Free csv software for linux

XML::CSV is a Perl extension converting CSV files to XML.

SYNOPSIS

use XML::CSV;
$csv_obj = XML::CSV->new();
$csv_obj = XML::CSV->new(%attr);

$status = $csv_obj->parse_doc(file_name);
$status = $csv_obj->parse_doc(file_name, %attr);

$csv_obj->declare_xml(%attr);
$csv_obj->declare_doctype(%attr);

$csv_obj->print_xml(file_name, %attr);

XML::CSV is a new module in is going to be upgraded very often as my time permits. For the time being it uses CSV_XS module object default values to parse the (*.csv) document and then creates a perl data structure with xml tags names and data. At this point it does not allow for a write as you parse interface but is the first upgrade for the next release. I will also allow more access to the data structures and more documentation. I will also put in more support for XML, since currently it only allows a simple XML structure.

Currently you can modify the tag structure to allow for attributes. No DTD support is currently available, but will be implemented in a soon coming release. As the module will provide both: object and event interfaces, it will be used upon individual needs, system resources, and required performance. Ofcourse the DOM implementation takes up more resources and in some instances timing, its the easiest to use.

Palm::Progect::Converter::CSV is a Perl module to convert between Progect databases and CSV files.

SYNOPSIS

my $converter = Palm::Progect::Converter->new(
format => CSV,
# ... other args ...
);

$converter->load_records();

# ... do stuff with records

$converter->save_records();

This converts between CSV files and Palm::Progect records and preferences.

The CSV format allows for basic import/export with spreadsheet programs. The CSV file does not look like a tree structure; instead, there is a level column, which indicates the indent level for the current row.

The columns in the format are:

level

The indent level of the record.

description

priority

The priority of the record from 1 to 5, or 0 for no priority.

isAction
isProgress
isNumeric
isInfo

Any record can have one (and only one) of the above types.

If you are going to change the type of a record, remember to set all the other types to false:

isAction isProgress isNumeric isInfo
0 0 0 1
completed

Completed has different values depending upon the type of record. For action items, it is either 1 or 0, for complete or not complete.

For Progress items, it is a number between 1 and 100, indicating a percentage.

For Numeric items it is a number between 1 and 100 indicating the the integer percentage of the numericActual value divided by the numericLimit value.

numericActual

The numerator of a numeric record. If the numeric value of a record is 4/5, then the numericActual value is 4.

numericLimit

The denominator of a numeric record. If the numeric value of a record is 4/5, then the numericLimit value is 5.

DateDue

This is a date in the format specified on the command line with the --csv-date-format option
category

opened
description
note

cbMySQL is a PHP Class witch can create, alter, and modify MySQL databases and tables. For backup issues, you can export CSV data directly with only one class method.
The MySQL object is much easier to handle than PHPs built in functions, and theres no need to install anything like PEAR.
Enhancements:
- This version is completely compatible with PHP5 and mysqli.
- The mysql extension is still supported.
- Some bug were removed and examples were added.
- The licence was changed to the LGPL.

Photocomments project convert various forms of comments and descriptions from digital photos.
Supports descript.ion files (as used by ACDsee), jpeg internal comments and CSV files for use with gallery
Written in perl. Uses ImageMagick for the jpeg comment stuff.
Main features:
- Convert different forms of comments for jpeg photos.
- Why? One picture viewer is good for editing comments, another one is good for viewing the images and then theres my online gallery, which should also use the comments as captions.
- Can read descript.ion files (acdsee) and jpeg comments
- can write: descript.ion files, jpeg comments, gallery-csv-files (needed for import to gallery)
- Caveeat: Cannot handle filenames with spaces.

OSLA (Open Source Logistics System) is an open standard Web system for logistics featuring support for shipment, tracking, barcode labelling, a 3rd-party interface to industry document messaging format APIs of DHL, FedEx, UPS, etc., document export to CSV to make invoicing more convenient, cargo manifest, a multilingual interface, user permission administration, data analysis, statistical reports and graphs, and more.

FWdoc project is a vendor-independent standard of storing firewall ruleset configurations. We provide tools to extract the ruleset from proprietary formats into FWdoc format (in JSON), filter rules and objects, and export them into a number of other formats.

From the FWdoc file you can produce a well readable, cross-referenced HTML summary of the firewall configuration. A dump of network and service objects, users, rules and settings into separate files (TXT and Tab-separated tables) or templates (TXT, CSV, SQL, etc.) is possible.

Working (with) Parts

The FWdoc system is designed in modules connected with shell pipes. Thus to create a HTML documentation of a CheckPoint configuration you could run e.g. the following command line:
fw1r55_to_fwdoc.pl | fwdoc_used_objects.py | fwdoc_to_html.py > DOC.html

Input converters (*_to_FWdoc)

CheckPoint up to NG R55

Output converters (FWdoc_to_*)

HTML output
TXT output
table output (CSV, SQL, etc.)

Filters (FWdoc_*)

filtering (un)used objects
ungrouping of objects and services
unrolling of rulesets

Mail::Addressbook::Convert::Tsv is a Perl module that can convert to and from Tsv ( Tab Separated )formatted addressbooks.

SYNOPSIS

use strict;
use Mail::Addressbook::Convert::Tsv;
my $TSV = new Mail::Addressbook::Convert::Tsv();
my $TsvInFile ="csvSample.txt"; # name of the file containing the csv data
# Convert Tsv to Standard Intermediate format
# see documentation for details on format.
my $raIntermediate = $TSV->scan($CsvInFile);
# This will also work
#my @TsvInArray = @arrayContainingTheCsvData;
#my $raIntermediate = $csv->scan(@TsvInArray);
# Convert back to Tsv
my $raTsvOut = $TSV->output($raIntermediate);
print join "", @$raIntermediate;
print "nnnn";
print join "", @$raTsvOut;

PySQLs project aim is to be a full (and much more) replacement for sqlplus. This projet start the 17th of august 2006. It is also a cool pretext for coding in Python. Some ideas behind PySQL:
- really usable and not painfull (history, completion, line edition...)
- high level function often used (search for tables, indexes, count, explain plan, list of sessions...)
- proper output for screen and file (csv ready for inclusion in spreadsheets)
- user defined macro ?