Hello,

I'm making a price comparator where many merchants should be able to upload their products (as CCK custom content) to the drupal database.
Their products don't contain any GUID corresponding to the drupal database. I tried to play during some hours with "feeds" but I think I can't do that : say I am merchant 'A'. I create daily a CSV file with all my products. The file contain a unique ID which is the merchant 'A' product unique ID but which is not the GUID that "feeds" needs because the same product ID can appear in merchant 'B' also.

In other words is there a way to :
- let my authenticated users import a CSV file without GUID

Thanks for your help

Comments

alex_b’s picture

alex_b commented

You have two options:

1. Use a separate feed node per merchant. GUIDs will only be compared within the items pertaining to a feed node, so same GUIDs from other merchant won't matter.
2. Generate a GUID by using merchant ID + product ID. This can be done either in a preprocessing step (outside of Drupal) or with a custom parser (an extension of CSV Parser) that takes two fields and merges them.

Does this answer your questions?

enjoyaol’s picture

enjoyaol commented

Hi Alex,

Thanks for your answer. I'm going to go with the first option.
So, basically I tried to understand how "feed nodes" and "feed items" nodes type are working together but I can't figure a way to work with them. Which importer do I have to use ?

Here is what I did, maybe there is something wrong in my setup:

- activated the importer 'Node import', attached to Feed Item,
- activated the importer 'Feed : Import RSS or Atom feeds, create nodes from feed items.'
- Now I have two new content types :

-- Feed "Subscribe to RSS or Atom feeds. Creates nodes of the content type "Feed item" from feed content."
-- Feed item "This content type is being used for automatically aggregated content from feeds".

- I modified the content type : Feed item to add my CCK fields from a previously made Product content type (imported CCK fields from my 'Product' content into Feed item)
- modified the importer Node Import : attached to Feed Item. Processor attached to Feed Item also
- modified the importer Feed : attached to Feed, Processor attached to Feed Item

I'm not sure about what to do now. I tried something :
- I click on the menu : import, I have two choices , Feed or Feed Item. I create a Feed named 'Test Feed'. The creation page of this Feed offers me to put a file.. I do it, I put my CSV File containing the merchant products. I save, I have one warning :

user warning: Duplicate entry 'feed-20' for key 'PRIMARY' query: INSERT INTO feeds_source (id, feed_nid, config, source, batch) VALUES ('feed', 20, 'a:2:{s:16:\"FeedsFileFetcher\";a:2:{s:6:\"source\";s:36:\"sites/default/files/feeds/test_4.csv\";s:6:\"upload\";s:0:\"\";}s:14:\"FeedsCSVParser\";a:1:{s:9:\"delimiter\";s:1:\";\";}}', 'sites/default/files/feeds/test_4.csv', 'b:0;') in C:\xampp\htdocs\ecigcompare\includes\common.inc on line 3477.

And the message:
- Feed Test Feed has been created.
- There is no new content.
(while I have 2 products in my CSV file)

I think I am stuck somewhere.. Don't know why. Do I have to create a real node of type 'Feed', and what next ?

Thanks for the help you could provide, It's very appreciated.

edit : grammar

enjoyaol’s picture

enjoyaol commented

I'm going to ask in the forum, I realize this may not be the place to ask for help. Thanks for your answer btw !

alex_b’s picture

alex_b commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

grahamvalue’s picture

grahamvalue commented

Hi,

I am having a somewhat related issue.
I need to be able to update the same node with multiple feeds.
Like one field from feed A, another field from feed B etc...

But looks like the GUID created by one feed is not recognized by another feed.
Or rather, the GUID is not really a Global unique id.It's specific to a feed.

Is there any way to do this?
Right now, each feed creates new nodes even with the same field as GUID in both feeds.

update: http://drupal.org/project/feeds_node_multisource looks promising