index

putInvoicees CSV

Import Invoicees from a CSV file

username
password
CSV file
save invoicees
Click submit once only or you may import duplicates.

Instructions

Warning, Excel for Mac does not support UTF-8 and may corrupt characters. We strongly recommend using an alternative like Open office or Libre office.

1. Create a CSV file in the correct format.

You can do this by first downloading your invoicees using: getinvoiceescsv

2. Create your CSV import file.

The first row must contain the header for each colum to identify the contents of that column. Each following row contains one invoice item.

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

The InvoiceeId number must be blank (or the column removed) to add a new invoicee or the Invoicee number of an existing invoicee to modify it.

A new invoicee must have a name.

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

4. Import.

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

IMPORTANT NOTES:

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

The data fields (columns) must not contain the data seperator character within the data (comma, tab or semicolon) unless the whole field is enclosed in double quotes.

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