Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Dual language

7 replies [Last post]
Thu, 2005-11-24 03:01
Joel Gilbert
User offline. Last seen 5 years 18 weeks ago. Offline
Joined: 5 May 2003
Posts: 166
Groups: Petro-Chem / Oil & Gas
Dual Language,
If the activity description is filled in English, and I want to have another column next to activity description in Chinese. Is the only way around it to use the Log, one by one?
Is there nothing like MSP a text column? Or is the only way to import from excel but then it alters the Characters?

Anybody with a suggestion?
Top

Replies

Tue, 2005-11-29 00:01
#1
Serge Marashlian
User offline. Last seen 10 years 37 weeks ago. Offline
Joined: 18 Apr 2005
Posts: 6
Groups: None
Again I have the same problem, but this time it is in Arabic. i will try to use the batch option. Thank you fot the help.
Serge
Top
Fri, 2005-11-25 01:16
#2
Joel Gilbert
User offline. Last seen 5 years 18 weeks ago. Offline
Joined: 5 May 2003
Posts: 166
Groups: Petro-Chem / Oil & Gas
will give it a bash

Thanks planners
Top
Thu, 2005-11-24 23:23
#3
Zhang Haixiang
User offline. Last seen 4 years 20 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
I did this before and no problems.


First export the activities with a empty log column to DBF.
Modify the empty log to what you want,
then import.

another way to do this is to use P3 batch,It’s not so easy to start. you need take some time to study the P3 batch Manual.

you may contact www.P3china.com for some language tools,e.g. switch the interface to Chinese....

hope this helps
Top
Thu, 2005-11-24 12:52
#4
Mario Sanvitale
User offline. Last seen 13 years 4 weeks ago. Offline
Joined: 22 Sep 2005
Posts: 139
Groups: None
I know it may not be an answer you will be able to do, but moving to Primavera Enterprise would resolve the problem we believe because P3e supports the Windows fonts, unlike P3. You would be able to switch to Chinese in the text field and type straight in. We did try with Russian in P3e a week ago and it worked fine!
Top
Thu, 2005-11-24 07:46
#5
Hannes de Bruyne
User offline. Last seen 2 years 24 weeks ago. Offline
Joined: 25 Jul 2005
Posts: 154
Groups: None
Hello Joel,

I had this problem a few times with Greek Characters. The best way for me was to import a log Column with the seccond language. But than you have a problem with characters and fonts.
This problem is caused by the 16-bit problem of P3. Therefore I wrote a small macro in Excel:

Function TranslateGreek()
Dim test, zwischen As String
iRow = 3
Worksheets("Activity").Activate
Do While Cells(iRow, 1) <> ""
Application.StatusBar = iRow - 3
If Cells(iRow, 19) <> "" Then
test = ""
For i = 1 To Len(Cells(iRow, 19))
zwischen = AscW(Mid(Cells(iRow, 19), i, 1))
test = test & IIf(zwischen < 256, ChrW(zwischen), ChrW(zwischen - 720))
Next i
Cells(iRow, 11) = test
End If
iRow = iRow + 1
Loop
End Function

The result of this translation looks funny in Excel,imported in P3 it still looks funny if I use Arial (Like: Âüñåéïò ÊëÜäïò), but as soon as I use a font for Greek as I used it for Windows 95, everthing is . So maybe this works in a similar way for Chinese (Maybe "720" must be changed into another number)

(I read from Column 19 and write into Column 11)
Regards Hannes
Top
Thu, 2005-11-24 05:19
#6
Mario Sanvitale
User offline. Last seen 13 years 4 weeks ago. Offline
Joined: 22 Sep 2005
Posts: 139
Groups: None
I discussed this recently in the UK - when you say the characters change - is the PC you are using running the Chinese version of Windows XP? There was a theory that if you were running Chinese XP the characters would be OK. Maybe if you contact the local dealer he can help.
Top
Thu, 2005-11-24 04:02
#7
Jackie Gilliland
User offline. Last seen 14 years 36 weeks ago. Offline
Joined: 17 Mar 2005
Posts: 41
Groups: None
Hi Joel

A possibility is to put it in a custom data field, but you are unfortunately limited to 20 characters.

Jackie Gilliland
Top