I have an RSS feed of contact details. Each item includes a Region and Town field. I have nodes for the regions. If I try to import with the regions selected as the foreign key, all my towns are being created at the same level
Check the CMSImportRelation database table please. All relations are stored in this table and CMSImport determines the parent node based on this table. The primary key info is stored in the DataSourceKey column. Format is [DataAdapter][Primary key column][Primary key value]. I'm sure there is a mismatch there.
When I look at that table, it is as I could expect for my results. Region folders indicate the Locations one as parent and read eg "Rss FeedregionScotland". The supposed child ones show the Locations folder as eg "Rss FeedtitleStirling"
I've seen the feed it's not a valid rss format. Use the xml adapter for this first import region select region as primary key. Then create a child import and select region as foreign key. The rss Adapter uses link as key.
Recursive Import from RSS
I have an RSS feed of contact details. Each item includes a Region and Town field. I have nodes for the regions. If I try to import with the regions selected as the foreign key, all my towns are being created at the same level
Any suggestions?
HI Tony,
Is the primary key value of the parent also the Region field?
Thanks,
Richard
Yes, it is
Check the CMSImportRelation database table please. All relations are stored in this table and CMSImport determines the parent node based on this table. The primary key info is stored in the DataSourceKey column. Format is [DataAdapter][Primary key column][Primary key value]. I'm sure there is a mismatch there.
When I look at that table, it is as I could expect for my results. Region folders indicate the Locations one as parent and read eg "Rss FeedregionScotland". The supposed child ones show the Locations folder as eg "Rss FeedtitleStirling"
Weird,
Is the rss file public available?
Thanks,
Richard
Not really, but you've got mail
Hi Tony,
I've seen the feed it's not a valid rss format. Use the xml adapter for this first import region select region as primary key. Then create a child import and select region as foreign key. The rss Adapter uses link as key.
Hope this helps,
Richard
If I choose xml, I only get access to the channel declarations (title, description, link, lastBuildDate, pubDate) and not the items in the feed
select //item as xpath and you should get the data
Ahem....
is working on a reply...