Csv To Wordpress Post v2 Released
Posted on April 2nd, 2009 in Wordpress |
This is V2 of the CSV to Wordpress post script, with a massive 800+ downloads of V1 its getting very popular for affiliates creating quick and easy stores with data feeds. If your going to use the script, maybe link to me or mention the script on your blog.
Check a demo of this script in action working with wordpress ——> http:/// www . mrchampagne . co . uk
Updates to V2:
Category bug fixed
Link Bug Fixed
You can easily select the button image, currency, button alt and Image style.
Upload sprite
Better layout
Installation Instructions
- Unzip the file csvtowordpresspostv2.zip,
- Upload the folder “csvtowordpresspostv2″ to the wordpress directory “/wp-includes/csv2/” you can do this with your FTP tool (im using Cyberduck on mac os)
- Point your browser to to www.yourwebsiteurlsite.com/wp-includes/csv2/upload.php “for the numpties open this url in “FIREFOX” or your preffered browser.
- Check! the script is now in this location “/wp-includes/ for the script can work properly, and the css styles.
- Creating a csv file, your .csv files need the following fields Title, Description, Category, Image, Link, Price. So go and grab your self a datafeed from affiliate window or affiliate future an change the fields to the ones above. E.g. the field “Aw_deeplink” will need to be changed to “Link”
- Done! your now ready to start uploading your csv files.
- Goto upload.php and select “browse” and find the .csv file which you modified for the fields.
Make sure your .csv files have the required fields Title, Description, Link, Price, Image, Category
Frequently Asked Questions:
1. I’m getting errors with something along the lines of “time out max memory exceeded”
Answer: If you run your own server, change the php timeout and memory settings. Or ask your hosting technical support to change it. If both of these fail, select half the data in excel or neo office(macusers) and copy, then delete, save file, upload, paste deleted data into new file and upload.
2. The categorys arent working.
Answer: See these two lines in “upload.php” require(’../../wp-blog-header.php’); require(’../../wp-admin/includes/taxonomy.php’); add the proper locations!
3. It doesnt work.
Answer: Post in comments or wordpress support forum, make sure you attach to code or nobody can help you.
4. What can i use this script with
You can use it to upload Affiliate Date Feeds to wordpress and turn them into blog posts, I’ve used this script successfully with Affiliate Window & Affiliate Future. It works with every other feed as well.
Download CSV to Wordpress V2
Csv To Wordpress Post v2 (1057) - 4.55 KB
Updates for V3(not released yet)
Maybe scheduled posts
Turn it into an actual wordpress plugin
Tag support
and more.
33 Responses
love the 2.0 script, it worked great on my site
let me know when v3 is ready, i’ll be glad to pay for it
you could probaly do this wine javascript likne mouserover
Can we add in an extra field? Like keywords?
Any quick tutorial on how to do it?
hmm this would be fairly easy, see how the code crabs the title for example, replicate the code for keyword fields.
Regarding installation - when you say
‘Navigate to http://www.yoursite.com/wp-includes/csv2/upload.php‘
What do I navigate with ? How do I run the script.
Excuse my ignorance i’m new to Wordpress and scripting.
I’ve tried pasting the contents of upload.php into a PHP widget but it doesn’t work properly. I’ve also run upload.php in a browser - it partly works, but I get lots of script above the form.
[...] CSV to WordPress Post [...]
Any chance of some more comprehensive instructions please Matboo? My exepeirences of this useful tool have been somewhat hit and miss, however I am sure you could eliminate most of comments and queries by actually explaining in greater detail exactly how to use your CSV uploader.
Just tried this out but received the following error;
Warning: Wrong parameter count for fgetcsv() in /home/sites/[url removed]/public_html/wp-includes/csv2/upload.php on line 31
Processing testimport.csv.
Warning: Invalid argument supplied for foreach() in /home/sites/[url removed]/public_html/wp-includes/csv2/upload.php on line 42
Done!
Any ideas?
The instructions are simple! i’ve now updated them. but if you have 0 knowledge of affiliate feeds,ftp, php, or wordpress dont bother using this script go and read some guides
Mike read the instructions, it looks like you have not named the .csv fields properly.
Hi,
I feel a bit embarrest, because I am sure that the tool is working properly, however it says: Processing Test_upcsv_060409_kurz.csv. Done! After I have uploaded a test.csv file.
When I get back to my wordpress admin, there are no new posts at all.
I am running Wordpress 2.7.1.
I have named the 1st row of the csv like this: Title Description Category Image Link Price.
I guess, all good…
But, what’s wrong?
Andreas
i have no idea, do you have php5, does your upload.php have execute and write permissions. Maybe its a plugin effecting this?
Image fields are named exactly as you have named them?
Title,Description,Link,Price,Image,Category
Hmm sry mike i haven’t come across that error before! Maybe try a different server to be sure it’s not the script. I’ve only tested this on latest version of wordpress 2.71 is it? check out the url in the post for example of the script in action.
Would love this plugin/hack to offer tagging too, i see its on your todo list, any idea on a release date for this feature?
Every week when I get a new affiliate feed, do I just upload the new feed onto my server or will that disrupt everything?
how can we do subcategories?
[...] CSV to WordPress Post [...]
Hi, what does this mean? Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 35 bytes) in /home/popupten/public_html/wp-includes/plugin.php on line 302
? File too large? How do I have to just cut it down - was only below half a meg? Cheers.
Hi there. I haven’t used your script yet, but have been following it very closely for a few months now. It’s atractive, and I don’t mind doing some tweaking.
But I would like to do more. Can it do the following (with some not so advanced programming):
- Import tags
- Import custom fields
- Import excerpt
- Import time stamps
The latest would enable us to post posts in the past, present and schedule posts to the future.
With these covered, along with all the already existing features of your script, I don’t see any limitation to what your script could accomplish. I see that some of these features I proposed are scheduled for the next release. Does it mean that they are too advanced for someone that know their way around with code - someone who’s used just to edit, not to reinvent the wheel?
Cheers!
Nice idea, but i doesn´t work for me. the script sais: xxx.csv done but no postings appear. No error msg, nothing.
What did i wrong?
WP 2.7.X
Regards
Dieter
Thanks for the great plugin but in the instructions at the top you say upload to wp-includes do you wp-admin?
Hi,
Having one and rather major problem, the ” buy now ” button isnt linking to my affiliates, its just linking to an internal page on my site?
If someone could help solve that it would be so grateful.
Fantastic bit of software / script though, thanks so much, been looking for ages!
A I have seen what i did wrong!
Now to deleted the few thousand posts that did have the link!
Thankyou so much!
I Now get this error, have cut the csv size right down!!
It worked earlier!
PHP Warning: filesize() [function.filesize]: stat failed for C:\WINDOWS\Temp\php8B9.tmp in
C:\MY SITE\wp-includes\csv2\upload.php on line 30
PHP Warning: Division by zero in C:\MY SITEwp-includes\csv2\upload.php on line 37
I have used your script recently and think it is great. However, like dreamyguy I would like to be able to upload some of the post_meta fields. I’ve had a go at tweeking the code but I can’t get it to do it. Can you help or is this for a future release?
Hi , this plugin is like a dream only thing I am unable to execute on my webserver , I tried it on localhost it works fine but over here
http://easygifts123.net/wordpress/wp-includes/csv2/upload.php
it shows up nothing but just blank page …
Any suggestion what seems to be the problem ?
Hello, have you a sample .csv file? I have Import my file, no error’s but i cannot see any post’s…
many thanks
Regards Roger
this does not work. i am currently using the latest wp and i’ve done everything under the sun to get this to work and it REFUSES to behave! Every time I upload my small to large csv files (I’ve tried different sizes) I get no confirmation that it was successfully uploaded (not sure if that was intended). And when I go to check out the posts I discover there are non! What?! I’m so disappointed and I have never had issues using feeds and plugins, but this one has truly WRECKED my nerves. So it’s whatever. Dang!
Does this “plugin” support custom fields?
Use the latest version, the plugin version !!! I havent tested this with the latest wordpress version. !!!!!
Absolutely bloody brilliant!!!! THANK YOU and may all your wishes come true!!!! I am running it on one site perfectly and about to add it to my main site.