Re: [U2] xml mapping file question

2009-08-09 Thread Boydell, Stuart
Hi Norman, Can I suggest a couple of modifications. You could use the fieldstore function instead of converting to and from VMs. Using fieldstore will run exponentially faster than the VM conversion method. Also, if you want to keep the output pretty add the newline. Eg Equ NEWLINE to

Re: [U2] xml mapping file question [AD]

2009-08-09 Thread Tony G
From: David Jordan Hi Norm Have you found any tools to help generate the excel stylesheets other than manual coding. Have a look at code sample and documentation for NebulaXLite: remove.pleaseNebula-RnD.com/products/xlite.htm I wrote NebulaXLite specifically because people keep asking the

Re: [U2] xml mapping file question

2009-08-09 Thread Norman Bauer
Thanks for the suggestion Stuart. On 8/9/09, Boydell, Stuart stuart.boyd...@spotless.com.au wrote: Hi Norman, Can I suggest a couple of modifications. You could use the fieldstore function instead of converting to and from VMs. Using fieldstore will run exponentially faster than the VM

Re: [U2] xml mapping file question

2009-08-08 Thread David Jordan
Hi Norm Have you found any tools to help generate the excel stylesheets other than manual coding. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] xml mapping file question

2009-08-08 Thread Steve Romanow
List u2-users@listserver.u2ug.org Subject: Re: [U2] xml mapping file question Hi Norm Have you found any tools to help generate the excel stylesheets other than manual coding. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] xml mapping file question

2009-08-08 Thread Norman Bauer
as creating excel docs from U2, sth I found that works well is the python xlwt library. -Original Message- From: David Jordan da...@dacono.com.au Sent: Saturday, August 08, 2009 6:43 PM To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] xml mapping file question Hi Norm

Re: [U2] xml mapping file question

2009-08-08 Thread Norman Bauer
mapping file question Hi Norm Have you found any tools to help generate the excel stylesheets other than manual coding. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2

Re: [U2] xml mapping file question

2009-08-08 Thread Steve Romanow
No direct connection, just csv to native xls on my aix server. -Original Message- From: Norman Bauer normanba...@gmail.com Sent: Saturday, August 08, 2009 8:30 PM To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] xml mapping file question Wow xlwt is schaweet! Thanks

Re: [U2] xml mapping file question

2009-08-07 Thread Norman Bauer
So here is how I did it. To recap. I wanted to include the xsl-stylesheet in the xml document that is produced by XMLExecute(). Below is the code that produced the desired result. PROGRAM STDCSTXML $OPTIONS INFORMATION $INCLUDE UNIVERSE.INCLUDE XML.H ;* CMD is the

Re: [U2] xml mapping file question

2009-08-07 Thread Jo Lester
Thank you for posting your solution. I mainly do XML from within a program too. Date: Fri, 7 Aug 2009 13:36:45 -0400 From: normanba...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] xml mapping file question So here is how I did it. To recap. I wanted to include the xsl

[U2] xml mapping file question

2009-08-05 Thread Norman Bauer
Hello all, Is there a way to insert stylesheet information in the mapping file? For instance: U2 root=name treat-as=element stylesheet=some.xsl / It would save me a lot of work and a huge headache if I could get that information in the mapping file. Thanks, Norm

Re: [U2] xml mapping file question

2009-08-05 Thread Jo Lester
, by adding an attribute? Date: Wed, 5 Aug 2009 14:45:47 -0400 From: normanba...@gmail.com To: u2-users@listserver.u2ug.org Subject: [U2] xml mapping file question Hello all, Is there a way to insert stylesheet information in the mapping file? For instance: U2 root=name

Re: [U2] xml mapping file question

2009-08-05 Thread Norman Bauer
a particular style to a particular element, by adding an attribute? Date: Wed, 5 Aug 2009 14:45:47 -0400 From: normanba...@gmail.com To: u2-users@listserver.u2ug.org Subject: [U2] xml mapping file question Hello all, Is there a way to insert stylesheet information in the mapping

Re: [U2] xml mapping file question

2009-08-05 Thread Jo Lester
.pdf I haven't tried it myself yet, sorry. Date: Wed, 5 Aug 2009 16:15:50 -0400 From: normanba...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] xml mapping file question That is exactly what I mean Jo. If I were to do: SORT VOC TOXML XMLMAPPING some_file.map