Custom Properties Import from CSV/FTPS
The Custom Properties Import from CSV/FTPS allows custom properties data to be automatically imported to Quant from a FTPS server.
1. Preparing the file for import
First of all the Excel file with store data has to be created. The file must contain the ID, name and type of each attribute. Once ready, the file must be exported and saved as a CSV file.
Custom Properties Import
2. Uploading a file to FTPS server
Upload the file you want to import into the appropriate folder, e.g. Import_Custom_Properties on FTPS.
For more information, see the manual CSV/FTPS Úvod a přihlášení.
3. Automatic Task Settings
In the Automatic Tasks section, create a new Import Custom Properties from CSV.
Custom Properties Import
Before launching the import, you must edit the following attributes in the Settings tab:
- Check the Enabled attribute to enable the task.
- In the Custom Property for Import row, select the entity for which the optional property is to be created.
- In the Custom Property Type Mapping row, select the relevant custom property type attribute – such as single-line text, decimal number or date – for each type that you want to import.
- Fill in the Address (Primary Server) line with "ftp.extech.eu", your Username (Primary Server) and Password (Primary Server) for the FTPS server.
- Fill in the Server Path (Primary Server) line with the name of the folder where you have the imported file stored on your FTP.
- We also recommend filling in the Emails for Notifications field, where you can enter one or more email addresses to which error notifications will be sent.
- In CSV Importable Custom Property Attribute Mapping- assign the relevant Quant attribute to each column that you want to import.
Attributes
Below is a list of other attributes that you can set as part of an automatic task:
Attribute | Description | Type |
Enabled | Specifies whether the automatic task is active and data can be sent through it. | yes/no |
Title | Custom name of the automatic task. | text |
Description | Custom description of the automatic task function. | formatted text |
Frequency | Specifies when to import the files from FTPS. | time |
Notes | Notes | text |
Email for Notifications | One or more email addresses to which emails with error conditions will be sent. | list of strings |
Custom Property for Import | This specifies the entity for which the custom property is to be created e.g. a product. When mapping custom properties in CSV, assign the relevant Quant attribute to each column that you want to import. | selection |
Custom Property Type Mapping | This is an attribute of the custom properties type, which is used to map individual types of custom property, such as a decimal number, a date, or a single line of text. | complex type |
File Extensions | Write all possible extensions that the imported file can contain. | list of strings |
Filename Pattern | The files to be imported are filter from all the files in the destination directory based on the specified expression. If there is only one file in the destination directory, it is not neccessary to specify the file name format. | text |
Extract Zips | Check if you have uploaded a zipped file. | yes/no |
Warn if no Files for Import Since | If no data has been imported since the specified date, you will receive a notification. | date selection |
Empty Values Strings | Enter here the values from the imported file to be ignored, or treated as empty strings. | list of strings |
Launch Another Task after Completion | Choose any automated task that you would like to run once this task has finished. | selection |
When to Launch Another Task | Select when the next task should run here, for example after each completion. | selection |
Primary Server Host | By default "ftp.extech.eu", unless you use your own server. | text |
Primary Server Port | Standard 21. | text |
Primary Server User Name | Your username in FTPS server. | text |
Primary Server Password | Your password in FTPS server. | text |
Primary Server FTP Client Type | Choose the FTP client type. | selection |
Primary Server Implicit SSL | Select if you want to use default SSL. If you do not check the box, explicit SSL for FTPS will be used. | yes/no |
Primary Server Plane FTP | Select if you want to use an unsecured FTP protocol. | yes/no |
Primary Server Keep Source Files Untouched | Select if you want the file to remain on FTPS after import. | yes/no |
Primary Server Path | Write the name of the folder in which the file is located. For example Import_Custom_Properties. | text |
Character Set | Select the character set of your CSV file. | selection |
Header Line Count | Write the number of the lines with header. | number |
Decimal Point | Select the sign for the decimal point used in your CSV file. | selection |
String Value for TRUE | Write what value in the file represents "TRUE" e.g. 1. | text |
Measure Unit | Measure unit such as cm, mm etc. | selection |
Date Format | Date entry format, eg 31.12.23. | selection |
List Item Separator | Select the list item separator which is used in your CSV file. | selection |
Escaping | Check if you use escaping in the file. | yes/no |
Escapovací znak | Vyberte, jaký používáte escapovací znak. | znak |
Ignore Escape Character | Check if the escaping character is to be ignored. | yes/no |
Empty Value Strings | Enter the values from the imported file here that should be ignored or treated as empty strings. | list of strings |
Max Escaped Newline Count | Enter the maximum number of new lines. | number |
CSV Importable Custom Property Mapping | Assign the appropriate Quant attribute to all columns you want to import. | list of attributes |
4. Launching the Automatic Task
Once you have set all the necessary attributes, you can import products immediately via the Launch button. Or wait until the products are imported automatically based on the set Frequency. If the automatic task is complete, a message will appear in the upper right corner indicating the successful import. In the Products section, you can check if the custom properties have been correctly created or modified.
If the import has not succeeded, in the Latest Logs you will find more details about why did the import fail.
5. Latest Logs
The Latest Logs tab provides an overview of every automated task run, including statistics, errors and warnings.
You can view the details of a specific row by selecting it and clicking the Show Items button.
If a task ends with an error or a warning, you can use the Show Errors and Show Warnings buttons to read the specific error or warning message.