WorldWideScripts.net Delivering the best Add-Ons in more than 37 languages.

中文(简体), English, हिन्दी/हिंदी, Español/Castellano, العربية, Русский язык, Français, 中文 (台灣), বাংলা, Bahasa Indonesia, اردو, Português, Deutsch, Bahasa Melayu (بهاس ملايو‎), 日本語 (にほんご), فارسی, Italiano, తెలుగు, Türkçe, ગુજરાતી, Język polski/polszczyzna, Tiếng Việt, ಕನ್ನಡ, Українська мова, ไทย
PHP Scripts / Miscellaneous

IMEXporter - CSV to MySQL importer & exporter

— Add-On to WorldWideScripts.net

Subscribe to our feed to stay up to date!

New! Follow us as you want it!


IMEXporter - CSV to MySQL importer & exporter - WorldWideScripts.net Item for Sale

Ads

Ad: Bluehost hosting

IMEXporter

Complete CSV to MySQL importer/exporter.
No more MySQL import and export headaches!

This script is intended to be used in any application where a good CSV to MySQL import tool is needed. It has it’s own CSV parser, and with help of adodb it processes all the csv into your desired table.

Here are some of the best features of IMEXporter.

  • Export to CSV in conformance with RFC4180 .
  • Three methods of import. Imports CSV files in conformance with RFC4180 .
  • Included CSV validation utility. Check all CSV values against MySQL table columns before load in.
  • Import direct – Takes a CSV file already in system and loads it to MySQL without any validations or checks.
  • Interactive Import – Takes a CSV file already in system and starts a interactive (step by step) process of validation and checks before loading into MySQL.
  • Fully Interactive – Same as above but with an included CSV file upload form.
  • Lightning fast CSV load using MySQL LOAD DATA INFILE method, even when CSV columns do not match with Table ones.
  • Easy to use. One liner. All HTML produced is valid XHTML with separate CSS file for styling.
  • Uses adodb as an database abstract layer.
  • Ability to import a CSV, using a column of it to populate multiple columns on the database.
  • Makes use of the primary key on the table to update records.
  • Complete localization files. Easy translation without coding.
  • 14 examples provided.
  • Well documented code.


Download
Other components in this categoryAll components of this author
CommentsFrequently asked questions and answers

Properties

Created:
28 March 12

Last Update:
28 March 12

Software Version:
PHP 5.x, jQuery

Files Included:
JavaScript JS, CSS, PHP, SQL

Keywords

ajax, csv, export, import, mysql, php