The definition for the update from CSV is largely the same as that from an external database except that the data items you specify are the entries in the CSV file – i.e. ‘ITEM-1, ITEM-2, ITEM-3, etc.’
Instead of the selection criteria and flag options, however,
are options to delete the input file and to import new accounts as well.
Opt. CSV to check accounts (Code, Name)
Here you can enter a separate CSV file to use for importing
account records, the CSV file containing two items - the account code followed
by the account name. If the file is
present the codes are first checked against the current nominal ledger and any
new codes added before the journal is imported.
Delete Files after Posting
Set this option to delete the input file after posting – you cannot flag a CSV record as updated so deleting the file prevents duplicate posting.
Note
You cannot use the same multiple update definition to bring in transactions from both a CSV file and an ‘external’ DFD database – you must create separate definitions for them.
Article ID: 1122
Created On: Thu, Jun 28, 2012 at 10:16 AM
Last Updated On: Mon, Jun 19, 2023 at 6:40 PM
Online URL: https://kb.datafile.co.uk/article/multiple-updating-â€-input-from-csv-file-nominal-1122.html