CSV to SQL database converter (csv, csv import, import, csv?)

Name:	CSV to SQL database converter Support forum
Base name:	`csv2db`
Description:	Import data from a CSV file into a database
Related top rated classes:	csv, csv import, import, csv?
Version:	`-`
Required PHP version:	`-`
License:	GNU General Public License (GPL)
All time users:	4002 users
All time rank:	430
Week users:	16 users
Week rank:	401

	Author		Groups		Detailed description

	User ratings		Dependencies		Applications		Files

Author

Name:	Michal Palma `<e-mail contact>`
Published packages:	4 Browse this author's classes
Country:	Czech Republic - PHP jobs in Czech Republic
Home page:	???
Age:	28
All time rank:	92
Week rank:	53

Groups

PHP 5	Classes using PHP 5 specific features	View top rated classes
Databases	Database management, accessing and searching	View top rated classes
Files and Folders	Listing, accessing and manipulating files and folders	View top rated classes

This package can be used to import data stored in CSV files into a database.

The main class can import the data into a table named by imported CSV-file name. Table in database is like image of CSV file, query "DROP TABLE IF EXISTS `<CSV-filename>`" is called before table creation!

The types of the columns and other details can be defined in a separate configuration XML file. This package comes with one class that can parse and extract the configuration details.

The import class uses an external package to provide DBMS independent access to the database in order to store the imported data.

User ratings

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (91.7%)`	`Good (91.7%)`	`Sufficient (75.0%)`	`Good (83.3%)`	`-`	`-`	`Sufficient (70.8%)`	143
Month:	Not yet rated by the users

Packages needed by this class

Class	Dependency	Why it is needed
XML 2 Array	Required	To read XML configuration
CSV managing class	Required	To read CSV file
SQL databases interface	Required	To write to database (any supported by it)

Applications that use this class

No application links were specified for this class.

If you know an application of this package, send a message to the author to add a link here.

Files

File	Role	Description
`config.xml`	Data	Configuration data
`Csv2Db.class.php`	Class	Csv2Db class
`Csv2DbCfg.class.php`	Class	Csv2DbCfg class
`Csv2DbInterface.class.php`	Class	Csv2DbInterface class
`readmeFirst.txt`	Doc.	Read me
`test.csv`	Data	CSV file to testing
`_preload.php`	Aux.	preload script
`___case_of_use.php`	Example	Case of use

Download all files: csv2db.tar.gz csv2db.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

Copyright (c) Icontem 1999-2009	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products

Class: CSV to SQL database converter