Dual language

Hi Joel

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

Jackie Gilliland

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

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

will give it a bash

Thanks planners

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