putRates CSV

CSV file
semicolon seperators
save rates
Click submit once only or you may import duplicates. Modified values are shown bold.


1. Create a CSV file in the correct format.

You can get the file format by first downloading your rates using getratescsv.

Data has to be entered exactly in the required format and position otherwise the import can not work or will import false data.

The first row must contain the header for each colum to identify the contents of that column. Each following row contains one rate. The minimum information required is a roomid number for each rate. The file must be CSV format and use commas or semicolons to separate the data fields.

Set the rate ID to an existing rate to modify it or leave blank to import as a new rate.

Not all columns can be imported, the preview will show the information that can be imported.

3. Preview import.

Upload the file WITHOUT ticking the "Save Changes" checkbox. A report will be shown of the information read from the file. If the preview shows errors fix them in your CSV file and preview the upload again.

4. Import.

Imports cannot be undone. Only if you are sure the data is ok select the "Save Changes" checkbox and upload the file again.


You should only use this function if you are comfortable working with CSV files.

It is a good idea to test with just a few rates and upload a maximum of 50 at a time. It can take up to a minute to process a file, do not re-click submit while the file is processing or you may end up with duplicate imports.

Once rates are uploaded they can only be deleted manually so make sure they are correct before making a bulk upload. If you upload the file twice you will create duplicate rates.

The data fields (columns) must not contain the data seperator character within the data (comma or semicolon)

To check your file format import it into your spreadsheet with only a comma or only a semicolon allowed as the field seperator.