Projects tagged ‘csv’ and ‘sql’

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]

pChart is a PHP class oriented framework designed to create aliased charts. Data can be retrieved from SQL queries, CSV files, or manually provided.

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]

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]

Simple data access object for csv files in php5.by Kazuyoshi Tlacaelel. Some featuresCellsfillCell cell value filler getCell cell fetcher hasCell checks if a coordinate is valid ... [More] HeaderscountHeaders header counter createHeaders header creator getHeaders header fetcher setHeaders header injector ColumnsappendColumn column appender fillColumn collumn data injector getColumn column fetcher hasColumn column existance checker removeColumn column remover walkColumn column walker Must see[construct] data load initialize connect header and row relationship builder getRawArray raw data as array isSymmetric data length/symmetry checker load csv file loader settings settings alterator symmetrize all rows length equalizer walkGrid grid walker RowsappendRow row appender countRows row counter fillRow fillRow getAsymmetricRows asymmetric data fetcher getRow row fetcher getRows multiple row fetcher hasRow row existance checker removeRow row remover walkRow row walker Comming sooncolumns (gets a range of columns) export (gets altered data as a csv string) url parsing grepColumn scans a column using a callback function grepRow scans a column using a callback function grepGrid scans the whole dataset using a callback function Using the package csv file name,age,skill john,13,knows magic tanaka,8,makes sushi jose,5,dances salsa php file load('my_cool.csv'); var_export($csv->connect()); ?> output array ( 0 => array ( 'name' => 'john', 'age' => '13', 'skill' => 'knows magic', ), 1 => array ( 'name' => 'tanaka', 'age' => '8', 'skill' => 'makes sushi', ), 2 => array ( 'name' => 'jose', 'age' => '5', 'skill' => 'dances salsa', ), ) Do not read this! Please DontReadThis for examples documentation information deprecations more... [Less]

MailMerge for DTP system Scribus is a PyQt application. It works as an Extension script.

The Problem If you have any dealings at all with data and databases, then you almost certainly will have have to deal with comma-separated values (CSV) data. Unfortunately, the CSV files you are ... [More] given, or are required to produce, never seem to be in quite the right format for your particular business application. And because of the structure of CSV records, using standard text procesing tools like sed, awk and perl on CSV files is not as simple as it might be. The Solution CSVfix is a command-line stream editor specifically designed to deal with CSV data. With it, you can: Convert fixed format, multi-line and DSV files to CSV Reorder, remove, split and merge fields Convert case, trim leading & trailing spaces Search for specific content using regular expressions Filter out duplicate data or data on exclusion lists Perform sed/perl style editing Enrich with data from other sources Add sequence numbers and file source information Split large CSV files into smaller files based on field contents Perform arithmetic calculations on individual fields Validate CSV data against a collection of validation rules Convert from CSV to fixed format, XML, SQL, DSV Summarise CSV data, calculating averages, modes, frequencies etc. You can see a full list of CSVfix commands here. Update: CSVfix Version 0.95 now available for download. This adds several new commands (including a new XML generating command) and the ability to use separators other than a comma in CSV input. Details of the changes are here. New: If you find CSVfix useful, please also check out CSVTest, a test data generator, at http://code.google.com/p/csvtest. [Less]

INTRODUCTIONCSV2db it is a command line Java software tool used for imoporting data from CSV files to SQL database. REQUIREMENTSJAVA Runtime 1.5+ Database JDBC driver (bundled with PostgreSQL 8+ ... [More] driver) SQL database server USAGEUnzip and run: java -jar CSV2db.jar yourfilename.csv NOTE: CSV2db boundled with PostgreSQL 8.0 JDBC driver, if you want to use other database like MySQL, Oracle e.t.c. you should put your appropriate JDBC driver in CLASSPATH variable. [Less]

TxtSushi is a collection of command line utilities for processing comma-separated and tab-delimited files (AKA flat files, spreadsheets). By focusing exclusively on processing text files with a ... [More] tabular structure, TxtSushi simplifies common tasks like filtering, joining and transformation that would take some effort to accomplish with a more powerful scripting language. [Less]

Generate Sql Script From CSV, Excel, Groovy