1. kilombo
  2. RO CSVI
  3. Thursday, 12 October 2017
  4.  Subscribe via email
Good evening,

We are currently using CSVI to export the orders modified in the current day (by this i mean every day not actualy todays calendar day), that are in the status "shipped", after this we apply one excel macro and import the modified CSV file to the shipping company application, so that all the shipping tickets are printed all at once.
The problem is that i'm not beeing able to find the "today" option in the data range, it has "since the last run", but that don't does the work, yesterday doesn't fit the needs also.
Is there any way of doing this?

Thanks in advance.
Accepted Answer Pending Moderation
Hello,
You can set today's date in Order date start filter which is under Date range drop down so you can filter your orders by today. Let me know if it helps.
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
Accepted Answer Pending Moderation
Hello,

Why is the option "Since last run" not working for you?
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. # 2
Accepted Answer Pending Moderation
Good evening.

tharuna it looks that the today option that you talk about returns today date for the option that you choose in the templare, by this i mean that it saves the actual date, so tomorrow when you run the import it will not be "today", so he will keep doing the day that was chosed in the template.
roland, since last run it doesn't work because it only exports the orders that are made "since last run", if the "since last run" option was directely connected to the "order status" option it would do the work, but it's not, if i choose the order status "shipped" since last run it would be easy to think that it will export the orders marked has shiped "since last run" independent of the date, but it doesn't, actually, first it checks the orders "since last run" then exports the ones marked has "shipped", i hope that i made it clear, it's a bit cofusing and my english is not that good (sorry about that).
It would be great to put one iteration that does something like this:
if "status"==true{
checkmodifieddatein(sincelastrun);
if checkmodifieddatein == true{
return orders;
}
}
something like this, sorry for the mess, i don't code anymore so the sintax is probably a nonsense but maybe you can get what i mean.

Thanks in advance.
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
tharuna it looks that the today option that you talk about returns today date for the option that you choose in the templare, by this i mean that it saves the actual date, so tomorrow when you run the import it will not be "today", so he will keep doing the day that was chosed in the template.

Yes i agree that every time you run the export you may need to change this date option.

roland, since last run it doesn't work because it only exports the orders that are made "since last run", if the "since last run" option was directely connected to the "order status" option it would do the work, but it's not, if i choose the order status "shipped" since last run it would be easy to think that it will export the orders marked has shiped "since last run" independent of the date, but it doesn't, actually, first it checks the orders "since last run" then exports the ones marked has "shipped", i hope that i made it clear, it's a bit cofusing and my english is not that good (sorry about that).
It would be great to put one iteration that does something like this:
if "status"==true{
checkmodifieddatein(sincelastrun);
if checkmodifieddatein == true{
return orders;
}
}
something like this, sorry for the mess, i don't code anymore so the sintax is probably a nonsense but maybe you can get what i mean.

The problem was that CSVI has been using created_on date to check with the last run date and so even when the order has been modified, the order was not included in the export. The attached patch file will give you an option in template settings to select created_on or modified_on date to be used for checking for date range option. You can load the patch file using CSVI maintenance menu and look for field Use date field under Date range option in options tab. By default it is set to created date, set it to modified date and check if your exports works as expected.

patch_vm_order_2010_10_13.zip
Attachments (1)
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
Accepted Answer Pending Moderation
Hello,

We understood your idea and support your request to make this more intelligent. Please test the patch Tharuna has provided and we can include it in a future release.
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. # 5
  • Page :
  • 1


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