To set up your catalogue quickly, you can import a CSV file with all your filters in a table.
You can create CSV fields in EXCEL and just save the file as CSV instead of XLSX.
Download Sample Filters File
The following is a sample file for importing new filters:
Click here to Download Sample Filters CSV File
The standard Filter Fields
When importing new filters, the following are the standard fields.
UniqueCode |
MAX 50 chars |
The UniqueCode for the filter This must be unique and must contain only characters a-z and all lower case |
Title |
MAX 100 chars |
The title of the filter |
ParentUniqueCode |
MAX 50 chars |
Set this to be the filter groups UniqueCode |
SortOrder |
Number |
Optional: This is set automatically to 0 (zero) but you can override it here |
Additional Fields
The following are additional optional fields that can also be included:
Active |
True or False |
This is set automatically to TRUE but you can override it here |
ActiveFrom
ActiveUntil |
Date |
Use date format "1 Jan 2020" OR "1 Jan 2020 14:30" if you want to use time as well |
ExternalCode |
Max 50 Chars |
Optional: If you would like to give this an external code (used for integrations with external systems), enter it here |
How to Import the File:
- Log in as web admin and click Catalogue - Bulk Imports
- Click Import Filters
- Browse to the file and click Upload
- It will then tell you if the file was uploaded successfully and how many records were imported and then inserted/updated - as well as how many errors/warnings were found. If there are errors/warnings, they will be listed down the page
Comments
0 comments
Please sign in to leave a comment.