Import Requirements

  • Data must be tab-delimited text data
  • Each field listed in the Import Data Specification must be included in the Data Import, in the order specified
  • Fields cannot contain carriage returns or tab characters
  • Data Types must match the specified Data Type for each field
    • i.e. you can't specify a string value when a number is expected
  • Row 1 of the Data Import must contain the list of Field Names (unless using an Import Header Command)
  • One record per row
  • If a Related Table is specified, then corresponding records must be present in the specified related table before importing data

Available Types of Import Data

The Import Data Into Datawarehouse function provides import capabilities into a number of tables within iSite.  A list of those tables are as follows:

Page ID:1703-4417-9563