----- Original Message ----- From: "Wilbert Enserink" <[EMAIL PROTECTED]> To: "PHP" <[EMAIL PROTECTED]> Sent: Wednesday, January 23, 2002 4:34 PM Subject: [PHP] db conversion advice needed
> Hi all, > > > I have this huge db in FileMaker Pro format :-( Which plattform? Mac, Win? I had once to write an import script for mysql to import a tab-export from FM Pro Mac. I did it this way: -HTML-Fileupload -Translate chars (e.g. german characters ä, ö, ü - or in HTML ä, ö - furthermore I translated ASCII 13 to <br>) -Read in a loop line for line -Split line by tab -check if record is already in mysql database (only if you have to import more than once) -build mysql insert query -done :) If you have more questions or more detailed questions just ask best regards Stefan Rusterholz > Now I need this db to make a db content based website. I know enough stuff > about MySQL to do this, but I don't know anything about converting db's. > Does anybody have any tips, or ideas how I can handle this db converting > thing best? > > > > I am able to export the filemaker pro file to -tab based- files, which I > know M$ excel can import.... > > > > many regards, and thx for all the ideas. > > > Wilbert Enserink > > ------------------------- > Pas de Deux > Van Mierisstraat 25 > 2526 NM Den Haag > tel 070 4450855 > fax 070 4450852 > http://www.pdd.nl > [EMAIL PROTECTED] > ------------------------- > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]