Search Results for "database csv"
Sort By:
Showing 37 open source projects for "database csv"
View related business solutions-
$300 Free Credits for Your Google Cloud ProjectsLaunch your next project with $300 in free Google Cloud credits—no strings attached. Test, build, and deploy without risk. Use your credits across the entire Google Cloud platform to find what works best for your needs. After your credits are used, continue with always-free tier services. Only pay when you're ready to scale. Sign up in minutes and start exploring.
-
Error to trace to log to deploy. One click. No SSH.AppSignal links every error to the trace, the trace to the log, the log to the deploy that shipped it.
-
1
Countries States Cities Database
Discover our global repository of countries, states, and cities
Full Database of city state country available in JSON, SQL, XML, YAML & CSV format. All Countries, States and cities are Covered and populated with Different Combinations and versions. The API database is regularly updated to ensure the latest data is available to users. Discover our global repository of countries, states, and cities! Get comprehensive data in JSON, SQL, XML, YAML, and CSV formats. -
2
sq data wrangler
sq data wrangler
sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. sq executes jq-like queries, or database-native SQL. It can join across sources: join a CSV file to a Postgres table, or MySQL with Excel. sq outputs to a multitude of formats including JSON, Excel, CSV, HTML, Markdown and XML, and can insert query results directly to a SQL database. sq can also inspect sources to view metadata about the source structure (tables, columns, size). ... -
3
Miller
Miller is like awk, sed, cut, join, and sort for name-indexed data
Miller is like awk, sed, cut, join, and sort for data formats such as CSV, TSV, JSON, JSON Lines, and positionally-indexed. With Miller, you get to use named fields without needing to count positional indices, using familiar formats such as CSV, TSV, JSON, JSON Lines, and positionally-indexed. Then, on the fly, you can add new fields which are functions of existing fields, drop fields, sort, aggregate statistically, pretty-print, and more. Miller operates on key-value-pair data while the... -
4
A read-only JDBC driver for Java that uses Comma Separated Value (CSV) files as database tables. Ideal for writing data import programs and conversion programs.
-
MongoDB Atlas runs apps anywhereMongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
-
5
RecordEditor
Editor for Fixed Width, Csv and Existing Xml files.
The RecordEditor is a Data File editor for Flat Files (delimited and fixed field position). It supports Unix / PC / Legacy (e.g. Mainframe) file formats, both Text and binary files. The Editor uses a Record-Layout description to format the files. This is ideal for Fixed width (Text or Binary) files, Cobol Data Files, Mainframe files and complicated Csv files. Cobol Copybooks can be used to format Cobol Data files. As well as an editor, The following utilities are supplied * Formatted... -
6
pyDaSSQLiteMan
An easy way to manage SQLite databases and query CSV files
Welcome to the project page for pyDaSSQLiteMan (Python Data and SQLite Manager). This application is a Python Tkinter application designed to enable easy SQLite database file manipulation, and an easy method to run SQL styled queries on CSV files. If you're not downloading the pre-compiled executable you will need Python to run this app. You can download it from http://www.python.org/ . I'd recommend something after version 3. Testing has been Windows based. SQLite is a free database format released into the public domain. ... -
7
csv2odf
csv2odf can convert csv data to formatted spreadsheets and documents.
csv2odf can create business intelligence reports from csv data sources with output to ods, odt, html, xlsx, or docx documents. It uses a template file that you design to control the layout, fonts, and colors. Just query your database with output to csv (or tsv), then use csv2odf to insert the data into your template to produce a nice looking formatted output. It is a command line tool and you can automate the generation of reports by using scripts and cron. -
8
asammdf
Fast Python reader and editor for ASAM MDF / MF4 (Measurement Format)
*asammdf* is a fast Python parser and editor for ASAM (Associtation for Standardisation of Automation and Measuring Systems) MDF / MF4 (Measurement Data Format) files. It supports MDF versions 2 (.dat), 3 (.mdf) and 4 (.mf4). *asammdf* works on Python 2.7, and Python >= 3.4 -
9
Java Data Loader
jdl is a loader utility for moving data from (CSV or XML) into a db.
usage: java [-options] -jar jarfile -c <arg> -d <arg> [-l <arg>] -c,--conn <arg> conn file -d,--data <arg> data file -l,--load <arg> load file Into src/test/resources you can find some sample (conn, data and load) files. -
Stop Cyber Threats with VM-Series Next-Gen Firewall on AzureGain integrated visibility across all traffic in a single pass. Deploy Palo Alto Networks VM-Series to determine application identity and content while automating security policy updates via rich APIs.
-
10
xsd2pgschema
Relational database replication tool based on XML Schema
xsd2pgschema is a Java application suite, which converts XML Schema 1.1 (hierarchical data model) to PostgreSQL DDL (relational data model) and supports XML data migration into PostgreSQL based on the XML Schema without defects on information content. It also supports full-text indexing via either Apache Lucene or Sphinx Search utilizing the relational data model. File conversion from XML to CSV, TSV, or JSON is possible as well as mapping XML Schema to JSON Schema. Obtained PostgreSQL database can be optimized at user's discretion. Moreover, differential update, and XPath query evaluation over PostgreSQL are possible. PgSchema server, serialized relational data model server, can be used to speed up the analysis of complex XML Schema. ... -
11
ldif-extract
Extrect selected entries from LDIF files like grep
ldif-extract is a small 'grep' like tool to extract and convert data from LDIF files. It could be used standalone or also in a pipe together with other tools like ldapsearch. -
12
GETL
ETL engine based on Groovy
P.S. Dear friends. Repository migration to https://github.com/ascrus/getl . You can download jar file from this site or maven. GETL - based package in Groovy, which automates the work of loading and transforming data. His name is an acronym for «Groovy ETL». GETL is a set of libraries of pre-built classes and objects that can be used to solve problems unpacking, transform and load data into programs written in Groovy, or Java, as well as from any software that supports the work with... -
13
Bots-ediint open source edi translator
open source edi translator
Bots-ediint is a file translator for EDI (Electronic Data Interchange). Translate files and databases data format to another one: edifact, x12, tradacoms, xml, json, raw, database (postgres, sqlite, mysql, oracle, ...) and more. Bots-ediint is based on Bots https://bots.sourceforge.net Support Python 2 and Python 3 AS2 communications are carried out with my external software that could work in standalone and/or in a Bots channel to send and receive AS2 messages (SYNC and... -
14
Metl ETL Data Integration
Simple message-based, web-based ETL integration
Metl is a simple, web-based ETL tool that allows for data integrations including database, files, messaging, and web services. Supports RDBMS, SOAP, HTTP, FTP, SFTP, XML, FIXLEN, CSV, JSON, ZIP, and more. Metl implements scheduled integration tasks without the need for custom coding or heavy infrastructure. It can be deployed in the cloud or in an internal data center, and it was built to allow developers to extend it with custom components. -
15
jdbc2csv.jar
Command-line sql JDBC tool
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. Relatively easy to configurate,... -
16
csvkml
Converts CSV and ODS to KML (KMZ)
CSVKML is a tool that can generate a KML or KMZ map file starting from a database of Points of Interes (POI) in CSV or ODS format. Generated map is suitable for Google Earth. Platform independent, requires Java. -
17
PortaFIB
Portafirmes de les Illes Balears
== MOGUT A GITHUB: https://github.com/GovernIB/portafib == PortaFIB és un portafirmes “digital” desenvolupat en el departament d'Administració Electrònica de la Fundació Bit per encàrrec del Govern de les Illes Balears.. Les seves característiques principals són: • Permet firmar documents de tipus PDF • Permet fitxers annexos al document principal • Suport de càrrecs • Gestió de flux de firmes i plantilles de flux de firmes • Realitzar peticions de firma via web o WebServices, és a... -
18
AhnConvert
Converts .ahn files into comma-separated .txt and GEDCOM 5.5.1 files
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. Generating a project and... -
19
"xmlsh" is derived from the design and goals the unix shell and core commands but with XML expressions and documents added as core features to the shell. xmlsh can be used as a drop-in replacement for scripting xml transformations instead of sh.
-
20
SQLiteToolBox
Tools for SQLite database file
SQLiteDBinfo - expend SQLite database Info SQLite2csv - SQLite-Database to CSV converter -
21
Database to CSV
"Database to CSV" project stores/loads data between database and CSVs
"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. -
22
-
23
fw2csv
Convert data file from fixed width format table to CSV
Fixed width data files are probably the most annoying data to import into database. This utility allows user to insert user-defined column separators into user-defided positions of flat file table given in fixed-width format. I am using this utility to import astronomical catalogs provided as flat tables at CDS ftp-server into postgresql; Build: $ make all [cc={icc|gcc}] Install: $ make install [prefix=/path/to/your/bin/directory] Example of usage: $ gzip -dc table.dat.gz | fw2csv --stops=4,10,11,20,30,36 -d '|' -header 1 | psql wsdb -c "copy mytable from stdin with csv delimiter '|'" For the list of available options call $ fw2csv --help -
24
dhcp-gen
dhcpd.conf generator
dhcp-gen is a perl script that was written by me and Trond Erik Dalho to simplify editing dhcpd.conf for adding static ip to computers and equipment on our school. It also made it easier to do manage the network by limiting some computers access to the local network only. Creating closed networks. And it also worked as a database over all our computers and equipment, making it easier to keep track of everything. All information about equipment is stored inside csv files which are comma separated. -
25
The csvdatamix project aims to randomize CSV input data files in order to conceal the original state of the data. Similar to data masking or data transformation. Also has mapping abilities to translate back to the original state of the data.
