The Lucity GIS Data Loader is an ArcCatalog tool that has been provided to allow for mass data imports to the geodatabase. These imports are performed on a registered, versioned geodatabase. The source data can be a feature class or a shapefile. Before this tool is run, it is recommended that quality control checks be performed on the source feature class to ensure that IDs are properly assigned and features are not duplicated. A QA/QC tool has been provided with Lucity GIS.
The Lucity GIS Data Loader can perform the following functions:
Insert new features into the geodatabase and the desktop.
Update spatial information to existing features in the geodatabase.
Update attribute information to existing features in the geodatabase and the desktop.
To load data into the Lucity GIS geodatabase:
In the Catalog Tree of ArcCatalog, select the feature class into which you wish to import data.
Click on the Lucity GIS Data Loader tool located on the Lucity GIS toolbar.
To load the Lucity GIS toolbar, click View > Toolbars > Lucity GIS [version number].
The Lucity GIS geodatabase Feature Class Import dialog will appear similar to the one below.
For this example, the SWNETG feature class was selected. The name of the feature class that the data will be imported into is displayed on the left-hand side of the import form.
The first step on this form is to select the file (feature class, shapefile, or table) that you want to import. Click the "Browse" button and navigate to the file you wish to import. This will populate the available import fields in the lower left hand list.
The second step is to map the fields or the data that is to be imported. The green field is very important and should always be specified except where described below in the Notes section. This green field should be mapped to a unique value field in your import file that is used as the feature unique number or name.
To map the fields, drag the field from the "Available Fields in Import File" list box and drop them into the field grid. Or, you can type in the field names directly in the field grid.
If the field needs a constant value assigned, type the constant value directly into the grid. If the constant value is a string, place a single quote (') in front of the value to distinguish it from a field name.
To save this mapping for use later, click the "Save Field Mapping" button. You will be prompted to enter a name for the field mapping.
The saved mapping will not be displayed in the list until the next time this form is opened, but has been saved and will be available for future use.
The last step is to import the data. Press the Import button at the bottom of the screen. When this button is clicked a message will be displayed warning you to perform some data protection measures. If you choose "OK", the import will proceed. If you choose "Cancel", you will be returned to the data import form.
The first progress bar will describe the progress of the features inserting into the Lucity GIS geodatabase.
The second progress bar will describe the progress of the features synchronizing with the desktop Inventory system.
When the import is finished the dialogs are closed. To check and see which features were successfully imported into both the geodatabase and the desktop Inventory table, click the preview tab for the feature class you imported the data into, and select "table" view. A field in this table is called "In Lucity database". If this is true, the data was synchronized with the desktop. If the value is not true, then the data did not meet the desktop requirements for synchronization and will need to be modified in ArcMap to correct the problem. For more information on editing requirements, see Editing Requirements.
If you are using this tool to import pipes or any other feature class where a spatial relationship is attached, you will need to run the Update Spatial Relationships tool in ArcMap as the Data Loader doesn't run spatial data.
Notes: When the data is imported using this data loader, the program checks to see if a feature already exists in the geodatabase based on its feature number (this is the green field in the import screen). If the field already exists, it will update any populated fields with the fields from the import feature class, and will update the geometry to the geometry in the import feature class. If the program does not find a matching feature, the feature is appended to the geodatabase. This is why it is critical that the green fields are properly populated.
Note: Several options are available when using the Data Loader. These may be of use to you when importing data. For additional information, consult the Data Loader Options topic.
is an ArcCatalog tool that has been provided to allow for mass data imports to the geodatabase. These imports are performed on a registered, versioned geodatabase. The source data can be a feature class or a shapefile. Before this tool is run, it is recommended that quality control checks be performed on the source feature class to ensure that IDs are properly assigned and features are not duplicated. A QA/QC tool has been provided with Lucity GIS. 
