Feed importer is one of the most important module supported by drupal community,which helps in importing various data format such as CSV,XML,Plain text and many more to your specific content.
Feed importer is convenient method when it comes to import the data to your custom content type but importing data to the field collection would require little amount of trick
So today we will try to give you simple and direct steps to import the field collection data and relate it to your particular content type
Let’s just make an assumption for convenience:
Content Type: Market Details
Field Collection: Price_Per_item
Step 1: Create the content type Market Details and add field Such as Title and S.No
Step 2: Add Field Collection Price_Per_item
Step 3: Create Fields Such as list and price In field collection Price_Per_item
step 4: Goto feed importer and create 2 new importer one for the content type and another for field collection
Note: you can’t import data to content type and field collection in same importer so it is required to create 2 different importer and then combining the data of 2 importer to get desired result
step 5: open the feed importer for the content type Market Details and add following settings to it.
step 5.1: click over Fetcher And choose file upload or HTTP fetcher where ever your file is located
step 5.2: Select the type of File/Parser in Parser Setting
Step 5.3: click on processor and choose Node(if not selected by default)
step 5.4: Move to the Node processor and select the content type in which the data has to be uploaded
step 5.5: now click the mapping and choose the source field(from your local file) and map it to the target field of your content type Market Details
Note: importing data to content type requires to specific trick its done in same way the magic methods lies behind the settings of how you import the field collection.Don’t get worried just follow the following easy steps
step 6: choose the importer of Field Collection Price_Per_item
step 6.1:click over Fetcher And choose file upload or HTTP fetcher where ever your file is located
step 6.2: Select the type of File/Parser in Parser Setting
Step 6.3: click on processor and choose Field Collection option, if it is not available then add module Field Collectin feed
step 6.4: Goto to the processor setting choose the field collection in which data has to be imported and move to the bottom of page where it says Field/property name of Host entity GUID and Identifier field name
step 6.5: create an extra field in Content type Market details and Field Colection Price_Per_item that will allow to link the field collection with content type and provide the machine name of content type in Field/property name of Host entity GUID and that of Field Collection in Identifier field name
step 6.6: In the mapping section do the following changes-:
uid (csv column) : Host Entity GUID (this will go into the field you entered in “Host entity GUID” on the settings panel)
S.No (csv column) : Identifier Field (this will go into the field you entered in “Identifier field” on the settings panel)
list (csv column) : Page list(field_page_lsit)
price (csv column) : Page price (field_page_price)
import the data and probably you will get what you expect…