Really Simple CSV Importer

Version Description

First Release (beta)

Release Info

Developer	hissy
Plugin	Really Simple CSV Importer
Version	0.1
Comparing to
See all releases

Version 0.1

Files changed (7) hide show

LICENSE +339 -0
readme.txt +43 -0
rs-csv-importer.php +277 -0
sample/sample.csv +4 -0
sample/sample.ods +0 -0
wp_post_helper/README +22 -0
wp_post_helper/class-wp_post_helper.php +348 -0

LICENSE ADDED Viewed

	@@ -0,0 +1,339 @@


1	+ GNU GENERAL PUBLIC LICENSE
2	+ Version 2, June 1991
3	+
4	+ Copyright (C) 1989, 1991 Free Software Foundation, Inc.,
5	+ 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
6	+ Everyone is permitted to copy and distribute verbatim copies
7	+ of this license document, but changing it is not allowed.
8	+
9	+ Preamble
10	+
11	+ The licenses for most software are designed to take away your
12	+ freedom to share and change it. By contrast, the GNU General Public
13	+ License is intended to guarantee your freedom to share and change free
14	+ software--to make sure the software is free for all its users. This
15	+ General Public License applies to most of the Free Software
16	+ Foundation's software and to any other program whose authors commit to
17	+ using it. (Some other Free Software Foundation software is covered by
18	+ the GNU Lesser General Public License instead.) You can apply it to
19	+ your programs, too.
20	+
21	+ When we speak of free software, we are referring to freedom, not
22	+ price. Our General Public Licenses are designed to make sure that you
23	+ have the freedom to distribute copies of free software (and charge for
24	+ this service if you wish), that you receive source code or can get it
25	+ if you want it, that you can change the software or use pieces of it
26	+ in new free programs; and that you know you can do these things.
27	+
28	+ To protect your rights, we need to make restrictions that forbid
29	+ anyone to deny you these rights or to ask you to surrender the rights.
30	+ These restrictions translate to certain responsibilities for you if you
31	+ distribute copies of the software, or if you modify it.
32	+
33	+ For example, if you distribute copies of such a program, whether
34	+ gratis or for a fee, you must give the recipients all the rights that
35	+ you have. You must make sure that they, too, receive or can get the
36	+ source code. And you must show them these terms so they know their
37	+ rights.
38	+
39	+ We protect your rights with two steps: (1) copyright the software, and
40	+ (2) offer you this license which gives you legal permission to copy,
41	+ distribute and/or modify the software.
42	+
43	+ Also, for each author's protection and ours, we want to make certain
44	+ that everyone understands that there is no warranty for this free
45	+ software. If the software is modified by someone else and passed on, we
46	+ want its recipients to know that what they have is not the original, so
47	+ that any problems introduced by others will not reflect on the original
48	+ authors' reputations.
49	+
50	+ Finally, any free program is threatened constantly by software
51	+ patents. We wish to avoid the danger that redistributors of a free
52	+ program will individually obtain patent licenses, in effect making the
53	+ program proprietary. To prevent this, we have made it clear that any
54	+ patent must be licensed for everyone's free use or not licensed at all.
55	+
56	+ The precise terms and conditions for copying, distribution and
57	+ modification follow.
58	+
59	+ GNU GENERAL PUBLIC LICENSE
60	+ TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
61	+
62	+ 0. This License applies to any program or other work which contains
63	+ a notice placed by the copyright holder saying it may be distributed
64	+ under the terms of this General Public License. The "Program", below,
65	+ refers to any such program or work, and a "work based on the Program"
66	+ means either the Program or any derivative work under copyright law:
67	+ that is to say, a work containing the Program or a portion of it,
68	+ either verbatim or with modifications and/or translated into another
69	+ language. (Hereinafter, translation is included without limitation in
70	+ the term "modification".) Each licensee is addressed as "you".
71	+
72	+ Activities other than copying, distribution and modification are not
73	+ covered by this License; they are outside its scope. The act of
74	+ running the Program is not restricted, and the output from the Program
75	+ is covered only if its contents constitute a work based on the
76	+ Program (independent of having been made by running the Program).
77	+ Whether that is true depends on what the Program does.
78	+
79	+ 1. You may copy and distribute verbatim copies of the Program's
80	+ source code as you receive it, in any medium, provided that you
81	+ conspicuously and appropriately publish on each copy an appropriate
82	+ copyright notice and disclaimer of warranty; keep intact all the
83	+ notices that refer to this License and to the absence of any warranty;
84	+ and give any other recipients of the Program a copy of this License
85	+ along with the Program.
86	+
87	+ You may charge a fee for the physical act of transferring a copy, and
88	+ you may at your option offer warranty protection in exchange for a fee.
89	+
90	+ 2. You may modify your copy or copies of the Program or any portion
91	+ of it, thus forming a work based on the Program, and copy and
92	+ distribute such modifications or work under the terms of Section 1
93	+ above, provided that you also meet all of these conditions:
94	+
95	+ a) You must cause the modified files to carry prominent notices
96	+ stating that you changed the files and the date of any change.
97	+
98	+ b) You must cause any work that you distribute or publish, that in
99	+ whole or in part contains or is derived from the Program or any
100	+ part thereof, to be licensed as a whole at no charge to all third
101	+ parties under the terms of this License.
102	+
103	+ c) If the modified program normally reads commands interactively
104	+ when run, you must cause it, when started running for such
105	+ interactive use in the most ordinary way, to print or display an
106	+ announcement including an appropriate copyright notice and a
107	+ notice that there is no warranty (or else, saying that you provide
108	+ a warranty) and that users may redistribute the program under
109	+ these conditions, and telling the user how to view a copy of this
110	+ License. (Exception: if the Program itself is interactive but
111	+ does not normally print such an announcement, your work based on
112	+ the Program is not required to print an announcement.)
113	+
114	+ These requirements apply to the modified work as a whole. If
115	+ identifiable sections of that work are not derived from the Program,
116	+ and can be reasonably considered independent and separate works in
117	+ themselves, then this License, and its terms, do not apply to those
118	+ sections when you distribute them as separate works. But when you
119	+ distribute the same sections as part of a whole which is a work based
120	+ on the Program, the distribution of the whole must be on the terms of
121	+ this License, whose permissions for other licensees extend to the
122	+ entire whole, and thus to each and every part regardless of who wrote it.
123	+
124	+ Thus, it is not the intent of this section to claim rights or contest
125	+ your rights to work written entirely by you; rather, the intent is to
126	+ exercise the right to control the distribution of derivative or
127	+ collective works based on the Program.
128	+
129	+ In addition, mere aggregation of another work not based on the Program
130	+ with the Program (or with a work based on the Program) on a volume of
131	+ a storage or distribution medium does not bring the other work under
132	+ the scope of this License.
133	+
134	+ 3. You may copy and distribute the Program (or a work based on it,
135	+ under Section 2) in object code or executable form under the terms of
136	+ Sections 1 and 2 above provided that you also do one of the following:
137	+
138	+ a) Accompany it with the complete corresponding machine-readable
139	+ source code, which must be distributed under the terms of Sections
140	+ 1 and 2 above on a medium customarily used for software interchange; or,
141	+
142	+ b) Accompany it with a written offer, valid for at least three
143	+ years, to give any third party, for a charge no more than your
144	+ cost of physically performing source distribution, a complete
145	+ machine-readable copy of the corresponding source code, to be
146	+ distributed under the terms of Sections 1 and 2 above on a medium
147	+ customarily used for software interchange; or,
148	+
149	+ c) Accompany it with the information you received as to the offer
150	+ to distribute corresponding source code. (This alternative is
151	+ allowed only for noncommercial distribution and only if you
152	+ received the program in object code or executable form with such
153	+ an offer, in accord with Subsection b above.)
154	+
155	+ The source code for a work means the preferred form of the work for
156	+ making modifications to it. For an executable work, complete source
157	+ code means all the source code for all modules it contains, plus any
158	+ associated interface definition files, plus the scripts used to
159	+ control compilation and installation of the executable. However, as a
160	+ special exception, the source code distributed need not include
161	+ anything that is normally distributed (in either source or binary
162	+ form) with the major components (compiler, kernel, and so on) of the
163	+ operating system on which the executable runs, unless that component
164	+ itself accompanies the executable.
165	+
166	+ If distribution of executable or object code is made by offering
167	+ access to copy from a designated place, then offering equivalent
168	+ access to copy the source code from the same place counts as
169	+ distribution of the source code, even though third parties are not
170	+ compelled to copy the source along with the object code.
171	+
172	+ 4. You may not copy, modify, sublicense, or distribute the Program
173	+ except as expressly provided under this License. Any attempt
174	+ otherwise to copy, modify, sublicense or distribute the Program is
175	+ void, and will automatically terminate your rights under this License.
176	+ However, parties who have received copies, or rights, from you under
177	+ this License will not have their licenses terminated so long as such
178	+ parties remain in full compliance.
179	+
180	+ 5. You are not required to accept this License, since you have not
181	+ signed it. However, nothing else grants you permission to modify or
182	+ distribute the Program or its derivative works. These actions are
183	+ prohibited by law if you do not accept this License. Therefore, by
184	+ modifying or distributing the Program (or any work based on the
185	+ Program), you indicate your acceptance of this License to do so, and
186	+ all its terms and conditions for copying, distributing or modifying
187	+ the Program or works based on it.
188	+
189	+ 6. Each time you redistribute the Program (or any work based on the
190	+ Program), the recipient automatically receives a license from the
191	+ original licensor to copy, distribute or modify the Program subject to
192	+ these terms and conditions. You may not impose any further
193	+ restrictions on the recipients' exercise of the rights granted herein.
194	+ You are not responsible for enforcing compliance by third parties to
195	+ this License.
196	+
197	+ 7. If, as a consequence of a court judgment or allegation of patent
198	+ infringement or for any other reason (not limited to patent issues),
199	+ conditions are imposed on you (whether by court order, agreement or
200	+ otherwise) that contradict the conditions of this License, they do not
201	+ excuse you from the conditions of this License. If you cannot
202	+ distribute so as to satisfy simultaneously your obligations under this
203	+ License and any other pertinent obligations, then as a consequence you
204	+ may not distribute the Program at all. For example, if a patent
205	+ license would not permit royalty-free redistribution of the Program by
206	+ all those who receive copies directly or indirectly through you, then
207	+ the only way you could satisfy both it and this License would be to
208	+ refrain entirely from distribution of the Program.
209	+
210	+ If any portion of this section is held invalid or unenforceable under
211	+ any particular circumstance, the balance of the section is intended to
212	+ apply and the section as a whole is intended to apply in other
213	+ circumstances.
214	+
215	+ It is not the purpose of this section to induce you to infringe any
216	+ patents or other property right claims or to contest validity of any
217	+ such claims; this section has the sole purpose of protecting the
218	+ integrity of the free software distribution system, which is
219	+ implemented by public license practices. Many people have made
220	+ generous contributions to the wide range of software distributed
221	+ through that system in reliance on consistent application of that
222	+ system; it is up to the author/donor to decide if he or she is willing
223	+ to distribute software through any other system and a licensee cannot
224	+ impose that choice.
225	+
226	+ This section is intended to make thoroughly clear what is believed to
227	+ be a consequence of the rest of this License.
228	+
229	+ 8. If the distribution and/or use of the Program is restricted in
230	+ certain countries either by patents or by copyrighted interfaces, the
231	+ original copyright holder who places the Program under this License
232	+ may add an explicit geographical distribution limitation excluding
233	+ those countries, so that distribution is permitted only in or among
234	+ countries not thus excluded. In such case, this License incorporates
235	+ the limitation as if written in the body of this License.
236	+
237	+ 9. The Free Software Foundation may publish revised and/or new versions
238	+ of the General Public License from time to time. Such new versions will
239	+ be similar in spirit to the present version, but may differ in detail to
240	+ address new problems or concerns.
241	+
242	+ Each version is given a distinguishing version number. If the Program
243	+ specifies a version number of this License which applies to it and "any
244	+ later version", you have the option of following the terms and conditions
245	+ either of that version or of any later version published by the Free
246	+ Software Foundation. If the Program does not specify a version number of
247	+ this License, you may choose any version ever published by the Free Software
248	+ Foundation.
249	+
250	+ 10. If you wish to incorporate parts of the Program into other free
251	+ programs whose distribution conditions are different, write to the author
252	+ to ask for permission. For software which is copyrighted by the Free
253	+ Software Foundation, write to the Free Software Foundation; we sometimes
254	+ make exceptions for this. Our decision will be guided by the two goals
255	+ of preserving the free status of all derivatives of our free software and
256	+ of promoting the sharing and reuse of software generally.
257	+
258	+ NO WARRANTY
259	+
260	+ 11. BECAUSE THE PROGRAM IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY
261	+ FOR THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN
262	+ OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES
263	+ PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED
264	+ OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
265	+ MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS
266	+ TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU. SHOULD THE
267	+ PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING,
268	+ REPAIR OR CORRECTION.
269	+
270	+ 12. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING
271	+ WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR
272	+ REDISTRIBUTE THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES,
273	+ INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING
274	+ OUT OF THE USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED
275	+ TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY
276	+ YOU OR THIRD PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER
277	+ PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE
278	+ POSSIBILITY OF SUCH DAMAGES.
279	+
280	+ END OF TERMS AND CONDITIONS
281	+
282	+ How to Apply These Terms to Your New Programs
283	+
284	+ If you develop a new program, and you want it to be of the greatest
285	+ possible use to the public, the best way to achieve this is to make it
286	+ free software which everyone can redistribute and change under these terms.
287	+
288	+ To do so, attach the following notices to the program. It is safest
289	+ to attach them to the start of each source file to most effectively
290	+ convey the exclusion of warranty; and each file should have at least
291	+ the "copyright" line and a pointer to where the full notice is found.
292	+
293	+ {{description}}
294	+ Copyright (C) {{year}} {{fullname}}
295	+
296	+ This program is free software; you can redistribute it and/or modify
297	+ it under the terms of the GNU General Public License as published by
298	+ the Free Software Foundation; either version 2 of the License, or
299	+ (at your option) any later version.
300	+
301	+ This program is distributed in the hope that it will be useful,
302	+ but WITHOUT ANY WARRANTY; without even the implied warranty of
303	+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
304	+ GNU General Public License for more details.
305	+
306	+ You should have received a copy of the GNU General Public License along
307	+ with this program; if not, write to the Free Software Foundation, Inc.,
308	+ 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
309	+
310	+ Also add information on how to contact you by electronic and paper mail.
311	+
312	+ If the program is interactive, make it output a short notice like this
313	+ when it starts in an interactive mode:
314	+
315	+ Gnomovision version 69, Copyright (C) year name of author
316	+ Gnomovision comes with ABSOLUTELY NO WARRANTY; for details type `show w'.
317	+ This is free software, and you are welcome to redistribute it
318	+ under certain conditions; type `show c' for details.
319	+
320	+ The hypothetical commands `show w' and `show c' should show the appropriate
321	+ parts of the General Public License. Of course, the commands you use may
322	+ be called something other than `show w' and `show c'; they could even be
323	+ mouse-clicks or menu items--whatever suits your program.
324	+
325	+ You should also get your employer (if you work as a programmer) or your
326	+ school, if any, to sign a "copyright disclaimer" for the program, if
327	+ necessary. Here is a sample; alter the names:
328	+
329	+ Yoyodyne, Inc., hereby disclaims all copyright interest in the program
330	+ `Gnomovision' (which makes passes at compilers) written by James Hacker.
331	+
332	+ {signature of Ty Coon}, 1 April 1989
333	+ Ty Coon, President of Vice
334	+
335	+ This General Public License does not permit incorporating your program into
336	+ proprietary programs. If your program is a subroutine library, you may
337	+ consider it more useful to permit linking proprietary applications with the
338	+ library. If this is what you want to do, use the GNU Lesser General
339	+ Public License instead of this License.

readme.txt ADDED Viewed

	@@ -0,0 +1,43 @@


1	+ === Really Simple CSV Importer ===
2	+ Contributors: hissy, wokamoto
3	+ Tags: importer, csv
4	+ Requires at least: 3.0
5	+ Tested up to: 3.6
6	+ Stable tag: 0.1
7	+ License: GPLv2 or later
8	+ License URI: http://www.gnu.org/licenses/gpl-2.0.html
9	+
10	+ Import posts, custom fields, taxonomies from csv file.
11	+
12	+ == Description ==
13	+
14	+ Alternative CSV Importer plugin. Simple and powerful.
15	+
16	+ * Category support
17	+ * Tag support
18	+ * Custom field support
19	+ * Custom post type support
20	+
21	+ Contains CSV file sample in plugin_dir/rs-csv-importer/sample .
22	+
23	+ Available values:
24	+ * post_name: (string) post slug
25	+ * post_author: (login or ID) author
26	+ * post_date: (string) publish date
27	+ * post_type: (string) post type
28	+ * post_status: (string) post status
29	+ * post_title: (string) post title
30	+ * post_content: (string) post content
31	+ * post_category: (string, comma divided) slug of post categories
32	+ * post_tags: (string, comma divided) name of post tags
33	+ * {custom_field}: any other column labels used as custom field
34	+
35	+ == Installation ==
36	+
37	+ 1. Upload All files to the `/wp-content/plugins/` directory
38	+ 2. Activate the plugin through the 'Plugins' menu in WordPress
39	+
40	+ == Changelog ==
41	+
42	+ = 0.1 =
43	+ * First Release (beta)

rs-csv-importer.php ADDED Viewed

	@@ -0,0 +1,277 @@


1	+ <?php
2	+ /*
3	+ Plugin Name: Really Simple CSV Importer
4	+ Description: Import posts, custom fields, taxonomies from csv file.
5	+ Author: Takuro Hishikawa, wokamoto
6	+ Author URI: http://notnil-creative.com/
7	+ Text Domain: rs-csv-importer
8	+ License: GPL version 2 or later - http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
9	+ Version: 0.1
10	+ */
11	+
12	+ if ( !defined('WP_LOAD_IMPORTERS') )
13	+ return;
14	+
15	+ // Load Importer API
16	+ require_once ABSPATH . 'wp-admin/includes/import.php';
17	+
18	+ if ( !class_exists( 'WP_Importer' ) ) {
19	+ $class_wp_importer = ABSPATH . 'wp-admin/includes/class-wp-importer.php';
20	+ if ( file_exists( $class_wp_importer ) )
21	+ require_once $class_wp_importer;
22	+ }
23	+
24	+ // Load WP Post Helper
25	+ require dirname( __FILE__ ) . '/wp_post_helper/class-wp_post_helper.php';
26	+
27	+ /**
28	+ * CSV Importer
29	+ *
30	+ * @package WordPress
31	+ * @subpackage Importer
32	+ */
33	+ if ( class_exists( 'WP_Importer' ) ) {
34	+ class RS_CSV_Importer extends WP_Importer {
35	+
36	+ /** Sheet columns
37	+ * @value array
38	+ */
39	+ var $columns = array();
40	+ var $column_raw = array();
41	+
42	+ /** Delimiter
43	+ * @var string
44	+ */
45	+ const DELIMITER = ",";
46	+
47	+ // Utility functions
48	+ function fopen($filename, $mode='r') {
49	+ return fopen($filename, $mode);
50	+ }
51	+
52	+ function fgetcsv($handle, $length = 0) {
53	+ return fgetcsv($handle, $length, self::DELIMITER);
54	+ }
55	+
56	+ function fclose($fp) {
57	+ return fclose($fp);
58	+ }
59	+
60	+ // User interface wrapper start
61	+ function header() {
62	+ echo '<div class="wrap">';
63	+ screen_icon();
64	+ echo '<h2>'.__('Import CSV', 'rs-csv-importer').'</h2>';
65	+ }
66	+
67	+ // User interface wrapper end
68	+ function footer() {
69	+ echo '</div>';
70	+ }
71	+
72	+ // Step 1
73	+ function greet() {
74	+ $this->header();
75	+ echo '<p>'.__( 'Choose a CSV (.csv) file to upload, then click Upload file and import.', 'rs-csv-importer' ).'</p>';
76	+ echo '<ol>';
77	+ echo '<li>'.__( 'Select UTF-8 as charset.', 'rs-csv-importer' ).'</li>';
78	+ echo '<li>'.sprintf( __( 'You must use field delimiter as "%s"', 'rs-csv-importer'), self::DELIMITER ).'</li>';
79	+ echo '<li>'.__( 'You must quote all text cells.', 'rs-csv-importer' ).'</li>';
80	+ echo '</ol>';
81	+ wp_import_upload_form( add_query_arg('step', 1) );
82	+ $this->footer();
83	+ }
84	+
85	+ // Step 2
86	+ function import() {
87	+ $this->header();
88	+
89	+ $file = wp_import_handle_upload();
90	+
91	+ if ( isset( $file['error'] ) ) {
92	+ echo '<p>' . esc_html( $file['error'] ) . '</p>';
93	+ return false;
94	+ }
95	+
96	+ $this->id = (int) $file['id'];
97	+ $this->file = get_attached_file($this->id);
98	+ $result = $this->process_posts();
99	+ if ( is_wp_error( $result ) )
100	+ return $result;
101	+
102	+ $this->footer();
103	+ }
104	+
105	+ /** Parsing header row, setup the columns definition.
106	+ * @param array $data name of columns
107	+ */
108	+ function parse_columns($data=array()) {
109	+ $columns = array();
110	+ foreach ($data as $key => $value) {
111	+ $columns[$value] = $key;
112	+ }
113	+ $this->columns = $columns;
114	+ $this->column_raw = $data;
115	+ }
116	+
117	+ /** Insert post and postmeta using wp_post_helper
118	+ * @param array $post
119	+ * @param array $meta
120	+ * More information: https://gist.github.com/4084471
121	+ */
122	+ function save_post($post,$meta) {
123	+ $ph = new wp_post_helper($post);
124	+
125	+ foreach ($meta as $key => $value) {
126	+ $ph->add_meta($key,$value,true);
127	+ }
128	+
129	+ $ph->insert();
130	+
131	+ unset($ph);
132	+ }
133	+
134	+ // process parse csv ind insert posts
135	+ function process_posts() {
136	+ global $wpdb;
137	+
138	+ $handle = $this->fopen($this->file, 'r');
139	+ if ( $handle == null )
140	+ return false;
141	+
142	+ $is_first = true;
143	+
144	+ echo '<ol>';
145	+
146	+ while (($data = $this->fgetcsv($handle)) !== FALSE) {
147	+ if ($is_first) {
148	+ $this->parse_columns( $data );
149	+ $is_first = false;
150	+ } else {
151	+ $post = array();
152	+
153	+ // (string) post slug
154	+ if (isset($data[$this->columns['post_name']]) && !empty($data[$this->columns['post_name']])) {
155	+ $post['post_name'] = $data[$this->columns['post_name']];
156	+ unset($data[$this->columns['post_name']]);
157	+ }
158	+
159	+ // (login or ID) post_author
160	+ if (isset($data[$this->columns['post_author']]) && !empty($data[$this->columns['post_author']])) {
161	+ $post_author = $data[$this->columns['post_author']];
162	+ if (is_int($post_author)) {
163	+ $post['post_author'] = $post_author;
164	+ } else {
165	+ $post_author = get_user_by('login',$post_author);
166	+ if (is_object($post_author)) {
167	+ $post['post_author'] = $data[$post_author->ID];
168	+ }
169	+ }
170	+ unset($data[$this->columns['post_author']]);
171	+ unset($post_author);
172	+ }
173	+
174	+ // (string) publish date
175	+ if (isset($data[$this->columns['post_date']]) && !empty($data[$this->columns['post_date']])) {
176	+ $post_date = $data[$this->columns['post_date']];
177	+ $post_date = date("Y-m-d H:i:s", strtotime($post_date));
178	+ $post['post_date'] = $post_date;
179	+ unset($data[$this->columns['post_date']]);
180	+ unset($post_date);
181	+ }
182	+
183	+ // (string) post type
184	+ if (isset($data[$this->columns['post_type']]) && !empty($data[$this->columns['post_type']])) {
185	+ $post['post_type'] = $data[$this->columns['post_type']];
186	+ unset($data[$this->columns['post_type']]);
187	+ }
188	+
189	+ // (string) post status
190	+ if (isset($data[$this->columns['post_status']]) && !empty($data[$this->columns['post_status']])) {
191	+ $post['post_status'] = $data[$this->columns['post_status']];
192	+ unset($data[$this->columns['post_status']]);
193	+ }
194	+
195	+ // (string) post title
196	+ $post['post_title'] = '';
197	+ if (isset($data[$this->columns['post_title']]) && !empty($data[$this->columns['post_title']])) {
198	+ $post['post_title'] = $data[$this->columns['post_title']];
199	+ unset($data[$this->columns['post_title']]);
200	+ }
201	+
202	+ // (string) post content
203	+ if (isset($data[$this->columns['post_content']]) && !empty($data[$this->columns['post_content']])) {
204	+ $post['post_content'] = $data[$this->columns['post_content']];
205	+ unset($data[$this->columns['post_content']]);
206	+ }
207	+
208	+ // (string, comma divided) slug of post categories
209	+ if (isset($data[$this->columns['post_category']]) && !empty($data[$this->columns['post_category']])) {
210	+ $categories = preg_split("/[\s,]+/", $data[$this->columns['post_category']]);
211	+ if ($categories) {
212	+ $post['post_category'] = wp_create_categories($categories);
213	+ }
214	+ unset($data[$this->columns['post_category']]);
215	+ unset($categories);
216	+ }
217	+
218	+ // (string, comma divided) name of post tags
219	+ if (isset($data[$this->columns['post_tags']]) && !empty($data[$this->columns['post_tags']])) {
220	+ $tags = preg_split("/[\s,]+/", $data[$this->columns['post_tags']]);
221	+ if ($tags) {
222	+ $post['post_tags'] = $tags;
223	+ }
224	+ unset($data[$this->columns['post_tags']]);
225	+ }
226	+
227	+ $meta = array();
228	+ foreach ($data as $key => $value) {
229	+ if (!empty($value)) {
230	+ $meta[$this->column_raw[$key]] = $value;
231	+ }
232	+ }
233	+
234	+ $this->save_post($post,$meta);
235	+
236	+ echo '<li>'.esc_html($post['post_title']).'</li>';
237	+ }
238	+ }
239	+
240	+ echo '</ol>';
241	+
242	+ $this->fclose($handle);
243	+
244	+ wp_import_cleanup($this->id);
245	+
246	+ echo '<h3>'.__('All Done.', 'rs-csv-importer').'</h3>';
247	+ }
248	+
249	+ // dispatcher
250	+ function dispatch() {
251	+ if (empty ($_GET['step']))
252	+ $step = 0;
253	+ else
254	+ $step = (int) $_GET['step'];
255	+
256	+ switch ($step) {
257	+ case 0 :
258	+ $this->greet();
259	+ break;
260	+ case 1 :
261	+ check_admin_referer('import-upload');
262	+ set_time_limit(0);
263	+ $result = $this->import();
264	+ if ( is_wp_error( $result ) )
265	+ echo $result->get_error_message();
266	+ break;
267	+ }
268	+ }
269	+
270	+ }
271	+
272	+ // setup importer
273	+ $rs_csv_importer = new RS_CSV_Importer();
274	+
275	+ register_importer('csv', __('CSV', 'rs-csv-importer'), __('Import posts, custom fields, taxonomies from csv file.', 'rs-csv-importer'), array ($rs_csv_importer, 'dispatch'));
276	+
277	+ } // class_exists( 'WP_Importer' )

sample/sample.csv ADDED Viewed

	@@ -0,0 +1,4 @@


1	+ "post_name","post_author","post_date","post_type","post_status","post_title","post_content","post_category","post_tags","custom_field","_is_imported"
2	+ "Import-test","admin",2013/9/13 0:00,,"publish","CSV Import Test","This is a post for csv import.
3	+ Hello dolly.","fruits","apple,banana","this is custom field value.",1
4	+ ,"editor",,"post",,"editor post",,"undefined",,,

sample/sample.ods ADDED Viewed

Binary file

wp_post_helper/README ADDED Viewed

	@@ -0,0 +1,22 @@


1	+ en : https://gist.github.com/4084471
2	+ ja : https://gist.github.com/4078027
3	+
4	+ License:
5	+ Released under the GPL license
6	+ http://www.gnu.org/copyleft/gpl.html
7	+
8	+ Copyright 2013 (email : wokamoto1973@gmail.com)
9	+
10	+ This program is free software; you can redistribute it and/or modify
11	+ it under the terms of the GNU General Public License as published by
12	+ the Free Software Foundation; either version 2 of the License, or
13	+ (at your option) any later version.
14	+
15	+ This program is distributed in the hope that it will be useful,
16	+ but WITHOUT ANY WARRANTY; without even the implied warranty of
17	+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18	+ GNU General Public License for more details.
19	+
20	+ You should have received a copy of the GNU General Public License
21	+ along with this program; if not, write to the Free Software
22	+ Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA

wp_post_helper/class-wp_post_helper.php ADDED Viewed

	@@ -0,0 +1,348 @@


1	+ <?php
2	+ /*
3	+ en : https://gist.github.com/4084471
4	+ ja : https://gist.github.com/4078027
5	+
6	+ License:
7	+ Released under the GPL license
8	+ http://www.gnu.org/copyleft/gpl.html
9	+
10	+ Copyright 2013 (email : wokamoto1973@gmail.com)
11	+
12	+ This program is free software; you can redistribute it and/or modify
13	+ it under the terms of the GNU General Public License as published by
14	+ the Free Software Foundation; either version 2 of the License, or
15	+ (at your option) any later version.
16	+
17	+ This program is distributed in the hope that it will be useful,
18	+ but WITHOUT ANY WARRANTY; without even the implied warranty of
19	+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20	+ GNU General Public License for more details.
21	+
22	+ You should have received a copy of the GNU General Public License
23	+ along with this program; if not, write to the Free Software
24	+ Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
25	+ */
26	+
27	+ if (defined('ABSPATH')) :
28	+
29	+ require_once(ABSPATH . 'wp-admin/includes/image.php');
30	+ require_once(ABSPATH . 'wp-admin/includes/post.php');
31	+
32	+ class wp_post_helper {
33	+ public $post;
34	+
35	+ private $postid = false;
36	+ private $attachment_id = array();
37	+
38	+ private $tags = array();
39	+ private $medias = array();
40	+ private $metas = array();
41	+ private $fields = array();
42	+ private $media_count = 0;
43	+ private $terms = array();
44	+
45	+ function __construct($args = array()){
46	+ $this->init($args);
47	+ }
48	+
49	+ // Get PostID
50	+ public function postid(){
51	+ return $this->postid;
52	+ }
53	+
54	+ // Get Attachment ID
55	+ public function attachment_id(){
56	+ return $this->attachment_id;
57	+ }
58	+
59	+ // Init Post Data
60	+ public function init($args = array()){
61	+ if (is_object($args))
62	+ $args = (array)$args;
63	+ $this->attachment_id = array();
64	+ $this->tags = array();
65	+ $this->medias = array();
66	+ $this->metas = array();
67	+ $this->fields = array();
68	+ $this->media_count = 0;
69	+
70	+ if (is_numeric($args)) {
71	+ $post = get_post(intval($args));
72	+ if ($post && isset($post->ID) && !is_wp_error($post)) {
73	+ $this->post_id = $post->ID;
74	+ $this->post = $post;
75	+ return true;
76	+ } else {
77	+ return false;
78	+ }
79	+ } else {
80	+ $this->post = get_default_post_to_edit();
81	+ $this->post->post_category = null;
82	+ if (is_array($args) && count($args) > 0)
83	+ return $this->set($args);
84	+ else
85	+ return true;
86	+ }
87	+ }
88	+
89	+ // Set Post Data
90	+ public function set($args) {
91	+ if (is_object($args))
92	+ $args = (array)$args;
93	+ if (!is_array($args))
94	+ return false;
95	+
96	+ if (isset($args['ID']) \|\| isset($args['post_id'])) {
97	+ $post_id = isset($args['ID']) ? $args['ID'] : $args['post_id'];
98	+ $post = get_post($post_id, 'ARRAY_A');
99	+ if (isset($post['ID'])) {
100	+ $this->post_id = $post_id;
101	+ $this->post->ID = $post_id;
102	+ unset($post['ID']);
103	+ $this->set($post);
104	+ }
105	+ unset($post);
106	+ }
107	+
108	+ $post = $this->post;
109	+ foreach ($post as $key => &$val) {
110	+ if ($key !== 'ID' && isset($args[$key])) {
111	+ $val = $args[$key];
112	+ }
113	+ }
114	+ $this->post = $post;
115	+
116	+ if (isset($args['post_tags'])) {
117	+ $this->add_tags(
118	+ is_array($args['post_tags'])
119	+ ? $args['post_tags']
120	+ : explode(',', $args['post_tags'])
121	+ );
122	+ }
123	+
124	+ return true;
125	+ }
126	+
127	+ // Add Post
128	+ public function insert(){
129	+ if (!isset($this->post))
130	+ return false;
131	+
132	+ $this->postid = 0;
133	+ $this->post->ID = 0;
134	+ $postid = wp_insert_post($this->post);
135	+ if ($postid && !is_wp_error($postid)) {
136	+ $this->postid = $postid;
137	+ $this->post->ID = $postid;
138	+ return $this->add_related_meta($postid) ? $postid : false;
139	+ } else {
140	+ $this->postid = $postid;
141	+ $this->post->ID = 0;
142	+ return false;
143	+ }
144	+ }
145	+
146	+ // Update Post
147	+ public function update(){
148	+ if (!isset($this->post))
149	+ return false;
150	+
151	+ $postid =
152	+ $this->postid
153	+ ? wp_update_post($this->post)
154	+ : wp_insert_post($this->post);
155	+ if ($postid && !is_wp_error($postid)) {
156	+ $this->postid = $postid;
157	+ $this->post->ID = $postid;
158	+ return $this->add_related_meta($postid) ? $postid : false;
159	+ } else {
160	+ $this->postid = false;
161	+ $this->post->ID = 0;
162	+ return false;
163	+ }
164	+ }
165	+
166	+ private function add_related_meta($postid){
167	+ if (!$postid \|\| is_wp_error($postid))
168	+ return false;
169	+
170	+ $this->postid = $postid;
171	+
172	+ // add Tags
173	+ if (count($this->tags) > 0)
174	+ $this->add_tags($this->tags);
175	+ $this->tags = array();
176	+
177	+ // add medias
178	+ foreach ($this->medias as $key => $val) {
179	+ $this->add_media($key, $val[0], $val[1], $val[2], $val[3]);
180	+ }
181	+ $this->medias = array();
182	+
183	+ // add terms
184	+ foreach ($this->terms as $taxonomy => $terms) {
185	+ $this->add_terms($taxonomy, $terms);
186	+ }
187	+ $this->terms = array();
188	+
189	+ // add Custom Fields
190	+ foreach ($this->metas as $key => $val) {
191	+ if (is_array($val))
192	+ $this->add_meta($key, $val[0], isset($val[1]) ? $val[1] : true);
193	+ else
194	+ $this->add_meta($key, $val);
195	+ }
196	+ $this->metas = array();
197	+
198	+ // add ACF Fields
199	+ foreach ($this->fields as $key => $val) {
200	+ $this->add_field($key, $val);
201	+ }
202	+ $this->fields = array();
203	+
204	+ return true;
205	+ }
206	+
207	+ // Add Tag
208	+ public function add_tags($tags = array()){
209	+ $tags = is_array($tags) ? $tags : explode(',', $tags);
210	+ foreach ($tags as $tag) {
211	+ if (!empty($tag) && !array_search($tag, $this->tags))
212	+ $this->tags[] = $tag;
213	+ }
214	+ unset($tags);
215	+
216	+ if ($this->postid) {
217	+ $tags = implode(',', $this->tags);
218	+ $this->tags = array();
219	+ return wp_add_post_tags($this->postid, $tags);
220	+ }
221	+ }
222	+
223	+ // add terms
224	+ public function add_terms($taxonomy, $terms){
225	+ if (!$this->postid) {
226	+ if (!isset($this->terms[$taxonomy]))
227	+ $this->terms[$taxonomy] = array();
228	+ foreach((array)$terms as $term) {
229	+ if (array_search($term, $this->terms[$taxonomy]) === FALSE)
230	+ $this->terms[$taxonomy][] = $term;
231	+ }
232	+ } else {
233	+ return wp_set_object_terms($this->postid, $terms, $taxonomy);
234	+ }
235	+ }
236	+
237	+ // Add Media
238	+ public function add_media($filename, $title = null, $content = null, $excerpt = null, $thumbnail = false){
239	+ if (!$this->postid) {
240	+ $this->medias[$filename] = array(
241	+ $title,
242	+ $content,
243	+ $excerpt,
244	+ $thumbnail,
245	+ );
246	+ return;
247	+ }
248	+
249	+ if ( $filename && file_exists($filename) ) {
250	+ $mime_type = '';
251	+ $wp_filetype = wp_check_filetype(basename($filename), null);
252	+ if (isset($wp_filetype['type']) && $wp_filetype['type'])
253	+ $mime_type = $wp_filetype['type'];
254	+ unset($wp_filetype);
255	+
256	+ $title = isset($title) ? $title : preg_replace('/\.[^.]+$/', '', basename($filename));
257	+ $content = isset($content) ? $content : $title;
258	+ $excerpt = isset($excerpt) ? $excerpt : $content;
259	+ $attachment = array(
260	+ 'post_mime_type' => $mime_type ,
261	+ 'post_parent' => $this->postid ,
262	+ 'post_author' => $this->post->post_author ,
263	+ 'post_title' => $title ,
264	+ 'post_content' => $content ,
265	+ 'post_excerpt' => $excerpt ,
266	+ 'post_status' => 'inherit',
267	+ 'menu_order' => $this->media_count + 1,
268	+ );
269	+ if (isset($this->post->post_name) && $this->post->post_name)
270	+ $attachment['post_name'] = $this->post->post_name;
271	+ $attachment_id = wp_insert_attachment($attachment, $filename, $this->postid);
272	+ unset($attachment);
273	+
274	+ if (!is_wp_error($attachment_id)) {
275	+ $this->media_count++;
276	+ $this->attachment_id[] = $attachment_id;
277	+ $attachment_data = wp_generate_attachment_metadata($attachment_id, $filename);
278	+ wp_update_attachment_metadata($attachment_id, $attachment_data);
279	+ unset($attachment_data);
280	+ if ($thumbnail)
281	+ set_post_thumbnail($this->postid, $attachment_id);
282	+ return $attachment_id;
283	+ } else {
284	+ return false;
285	+ }
286	+ } else {
287	+ return false;
288	+ }
289	+ }
290	+
291	+ // Add Custom Field
292	+ public function add_meta($metakey, $val, $unique = true){
293	+ if (!$this->postid)
294	+ $this->metas[$metakey] = array($val, $unique);
295	+ else
296	+ return $val ? add_post_meta($this->postid, $metakey, $val, $unique) : false;
297	+ }
298	+
299	+ // Add Advanced Custom Field
300	+ public function add_field($field_key, $val){
301	+ if (!$this->postid)
302	+ $this->fields[$field_key] = $val;
303	+ else
304	+ return $val ? update_field($field_key, $val, $this->postid) : false;
305	+ }
306	+ }
307	+
308	+ function remote_get_file($url = null, $file_dir = '') {
309	+ if (!$url)
310	+ return false;
311	+
312	+ if (empty($file_dir)) {
313	+ $upload_dir = wp_upload_dir();
314	+ $file_dir = isset($upload_dir['path']) ? $upload_dir['path'] : '';
315	+ }
316	+ $file_dir = trailingslashit($file_dir);
317	+
318	+ // make directory
319	+ if (!file_exists($file_dir)) {
320	+ $dirs = explode('/', $file_dir);
321	+ $subdir = '/';
322	+ foreach ($dirs as $dir) {
323	+ if (!empty($dir)) {
324	+ $subdir .= $dir . '/';
325	+ if (!file_exists($subdir)) {
326	+ mkdir($subdir);
327	+ }
328	+ }
329	+ }
330	+ }
331	+
332	+ // remote get!
333	+ $photo = $file_dir . basename($url);
334	+ if ( !file_exists($photo) ) {
335	+ $response = wp_remote_get($url);
336	+ if ( !is_wp_error($response) && $response["response"]["code"] === 200 ) {
337	+ $photo_data = $response["body"];
338	+ file_put_contents($photo, $photo_data);
339	+ unset($photo_data);
340	+ } else {
341	+ $photo = false;
342	+ }
343	+ unset($response);
344	+ }
345	+ return file_exists($photo) ? $photo : false;
346	+ }
347	+
348	+ endif;

Really Simple CSV Importer - Version 0.1

Version Description

Release Info

Version 0.1