1 Reply Latest reply on May 4, 2015 3:25 PM by philmodjunk

    Import Records using variables in the directory

    LuisLoya

      Title

      Import Records using variables in the directory

      Post

      Hello,

      I am trying to write a script to import data from a list of files (I have over 300 FM12 files that need to be merged into a single database)

      I am using the following script:

      Set Field [input number;0]

      Loop

      Set Field [inputNumber;inputNumber+1]

      Import Records [No dialog;"$inputDirectory";add;Womdpws ANSI]

      Exit Loop if [inputDirectory="END"]

      End Loop

       

      The file directories live in a table with a list of input numbers.  As the variable inputNumber is updated, a new value is stored in inputDirectory.

       

      The script does not seem to work, and I'm guessing it's because of either a syntax error, or the Import Fields command does not allow for a variable in the file directory.

       

      Any help with this would be much appreciated!