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.15

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.15
File Size Uploaded Provenance Actions
ExportCsvToInflux-0.1.15.tar.gz 13.0 kB Without provenance Details for ExportCsvToInflux-0.1.15.tar.gz

Release files / ExportCsvToInflux-0.1.15.tar.gz

Download URL ExportCsvToInflux-0.1.15.tar.gz
Size 13.0 kB
Tags Source
SHA-256 checksum
How to use checksums
0d2f3317c2df3b55b07d2ad1f8edef792024a712dfb24336f70e03c0f76b3dd8
BLAKE2b-256 checksum
How to use checksums
9f9f616e9235594c3bc26b760632bb30be60cef4ae11efd2cfccea48fd862f16
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.15

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