Login   Register  
PHP Classes
elePHPant
Icontem

CSV to SQL database converter: Import data from a CSV file into a database

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Michal Palma
Name: Michal Palma <contact>
Classes: 4 packages by
Country: Czech Republic Czech Republic
Age: 33
All time rank: 731 in Czech Republic Czech Republic
Week rank: 324 Down3 in Czech Republic Czech Republic Down


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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.

  Classes of Michal Palma  >  CSV to SQL database converter  >  Download Download .zip .tar.gz  >  Support forum Support forum (4)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: CSV to SQL database converter
Base name: csv2db
Description: Import data from a CSV file into a database
Version: 1.0.0
PHP version: -
License: GNU General Public License (GPL)
All time users: 5526 users
All time rank: 399
Week users: 3 users
Week rank: 649 Down
 
  Groups   Rate classes User ratings   Dependencies   Applications   Files Files  

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


  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (91%) Good (91%) Sufficient (75%) Good (83%) - - Sufficient (70%) 175
Month: Not yet rated by the users

  Packages needed by this class  
Class DownloadWhy it is needed Dependency
XML 2 Array Download .zip .tar.gz To read XML configuration Required
CSV managing class Download .zip .tar.gz To read CSV file Required
SQL databases interface Download .zip .tar.gz To write to database (any supported by it) Required

  Applications that use this package  
No pages of applications that use this class were specified.
Add link image If you know an application of this package, send a message to the author to add a link here.
  Files folder image Files  
File Role Description
Plain text file config.xml Data Configuration data
Plain text file Csv2Db.class.php Class Csv2Db class
Plain text file Csv2DbCfg.class.php Class Csv2DbCfg class
Plain text file Csv2DbInterface.class.php Class Csv2DbInterface class
Accessible without login Plain text file readmeFirst.txt Doc. Read me
Accessible without login Plain text file test.csv Data CSV file to testing
Plain text file _preload.php Aux. preload script
Accessible without login Plain text file ___case_of_use.php Example Case of use

Install with Composer Install with Composer - Download 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.