Python script to convert DBF database file to CSV

First download dbfpy: http://sourceforge.net/projects/dbfpy/files/latest/download?source=files Then install: sudo python setup.py install To convert DBF file to CSV: ./dbf2csv database.dbf #!/usr/bin/python import csv from dbfpy import dbf import os import sys filename = sys.argv[1] if filename.endswith(‘.dbf’): print “Converting %s to csv” % filename csv_fn = filename[:-4]+ “.csv” with open(csv_fn,’wb’) as csvfile: in_db = dbf.Dbf(filename) out_csv = csv.writer(csvfile)Seguir leyendo

csvkit 0.9.0 (beta)

https://csvkit.readthedocs.io/en/0.9.0/   About csvkit is a suite of utilities for converting to and working with CSV, the king of tabular file formats. It is inspired by pdftk, gdal and the original csvcut utility by Joe Germuska and Aaron Bycoffe.   Input in2csv sql2csv Processing csvclean csvcut csvgrep csvjoin csvsort csvstack Output (and Analysis) csvformat csvjsonSeguir leyendo

AquaData Studio

How to connect progress jdbc:datadirect:openedge://192.168.1.1:13000;databaseName=dbname[-mdbq:listadb];defaultSchema=pub com.ddtek.jdbc.openedge.OpenEdgeDriver C:\Progress11\OpenEdge\java\openedge.jar Fix width progress sql dbtool dbname

quick create root CA and self signed for chrome 58+

create RootCA first cat createRootCa.sh #!/usr/bin/env bash mkdir /root/ca/ openssl genrsa -des3 -out /root/ca/rootCA.key 2048 openssl req -x509 -new -nodes -key /root/ca/rootCA.key -sha256 -days 7300 -out /root/ca/rootCA.pem Create server.csr.cnf [req] default_bits = 2048 prompt = no default_md = sha256 distinguished_name = req_distinguished_name [ req_distinguished_name ] # See <https://en.wikipedia.org/wiki/Certificate_signing_request>. countryName = MX stateOrProvinceName = MX localityNameSeguir leyendo