About this plugin
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’