CSV importing problems [money in]
Problem reported by Michiel Haverlag 8 years ago
Dear CB Team,
I've a problem when importing a CSV file. Please let me clarify the steps I'm taking:
1) Download CSV file from our bank (Rabobank, Dutch)
2) Open the CSV file with Excel
3) Then I convert (manually) all the dates - written as 20140414 - to the correct format (YYYY/MM/DD)
4) Save and export the file as a CSV file
5) Upload and import the file to CB
Do you guys have any idea why I get an error? It appears to be that our bank has a very sh*tty CSV export with this weird date format, so I've to manually change all the dates. I'm willing to do so (search and replace) if the import tool would finally work for me.
If I can't fix this in a way, our company won't use CB (unfortunately). Because manually adding all our transactions to the CB system would be a lot of work (and quite a task). We could hire an extra team member for doing that... :)
Could you guys help me out?
Many thanks in advance!