Here you may find information about the import procedure.
The import can be done in CSV/Excel extension formats.
The administrator can create a file with data and import it to the database:
| • | Define column names in the file to be imported in accordance with iLister field IDs, except for fields of the 'Tree' type (MakeModel). |
| • | For example, the 'Price' field has ID=Price, so use Price for the name of the corresponding column. |
| • | For the 'featured' system field, set 'featured' in a column name (note all characters are lower case). |
| • | For the 'pictures' system field, set 'pictures' in a column name (note all characters are lower case). The 'pictures' column should contain either full URL of a picture with 'http://' (http://www.YourSite.com/files/pictures/picture.jpg) or relative URL from the temp/import/ directory of your iLister script (pictures/picture.jpg). Picture URLs should be separated with ";" (semicolon). |
| • | The Tree type (as the 'MakeModel' field) should be defined as follows: in two columns, first is 'MakeModel[1]' - it is for the 1st level (Make), second is 'MakeModel[2]' - it is for the 2nd level (Model). |
| • | To connect a listing with a user, set 'username' (note all characters are lower case) in a column. The user should be registered in your iLister system. |
There is an example of the imported file in Excel extension format on the picture:
To import listings through the administration panel, click the ‘Import Listings’ link in the ‘Listing Management’ section on the left administration menu. Fill out the 'System Import Values' form with the appropriate data:
| • | Type – choose a necessary listing type from the drop down menu. Imported listings will belong to the chosen type; |
| • | Package – choose a necessary package from the drop down menu. Imported listings will belong to the chosen package; |
| • | Active status – this flag means that the imported listings will be activated after importation; |
| • | Activation date – the date of activation (the current date by default); |
Fill out the 'Data Import' form:
| • | File – indicate a file to import. A file can have the following extensions: |
| • | csv (Comma-separated values), |
| • | zip (zip archive), containing an .csv or an .xls file in the root of the archive, |
| • | tar.gz (tar gzip archive), containing an .csv or an .xls file in the root of the archive. |
| • | File Type - choose the type of file to import. The type can be either with .csv or .xls extension. |
| • | Fields Delimiter: – for CSV-files choose a field delimiter here (Comma | Tabulator | Semicolon); |
| • | Not found values in DB will be – ignored or added to DB (only for values of the List or Tree type). |
When importing an archive file, pictures should be in the root of archive in the pictures/ directory.
When importing an .csv or .xls file, pictures should be copied to the temp/import/pictures/ directory in the root of your iLister script.
After filling all the fields, click the ‘Import’ button.
Also the following articles can be helpful for you:
How to import listings with pictures
How to import texts with special symbols
|