Topic: Journal Entry Import format

I was wondering what the import format is. Seeing as you can change the field separator I am presuming it is a basic CSV type format, but how are the fields organized?

Sorry if this is covered someplace else. I did look for the information but didn't check exhaustively...

Re: Journal Entry Import format

Well I found out what the format was by locating the module code... feeling a bit sheepish roll

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