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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] > > 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* < [EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED]>> wrote: > > > > > > On 8/22/07, Ron LeVine < [EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED]>> 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 > > [email protected] > > http://www.euglug.org/mailman/listinfo/euglug > > > > > _______________________________________________ > EUGLUG mailing list > [email protected] > http://www.euglug.org/mailman/listinfo/euglug > >
_______________________________________________ EUGLUG mailing list [email protected] http://www.euglug.org/mailman/listinfo/euglug
