Ivanti Automation powered by RES

Home 

Use parameter values from a CSV file

When scheduling a Job, the option Use parameter values from file makes it possible to input Text parameter and Password parameter values from a CSV file, instead of providing these values manually. This makes it possible to feed information into Tasks from a spreadsheet. The same CSV file can be used for several Tasks, so that one spreadsheet can provide many different Tasks with parameter values. This makes it possible to input parameter values in bulk into large numbers of Tasks.

If the values in a column in the CSV file do not correspond with the desired values for a specific parameter, you can select a different column of values for a specific parameter by right clicking the parameter, selecting Select input column and choosing the relevant column.

Ivanti Automation will execute the Module once for each row in the CSV file. So, if the CSV contains 400 rows of user information, then Ivanti Automation will execute the Module 400 times and so create all 400 users - while the administrator only had to schedule the Module once.

Extra option for Run Books

When scheduling Run Books, additional options are available to choose how the parameter values from the CSV file should be used:

  • Select Use on Task level to execute Tasks simultaneously. This is the fastest option. However, this results in more Tasks per Job. This means that if one Task fails, the entire Job fails.
  • Select Use on Job level to spread out the Tasks over more Jobs, which are executed in turn. This results in fewer Tasks per Job, and is the safer option: if one Job fails, Ivanti Automation will move on to the next Job. This option also provides more detailed information in the Job history.

The option Use parameter values from file makes it possible to use information obtained from third-party sources, such as change management systems. This is especially useful when scheduling Jobs unattended.

  • The option Use parameter values from file can only be used for Text parameters and Password parameters. Other types of parameters cannot be filled with values imported from a CSV file. However, because parameters can be embedded, the values of a list parameter can be a set of text parameters, and those text parameters can be filled from a CSV file.
  • Ivanti Automation only supports comma-separated CSV-files. Other formats, such as tab-separated or semi-colon separated are not supported.
  • Empty rows in the CSV file are skipped.
  • Use double quotes (") around parameter values that include comma's (such as the Active Directory paths used in the example above).
  • When using this option, parameter values will be replaced by actual values: any link actions no longer apply as a result of this.
  • In Run Books, it is not possible to use parameter values from a CSV file in conditions based on parameters whose values are based on other parameters.
  • When selecting the option Use Run Book parameter, it is not possible to use parameter values from a CSV file for this parameter.

Was this article useful?    

The topic was:

Inaccurate

Incomplete

Not what I expected

Other