How to use the CSV dataset

• • The CSV dataset is a generic parser than can import your data that is in a csv format. Column headings are expected on row 1. Columns can be in any order

  • The following columns are mandatory

  • Date

  • Amount

  • Description

  • Reference

  • You can add any number of reference columns. If the column headings have a space in them, map it with an underscore on the template setup eg Cost_Centre_Code

  • Additionally you can have a balance column. If not present then balances are defaulted to zero. If present then the opening balance is the first records balance - first records amount. Closing balance is the last balance field on the file.

  • An account column can be included if required. If present then any value captured in the account filter on the template will be matched to the value in the account column and if they are the same the transaction record will be imported. Transactions with a different account value will be ignored.

E.g. A file with the following headings and transaction

Account, Date, Amount, Description, Reference, Member Name, Balance

2345, 2012/12/04, 5353.56, My transaction, Reference1, John Doe, 5353.56

will have an opening balance of 0 (Balance - Amount).

If there is an account filter it will be checked and the transaction only imported if it matches

Member Name must be mapped as Member_Name (Replace space with an underscore) in the external Field Map of the Template.

Description and Reference need to be included in the template.