Skip to main content

Export CSV To Influx

Export CSV To Influx: Process CSV data, and export the data to influx db

Install

Use the pip to install the library. Then the binary export_csv_to_influx is ready.

` pip install ExportCsvToInflux `

Features

  1. Allow to use binary export_csv_to_influx to run exporter

  2. Allow to check dozens of csv files in a folder

  3. Auto convert csv data to int/float/string in Influx

  4. Allow to limit string length in Influx

  5. Allow to judge the csv has new data or not

  6. Allow to use the latest file modify time as time column

  7. Auto Create database if not exist

  8. Allow to drop database before inserting data

  9. Allow to drop measurements before inserting data

  10. Allow to match or filter the data by using string or regex.

  11. Allow to count, and generate count measurement

Command Arguments

You could use export_csv_to_influx -h to see the help guide.

-c, –csv, Input CSV file path, or the folder path. Mandatory

-d, –delimiter, CSV delimiter. Default: ‘,’.

-lt, –lineterminator, CSV lineterminator. Default: ‘n’.

-s, –server, InfluxDB Server address. Default: localhost:8086.

-u, –user, InfluxDB User name. Default: admin

-p, –password, InfluxDB Password. Default: admin

-db, –dbname, InfluxDB Database name. Mandatory

-m, –measurement, Measurement name. Mandatory

-t, –time_column, Timestamp column name. Default: timestamp. If no timestamp column, the timestamp is set to the last file modify time for whole csv rows.

-tf, –time_format, Timestamp format. Default: ‘%Y-%m-%d %H:%M:%S’ e.g.: 1970-01-01 00:00:00.

-tz, –time_zone, Timezone of supplied data. Default: UTC.

-fc, –field_columns, List of csv columns to use as fields, separated by comma. Mandatory

-tc, –tag_columns, List of csv columns to use as tags, separated by comma. Mandatory

-b, –batch_size, Batch size when inserting data to influx. Default: 500.

-lslc, –limit_string_length_columns, Limit string length column, separated by comma. Default: None.

-ls, –limit_length, Limit length. Default: 20.

-dd, –drop_database, Drop database before inserting data. Default: False.

-dm, –drop_measurement, Drop measurement before inserting data. Default: False.

-mc, –match_columns, Match the data you want to get for certain columns, separated by comma. Match Rule: All matches, then match. Default: None.

-mbs, –match_by_string, Match by string, separated by comma. Default: None.

-mbr, –match_by_regex, Match by regex, separated by comma. Default: None.

-fic, –filter_columns, Filter the data you want to filter for certain columns, separated by comma. Filter Rule: Any one filter success, the filter. Default: None.

-fibs, –filter_by_string, Filter by string, separated by comma. Default: None.

-fibr, –filter_by_regex, Filter by regex, separated by comma. Default: None.

-ecm, –enable_count_measurement, Enable count measurement. Default: False.

-fi, –force_insert_even_csv_no_update, Force insert data to influx, even csv no update. Default: False.

For more info, please refer to the https://github.com/Bugazelle/export-csv-to-influx

Metadata

Release files for ExportCsvToInflux 0.1.14

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for ExportCsvToInflux 0.1.14
File Size Uploaded Provenance Actions
ExportCsvToInflux-0.1.14.tar.gz 13.0 kB Without provenance Details for ExportCsvToInflux-0.1.14.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for ExportCsvToInflux 0.1.14
File Interpreter ABI Platform Actions
ExportCsvToInflux-0.1.14-py2.7.egg Legacy Egg format - - Details for ExportCsvToInflux-0.1.14-py2.7.egg

Total release size: 38.8 kB

Release files / ExportCsvToInflux-0.1.14.tar.gz

Download URL ExportCsvToInflux-0.1.14.tar.gz
Size 13.0 kB
Tags Source
SHA-256 checksum
How to use checksums
83ff19d3d03fca61a5c041557024257ac7997f43f452377b0b75c4d3271543d8
BLAKE2b-256 checksum
How to use checksums
d56ebb538dbb68ee0f01bd264de5463bf1532d09a9a87ee46c46e92a614415c1
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.13.0 pkginfo/1.5.0.1 requests/2.19.1 setuptools/18.5 requests-toolbelt/0.9.1 tqdm/4.32.2 CPython/2.7.10

Release files / ExportCsvToInflux-0.1.14-py2.7.egg

Download URL ExportCsvToInflux-0.1.14-py2.7.egg
Size 25.8 kB
Tags Egg
SHA-256 checksum
How to use checksums
374d3e5f1f99c2653dbeebd21a17b7f3e160694e19105648ef6207f983602e4f
BLAKE2b-256 checksum
How to use checksums
9e414ed84919e311bbb3abca9f18499b9f907df6ce9ea333fdfc5b933be64f37
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.13.0 pkginfo/1.5.0.1 requests/2.19.1 setuptools/18.5 requests-toolbelt/0.9.1 tqdm/4.32.2 CPython/2.7.10

Security for ExportCsvToInflux 0.1.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page