Hi, I need a conversion of an XML file to a .sql file for insertion to a database. The file is people.xml on the page http://www.govtrack.us/source.xpd
Final delivery will include an .sql file and a php 5 script so that I can convert future files of the same format.
I'm flexible on the schema. I need all of the data included, and person_id as the primary key. Probably can have a main table, a roles table, and a committee table.
This should be a quick and straightforward project. Thanks!