Headings for Import Files
|FIRST TOPIC BACK PREVIOUS TOPIC NEXT TOPIC|
eForms Standard & Enterprise Only
Column headings are used by the import function to identify the information in the column; the keyword "NULL" can be used as the heading of any column you wish the import to ignore. If data exceeds the maximum size of a field, an error message will be given and the import process will be halted. Where applicable, default data that will be used if a field is empty (or not represented in the import file) are listed in the Comments & Examples column in bold print. The various formats used are described below:
See Import from Excel File and Import from CSV File for sample import file layouts. Excel templates have been installed with eForms and can be accessed via the TOOLS > IMPORT / EXPORT DATA > OPEN EXCEL TEMPLATES menu.
Cell A1 (import from Excel) or the first data element (import from CSV) must contain a heading defining the type of data to import. The table below shows the appropriate heading for each from included with eForms (click on any form for detailed heading information):