Hi
I have to do the following
parse an xml file that will be uploaded periodically to our server,
I need to enter expiry dates from this file into a table. I am not a coder and am looking for something very simple to use that can help me.
The expiry fields are in the following format
2006-10-18T06:56:00
Can Magic Parser help me to do this? I am supposing that once the data is in arrays I can insert it into the database in the usual way.
Hi,
Thanks for your interest in Magic Parser. I'm afraid the script; whilst it should certainly be able to parse your file easily does not have anything to do with MySQL - all of the code required to do this would have to be developed together with your framework around Magic Parser to read the file. If you don't have coding experience i'm afraid this would not be straight forward as there is quite a bit of PHP and MySQL development knowledge that you would need beforehand.
If however, as you mention inserting into the database in the normal way; so if you are already familiar with what I have described above then you may find that Magic Parser is the easiest way to read your XML file. One way to find this out is if you can upload a copy of your XML to the demo script...
http://www.magicparser.com/demo
If you can browse through the records and see the date field that you need to insert into the database then it should be no problem. If you then click the link to view PHP source; you will be able to see where you can add your MySQL code to do the job..!
Hope this helps!,
Cheers,
David.