Resolved Virtuemart Export - Group by date

Hello Francesco,
CSVI is not a report generating tool . The way you want your orders for a day and the total amount of orders of that day is not possible with CSVI. You can try that by writing your own custom code and by creating a override for your export.

Thank you,
best regards
Francesco

Hi Tharuna,
wouldn't it help to proceed like this?
Using a rule for the to replace the output field modified_on
05-01-18 05:10:01
05-01-18 06:11:02
in
05-01-18 00:00:00
05-01-18 00:00:00
In this case is it possible to group rows by modified_on or still I will have 2 rows for the same date?
I ask you that because I don't know ho to replace the time with "".
On CSV IMPROVED site, about replacements, for some cases I've found "This will not work with PHP 7 and higher. CSVI 7.0 will have a new rule plugin that makes this possible."
I know CSV Improved is not for reports, but I use it to generate many perfect reports for my needs.
Thank you, best regards.
Francesco

Hello Francesco,
You can change the date format of a export field from CSVI template fields page. Click on the export field and in the Date Format field set to d-m-y so no time is exported and save the field. Check the export.

Thank you for your fast support!
The first action I made was to change the date format in the field options like this: d-m-y and group export by the same field (modified_on) but stll the export contains several rows for the same date
04-01-18 € 59,00
05-01-18 € 10,00
05-01-18 € 20,00
06-01-18 € 42,00
It's like in the beginning the export has been generated without condsidering the date format and after that the date format has been applied, but we already had several rows for every date.
Sorry Tharuna, in your screenshot you show the rule Combine, is it that I miss to make everything work?
If yes, how should I create the combine rule?
Thank you
Best regards
Francesco

Hello Francesco,

The first action I made was to change the date format in the field options like this: d-m-y and group export by the same field (modified_on) but stll the export contains several rows for the same date
04-01-18 € 59,00
05-01-18 € 10,00
05-01-18 € 20,00
06-01-18 € 42,00
It's like in the beginning the export has been generated without condsidering the date format and after that the date format has been applied, but we already had several rows for every date.

Even though you get the exported field value in the date format set in template fields group by will be still applied on the values of database and not on exported value. You need to do custom coding and set it as override for export to fix the group by field format.

Sorry Tharuna, in your screenshot you show the rule Combine, is it that I miss to make everything work?
If yes, how should I create the combine rule?

Sorry the screenshot was meant to show you the Date Format field in template fields page and nothing to do with combine rule.

Thank you Tharuna,
now I'm not talking about date format, but about replacing the time from this
05-01-18 05:10:01
05-01-18 06:11:02
to this
05-01-18 00:00:00
05-01-18 00:00:00

wuould it help to group the output or in any case I will have separated row for the same date?

Thank you
Best regards
Francesco

Hi,
I have found an easy solution using, after exporting, the Pivot Tables in Openoffic Calc. Two clicks and it is done.
Thank you, best regards
Francesco

Hello Francesco,
Glad to know that you figured out a easy solution