Top rated packages with tag import csv

Recommend this page to a friend!

			All class groups	>	Search tags: import csv

	1. CSV to SQL database converter		import csv

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

	2. csv2mysql database migration tool		import csv

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 (86.5%)`	`Sufficient (76.9%)`	`Sufficient (69.2%)`	`-`	`-`	`-`	`Not sure (57.9%)`	964
Month:	Not yet rated by the users

	3. CSV		import 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%)`	1373
Month:	Not yet rated by the users

	4. Quick CSV import		import csv

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

Copyright (c) Icontem 1999-2012	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products