Give admin a better understanding on how to export MySQL tables to his desktop; import CSV file, append records to existing database, undo import process to restore his last backup data, create database groups, preference settings, and others. Browse to the respective topic at the menu section to view screenshots, step by step tutorials, and tips.
Walkthrough
CSV Import
To begin an import task, simply follow 4 consecutive steps. At the initial stage, browse to the CSV file and upload it. Then, connect to the database in order to select specific database and table to import. Next, perform columns matching to ensure the similarities of table columns. Finally, view import summaries for successful import procedure. Click on 'Admin' > 'Installation' if the CSV Importer has yet to install.
Undo Import
Undo import is a feature that allows admin to restore the last backup data. View last import information, such as date, time, database and table name. Also, preview the last import table (current existing table) and the backup copy (original data before import).
CSV Export
Easily export preferable data from the database into CSV files and view them on the desktop. Simply select the database, table and column to export.
Database Group
Manage multiple member accounts into different database groups. First, give a name for specific database group, connect to the database with MySQL info and select particular database tables to enable specific user group to gain access and import CSV file into database through the front-end. After several database groups have been created, lets proceed to add members and assign them to these groups.
Member
Add various members with login username and password under particular database groups. Members status which is set as Active are able to import their CSV file into the database tables assigned by admin. All files which are successfully import by members will be located in Member > Member File where admin can download and save CSV files on his desktop.
Preference Settings
Define how many records to be shown in a List Member page, enter a complete URL of the domain to display the CSV Importer, enable image verification in member signup form, personalize notification emails and others.
This is an example of the CSV Importer after integration. Members can login to their accounts and import their CSV files into specific database tables assigned by admin.
