Resolved Is this possible?

Hello Bart,

Import in Virtuemart.
I like to use a field twice. One time in a combine and the other just as plain data.

That should be Ok.

I only can export the fields once form my CRM software and I don't want to manually edit the CSV.
I've tried a combination with the field copy and combine plugin but I can't work it out.

Please have a look at Field combine plugin and Field copy plugin documentation.

So here is the example. I hope it's possible.

CSV file
3 fields: field A, field B, field C

Import output
product_name = Field A | Field B
catergory_path = Field B
product_s_desc = Field C

CSVI will not be able to process this data as product_sku field is missing in your example. CSVI identifies if the record has to be inserted or updated using this field. If that is missing you should be seeing Missing required field error. You would need product_sku field in your import file. Have a look at Import Virtuemart products documentation which explain about required fields and import process.

Thanks for the quick reply.

1) I know the documentation by heart but I can figure out how to copy a value and then use is to combine
2) I know that a required field is de product_sku. The example is just a excerpt from an import file. I can provide you with the XML.

So here again the example with product_sku

CSV file
4 fields: field A, field B, field C, field D

Import output
product_name = Field A | Field B
combine = Field B
catergory_path = Field B
product_s_desc = Field C
product_sku = Field D

In CSVi I only can use field B once so I have to copy the field but than I can not combine it any more

What I did was
Use a rule copy plugin to copy value category_path to combine field
Use a rule combine plugin in product_name where product_name and combine field are combined.

Hello Bart,

In CSVi I only can use field B once so I have to copy the field but than I can not combine it any more

What I did was
Use a rule copy plugin to copy value category_path to combine field
Use a rule combine plugin in product_name where product_name and combine field are combined.

As much as i understood from your example, product_name field should have category_path field value combined with a character |. To do this you can create a combine rule with source fields as product_name,category_path and target field as product_name, combine character set to |. Apply the rule on product_name in template fields and i think this should work. Try it and let me know how it goes.

I seem to be very difficult for me to explain. I will give it another try. With an other example.

I have a CSV with the following fields

"Product Number", "Product Name", "Artist", "Genre"
"PRO1003", "Thriller", "Michael Jackson", "Pop"

I would like to import this in the following fields in virtuemart (I show the values also)
product_sku = PRO1003
product_name = Thriller - Micheal Jackson
artiest = Michael Jackson (is a custom field in Virtuemart)
category_path = Pop

This is what i did:


[table]
[tr]
[td]Field Name[/td]
[td]Your field[/td]
[td]Rule[/td]
[/tr]
[tr]
[td]product_sku[/td]
[td]Product Number[/td]
[td]
[/td]
[/tr]
[tr]
[td]product_name[/td]
[td]Product Name[/td]
[td]Field combine -> source fields product_name,artiest | target field product_name | combine character -[/td]
[/tr]
[tr]
[td]combine[/td]
[td]artiest[/td]
[td][/td]
[/tr]
[tr]
[td]artiest[/td]
[td]Artist[/td]
[td]Field copy -> source field artiest | target field Combine[/td]
[/tr]
[tr]
[td]category_path[/td]
[td]Genre[/td]
[td][/td]
[/tr]
[/table]

Result
product_sku = PRO1003
product_name = Thriller - Micheal Jackson
artiest = Pop
category_path = Empty

Can you help.

Hello Bart,

Not sure why you are using the Combine field because it is not needed. Here is how it should look like:
[table]
[tr]
[td]Field Name[/td]
[td]Your field[/td]
[td]Rule[/td]
[/tr]
[tr]
[td]product_sku[/td]
[td]Product Number[/td]
[td]
[/td]
[/tr]
[tr]
[td]product_name[/td]
[td]Product Name[/td]
[td]Field combine -> source fields product_name,artiest | target field product_name | combine character -[/td]
[/tr]
[tr]
[td]artiest[/td]
[td]Artist[/td]
[td][/td]
[/tr]
[tr]
[td]category_path[/td]
[td]Genre[/td]
[td][/td]
[/tr]
[/table]

With this setup, the number of fields in your template matches the number of fields in your CSV file. Let me know how it goes.