|
|
 top
|
  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)
 catalog(1).json
JSON file
|
|
|
|
|
