Dual language
Featured Partner
Top Posters
Sunchana Johnston
12 posts
Akram Hammam Mohamed
17 posts
Sagar Raut
14 posts
Patricio_aoa
0 posts
James Williams
75 posts
Philip Assou-Dodji
1 posts
jeoffrey reyes
15 posts
markg
0 posts
Manjeet Yadav
0 posts
Pan
0 posts
Our Partners
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
will give it a bash
Thanks planners
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,Its 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
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
Hi Joel
A possibility is to put it in a custom data field, but you are unfortunately limited to 20 characters.
Jackie Gilliland