How Tos

1. Open the tool and click to create a new configuration
2. Enter the Import Name.
3. General Tab
   • Select which part of the Lucity program the records will be imported to.
   • Enter a Output Directory for any bad records.
   • On the right side of the tab select which options will be active for the import.
4. Data Source Tab
   • Use the fields to select an configure the data source
5. Mapping Tab
   • Map the import data's fields to Lucity's fields.
6. Correlations Tab
   • If you are mapping text fields into codes, or have any other data that needs to be converted during the import create correlations.
7. Email Tab
   • Fill out the information on this tab if you want to send out an email notification when the import is complete.
8. Click to save the configuration.

1. Open the tool and click to create a new configuration
2. Enter the Import Name.
3. General Tab
   • Select which part of the Lucity program the records will be imported to.
   • Enter a Output Directory for any bad records.
   • On the right side of the tab select which options will be active for the import.
4. Data Source Tab
   • Use the fields to select an configure the data source
5. Mapping Tab
   • Map the import data's fields to Lucity's fields.
6. Correlations Tab
   • If you are mapping text fields into codes, or have any other data that needs to be converted during the import create correlations.
7. Email Tab
   • Fill out the information on this tab if you want to send out an email notification when the import is complete.
8. Click to save the configuration.

1. Open the tool and click to create a new configuration
2. Enter the Import Name.
3. General Tab
   • Select which part of the Lucity program the records will be imported to.
   • Enter a Output Directory for any bad records.
   • On the right side of the tab select which options will be active for the import.
   • Come up with a Group Name. This will be used on all other configurations in the group import.
   • Enter the Group Order. This is a number that tells the import program what order to run the different configurations in during a group import.
4. Data Source Tab
   • Use the fields to select and configure the data source
5. Mapping Tab
   • Map the import data's fields to Lucity's fields.
6. Correlations Tab
   • If you are mapping text fields into codes, or have any other data that needs to be converted during the import, create correlations.
7. Email Tab
   • Fill out the information on this tab if you want to send out an email notification when the import is complete.
8. Click to save the configuration.
9. Repeat Steps 1-8 to create configurations for every other part of the group import.
   • On the General Tab the Group Name must be the same for all configurations.
   • The Group Order must be different for each part of the group import.

1. Navigate the configuration record.
2. Click the drop down arrow on the button and select Group Import.
3. The import process will begin and the following progress bar will appear.

   

4. Depending on settings, if there are no records that fail to import the program will import everything and be done.
5. If there are records that fail to import the following screen will appear:

   

6. If there are simple issues with the data it can be fixed directly in this grid. After fixing the data click Retry.
7. Click Continue to import the records and continue to the next step in the group import.

The Import can also be run as part of a command line or script.

To do this you should use the following syntax and parameters when running the import:

Lucity.ImportAndUpdate.exe [/S]{/P][Path][/L][Configuration][/C][Client][/G]

Example: C:\Program Files\bin\Lucity.ImportAndUpdate.exe /S /L /Hydrants /C /Production