Skip to main content
C
CR_104225264-Participant
4-Participant
December 15, 2023
Question

How to get date column from CSV file when Parsley extension using

  • December 15, 2023
  • 2 replies
  • 927 views

Hi,

Please help on following ,

 

I want to get date field from CSV file.  If I apply dataShape (Date column as Datetime). will getting error (tried many ways, still didn't get answer). 

 

let params = {
path: "/PhysicalTestMachineData.csv" /* STRING {"defaultValue":"/"} */,
columnMappings: undefined /* STRING */,
hasHeader: true /* BOOLEAN {"defaultValue":false} */,
longitudeField: undefined /* NUMBER */,
dateFormat: parseDate(Date, "DD/MM/YYYY") /* STRING */,
fileRepository: "SystemRepository" /* THINGNAME */,
latitudeField: undefined /* NUMBER */,
fieldDelimiter: "," /* STRING {"defaultValue":","} */,
stringDelimiter: undefined /* STRING {"defaultValue":"\""} */,
customFieldNames: undefined /* STRING */,
dataShape: "Physical_E1" /* DATASHAPENAME */
};

// result: INFOTABLE
let result = Resources["Parsley"].ParseCSV(params);

 

.....>>>

 Error executing service GetPhysicalTest_CSV_1. Message :: Invalid format: "org.mozilla.javascript.IdFunctio..." - See Script Error Log for more details.

 

Thank you

2 replies

N
nmilleson17-Peridot
17-Peridot
December 15, 2023

@CR_10422526 ,

 

I know this solution isn't ideal, but you can add an extra text field to your datashape to accept the string value of the date, and then use the:

 

var newDate = new Date(dateString);

 

to get it to the format you need for your DateTime column.

 

Hope that helps

- Nick

    Rocko
    Rocko19-Tanzanite
    19-Tanzanite
    December 15, 2023

    You didn't provide sample data or the datashape, plus Parsley is not a PTC-supported extension, so you might get better advice asking the developer. I've seen him around here @jamesm1@jamesm1 

    The images at https://github.com/jmccuen/parsley seem to be broken as well which leaves us with little information, but from what I can see, wouldn't you just use the plain date format in the parameter?, e.g.

    dateFormat: "DD/MM/YYYY",

     

    EDIT: What's probably also to know is that you have to use joda time format for your format string. See https://www.joda.org/joda-time/apidocs/org/joda/time/format/DateTimeFormat.html

    Try dd/MM/yyyy

     

     

     

    Terms & ConditionsAccessibility statement