# Uploding a csv file from kibana with updating mapping

**URL:** <https://discuss.elastic.co/t/uploding-a-csv-file-from-kibana-with-updating-mapping/187621>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-machine-learning\
**Created:** [June 26, 2019, 4:11pm UTC](https://discuss.elastic.co/t/uploding-a-csv-file-from-kibana-with-updating-mapping/187621 "2019-06-26T16:11:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adil\_Bakkouri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adil_bakkouri/32/42340_2.png) [@Adil\_Bakkouri](https://discuss.elastic.co/u/Adil_Bakkouri)\
**Post date:** [June 26, 2019, 4:11pm UTC](https://discuss.elastic.co/t/uploding-a-csv-file-from-kibana-with-updating-mapping/187621/1 "2019-06-26T16:11:35Z")

</div>

Hello,  
I'm trying to upload my csv file to elasticsearch via Kibana machine learning tool,  
I succeeded the add but i want to redefine my mapping, so juste before creating the index, i update my mapping to this :  
{

```
  "Annee": {
    "type": "float"
  },
  "Comp": {
    "type": "nested", 
    "include_in_parent": true, 
    "properties": {
            "skill": { "type": "text" }
          }
  },
  "Etudes": {
    "type": "keyword"
  },
  "Experience": {
    "type": "nested", 
    "include_in_parent": true, 
    "properties": {
            "exp": { "type": "text" },
            "date_debut":{"type":"date"
            },
            "date_fin":{"type":"date"
            }
          }
  },
  "Formation": {
    "type": "nested", 
    "include_in_parent": true, 
    "properties": {
            "form": { "type": "text" }
          }
  },
  "ID_CV": {
    "type": "keyword"
  },
  "Langues": {
    "type": "nested", 
    "include_in_parent": true, 
    "properties": {
            "coef": { "type": "float"},
            "langf":{"type":"text"}
          }
  },
  "Title": {
    "type": "text"
  },
  "cv_content": {
    "type": "text"
  }
}

```

I'm putting here a line of my CSV file :

```
|Experience|Formation|Langues|Annee|Etudes|ID_CV|cv_content|Title|Comp|
|---|---|---|---|---|---|---|---|---|
|[{ airbus group pmo / conduite du changement },{04/ 2014},{09/ 2014}, { albatec consultant en strategie },{09/ 2013},{03/ 2014}, { village center assistant direction },{04/ 2013},{08/ 2013}]|[{ master 2, management de projet et innovation (eum clermont-ferrand) management de projet & planification, strategie et innovation (methode agile : scrum), management de la connaissance, analyse financiere & management daffaire, conduite du changement. licence 3, ingenierie du management (iup clermont-ferrand) management & economie & marketing, controle de gestion & comptabilite, droit du travail, ressource humaine & management humain, bts comptabilite & gestion comptabilite & controle de gestion analyse financiere & analyse des couts fiscalite prevision & budgetisation},{master 2, eum clermont-ferrand (reseau iae) annee 2014}]|[{85, anglais}, {60, espagnol}]|0|bac + 5|0| Fonction Trigramme ou nom - Annees dexperience |Consultant Devoteam|[{ Outils Bureautiques },{ Messagerie Outlook Adm },{ Pack office },{ Systeme Microsoft },{ Apple },{ Androide },{ SharePoint Adm },{ MySQL },{ MS Access },{ MS Project Outils Decisionnels },{ Bizagi },{ Resalys },{ Ciell },{ Cegid , Gestion de projet },{ Planification },{ Budgetisation et analyse financiere },{ Coordination de projet },{ Gestion des crise },{ Chef de projet },{ Communication },{ Recherche de linformation},{ Capitalisation de la connaissance },{Management dequipe }]|

```

The Error i got is :

```
Some documents could not be imported

200 out of 200 documents could not be imported. This could be due to lines not matching the Grok pattern.

Failed documents

0: object mapping for [Experience] tried to parse field [Experience] as object, but found a concrete value
.
.
.
200: object mapping for [Experience] tried to parse field [Experience] as object, but found a concrete value

```

i doesnt import any document !  
Can you help me please.

---

<div class="post-metadata">

**Author:** ![richcollier](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/richcollier/32/115035_2.png) [@richcollier](https://discuss.elastic.co/u/richcollier)\
**Post date:** [June 28, 2019, 1:43pm UTC](https://discuss.elastic.co/t/uploding-a-csv-file-from-kibana-with-updating-mapping/187621/2 "2019-06-28T13:43:49Z")

</div>

Hello, the CSV uploader expects simple, flat CSV files with single-value fields - not nested objects

Instead, use [Logstash or an ingest node](https://www.elastic.co/blog/should-i-use-logstash-or-elasticsearch-ingest-nodes) to get your data into Elasticsearch.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 26, 2019, 1:43pm UTC](https://discuss.elastic.co/t/uploding-a-csv-file-from-kibana-with-updating-mapping/187621/3 "2019-07-26T13:43:50Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.