IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only

When is a quote, not a quote

  • 1.  When is a quote, not a quote

    Posted 08/16/16 05:43 AM

    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