Autoblog Mutliple RSS Feed Import

I need to add about 50 RSS Feeds to the list of feeds. Is there a way to do am import or automate this?

I tried grabbing the SQL and creating my own SQL statements. The feed appears to insert fine into the database, but then in display it shows unknown. Clicking that shows no name or RSS url.

  • oodastrategy

    This is what I ran:

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;

    INSERT INTO wp_autoblog (feed_id, site_id, blog_id, feed_meta, active, nextcheck, lastupdated) VALUES
    (55, 1, 1, 'a:35:{s:5:"title";s:21:"IL House GOP Youtube";s:3:"url";s:39:"ttps://gdata.youtube.com/feeds/base/users/ilhousegop1/uploads";s:4:"blog";s:1:"1";s:8:"posttype";s:4:"post";s:10:"poststatus";s:7:"publish";s:8:"postdate";s:8:"existing";s:6:"author";s:1:"0";s:9:"altauthor";s:1:"1";s:11:"feedcatsare";s:8:"post_tag";s:18:"originalcategories";s:1:"1";s:8:"category";s:2:"11";s:3:"tag";s:0:"";s:8:"allwords";s:0:"";s:8:"anywords";s:0:"";s:6:"phrase";s:0:"";s:9:"nonewords";s:0:"";s:5:"regex";s:0:"";s:7:"anytags";s:0:"";s:10:"useexcerpt";s:1:"1";s:13:"excerptnumber";s:1:"3";s:15:"excerptnumberof";s:10:"paragraphs";s:6:"source";s:0:"";s:13:"poststoimport";s:1:"0";s:11:"processfeed";s:2:"60";s:12:"startfromday";s:0:"";s:14:"startfrommonth";s:0:"";s:13:"startfromyear";s:0:"";s:8:"endonday";s:0:"";s:10:"endonmonth";s:0:"";s:9:"endonyear";s:0:"";s:8:"forcessl";s:2:"no";s:12:"overridedups";s:2:"no";s:10:"footertext";s:89:"Continue reading at %ORIGINALPOSTURL%";s:13:"featuredimage";s:3:"ASC";s:15:"featureddefault";s:1:"0";}', 0, 1423530054, 1423526454),
    (56, 1, 1, 'a:35:{s:5:"title";s:26:"Edward J. Acevedo";s:3:"url";s:39:"https://www.facebook.com/feeds/page.php?id=100000453808323&format=rss20";s:4:"blog";s:1:"1";s:8:"posttype";s:4:"post";s:10:"poststatus";s:7:"publish";s:8:"postdate";s:8:"existing";s:6:"author";s:1:"0";s:9:"altauthor";s:1:"1";s:11:"feedcatsare";s:8:"post_tag";s:18:"originalcategories";s:1:"1";s:8:"category";s:2:"11";s:3:"tag";s:0:"";s:8:"allwords";s:0:"";s:8:"anywords";s:0:"";s:6:"phrase";s:0:"";s:9:"nonewords";s:0:"";s:5:"regex";s:0:"";s:7:"anytags";s:0:"";s:10:"useexcerpt";s:1:"1";s:13:"excerptnumber";s:1:"3";s:15:"excerptnumberof";s:10:"paragraphs";s:6:"source";s:0:"";s:13:"poststoimport";s:1:"0";s:11:"processfeed";s:2:"60";s:12:"startfromday";s:0:"";s:14:"startfrommonth";s:0:"";s:13:"startfromyear";s:0:"";s:8:"endonday";s:0:"";s:10:"endonmonth";s:0:"";s:9:"endonyear";s:0:"";s:8:"forcessl";s:2:"no";s:12:"overridedups";s:2:"no";s:10:"footertext";s:89:"Continue reading at %ORIGINALPOSTURL%";s:13:"featuredimage";s:3:"ASC";s:15:"featureddefault";s:1:"0";}', 0, 1423530050, 1423526450)
    ;

    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

  • Hoang Ngo

    Hi there,

    I hope you are well today.

    Actually I think we need to process by PHP, as after we import the feed, we will need to tell WordPress when it should run.
    Here's an example of importing a feed manually, you can check and implement for multiple feeds. If you have any coding issue, please let us know :slight_smile:

    $data = array(
            'site_id' => '1',
            'blog_id' => get_current_blog_id(),
            'feed_meta' => array(
                'title' => 'title',
                'url' => 'your_url',
                'blog' => get_current_blog_id(),
                'posttype' => 'post',
                'poststatus' => 'publish',
                'postdate' => 'current',
                'author' => '0',
                'altauthor' => '1',
                'feedcatsare' => '',
                'category' => '-1',
                'source' => '',
                'tag' => '',
                'allwords' => '',
                'anywords' => '',
                'phrase' => '',
                'nonewords' => '',
                'regex' => '',
                'anytags' => '',
                'useexcerpt' => '1',
                'excerptnumber' => '',
                'excerptnumberof' => 'words',
                'poststoimport' => '0',
                'processfeed' => '1449',
                'startfromday' => '',
                'startfrommonth' => '',
                'startfromyear' => '',
                'endonday' => '',
                'endonmonth' => '',
                'endonyear' => '',
                'forcessl' => 'yes',
                'overridedups' => 'no',
                'featuredimage' => 'ASC',
                'featureddefault' => '0',),
            'active' => '0',
            'nextcheck' => time(),
            'lastupdated' => strtotime('-1 hour'),
        );
        $data['feed_meta'] = serialize($data['feed_meta']);
        global $wpdb;
        $feed_table = $wpdb->prefix . 'autoblog';
        $id = $wpdb->insert($feed_table, $data);
        //shchedule
        if ( $data['nextcheck'] > 0 ) {
            wp_schedule_single_event( $data['nextcheck'], Autoblog_Plugin::SCHEDULE_PROCESS, array( $id ) );
        }

    Best regards,
    Hoang

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.