RE: [UV] XML conversion in UV 10.1

2004-02-29 Thread Stuart Boydell
Hi John,
We are using UV/10.0.17/aix to receive and convert XML documents. This works
quite well. It uses an extraction document, which is based on a subset of
XPath to extract data from XML documents and formats the output into a
dynamic array. Semantically, it's not always obvious why there are certain
requirements for the extraction document but, it works.

We parse documents into a number of dynamic arrays, correlating to our file
structures. There's a small amount of Basic code to prepare and parse the
XML and handle error conditions.

I believe that the changes for 10.1 are all positive with more Basic
functions and better access to the DOM.

XML to CSV. The method to use for that would be XSL/XSLT - the tool depends
on what skills you have available to roll you own using Java, Perl, MSXML,
etc or want to buy. Search GOOGLE you will find plenty of examples ("convert
XML to CSV" = 101 hits).

Cheers,
Stuart



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf Of John Hester
> Sent: Saturday, 28 February 2004 07:41
> To: U2 Users Discussion List
> Subject: [UV] XML conversion in UV 10.1
>
>
> We're planning a platform migration to UV 10.1 and hope to utilize the
> built-in XML functionality to exchange data with our trading partners.
>  From what I read on the IBM U2 site it appears that XML can be created
> from standard UV files in 10.1.  Are there also tools that enbable data
> to go the other direction - from XML to a standard UV file?  Sorry if
> I'm not being specific enough, but I'm a newbie to XML.
>
> Also, since UV 10.1 has not been ported to our chosen platform yet, can
> anyone recommend an XML to CSV parsing tool?  I'm looking for something
> that can be run in batch mode, preferably on a unix server.
>
> Thanks,
> John
>
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>



**
This email message and any files transmitted with it are confidential
and intended solely for the use of addressed recipient(s). If you have 
received this email in error please notify the Spotless IS Support Centre (61 3 9269 
7555) immediately who will advise further action.

This footnote also confirms that this email message has been scanned
for the presence of computer viruses.
**

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: [UV] XML conversion in UV 10.1

2004-02-29 Thread Craig Bennett
>Are there also tools that enbable data
>to go the other direction - from XML to a standard UV file?  Sorry if
>I'm not being specific enough, but I'm a newbie to XML.

John,

I haven't really used it (I wrote an XML parser back in UV 9.6 and can't
justify the switch) but my scan of the docs for 10.1 suggested that you can
both create and parse/extract from  XML.


Craig

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: [UV] XML conversion in UV 10.1

2004-02-27 Thread Mike Randall
Not sure about Unix tools but Excel 2003 is fully XML aware.   Going from
XML to CSV is as simple as Save As. If you are into .Net,  Microsoft has
introduced a very power API called Visual Studio Tools for Office that will
allow full programmatic control over Excel (Word too) from within VB.Net.
Smooth and easy automation.  Through Redback into the mix and Excel/Word
take on new life from .Net in regards to using them with U2 data.

Mike R.

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of John Hester
Sent: Friday, February 27, 2004 3:41 PM
To: U2 Users Discussion List
Subject: [UV] XML conversion in UV 10.1

We're planning a platform migration to UV 10.1 and hope to utilize the
built-in XML functionality to exchange data with our trading partners. 
 From what I read on the IBM U2 site it appears that XML can be created from
standard UV files in 10.1.  Are there also tools that enbable data to go the
other direction - from XML to a standard UV file?  Sorry if I'm not being
specific enough, but I'm a newbie to XML.

Also, since UV 10.1 has not been ported to our chosen platform yet, can
anyone recommend an XML to CSV parsing tool?  I'm looking for something that
can be run in batch mode, preferably on a unix server.

Thanks,
John

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users