Categories
View Replies (14)

Resolved Products exported multiple times

  1. p.barg
    p.barg
  2. RO CSVI
  3. Thursday, 10 December 2015
  4.  Subscribe via email
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
0
Responses (14)
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
p.barg
p.barg
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Attachment missed in the previous message, Please find it here.

patch_textenclosure_20151210.zip
Attachments (1)
patch_textenclosure_20151210.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
p.barg
p.barg
Accepted Answer Pending Moderation
Hello Tharuna,
thanks for the patch and looking into the other issue. I attach the log file.

Best regards

Petra
Attachments (1)
com_csvi.log.31.zip
  1. more than a month ago
  2. RO CSVI
  3. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 6
p.barg
p.barg
Accepted Answer Pending Moderation
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
Attachments (2)
stock.csv
com_csvi.log.33.zip
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
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.
Attachments (1)
patch_productchildren_20151211.zip
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
p.barg
p.barg
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 9
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 10
p.barg
p.barg
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 11
p.barg
p.barg
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 12
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 13
p.barg
p.barg
Accepted Answer Pending Moderation
Hi Roland,
perfect - thanks!

Petra
  1. more than a month ago
  2. RO CSVI
  3. # 14
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!