How to update colloections ?

What is the best way to create a feed for this field collections parser? I have tried Views Data Export module. That seems to turn images fields and field collections into HTML when you choose XML file type and CSV file type formats the field collections incorrectly. Any thoughts?

I get this error in feed logs SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1. Any idea what might be the problem ?

Hi,

I'm running the latest version of Drupal, feeds, field-collection, and field-collection-feeds. However I'm having difficulty getting feeds to import my field collections.
Here's what I'm trying to do. I have three different field collections I will eventually want to import but they all have similar structures so I hope we can just get this first one working.

I have a content type "Departments".
It has a field collection field "Faculty"
"Faculty" contains several fields like any field collection such as..

• Name
• Status
• Degree

Each "Faculty" field-collection is also "unlimited" and so each department will have several "Faculty" fields with different Delta's

I have followed the instructions above in an attempt to import the "Faculty" field to the "Department" nodes I currently have on my website.
Here are the settings I am using with Feeds Importer (I will start with Parser assuming the other settings are irrelevant. assume all settings at default unless otherwise indicated)

1. CSV Parser (comma delimeted with headers. basically left to default)
2. Processor: Field Collection Processor
3. Field Collection Settings:
   • Update existing field collection item : Update existing field collection item
   • Field name : field_dep_faculty (machine name for field collection field)
   • Host entity type : node
   • Is field : checked(TRUE)
   • Field/property name of Host entity GUID : title (using the title of the node? I have also tried assigning a simple integer to each "Department" node with no success)
   • Identifier field name : field_dep_faculty_name (name field within faculty field collection. I'm not sure what to use for these last two. They are unique values but not always integers)

   Here are my mappings:
   hostid Host Entity GUID
   name Name
   namem Identifier Field
   status Status
   degree Degree

Please help me understand what settings I need to change. I've tried all sorts of variations with no luck importing the values. Also I am concerned about how to get the multiple values in with their delta values.

Thanks for the help!
gswebmaster

I have a problem, not sure if this module can do it, so I'm asking.

I have a book store. field_genre (fiction, nonfiction, trailer etc...) If I make a text field, no problem, I can import using Feeds and my CSV file. But I can't filter by genre in Views, because it is a text field. If I use Integer:list, I can't feeds the data to the database from my CSV because it is not separating the genre for each field like you would with manually value...

I tried manually to add the values in the fields and then load the CSV, but that didn't work either.

It works for Year though (ie. for number)... Can anyone help or point to the right module (I tried Tamper, didn't seem to work).

Thanks,
Mario

I have set up a Feed Importer using Field Collection Feeds but when I run the import it only brings in the first occurrence of the field collection data. This feed is set up as an Xpath XML parser and the Nodes I am updating with this information already exist from a previous feed importer. Below is a simplified version of the XML file I am trying to import. Only the first group gets imported. Is there something I'm missing in my XPath XML Parser settings that will get it to step through and grab each grouping and populate my Field Collection? Thanks.

<DIF>
   <Entry_ID>GES_DISC_AIRH2RET_V005</Entry_ID>

   <Related_URL Type="GET DATA">
      <URL_Content_Type uuid="3c2a68a6-d8c2-4f14-8208-e57a4446ad71">
      <Subtype>ON-LINE ARCHIVE</Subtype>
      </URL_Content_Type>
      <URL>ftp://airsl2.gesdisc.eosdis.nasa.gov/ftp/data/s4pa/Aqua_AIRS_Level2/AIRH2RET.005/</URL>
      <Description>
         Access the AIRS/Aqua Level 2 Standard Products (With HSB) data by FTP.
      </Description>
   </Related_URL>

   <Related_URL Type="GET DATA">
      <URL_Content_Type uuid="9b05d2a3-9a5a-425c-b6ed-59e0e56814fa">
      <Subtype>MIRADOR</Subtype>
      </URL_Content_Type>
      <URL>http://mirador.gsfc.nasa.gov/cgi-bin/mirador/homepageAlt.pl?keyword=AIRH2RET</URL>
      <Description>
         Access the AIRS/Aqua Level 2 Standard Products (With HSB) data using Mirador.
      </Description>
   </Related_URL>

   <Related_URL Type="GET DATA">
      <URL_Content_Type uuid="62919237-f020-4f9d-abcb-3d46b9b021e6">
      <Subtype>OPENDAP DIRECTORY (DODS)</Subtype>
      </URL_Content_Type>
      <URL>http://airsl2.gesdisc.eosdis.nasa.gov/Aqua_AIRS_Level2/AIRH2RET.005/contents.html</URL>
      <Description>
         Access the AIRS/Aqua Level 2 Standard Products (With HSB) data through OPeNDAP.
      </Description>
   </Related_URL>

</DIF>

My XPath expressions for each of the fields are as follows:

//DIF (Context base query)
Related_URL[@Type='GET DATA']/URL_Content_Type/Subtype
Related_URL[@Type='GET DATA']/Description
Related_URL[@Type='GET DATA']/URL
Related_URL[@Type='GET DATA']/URL_Content_Type/@uuid

Here is the configuration recipe I used to import a field collection into Profile2...

Settings for Field collection processor
Do not update existing field collection item
Field name: (The machine-readable name of the field collection)
Host entity type: Profile
Is field: unchecked (FALSE)
Field/property name of Host entity GUID: pid
Identifier field name: pid

Mapping for Field collection processor
guid => GUID (Used as unique.)
pid => Host Entity GUID
(and my other fields of course)

A few notes:
pid: this is the Profile ID.
guid: this is an arbitrary but unique number, it must be higher than the highest item_id in the field_collection_item table. I used Excel to autofill this whole column with sequential numbers.

Worked great. Excellent module.

FWIW, I'm trying to follow this documentation and there are several discrepancies with the Field collection processor > Settings interface:

• Node is not an option for Host Entity Type.
• Above, it describes Identifier field name as "used for mapping target "Identifier Field" -- here you need to type in the machine name of the field in your field collection that is unique for the individual imported item)." But on the interface, it says "Machine name of the identifier field which is unique in host entity."

Is there some way to use feeds_item.guid as the Host Entity GUID?

I can't seem to work out how to do it, as it's neither a field or a node parameter.

As a work-around I'm using node.title as my Host Entity GUID, but all of my other Feeds Importers use feeds_item.guid for cross references.

I test with my application company and contact, In my case one compay have a lots of contact so company is content node and contact is collection field
it works only one line contact imported

Node type = company (title,field_address,field_fc_contact)
field_fc_contact have 2 fields
field_name,field_phone

my file csv
title;field_name;field_phone
com A;Smith;12345
com A;Eve;98756
com B;Susan;6582
com B;Kelly;45987

result 4 imported but i check it again in my com A i have only Smith 12345; and com B only line Susan 6582
how can i fix it?

I have several profile types which contain field collections. It took me a lot of time to get things working. This is the config that worked for me. For future reference and help for others, I hope.

Profile type: Contact
- Field: Phone (system name 'phone') as embedded Field collection:
-- Field: Type (List), system name 'type'
-- Field: Number (Text), system name 'number'

So basically I want to store a repeating group of phone number, each consisting of a type (e.g. 'Cell' or 'Home') and a unique number.

Import file:
- column 1: User Name
- column 2: Phone Type
- column 3: Phone Number

Feeds Importers, Processor tab (relevant fields)

Settings
- Bundle: Field collection phone
- Field name: phone
- Host entity type: Profile
- Is field unchecked (so a property of Profile is used)
- Field/property name of Host entity GUID: pid
- Identifier field name: pid

Created a view to display user names and profile id's (PID)
Entered the PID in the import file adjacent to the user names

Mapping
- Phone Number - Number
- Phone Type - Type
- PID - Host Entity GUID
- Phone Number - GUID - unique

So when importing, the following is carried out:
- from the import file, the host entity GUID is read
- the PID entry is used to find the profile of the user
- from the import file, the Number and Type are read
- this field is added to the entry created
- the GUID prevents creating double entries

Troubleshooting:
Open the Log tab and verify that the import is read properly (original item) and check that the proper Host Entity is used.

I know this is an old thread, but I'm hoping somebody is still around. I'm failing miserably to import a set of field collections (from HTML if it matters).

Target data structure:

Individual (unlimited number of these)
Individual ID (used to create a unique Path for the Individual record which is also used as the GUID)
Field Name, Email, Phone
Field collection Events (unlimited number of these)
Event 1 Label, Date, Detail, UniqueID (4 fields, including one unique acrsss the target site)
Event 2 Label, Data, Detail, Unique ID
etc...

Each Individual node is created in two Feed importers operating on the
1. to create the Individual nodes each with a unique path/GUID and some non-field collection fields (this works fine)
2. to create multiple Events for each Individual (this is the problem)

Settings for the Events Importer

Parser context: //table[contains(@class,'events')]
Parser UniqueID: tbody/tr/td[1]
Parser field1: tbody/tr/td[2] to Parser field4: tbody/tr/td[4]
Path: .././/*[@class='gs-pe-id']

The parser is working fine.

Processor: Field collection
Bundle: Field collection field_events
Insert new item, update existing item, delete non-existent item
Field name: field_events
Host entity type: Node
Import id, feed nid and Host entity Guid all left blank
(There is no identifier field name in this set of options)

Mappings:
((various mappings for field2 to 4))
path => Host Entity GUID
uniqueid => GUID (used as Unique)

What do I need to do to get this to work? At present, for each node only the first field collection is imported.