By hujia on

Hi:

Could someone give suggestions on modules for importing/inserting RSS datafeed into MySQL database please?

Thanks, Hujia

⋅ Categories: Drupal 6.x

Comments

nevets’s picture

nevets commented

The Aggregator module is part of core. There is also the contributed FeedAPI module.

hujia’s picture

hujia commented

I have been using Aggregator module for a while and what I find is that it actually combines different RSS nodes into one in database table called aggregator_item, which for my RSS includes Date, Location, description. That is really inconvenient for data manipulation. For example, I want to emerge data from different RSS sources and rearrange them in order of Date, or Title alphabetically. So I hope the import data could keep original data structure: like Date, Location and Description all in separarte variables/fields of the db table. Better still, they may be able to talk to Event Calendar... or CCK taxonomy?

I think FeedAPI and its sub-module FeedAPI Taxonomy Compare etc might do that job. But I played with these and could not get them work properly. Could you enlighten me on this? And, is there a good instruction for FeedAPI and its sub-modules, like FeedAPI Element Mapper, Taxonomy Comapre? Many thanks! huj

hujia’s picture

hujia commented

Any aggregator module for "pure" XML (not rss)? Huj

adbox’s picture

adbox commented

You can try a third party solution such as RSS-to-MYSQL