PHP Classes
elePHPant
Icontem

csv2mysql database migration tool: convert fields in a csv into SQL

Recommend this page to a friend!
     
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2003-06-06 (13 years ago) RSS 2.0 feedStarStarStar 58%Total: 7,815 This week: 1All time: 215 This week: 1,047Down
Version License Categories
csv2mysql 1.0.0GNU General Publi...Databases, Files and Folders
Description Author

This class creates sql to import into tables in any mysql table - you specify the fieldname in the csv - and the mysql field in your db that this relates to. It supports database queries to get values to go into final sql (so you can link tables) and it supports running custom functions to get values for the final sql too. - and static values for other fields.
It does some validation on the final sql to check that you have all the fields that are required etc.
There is also some (experimental) xls file import support providing you have xlhtml installed on the machine the class is running on. (it will locate it and moan if you haven't) This works if the excel file only has 1 page but if it has multiple pages then im working on it ;)

Picture of Mark Williamson
Name: Mark Williamson <contact>
Classes: 5 packages by
Country: United Kingdom United Kingdom

  Files folder image Files  
File Role Description
Accessible without login Plain text file csv2mysql instructions Doc. instructions on how to use
Plain text file csv2mysql.inc Class csv2mysql
Accessible without login Plain text file htmltablecreation.inc Aux. creates html tables from structs

Downloadcsv2mysql-2003-06-06.zip 11KB
Downloadcsv2mysql-2003-06-06.tar.gz 10KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:7,815
This week:1
All time:215
This week:1,047Down
 User Ratings  
 
 All time
Utility:88%StarStarStarStarStar
Consistency:76%StarStarStarStar
Documentation:70%StarStarStarStar
Examples:-
Tests:-
Videos:-
Overall:58%StarStarStar
Rank:1291
  

  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.


  Pages that reference this package  
como importar xls a php
El Talend hace sus trabajos en phyton o JAva, cuando haces la tarea en JAVA, puedes exportarlo a Webservice de Axis entre otros, y puedes invocar la URL indicando el metodo del webservice a ejecutar, el cual retorna un 0 o un 1 dependiendo de si latarea fue correcta o erronea...
Whats the PHP Code to import excel data into mysql?
There is a class here that can be used to import CSV file data into MySQL...

Latest pages that reference packages Latest pages that reference packages