ECI: Project Database Table
The Project Database Panel holds details about a table created for your Current Project. Every project gets its own table and that is where your CSV data goes.
Key Information
- You should see a list of all your CSV file titles, cleaned for using in MySQL meaning lower-case and special characters removed. If you do not then there has been a problem creating the table.
- You will see other column titles that being with “eci”, these are used by the plugin for various purposes that will be detailed in the Features section below.
Features
My original plan was for this panel to allow some actions on the project table, however I have not long created the Database base and this is now where any project table actions will be done.
Table Created Button
I used the approach of displaying the current state of your project table on the buttons text. If the table exists, it will say “Yes, Delete Table”. The button will delete the project table when pressed without any further confirmation. If no project table exists, it will say “No, Create Table”. Clicking it will attempt to create the project table. If for any reason the plugin cannot create your table please contact the webmaster@webtechglobal.co.uk straight away.
Table Name
Your table name will be a cleaned version of your CSV file-name.
eciid
This is simply the record id. It will be saved as meta data/custom field in your post when the record is used to create that post. This is how Easy CSV Importer tracks down the record and checks for new data. This will happen when you open a post and if updating is activated.
ecipostid
This is the standard WordPress Post ID of the post or page or custom post type created using that record. The plugin has to update the record with the post id during the post creation phase.
eciinuse
This column is used to indicate if we are still using the record or not. We can sort of black-mark the correct so that it is ignored.
eciconsync
This column is the Default selection for Post Sync. Post Sync stores a posts content in this column when you edit the post content manually.
eciupdated
Holds the date and time when the record was updated by importing data from a new CSV file, it may show a default time which will be the initial import time.
eciapplied
The date and time when the record was used to create or update the connected post (see ecipostid column for post id), check this when testing to confirm a record has been used for update.
ecifiletime
This column holds the project CSV files date-stamp. This allows the plugin to check if a record has been updated by the latest CSV file or not.