CSV export formats, Overview

Export	Description	File format	Selection criteria
Customers	Exporting customer data with details on contact person	GBAC15	All customers
Invoice Journal	Exporting invoice journals only.	GBAT10	All invoices, or just invoices generated since last export
All Journal Types	Exports all journal entries including Purchase entries.	GBAT10	All entries, or just entries generated since last export
Orders	Exporting orders	GBAO10	All orders, or just orders generated since last export
Products	Exporting products	GBAP15	All products
Suppliers	Exporting suppliers	GBAV15	All suppliers

Notes for all formats

The decimal separator for all numerical fields is a full stop: ‘.’

All lines in the formats separated by a semi-colon should be finished with a semi-colon.

If errors occur during import/export, a file named ‘GBAe2apiErrors.txt’ will be created (usually in the folder C:\Documents and Settings\USERNAME\My Documents\). This file contains error messages that can provide information on the nature of the error and when in the process the error occurred.