ApplicationsImport Data to a Cross Reference Table

You can add columns and data to a cross reference table by importing data from a comma-delimited text file (CSV) file. Before you import, review the following information:

  • To prevent your system from becoming unresponsive, do not import more than 5,000 rows in a single CSV file.
  • The cross reference table must already exist in Loftware Enterprise SP. For more information, see Create a Cross Reference Table.
  • The names of the columns in the file to be imported must match the names of the columns in the existing table in Loftware Enterprise SP.
  • The type of data in the columns (String, Number, or Date/Time) in the file to be imported must match the data type of the columns in the existing table in Loftware Enterprise SP.
  • Data that is imported without an ID number is inserted as a new row and assigned an ID.
  • Data that is imported with a unique assigned ID number is inserted as a new row with the ID provided.
  • Data that is imported with an existing ID number overwrites the previous data in the existing row.

To import data to a cross reference table, perform the following steps:

  1. In Applications , open the Cross Reference Table App folder and select the XrefUserApplication.
  2. On the View Data page, select a table from the drop-down list. The names of the columns in the table are displayed.
  3. Click Import CSV. The Import Data page is displayed.
  4. On the Import Data page, click Select File.
  5. In the browser's Open dialog box, select the CSV file you want to import and then click Open.
  6. On the Import Data page, review the displayed data for accuracy.
  7. Review and resolve any issues displayed under Warnings.
  8. Click Commit. A message is displayed confirming the rows have been committed.
  9. Click Back to View Data to search or edit data. For more information, see View Data in a Cross Reference Table.