-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathreadme.txt
158 lines (120 loc) · 4.41 KB
/
readme.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
=== DBMaker ===
Contributors: castanet01
Donate link: https://www.castanet.tokyo/donation
Tags: database, csv, import, search
Requires at least: 4.6
Tested up to: 5.4.2
Stable tag: 1.2
Requires PHP: 5.2.4
License: GPLv2 or later
License URI: https://www.gnu.org/licenses/gpl-2.0.html
Simple database plugin. import csv file, delete all records,
search and sort in backend, simple search form for frontend.
== 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
1. Select DataBase Maker in admin menu. Add new post.
1. Title is database name, it is displayed admin menu.
1. Content is frontend search form. If content is empty, default form inserted.
#### Edit csv settings
1. post_type is database type
1. format is column names order in csv files. comma separated. see **column names**
1. status is default post status.
1. character encoding is csv file's encodeing
1. "skip lines" : skip n lines
1. "public access" is data status. if it is checked, public access from frontend.
1. save post.
#### Import data from csv file
1. Select your database name in admin menu.
1. Select csv file and push "read csv", start importing.
1. 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
1. Select DataBase Maker, edit database
1. edit contents, see **Short codes**
1. 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'
== Installation ==
1. Upload the plugin files to the `/wp-content/plugins/plugin-name` directory, or install the plugin through the WordPress plugins screen directly.
1. Activate the plugin through the 'Plugins' screen in WordPress
1. Use the Settings->Plugin Name screen to configure the plugin
1. (Make your instructions match the desired user flow for activating and installing your plugin. Include any steps that might be needed for explanatory purposes)
== Frequently Asked Questions ==
* Can i export data to csv file?
Export csv file not supported yet. ToDo.
== Screenshots ==
1. csv settings
2. data list in admin menu
3. search form editor
4. search form in frontend
== Changelog ==
= 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
== Upgrade Notice ==
= 1.0 =
* first release
== Arbitrary section ==