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 ;)
|
|
| Name: |
csv2mysql database migration tool |
| Base name: |
csv2mysql |
| Description: |
convert fields in a csv into SQL |
| Version: |
- |
| PHP version: |
- |
| License: |
GNU General Public License (GPL) |
| All time users: |
7438 users |
| All time rank: |
211 |
| Week users: |
2 users |
| Week rank: |
1296  |
| |
|
| Ratings | Utility |
Consistency |
Documentation |
Examples |
Tests |
Videos |
Overall |
Rank |
| All time: |
Good (87.5%) |
Sufficient (75.0%) |
Sufficient (67.9%) |
- |
- |
- |
Not sure (58.0%) |
987 |
| Month: |
Not yet rated by the users |
| 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... |
| 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... |
| |
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 |
|
|
Stumble It!
Bookmark in del.icio.us
Support forum (1)
Blog
Latest changes
User ratings
Files
