4 Replies Latest reply on Oct 2, 2015 11:24 AM by jsheller

    Removing missing fields from an Import Records script step (using variable as data source)

    jsheller

      Using FileMaker Pro 14 Advanced, I found in my Database Design Report that I have missing fields in an import records script step. When I go to investigate the import order, there are indeed blank fields and I do not have the ability to remove them. It's important to mention that my script looks like this (simplified):

       

      Insert File [Filters; Reference; Never compress; <ContainerField>]

      <If statement checks if filename is correct. If not, script is exited.>

      Set Variable [$Report; Value: GetValue (<ContainerField> ; 2)]

      Import Records [No dialog; "$Report"; Add; Unicode]

       

      I use Insert File because the Import Records dialog can not be customized to auto-select the appropriate format. I also am unable to check the file being imported in the Import Records dialog to make sure the correct file was selected for the task.

       

      I would love the above statement to be proven wrong. Otherwise, I would like to find a way to refresh the list of fields that are displayed in the Import Field Mapping dialog.

       

      Bonus question, because of the method I use, I am unable to select the option to not import the first record. Is there a way around this?

       

      Any help is appreciated.