DataLoad Community Forum Index DataLoad Community

 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Loading Chinese language data

 
Post new topic   Reply to topic    DataLoad Community Forum Index -> General DataLoad Support
View previous topic :: View next topic  
Author Message
spencerhmoore



Joined: 22 Aug 2007
Posts: 7

PostPosted: Wed Aug 22, 2007 6:48 pm    Post subject: Loading Chinese language data Reply with quote

I'm trying to load Chinese data into Oracle EBS 11.5.10.2 using the free version of DataLoad. I'm not having much luck.

Here's what I'm doing:

-- I'm using the Chinese (PRC) language
-- I'm using the Chinese (Simplified) - Microsoft Pinyin IME 3.0 editor
-- I'm using the font SimSun (although I've also tried others)
-- In the Text Services and Input Languages dialog box (in Windows XP) I've checked the "Extend support of advanced text services to all programs" checkbox.
-- Editing simplified Chinese in Word, Excel, Notepad all works perfectly.
-- I still get the '???" characters in DataLoad.

Can someone steer me in the right direction? I really need to load Chinese data into Oracle EBS.

Thanks.
Back to top
View user's profile Send private message
David



Joined: 15 Nov 2005
Posts: 97
Location: Near Heathrow Airport, London

PostPosted: Fri Sep 07, 2007 11:55 am    Post subject: Reply with quote

Click the "Search" icon at the top of the DataLoad Forum screen, then supply the Keyword "Chinese".

You will find your own question plus this one:- http://www.dataload.net/forum/viewtopic.php?t=42 which also refers to this one:- http://www.dataload.net/forum/viewtopic.php?t=11.

Cool HTH
_________________
When my time comes,
I want to die like my grandfather did:
quietly and in his sleep.
Not kicking and screaming like the passengers in his car.

David K. Dickson
DataLoad Forum Moderator
Back to top
View user's profile Send private message
spencerhmoore



Joined: 22 Aug 2007
Posts: 7

PostPosted: Mon Sep 24, 2007 7:42 pm    Post subject: Reply with quote

I'm doing everything that these posts suggest as far as I can tell and am still having the same problem.

Any ideas?
Back to top
View user's profile Send private message
David



Joined: 15 Nov 2005
Posts: 97
Location: Near Heathrow Airport, London

PostPosted: Tue Sep 25, 2007 11:22 am    Post subject: Reply with quote

If you do Help->About Oracle Applications in 11i what does it show for the NLS_LANG value, please?
_________________
When my time comes,
I want to die like my grandfather did:
quietly and in his sleep.
Not kicking and screaming like the passengers in his car.

David K. Dickson
DataLoad Forum Moderator
Back to top
View user's profile Send private message
spencerhmoore



Joined: 22 Aug 2007
Posts: 7

PostPosted: Tue Sep 25, 2007 3:47 pm    Post subject: Reply with quote

NLS_LANG : AMERICAN_AMERICA.UTF8
Back to top
View user's profile Send private message
David



Joined: 15 Nov 2005
Posts: 97
Location: Near Heathrow Airport, London

PostPosted: Tue Sep 25, 2007 4:11 pm    Post subject: Reply with quote

Thank you.

Now in the DataLoad Options form (DataLoad, Tools, Options), what does it show for Font, and is the "Unicode (UTF8) File Format for FLD Files" checked?

Thanks.
_________________
When my time comes,
I want to die like my grandfather did:
quietly and in his sleep.
Not kicking and screaming like the passengers in his car.

David K. Dickson
DataLoad Forum Moderator
Back to top
View user's profile Send private message
spencerhmoore



Joined: 22 Aug 2007
Posts: 7

PostPosted: Tue Sep 25, 2007 5:06 pm    Post subject: Reply with quote

I can use the fonts Default, Pinyin Okay, Courier, anything and it always displays the "?" instead of the Chinese character.

I have the "Unicode (UTF8) File Format for FLD Files" checked.
Back to top
View user's profile Send private message
David



Joined: 15 Nov 2005
Posts: 97
Location: Near Heathrow Airport, London

PostPosted: Tue Sep 25, 2007 6:00 pm    Post subject: Reply with quote

Smile Thank you. I think that that is all of the information required. Sad I regret that your problem is beyond my own knowledge and skills to resolve, but I have asked DataLoad Support to help.

David.
_________________
When my time comes,
I want to die like my grandfather did:
quietly and in his sleep.
Not kicking and screaming like the passengers in his car.

David K. Dickson
DataLoad Forum Moderator
Back to top
View user's profile Send private message
spencerhmoore



Joined: 22 Aug 2007
Posts: 7

PostPosted: Tue Sep 25, 2007 6:05 pm    Post subject: Reply with quote

Thanks for your help.

Are you able to make this work for you?
Back to top
View user's profile Send private message
David



Joined: 15 Nov 2005
Posts: 97
Location: Near Heathrow Airport, London

PostPosted: Wed Sep 26, 2007 10:40 am    Post subject: Reply with quote

No. I do not use either Japanese or Chinese (nor do I have access to a user who does). My current project does not use DataLoad Professional and I don't have access to a server which is set up for its use. I just happen to have been involved with DataLoad since just after it was launched, and enjoy helping people to get up and running with it, and volunteered to be a moderator on this forum. I am not employed by DataLoad and I do not have any commercial connection with DataLoad; I simply enjoy using it and enjoy helping others to get started (or helping them help themselves to get started).

While I was browsing the forum, I noticed your post and remembered the two previous posts, so I pointed you towards them. As far as I know, these issues have been resolved and the users are using DataLoad to load Japanese and Chinese characters. Therefore I anticipate that it should be possible to solve your problem. I don't know what the answer will be, but I think that I have asked you for the information that DataLoad Support will need to help you.

Cool HTH
_________________
When my time comes,
I want to die like my grandfather did:
quietly and in his sleep.
Not kicking and screaming like the passengers in his car.

David K. Dickson
DataLoad Forum Moderator
Back to top
View user's profile Send private message
spencerhmoore



Joined: 22 Aug 2007
Posts: 7

PostPosted: Wed Sep 26, 2007 3:51 pm    Post subject: Reply with quote

Thanks for your help. Hopefully I'll get it figured out.
Back to top
View user's profile Send private message
David



Joined: 15 Nov 2005
Posts: 97
Location: Near Heathrow Airport, London

PostPosted: Fri Oct 05, 2007 10:45 am    Post subject: Reply with quote

Did you also look at http://www.dataload.net/forum/viewtopic.php?t=95?

David.
_________________
When my time comes,
I want to die like my grandfather did:
quietly and in his sleep.
Not kicking and screaming like the passengers in his car.

David K. Dickson
DataLoad Forum Moderator
Back to top
View user's profile Send private message
spencerhmoore



Joined: 22 Aug 2007
Posts: 7

PostPosted: Fri Oct 05, 2007 4:10 pm    Post subject: Reply with quote

That worked! This is what I did:

Navigation: Microsoft Windows > Start > Settings > Control Panel > Regional and Language Options

On the last tab (Advanced) I selected Chinese (PRC).

Worked great! Thanks.
Back to top
View user's profile Send private message
David



Joined: 15 Nov 2005
Posts: 97
Location: Near Heathrow Airport, London

PostPosted: Fri Oct 05, 2007 4:31 pm    Post subject: Reply with quote

Cool You are most welcome.

David
_________________
When my time comes,
I want to die like my grandfather did:
quietly and in his sleep.
Not kicking and screaming like the passengers in his car.

David K. Dickson
DataLoad Forum Moderator
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    DataLoad Community Forum Index -> General DataLoad Support All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group