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

[Ron LeVine]

Well, unfortunately, there is no money for this project until she is
actually able to go live and I am not making anything off of this. Just
trying to assist a friend.

Thanks again,
Ron

On 8/22/07, Ben Barrett <stircrazyben at gmail.com> wrote:
>
> 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/<=
http://brown.armoredpenguin.com/%7Eabrown/>
> >    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
> >
>
>
> _______________________________________________
> 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/4af6f8b0/attac=
hment-0001.htm