CSV Import Tool enables a user to import bulk data into a specific form's table by retrieving the CSV file from a form field and doing a simple column-to-field mapping.
Figure 1: CSV Import Tool Properties
| Name | Description | ||||||
|---|---|---|---|---|---|---|---|
| File Upload Form | Specify the source Form where File Upload element resides. | ||||||
| Upload Field ID | File Upload element ID in the specified form above. | ||||||
| Store Data Form | Specify on where to store the data by choosing a target form. How storing works? The target form's store binder will be called upon for data storage. | ||||||
| Column Mappings | Map the source file's CSV values to the target form fields.
| ||||||
| Key Column Number | Column number that holds the primary key value. If nothing is defined, a UUID will be assigned when importing. | ||||||
| Start From Row Number | Row number to start importing data. Integer only, starts from 1. | ||||||
| Foreign Keys | Define other values that can not be found in the CSV file such as Foreign Key value associations data. You may also define hard-coded value here too.
|