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


Groups > comp.databases.filemaker > #3278

Re: FileMaker Pro 18: Import Records has been changed

From Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups comp.databases.filemaker
Subject Re: FileMaker Pro 18: Import Records has been changed
Date 2019-10-05 09:31 +1300
Organization Aioe.org NNTP Server
Message-ID <qn8a74$p1d$1@gioia.aioe.org> (permalink)
References <qn1gl9$q42$1@gioia.aioe.org> <slrnqpds76.ls9.t-usenet@ID-685.user.individual.de>

Show all headers | View raw


On 2019-10-04 07:12:38 +0000, Martin Τrautmann said:

> On Fri, 4 Oct 2019 15:20:44 +1300, Helpful Harry wrote:
>> 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> 
>> 
> 
> thanks, if it's more than tab, that's at least one improvement.

The pop-up menu has field delimiter options of tab, comma, semicolon, 
and space, but there's also the "other" option underneath that pop-up 
menu where you could potentially define almost any single character you 
wanted (it let me paste in a return / carriage return character, but I 
haven't tried a file using that as a field delimiter - it would cause 
problems since you can't define a record delimiter).



> are you aware of the LibreOffice import dialog?
> 
> https://ibb.co/xG5ggdc

No. I very occasionally use Libre Office to convert old ClarisWorks 
documents, but that's all.


Helpful Harry  :o)

Back to comp.databases.filemaker | Previous | NextPrevious 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