Search Results for "sql command line"

provide Java Record based IO routines for Fixed Width (including Text, Mainframe, Cobol and Binary) and delimited Flat files via a Record Layout (Cobol, CSV or XML). The source is now available at https://github.com/bmTas/JRecord Projects using JRecord include: * https://github.com/thospfuller/rcoboldi - Cobol File in R * https://github.com/tmalaska/CopybookInputFormat - Cobol files in Hadoop * https://github.com/gss2002/copybook_formatter * https://github.com/gss2002/ftp2hdfs...

jdbc2csv is a small command-line tool written in JAVA and can be used on all platforms, for which JRE 8 or higher is available. To connect to a specific DBMS the tool uses its JDBC driver. The result of the executed 'select' query is displayed in CSV format ( different standards are supported ). When there is an error the tool stops with exit code 1 and the error message is output on stderr. jdbc2csv is created with a main purpose to be used in shell-scripts.

xml2csv is a small command-line tool written in JAVA and can be used on all platforms, for which JRE 8 or higher is available. Examples: 1. Help java -jar xml2csv-1.0.jar --help 2. Extract nodes from xml: java -jar xml2csv-1.0.jar --nodes test/cd_catalog.xml The result is the full node name and number of repetitions: /CATALOG=1 /CATALOG/CD=26 /CATALOG/CD/TITLE=26 /CATALOG/CD/ARTIST=26 /CATALOG/CD/COUNTRY=26 /CATALOG/CD/COMPANY=26 /CATALOG/CD/PRICE=26 /CATALOG/CD/YEAR=26 3. ...

...It was created for performance engineers to be able to have a easy way to compare data from two testruns and be able to automate the comparing process of various files with scripts. There is a command line tool as well as a user interface. In case you need to compare .xml-Files you can convert them to .csv-Files with my other project CSV Transformer. The advantages by using CSV as input and output are the following: - Many applications allow an export of its data to CSV or Excel(were it could be saved to CSV) - It is possible to pre- and postprocess the data, e.g removing version numbers before comparing - It is easy to create CSV data from logfiles and other resources by using unix tools like sed or awk - CSV can be loaded into other applications, especially Excel, were it can be formatted by macros for analyzing.

...I made it in order to extract data from big XML files and gather them in files more easily opened with a spreadsheet because I didn't find anything adapted to my needs over the Internet when I needed to (Java + truly generic + self-contained algorithm + Unix like command line options + efficiency). It is packaged as an auto executable Jar for convenient command line execution but might as well be interfaced directly by a Java class as part of a broader [yet non commercial] software. It handles attributes, repeated elements, and so on, and produces results which level up with what spreadsheets generate when they import native XML (at least in its most extensive execution mode). ...

This converter bridges from the .ahn file format into GEDCOM 5.5.1, It's a command-line tool written in Java. AhnConvert allows family data, laboriously grabbed decades ago surviving into state-of-the art genealogy software products. The software "Familien Chronik" by Reiner W. Dudde was a genealogy software published by Data Becker as part of the "Goldene Serie" series, back in the 1990's. Especially in Germany this tool penetrated the market to some extent.

"Database to CSV" allows to back-up data from database(Oracle, MySQL, SQL Server) in the form of CSV files. Each table data is stored in a separate CSV file. It also allows to load data from CSV files into the database. Program can be run from UI or from command line. There's one more advanced feature which allows merging of data from CSV file to Database. It is only available from command line.

A simple java app to reformat text from one specific format to another specific format.

OSM XML to CSV conversion. POI only, polygons (and polylines, but not recommended) are approximated by centroid. Result is a 3-column table with lon, lat and value (for a particular key to be chosen beforehand).

dbUPLoader is a tool to import data from csv or MS-Excel files into a database. You can distribute data across several tables, create relationships between imported data and integrate sub queries to reference existing data.

To switch historical data quotes, from a format to a other one. For example to move historical data quotes from MetaTrader4 to NinjaTrader. Or to move historical data quotes from NinjaTrader to MetaTrader4 .