Here you may find information about the import procedure.
The administrator can create a file with data and import it to the database. The importation can be done in CSV/Excel extension formats.
You need to define column names in the imported file in accordance with SmartJobBoard field IDs. For example, the 'Salary' field has ID=Salary, so you need to use Salary for the name of the corresponding column.
For the 'featured' system field, you need to set 'featured' in a column name (note all characters are in lower case).
For the 'pictures' system field, you need to 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://' (e.g. http://www.YourSite.com/files/pictures/picture.jpg) or relative URL from the root of your SmartJobBoard script (/files/pictures/picture.jpg). Picture URLs should be separated with ";" (semicolon).
In order to connect a listing with a user, you need to set 'username' (note all characters are lower case) in a column and to have this user registered in your SmartJobBoard 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 of the left administration menu.
The 'Import Listings' page will be opened. Fill out the 'System Import Values' and 'Data Import' forms with an appropriate data.
System Import Values
• 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);
Data Import
• File: – indicate a file to import;
• File type - choose file format
• Fields Delimiter: – for CSV-files choose a field delimiter here (Comma | Tabulator);
• Not found values in DB will be – ignored or added to DB (only for values of the List or Tree type).
After filling all the fields, click on the ‘Import’ button.