Turkish character problem while importing
yourrfriend - February 7, 2009 - 22:32
| Project: | Taxonomy CSV import/export |
| Version: | 6.x-1.5 |
| Component: | User interface |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Description
hi thanks for this module
while i try to import csv file in turkish there exist turkish character problem. i tried to save csv file in utf-8 and unicode. but nothing changed.
I appreciate any help
thanks
barış kiremitci
istanbul
#1
i have to add something about problem.
Turkish Character problem exists mostly if first letter of the word is a Turkish special like İ (İstanbul) or Ç (Çanakkale). After importing the csv file if first letter of word is İ,Ç, Ş, Ö then this characters omitted-blank at imported word.
In database tables it is also omitted.
İstanbul becomes stanbul. İzmir becomes zmir.
Üniversite becomes niversite.
i attached sample csv as text file.
baris
#2
Same problem with regular latin characters like àáãâéê...
First character is removed.
Ricardo
#3
Hi,
You need to protect terms beginning with a non-ascii letter with quotation marks as "émotion".
I make a patch where I indicate it in the help (and other improvments), but it's a it's a php and not a Drupal bug. See http://drupal.org/node/377056.
Sincerly,
Daniel Berthereau
#4
Hi all,
I ve got same problem.
Ive got a csv file that including "Süleyman" data.
But when I imported this csv, I ve got a blank field...
thanks for help..
#5
Hi,
Could you tell me which releases of taxonomy_csv and Drupal do you use?
Generally, when you use neither only ascii characters neither utf8 encoded file, you need to protect all your terms with quotation marks, as :
"Süleyman","Türk Kağanları ve Sultanları","Süleyman TÜRK"Furthermore, "tab" separator between fields, as in comment # 1, is currently not supported.
You can save your file with quotes and utf-8 encoding with OpenOffice Calc to avoid problems.
Regards,
Daniel