Assign Data Field
Assign Data Field
- Open the "Excel Import" dialog.
- Open an Excel data source. (see Open data sources)
- You have defined the Data structure. (see Use Import Groups for structuring data)
- Select an entry in the "FACTON fields" table along with the corresponding entry in the "Excel columns" list.
- Click to assign the highlighted entry from the "Excel columns" to the selected entry in the "FACTON fields" table.
- Alternatively, you can use the combobox in the FACTON fields to assign the Excel columns.
- Double-click on a suitable entry in the "Search Result" table.
- Repeat steps 1 and 2 until you have assigned all the required columns.
Alternative:
or
Note
You can remove incorrect assignments with the button or by pressing DEL.
Note
Some of the data fields in FACTON have predefined values. You can identify these fields by the funnel symbol next to them.
Assign columns from the Excel worksheet to the values. Double-click on the funnel symbol. The "Assign <object type>" dialog opens.