I can't load all documents from csv file using python

Elastic Stack Elasticsearch
1

i'm trying to load csv file to Elasticsearch using python

from elasticsearch import Elasticsearch, helpers
import csv

# Elastic search configuation

es = Elasticsearch('http://IP:8081')

# Creating index
es.indices.create(index="suivipsi")

# Looking if the index exists
#es.indices.exists(index="firstindex")

# Open csv file and bulk upload
with open('Suivi_des_PSI_2.csv',encoding='utf-8') as f:
    reader = csv.DictReader(f)
    helpers.bulk(es, reader, index='suivipsi')

my csv file hase 8793 line but when index is created in elasticseach i found that just 334 document loaded

psi
psi1050×195 17.5 KB

2

You probably want to check the response from Elasticsearch to see if there are any errors.
You can also check the Elasticsearch logs to see if there's anything there that might provide some hints.

3

@warkolm i found that he can load empty date documents is there a way to load that lines eventhought they are empty !!!

4

You will need to provide a date in there for it to be accepted.