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

  • Comment on Re: I have a generalized "from XML to SQL" chore... best way?