30 projects tagged "csv"
StelsCSV is a JDBC driver that allows performing SQL statements and other JDBC operations upon text files (comma separated, tab-separated, fixed length, etc.). Using this driver, users can easily create a simple database consisting of plain text files. The driver can be used for writing data importing programs and migration tools. It supports most keywords of ANSI SQL92, table joins, INSERT, UPDATE, and DELETE statements, data types, aggregate, converting, string, and user-defined SQL functions.
Ldap Synchronization Connector reads from any data source including databases, LDAP directories, or files and transforms and compares this data to an LDAP directory. These connectors can then be used to continuously synchronize a data source to a directory, for a one shot import, or to compare differences by outputting CSV or LDIF format reports. It offers a powerful transformation engine based on a scripting language to easily manipulate data on the fly. Various identity management functions are included for directory-specific compatibility - most notably Active Directory (changing passwords, account status, last logon, etc.).
Sql2xml is a CGI program that lets you request a SQL query and convert it to JSON, CSV, XML or INI through a Web server. Sql2xml supports requests from multiple users and for multiple databases. It is intended for developers who do not have direct access to database servers due to firewalls or other restrictions.
SuperSimpleNews is a news script for Web sites. It doesn't require a database, since all news articles are stored in simple CSV files. It includes a password protected administrative backend for adding, editing, and deleting articles. widgEditor is used for editing the text. Example scripts are included to get you setup quickly. RSS support is included by default.
libcsv_parser++ is a C++ library for parsing text files to extract records and fields. The records can be delimited with any set of characters. It makes the following assumptions: the record terminator is only one character in length; the field terminator is only one character in length; and the fields are enclosed by single characters, if any. The parser can handle documents where fields are always enclosed, not enclosed at all, or optionally enclosed. When fields are strictly all enclosed, there is an assumption that any enclosure characters within the field are escaped by placing a backslash in front of the enclosure character. The software could be ported to Windows with very little effort.
jSmaTeP assists in the use of Java for processing import and export data by configuring a data structure rather than by programming it. The structure of the import data is specified in an XML file. jSmaTeP then generates a value object representing exactly one row or record in the import file based on a given XML data configuration. This means that if the import or export format changes, only the XML data configuration needs to be changed to match it.
loadcsv is a small utility to load data from CSV files into a database. It gets the names of the columns from the first row of the CSV file. It supports MySQL, PostgresSQL, and sqlite, but can be used with other SQL databases by using the utility to generate SQL statements and sending them to the database.