Projects tagged ‘csv’ and ‘database’

KOffice is a free, integrated office suite for KDE, the K Desktop Environment. KOffice applications uses OpenDocument as their native file format when possible. The suite is released separately from ... [More] KDE. The KOffice suite includes the following applications: - KWord - A frame-based word processor - KSpread - A powerful spreadsheet application - KPresenter - A full-featured presentation program - Kexi - An environment for creating databases and applications - Kivio - A Visio®-style flowcharting application - Karbon14 - A vector drawing application - Krita - A layered pixel image manipulation application - KPlato - An integrated project management and planning tool - KChart - A graph and chart drawing tool - KFormula - A formula editor - Kugar - A tool for generating reports [Less]

The FileHelpers are an easy to use .NET library written in C#. Is designed to read/write data from flat files with fixed length or delimited records (CSV). Also has support to import/export data from ... [More] different data storages (Excel, Access, SqlServer) DevBlog at: http://blog.filehelpers.com [Less]

OxygenOffice Professional is a free and open source enhancement of official OpenOffice.org. The OxygenOffice Professional Team has modified the source of OpenOffice.org and bundled lot of extras with ... [More] it. Here are just a few of the extras you get with OxygenOffice Professional: More than 3,400 graphics are included, both clip art and photos. These pictures are integrated into the gallery and can easily be placed into any OxygenOffice document.Several templates and sample documents are included, as well as over 90 fonts. The extras are integrated by default in the installation of OxygenOffice Professional, but they are optional, so the user can decide what parts to include and what parts to leave out. These extra templates, fonts, and graphics are free for both personal and professional use. [Less]

Scriptella is an ETL (Extract-Transform-Load) and script execution tool. Its primary focus is simplicity. It doesn't require the user to learn another complex XML-based language to use it, but allows ... [More] the use of SQL or another scripting language suitable for the data source to perform required transformations. Main features: * Simple and minimalistic XML syntax for ETL scripts. * Built-in providers for JDBC, CSV, Text, XML, LDAP, Lucene and Velocity. * Support for many useful JDBC features, e.g. parameters in SQL including file blobs and JDBC escaping. * Easy-to-Use as a standalone tool or Ant task. No deployment/installation required. Easy-To-Run ETL files directly from Java code. * Seamless integration with Java/Java EE and Spring [Less]

Apatar is an open source data integration application to help join your desktop data with the web. Apatar effectively integrates data and applications, and provides visual job designer and mapping ... [More] , joins, filtering, data cleansing and validation capabilities. Connectors include MySQL, PostgreSQL, Oracle, MS SQL, Sybase, FTP, HTTP (POST and GET), SalesForce.Com, SugarCRM, Compiere ERP, Goldmine CRM, XML (local and web-based), flat files (CSV, TXT), Webdav, Buzzsaw, LDAP, Amazon, RSS and even Flickr; more connectors are under way. [Less]

benerator is a framework for creating realistic and valid high-volume test data, used for testing (unit/integration/load) and showcase setup. Metadata constraints are imported from systems and/or ... [More] configuration files. Data can be imported from and exported to files and systems, anonymized or generated from scratch. Domain packages provide reusable generators for creating domain-specific data as names and addresses internationalizable in language and region. It is strongly customizable with plugins and configuration options. [Less]

Some tools to handle csv files. easycsv - a Python module that permits to manage data into databases with csv statements csvgrep - a kind of grep adjusted for columns into a csv file Getting Started Reference Guide

This is a small class for the .net framework that will read and write comma-separated-values (CSV) spreadsheets. It allows for cell access by row and column number, or for tables that have a header ... [More] row with field names, the class allows the user to treat the table as a database table, where the record/field combination can be accessed. Source code is included, along with compiled DLL. Public functions are fully documented in a PDF file, but there is no documentation for the source code (but it's pretty simple, so if you're a hacker, you can figure it out). [Less]

There are many csv-parsers out there. So why another one? Because none of the others did what I needed. So what is special about this csv-to-db utility? I'll tell you. CSV Parser FeaturesExports ... [More] from outlook-addressbook can have carriage-returns in the address (if you entered it that way in outlook). This utility will handle that correctly. It converts a csv-file into a java.sql.ResultSet so you can use it the same as you use a 'select' sql statement Because you might want to make selections on the file, you can put it in a DataBase. Some CSV files have column-names on the first row. These will be used as the metadata for the ResultSet. Internationalization. Different date-formats and decimal points. Not all CSV files use a comma to seperate the fields, sometime tabs are used. This utility can. When you want to put the file into a DataBase, you can configure what the DataBase table will look like. DB Creation Features You can supply a jdbc connection url to use, or use the default Derby. You can use an existing table, or create a new one. You can tell what data-type the fields of the table will be. Many data-types are already there, but you can make your own implementation of the DbType so this utility can handle your database. You can add an extra column enabling you to create a primary key. Some CSV files have column-names on the first row. These will be used as the column-names for the table. Some CSV files don't have column-names on the first row. You can supply the column-names yourself. Some CSV file do have column-names on the first row, but you don't want to use those but supply your own. Also possible. [Less]