Description
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