Select to view content in your preferred language

geoEvent input of a CSV file --

78
2
Sunday
JeffSilberberg
Frequent Contributor

Have a large CSV file with 26 Columns.  I can not get this file to import -- 

I defined the Input as Field1 - Field26 type String - 

But Field 20 is a "ellipse.polygon.coordinates" and when I try to import it, geoEvent fails to parse this, and I sort of think it's because Field 20 is inside double Quotes, but I am not sure. 

CSV Parse error. Error: vr3a6f68dda1283c12f47137907a6d1658,-114.1885,39.9274,1758412824,2025-09-21T00:00:24+00:00,1758412824629,2025-09-21T00:00:24.629+00:00,ic,6900,7,1758412824,2025-09-21T00:00:24+00:00,,,,,,,MultiPolygon,"[array([array([array([-114.18623352, 39.92692947]),.
 
The Full Field 19 contains "ellipse.polygon.type" value - MultiPolygon 
 
While Field 20 contains "ellipse_polygon_coordinates" value - 
"[array([array([array([-114.18623352, 39.92692947]),
array([-114.18623352, 39.92786407]),
array([-114.18684387, 39.92867279]),
array([-114.1878891 , 39.92913437]),
array([-114.18910217, 39.92913437]),
array([-114.1901474 , 39.92867279]),
array([-114.19075775, 39.92786407]),
array([-114.19075775, 39.92692947]),
array([-114.1901474 , 39.92612457]),
array([-114.18910217, 39.92565918]),
array([-114.1878891 , 39.92565918]),
array([-114.18684387, 39.92612457]),
array([-114.18623352, 39.92692947])], dtype=object)],
dtype=object) ]",
 

  I have tried changing Field 20 Cardinality to Multi, but that did not help.  

  Hoping someone who has more experience than me might have an answer -- 

   TIA -- 

 

 

0 Kudos
2 Replies
JeffSilberberg
Frequent Contributor

A little more data from the log -- Type = Error 

Com.esri.ges.adapter.text.TextInboundAdapter    CSV Parse error. Error: dtype=object) ]",105,200,200,656,656,reprocessedV1.
 
Com.esri.ges.adapter.text.TextInboundAdapter    CSV Parse error. Error: vr3a6f68dda1283c12f47137907a6d1658,-114.1885,39.9274,1758412824,2025-09-21T00:00:24+00:00,1758412824629,2025-09-21T00:00:24.629+00:00,ic,6900,7,1758412824,2025-09-21T00:00:24+00:00,,,,,,,MultiPolygon,"[array([array([array([-114.18623352, 39.92692947]),.
 
 
0 Kudos
JeffSilberberg
Frequent Contributor

 

Just thought I would bump this to see if anyone has any helpful pointers/tips. 

 

 

0 Kudos