2 Replies Latest reply on Mar 11, 2009 9:47 AM by jlgonqui

    export records separately

    jlgonqui

      Title

      export records separately

      Post

      I have a data base with the following fields

      -name

      -category

      -address

      and so on

       

      I create a script where it found all the records from a specific category and now I want to export each row of data in different files, and each file label as the name field, thanks so much.

       

        • 1. Re: export records separately
          davidhead
            

          I don't know how much scripting experience you have but this can be done with a script. What you will need to do is something like this:

           

          Go to the first record

          Loop

            Open a new window

            Show all records

            Omit record

            Show omitted (this isolates the required record)

            Set a variable $file to the path required and ending in the required file name (using the name field) 

            Export (using $file as the file reference) 

            Close the window

            Go to the next record (exit after last)

          End Loop

           

          This is not actual code, just the required steps but it should get you on the right path. See how that goes for you. 

          • 2. Re: export records separately
            jlgonqui
               Thanks ery much. Yes I do have experience with scripting but is my first time with FM. This steps help me a lot. Thanks so much for your input.