[libreoffice-users] Re: import data from FileMaker Pro?

Le 29/08/11 13:40, Paul Hochbaum a écrit :

Hi Paul,


> do you have any idea, how to import data from FileMaker Pro databases in order to convert them 
> into a libre database?

For the data, I have used CSV or SYLK in the past.
For the structure, export to *.BAS or *.MER (if those options are still
available) and then correct to fit the constraints accepted by Base.

Bear in mind that multi-valued fields, a favorite with FMPro
users/developers, are not directly transferable as these are not
supported by the HSQLDB backend engine.

Also, I seem to recall that the binary image fields of FMPro are not
importable either.

Date fields require validation/verification before importing into Base -
FMPro seemed to use non-standard date representation (but that would be
a general recommendation anyway, whatever the database).

Boolean fields can have 3 states in LO Base, True, False and Unset (i.e.
undetermined).

Multiple keys, if you have them, can sometimes be problematic.

Your field names should avoid extended latin characters, spaces and
punctuation such as question marks for best results. Such freedom of
choice is of course allowed in FMPro (or it was, unless Apple has
changed the way FMPro works).


Alex


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted