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: [email protected] 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
