es2csv | Export from an Elasticsearch into a CSV file | CSV Processing library

by taraslayshchuk Python Version: 5.5.2 License: Apache-2.0

X-Ray Key Features Code Snippets(1)Community Discussions(3)Vulnerabilities Install Support

kandi X-RAY | es2csv Summary

es2csv is a Python library typically used in Utilities, CSV Processing applications. es2csv has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has low support. You can install using 'pip install es2csv' or download it from GitHub, PyPI.

Export from an Elasticsearch into a CSV file

Support

Quality

Security

License

Reuse

Support

es2csv has a low active ecosystem.

It has 506 star(s) with 195 fork(s). There are 23 watchers for this library.

It had no major release in the last 12 months.

There are 20 open issues and 38 have been closed. On average issues are closed in 49 days. There are 18 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of es2csv is 5.5.2

Quality

es2csv has 0 bugs and 0 code smells.

Security

es2csv has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

es2csv code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

es2csv is licensed under the Apache-2.0 License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

es2csv releases are available to install and integrate.

Deployable package is available in PyPI.

Build file is available. You can build the component from source.

es2csv saves you 122 person hours of effort in developing the same functionality from scratch.

It has 307 lines of code, 18 functions and 3 files.

It has high code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed es2csv and discovered the below as its top functions. This is intended to give you an instant insight into es2csv implemented functionality, and help decide if they suit your requirements.

Perform a search query
Write hit list to file
Retry decorator
Write the results to a csv file
Get the version string
Check if index_prefixes is set
Creates elasticsearch connection
Get the description
Remove all scroll ids
Read a file

Get all kandi verified functions for this library.

es2csv Key Features

No Key Features are available at this moment for es2csv.

es2csv Examples and Code Snippets

python3 UnicodeEncodeError: 'charmap' codec can't encode characters in position 95-98: character maps to

Python

Lines of Code : 2

License : Strong Copyleft (CC BY-SA 4.0)

Copy

for line in open(self.tmp_file, 'r', encoding='utf-8'):

Community Discussions

Trending Discussions on es2csv

python3 UnicodeEncodeError: 'charmap' codec can't encode characters in position 95-98: character maps to

Cannot change delimiter of output csv for es2csv cli

Exporting the entire database for elastic search in csv

QUESTION

python3 UnicodeEncodeError: 'charmap' codec can't encode characters in position 95-98: character maps to

Asked 2019-Jan-08 at 18:51

A month ago I encountered this Github: https://github.com/taraslayshchuk/es2csv

I installed this package via pip3 in Linux ubuntu. When I wanted to use this package, I encountered the problem that this package is meant for python2. I dived into the code and soon I found the problem.

...

ANSWER

Answered 2017-Jun-06 at 22:00

It's due to the default behaviour of open in Python 3. By default, Python 3 will open files in Text mode, which means that it also has to apply a text decoding, such as utf-8 or ASCII, for every character it reads.

Python will use your locale to determine the most suitable encoding. On OS X and Linux, this is usually UTF-8. On Windows, it'll use an 8-bit character set, such windows-1252, to match the behaviour of Notepad.

As an 8-bit character set only has a limited number of characters, it's very easy to end up trying to write a character not supported by the character set. For example, if you tried to write a Hebrew character with Windows-1252, the Western European character set.

To resolve your problem, you simply need to override the automatic encoding selection in open and hardcode it to use UTF-8:

Source https://stackoverflow.com/questions/44391671

QUESTION

Cannot change delimiter of output csv for es2csv cli

Asked 2018-Aug-23 at 09:28

Could you please suggest what i am doing wrong? i cannot change the delimiter of the output file using es2csv cli tool.

...

ANSWER

Answered 2018-Aug-23 at 09:28

Actually this issue has been reported here: https://github.com/taraslayshchuk/es2csv/issues/51

If you don't want to wait for the fix to be released, you can change line 212 of es2csv.py like this and it will work:

Source https://stackoverflow.com/questions/51981417

QUESTION

Exporting the entire database for elastic search in csv

Asked 2017-May-02 at 17:07

Any ideas on how to export the entire database in elastic search in csv? I just need one index to be exported.

I tried the following python plugin but elastic search as a service provider is complaining on root certificates:

https://github.com/taraslayshchuk/es2csv/blob/master/README.rst

es2csv -i leads -a user:password -u https://host.us-east-1.aws.found.io:9243 -q '' -o database.csv

but I get: elasticsearch.exceptions.ImproperlyConfigured: Root certificates are missing for certificate validation. Either pass them in using the ca_certs parameter or install certifi to use it automatically.

help? I'm using Elasticsearch.co as a service for my elastic search

...

ANSWER

Answered 2017-Mar-26 at 19:13

You can use Logstash to export an index to CSV:

Source https://stackoverflow.com/questions/43025236

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install es2csv

You can install using 'pip install es2csv' or download it from GitHub, PyPI.
You can use es2csv like any standard Python library. You will need to make sure that you have a development environment consisting of a Python distribution including header files, a compiler, pip, and git installed. Make sure that your pip, setuptools, and wheel are up to date. When using pip it is generally recommended to install packages in a virtual environment to avoid changes to the system.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: