1. Comenaranjas
  2. RO CSVI
  3. Sunday, 04 January 2015
  4.  Subscribe via email
Hello

I made a simple order export template with this fields:

Orden Field name
1 address_1
3 city
4 country_2_code
5 customer_note
6 full_name
10 order_total
11 payment_name
12 phone_1
13 phone_2
14 shipment_name
15 shipping_full_name
16 zip

I attach image to show you results. We have record groupping set to YES cause we only need 1 line per order in this particular template but we dont know why we get the order repeated as many times as products have been ordered (even when products itself are not exported)

We have also set Order address type - Shipping.

What we are trying to do in this particular template is 1 line per order simply (is for our transport company). We tried in previous stable version and it did work, we only got one line there.

Regards
Accepted Answer Pending Moderation
Hello,

Nice catch, the grouping is indeed not applied, that is why you get multiple lines. I still haven't fully worked out how I want to implement the grouping. One way is to hardcode the grouping fields but this may not always be what you want/need. So I am looking into making this more flexible, so you can decided on which fields you want to group. At least this grouping is fixed for now.
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. # 1
Accepted Answer Pending Moderation
Hi Roland

For us depending on the template we will need multiple lines or just one line.

For us is in that case, others as you say maybe need it other way but we are happy just if we can set it per template as I believe the actual grouping setting is meant for.

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hi Roland

Talking about grouping again:

I upload here an image,

Basicly we made a simple order export:

order_item_name
product_quantity

Our idea is to show how much quantity we have of each product.

As you can see the different products appear the same times as they do in different orders.

I know grouping can become complex but just wanted to let you know about this.

Dont know what the ideal solution could be? Choose what field should group values? Or a setting which groups duplicated values?

Regards
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Manuel,

Dont know what the ideal solution could be?
Every case is specific and this one is no different however grouping is not your only problem here. If you would group only on the order_item_name, the value of the product_quantity would be 2 and not 3. From what I understand you want these values calculated as well, that will require other code than just grouping.
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. # 4
Accepted Answer Pending Moderation
Hello Manuel,

Dont know what the ideal solution could be?
Every case is specific and this one is no different however grouping is not your only problem here. If you would group only on the order_item_name, the value of the product_quantity would be 2 and not 3. From what I understand you want these values calculated as well, that will require other code than just grouping.


Hi Roland

We are still wondering if this could be achieved with a calculation rule somehow, since this post was created you added the sortfield and groupfields option nicely but as you said what we need I guess is a calculation that sums up quantities of same product.

Possible in the future with a rule or a template parameter you think?

sorting fields currently deletes entries if we choose order item name.

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello Manuel,

Possible in the future with a rule or a template parameter you think?
Not really possible because the calculation needs to be done across all rows and the export only runs 1 row at a time. If you want to get the total quantities per product name, you will need to keep track of the item name and it's quantities across the whole export.

CSVI is not a reporting tool and this is where I think we are touching on the boundaries of CSVI as to what should be possible and what is actually for a different tool.

sorting fields currently deletes entries if we choose order item name.
Grouping fields you mean I think, that is because the field is not unique enough. You would need to group on the most unique field or a combination of them.
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. # 6
Accepted Answer Pending Moderation
Oh my friend youll be surprised of the possibilities your component offers :laugh:

I guess youll be shocked to know we use CSVI for our accountancy, and does the job. Aswell as for our transport company and warehouse orders, but I guess these last 2 are more common.

Sadly there is not a single report component for VM, just one added in 2009 so...

But yeah I know reports is something different ;)
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
We sorted fields by order_item_name and that way we get them in order by product name.

Yes we are looking for totals as shows in the image those 4 results to be in one line with the total quantity.

I guess a new rule to remove duplicated values for product names could work but still we will need a calculation that sums up product_quantity per product so I guess you are right and is quite tricky.

CSVI may not be intended for reports but even as know it does the job for us, theres no alternative component for it anyway ;)


If you ever come with a solution or think this is viable as a custom job gives us a quote. Don't even know if you do custom jobs.

Regards
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Manuel,

The only solution would be is to build a custom export for this purpose because the way the queries need to be made is quite different from a regular export.
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. # 9
  • Page :
  • 1


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