XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Chris BartlettSubject: Can I do this with Stylus?
Author: Chris Bartlett
Date: 19 Nov 2009 04:10 AM
Hi All,

I am trying to find out if Stylus studio can solve my problems:

1) I have large scale XML files with quite complex tree structure and many attributes (average size of XML is about 150MB)
2) I need to extract some tables from XML with selected columns and export it to Access .mdb
3) I need to add keys from the parent attribute values as extra columns to the exported tables

Basically that's it. can I do this with Stylus?

Thanks!

Chris

Postnext
Alberto MassariSubject: Can I do this with Stylus?
Author: Alberto Massari
Date: 20 Nov 2009 03:07 AM
Hi Chris,
Stylus Studio can easily handle your 150Mb file (we tested with XML documents up to 1Gb). As for moving parts of this document to Access, I would use XQuery or XSLT to do the filtering and shaping the result to conform to a structure like

<dataroot>
<TableName>
<Column1>data</Column1>

that can be imported into Access using either the UI or programmatically by running a script like

Const acAppendData = 2
Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "C:\Scripts\Test.mdb"
objAccess.ImportXML "c:\scripts\test.xml", acAppendData

See http://msdn.microsoft.com/en-us/library/aa139956%28office.10%29.aspx for more informations on the Access side.

Hope this helps,
Alberto

Postnext
Chris BartlettSubject: Can I do this with Stylus?
Author: Chris Bartlett
Date: 21 Nov 2009 01:28 AM
Thank you Alberto.

Still, the problem with large files remains. Even though I have managed to load it (not a very big - about 190MB), it is hardly manageable and Stylus Studio crashed a few times. is there a way to split large XML with Stylus? I am trying to find a simple and quick solution without coding a custom splitter myself.

Any suggestions?

Thanks,

Chris

Posttop
Alberto MassariSubject: Can I do this with Stylus?
Author: Alberto Massari
Date: 23 Nov 2009 05:01 AM
Hi Chris,
which version of Stylus Studio are you using?
Can you cause a crash and send the error report to stylus-field-report@progress.com (which a zipped copy of the XML, if possible)?

As for splitting the file in chunks, there is no such a feature in Stylus, as the logic behind splitting is usually non-standard and depends on the capabilities of the application reading that XML.

Thanks,
Alberto

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.