SSDN - CSV file putting all the data in one Value

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Brandon Gilchrist

Subject: CSV file putting all the data in one Value
Author: Brandon Gilchrist
Date: 07 Sep 2021 08:36 PM

Hello,

I am using the custom XML conversion and I an unable to batch update the xml tree once the data is pulled to nest some of the fields.

I was unable to nest the fields when I set up the custom convertor even thought the XML that it is using had nesting fields.

Best,
Brandon

Ivan Pedruzzi

Subject: CSV file putting all the data in one Value
Author: Ivan Pedruzzi
Date: 07 Sep 2021 09:50 PM

Brandon can you attach a small example zipped of following

- example of input data
- desired output
- custom conversion template you have designed

Ivan Pedruzzi
Stylus Studio Team

Brandon Gilchrist

Subject: CSV file putting all the data in one Value
Author: Brandon Gilchrist
Date: 08 Sep 2021 03:19 PM

Hello Ivan,

I have attached the documents in a zip file.

Stylus(2).zip
files

Ivan Pedruzzi

Subject: CSV file putting all the data in one Value
Author: Ivan Pedruzzi
Date: 08 Sep 2021 09:03 PM

Brandon,

Have a look at the project attached.

In order to create the XML structure you have in your example APApplicantschema.xml, you need more than just a converter.

I used a XQuery to build a simple transformation. If you want to learn more we can setup a zoom call.

How are you planning to automate the conversion?

In the project I created an XML pipeline which can be be executed on our XML Pipeline Server (www.xmlpipelineserver.com).

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

CSV-applications-to-XML-applications.zip

Brandon Gilchrist

Subject: CSV file putting all the data in one Value
Author: Brandon Gilchrist
Date: 09 Sep 2021 01:42 PM

Thanks Ivan,

I would love a zoom call to go over this as well as assistance with automating this process.
I am free anytime today after 12 est and I can make time Friday if needed. You can email me directly bjgilchrist@nsu.edu.

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.