Lucity Data Loader

The Lucity Data Loader allows users to perform a mass data import and/or update to the geodatabase. This tool will import features into both a Lucity linked feature class and the corresponding Lucity table at the same time. It can also be used on existing features to update spatial and attribute data. The Lucity GIS Data Loader can perform the following functions:

• Insert new features into the geodatabase and Lucity database.
• Update spatial information for existing features in the geodatabase
• Update attribute information for existing features in the geodatabase and Lucity database.

How To

To load data into a Lucity linked feature class:

1. In ArcMap, start an edit session.
2. Click on the Lucity Data Loader tool on the Lucity GIS Edit toolbar. The Lucity Data Loader form will appear:

   

3. Select the destination feature class from the drop down list. Only editable feature classes that are linked to Lucity will be listed.

   

4. Select the source data. Use the browse button to navigate to the location of the source data. The source data can be a feature class or shapefile.

   

5. Select a saved field mapping (Optional). If this is a routine import in which users previously saved the field mapping they can select the mapping from the list to automatically load the saved settings.

   

6. Enter a filter syntax (Optional). If users wish to limit the records that are imported from the source file they can specify the select filter criteria in the text box.

   Note: Only include the syntax that follows the "SELECT * FROM <tablename> WHERE". For example: MODEL = 'FORD'

7. Using the grid on the right, map the source fields to the destination fields.
   • Use the Field Lookup button for a list of fields from the source data.
   • If a field needs a constant value assigned, type the constant value directly into the grid with a leading "=". For example, if a field should be updated so all record have the value "Hank" enter "=Hank".

   

8. Finally, specify any additional options:
   • Save Field Mapping- Check this box to save the field mapping. The next time the Lucity Data Loader tool is used on that feature class the saved mapping will be available.
   • Allow features without IDs to be imported- This special option for importing data allows data to be imported without IDs.  This is available so that data can be brought into the geodatabase without an ID and later the IDs can be entered directly into the geodatabase itself.  An example of this would be if a series of meters were GPS in the field, but not numbered, they could be imported into the geodatabase and numbered within the geodatabase.  If you choose to import data without IDs it is critical that the data is only imported once, otherwise the data will continually append itself to the geodatabase.*
   • Do not import null/empty string attribute data- If a field in the source record contains a null/empty string value the value will not be sent to the destination record in the feature class or Lucity database. This is especially important when using the Lucity Data Loader to update existing features.
   • Do not overwrite a non-null value with null/empty string- If using the Lucity Data Loader to update an existing feature this will prevent existing information from being overwritten with null/empty string data.
9. Click Import to begin the import process. The import will automatically save your edit session after performing the import. Click Yes, on the following dialog to start the import process.

   * Note: - During the Import process any Spatial Relationships and Number Generators that are setup will automatically be run.

   

10. The progress of the import will be displayed in the lower right-hand corner of the ArcMap window. Once complete a dialog similar to the following will be displayed to indicate the results of the import.