Hello,
I've downloaded and installed the new version (6.4.2) and am encountering several problems.
I've set up a simple VM product export that only contains the fields product_sku and product_in_stock. The export is done, but the file contains some of the products multiple times. I think it has to do with parent products, but am not sure about it.
Moreover, if I set the export to "child products only" the export is empty (saying that that are no data).
Would you have some advise here?
Best regards
Petra
Joomla 3.4.5
Virtuemart 3.0.12
CSVI Pro 6.4.2
Hello Petra,
You can group by fields while doing the export, use Group by and Sort by Fields tutor for reference.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Tharuna,
thanks for the reply - that did the trick!
Now I have another problem in that those 2 fields (which are numbers) are always enclosed by "", which leads to imcompatibilities with another DB that imports that file (not with CSVI). Is there a way to get rid of the string delimiter?
And is there ans answer to the other problem I mentioned (export child products only)?
Thank you for your help and best regards
Petra
Hello,
Now I have another problem in that those 2 fields (which are numbers) are always enclosed by "", which leads to imcompatibilities with another DB that imports that file (not with CSVI). Is there a way to get rid of the string delimiter?
Try applying the attached patch file using how to load patch file tutor and run the export.
And is there ans answer to the other problem I mentioned (export child products only)?
Can you send the debug log of the export to check into the issue?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
Attachment missed in the previous message, Please find it here.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Tharuna,
thanks for the patch and looking into the other issue. I attach the log file.
Best regards
Petra
Hello Petra,
Looking into the log shows that you don't have any parent-child relation set for products. Can you add one more field product_parent_id along with the export fields you are doing and send the debug log and the exported CSV file?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
the result is the same. I attach the 2 files.
We do have a lot of parent-child relations on that site and if I don't use the option 'export only child products' they are all exported. And I see the product_parent_ids in the newly added column.
Thanks for looking
Petra
Hello Petra,
Thank you for the log, I was able to reproduce the odd output and fix it as well.
Please load the attached patch file and let me know if the child products export as expected now.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Roland,
thanks for the patch - I can confirm that it works perfectly now!
I discovered though, that the other patch you've sent me (textenclosure) doesn't seem to work. Each time I open an export template the default value for textenclosure is " again.
Best regards
Petra
Hello Petra,
Can you load the patch file posted by Tharuna once more to see if that solves it because it is a good fix.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Roland,
you're right - I've uploaded the patch again and now it works. I wonder what went wrong the first time, because I've had a look via FTP and the patch file was there before... Strange but anyway - thanks for your help!
Petra
Hi Roland,
I have to correct myself and I know what's going wrong now: the patch only works if you select "CSVI", but not if you select
"Virtuemart" as export... Is there a different XML file for Virtuemart exports? If so, I can alter it manually.
Best regards
Petra
Hello Petra,
You are correct, the VirtueMart has an override for this field. You can change the file administrator\components\com_csvi\addon\com_virtuemart\tmpl\export\file.xml and find there text_enclosure and just below it there will be a line
default='"'/>
and change this to
default=''/>
and all should be good.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland,
perfect - thanks!
Petra
Log in to reply to this topic.