|
Import of Lookups
Configuring a lookup import involves defining what needs to be imported, where it needs to go and how frequently this needs to occur. The following sections describe the process in detail.
|
Prerequisites
You must have the Policy: Maintain Events/Imports/System Settings assigned to your Role to:
- configure imports
- manually initiate imports
|
To configure a Lookup Import
- From the menu, select Designer
 Configuration Management Lookup Import. - Click New. A new Lookup Import Configuration record opens.
- Complete the fields according to the descriptions in the table.
Field
|
Description
|
Notes
|
Import Name
|
The name given to the import by the Designer.
|
Should be unique. This is necessary if you wish to initiate an import manually.
Note: may not contain colons (:)
|
Lookup
|
Allows user to select into which lookup the items shall be imported.
|
|
Import Time
|
The start time at which the import will start.
|
Format hh:mm (24hr). If an Import Time is specified, then the import will run at this time every day, seven (7) days a week.
|
Polling Interval (mins)
|
Determines the intervals (in minutes) at which the import will start.
|
If this field is populated the 'Import Time' should be left blank. This setting can be used if the required frequency of the import is greater, or less than, once every 24 hours.
|
Type of Import
|
CSV File
|
Select CSV File for User, Attachment or Lookup imports.
|
Import to run on completion
|
Any import selected here will be run directly after the current import has completed successfully.
|
This feature allows users to 'chain' two or more imports, which need to run in a particular sequence, for example 'Persons' and 'Users'.
Note: if one of the imports in a chain fails, any subsequent imports will not be run.
'Chained' imports can only be run from the server and not from a local file (i.e. 'select file now').
|
- When you have completed this section, click Save.
- Complete the relevant CSV.
- Click Save. The import can now be run at the scheduled times.
To perform a Lookup Import
Following is a step by step Instruction for importing Lookups through the Web Application:
- From the menu, select Designer Imports Lookup Import Configuration.
- Create a new import.
- Type of import is CSV, and select the lookup to which you want to add the lookup items.
- Save the settings.
- You will get a CSV file section open up, where you need to define the directory location where you will place the import file.
Note: the Tomcat account must have access to this folder. - Trigger the import via Admin Import Trigger.
- At this stage, nothing will be imported, but new folders will be created as defined in the above step.
- Move the CSV to the "...\importfiles" folder.
Note: all CSV files in this folder will be imported into the lookup, so make sure it's only the one you want to import. - Trigger the import again via Admin Import Trigger.
- The lookups will now import.
- No publish is required, the new lookup items will appear in the Web Application within 30 seconds.
|
