Metadata-Version: 2.1
Name: mds-csv-reader
Version: 1.0.4
Summary: Convert csv-file to list of dictinaries
Home-page: https://www.m-ds.de/
Author: martin-data services
Author-email: service@m-ds.de
License: GPL-3
Keywords: csv convert
Platform: UNKNOWN
Classifier: Development Status :: 5 - Production/Stable
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: BSD License
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 2.6
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3.4
Classifier: Programming Language :: Python :: 3.5
Classifier: Programming Language :: Python :: 3.6
Classifier: Topic :: Software Development :: Libraries :: Python Modules

mds-csv-reader
==============
Read a csv-file, converts to list of dictionaries.

Install
=======
pip install mds-csv-reader

Howto
=====

Syntax
------

::

  import_csv_file(
         csvfile,                          # file or string
         firstline=True,                   # first line contains column names
         decimalremove=['€', 'EUR', '.'],  # remove these strings from decimal columns
         ignline=[1, 2, ...],              # skip these lines
         ignore_leer=['<column nam>',...], # ignore empty values in these columns
         encod='utf-8',                    # encoding if 'csvfile' is byte type
         )

Column names
------------

- column names must contain field type info
- allowed types: C, D, DT, T, N, L

Example
-------

NAME1,C
 type String
CREATEDATE,D,%Y-%m-%d
 type Date, detection tries defined format
CREATEDATE,D
 type Date, detection tries predefines formats
DATETIME,DT,%Y-%m-%d %H:%M
 type DateTime, detection tries defined format
DATETIME,DT
 type DateTime, detection tries predefines formats
CREATETIME,T,%H:%M
 type Time, detection tries defined format
CREATETIME,T
 type Time, detection tries predefines formats
NUMSTEP,N,10,0
 type Numeric (no decimals) --> Integer
AMOUNT,N,16,2
 type Numeric (two decimals) --> Decimal
ISENABLED,L
 Boolean (allowed: true, false, t, f, wahr, falsch, 1, 0)
default-type: String
 if convert to requested type fails


Changes
=======

*1.0.4 - 09.01.2020*

- fix: detection of boolean, import of csv-text-data

*1.0.2 - 20.12.2019*

- exteded detection of date and time formats

*1.0.0 - 17.12.2019*

- optimized detection of formatting in csv-file

*1.0.0 - 17.12.2019*

- first public version


