CSV importing
Posted: Sun Oct 28, 2012 9:18 am
Hello :
I am setting up a new deployment. We will need to import bank transactions daily into the "bookkeeping" module. I have this all working well - But I have run into a problem and I'd like to know if there is a solution.
The import works 100% as long as the Data is 100% from the bank statement but if a client/bank clerk has made a Typo on the "Username" while making a deposit the entire import fails.... Now is there a way to isolate the line in the .csv file that has the error so we can correct the entry ?
Currently we are using a small test bed of clients so no major problem but once we scale up I can see this as causing large time delays in the update process.
Thank you
I am setting up a new deployment. We will need to import bank transactions daily into the "bookkeeping" module. I have this all working well - But I have run into a problem and I'd like to know if there is a solution.
The import works 100% as long as the Data is 100% from the bank statement but if a client/bank clerk has made a Typo on the "Username" while making a deposit the entire import fails.... Now is there a way to isolate the line in the .csv file that has the error so we can correct the entry ?
Currently we are using a small test bed of clients so no major problem but once we scale up I can see this as causing large time delays in the update process.
Thank you