Import from CSV files - Bento
Posted by: Peter Brooks
Date: January 27, 2011 08:42AM

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!

Options: ReplyQuote

Written By
Import from CSV files - Bento
January 27, 2011 08:42AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.