| Note |
|---|
| Note: The Insert Like command creates a new import configuration and copies fields from both the Imports and Import Detail tabs. |
...
- When the Exit on Exception check box is selected, then the system will stop the import process when the number of exceptions entered in the Exception Limit field is reach (or the first exception if this field is left blank).
Regardless of the setting of the Exit on Exception check box, the Commit Interval field determines when records are committed to the database based on the number of records processed. For example, if this field is set to 1000, then after the 1,000th record is processed the system will commit the last 1,000 records to the database.
Note Note: Once records are committed to the database, an exception will not cause those records to be restored to the condition they were in before the import process began. - If the Auto. Split Partially Subord. Sections check box is selected, then the system will split the data that crosses a concurrency (subordinate) boundary. (This check box only has an effect for purely location-based data.) If this check box is not selected, then an error will result when the system attempts to enter data that crosses a concurrency boundary.
- If the Save Errors Only check box is selected, then the system will save the text describing exceptions to a log file.
The fields that are displayed in the right pane are dependent on the selected Source Type. The following table lists the different types of sources from which data may be imported and the fields that become available when you select a particular source type. Following the table is a description of the different fields that may appear in the right pane.
Note Note: For the Database Table and SQL Server Table source types, the data source is defined in the Data Source Connection window. If this window contains more than one source, the system will display a dialog box so you may select the desired source.
Source Type | Select Source | Data Source Where Clause | Import Method | Where Clause | After Each Import Script | After All Import Scripts | Has Header |
|---|---|---|---|---|---|---|---|
Access file | x | x | x |
| x | x |
|
Comma separated | x |
| x |
| x | x | x |
Database table | x | x | x |
| x | x |
|
Dbf file | x |
| x |
| x | x |
|
Excel file | x |
| x |
| x | x | x |
Fixed length | x |
| x |
| x | x | x |
SQL server table | x | x | x | x | x | x |
|
Shape file | x |
| x |
| x | x |
|
The fields are described below:
...