Problem linking to Blogspot via Syndication

  • Hello,
    We just have setup WordPress on our servers and love it. A couple of our bloggers have other blogs at Blogspot as well. When running syndication on these we are having a hard time getting a link to each article.

    The wp_posts.gui field in the WordPress DB is coming across in this format from blogspot: “tag:blogger.com,1999:blog-18769876.post-113810021433608879” instead of the Word Press format: “https://www.domain.com/path/wordpress/name/?p=107”. The RSS syndication link from Blogspot looks to be an atom.xml file. Does anyone have any idea how to get a good link to each story from Blogspot through syndication?

Viewing 5 replies - 1 through 5 (of 5 total)

  • Could this help ?

    Plugin Name: Feed List
    Plugin URI: https://rawlinson.us/blog/?p=212
    Description: Displays any ATOM or RSS feed in your blog.
    Author: Bill Rawlinson
    Author URI: https://blog.rawlinson.us
    Version: 2.02B

    Thread Starter emiller

    (@emiller)

    Thanks for the reply podz,
    I forgot to mention one thing, I am writing code to pull the last few posts from several different bloggers depending on which Word Press blog the user selects. I am doing this from outside WordPress.

    I have written the code to pull the Headline, Excerpt, Date & Link to the full article. Will the link you sent still apply to that since I am not actually in the WordPress Directory but querying the WordPress DB?

    Thanks

    Thread Starter emiller

    (@emiller)

    Also, WordPress is displaying the links correctly to Blogspot. I have looked through the WordPress code and am having a hard time finding the function that is generating the Link that wraps around the title of each post. Any Idea where that is at and what it is called?

    Thread Starter emiller

    (@emiller)

    To follow up more with what I have found today, It looks like the Blogspot RSS feed is storing info in the wp_options.option_value field. It is putting extra data here that isnt in the wp_posts table (Like the actual link to the Article).

    Is there an easier way to get the URL other than using the the ton of embedded functions?

    Thread Starter emiller

    (@emiller)

    I finally found the answer I was looking for so I thought I would post it in case someone else has the same problem.

    The correct URL is being stored in another table called ‘wp_postmeta’. There you will find a foreign key to the article ID with a meta_value=’syndication_permalink’ and the URL that you need is in the ‘meta_value’ field.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Problem linking to Blogspot via Syndication’ is closed to new replies.