Import from CSV files - Bento

[Peter Brooks]

I'm trying to migrate a database from Bento to MySQL. I've managed the following:

- Export data - various .csv forms tab, comma and semicolon separated
- Set up import with mysqlimport

This is where I get stuck. It only imports one record then stops. It seems to have got the first record in OK - but the second record is all nulls.

Actually the first record doesn't come in that well - the time is in the format 18 Nov 2010 11:03 and this ends up as all 0's or, when you try to report it, as an illegal or undefined field.

So, my questions are:

- Is there some easier way to migrate a Bento database?
- What time & date format will it import properly?
- I've got multi-line text fields, which include commas. Is it possibly choking on these? If so, what's the best way to import them?

Any suggestions gratefully received!