Archivo por meses: febrero 2018

How to set the PUB qualifier in the Windows registry to avoid prefixing it in existing reports?

Environment Product: Progress Version: 9.1x Product: OpenEdge Version: 10.x OS: Windows Other: Crystal Reports Question/Problem Description How to avoid setting the pub qualifier before each table name in a Crystal Report ? How to set the pub qualifier in Windows registry? How to use existing SQL-89 Crystal Reports with SQL-92 ? How to set the… Leer más: How to set the PUB qualifier in the Windows registry… »

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)… Leer más: Python script to convert DBF database file to CSV »

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 csvjson… Leer más: csvkit 0.9.0 (beta) »

Resize a Linux Root Partition Without Rebooting resize alienvault

Introduction A typical Linux server deployed from a ProfitBricks supplied image has a single storage volume, /dev/vda. If we take a look at that using fdisk we will see that the disk is divided into two partitions. The first one, /dev/vda1, is the boot partition where the OS resides. The second partition, /dev/vda2, is configured as swap space. root@debian:~# fdisk… Leer más: Resize a Linux Root Partition Without Rebooting resize alienvault »

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 localityName… Leer más: quick create root CA and self signed for chrome 58+ »

Git 2.9 by Software Collections centos 7 rhel 7

rh-git29 – A release of Git, a distributed revision control system with a decentralized architecture. As opposed to centralized version control systems with a client-server model, Git ensures that each working copy of a Git repository is its exact copy with complete revision history. EL6 tests EL7 tests Instructions You can get started in three… Leer más: Git 2.9 by Software Collections centos 7 rhel 7 »