Resolved some questions

Hello,

We just started implementing CSVI but im running into some issues. for instance the different attributes to a product: I feel this is insterted per attribute, instead of per line?

Can you tell me what you mean by attributes? I mean which fields in your import file you are saying as attributes? Can you also post your import debug log? Check How to get debug information? document to get the debug log.

So i would first need to import all categories from my export, then the products, and then all the different options we are using (per the categories stated in the field mapper?

Yes, you would need to import categories first and then products. If you are talking about custom fields as options that can be done along with product import.

Also i use the same field to gather data from (like a description: I want this taken from multiple fields, but the source data needs to be copied and combined in other fields as well), which also needs to be combined after. Can you give me a pointer on how i would set this up? Attached is the exportfile we get, and the importfile i want to create (how we are uploading now).

You need to use CSVI Combine rule plugin to combine your fields.

@Tharuna:

Thanks, this info caused that i created the rules within the hour for Category creation and product creation, however i wasnt aware of appending categories, this already does what i want (creating categories on the fly).

I will continue now with all the combinations and let you know if i have any issues.

found it

Hello,
Glad to know that you found it.

Hi Tharuna,

When combining field, do i use fieldnames from the source CSV as a source, and the fieldname for the target as target? My actions are as follows:

- I create product_name in the template
- I want to map (from my CSV) the column 'Artikelcode' to this, but i also use this to fill product_sku, so i want to copy it from one of them
- Made a rule to copy product_sku to product_name, which doesnt work
- made a rule to copy Artikelcode to product_name, which doesnt work
- When attaching everything to the template and the field, i see the product_name being created, but nothing copied.

All in all it makes me guess that i use the wrong fields, but as your tutorial only speaks about existing fields im unsure what to fill out.

Ive attached a log i just ran. It was cancelled but i hope its still readable.

csvi_templates_lynne.ca_20180730.xml

Hello,

When combining field, do i use fieldnames from the source CSV as a source, and the fieldname for the target as target? My actions are as follows:

Source names should be the fields you would like to combine and target field is where the combine result to be used. Both source and target fields should be added as template fields and in your template settings on File tab Use File for configuration should be set to No so that CSVI uses template fields for the rules. You need to map your fields from your import field to these template fields either using Field mapper or by setting the field name in Your Field in template fields.

- I create product_name in the template
- I want to map (from my CSV) the column 'Artikelcode' to this, but i also use this to fill product_sku, so i want to copy it from one of them
- Made a rule to copy product_sku to product_name, which doesnt work
- made a rule to copy Artikelcode to product_name, which doesnt work
- When attaching everything to the template and the field, i see the product_name being created, but nothing copied.
Ive attached a log i just ran. It was cancelled but i hope its still readable.

There was no debug log attached in your post but a template XML file and the template XML was for Joomla content import and not for VirtueMart Product import. Can you post screenshots of how you have used these rules?

Hi Tharuna,

Thanks for the patience and answers, i seem to make some real good progress now. (Im not able to work on this often)

When i want to add breaklines or custom text in the field combiner, do i make a combine field in the same order as im combining field? Or is there an easier way.

Its meant for the following: In the combined field, there has to be a space between every field, for which i use combine character in a rule. However i want to add a static line between these, and 1 or 2 breaklines.

Thanks

Hello,

When i want to add breaklines or custom text in the field combiner, do i make a combine field in the same order as im combining field? Or is there an easier way.
Its meant for the following: In the combined field, there has to be a space between every field, for which i use combine character in a rule. However i want to add a static line between these, and 1 or 2 breaklines.

For the static text, you can add a combine field and set Default value for this field. Put this combine field in the order as it comes between the other combine fields and use it in your rule. Field order should be like

Combine ->Value1
Combine->Static text as Default value set in Template fields.
Combine->Value 2

Hope it is clear.

Hello,

When i want to add breaklines or custom text in the field combiner, do i make a combine field in the same order as im combining field? Or is there an easier way.
Its meant for the following: In the combined field, there has to be a space between every field, for which i use combine character in a rule. However i want to add a static line between these, and 1 or 2 breaklines.

For the static text, you can add a combine field and set Default value for this field. Put this combine field in the order as it comes between the other combine fields and use it in your rule. Field order should be like

Combine ->Value1
Combine->Static text as Default value set in Template fields.
Combine->Value 2

Hope it is clear.

Tharuna,

This worked great

Now we almost have it set up exactly how we need it, except for this single breakline (an enter) like here:

https://italricambi.nl/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=14971&virtuemart_category_id=331

You see that the 'Vervangingsnummer voor' is a new line, which i added to product_desc in plain text (<br />. Does this combine field support HTML? Or how do you suggest to insert the breakline? Should i make everything in paragraphs maybe? I do have to keep 'order' in my combine fields. Some of them are used in the template for instance.

Many thanks

Hello,

You see that the 'Vervangingsnummer voor' is a new line, which i added to product_desc in plain text (<br />. Does this combine field support HTML? Or how do you suggest to insert the breakline? Should i make everything in paragraphs maybe?

You may not be able to insert HTML directly using combine field but you can create a rule using CSVI Multi replace plugin to insert empty space with <br/>(like in screenshot) and apply the rule on combine field. That should put the HTML <br/> in combine field and it would be used in product_desc on import. Let me know if that works.

I do have to keep 'order' in my combine fields. Some of them are used in the template for instance.

Yes, you need to keep your combine fields in order so the content gets combined in the same order as it is placed.

I will try that tomorrow

Otherwise it might be an idea to edit a product in Virtuemart, then proceed to run an export and see how it looks there? I did notice that its quite impossible to add HTML in regular fields, even abusing some fields where you might expect some HTML

Sorry for not being able to test it faster

Hello,

Otherwise it might be an idea to edit a product in Virtuemart, then proceed to run an export and see how it looks there?

Yes that would be a good idea.

I did notice that its quite impossible to add HTML in regular fields, even abusing some fields where you might expect some HTML

Yes, as of now it is not possible to add HTML in fields.

Sorry for not being able to test it faster

No problem. Let me know how it goes.

I used a comma instead of a space. The comma is definately being replaced. I tried it on the product_desc field and on the combine field. Both work, but the actual <br/> is not shown.

Next up, seeing what happens in an export

Hmm, maybe i did something wrong because the comma is now being replaced with <br/> in the example. Import running now.

Edit: COOOOL :-) Its working! This means we can finally take it into production

Thanks!

Ok one more issue

We upload all images manually and i used to hardcode the links to the images.

Now, CSVI does not allow for the product_image_1 field, so i set the images tab as followed:



Now most images get updated, but a lot also are not, all images actually exist, and when i manually attach them it works fine. Any way this can be resolved? Could it be some performance thing?

Thanks

Hello,
Can you send us your import debug log? Debug log will tell us what went wrong with those images which did not get updated. You can check How to get debug information? document to get the debug log.

The debug log is 71MB and has 630000 lines. I will trim it a little and upload it. Or do you want it all?

Hello,
Which CSVI version are you using? Starting with CSVI 7.7.0 version we have given an option to limit debug log entires. By default the number of entries is 20 and it can be increased by going to CSVI Dashboard page >> Options >> Site and in Number of lines in log file field. If you are on older version, either update to latest version or try running a smaller import file to get small debug log.

These are the first few lines :-) Hope its enough.

105480203010 is one of the examples where an image is not displayed.

Thanks

edit: Still on 6.8.2 but i will upgrade once everything is working

Hello,

edit: Still on 6.8.2 but i will upgrade once everything is working

Debug log shows you are on CSVI 7.6.2 version and not 6.8.2. I would still suggest you to update to latest version.

You have set Update media link only to yes in your template settings on Images tab. This setting will look for an entry for image in VirtueMart media table and if entry exists, media will be linked it to product. This feature is only for linking the existing media links to a product. You need to set this option to No, save the template and run the import. Check if your images are imported after that. If you still have issues, post the latest debug log to check.