Importing data using import sets

To import data define a data source and transform map, and run or schedule an import.

Create a data source record to define what data an import set should import. - Data source fields
In addition to common fields, other fields appear on the data source form, depending on the value of the Type field. - Create a transform map
Every import operation to a production table requires at least one transform map associated with an import set. - Mapping options
You can map fields in a number of ways depending on the circumstances of the import and whether data must be transformed prior to loading onto a production table. - Create a field map
Field maps establish a relationship between a field in an import set table and a field in the target table. - Field map script variables
Several predefined variables are available in the Source script field. - Run an import
You can manually run an import to immediately import data. - Importing date/time values
Considerations when importing data containing date/time values. - Review the import set
After an import set completes, you can review the completed import and clean up import set tables. Even if no errors are reported by the progress indicator, review how your data is imported into the new import set. - Viewing the import log
The import log is where you can find information about the internal processing that occurs during an import operation. - Import run history
The import history gives status information about individual import operations. - Schedule a data import
Schedule imports to make it possible to specify that certain import operations occur at a regular interval. - Monitor scheduled data import executions
Monitor scheduled data import executions to see the hierarchy and flow of the scheduled chained imports. - Monitor concurrent import sets
Monitor concurrent import sets to check the status of import sets and import set jobs, resume or reprocess import sets, and view transform history. - Monitor concurrent import set jobs
Check the status of concurrent import set jobs. - Post CSV or Excel files directly to an import set
An administrator can post CSV or Excel files directly to instance. - Delete import sets
Delete import sets to clean up your database on a scheduled basis, one time only, or on demand. - Delete import set tables
Delete import set tables, related transform maps, or data only (preserving the table structure) to clean up your database.

Parent Topic:Import sets