PHP Classes
Icontem

Class: csv2mysql database migration tool


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Mark Williamson  >  csv2mysql database migration tool  >  Download  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: csv2mysql database migration tool Support forum
Base name: csv2mysql
Description: convert fields in a csv into SQL
Related top rated classes: , , ,
Version: -
Required PHP version: -
License: GNU General Public License (GPL)
All time users: 5984 users
All time rank: 196
Week users: 22 users
Week rank: 240
 
  Author   Group folder image Groups   Detailed description  
  Rate classes User ratings   Trackback   Applications   Files Files  

Author

Picture of Mark Williamson
Name: Mark Williamson <e-mail contact>
Published packages: 5 Browse this author's classes Browse this author's classes
Country: United Kingdom United Kingdom - PHP jobs in United Kingdom
Home page: ???
Age: ???
All time rank: 182
Week rank: 292

Groups

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

Detailed description

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 ;)

User ratings

Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (87.5%)
Sufficient (77.1%)
Sufficient (68.8%)
-
-
-
Not sure (58.3%)
817
Month:
Not yet rated by the users

Trackback links

Link Description
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...

Applications that use this class

No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.

Files

File Role Description
Plain text file csv2mysql instructions Doc. instructions on how to use
Plain text file csv2mysql.inc Class csv2mysql
Plain text file htmltablecreation.inc Aux. creates html tables from structs
Download all files: csv2mysql.tar.gz csv2mysql.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products