[Eug-lug] Importing a .csv file into MySql

[Ben Barrett]

Or if you are in a business pinch, you could say you're willing to pay $o
many dollar$
to get this done, and that the CSV contains so many columns/fields, also
give a sense
of how complicated the job is.... or that you need someone to check it out
to give you
an estimate.  It sounded like you were seeking DIY-type help at first; I'm
sure you can
find paid "get're done" help here too :)

ben


On 8/22/07, Allen Brown <abrown at peak.org> wrote:
>
> The answers you are getting are geared toward telling you where
> to learn how to do the job.  If you want more specific help
> you may want to be more specific with your question.  Posting
> the exact format of the data and how you want it to be
> organized under MySQL will empower folks to give you a better
> answer.
> --
> Allen Brown  abrown at peak.org  http://brown.armoredpenguin.com/~abrown/
>    Always forgive your enemies -- Nothing annoys them so much. ---Oscar
> Wilde
>
> Ron LeVine wrote:
> > Well, guys, you both are talking way over my head on this.
> >
> > Oh well.
> >
> > Thanks anyways,
> > Ron
> >
> > On 8/22/07, *larry price* < laprice at gmail.com
> > <mailto:laprice at gmail.com>> wrote:
> >
> >     On 8/22/07, Ron LeVine < levine.ron at gmail.com
> >     <mailto:levine.ron at gmail.com>> wrote:
> >      > Greetings all,
> >      >
> >      > I have a .csv file from a spreadsheet that I want to import into
> >     a MySQL db.
> >      > Unfortunately, the format of the file is not the same as the
> >     field list in
> >      > MySQL so I think I need a script to parse the file and then do
> >     the MySQL
> >      > commands to place the data where it goes.
> >      >
> >
> >     This is a very straightforward data filter script, the general
> pattern
> >     goes like this
> >
> >     using your favourite scripting language
> >
> >     read each line of the file into a hash table (dictionary)
> >
> >     write the output function that does whatever formatting,
> interpolation
> >     and calculation you need to produce the database table row you need
> >     from the hash structure you have.
> >
> >     apply the output function to each line, and either stuff the result
> >     into the database directly, or into a file for importation later.
> >
> >     (for larger data sets the copy function your DBMS has is
> significantly
> >     faster than inserting row by row)
> >
> >
> >
> >
> >
> >
> >      > I am not much of a script guy. Anyone care to assist on this???
> >      >
> >      > Thanks in advance,
> >      > Ron
> >      >
> _______________________________________________
> EUGLUG mailing list
> euglug at euglug.org
> http://www.euglug.org/mailman/listinfo/euglug
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://euglug.org/pipermail/euglug/attachments/20070822/43751da4/attac=
hment.htm