WordPress.org

Ready to get started?Download WordPress

Forums

WordPress SEO by Yoast
[resolved] Importing Meta Data from CSV File (8 posts)

  1. michelelougheed
    Member
    Posted 2 years ago #

    WordPress version: 3.3.2
    WordPress SEO version: 1.2.1

    I did this:

    I'm trying to import existing meta description and keywords fields into my new wordpress site. The data is in CSV format. I'm using csv importer (http://wordpress.org/extend/plugins/csv-importer/) and just need to know the values to properly label the meta description and meta keywords columns to feed the data in properly. csv_meta_description or any variation of that doesn't work. Grasping at straws here. Do you have a solution for me? Surely someone has tried to import existing meta data from a csv format before?

    I can pull the keywords in as tags (label - csv_post_tags), but our site uses tags for another purpose besides meta keywords, so I don't want to do that. I can also pull the data in to custom fields below - but that doesn't help me. I have thousands of posts that are moving to the new site and will need to pull all the meta data into the seo plugin properly.

    I expected the plugin to do this:

    Pull my meta description and keywords into the SEO plugin fields in my post.

    Instead it did this:

    Nothing. No data was pulled in to the seo plugin.

    Any help would be greatly appreciated. I've tried the support forums at CSV Importer, but no answers. Hopefully you have a solution since I'm trying to pull the meta details into your plugin. Our developer is going to offer me a custom fields solution to feed the meta data into the header if I can't get it to pull into the plugin properly, which I'd rather avoid.

    Thanks!!

    http://wordpress.org/extend/plugins/wordpress-seo/

  2. iversoncreative
    Member
    Posted 2 years ago #

    Hi Michele,

    We got it working. Instructions to come. For those who are also having this issue, the fields are as follows:

    _yoast_wpseo_focuskw
    _yoast_wpseo_title
    _yoast_wpseo_metadesc
    _yoast_wpseo_metakeywords
    _yoast_wpseo_meta-robots-noindex
    _yoast_wpseo_meta-robots-nofollow
    _yoast_wpseo_meta-robots-adv
    _yoast_wpseo_canonical
    _yoast_wpseo_redirect

    -Patrick

  3. Joost de Valk
    Member
    Plugin Author

    Posted 2 years ago #

    Cool, please do email me, joost - yoast - com with how you did it :)

  4. Justin Handley
    Member
    Posted 2 years ago #

    Hi There Joost,

    We initially tried with CSV Importer - a free wordpress plugin. Interestingly, it did import all of your data, but it skipped all other meta data. In the end, we used TurboCSV, which is a paid plugin for about $30 and that let us custom map all meta data including yours - you just name the columns in the spreadsheet as Patrick specified above and the plugin will automap the custom fields to your plugin.

  5. Justin Handley
    Member
    Posted 2 years ago #

    I will add one more note here for anyone attempting this - we ran into a speedbump importing a comma separated list of tags into Yoast's tag field - the solution was simple - just escape all comma's in the tag field with a \. A big shout out to Chris Richardson and TurboCSV - he went above and beyond in support to help me figure this out - thanks Chris!

  6. WebTechGlobal
    Member
    Posted 1 year ago #

    CSV 2 POST has support for WordPress SEO by Yoast. Specifically it fills out a form for you just by detecting SEO by Yoast is installed.

    Right now the meta values are created during post creation using imported data. I'm looking over WordPress.org and finding some need for import data to existing posts.

    Let me know if you are still stuck on this. You can contact me through http://www.csv2post.com also.

  7. SpinTrust WebDevloper
    Member
    Posted 1 year ago #

    No one, answered this post...which is shame. It’s actually quite easy, matter of fact too easy to buy a program to do it. So I would highly recommend against buying both CSV2POST or TurboCSV ... both just do what you can already do with free programs.

    Once you learn, you save yourself alot of money and become a better blogger because you know how to do this on your own. Which give you more control over your data and website. Basically you just download this first program http://wordpress.org/extend/plugins/csv-importer/

    Then you give each column your label, and when you come to the Yoast tables

    _yoast_wpseo_focuskw
    _yoast_wpseo_title
    _yoast_wpseo_metadesc
    _yoast_wpseo_metakeywords
    _yoast_wpseo_meta-robots-noindex
    _yoast_wpseo_meta-robots-nofollow
    _yoast_wpseo_meta-robots-adv
    _yoast_wpseo_canonical
    _yoast_wpseo_redirect

    You just use the custom map function, it actually sounds harder than it is. You can do it in two seconds and it works great in the latest version or wordpress. I really hate to see companies try to scam wordpress bloggers hiding something simple inside a script they want you to buy, just to get you to buy it; we just saved you $30 to $299 and remember, they even put limits on their software per domain or make you feel you need to update it with new version. Totally waste, there no reason in the world people can not just post this info and help the community out…it’s not hard. This is the whole point in using wordpress cause its open source and free let’s keep it that way..I understand offering software but not when it’s abused in a feature that’s so easy for users to do on their own.

    if you have problems go to Charleston WebDesign and email us and if you want a better step by step walkthrough, we added a Custom Mapping Tutorial on our website for reference
    http://www.spintrust.com/yoast-seo-import-tutorial-for-wordpress/

  8. Zara Walsh
    Member
    Posted 1 year ago #

    @SpinTrust WebDevloper how can we ignore this. I wish we could because its just wrong. A review is one thing but when you use the word scam in relation to a product provided by WebTechGlobal it is a whole other thing.

    CSV 2 POST is a 7 MB plugin and growing, not a "script" as you suggest. Your making out we have created something something to make money from it when in fact our plugin took many months to create. I bet you have not even installed the free edition. It's such a shocking implication.

    One thing really bugging me is Ryan never mentioned money above, just to contact us. Then you go and do the same in your post. Sure we have a prices page but so what, are you not providing ANY service on your site at all? Try telling me your a none profit organization or something! I seriously question your own motives. It is not like traffic means nothing.

    I must ask you to refrain from discussing our plugins, WordPress activity or business in this manner in future. Thank you.

    If you decided to contact us @michelelougheed we would never push the paid edition unless you require something rare/advanced that suits your WordPress installation or long term support. We would initially provide support based on the free edition in the hope that it fulfills your project needs. We always consider how we can improve the free edition to do just that and we are always happy to know what your project needs are.

    The specific part of the plugin that relates to this post is supported by much of the core plugin which is the most advanced free CSV importer on WordPress. We suggested its use because we believe in its ability to not just perform but to adapt and grow which is often a requirement for people working with data. Our plugin may be the right solution for you @michelelougheed or we will adapt it to be the right solution if struggling to find such a plugin. We try to do this in the free edition OR we add something to the free edition and add something more advanced in the paid. Depends on how much support requests we feel will be generated by a feature. For the record that is far more discussion about the paid edition then we normally permit on this forum but it seems to have gone that way in this thread.

    I hope you don't see anything wrong in making him aware of our plugin and being ready for his response without discussing money.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic