{"id":100052,"date":"2019-03-22T01:39:38","date_gmt":"2019-03-22T01:39:38","guid":{"rendered":"https:\/\/ja.wordpress.org\/plugins\/dbmaker\/"},"modified":"2020-07-11T04:11:57","modified_gmt":"2020-07-11T04:11:57","slug":"dbmaker","status":"publish","type":"plugin","link":"https:\/\/sa.wordpress.org\/plugins\/dbmaker\/","author":16971646,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.1","stable_tag":"1.2","tested":"5.4.19","requires":"4.6","requires_php":"5.2.4","requires_plugins":"","header_name":"DBMaker","header_author":"Toshiyuki Kawashima","header_description":"Make data base from csv","assets_banners_color":"41947d","last_updated":"2020-07-11 04:11:57","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/www.castanet.tokyo\/donation","header_plugin_uri":"https:\/\/www.castanet.tokyo\/dbmaker\/","header_author_uri":"https:\/\/www.castanet.tokyo\/","rating":0,"author_block_rating":0,"active_installs":0,"downloads":2015,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":{"1.0":"<ul>\n<li>first release<\/li>\n<\/ul>"},"ratings":[],"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":"2054964","resolution":"128x128","location":"assets","locale":""},"icon-256x256.png":{"filename":"icon-256x256.png","revision":"2054964","resolution":"256x256","location":"assets","locale":""}},"assets_banners":{"banner-1554x500.png":{"filename":"banner-1554x500.png","revision":"2054964","resolution":"1554x500","location":"assets","locale":""},"banner-772x250.png":{"filename":"banner-772x250.png","revision":"2054964","resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0","1.1","1.2"],"block_files":[],"assets_screenshots":{"screenshot-1.JPG":{"filename":"screenshot-1.JPG","revision":"2054964","resolution":"1","location":"assets","locale":""},"screenshot-2.JPG":{"filename":"screenshot-2.JPG","revision":"2054964","resolution":"2","location":"assets","locale":""},"screenshot-3.JPG":{"filename":"screenshot-3.JPG","revision":"2054964","resolution":"3","location":"assets","locale":""},"screenshot-4.JPG":{"filename":"screenshot-4.JPG","revision":"2054964","resolution":"4","location":"assets","locale":""}},"screenshots":{"1":"csv settings","2":"data list in admin menu","3":"search form editor","4":"search form in frontend"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[567,153,87,944],"plugin_category":[59],"plugin_contributors":[169412],"plugin_business_model":[],"class_list":["post-100052","plugin","type-plugin","status-publish","hentry","plugin_tags-csv","plugin_tags-database","plugin_tags-import","plugin_tags-search","plugin_category-utilities-and-tools","plugin_contributors-castanet01","plugin_committers-castanet01"],"banners":{"banner":"https:\/\/ps.w.org\/dbmaker\/assets\/banner-772x250.png?rev=2054964","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/dbmaker\/assets\/icon-128x128.png?rev=2054964","icon_2x":"https:\/\/ps.w.org\/dbmaker\/assets\/icon-256x256.png?rev=2054964","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/dbmaker\/assets\/screenshot-1.JPG?rev=2054964","caption":"csv settings"},{"src":"https:\/\/ps.w.org\/dbmaker\/assets\/screenshot-2.JPG?rev=2054964","caption":"data list in admin menu"},{"src":"https:\/\/ps.w.org\/dbmaker\/assets\/screenshot-3.JPG?rev=2054964","caption":"search form editor"},{"src":"https:\/\/ps.w.org\/dbmaker\/assets\/screenshot-4.JPG?rev=2054964","caption":"search form in frontend"}],"raw_content":"<!--section=description-->\n<p>This plugin make simple database from csv.\nImport from csv files to custom post type.<\/p>\n\n<h3>features<\/h3>\n\n<ul>\n<li>you can make database from csv file<\/li>\n<li>import over 10000 records from csv file<\/li>\n<li>delete all data records<\/li>\n<li>support custom fields and taxonomies<\/li>\n<li>sort and search data in backend<\/li>\n<li>support shortcode for search form and result list in frontend<\/li>\n<li>import from csv, insert only. update record not supported.<\/li>\n<\/ul>\n\n<h3>Usage<\/h3>\n\n<h4>Create Database<\/h4>\n\n<ol>\n<li>Select DataBase Maker in admin menu. Add new post.<\/li>\n<li>Title is database name, it is displayed admin menu.<\/li>\n<li>Content is frontend search form. If content is empty, default form inserted.<\/li>\n<\/ol>\n\n<h4>Edit csv settings<\/h4>\n\n<ol>\n<li>post_type is database type<\/li>\n<li>format is column names order in csv files. comma separated. see <strong>column names<\/strong><\/li>\n<li>status is default post status.<\/li>\n<li>character encoding is csv file's encodeing<\/li>\n<li>\"skip lines\" : skip n lines<\/li>\n<li>\"public access\" is data status. if it is checked, public access from frontend.<\/li>\n<li>save post. <\/li>\n<\/ol>\n\n<h4>Import data from csv file<\/h4>\n\n<ol>\n<li>Select your database name  in admin menu.<\/li>\n<li>Select csv file and push \"read csv\", start importing.<\/li>\n<li>Display progress bar, please wait for a while.<\/li>\n<\/ol>\n\n<h4>Data operation in admin menu<\/h4>\n\n<ul>\n<li>keyword search target all columns<\/li>\n<li>taxonomy filter supported<\/li>\n<li>title, date and  custom fields support sorting.<\/li>\n<li>Delete all data supported<\/li>\n<\/ul>\n\n<h4>Create search form for frontend<\/h4>\n\n<ol>\n<li>Select DataBase Maker, edit database<\/li>\n<li>edit contents, see <strong>Short codes<\/strong><\/li>\n<li>save contents then view posts<\/li>\n<\/ol>\n\n<h3>Column names<\/h3>\n\n<ul>\n<li>post_title: title of the post<\/li>\n<li>post_author: (login or ID) The user name or user ID number<\/li>\n<li>post_date:<\/li>\n<li>post_excerpt:<\/li>\n<li>post_status:<\/li>\n<li>post_password:<\/li>\n<li>post_name:<\/li>\n<li>post_parent:<\/li>\n<li>menu_order:<\/li>\n<li>tax_{taxonomy}: (string, comma separated) Any field prefixed with tax_ will be used as a custom taxonomy.<\/li>\n<li>{custom_field_key}: Any other column labels used as custom field.<\/li>\n<\/ul>\n\n<h3>Short codes<\/h3>\n\n<h4>dbm_search<\/h4>\n\n<p>Create form tag for search. This code is enclosing.<\/p>\n\noption\n\n<ul>\n<li>post_type : <strong>required<\/strong> Search database post_type.<\/li>\n<li>posts_per_page : default: 5<\/li>\n<li>pager : This option set not empty string, pager support. default: ''<\/li>\n<\/ul>\n\n<h4>dbm_tax_checkbox<\/h4>\n\n<p>Create checkboxes for taxonomy<\/p>\n\noption\n\n<ul>\n<li>name : <strong>requried<\/strong> taxonomy name.(No \"tax_\" prefix)<\/li>\n<\/ul>\n\n<h4>dbm_tax_select<\/h4>\n\n<p>Create select tag for taxonomy.<\/p>\n\noption\n\n<ul>\n<li>name : <strong>requried<\/strong> taxonomy name.(No \"tax_\" prefix)<\/li>\n<li>multiple : This option set not empty string, multiple select box. default: ''<\/li>\n<li>size : Select tag size.<\/li>\n<\/ul>\n\n<h4>dbm_textbox<\/h4>\n\n<p>Create text input box<\/p>\n\noption\n\n<ul>\n<li>name : Set search target column name. 's' is target all columns. default : 's'<\/li>\n<li>required : true or false.  default : 'false'<\/li>\n<\/ul>\n\n<h4>dbm_result_table<\/h4>\n\n<p>Display search result table. This code need outside of dbm_search.<\/p>\n\noption\n\n<ul>\n<li>label : th tag names, comma separated.<\/li>\n<li>data : column names, comma separated.<\/li>\n<\/ul>\n\n<h4>dbm_result_pager<\/h4>\n\n<p>Output pager<\/p>\n\noption\n\n<ul>\n<li>label : pager button label. default : 'first, prev, next, last'<\/li>\n<\/ul>\n\n<h3>Arbitrary section<\/h3>\n\n<!--section=installation-->\n<ol>\n<li>Upload the plugin files to the <code>\/wp-content\/plugins\/plugin-name<\/code> directory, or install the plugin through the WordPress plugins screen directly.<\/li>\n<li>Activate the plugin through the 'Plugins' screen in WordPress<\/li>\n<li>Use the Settings-&gt;Plugin Name screen to configure the plugin<\/li>\n<li>(Make your instructions match the desired user flow for activating and installing your plugin. Include any steps that might be needed for explanatory purposes)<\/li>\n<\/ol>\n\n<!--section=faq-->\n<ul>\n<li>Can i export data to csv file?\nExport csv file not supported yet. ToDo.<\/li>\n<\/ul>\n\n<!--section=changelog-->\n<h4>1.2<\/h4>\n\n<p>*fix all delete bug.<\/p>\n\n<h4>1.1<\/h4>\n\n<ul>\n<li>add view link in database admin menu.<\/li>\n<li>no import empty records.<\/li>\n<li>add order and orderby parameter in frontend search.<\/li>\n<li>Shortcode dbm_search: add parameter preload. Set it, data list load on init.(orderby post_id, ASC)<\/li>\n<li>Back to seach result page in frontend, recently data list display.<\/li>\n<\/ul>\n\n<h4>1.0<\/h4>\n\n<ul>\n<li>first release<\/li>\n<\/ul>","raw_excerpt":"Simple database plugin. import csv file, delete all records, search and sort in backend, simple search form for frontend.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/sa.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/100052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sa.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/sa.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/sa.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=100052"}],"author":[{"embeddable":true,"href":"https:\/\/sa.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/castanet01"}],"wp:attachment":[{"href":"https:\/\/sa.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=100052"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/sa.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=100052"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/sa.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=100052"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/sa.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=100052"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/sa.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=100052"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/sa.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=100052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}