Projects tagged ‘csv’ and ‘java’

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]

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]

Project to control GPS Dataloggers, mainly MTK based and convert GPS logs to several other formats using filters, etc. Runs on most platforms (Desktops, Linux, Mac, Palm, Mobile Phone, PocketPC).

FlatPack came out of the frustration of having to mix file parsing logic with business logic. FlatPack on SourceForge: a Java (1.4+) flat file parser that handles CSV, fixed length and custom ... [More] delimiters. The formats are configured in XML, it is fast and released under Apache license 2.0. Substrings in a fixed width parse can be daunting to deal with when trying to analyze what existing code is doing, and what about when you have no comments... We also provide delimited file parsing; works with any delimiter / qualifier, multiline records, delimiter or qualifier allowed in column value. [Less]

opencsv is a very simple csv (comma-separated values) parser library for Java.

ZFileReader on SourceForge: a Java (1.4+) flat file parser that handles CSV, fixed length and custom delimiters. The formats are configured in XML, it is fast and released under Apache license 2.0. ... [More] Substrings in a fixed width parse can be daunting to deal with when trying to analyze what existing code is doing, and what about when you have no comments... We also provide delimited file parsing; works with any delimiter / qualifier, multiline records, delimiter or qualifier allowed in column value. [Less]

UJO Framework provides special objects with a different architecture from JavaBeans. The UJO objects have got the some unique features: * map based architecture with a value type safe solution * ... [More] an easy object introspection without a heavy PropertyDescriptor implementation * simple persistence the object to XML and another formats * two fundamental interfaces are applicable for easy user implementation [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]

This is a simple Groovy script to convert simple CSV files containing POIs to KML

Load data into memory and use convenient query language to extract information. Very useful in CSV processing. The query syntax is intuitive.