Exabytes^®

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

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