Skip to main content
rtaylor-31-Visitor
1-Visitor
January 11, 2016
Solved

ThingWorx ML 51.0.1 Developer Edition - error importing parking_importdata.csv

  • January 11, 2016
  • 6 replies
  • 4167 views

Greetings,

I just downloaded Thingworx ML 51.0.1 Developer Edition and am trying to import the parking kiosk data set.

I'm using PostMan and have been able to define the dataset and the corresponding meta information in Neuron successfully.
However, when i try to upload the actual data, i'm getting the following error:

Unexpected character ('-' (code 45)) in numeric value: expected digit (0-9) to follow minus sign, for valid numeric value

at [Source: org.glassfish.jersey.message.internal.ReaderInterceptorExecutor$UnCloseableInputStream@20679501; line: 1, column: 3]

Is this a known issue?

Seems like a parser error with the data file.

Is there a work around?

Best answer by rtaylor-3

Filed a tech support case. With their help identified that when uploading file content, you need to remove the content-type header. This is not documented in the install guide, however, in hindsight, it makes sense.

6 replies

rtaylor-31-VisitorAuthor
1-Visitor
January 11, 2016

It appears the parser is expecting a numeric value in the "identifier" column. However, the parking_importdata.csv file "identifier" column contains alpha-numeric entries like 305-AJ-456. I'm guessing the parser is choking on the "-" character.

One work around i can see is to replace the identifier values with unique numeric values....unless the identifiers are referenced by other entities.

rtaylor-31-VisitorAuthor
1-Visitor
January 11, 2016

Hmmmmm.... i replaced the identifier values with unique integer values....still getting the same error. Maybe its an issue with parsing the entry_dt column.

Here is a value from the first record: 2015-10-13T11:16:50.5245740-04:00 ....Maybe its the timezone offset?

rtaylor-31-VisitorAuthor
1-Visitor
January 11, 2016

Ok....i modified the first column to be a unique integer value and the second column to be a static string '20151013'. Still getting the same error.

rtaylor-31-VisitorAuthorAnswer
1-Visitor
January 12, 2016

Filed a tech support case. With their help identified that when uploading file content, you need to remove the content-type header. This is not documented in the install guide, however, in hindsight, it makes sense.

    dsharma1-Visitor
    1-Visitor
    March 18, 2016

    I removed the content-type header and encounter error when I select the Send button:

    {

      "errorId": "d98746f2-921d-49db-849e-86199e814dbf",

      "errorMessage": "Error uploading data set"

    }

    Can you please advise how to resolve this?

    dsharma1-Visitor
    1-Visitor
    March 18, 2016

    Removing the content-type header did help to resolve the problem. Thank You.

    Terms & ConditionsAccessibility statement