in v5... each mapping is equal to a input name
if the field is in subform, then the field id need to prefix with the id of subform lah
this allow u to import to several tables based on the form binder in the form
tht y i told u ..u can even import user.. or using bean shell for import
becoz the import is handle by the form binder
the validation is handle by form as well
account_id is the field id
account_crm is the subform id
it is follow the form input name
when u check the input field in ur subform using firebug.. u can see this
| 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.
|