Originally posted by: paul.brett
I had a client trying to import a JSON data file. It contained a mixture of quote characters:
At this font size, it's easy to visually compare the types, and 'see' that the second and third examples are not the same as a standard quote character. The JSON importer will choke on either of these two 'invalid' quote characters:
java.io.IOException: Unexpected character '"' on line 6, column 21
at com.ibm.json.java.internal.Tokenizer.next(Tokenizer.java:129)
at com.ibm.json.java.internal.Parser.parseObject(Parser.java:109)
at com.ibm.json.java.internal.Parser.parseValue(Parser.java:231)
at com.ibm.json.java.internal.Parser.parseObject(Parser.java:110)
at com.ibm.json.java.internal.Parser.parseValue(Parser.java:231)
at com.ibm.json.java.internal.Parser.parseObject(Parser.java:110)
at com.ibm.json.java.internal.Parser.parse(Parser.java:58)
at com.ibm.json.java.OrderedJSONObject.parse(OrderedJSONObject.java:65)
at com.ibm.json.java.JSON.parse(JSON.java:71)
at com.ibm.json.java.JSON.parse(JSON.java:135)
at com.ibm.websphere.dtx.ui.importers.json.model.util.Builder.build(Unknown Source)
at com.ibm.websphere.dtx.ui.importers.json.JSONImporter.getModel(Unknown Source)
at com.ibm.websphere.dtx.ui.importers.json.JSONImporter.generateTree(Unknown Source)
at com.ibm.websphere.dtx.ui.importers.dialogs.WTXImportWizard.buildTypeTree(Unknown Source)
at com.ibm.websphere.dtx.ui.importers.dialogs.WTXImportWizard$2.run(Unknown Source)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
I hope this helps somebody who might be struggling with this at some point in the future.
Thank-you.
Paul.
Follow me on Twitter
#DataExchange#IBMSterlingTransformationExtender#IBM-Websphere-Transformation-Extender