You are here:  » Can be used as MySQL Import?

Support Forum



Can be used as MySQL Import?

Submitted by dennis.ozkohen on Sat, 2007-12-22 22:51 in

Dear MagicParser,

I have a question about your script.
The first question, the important one, can this script be used as a XML to MySQL import ?

Second, does this script uses a authentication to check license? So, are you under control of this page?
What I mean: Script run -> Check license @ Magicparser.com -> Magicparser.com is down (For any reason?) -> Script fails ?

Please let me know,
Regards Dennis

Submitted by support on Sun, 2007-12-23 08:07

Hello Dennis,

You can certainly write a script using Magic Parser to import XML to MySQL, but there is no MySQL code specifically within the script - you have to write the MySQL code yourself.

This goes in your record handler function; where you would construct and execute and SQL statement to insert the fields you require from $record (or whatever you have called it) into the appropriate table. It's very easy to do as long as you are reasonably familiar with PHP's MySQL library, but if you need any help doing this let me know.

Secondaly, no the script does not need to connect to MagicParser.com to check for your license, so you will not have any problem like that!

All the best,
David.