I’m getting the following data generated:
{ "_id": { "$oid": "5ea47836fc13ae739a000000" }, "user_id": "2", "gender": 2, "location": { "type": "Point", "coordinates": [ 28.153607, 12.9028236 ] }, "videoId": "SImfU9h", "videoUrl": "https://pagesperso-orange.fr/nisi/volutpat/eleifend/donec/ut/dolor.png", "videoTags": [ "High Availability Clustering", "Sports Nutrition", "PTMS" ] }
for the most part this is fine, but randomly among the dataset the section with coordinates has quotes put in them as follows:
"location": { "type": "Point", "coordinates": [ 28.153607, "12.9028236" <---unnecessary quotes ] },
this creates import issues and the entire import stops as soon as something like that is encountered. How can I fix this?