Projects tagged ‘csv’ and ‘mysql’

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]

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]

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]

tissynbe parses Nessus results and performs various cleanup operations to "prettify" the results and make analyzing data easier.

Dockhand began as a tool for generating SQL create table statements and Oracle SQL*Loader control files, but it quickly expanded and now aims to be a general purpose data manipulation, extraction, and deployment utility.

More info soon

Live Glossary is a web based application, which allows users to view, create and edit a Glossary. It also has an administrative portion from which the administrator can accept or reject additions or ... [More] edits, populate the glossary with delimited data from a csv file and export a pure HTML version of the Glossary. [Less]

The problem: I have a gigantic csv file with hundreds of columns (mixed types: strings and integers), and need to turn this into a queryable mysql table. MySQL's LOAD DATA INFILE is great if the ... [More] schema is already there -- but in many cases that's the majority of the problem. You can't just create N columns of varchar(255)'s, because then your numeric columns get string sorted (0, 1, 100, 101, 2). Additionally, LOAD DATA INFILE sucks in many circumstances and becomes an irreconcilable train wreck when it comes to matching up data into the right columns and not dropping rows (why?!). csv2mysql generates tables with compact columns of the right type (so far just varchar and int), stealing column names from headers in the first row of the csv. [Less]

Software for conversion of files in CSV to SQL. For MySQL, PostGreSQL, MSSQL, SQLITE...