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
(Deleted User) Subject: Get a schema for a JSON file
Author: (Deleted User)
Date: 15 Feb 2011 10:57 AM
Originally Posted: 15 Feb 2011 08:56 AM
Perhaps I can obtain some help with this?

I have been extracting data from a JSON file using the JavaScriptSerializer in .NET, but it occurs to me that SS may be able to help me better.

I think I need to generate a schema file from which I can construct a class - and write some .NET code to more efficiently parse the file and extract stuff.

Having just activated my latest update to SS, I see that I have about 2 weeks to use an XML Converter for Java, but I would like some guidance in converting this file (50Kb only).

The first hurdle I have is that the conversion gags at the first character, [

I'm totally ignorant of JSON format. Here is the first 100 characters or so of the file -

[{"a":"3094837","b":"Arthur Series 5","e":"pre-school arthur series 5 recent","f":[{"a":"690437","f":"2010-12-19 16:05:00","g":"2011-01-02 16:05:00"}]},{"a":"2806431","b":"Message Stick Series 12","e":"message stick series 12 arts abc1 docs people recent","f":[{"a":"690461","f":"2010-12-19 14:30:00","g":"2011-01-02 14:30:00"},{"a":"682525","f":"2010-12-12 14:30:00","g":"2010-12-26 14:30:00"}]},

and the last 30 or so is as follows -

,{"a":"9997202","b":"The WotWots Volume 1","e":"shop shopdownload shop-pre-school shop-kids","f":[{"a":"9997202","f":"2010-03-01 00:00:00","g":"2015-10-31 00:00:00"}]}]

A step-by-step recipe would be nice ..

[edit] Attached the actual file, catalog.json

Ian Thomas
Stylus Studio 2011 XML Enterprise Suite (Build 1756a)

JSON file

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!  

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.