How do I add custom format fields to an import format? (System Administrator)
By means of an import format, you can specify which data, or rather columns, from an import file are to be transferred, how these columns are named and delimited (separators), and into which database tables the import data are to be taken over.
Which columns you can choose from when adding an import format depends on the DB table that is linked to the format. As a system administrator, you can adapt, modify and extend this database table to add custom fields to the import format. To do so, please proceed as follows:
To transfer the imported data from a newly added column to the correct place within the system, a separate SQL function is required for each column following the pattern <ImportTableName>_<IMPORT_AFTER_ROW>_<somedesc>, e.g., I_Product_Import_After_Row_InterCheese(IN p_C_DataImport_ID numeric, IN p_recordId numeric,) for new columns in the import format for product data.
The activation of new columns is done by our developers. Just contact us and we will take care of it!