vendo cialis cialis preço comprar sildenafil viagra farmacia pastilla sildenafil vente de cialis zithromax prix levitra generico cialis vente en ligne acheter kamagra france ordina viagra achat cialis en ligne comprare viagra viagra donna levitra venta levitra pharmacie acheter cialis internet tadalafil generique medicament viagra cialis marche pas levitra prezzo acheter clomid en france kamagra rezeptfrei levitra farmacia dysfonction erectile levitra a vendre commande cialis viagra cialis differenze sildenafil kaufen cialis france pastilla viagra cialis generico viagra en ligne cialis ohne rezept venta de levitra ordina levitra propecia generique acheter cialis cialis ordonnance acheter cialis en pharmacie achat cialis generique acheter prozac viagra senza ricetta impuissance erection acheter isotretinoine vendo cialis prix du viagra viagra suisse viagra ricetta impotenza sessuale comprar cialis em portugal viagra kosten posologia viagra procurer du levitra viagra prijs acquisto viagra senza ricetta generische levitra cialis sans prescription procurer du cialis cialis prijs viagra kosten achete levitra levitra donna levitra sur internet generische viagra kamagra te koop acquisto viagra generico vendo sildenafil viagra vendita libera pharmacie en ligne prezzi levitra kamagra generique procurer du viagra commander kamagra compro cialis remede impuissance viagra kopen venta viagra cialis generico 10 mg levitra ricetta kamagra oral jelly viagra generico zyban generique acheter cialis en espagne acheter cialis sur internet cialis donne levitra en pharmacie acheter cialis generique levitra venta libre kamagra 100 acheter tadalafil viagra quanto costa le viagra sildenafil generique vardenafil generika acheter cialis generic cialis indien sildenafil rezeptfrei citrate de sildenafil levitra naturale cialis venta achat tadalafil costo levitra levitra generico comprar cialis generico tadalafil generico farmaci impotenza sildenafil sin receta commander du viagra achat vardenafil trouver du levitra pilule viagra levitra sur le net comprar cialis propecia moins cher cialis prescrizione compra viagra tadalafil rezeptfrei cialis 10mg cialis en pharmacie viagra pharmacie acheter du levitra viagra donne kamagra vente cialis belgique vardenafil generico acquista viagra viagra acquisto online achete cialis citrato di sildenafil levitra ohne rezept cialis generico prezzo

Importing Posts from CSV file into Wordpress

28 Mar

Posted by admin as wordpress

Problem: I have a big excel spreadsheet with posts and extra fields and I want to import it into Wordpress.

I haven’t found a plugin to do this so I decided to make my own. It’s not complete, and it’s not quite a ‘plugin’ but it works. Here’s how to do it:

Download CSV_Import class from me. csv2 post.
Unzip and up load the file called csv.php to /wp-admin/import/
Prepare your csv file, here is a sample file. It’s really a pipe delimited file. It MUST follow this format or it will not work. Make sure you include the header row.
In admin panel , go to Manage, Import, choose CSV
The rest is pretty self explanitory, upload file, pick a user, and voilá

93 Responses

Your Seventh Loyal Reader

April 1st, 2008 at 5:05 pm
1

NICE. I’ve been searching for something like this for-ev-er. I’m about to use it to create 288,000 pages. I will probably break it down into bite size chunks so everything doesn’t choke and die.

Any idea how many this can handle. Oh, and can I create unlimited (16 or so) fields with this? And can it create pages also or just posts? Sweet ass work, get a donation button doood.
Your Seventh Loyal Reader

April 2nd, 2008 at 2:08 pm
2

I am having troubles… can you look at this text file and help me figure out what I’m doing wrong?

wp_title|wp_post_date|wp_category|wp_content|zip|website|phone|attorney|position|sex|employees|revenue
A Conflict Management Ctr|12/31/07 23:59|anchorage|310 K St # 200|99501-2064|Not Available|9072646687|Not Available|Not Available|Not Available|6|1002000
A Fred Miller Attorneys At Law|12/31/07 23:59|ketchikan|426 Main St|99901-6316|Not Available|9072256666|A Fred Miller|Owner|Male|5|835000
A Robert Hahn Jr|12/31/07 23:59|anchorage|1500 W 33rd Ave|99503-3639|Not Available|9072791544|A Robert Hahn Jr|Not Available|Male|2|334000
admin

April 2nd, 2008 at 2:52 pm
3

Hey 7th loyal reader!

First things first, I’m glad you liked the code…even if it hasn’t worked for you yet.

I haven’t tested the code on WP 2.5 yet. The problem with your file though I think is the date format. You must follow

YYYY-MM-DD HH:MM:SS:MS

(dashes not slashes)…hope that was it.. let me know.
michael

April 12th, 2008 at 5:13 am
4

thanks for this awesome plugin.
i am working on a new project and need to import about 2000 posts.
every post includes an excerpt and data for the plugin “All in One SEO Pack”.

can i import these fields as well?
i assume i have to look in the mysql table for the corresponding table name and just add it to the csv file.
admin

April 12th, 2008 at 6:04 am
5

Hey Michael,

Sorry man…excerpts are not officially supported yet. I’ll work on it. Check back. Another thing, the plugin uses all WP functions…doesn’t talk directly to MySQL.
Nick

April 12th, 2008 at 11:27 am
6

Hey Zack,

I usually build my websites tree on spreadsheet so I will have the different levels of the website [categories(first level)--> subcategories(second level) --> sub-subcategories(third level)] deployed there.

I would like to import this into WP.

Is there a way to achieve this with your plugin?
admin

April 12th, 2008 at 2:33 pm
7

Hey Nick,

I’m currently adding support for cats/subcats. Check back.
michael

April 13th, 2008 at 12:04 pm
8

thanks for the update Zack,
you saved me hours of mindnumbing work.
Nick

April 14th, 2008 at 8:35 pm
9

Hey Zack,

Thanks for your reply. I already checked the update you posted but still can´t make it to do what I need…can I create with the updated version you posted sub-categories already?

If yes, could you provide a short example of the required syntax to define properly the child categories? Already tred but got no luck.

It would be great REALLY to have as many child categories created as desired.

Also, like mentioned above by Michael, the possibility to have titles, tags, etc passed to the All-in-One-SEO-Plugin would be Heaven.

All heavy WP users use it extensively so if you achieve this, your plugin is gonna rock for sure.

Thanks again for your time and keep it up! Looking forward for the updates.
Nick

April 15th, 2008 at 3:46 pm
10

Any news Zack?
admin

April 15th, 2008 at 5:32 pm
11

Hey Nick, see the new post
Nick

April 16th, 2008 at 7:18 am
12

Hey Zack,

Nice job…worked like charm. I am not sure if I missed it but are we able with the new version to pass parameters to the All-in-One SEO plugin?

Not sure if this can be achieved via the additional field tags…

Cheers
Nick

April 16th, 2008 at 7:21 am
13

Actually, would be great if you could provide a quick overview of how we’re supposed to use the extra fields & excerpts columns…
michael

April 17th, 2008 at 2:13 am
14

Hey Nick,
you can pass parameters to the All-in-One SEO plugin with csv_import.

just add “all-in-ONE SEO” custom fields to the txt file. put the “key” in the first row, and the values below.
logan

April 20th, 2008 at 2:14 pm
15

thanks! a lot.. this worked like a charm!
Adam

April 23rd, 2008 at 5:34 am
16

Hi Zack, thanks for the plugin. I’v not managed to get it to work yet though. After selecting my file and then clicking import I’m getting this message:

Import CSV

Warning: Cannot modify header information – headers already sent by (output started at /content/DesignerPlus/l/o/mydomain.co.uk/web/wp-admin/admin-header.php:16) in /content/DesignerPlus/l/o/mydomain.co.uk/web/wp-includes/functions.php on line 2448

Any ideas? As usual it’s probably something dead simple but I’ve just not worked it out yet. I think this site is on wordpress 2.0.4.
Thanks
nevergivemyname

April 24th, 2008 at 11:20 am
17

Just tried it out for 5 minutes but it looks really good so far !
ImportingPages?

April 26th, 2008 at 8:19 pm
18

How we can modify the plugin to import pages?

Thanks!
admin

April 26th, 2008 at 8:38 pm
19

I’m not sure how much work would be involved in changing the code to import pages instead of posts. The line/function used to import the post is

$post_id = wp_insert_post($postdata);

I started looking into what function is used to create a page and I can’t seem to find it (granted, I only looked for about 5 minutes). If anybody has the patience to find it, let me know, maybe I can add an ‘import page’ feature.
Your Seventh Loyal Reader

April 28th, 2008 at 5:30 pm
20

Hi there -

I still can’t get this to work for me… I’ve tried on a few version of WP. In some of my field values I am using spaces – does that matter? Does white space matter at all?

thanks!
Your Seventh Loyal Reader

April 28th, 2008 at 6:16 pm
21

I’m having such a hard time with this. Can I send you my text file to take a look at? I have tried so so many different things and it is just not working.

I have changed my date format as suggested, and in fact I have changed tons of things. I am saving a CSV from excel, opening in a Mac text editor, replacing my commas with pipes, and then saving as a .txt. Any help is much appreciated.

<B
Your Seventh Loyal Reader

April 28th, 2008 at 6:47 pm
22

I got it now — If any Mac users are out there going from an excel CSV to a text file, export from excel as a CSV(Windows) file in the sace as options. Duh, I feel like saying to myself, hopefully this will save someone else some time. Plug in rocks!! Thanks for your work Zack.
Nick

April 28th, 2008 at 8:30 pm
23

Hey Michael & Zack,

I´ve tried to insert the proper “keys” in the txt file to pass values to the All in One SEO plugin…I want to pass value for theses variables in the plugin: title, meta description & metakeywords.

Can you help me achieve this? Just a small example to clarify which are the correct “keys”?

Thanks in advanced guys!
Nick

April 30th, 2008 at 4:23 pm
24

Any help here guys?
ImportingPages?

May 9th, 2008 at 4:41 am
25

There are no difference between post and pages just the “post_type” field which has to be “page”
Loren

May 10th, 2008 at 5:35 pm
26

Hello: I’ve been looking for something like this! Thank you! I try to import and get the message “The uploaded file could not be moved to …httpdocs/wp/wp-content/uploads/2008/05. 121″. What am I doing wrong?
admin

May 10th, 2008 at 7:04 pm
27

Hi Loren,

wp-content needs to be writable by the server. Make sure permissions are right. Maybe that’s it.

Zack
lemon.head

May 14th, 2008 at 2:42 am
28

Hi!

I am interested in contributing to the development of your tool. What I’d like to have:
* possibility to import pages instead of posts
* control more columns than just the four you have.
* define default values for other columns
* column “id” to modify existing posts.
* export csv (with ids) for easy mass manipulation in excel. This export could happen automatically with every import.

Do you have a repository somewhere, where I could contribute?

Please contact me if you are interested in cooperation!
admin

May 15th, 2008 at 7:08 am
29

Hi LemonHead

Thanks for offering! Your ideas are great. I don’t know what repository to host the project. I don’t know if this script really qualifies as a plugin to submit to Wordpress.org because it runs under the admin/import section and not /plugin. I could be wrong…it may not make a difference to Wordpress under what dir the script runs. Anyway, I say this because they (wordpress.org) use SVN to keep versions of plugins and maybe we could collaborate through that. If you have any ideas on which repository to use please let me know. This could really turn into a great project.
Joe

May 15th, 2008 at 1:40 pm
30

Great it works like a charm
Thanks a lot
lemon.head

May 15th, 2008 at 7:48 pm
31

And another one
* allow more flexible input format

I prefer to not publish my email in public, but I hope you can find it on the admin backend.

About the repository. So far I have not bothered to get my own repository running somewhere. WP.org seems like an easy solution, so why not have a try.

Btw, I don’t find an rss link for the comments. I would like to keep up to date!

Thx, lem.
Max

May 16th, 2008 at 12:36 am
32

Hello,

Thanks for your great plugin first. Is it possible to have tag(s) support?
lemon.head

May 19th, 2008 at 5:47 pm
33

Now gave it some MVC, made the variables more local (I don’t like methods to communicate via class-scope variables), and made some things more logical (or what I perceive as more logical).

It’s going quite well, but now I am arriving at the tasty part, the process_post method, which at some point calls the WP function wp_insert_post(..). I am sure I can bite my way through, but I would be happy about some assistance and someone telling me what’s the idea behind all the lines of this function. Sometimes I think I can magically simplify things, but miss some of the original ideas which have been behind.

Another function which I don’t fully get is the get_tag() method. Is the user expected to put some XML tags into the input table?

Would be great if you can lighten me up a bit
dewaji

June 8th, 2008 at 7:12 pm
34

Nice plugins. But, how about if I want to put tags in there ? how to make it.

For example :
wp_title|wp_post_date|wp_category|wp_content|tags|field2|field3

I want to make it like this :
wp_title|wp_content|wp_category|wp_post_date|tags1, tags2, tags3, moretags
Lionel Chollet

June 18th, 2008 at 3:06 pm
35

Any way to insert custom slug/post_name?

I’d like to order posts by post_name (different than the sanitized post_title).

In my site’s scheme, post_title is the book’s title, post_name/slug is the book’s reference number.
Max

June 24th, 2008 at 2:26 pm
36

Hi, looks like a great plugin.

I’d like to use it to import datafeed items with images. How would I add an image field into csv and connect it to the post (wp-content)?

thanks.
Max

June 25th, 2008 at 6:12 pm
37

Hi,

I looked at discussion about All-in-one SEO plugin… How exactly txt line will look? Anybody can give an example?

…|wp-content|All-in-one SEO|tags
…|fun staff|Title: Post1, Description: test desc|test tag

????

Anybody can help please?
Nick

July 12th, 2008 at 11:48 am
38

Hey guys,

I am having issues while importing posts…for instance, whenever I have a new line or starting a tense on a different line the plugin assumes it’s a new post….any ideas on how to solve this?

Thanks a lot!

Nick
kamu

July 29th, 2008 at 8:15 pm
39

I tried to import post using rss/xml format but i had problem with the custom field. then someone suggested me to try this and voila! its working perfectly!
a million thanks to you zack.
Mike Smith - Bootstrapping Blog

August 4th, 2008 at 1:00 am
40

awesome work here. I do have a question though.

Do you know how to merge three cell columns together? ie: A, B and C

I have a csv file thats got 3 columns for different information but I need it all to go into one so I can add it into the wp_content column.

Any help is appreciated.

Thanks
Frank

August 12th, 2008 at 12:25 am
41

I think this is perfect for what I need… only problem is it’s not importing the content. Instead, it’s putting, for example from your sample, “My Post Title” and “Another Post” into the title and content fields.

I’m using Wordpress 2.6. Thanks a ton! If I can get this to work, you’ll have saved me hours of work!
Frank

August 12th, 2008 at 12:32 am
42

Ok, disregard my last comment. I must have had a something wrong. It’s working perfectly now! Thanks!

Do the spaces between the text and the pipe have to be spaces, or are tab’s ok?

Thanks again!
Marc Juneau

August 22nd, 2008 at 12:05 pm
43

All that is needed to make a “post” a “page” is one variable

online 292 of your script change:
$post_type = “post”;
to
$post_type = “page”;

im no php whiz but this seemed to work! i tried it with your test csv after only changing that one line and the sample shows up in my pages area of wordpress

by the way .. you ROCK thank you for posting this plugin i have been wanting something for this forever!
DiamondGeezer.com

August 24th, 2008 at 9:21 am
44

Is there a limit to the characters in wp_content
mine contains the following:

REBECCA is between 20 and 30 and is in a relationship (but not yet engaged or married). Rebecca LOVES the brand-name DiamondGeezer.com. and described the Diamond Geezer web site as EXCELLENT.She added ……TextPad loads an entire file into memory when you edit it, so the original file is not changed until you save the changes. You can opt to keep the original file as a backup when saving changes, and to keep it locked while you edit it.

But ends after She added ……
chantal

August 25th, 2008 at 8:17 am
45

Hi

This looks really great… just one, probably dumb question… how do I get a csv file to be pipe delimited?
chantal

August 25th, 2008 at 8:24 am
46

aarg dont worry… typically after spending 2 hours online etc to figure it out, I got it together after writing this note… apologies!
Bob

October 28th, 2008 at 12:43 pm
47

Hi,

need your help here:
uploaded the csv.php file to my plugins folder, but it doesn’t show up in the plugins dashboard?

I’m using wordpress 2.6.2 – is it working with that?

how can I fix this?

thanks a lot for your help,
bob
admin

October 28th, 2008 at 3:07 pm
48

Hi Bob,

This is not a traditional plugin. It goes in the wp-admin/import folder. You will see the link under Manage|Import

Zack
Bob

October 29th, 2008 at 10:35 am
49

Ah, great, now I got it. Thanks a lot, this is just what I was looking for.
Am still trying to figure out the details with how to do long posts with several paragraphs, currently it breaks them up into separate posts for some reason.

Thanks again!
Joel

November 9th, 2008 at 8:17 pm
50

Is there another way to upload the file to be imported (such as FTP)? The problem is, when I use the web form, it times out after 1000 posts and I have like 10,000 posts to import (long story…)
me

November 14th, 2008 at 2:09 am
51

Bob,

Having the same problem too. Any solution yet?

How to add new line for a single long post?

Any advise?
peter

November 24th, 2008 at 2:55 am
52

this plugin rocks. is it able to add tags? wp_tags
Mike

December 10th, 2008 at 1:18 am
53

I was thinking it would be nice if we could modify this to work with WP MU so that instead of uploading to a post or article, we could upload to a new blog subdomain. Is this too far fetched based on the current state of the plug-in?

Great plug-in regardless, truly a unique and completely useful tool in it’s current form, thank you so much!
M

December 17th, 2008 at 10:49 pm
54

Script is working fine, however not adding any tags to the posts imported.

Does anyone know the exact variables to use to make sure tags can be added?

I tried both “wp_content” and “the_tags”

Thanks. Great script.
Adem

December 18th, 2008 at 11:44 pm
55

I figured it out. Thanks.

For those of you that is having the same problem as me which is it imports wrong values, you need the header part of the csv which is:
wp_title|wp_post_date|wp_category|wp_content|field1|field2|field3

put that on the header and you should be fine.

thanks for the script, it works very well and it is very useful.

Adem
Andrew

December 19th, 2008 at 8:54 am
56

Thanks for your wok on this script. It works beautifully. One problem I’m having is with line breaks within the wp_content field. Shouldn’t I be able to have line breaks within the pipe delimited field? Let me know if I’m missing something obvious. I am importing data from a pMachine site. Do I need to replace all CRs and LBs with HTML tags? Thanks.
glenn

December 21st, 2008 at 5:03 pm
57

Im trying to find a way to get my posts from, b2E over to WP. This is a error I came up with when trying to use the CVS file per your instructions.

Fatal error: Cannot redeclare kaltura_find_post_widgets() (previously declared in /hsphere/local/home2/extsieg/siegrist.nu/wp-content/plugins/all-in-one-video-pack/all_in_one_video_pack.php:73) in /hsphere/local/home2/extsieg/siegrist.nu/wp-content/plugins/all-in-one-video-pack/all_in_one_video_pack.php on line 73
Carl Eric Johnson

January 2nd, 2009 at 3:49 pm
58

I’m so glad I found your CSV import tool. I’m just now putting my text file together. I’m moving an old Squarespace blog to my own WordPress blog. One of the entries, however, has a user comment. How do I upload comments written by other people using your utility?
Tim

January 5th, 2009 at 8:19 pm
59

Hi Zack,

Thanks for the plugin; I installed it with no problem.

My question is how do I add the extra fields to my posts? I assume the new code goes into single.php?

I am not fluent with PHP – I read it but I can’t write it – so if you could point me to examples I can copy and paste that would be great.

Thanks for your help – Tim
Heikki

January 10th, 2009 at 7:03 am
60

I have a strange problem. I have made a csv file just like the example and I even tried the example file but no help…

The script converts all posts into a categories and ignores the content. There’s the title as a category of the post, as a title and as the content.

And if not weird enough, in the title’s there are strange characters after every letter of the title.

What am I doing wrong here?
Tim

January 23rd, 2009 at 4:44 pm
61

Great plugin! The only problem I’ve had is importing large files. I know the max is 10mb but even 3mb files are timing out for me. Small files work fine.
Lingvemulo

January 27th, 2009 at 1:46 am
62

Hi – I’d like to reiterate the request for code to import tags… Have tried “wp_tags” and it doesn’t work. Is there something we can do? If I can’t import tags with my 200-some posts I’ll have to add them by hand, which kind of makes an automatic import moot.

Thanks!
Jonathan

January 28th, 2009 at 8:53 pm
63

I’m having the same problem as Andrew. In the wp_content field, each line break is treated as a new post. I set up 20 posts for import, but it recognized 296. I’m using WP 2.7

Jonathan
Samrs

February 3rd, 2009 at 3:51 pm
64

I just installed this plugin and it imports the data very well. Thank you very much. The one question I have is how to get the categories to work. The imported data is creating a new category and naming it what ever the wp_title name is. It appears some others have experienced this as well. Do you know a solutions?

Many thanks
Import CSV and Datafeed in Wordpress | Cool wordpress plugins to import CSV in wordpress | Authority Guide

February 4th, 2009 at 2:43 am
65

[...] I found a fantastic plugin which allows you to import posts directly from a CSV file. The CSV2Post plugin provided by Zach is an excellent way to automate your postings. The cool little plugin [...]
drage

February 6th, 2009 at 12:02 am
66

I liked this… thanks Zack!
And how about wp_tags ?
Is it a great problem?
Jukka

February 13th, 2009 at 8:44 am
67

Does it support multiple categories ?
jean

February 15th, 2009 at 4:37 pm
68

Hello,

I have two questions

1. how can I show Umlauts correctly
2. html and import tables correctly

Thanks
Jukka

February 17th, 2009 at 2:05 am
69

Jean,

About umlauts: I did try importing posts with special letters in their topics, and they work if you make sure that .cvs file is in UTF-8-format. My Excel exported .cvs in ANSI-format, so I used Notepad++ to convert it to UTF-8 and voilá!
jean

February 18th, 2009 at 6:33 am
70

in post, is German umlauts ä, ö, ü, are not displayed correctly
Higgins

February 20th, 2009 at 1:05 pm
71

really like yr importer – use it a lot. Haven’t tested uploading & importing pages (w tweaking t post_type variable) but I’ll give it a try & post my experience.
Studio Primus

February 23rd, 2009 at 9:20 am
72

Hello,

has this plugin urf-8 import support?

Thank you!
Kamal Panhwar

March 19th, 2009 at 7:29 am
73

What happen if I have many categories with same name and with different parents.
like United States(parents)>California>Images
similarly
United States(parents)>Alaska>Images
So images is same if I made my data
My Post Title|2007-12-31 23:59:59|images|Long post text|value|value|valaue
Whic will put it in any images, so how can I make it that it should put that categories in proper parent cateogory.
I tried.
My Post Title|2007-12-31 23:59:59|alaska > images|Long post text|value|value|valaue
But it create new category of Alaska > Images, and go in that cateogry.

Anyone if could through some light.
regards

Kamal.
Goran

March 27th, 2009 at 3:30 pm
74

Hello, I also have problem s with non-English characters.
Characters č, ć, ž etc. are all converted to ? or square a.
This is not the case when importing from wordpress export file. Have anyone find a solution? jean?
Thank you
Ajay Jain

March 28th, 2009 at 7:24 pm
75

It seems to be good script.

But it should support comma delimited csv file becuase while saving the file as csv file in ms excel there is no option to save it live pipe delimited csv file.

Regards,
Ajay
aukseo

March 31st, 2009 at 1:08 pm
76

Looking at the code to change to import into pages you need to change this line

$post_type = “post”;

to

$post_type = “page”;

will be testing now
Goran Milo

April 1st, 2009 at 6:05 am
77

how do you add username or $user_id for each post in the cvs?

wp_title|wp_post_date|wp_category|wp_content|dc:creator|field2|field3
aint doing the trick for me.
Nauman

April 6th, 2009 at 6:06 am
78

I have the same question as Kamal has (73), how to handle parent / child categories in import?
wpnewbie

April 15th, 2009 at 9:00 am
79

Just wondering if there is any solution to the TAG issue… This is pretty awesome, but adding tags would make it even better!
volcomjon

April 17th, 2009 at 4:35 am
80

Hi zack – great plugin, and is working well – until it comes to long posts (with paragraphs) – I have read that other people are also experiencing the same problem with the script breaking the posts up at each paragraph line break, therefore generally screwing up the entire import.

please please please can you help us out with this one as I have tried a couple of different methods using preg_replace and it is still doing the same thing.

unfortunately I cant go through every single post taking these line breaks out, and so there must be a solution.

your help would be very much appreciated.
Cheers
volcomjon

April 17th, 2009 at 8:15 am
81

ok – I have found where the problem lies with splitting the import into separate arrays where line breaks appear – it is because of the use of the file() function – which splits arrays with every new line break. – now – I have found an optional flag which attempts to ignore these line endings, but it doesnt seem to work.

I believe it also has something to do with the encoding of the csv file you are uploaded – e.g. – unix, windows or mac format, as the line endings are different in each version.

here is what I have found in the php manual – if anyone can shed some light on this – it would be awesome

http://uk2.php.net/function.file
Mike

April 24th, 2009 at 9:39 am
82

Like everyone else, I need some of the same things.

1) Ability to add tags
2) Fix the line break issue
3) Ability to change slugs

Any updates coming?
Mike

April 24th, 2009 at 10:10 am
83

Addendum to my previous post:

I’ve figured out how to use this for pages instead of posts, and to define a parent page, as well as a page theme.

All that’s left is to figure out how to fix the linebreak bug. Any suggestions are welcome.

For those that want to use this for pages, with a page parent:

on line 292, change:
$post_type = “post”;
to
$post_type = “page”;

To define a page parent:
Below $post_type, add:
$post_parent = “”;
Input the ID of the page you want to be the parent of your imported page(s).

If you want to use a custom template, simply add a field to your CSV that is _wp_page_template, and define it with whichever .php page you want for your template, ie; page.php

Hope that helps those that are trying to do what I am. Now, if I can figure out that pesky linebreak bug, I’ll post again.
Mike

May 1st, 2009 at 8:03 am
84

I think I found a bug.

Any field that has any form of HTML link in it, gets imported in quotes.

While there’s no quotes around the fields in the CSV, something in the script is adding opening and closing quotes, presumably to escape the quotes in the links. Any ideas?
Goatseo

May 8th, 2009 at 6:56 am
85

is it planned a wordpress bundle for XLS importing?
jojo

May 8th, 2009 at 2:43 pm
86

Hi Zack
Thanks for this great script, that will save me dozens of hours

Yet, I still have one question : is it possible to define the permalink of each post ?
Sushi

May 9th, 2009 at 6:20 pm
87

How do you make a post go under a parent category?
Yip Bop

May 13th, 2009 at 8:46 am
88

Hi, How can I enter a code in the wp_content field such as:
[code]name,12,260,""[/code]

When I import, it pasts in the content [code]name,12,260 and not the rest of the code.

Also, I am getting a " before the title on the post

Thanks for your help.

Yip
Herry

May 18th, 2009 at 9:04 am
89

[Comment Import]

Hallo Zack,

i have the same question as Carl Eric Johnson (Nr. 58). Can you tell us about that?

Thanks for your script!
windracer

June 25th, 2009 at 10:10 am
90

Thanks for a great tool! I used this and your category importer to move 525 entries exported from a SQL database into WordPress.

For those of you having problems with line breaks, try replacing any CR/LF combinations (ascii 10 and 13) with the ” tag. The importer will obey that and you’ll get the proper breaks in your post content. This worked great for me.
Raj

July 29th, 2009 at 10:43 am
91

Hi,

I’m using Wordpress 2.8.2 (latest) version.

I’ve installed the “import” successfully and can see it under Tools>>Import

However, when I tried to upload the sample csv file, I’m got below error..

*************************************************
Import CSV

Sorry, there has been an error.

File is empty. Please upload something more substantial.
*************************************************

Any idea guys, Zack.. Please help
mugger

August 8th, 2009 at 6:36 pm
92

Lines truncate at high-ascii characters.
I renamed |field1|field2|field3 to |Price|More Info|Image where
Price = $nn.mm
More Info is hyper-text link
Image is absolute URL. (Try relative path later.)
None of these appear in PostEdit or blog.

Without those fields, import is worthless to me.
How might I rescue this?
malibu

November 13th, 2009 at 2:15 am
93

Hi,Zack.

I have a question.

The future post doesn’t work.

[wp_post_date]
2008-12-31 23:59:59→OK!
2009-11-13 23:59:59→reserved→ 11-14 still “reserved”.

This is only from csv2post.

please help me! please.

RSS feed for comments on this post · TrackBack URI

Zack Preble

Importing Posts from CSV file into Wordpress

93 Responses

Leave a reply

Pages

Archives

Blogroll

Meta

Recent Posts

Categories

Recent Comments

Tags