| |
| • | 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 |
| • | Able to undo previous import process by restoring the original data |
| • | Preview last import and backup data for comparison |
| • | 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 |
|
|
