The CSVLayer object converts CSV integer data from the last column (right-most) to a data-time format when the line break type is set to Windows (CR LF).

Workaround

Two workarounds:

-----If creating your own CSV files-----

Method 1

• Using the same data2.csv you created, open/edit the file in Notepad++.
• Set the line break type to Unix (LF) and save the file.
• Refresh the JavaScript web page.
• Click a point and see that the Population attribute value is a regular integer and not in date-time format.

Method 2

• Using the same data2.csv you created, open/edit the file in Notepad++.
• Set the line break type to Windows (CR LF).
• Put a comma at the end of each Population value. A comma is not needed for the header column name.
• Refresh the JavaScript web page.
• Click a point and see that the Population attribute value is a regular integer and not in date-time format.

-----If using the file attachments on this bug log-----

Method 1

Set the const url variable to the CSV file data1.csv web server location (Refer to the comment examples on the code). Refer to workaround.png for the expected output.

• Click any orange CSV point in the map view and notice the pop-up feature attribute. The format of the Population attribute is not converted to date-time format.
  • Open the data1.csv file in a Notepad++ text editor. Notice that the line break type on the bottom right corner is set to Unix (LF). Refer to screenshot1.png.
  • This bug is not reproducible for line break type Unix (LF).

Method 2

Set the const url variable to the CSV file data3.csv web server location (Refer to the comment examples on the code). Refer to workaround.png for the expected output.

• Click any orange CSV point in the map view and notice the pop-up feature attribute. The format of the Population attribute is not converted to date-time format.
  • Open the data3.csv file in a Notepad++ text editor. Notice that the line break type on the bottom right corner is set to Windows (CR LF). Refer to screenshot3.png.
  • This bug is not reproducible for line break type Windows (CR LF) if the last column of data contains a comma at the end of a value.

Schritte zur Reproduzierung