Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Importer with Windows-1250 support
Avatar
Michal Havli
Member
Free Members
Offline
Jul 22, 2013 - 11:41 am

Hello,

i have a small...not, actualy i have a realy big problem. When i try to import post from bbpress forum, it change some character specific to my country, like ř or č, with empty space or some strange characters. I know its problem of diferent coding, but theres my knowlege ends :-( So, please, is there a way to modify importer to Windows-1250(eastern european) charset?

When i submit new topic, all chars are good, this happens only when i try to import post from old forum.

  I hope u understand my message, cause me english is TERRIBLE, so sory about that.

Thanks for your replies and have a nice day guys :-)

Avatar
Yellow Swordfish
Glinton, England
SP Master
Offline
Jul 22, 2013 - 12:12 pm

Why not utf-8? And if utf-8 works for you have you tried importing with the utf-8 filter option turned on?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Michal Havli
Member
Free Members
Offline
Jul 22, 2013 - 2:02 pm

I know, UTF-8 is my best option now. But still having this problem. Its weird, becasue source of forum is in UTF-8. But when i try to import old forum, everything goes wrong. 

Avatar
Yellow Swordfish
Glinton, England
SP Master
Offline
Jul 22, 2013 - 2:43 pm

So if the source is utf-8 and you have the option turned on within the import to use utf-8 have you looked at the actual database tables to see what encoding they have been created with as the SP tables will inherit the encoding from the database global setting.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Michal Havli
Member
Free Members
Offline
Jul 22, 2013 - 4:38 pm

Well i tried and no change. I also tried to manualy import original DB into SP, but not working too. I know i doing something wrong, but i realy dont know what :-(

Avatar
Yellow Swordfish
Glinton, England
SP Master
Offline
Jul 22, 2013 - 5:16 pm

... and the encoding on the database tables themselves?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Michal Havli
Member
Free Members
Offline
Jul 22, 2013 - 11:07 pm

both, new and old are set on UTF-8_czech_ci. Also tried to set them on CP-1250, no change.

Avatar
Yellow Swordfish
Glinton, England
SP Master
Offline
Jul 23, 2013 - 4:21 am

That will be the table collation. Is the table encoding utf-8 as well?

If it is then I am not really sure what to suggest. I do have a script somewhere that attempts to re-code all the posts to utf-8 which I suppose you could try... if I can find it again!

andy-signature.png
YELLOW
SWORDFISH
Avatar
Michal Havli
Member
Free Members
Offline
Jul 23, 2013 - 5:07 am

Its simple, i think bbpress screw up coding. Maybe its reforum, i realy dont know. Iam pretty newbie in DB, so i dont know how far can template affect coding. But i thank you, A LOT! If you find that script, it would be great, but for now, i start with manual repairing of DB. Just 4000 post, no more then two weeks of work :-)  Thanks again!

Avatar
Yellow Swordfish
Glinton, England
SP Master
Offline
Jul 23, 2013 - 5:52 am

The attached script might help. Please note that the table prefix on this script is the default 'wp_' and if different you will need to change it on ALL statements.

It will convert the post content and the topic names. At least that is what it is designed to do and has worked for me in the past.

USE WITH CARE - preferably on a test run of the imported data. You will need a tool like phpMyAdmin to run the script of course. By the way - at the top are articles in the WP Codex on which the script is based.

 

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625