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 iRealty field IDs, excepting fields of the 'Tree' type . For example, the 'Price' field has ID=Price, so you need to use Price 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 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://' (http://www.YourSite.com/files/pictures/picture.jpg) or relative URL from the root of your iRealty script (/files/pictures/picture.jpg). Picture URLs should be separated with ";" (semicolon).
The Tree type (e.g. 'TreeTypeField') should be defined as follows: in two columns, first is 'TreeTypeField[1]' - it is for the 1st level, second is 'TreeTypeField[2]' - it is for the 2nd level.
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 iRealty 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 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); |
| • | File: – indicate a file to import; |
| • | 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 the button ‘Import’.