Publisher review:Excel Importer/Exporter allows you to import your data from CSV file format to your MySQL database. CSV stands for comma delimited file and it is supported in most spreadsheet programs like Microsoft Excel.
Features
Import CSV File
- Upload CSV format file to server
- Specify column separator and number of records to preview
- Display total columns and records found in uploaded CSV file
- Option to view all records in popup window
- Step-by-step walkthrough wizard
Connect To MySQL Database
- Enter MySQL host, username and password to connect to MySQL database
- Able to connect to remote database and save connection information
- Select target database and table to import
- Display total columns and records found in database
Confirm & Complete Import
- Able to match source and target columns to make sure both data are matched
- Option to import record at first line, which to avoid import the column title as data
- Options to append as new records, replace existing records or update records using primary key
- Finish import process with summarized report
Undo import Process
- Able to undo previous import process by restoring the original data
- Preview last import and backup data for comparison
Export To CSV File
- Able to connect to MySQL database, including both local and remote database
- Select database and table to export its data
- Option to select all or specify which columns to export its data
- Preview data before export
- Export to CSV format file
Sign up For Users
- Users can signup to import CSV files to selected database through the front-end
- Create various database group
- Allocate database tables for users to access
- View all CSV files imported by users
- Delete files from the database.
Anti-Spam With Image Verification
- Secure your user signup form from being spammed by bots.
- Requires both the GD library and FreeType library
Easy-to-Use Back-end System
- Notify admin upon member signup and tables submission
- Time Zone settings
- Pre-define Front-end CSS
Requirements: · PHP 4.2 or above · ZLib library · GD 1.6.2 , GD 2.0 library or higher · Enable EXIF · Safe_Mode = OFF · Open_Basedir = EMPTY VALUE · MySQL 3, MySQL 4
Excel Importer/Exporter 1.1 is a PHP script for Database Tools scripts design by WebBiscuits Software Ltd Sti.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
Operating system:Windows / Linux / Mac OS / BSD / Solaris