Well I found out what the format was by locating the module code... feeling a bit sheepish
////////////////
// File Format
This extension imports CSV files of the following format:
entryid,date,reference,accountcode,dimension1,dimension2,amount,memo
- 'entryid' can be any value, so long as it differs from all other entryids
in the import file. Every entryid will result in a separate journal entry
being created with the specified transaction data within it.
Transactions with the same entryid must be grouped together within the
import file.
- 'date' and 'reference' should be the same throughout a given entry.
- For proper use of all of these fields (except 'entryid'), see the
Journal Entry entry dialog within FrontAccounting under Banking and
General Ledger.
- entryid does *not* correspond to what the journal entry id will be within
FrontAccounting.
In the case above, the separator is a comma (,) though any separator will work.
Example import file:
entryid,date,reference,accountcode,dimension1,dimension2,amount,memo
1,10/5/2009,TD-1,10002,MyDim,,945.59,"My memo"
1,10/5/2009,TD-1,5600,MyDim2,,-400,""
1,10/5/2009,TD-1,5602,MyDim2,,-545.59,""
2,10/7/2009,TD-2,5602,,,-100,""
2,10/7/2009,TD-2,5602,MyDim,,100,"Reimbursement"
This file will result in two journal entries:
- One dated 10/5/2009 with reference TD-1 and three transactions
- One dated 10/7/2009 with reference TD-2 and two transactions
Note 1: Dimensions are expressed in references, not IDs!
Note 2: It is wise to enclose memos in double quotes ("my memo") so that
it will be parsed properly in case it contains the field separator.