Reply to thread

Message: [QUOTE="Peter J. Holzer, post: 4852943"] I think (just from superficially reading [URL]http://search.cpan.org/~cberning/DBIx-XML-DataLoader-1.1b/DataLoader.pm[/URL], I've never used this module) that you can use it to specify multiple databases in the same map file. Then you can say "this data goes into table X on database A, and this goes into table Y on database B". If you don't need that, just choose a descriptive name. XPath is like Perl. It gets cranky when it's spelt in all upper case ;-). Seriously: XPath is a language for selecting stuff from an XML file. Sort of what regexps are for plain text or SQL for relational databases. You can find the specification at [URL]http://www.w3.org/TR/xpath20/[/URL] and google will help you find tutorials (Sorry, I don't have a good one at hand - you'll probably have to read several of them and the specs, too to get the hang of it). Seems plausible. Just use an Element without a KeyColumn. Note that the Element element has two attributes: xpath (which specifies where to find the data in the XML file) and toColumn (which specifies where to put the data in the table). If the XML file already contains the keys, you can specify them with xpath. If it doesn't you are probably supposed to create them in a handler. hp [/QUOTE]