Categories
View Replies (2)

Resolved Duplicates in export file

  1. docetmedia
    docetmedia
  2. RO CSVI
  3. Thursday, 10 November 2016
  4.  Subscribe via email
Hi,

I often get duplicate lines in my orders export file, example hereunder :

WEB000109;pompi;10021208;10021208;10/11/2016;381007394/1;1
WEB000109;;10021208;10021208;10/11/2016;381007394/1;1
WEB000109;pompi;10021208;10021208;10/11/2016;322110597/0;1
WEB000109;;10021208;10021208;10/11/2016;322110597/0;1
WEB000109;pompi;10021208;10021208;10/11/2016;181004455/0;1
WEB000109;;10021208;10021208;10/11/2016;181004455/0;1
WEB000109;pompi;10021208;10021208;10/11/2016;118801963/0;2
WEB000109;;10021208;10021208;10/11/2016;118801963/0;2
WEB000109;pompi;10021208;10021208;10/11/2016;123650004/0;5
WEB000109;;10021208;10021208;10/11/2016;123650004/0;5
WEB000109;pompi;10021208;10021208;10/11/2016;123867022/0;5
WEB000109;;10021208;10021208;10/11/2016;123867022/0;5
WEB000109;pompi;10021208;10021208;10/11/2016;118550609/0;1
WEB000109;;10021208;10021208;10/11/2016;118550609/0;1

each line is doubled, but without the second field.
(fields are : order_number,customer_note,customer_number,username,created_on,product_sku,product quantity)


I found this information in the troubleshooting section :

Duplicates in the export file
It can happen that the export file contains duplicates, this happens because of the selection that needs to be made to export all the requested fields. The solution to this is to group based on the duplicate fields. This can be done on the fields page of the template.


But I don't understand what needs to be grouped to solve the issue (it's not the fields that are duplicated but the lines)

I use CSVI Pro version 6.6.2 with Joomla 3.6.4/Virtuemart 3.0.18
the export log is attached

Thanks for your help,
Olivier
0
Responses (2)
docetmedia
docetmedia
Accepted Answer Pending Moderation
Thanks Tharuna !

I needed quite a long time to experiment but I found a grouping way that seems to solve my duplicates problem.
(by order_id+product_sku in case the information could help someone else)

Thanks,
Olivier
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Olivier,
Please have a look at Group by and Sort by fields document to know how to avoid duplicates.

But I don't understand what needs to be grouped to solve the issue (it's not the fields that are duplicated but the lines)

Its the fields which are queried and forms the lines so you need to group by fields to avoid duplicates. In your case try grouping by virtuemart_order_id and see if it solves your duplicates 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. # 2
  • Page :
  • 1


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