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 »
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 »
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 »
PostedApril 15, 2016 91.2k views MongoDB Backups Ubuntu MongoDB is one of the most popular NoSQL database engines. It is famous for being scalable, powerful, reliable and easy to use. In this article we’ll show you how to back up, restore, and migrate your MongoDB databases. Importing and exporting a database means dealing with data… Leer más »
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 »
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
TOP clause Limits the rows returned by an OpenEdge SQL query at the statement level and is supported in subqueries. Syntax TOP n[ column_name [, column_name ] …..| * ] Parameters n Indicates the number of records per table. [ column_name [, column_name ] …..| * ] Indicates the columns within a table. When the… Leer más »
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 »
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 »