Scenario:
Multiple bank accounts are monitored throughout the day for deposits and withdrawals to post into various ledgers and customer accounts.
Clerks log into various banking sites continuously downloading CSVs.
Administrator using Alpha, periodically selects csvs to update into the system. They may select the same csv as earlier (to ensure picking up added transactions) as well as most recent csvs
Requirement:
When bank transactions are collected it must not allow duplicate that transactions, only new entries appearing since last update. The bank systems dont always append to the bank statement, earlier entries picked up later can be inserted before a previous one.
None of the above is strange or unusual, but I cannot get the append operation to append only unique;
Determined by fields iDate (c)+ iAmount (n) + idesc (c)
it either appends nothing or all again
Simple DB attached. bankcsv.dbf must update to banks_imported,dbf.
Then Add a or alter a transaction with an amount in bankcsv.dbf. Update again and only the new transaction/s should be appended.
I included only a couple of my attempts.
All the other ops and code work flawlessly from origin to account journals - except for this little bit in the middle.
My only alternative otherwise is to code a laborious procedure.
Multiple bank accounts are monitored throughout the day for deposits and withdrawals to post into various ledgers and customer accounts.
Clerks log into various banking sites continuously downloading CSVs.
Administrator using Alpha, periodically selects csvs to update into the system. They may select the same csv as earlier (to ensure picking up added transactions) as well as most recent csvs
Requirement:
When bank transactions are collected it must not allow duplicate that transactions, only new entries appearing since last update. The bank systems dont always append to the bank statement, earlier entries picked up later can be inserted before a previous one.
None of the above is strange or unusual, but I cannot get the append operation to append only unique;
Determined by fields iDate (c)+ iAmount (n) + idesc (c)
it either appends nothing or all again
Simple DB attached. bankcsv.dbf must update to banks_imported,dbf.
Then Add a or alter a transaction with an amount in bankcsv.dbf. Update again and only the new transaction/s should be appended.
I included only a couple of my attempts.
All the other ops and code work flawlessly from origin to account journals - except for this little bit in the middle.
My only alternative otherwise is to code a laborious procedure.
Comment