Page 1 of 1

Lead language problems

PostPosted: Sat Aug 16, 2014 5:43 am
by gkandylakis
I'm trying to load some leads with greek letters in it and i'm getting the follow in my agent screen:

tinypic. com/r/2znn32v/8 (site blocks my picture uoload, delete space before com to view)

I'm uploading the leads in UTF-8 format and after changing the latin1_swedish_ci of the fields in the vicidial_list to utf8_general_ci managed to view in the database tables my leads correctly. Still when i try to view it from my agent front end i'm getting the same ??????? i got before. Is there any other field that needs to change collation in order to be viewed properly?

Re: Lead language problems

PostPosted: Sat Aug 16, 2014 6:40 am
by mflorell
Make sure your PHP is set to use UTF-8 instead of latin.

Re: Lead language problems

PostPosted: Sat Aug 16, 2014 8:32 am
by gkandylakis
i use the goautodial 3.3 pack and even by enabling the mbstring.dll and configuring it to use UTF-8 i still get ????? from the database (i rebooted apache to read the php.ini again). If i manually add greek letters from the agent frontpage it's insterted correctly and show properly but in the database i'm getting this format "τεστ" for the word "τεστ". From what i can see agent.php has "charset=utf-8" in his meta.

Re: Lead language problems

PostPosted: Sun Aug 17, 2014 7:12 am
by mflorell
You should try posting in the GoAutoDial forum, I don't really work on those systems much, I only work with Vicibox.

Re: Lead language problems

PostPosted: Mon Aug 18, 2014 2:00 pm
by gkandylakis
I tried. They got a really slow forum. Almost no answer at all. Anyone else got any ideas?

Re: Lead language problems

PostPosted: Wed Aug 20, 2014 4:36 pm
by miixx
Hey i have the same problem with typical german letters like Ü or Ä ... i must open the csv with Open office and save as csv then came an Dialoge and you see 3 dropdown the first is the language here you must scroll to Unicode UTF8 the second is the separeted sign here i put the | in and the last is ok this is the textsign " this is ok...

then save and rename from myadresses.csv to myadress.txt . Then upload all is going...