in reply to I have a generalized "from XML to SQL" chore... best way?
Hello,
Assuming that the XML file takes a "each child of the root node is a record" layout, the first thing I would do is turn each record in to a data structure. An easy way to do this while keeping efficiency in mind is with Jenda's XML::Rules (see also node #582348).
Then personally I would use Data::FormValidator to validate and manipulate each record.
And then probably DBI or maybe an ORM to insert the data in to the db.
trwww
|
|---|