CKD-Zen-Cart Japanese Pack

I found it!
By comparing the form page to send message from admin in different languages I found an error in the japanese.php file (the admin one) on line 63:
define('CHARSET', 'utf8');
It should be this:
define('CHARSET', 'utf-8');
The '-' was missing. I checked your pack and it is missing too. It is not something I touched. Perhaps on your system it is working fine if you use some UNIX system with UTF-8 but on Windows xp which is not in Japanese it doesn't as when you imput Japanese in a form it is Shift-jis encoded I think if no other encoding is set.
I hope you didn't waste too much time with this as you seem to be very busy.:wink:
I think now everything is working perfectly... until next bug appears.:D

Thanks for the update there. I only use Linux servers. I will update the pack on that. And yes, I have been really busy.

On a different note, I will be uploading changes to the pack soon. As the way customer postal codes are taken will be changed. The paypal file will be deleted from the pack and 2 more files will be overridden and one core file will be changed.

You can see more here.
http://www.zen-cart.com/forum/showthread.php?t=103678&page=2

pilou2:

I found it!
By comparing the form page to send message from admin in different languages I found an error in the japanese.php file (the admin one) on line 63:
define('CHARSET', 'utf8');
It should be this:
define('CHARSET', 'utf-8');
The '-' was missing. I checked your pack and it is missing too. It is not something I touched. Perhaps on your system it is working fine if you use some UNIX system with UTF-8 but on Windows xp which is not in Japanese it doesn't as when you imput Japanese in a form it is Shift-jis encoded I think if no other encoding is set.
I hope you didn't waste too much time with this as you seem to be very busy.:wink:
I think now everything is working perfectly... until next bug appears.:D

To the two people who said they had checkout problems. I have no problem with this.

I know that's no help, but I would check for a php white space error, check if you have any files that deal with the checkout area with blank spaces after the final closing php tag, "?>"

Regards,

CKD

Thank you so much, CKD, for such a great language pack and dedication to getting it right. As a new Zenner, it really makes me feel enthusiastic about this community to have such awesome members!

(Oh, and by the way this saved my sanity:

pilou2:

I found the answer to my last trouble with the pull down menu not working everywhere. In fact you have to copy the file "jscript_addr_pulldowns.php" created in "/includes/modules/pages/create_account/" to 3 other folders:

../includes/modules/pages/checkout_payment_address/
../includes/modules/pages/login/
../includes/modules/pages/popup_shipping_estimator/

Then all pull down menu will work.:D

I'd been banging my head against this for an hour trying to figure out what I was doing wrong. Feel free to put this in bold on your site, and blinking, with fireworks for slow folks like myself... :wink:)

Thanks again to both you and pilou2!

Alex

Thanks very much Crystal Koi for all your work.

I'm having trouble with the Japanese-English zone dropdowns. The Japanese text appears as ??? (Please see http://floatingworldweb.com/agora/index.php?main_page=login&language=ja)
All the other Japanese in the site appears fine.

Having followed all of the steps in your website except the first, I'm guessing it might be the encoding in the database. (The database and store were already installed before I came along to install Japanese.)

I've tried to change the collation encoding of the database to utf-general-ci, but the individual tables remain latin-swedish-ci. Changing the zone table and text rows in it enabled me to get the Japanese text into the table, but the output for the final user is still ???

I'm guessing I should set up a new database with utf-general-ci encoding from scratch, but can't really work it out. Is there an easy way to change my database encoding properly, or copy it to another database with correct encoding, or otherwise fix my mess?

FOLLOWUP INFO

I've successfully transferred to a new database entirely in utf-general-ci. The Japanese zone names in the database 'zones' table all appear OK, yet on the page they STILL appear as ???

Please help - what could I be doing wrong?

Followup two:
Managed to get it sorted out...

First up, did a fresh install of Zencart, but when it told me the database it would create I beat it there and set the encoding as recommended.

Secondly, exported my original database, ensured the encoding wouldn't change by editing the SQL file, then imported to the new database.

Changed the pointers in my original Zencart's configure.php files to use the new database.

Then when setting up the jscript_addr_pulldowns.php files I copied in the kanji manually.

@shen,

Sorry I wasn't around to help you out there. But there is nothing better than learning the hard way and doing it on your own. I'm glad to see you got it all worked out.

Regards,

CKD

No worries CrystalKoi. It is working out so far, although I don't know why the first step in setting up the dropdowns produced all those ???s. Hopefully there won't be similar problems in future when pulling Japanese from the database.

NOW, I'd like some advice on setting up Japanese shipping and payment modules. I can't really find that info anywhere - any leads?

Mmm, still having troubles with getting the Japanese prefecture names out of the zones table properly. I've tried installing the shipping modules from the Japanese localisation pack available from zencart.com, and I'm having many troubles. First of all that the zone names are coming to the shipping module code as ???

What to do? The checks for UTF-8 encoding are all OK - the database tables and rows are all utf-general-ci and I can read the Japanese zone names via PHPMyAdmin.

Hasn't anybody set up Japanese shipping modules (eg Yamato, Sagawa) in Zen Cart to work with the CKD Japanese language pack?

Followup info from my last post:

Checking out other tables in the database with Japanese content, I found that my products info, inputted through the zen-cart admin area in Japanese and outputted in the online catalog correctly in Japanese, appears as gobbledigook in PHPMyAdmin!
(eg オーマス comes out as オーマス)

I guess this means that if I can put the zone names into the database in the correct gobbledigook, I can get the right output...

This would be just a hack/workaround, so I'd like to hear any ideas on how to avoid having to do this too...
I'm sorry I don't know much about how databases and encoding actually work.

Oops very sorry, I found my mistake.
In transferring my database to the new utf database, I copied the zone table directly. Just now, having deleted the Japanese zones and re-entered them using Crystal Koi's SQL patches through zencart admin, it works.
STILL a bit strange that you can't read the Japanese through PHPMyAdmin though...

Also still keen for any advice on setting up Japanese shipping and payment modules, although I am making slow progress...

Hi,

I recently installed the Japanese language pack on a test server. So far everything seems to work ok except when I get to the "Review Order" page and click to OK button. The next page should be the "Order Complete" page which displays some information indicating the order was successfully placed. However in my case, it is just blank. I traced the problem to the following file (which handles off-line cc processing):

includes/languages/japanese/modules/payment/cc.php

In the Japanese language pack, the above file is UTF-8 encoded.
The English version is US-ASCII encoded. When I substitute the English version for the Japanese version everything works (except no Japanese on the "Order Complete" page. So to work around this, I converted the Japanese version to US-ASCII and it also worked -- only now my "Order Complete" page shows Japanese characters like I want.

Of course converting Japanese UTF-8 pages to US-ASCII is a royal pain so I'd like to keep them UTF-8.

In order to do this, I need to figure out which file down stream from cc.php does not like the UTF-8 encoding.

Anyone have any ideas? My error log indicates there may be a problem in functions_general.php at line 44. However, when I look at that file, I don't see anything that would cause a problem like this.

Thanks,

Doug

For reference, below is the error log:

PHP Warning: Cannot modify header information - headers already sent by (output started at /includes/languages/japanese/modules/payment/cc.php:1) in /includes/functions/functions_general.php on line 44

I have posted my (rough) shipping modules for domestic and international parcels from Japan on this thread:

http://www.zen-cart.com/forum/showthread.php?p=623780

Includes Japan Post Youpack (domestic), International parcels by Air, Sea, SAL, EMS, and domestic parcels by Yamato, Nittsu and Sagawa, adapted to work with CKD's zone dropdowns.

The modules need further work, especially full bilingual translations and incorporating dimensional shipping, but anyway there's useful data there for you all.

I've followed instructions and installed UTF-8 Zen-Cart, Zen-Car 1.3.8 Japanese Pack, and now Zen-Cart Japanese/English Pull Down (CKD-Multi-Lingual-PullDowns1.0) and all seems okay except /create_account/jscript_addr_pulldowns.php. The prefectures in the login page list are in both Japanese and English. The other pages, address book and checkout list the prefectures correctly in English or Japanese depending on the user. I compared the orginal script from the zip file and the modified one on my website and found the only differences are the java script copied in as instructed. What could be the problem?

Thanks to Crystal Koi & Shaun Ward for their great help!

Zen Cart 1.3.9h (Fresh Install)
PHP 5.2.17

Server OS: Linux 2.6.35.8-nx
PHP Version: 5.2.17 (Zend: 2.2.0)
Database: MySQL 4.1.22-standard-log
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
v1.3.9h [2011-03-18 22:41:21] (Fresh Installation)
Language Japanese/English
Addins Edit Orders 3.03, Super Orders 3.0

Somehow my invoices no longer have the 様 at the end of the name. Without it documents to customer are rude, does anyone know how this can be corrected?

Craig