	Login		Register

Top rated packages with tag csv import

Recommend this page to a friend!

Stumble It!

Bookmark in del.icio.us

			All class groups	>	Search tags: csv import

	1. CSV to SQL database converter

Supplied by: Michal Palma <e-mail contact>

Import data from a CSV file into a database

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.

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%)`	173
Month:	Not yet rated by the users

	2. csv2mysql database migration tool

Supplied by: Mark Williamson <e-mail contact>

convert fields in a csv into SQL

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

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (87.5%)`	`Sufficient (75.0%)`	`Sufficient (67.9%)`	`-`	`-`	`-`	`Not sure (58.0%)`	986
Month:	Not yet rated by the users

	3. CSV

Supplied by: Waldemar Derr <e-mail contact>

A class for import comma separated and fixed files

This class enable you a databse-likely access to comma separated (csv) and fixed length files. Is useful for import from csv to db.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Sufficient (72.1%)`	`Sufficient (77.9%)`	`-`	`Sufficient (79.4%)`	`-`	`-`	`Not sure (51.8%)`	1422
Month:	Not yet rated by the users

	4. Quick CSV import

Supplied by: Alexander Skakunov <e-mail contact>

Import CSV data into a MySQL database table

This class can be used to import data from CSV (Comma Separated Value) files into a given MySQL database table.

It parses a given CSV file to extract the field names. Then it imports the data into the MySQL database using a LOAD DATA INFILE query to import the data in a much faster way than using SQL INSERT queries.

If necessary, the class can also create the database table using the CSV file headers to retrieve the table field names.

UPDATE: From now you can set the encoding table which is used to parse the file.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Sufficient (71.1%)`	`Sufficient (72.4%)`	`-`	`Sufficient (72.4%)`	`-`	`-`	`Not sure (50.0%)`	1525
Month:	Not yet rated by the users

	5. adv_csv

Supplied by: Tomasz Malewski <e-mail contact>

Export and import data in CSV from HTML or MySQL

This class can be used to export and import data in CSV format from HTML tables or MySQL database tables. It can:

- Parse an HTML document with tables and generate CSV data from the table cells
- Parse an CSV file and import it into a MySQL database table
- Generate CSV data from MySQL query results

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Not sure (50.0%)`	`Good (83.3%)`	`-`	`Good (91.7%)`	`-`	`-`	`Not sure (42.5%)`	1953
Month:	There are not enough user ratings to display for this class.

Advertise on this site

For more information send a message to info at phpclasses dot org.