Anybody successfully implemented a Date Offset contribution??

[henrygoh]

I searched and cannot seem to find anyone saying they have successfully implemented any Date Offset? I need to set my server to GMT+8 hours but have not been able to get this done. Really appreciate some help. Thank you.

Henry

[henrygoh]

bump for a good cause

[gilby]

I searched and cannot seem to find anyone saying they have successfully implemented any Date Offset? I need to set my server to GMT+8 hours but have not been able to get this done. Really appreciate some help. Thank you.

Henry

Search fot TIME ZONE OFFSET
or
look in downloads->other modules->timeZoneOffset

This is for 1.3.0.1 if you have a previous version its available as well
This sets the time offset for the database stuff which is the most important.
You can set the admin server time by adding another file with a TZ variable for your time zone.

[henrygoh]

Hello Neville,

I actually emailed you yesterday hoping to get some instructions on implementing your contribution for Date Offset. I don't quite understand (I'm a total newbie and a non-programming guy) and was not able to get your contribution working. I really, really need to get this small cart of mine to work right since I only sell in Singapore.

Would be truly grateful for some hand-holding through this.

Henry

[gilby]

Sorry I'm Not Neville??? no email received by me!

Assuming you are using 1.3
download contrib, unpack on your computer
Copy & paste the contents of the sql patch to the box in the admin->tools->install sql patches area of the administration side of the site.
Run (send) the query.

Upload the files in the admin directory to the admin directory on your site.

Open admin->configuration->my store->time zone offset, put +8 in here

Thats it

[henrygoh]

Sorry I'm Not Neville??? no email received by me!

Assuming you are using 1.3
download contrib, unpack on your computer
Copy & paste the contents of the sql patch to the box in the admin->tools->install sql patches area of the administration side of the site.
Run (send) the query.

Upload the files in the admin directory to the admin directory on your site.

Open admin->configuration->my store->time zone offset, put +8 in here

Thats it

Really sorry.. I'm getting names all mixed up.

Before I saw your reply, I had re-run the patch again but w/o sending the query. Seems to work in so far as Date Offset for reports and time stamp on purchase are concerned but my Admin panel clock remains unchanged. Is this to be expected? Is it harmful if I now re-run the whole process on the existing database? Will the mod cause errors if I do not work on an unmod database?

Thanks a zillion for coming back and writing a very clear and simple set of instructions. Really appreciate this.

Henry

[gilby]

Before I saw your reply, I had re-run the patch again but w/o sending the query. Seems to work in so far as Date Offset for reports and time stamp on purchase are concerned but my Admin panel clock remains unchanged. Is this to be expected? Is it harmful if I now re-run the whole process on the existing database? Will the mod cause errors if I do not work on an unmod database?

Thanks a zillion for coming back and writing a very clear and simple set of instructions. Really appreciate this.

Henry

Running the patch again will bring up errors saying it can't insert the patch because it alredy exists. Ignore it It does no damage.

I prefer not to patch the admin panel but to use a simpler approach.
create a file time_offset.php and put the correct define in it for your time zone.
You may have to search to find the correct valid names for your time zone.

Heres the one I use in Oz

<?php 
//You can modify the TZ (Time Zone) by using one of the following offsets
//TZ=America/Los_Angeles
//TZ=America/Denver
//TZ=America/Chicago
//TZ=America/New_York

putenv ('TZ=Australia/Melbourne'); 
?>

upload to
admin/includes/extra_configures/

This doesn't work on all servers but try it out and see.

[henrygoh]

Thank you very much gilby!

This works very well and I now have the cart working correctly.

Very grateful for your help.

Henry

[henrygoh]

Thank you very very much. Everything is working nicely now.

I'm just wondering if I should update to 1.3.0.2 because I understand that all or most of my mods may be discarded....??? not sure what to do...

Henry

[gilby]

Thank you very very much. Everything is working nicely now.

I'm just wondering if I should update to 1.3.0.2 because I understand that all or most of my mods may be discarded....??? not sure what to do...

Henry

I have already updated the time zone offset for 1.3.0.2
Just need to do some testing to make sure its working ok before I update my sig to point to it, and to update the downloads section.

Sigh "When will it ever be finished...."