Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #3276

Re: FileMaker Pro 18: Import Records has been changed

Show all headers | View raw

On 2019-10-03 20:29:37 +0000, Martin Τrautmann said:

> On Fri, 4 Oct 2019 08:22:56 +1300, Helpful Harry wrote:
>> I don't know about the CR / LF / CRLF. There is still the pop-up menu
>> for "Output file character set" with various options, including
>> "Windows (ANSI)", "ASCII (DOS), "Macintosh", etc., but I've never
>> needed to look into what the difference for those options is.
> 
> So propably nothing changed here.
> 
> FMP on Windows does export with CRLF.
> FMP on Mac does export with CR only.
> 
> But Mac is based on some unixoid system from OSX on - and due to the
> limited capabilities of FMP, I frequently do a "sort -u" or regex data
> conversion via the terminal or do an upload for other purposes and
> exchange. Then Mac's CR is always some kind of extra trouble, where I
> would prefer a choice to export with other EOL delimiters.
> 
> BTW, how about the import experience now. I usually do convert everthing
> to tab delimited fields and do rename files to .txt or .tab.
> Is there some better import function now where you can define how to
> handle .csv. Not only the input character set (mainly windows, latin-1,
> utf-9 and mac), but
> * separated by comma, semicolon, tab, space, other
> * string delimiter (such as ")
> * fixed with
> for real .csv handling?
> 
> Here I do use Libreoffice, which is rather suitable for that job.
> I still hope for a copy/paste operation some day between filemaker's
> table view and another table or spreadsheet from other applications.
> 
> - Martin

I've only had to do the one import from an Excel spreadsheet so far, 
but as the picture shows, there is a new "Import Options" section at 
the bottom-left which may help you. It has options to let you define 
the character set (same as the export window) and the field delimiter - 
depending on the import file type of course (it's disabled for Excel 
spreadsheets, for example).

<https://www.soliantconsulting.com/wp-content/uploads/2019/05/blog-fm-import-field-mapping.jpg> 



Helpful Harry  :o)

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

Thread

FileMaker Pro 18: Import Records has been changed Helpful Harry <HelpfulHarry@BusyWorking.com> - 2019-10-02 19:38 +1300
  Re: FileMaker Pro 18: Import Records has been changed Martin Τrautmann <t-usenet@gmx.net> - 2019-10-02 08:56 +0200
    Re: FileMaker Pro 18: Import Records has been changed Helpful Harry <HelpfulHarry@BusyWorking.com> - 2019-10-03 12:34 +1300
  Re: FileMaker Pro 18: Import Records has been changed Helpful Harry <HelpfulHarry@BusyWorking.com> - 2019-10-03 12:30 +1300
    Re: FileMaker Pro 18: Import Records has been changed Martin Τrautmann <t-usenet@gmx.net> - 2019-10-03 14:53 +0200
      Re: FileMaker Pro 18: Import Records has been changed Helpful Harry <HelpfulHarry@BusyWorking.com> - 2019-10-04 08:22 +1300
        Re: FileMaker Pro 18: Import Records has been changed Martin Τrautmann <t-usenet@gmx.net> - 2019-10-03 22:29 +0200
          Re: FileMaker Pro 18: Import Records has been changed Helpful Harry <HelpfulHarry@BusyWorking.com> - 2019-10-04 15:20 +1300
            Re: FileMaker Pro 18: Import Records has been changed Martin Τrautmann <t-usenet@gmx.net> - 2019-10-04 09:12 +0200
              Re: FileMaker Pro 18: Import Records has been changed Helpful Harry <HelpfulHarry@BusyWorking.com> - 2019-10-05 09:31 +1300

csiph-web