Product Documentation

Import from List

Mar 28, 2016

You can use a comma-separated values (.csv) file to define a list of applications to import into AppDNA. The file must have the following columns:

  • Filename — The name and path of the file to be imported. For Install Capture and Self-Provisioning, this must be expressed as a UNC path.
  • Silent switch — Use this column to specify a silent switch using the /s notation.
  • Execution profile — For Install Capture and Self-Provisioning, specify the execution profile to be used.
  • Group — Use this column to specify the group that the application is to be imported into. If the group is nested, use the RootGroup\ChildGroup\ChildGroup notation to specify the group.
  • AppID — Use this column to specify the application ID.
  • Application attributes — When you create an application attribute, AppDNA adds it to the template import file. Use these columns to provide the attribute data.
    • Imported dates must be in international date format (YYYY-MM-DD). Microsoft Excel defaults to the date format for the current locale, so be sure to check the format of date columns and change them if needed.
    • An imported list value is ignored if it does not match a list item defined for the attribute.
    • For a list type of RAG, the accepted values are Red, Amber, and Green. These values are not case-sensitive.
Tip: You can download a template import file from the Import an Application List dialog box. To open this dialog box, click Import from List on the toolbar in the Import Applications screen.

Non-English characters

If the file includes any characters that are not standard printable ASCII characters, the file must be saved with UTF-8 encoding.

Example

In the following example .csv file, the first row defines the columns, including the application attribute AppID. The second row specifies an .msi file to import into the General application group. The third row specifies an .exe file to import using a silent switch and the Snapshot execution profile into the General application group.

Filename,Silent Switch,Execution Profile,Group,AppID 
\\machine01\25appTest\Dreamweaver_MX_6.0_P1.1.msi,,,General 
\\machine171\AppDNAInput\burn4free_setup.exe,/s,Snapshot,General 

Import the applications specified in the file

  1. On the toolbar in the Import Applications screen, click Import from List.
  2. Specify the file.
  3. If you are importing application attributes, verify the Ignore attribute errors setting.

    Errors are incorrect data, missing data, or columns that cannot be matched. Choose whether to ignore errors for this import.

  4. Click Import. If you are on the Self-Provisioning tab, AppDNA lists all types of files found on the Self-Provisioning tab. If you are on the Direct Import or Install Capture tab, AppDNA lists .msi, .sft, and .appv files on the Direct Import tab, and all other file types on the Install Capture tab.
  5. Select the applications in the normal way and then click Import on the toolbar.
Note: You can also import web applications using an import list in the Import Web Applications screen.