Access Quick Import inside of the application record where you want the external data. Open the form action menu and select Import Data to open the Quick Import window and download the CSV template.
Fill out the CSV template then open the Quick Import window and either:
- Browse and select your saved CSV template, and then select Import.
- Copy the data from the template directly to your clipboard, and select Import From Clipboard.
The data from your file is brought in as detail lines that you can edit in the application.
If your import times out
A quick import has an enforced time limit. If your import takes longer, it stops and none of the rows are kept. The message tells you how many rows were processed before the limit. Break your file into batches of that size or smaller, and import each batch separately.
CSV template considerations
Column names in your CSV template use the internal name, also called a data item name, of the fields in the application. To view the internal name of a field, open the help text for that field and hover over the first value on the bottom of the window.
Search fields, also called table lookup fields, reference information that is maintained in other applications. A search field can point at a single field, or multiple fields, within the other application. If the search field references multiple fields, you may see multiple columns for the same data item name. For example, Organizational Unit may reference both the Name and Numeric Code fields. This would allow you to have unique values for org units with the same name, but different numeric codes.
Column headers in the CSV template have the following formats:
| Field Type | Template Column Header Format | Example | Explanation |
|---|---|---|---|
| Traditional field | [Field Name]Data Item Name | [Units] UnitAmount |
|
| Required fields—Indicates you must enter a value or the import fails. | [Required][Field Name]Data Item Name | [Required] [Line] GLLineNumber |
|
| Search fields—Also called Table lookup fields. | [Field Name]Data Item Name_Related Field | [GL Account] GLAccount_AccountNumber [Account Name] GLAccount_AccountName |
|
| Composite fields—Fields made up of multiple components, such as address or currency fields. | [Field Name]Data Item Name_Composite Component | [Debit Amount] TransactionDebitAmount_CurrencyCode [Debit Amount] TransactionDebitAmount_CurrencyBigDecimalValue [Debit Amount] TransactionDebitAmount_CurrencyDecimals |
|
Example CSV Format
Example of filling out the CSV Template:
| [Required] [Line] GLLineNumber | [GL Account] GLAccount_AccountNumber | [Account Name] GLAccount_AccountName | [Debit Amount] TransactionDebitAmount_CurrencyCode | [Debit Amount] TransactionDebitAmount_CurrencyBigDecimalValue | [Debit Amount] TransactionDebitAmount_CurrencyDecimals | [Units] UnitAmount |
|---|---|---|---|---|---|---|
| 1 | 13100 | Raw Inventory | USD | 12100 | 2 |
Some CSV templates have columns that do not match any visible fields on the application. These columns can be optional or mandatory, depending on the application.