描述
This plugin make simple database from csv.
Import from csv files to custom post type.
features
- you can make database from csv file
- import over 10000 records from csv file
- delete all data records
- support custom fields and taxonomies
- sort and search data in backend
- support shortcode for search form and result list in frontend
- import from csv, insert only. update record not supported.
Usage
Create Database
- Select DataBase Maker in admin menu. Add new post.
- Title is database name, it is displayed admin menu.
- Content is frontend search form. If content is empty, default form inserted.
Edit csv settings
- post_type is database type
- format is column names order in csv files. comma separated. see column names
- status is default post status.
- character encoding is csv file’s encodeing
- “skip lines” : skip n lines
- “public access” is data status. if it is checked, public access from frontend.
- save post.
Import data from csv file
- Select your database name in admin menu.
- Select csv file and push “read csv”, start importing.
- Display progress bar, please wait for a while.
Data operation in admin menu
- keyword search target all columns
- taxonomy filter supported
- title, date and custom fields support sorting.
- Delete all data supported
Create search form for frontend
- Select DataBase Maker, edit database
- edit contents, see Short codes
- save contents then view posts
Column names
- post_title: title of the post
- post_author: (login or ID) The user name or user ID number
- post_date:
- post_excerpt:
- post_status:
- post_password:
- post_name:
- post_parent:
- menu_order:
- tax_{taxonomy}: (string, comma separated) Any field prefixed with tax_ will be used as a custom taxonomy.
- {custom_field_key}: Any other column labels used as custom field.
Short codes
dbm_search
Create form tag for search. This code is enclosing.
option
- post_type : required Search database post_type.
- posts_per_page : default: 5
- pager : This option set not empty string, pager support. default: ”
dbm_tax_checkbox
Create checkboxes for taxonomy
option
- name : requried taxonomy name.(No “tax_” prefix)
dbm_tax_select
Create select tag for taxonomy.
option
- name : requried taxonomy name.(No “tax_” prefix)
- multiple : This option set not empty string, multiple select box. default: ”
- size : Select tag size.
dbm_textbox
Create text input box
option
- name : Set search target column name. ‘s’ is target all columns. default : ‘s’
- required : true or false. default : ‘false’
dbm_result_table
Display search result table. This code need outside of dbm_search.
option
- label : th tag names, comma separated.
- data : column names, comma separated.
dbm_result_pager
Output pager
option
- label : pager button label. default : ‘first, prev, next, last’
Arbitrary section
螢幕截圖
安裝
- Upload the plugin files to the
/wp-content/plugins/plugin-name
directory, or install the plugin through the WordPress plugins screen directly. - Activate the plugin through the ‘Plugins’ screen in WordPress
- Use the Settings->Plugin Name screen to configure the plugin
- (Make your instructions match the desired user flow for activating and installing your plugin. Include any steps that might be needed for explanatory purposes)
常見問題
- Can i export data to csv file?
Export csv file not supported yet. ToDo.
評價
There are no reviews for this plugin.
貢獻者及開發者
修改日誌
1.2
*fix all delete bug.
1.1
- add view link in database admin menu.
- no import empty records.
- add order and orderby parameter in frontend search.
- Shortcode dbm_search: add parameter preload. Set it, data list load on init.(orderby post_id, ASC)
- Back to seach result page in frontend, recently data list display.
1.0
- first release