ECI: Database Manager
The database manager is intended to allow many abilities but the main ability at this time is for exporting data to csv file. There are advanced features that allow meta data to be exported along with none meta data. Meaning, the plugin will use each distinct meta key as a column title and put the meta values in that column. Much testing is to be done and more upgrades but it is considered an impressive tool already.
Key Information
- Use the Split features with care. Too many meta keys will result in a large number of columns in your csv file. Improvements may be required to allow you to filter out meta keys you would like Easy CSV Importer to ignore.
- If your not exporting meta data, simply put a tick in the Normal box for each column you wish to export.
- If you tick a meta key column as Normal, it can result in what looks almost like duplicate records but in fact each record will be slightly different within the meta key column. This is due to how the MySQL SELECT query works and the fact that meta key columns contain the same values many times.
Features
Many more features can be added to this page on request. I already have many planned however if you need something quickly, please contact the webmaster@webtechglobal.co.uk
Database Operations – Select Columns
Easy CSV Importer will list all of your WordPress database tables. Every single one of them has its own panel with the tables columns listed. You must scroll down, opening each column that you would like to export or edit. As I write this we can only export but that will change.
Normal Check-boxes
These boxes are for exporting. If you are not exporting a meta key column then always tick Normal.
Split Check-Boxes
These are also for exporting data. If you need to export a column of meta values, you need to put a tick in the Split box for the meta key column, not the meta values column. That is what the Secondary Column menus are for.
Column Name (split key)
This is simple a list of the tables column names. I have put (split key) in the table title simply to indicate that when splitting a meta column, there is no need to select it in the Secondary Menus. You simply put a tick in the box to indicate that you want the meta key column to be split into individual csv file columns.
Secondary Column (split value)
The split value is the meta value, it is entered into the csv column that is named, the same as the meta key from the split key column. The menus on this page allow you to tell Easy CSV Importer what the meta values column actually is. This cannot be assumed see, it may be customised and not the default WordPress tables. Select the columns in the menus that holds the actual unique meta values.
Do not need to use the Secondary Column menus if you are not exporting meta data.
Database Operations – Actions
This panel holds buttons to action changes you have made to the Database Operations – Select Columns and any other Database Operations panels that may have been added since I wrote this.
Database Operations – Actions – Save Settings
This button will save the selections you make in the Database Operations table panels. Saving allows you to perform the same export multiple times. Other uses for saving will come later including automatic export and delivery of csv file using ftp too an external source or even zipping it for user download. Such abilities are advanced and must be requested before I will add them.
Database Operations – Actions – Rest Settings
Simply deletes any of the saved settings.
Database Operations – Actions – CSV Export
Clicking this will begin the export process, a csv file will be generated and downloaded by your browser.
Overall Effects
Currently the only effects is the download of a csv file. The scripts ensure that the user is Admin before allowing any export.
Videos
Coming soon