Page 1 of 1

[HELP] Override Time zones?

PostPosted: Fri Nov 17, 2006 4:33 pm
by AlexR
Hello...


Im not sure I understand how the timezones work, I uploaded a lead file with

Code: Select all
100001|10001|107|1|58910295|MR|I|P|FREELY01|249 MUNDON ROAD|||MALDON|FL||33709|USA|M|1970-01-01|7275551212|test@test.com|nothing|COMMENTS


several times, but when I see the DB some have different timezones than others. How is this possible?

I've tried manually setting on the DB the GMT timezone so it is uniform, but if I do an update on MySQL the "lastmodified" field gets updated and the lead is not processed.

Am i able to override this so everything works in the same timezone?


Thank you!


Alejandro

PostPosted: Fri Nov 17, 2006 4:35 pm
by mflorell
What country are you in?

PostPosted: Fri Nov 17, 2006 4:41 pm
by AlexR
Guatemala GMT-6, but I fail to understand how the same lead can be uploaded in different timezones, where does VICIDIAL gets it GMT info for each lead?

Thanks Matt


(Matt, how could i contact you to discuss support pricing info?)

PostPosted: Fri Nov 17, 2006 4:56 pm
by mflorell
Guatemala's international phone code is 502 so you would need to replace the "1" (country dialing code for US/Canada/Carribean) with your country's code in that field(the one right before the phone number), then either load the leads again, or rerun the ADMIN_adjust_GMTnow_on_leads.pl script.

The GMT time zone info is stored in the vicidial_phone_codes MySQL table.

For support questions, email me at vicidial -at- gmail.com