1. deurkruk
  2. RO CSVI
  3. Monday, 20 November 2017
  4.  Subscribe via email
Hi,

We are using CSVImproved to export Hikashop orders on daily base. These export are done every evening at 22 hours and should export the new (confirmed) orders since last run.

But lately, it looks like there are somtimes orders exported twice. This should not be possible, since we have as rule it should look at new orders since last run.

When I compare these orders, it seems that all of these orders are made between 21 and 22 hours, in fact the hour before export is made. Is it likely that this is where the bug is coming from? Maybe wrong server time? Or...

I hope you have a suggestion, because our Fulfilment partner has many problems with working with our exports now.

Regards, Carst
Accepted Answer Pending Moderation
Hello Carst,

In a situation like this there are a few things we need to check. So let's make a checklist:
  1. Are the duplicates in the same export or across multiple exports?
  2. When it is 10 am Amsterdam time, what time does the server give you?
  3. What timezone is Joomla set to?
Let's get this data first and we can check what might be going on. I am pretty convinced it is a timezone issue, just need to find out where the issue comes from.
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi Roland

Thanks for your reply. I answer it below:


  1. Are the duplicates in the same export or across multiple exports?
    The duplicates are in multiple exports

  2. When it is 10 am Amsterdam time, what time does the server give you?
    As far as I can see, the time on the server is A'dam time, so no differences here.

  3. What timezone is Joomla set to?
    In Joomla Server Time Zone is set to A'dam as well.

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

Thank you for the answers. This has helped me to find what I believe is the issue. The lastrun timestamp is GMT while the orders are in Amsterdam time. This hour difference causes the issue you see and only if orders are within the last hour.

Attached is a patch file that you can load via the Maintenance menu. Please give it a try and let me know your findings.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hi Roland,

I'm afraid the export did not work tonight with this patch. I hope you can help me out, as this is a live webshop and things must remain working.

Regards, Carst

Log: com_csvi.log.1043.zip
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Carst,
Can you please explain the issue you have in your export? What did not work? Did you not get any orders in the export? Looking at your debug log, you have few filters set for the export like the orders from product category with id 12 with status as confirmed. Do you have orders matching to these filters?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello Tharuna

The export did not export anything at all, that is the main problem.
I can't check the results, which Roland has made. But yes, there should be some orders in the export.

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

The only thing I changed is to modify the last run time by 1 hour. There isn't a logfile either of the export? Do you see the export in the Logs page? Was it even started?
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hi Roland

The cron is running and as far as I can see the job is started but is not ending.

Could we better restore the previous file?
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Carst,

You can restore the previous file, no problem. Can you post the debug log of the last run? If you can't find this in the CSVI logs, you should be able to find it in the logs folder on your server. Assuming you have the debug option turned on in your template.

This still makes me wonder why it wouldn't run as the change is very basic. If you create a copy of the template, set the debug mode to Yes and export to file to Download and run that manually, do you get any output? We could check that log file instead. This is done with the patch still applied of course.
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
I get an Internal Servererror. I'll put backup back
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,

That would explain why the cronjob doesn't run. I have attached a new patchfile which has the same code as the original file, only change is I hardcoded the 1 extra hour in there. So it won't be calling any other files. The result should be the same as the previous patch minus the internal server error.

Which PHP version are you running on your server? As for the internal server error, can you check the server error log to see what the real error is? This would tell us what code it doesn't like.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 11
  • Page :
  • 1


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