Import 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:
- In Applications
- On the View Data page, select a table from the drop-down list. The names of the columns in the table are displayed.
- Click Import CSV. The Import Data page is displayed.
- On the Import Data page, click Select File.
- In the browser's Open dialog box, select the CSV file you want to import and then click Open.
- On the Import Data page, review the displayed data for accuracy.
- Review and resolve any issues displayed under Warnings.
- Click Commit. A message is displayed confirming the rows have been committed.
- Click Back to View Data to search or edit data. For more information, see View Data in a Cross Reference Table.