Prev
Next
Forums Integration / Customization IPA/ProcessFlow

FileAccess passing data

 8 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
nlmoran
Veteran Member
Posts: 53
Veteran Member
4/1/2008 6:55 PM

    I am pulling data  from Resource Module  that's working file I have connected to File Access module

    I assume I need another Parameter in the Input data BOX on the File Access Properties.  I have been able to key into and write a file.

    I want to pass Data from my resource extract.  I have been to 8.0 class but no 9.0 I have tried to find this in manuals .  

    .

     

     

    John Henley
    Posts: 3353
    4/1/2008 7:34 PM
      That is actually a bug in the ProcessFlow Designer (which I reported over a year ago and which is STILL not fixed!). You just have to know what the output variables from the ResourceQuery are named, and enter that manually into the INPUT of the subsequent node. For example, if I have a ResourceQuery called rsrcLookup, all of the ATTRIBUTES returned by the ResourceQuery will be prefixed 'rsrcLookup_', e.g., rsrcLookup_ID, rsrcLookup_DOMAIN_USER, etc.
      Thanks for using the LawsonGuru.com forums!
      John
      nlmoran
      Veteran Member
      Posts: 53
      Veteran Member
      4/2/2008 6:05 PM

        I am still missing something I entered query name followed by name from output query  IE

        rd30Q_ID

        that's what it will write to file rd30Q_ID  not thae actual id.

        Is there any other character's I need to include?

        John Henley
        Posts: 3353
        4/2/2008 6:36 PM

          You need to use the PF syntax:

          Thanks for using the LawsonGuru.com forums!
          John
          nlmoran
          Veteran Member
          Posts: 53
          Veteran Member
          4/2/2008 8:23 PM



            This is what I am using in the Input Properties of File Access
            nlmoran
            Veteran Member
            Posts: 53
            Veteran Member
            4/2/2008 8:31 PM
              Posted By Norm Moran on 4/02/2008 4:23 PM
              <!--30Q_EMPLOY-->
              <!--30Q_COMPA-->
              <!--30Q_-->
              This is what I am using in the Input Properties of File Access


               

              John Henley
              Posts: 3353
              4/3/2008 12:20 PM

                Here's one I just did, which works:

                Attachments
                Thanks for using the LawsonGuru.com forums!
                John
                nlmoran
                Veteran Member
                Posts: 53
                Veteran Member
                4/3/2008 4:54 PM
                  Thanks
                  Interesting:
                  I was using Write to File vs Append to File and was I keying name's directly into input data (syntax correct)
                  that does not work.
                  John Henley
                  Posts: 3353
                  4/3/2008 5:42 PM
                    "Write To File" should work fine as well, although it will only write one line...
                    Thanks for using the LawsonGuru.com forums!
                    John