Groups > comp.databases.filemaker > #488

Re: Lion vs Snow Leopard and FMP 11 Advanced

From	Martin Τrautmann <t-usenet@gmx.net>
Newsgroups	comp.databases.filemaker
Subject	Re: Lion vs Snow Leopard and FMP 11 Advanced
Date	2011-12-01 05:25 +0000
Organization	slrn user
Message-ID	<slrnjde3u8.7a.t-usenet@ID-685.user.individual.de> (permalink)
References	<144912e2-626b-4cb4-b755-b4476a559060@i8g2000vbh.googlegroups.com> <slrnjdbg3u.84t.t-usenet@ID-685.user.individual.de> <1kbk8dh.12mfrqklcx9odN%dempson@actrix.gen.nz> <bbcollins-EB0830.17212830112011@70-3-168-216.pools.spcsdns.net> <yourname-0112111327490001@203-118-175-126.nzwide.ihug.co.nz>

Show all headers | View raw

On Thu, 01 Dec 2011 13:27:49 +1300, Your Name wrote:
>  FileMaker has (apparently) decided they want to abandon the ability to
>  export to the older .xls format, but you can still work around that by
>  exporting to CSV or tab-delimited text formats, which any version of Excel
>  will open and can then be re-saved as .xls.

FileMaker has still not managed to offer a choice of EOL characters.
Even if you do export as "Windows" charset, the EOL will be Mac only.
(Windows takes Carriage Return plus Line Feed. Mac takes Line Feed only,
Unix takes Carriage Return only. Or was it the other way round?)

This may drive some nonexpierenced users crazy when you mail them an
export. .xls is an easier choice.

FileMaker does import from CR, LF and CRLF files.
But FMP does always assume that encoding is Mac when you do convert a
text file to a database. Thus you may open/convert, then delete all
records, then import with proper encoding.

FMP lacks some basic import formats - such as
  "x","y",1,"z"
(comma or semicolon separated, with quote marks)

Does FMP on SL still import from .xls files?

- Martin

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Lion vs Snow Leopard and FMP 11 Advanced CRC123 <cra@aalappraisals.ca> - 2011-11-29 15:28 -0800
  Re: Lion vs Snow Leopard and FMP 11 Advanced Martin Τrautmann <t-usenet@gmx.net> - 2011-11-30 05:34 +0000
    Re: Lion vs Snow Leopard and FMP 11 Advanced dempson@actrix.gen.nz (David Empson) - 2011-12-01 10:01 +1300
      Re: Lion vs Snow Leopard and FMP 11 Advanced Bill <bbcollins@earthlink.net> - 2011-11-30 17:21 -0500
        Re: Lion vs Snow Leopard and FMP 11 Advanced yourname@yourisp.com (Your Name) - 2011-12-01 13:27 +1300
          Re: Lion vs Snow Leopard and FMP 11 Advanced Martin Τrautmann <t-usenet@gmx.net> - 2011-12-01 05:25 +0000
          Re: Lion vs Snow Leopard and FMP 11 Advanced dempson@actrix.gen.nz (David Empson) - 2011-12-01 22:47 +1300
          Re: Lion vs Snow Leopard and FMP 11 Advanced David Stone <no.email@domain.invalid> - 2011-12-01 09:30 -0500
            Re: Lion vs Snow Leopard and FMP 11 Advanced Martin Τrautmann <t-usenet@gmx.net> - 2011-12-01 15:29 +0000
              Re: Lion vs Snow Leopard and FMP 11 Advanced David Stone <no.email@domain.invalid> - 2011-12-01 11:51 -0500
                Re: Lion vs Snow Leopard and FMP 11 Advanced yourname@yourisp.com (Your Name) - 2011-12-02 09:06 +1300
              Re: Lion vs Snow Leopard and FMP 11 Advanced yourname@yourisp.com (Your Name) - 2011-12-02 09:03 +1300
            Re: Lion vs Snow Leopard and FMP 11 Advanced yourname@yourisp.com (Your Name) - 2011-12-02 09:01 +1300
              Re: Lion vs Snow Leopard and FMP 11 Advanced David Stone <no.email@domain.invalid> - 2011-12-01 15:48 -0500
            Re: Lion vs Snow Leopard and FMP 11 Advanced yapu@invivo.edu (Philippe Manet) - 2011-12-06 21:26 +0100
              Re: Lion vs Snow Leopard and FMP 11 Advanced David Stone <no.email@domain.invalid> - 2011-12-07 09:21 -0500

csiph-web