By decon on

http://drupal.org/node/19097

I was reading that post earlier searching for an answer to something that seems possible in Drupal, but I do not know the current way to do it.

I am looking for a way to be able to syndicate posts/RSS feeds and put them into a node. Apparently Node.Aggregator used to be able to do it, but is now broken. Does anyone know of a current solution?

thanks!

Comments

SimonP’s picture

SimonP commented

I think what you're after is the Naggregator module:
http://cvs.drupal.org/viewcvs/drupal/contributions/modules/naggregator/
http://cvs.drupal.org/viewcvs/drupal/contributions/modules/naggregator/R...

This is something that I wanted to get going but I haven't been able to put aside the time yet - let me know if you have any joy.

It's not included under 'Downloads' as it's only in CVS repository and not guaranteed to work with whatever version of Drupal your using.

====
Back in the UK after discovering drupal during temporary residence of Vancouver

decon’s picture

decon commented

That looks to be exactly what I was looking for! Thanks for posting it. I'll see if I can get it going.

And just to clarify, CVS modules work just like any other module, just that they aren't necessarily guaranteed to work since they are still "works in progress" and might have some quirky bugs?

boris mann’s picture

boris mann commented

There is an "aggregator2" module that looks really good. I put that in quotes, because it hasn't been checked in as a project yet.

There is discussion on it is here here, and this is the direct download link:
http://ahwayakchih.neoni.net/files/aggregator2-RC3.zip

SimonP’s picture

SimonP commented

Yes, but I'm slightly wary of using modules that aren't included in the 'downloads' section, or at least CVS - I have more (perhaps misplaced) confidence that they will be kept up-to-date.

For example, for 4.5 there's also a News_page module that looks very useful. It creates a page from certain news feeds items - you can specify the keywords that must occur if it is to be included (you could of course sepcify 'a' or 'the' to get them all included).

It's not clear to me if it's been upgraded to work with 4.6 yet though.

====
Back in the UK after discovering drupal during temporary residence of Vancouver

legacyb4’s picture

legacyb4 commented

I'm having some issues with the latest version of News_Page as I am getting the error:

You have an error in your SQL syntax near ') ORDER BY timestamp DESC LIMIT 0, 25' at line 8 query: SELECT i.*, f.link AS flink, f.title AS ftitle FROM aggregator_item i LEFT JOIN aggregator_feed f ON i.fid = f.fid LEFT JOIN aggregator_category_feed c ON c.fid = f.fid WHERE c.cid = '' AND () ORDER BY timestamp DESC LIMIT 0, 25 in /home/httpd/vhosts/DOMAIN.COM/httpdocs/includes/database.mysql.inc on line 66.

with the only reference I can determine being on lines 253-264 on the news_page.module:


$result = db_query_range("
SELECT i.*, f.link AS flink, f.title AS ftitle
FROM {aggregator_item} i
LEFT JOIN {aggregator_feed} f
ON i.fid = f.fid
LEFT JOIN {aggregator_category_feed} c
ON c.fid = f.fid
WHERE c.cid = '" . $node->cid . "' AND (". $filter_query . ")
ORDER BY timestamp DESC", 0, $node->max_items);

return $result;
}

reikiman’s picture

reikiman commented

The SQL you quoted has a problem at the "AND ()" ... the () should have something inside it.

Looking at the code I see if $filter_query is empty then the symptom will occur. Also I notice just before the AND() you have "c.cid = ''" which is controlled by the code just before that, and indicates that $node->cid is also empty.

- David Herron - http://7gen.com/

+ David Herron - 7gen.com/, The Long Tail Pipe, davidherron.com/drupal-blogging-hints