Re: db conversion advice needed

----- Original Message ----- From: "Wilbert Enserink" <wilbert@pdd.nl> To: "PHP" <php-general@lists.php.net> 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 &auml;, &ouml; - 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 > info@pdd.nl > ------------------------- > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >