Elasticsearch CSV import via File Data Visualizer (ML) - Convert latitude and longitude column to geo_point using ingest pipeline

elasticsearch_filedatavisualizer_geopoint_ingest_pipeline_conversion.md

1. Choose your CSV file to import including your coordinates data and upload it

location.csv

lat,long, timestamp
41.12,-71.34,1569476964
38.85896,-106.01665,1569476964
65.47629,18.61576,1569476964

2. Click on import and go to the Advanced tab
3. Set the mapping

{
  " timestamp": {
    "type": "date",
    "format": "epoch_second"
  },
  "@timestamp": {
    "type": "date"
  },
  "経度": {
    "type": "long"
  },
  "緯度": {
    "type": "long"
  },
  "location": {
    "type": "geo_point"
  }
}

4. Define the ingest pipeline (to set location geo_point)

{
  "description" : "sets location geo_point with lat, lon",
  "processors": [{
  "set": {
    "field": "location",
    "value": "{{lat}}, {{lon}}"
  }
  }]
}

5. Import

@shkazmi89
Error parsing mappings: Unexpected string in JSON at position 254 looks like a JSON parsing issue.