[HELP] Override Time zones?

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

[HELP] Override Time zones?

Postby AlexR » Fri Nov 17, 2006 4:33 pm

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
AlexR
 
Posts: 127
Joined: Mon Aug 21, 2006 5:02 pm

Postby mflorell » Fri Nov 17, 2006 4:35 pm

What country are you in?
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby AlexR » Fri Nov 17, 2006 4:41 pm

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?)
AlexR
 
Posts: 127
Joined: Mon Aug 21, 2006 5:02 pm

Postby mflorell » Fri Nov 17, 2006 4:56 pm

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
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 143 guests