#community-help

Converting CSV Geo Locations to Single Array for Typesense in JSON

TLDR Kshitij asked for help to convert csv geo locations to a single array for Typesense in JSON. Jerson suggested using a JS script, and Kishore Nallan confirmed the need for a script. Kshitij decided on a Python script.

Powered by Struct AI

1

1

4
20mo
Solved
Join the chat
Mar 08, 2022 (20 months ago)
Kshitij
Photo of md5-04d472d89b7b8e48d5d789355d4f48b5
Kshitij
05:02 AM
I am facing an issue and hoping if someone has already solved this - I have csv files with geo locations as Lat and long but they are in two different columns. Now the typesense wants it in single array when converting csv to json. Was wondering if someone has solved this issue already?
Jerson
Photo of md5-a1cd0747040f227dcfb695d136e5e90f
Jerson
05:12 AM
Mine might be outdated approach, but not for exact this, but similar problem, I end up wrote a JS script , itereate the records and populate the expected array..not sure if there is any better approach

1

Kshitij
Photo of md5-04d472d89b7b8e48d5d789355d4f48b5
Kshitij
05:32 AM
Okay this seems like the only way. I will go with python script as i need to make a dashboard for people to upload the said file to process the whole data as a batch
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
06:41 AM
No other way to do it other than transforming the data through a script first.

1