On my Drupal 6 site I have several Select list: Allowed values list: Integer with 3 diff. values like this

|
1|Ja
0|Nej
2|Ved ikke

AND

|
handicap|Handicap
pissoir|Pissoir
unisex|Unisex

AND
Textfield number of m2 is not imported too.

It looks as Feeds importer look for key and not value because if I manually change csv-file to use key it's functioning. Is this how it's supposed to functioning and how do I solve this, please?

Comments

twistor’s picture

twistor CreditAttribution: twistor commented
Project: Feeds » Feeds Tamper
Version: 6.x-1.0-beta13 » 6.x-1.x-dev
Component: Feeds Import (feature) » Code
Category: Bug report » Support request
Priority: Critical » Normal
Status: Active » Fixed

Correct, that is how it is supposed to work. It maps to the key, not the value.

Look at Feeds Tamper. It offers various plugins that can accomplish what you're looking for.

tinem’s picture

tinem CreditAttribution: tinem commented

Thanks but would be great if you could help and link me to the solution how to do this, please?

I have used weeks to solve this and have posted several messages in both Forum/Feeds/Feeds Tamper issue but didn't get the solution. It's for version 6. I can post my messages here if you want me to?

tinem’s picture

tinem CreditAttribution: tinem commented
Status: Fixed » Needs review
twistor’s picture

twistor CreditAttribution: twistor commented
Status: Needs review » Active

It's kind of hacky, but you can use the Find Replace plugin to convert these to the required values.

There isn't currently a plugin that looks up the field mapping from CCK. This should be fixed in Feeds, but that can only come in 7.x. 6.x can't do it.

In your second example, you can use the Convert case plugin to lowercase the words.

Can you just set the keys and values to the same thing?