exporting data from Filemaker 6 to Servoy 2.2

Classic Servoy
1

I’m exporting data from Filemaker 6 to Servoy 2.2
(on Mac OSX 10.4)

All works fine,

  • however a “last import” field name list in Servoy would help alot! (Filemaker has that feature and it’s super useful!)

The only problem field is the Japanese text field.

Japanese text won’t export correctly in csv
and can’t be fixed in Servoy as far as I can see.

Any ideas?

I don’t have the Japanese version of Filemaker 6,
just the English version, which displays the Japanese text fine.

2

Using Jedit X I can convert the Filemaker 6 csv text file to display the
Japanese text in Jedit X.

So the Filemaker output is good.

I can save in Jedit X has various text formats.
UTF-16 for example.

But none will import to Servoy correctly.

I can cut and paste the Japanese text into the Servoy field,
but I’ve got 28,918 records to import!!

3

Servoy does nothing to the data. Your underlying database (Sybase, or other) have to support the double byte encoding.

What database engine do you use with Servoy ?

4

MySQL
Our solution shows Japanese text I paste into Servoy
and any I type in as well.

It just won’t import it!

5

Try importing the data using MySQL Query Brower or any other tool.
See if that makes a difference.

6

I can’t see how to import the data with MySQL Query Brower.

I tried mysqlimport in MAC OSX Terminal
but all i got was

Alex-Computer:/usr/local/mysql/bin alex$ mysqlimport

-bash: mysqlimport: command not found

Next we tried
Navicat

That imported the data,
both as csv and dbf
but it came out as garbled text again.

Help!

Alex

7

I’m now sure the Japanese Text has correctly imported to Servoy, but somehow it’s not displaying correctly.

In Filemaker this also happens sometimes, and I would select text such as this and just change the font
to a Japanese font. It would then display correctly.

But how do I apply these sort of font changes in Servoy?

I’ve set the font type in the property editor to a Japanese Font, but it doesn’t apply.

8

Fixed it!

Save text as UTF-8
and then set
the defualt char set in MySQL Admin
to UTF-8