FIELDS Tab:
With Add button it is possible to add strings into tabular part of this tab.
Columns in tabular part:
Excel Field - name of the Excel document column. It is displayed on the form of Import template data and in the Excel file -the document created based on the template, if user push Download option of the template form.
Local Field - The field of the object specified in the Object Type field on the Main Parameters tab. The list of available values is formed automatically (the system displays the list of fields available to the load for the selected object, adding additional fields in the user mode is not provided).
Comment - Commentary to the field. In this field user can describe the expected values or other recommendations for filling out. It is displayed in the standard field of the cell document.
Format - A link to an element of the Excel Import Formats directory that describes exactly how the Excel value should be translated. FirstBIT ERP will try to fill in this field by itself when filling in the Local Field, but you can change the result if necessary. If you leave the field empty, the field will not be broadcast automatically.
See more about fields format - 2.1 Fields Format .
Create Objects - Link to the Custom Handlers reference element, which contains a code necessary for automatically creating a new object. Here user needs to mark/unmark checkbox. If it is marked - system will check existing elements in Import object and if data from excel would be recognized as new (means in the system element with this data does not exist) - system will create new element.
Is Key - The purpose of the field is to identify fields that determine the unique object. Instead of a title, this props is displayed by the key image. The requisite becomes affordable if the IMPORT TYPE requisite on the Main Parameters tab has selected the Import to Objects value, and the object’s requisite is selected as Local Field (there is no suitable for the tabular part).
Is this field requierd to be filled? column - here user may mark checkboxes in strings with fields which is mandatory should be filled with Import from excel file.
Thank you for being a FirstBIT customer!