[BNM] nice mysql import tool and free

[Jason Bailey]

--- On Mon, 11/8/08, Alessandro De Maria <alessandro.demaria at gmail.com> wrote:

> From: Alessandro De Maria <alessandro.demaria at gmail.com>
> Subject: Re: [BNM] nice mysql import tool and free
> To: "Brighton New Media" <bnmlist at brightonnewmedia.org>
> Date: Monday, 11 August, 2008, 5:20 PM
> what kind of errors do you have? how unclean is the data?
> 
> Can you read it with a script, clean it and output it as
> SQL?
> This way you can then pipe it to mysql.


Hi

Thanks for replying. Navicat looks good and I think there's a 30 day demo which'll do me!

It's about 4000 records with international characters; this isn't the problem.

The problem is that it's been created in Excel, the data in places is two merged cells. There are commas where there should be semi colons and not all of the text is enclosed in speech marks (i.e. where for example there are commas). 

It's really messy data and in the past I've gone through it error by error but I'd quite like something to at least shove the data in that is OK and report/return the rest so at least I can say "I did this but you've got to fix this".


Jason




Send instant messages to your online friends http://uk.messenger.yahoo.com