Or you could use a proper XML integration product and provide XML In any format you wish, right down to links to attachments and diary fields broken up into their components (not to mention access to the every piece of AR API stat/info information).
Check out this XML export: Entirely customisable and you could write the export template in 10 minutes: http://www.javasystemsolutions.com/img/screenshots/xmlgw/query2.png (Notice how it's so flexible that it can even break up long fields into multiple nodes, if that's what you want to do - which I appreciate most don't!). John Baker Java System Solutions : http://www.javasystemsolutions.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"