46 Batch data import methods

46.2 Data imports back port from 1.4

46.2.1 Chart of Accounts import

This function allows bulk import of an entire chart of accounts using a single Comma Separated Values (CSV) file.

The first line of the file contains the headers of the columns. The import routine expects the columns as presented in (table name).

accno

Number of the account or header

desc

Description for the account or header

charttype

“H” for heading record
“A” for account record

category

“I” for Income
“E” for Expense
“A” for Asset
“L” for Liability

contra

“0” not a contra account
“1” is a contra account

tax

“0” not a tax account
“1” is a tax account.

link

A colon (’:’) separated list of account check-mark values (links) as described in Section 26.2.3 on page 26.2.3, or “AR”, “AP” or “IC” for the specified summary accounts

heading

Id of the heading to group the account (or heading) under

gifi

GIFI account number

All lines after the first one are considered to be data lines.