<div class="content">
    <span style="font-weight: bold">Instructions for Use:</span>
    <br>
    <br>Data from the listings is written in the *.csv file encoded in UTF-8 without BOM. No HTML special characters.
    <br>
    <br>While doing the reverse operation (import), the file shuld be loaded in the same encoding.
    <br>Before importing make sure that the database contains the names of cities and references.
    <br>
    <br>For paid versions the names of city and references ("Security", "Comfort", "Kitchen", "Bathroom", "Work",
    "Entertainment", "Services", "On conditions") are taken in the language by default. It means that if a languafe is
    "en" by default, and the name in the csv file is written in the Russian language (e.g."Москва"), you should correct
    it according to the language "en" name ("Moscow").
    <br>
    <br>In the OpenOffice Calc you can open and save files in UTF-8 without BOM.
    <br>
    <br><span style="font-weight: bold">The exporting fields:</span>
    <br>
    <br>
    <ul><span style="font-weight: bold">type</span> - Type of transaction. A numerical value. Possible values can be:
        '1' — Rent property to smb, '2' - Sell, '3' — Rent property from smb, '4' - Buy, '5' - Exchange;
        <br>
        <br><span style="font-weight: bold">priceType</span> - Price type. A numerical value.
        <br> Possible values can be:
        <br> For type "Rent property to smb": '1' — USD per month, '2' — USD per hour, '3' — USD per day, '4' — USD per
        week;
        <br> For type "Sell": '5 '- USD Sale;
        <br> For type "Rent property from smb": '6';
        <br> For type "Buy": '7';
        <br> For type "Exchange": '8';
        <br>
        <br><span style="font-weight: bold">objType</span> - Property type. A numerical value. Data from the table
        '{prefix} apartment_obj_type'. Ppossible values can be 1 - Apartment, 2 - House, 3 - Commercial real estate;
        <br>
        <br><span style="font-weight: bold">cityName</span> - City name. A string value. Data from the table
        '{prefix}apartment_city'. A possible value can be 'Moscow';
        <br>
        <br><span style="font-weight: bold">isPricePoa</span> - Price on asking. Possible values can be '1' - yes, '0' -
        no;
        <br>
        <br><span style="font-weight: bold">price</span> - Price. A numerical value, for instance '3000';
        <br>
        <br><span style="font-weight: bold">priceTo</span> - Price "Up to". It is used for property types "Rent property
        form smb" and "Buy". Do not fill in the field for other property types;
        <br>
        <br><span style="font-weight: bold">numberRooms</span> - Number of rooms. A numerical value. The maximum value
        is set in the Settings by the administrator. A possible value can be '2';
        <br>
        <br><span style="font-weight: bold">floor </span> - Floor. A numerical value. A possible value can be '5';
        <br>
        <br><span style="font-weight: bold">floorTotal</span> - Total number of floors. A numerical value. The maximum
        value is set in the Settings by the administrator. A possible value can be '10'.
        <br>
        <br><span style="font-weight: bold">square</span> - Square. A numerical value. A possible value can be '52';
        <br>
        <br><span style="font-weight: bold">sleeps</span> - Number of berths. A string value or a numerical value. A
        possible value can be '1+2+1';
        <br>
        <br><span style="font-weight: bold">title</span> - Listing title. A string value. A possible value can be
        "Apartment near Novokuznetskaya metro station, Runovsky Lane, 3B";
        <br> Add a prefix of the language 'title_en', 'title_ru', 'title_de', if you use a paid version. You should fill
        in each field.
        <br>
        <br><span style="font-weight: bold">description</span> - Description. A string value. A possible value can be
        "Spacious and comfortable apartment";
        <br> Add a prefix of the language 'title_en', 'title_ru', 'title_de', if you use a paid version. You should fill
        in each field.
        <br>
        <br><span style="font-weight: bold">near</span> - What is near. A string value. A possible value can be
        "Novokuznetskaya metro station";
        <br> Add a prefix of the language 'title_en', 'title_ru', 'title_de', if you use a paid version. You should fill
        in each field.
        <br>
        <br><span style="font-weight: bold">location</span> - Address. A string value. A possible value can be "Runovsky
        Lane, 3B";
        <br> Add a prefix of the language 'title_en', 'title_ru', 'title_de', if you use a paid version. You should fill
        in each field.
        <br>
        <br><span style="font-weight: bold">exchange</span> - Change for. A string value. A possible value can be
        "Apartment with the same price";
        <br> It is necessary for listings' type "Exchange"
        <br> Add a prefix of the language 'title_en', 'title_ru', 'title_de', if you use a paid version. You should fill
        in each field.
        <br>
        <br><span style="font-weight: bold">bathroom</span> - Reference "Bathroom". The enumeration of string values
        separated with a vertical line "|";
        <br>
        <br><span style="font-weight: bold">safety</span> - Reference "Security". The enumeration of string values
        separated with a vertical line "|";
        <br>
        <br><span style="font-weight: bold">comfort</span> - Reference "Comfort". The enumeration of string values
        separated with a vertical line "|";
        <br>
        <br><span style="font-weight: bold">kitchen</span> - Reference "Kitchen". The enumeration of string values
        separated with a vertical line "|";
        <br>
        <br><span style="font-weight: bold">employment</span> - Reference "Work". The enumeration of string values
        separated with a vertical line "|";
        <br>
        <br><span style="font-weight: bold">entertainment</span> - Reference "Entertainment". The enumeration of string
        values separated with a vertical line "|";
        <br>
        <br><span style="font-weight: bold">services</span> - Reference "Services". The enumeration of string values
        separated with a vertical line "|";
        <br>
        <br><span style="font-weight: bold">terms</span> - Reference "On conditions". The enumeration of string values
        separated with a vertical line "|";
        <br>
        <br><span style="font-weight: bold">photos</span> - Photos. The enumeration of string values separated with a
        vertical line "|";
        <br>
        <br><span style="font-weight: bold">lat</span> - Latitude. A numerical value. A possible value can be
        '55.7300745' (use a "point");
        <br>
        <br><span style="font-weight: bold">lng</span> - Longitude. A numerical value. A possible value can be
        '37.6336848' (use a "point");
        <br>
        <br>
    </ul>
    <br>Separate the elements with a semicolon ";".
    <br>
    <br>The values that are related to the same element (section) should be separated with a vertical line "|".
    <br>
    <br>===============================================================================================================================
    <br>
    <br>You can create a new csv file yourself in the OpenOffice Calc or make it using the exported from the product
    file as a basis.
    <br>
    <br>The number of listings for importing into one file should not exceed 40-50 ones, it depends on the number of
    images (the more images, the less number of importing listings should be).
    <br>If the number exceeds the recommended one, the script can not have enough time (which is set at server settings)
    to complete the operation of importing.
    <br>
    <br>If you instead of importing a zip file with attached images place links to the images in the "photos" field, the
    script will try to download these images remotely and save them at your server with the help of 'cURL' or
    'file_get_contents'. Note that this operation requires more time than it is needed to extract images out of a zip
    file.
    <br>
    <br>While importing references' values ("Bathroom", "Kitchen", "Security" etc.) as well as city name it is strictly
    recommended to follow whatever upper- and low-cases of their names that you use to define them and make sure that
    the names are correct and are the same as your site contains.
</div>