roskakori / cutplace

validate data stored in CSV, PRN, ODS or Excel files
http://cutplace.readthedocs.org/
GNU Lesser General Public License v3.0
18 stars 20 forks source link

Add option to build bcp import script #99

Open roskakori opened 9 years ago

roskakori commented 9 years ago

Goal: cutplace --sql bcp some_icd.ods create a bcp script to import data that conform to the ICD.

bcp documentation: https://msdn.microsoft.com/en-us/library/ms162802.aspx

Note: bcp has several limitations that prevent it from processing certain constructs in valid CSV files, so these scripts will have the same limitation.

In case cutplace can detect that a field cannot be processed by bcp no matter what, the conversion should fail. TODO: Are there any such conditions?