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.
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.
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.