Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Command line to add Users and Tasks in IPA?

 6 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Thibaud Lopez Schneider
Advanced Member
Posts: 30
Advanced Member
9/2/2016 3:18 AM

    Hello,

     

    How can I programmatically add Users, Tasks, and User-Tasks to a specified data area (e.g. DEV, TST) in Infor Process Automation (IPA)? That's PFIUSERPROFILE, PFITASK, and PFIUSERTASK in the IPA database.

     

    I need to synchronize M3 Users (MNS150), M3 Roles (MNS405), M3 User-Roles (MNS410), and M3 Email addresses (CRS111) with their counterparts in IPA. That's for Infor Smart Office users to take action in the Inbasket for approval flows.

     

    With the command secadm.bat I can create the Identities, Actors, Email addresses, Identity-Actors, and Actor-Roles in the gen data area. Now I am missing the Users, Tasks, and User-Tasks in the other data areas. I am aware I can use a Landmark activity node in a process flow, but I am looking for a direct programmatic means such as a command line or a Java class.

     

    Thank you,

     

    Thibaud Lopez Schneider

    https://m3ideas.org/

    Thibaud Lopez Schneider
    Advanced Member
    Posts: 30
    Advanced Member
    9/2/2016 5:46 AM
      I found the documentation Infor Landmark Technology Installation Guides / Infor Lawson System Foundation Using Infor Process Automation Configuration Guide / Post-Installation Procedures / Run migration scripts, at https://lawson-lsaprod.hm...L27302068284309.html

      I found the class bpm-commons.jar/com.lawson.bpm.classic.ImportClassicConfiguration

      So I created this XML file to import a test Task:


      And I ran this command, but it doesn't do anything (0 changed): 

      
D:\Infor\LMTST\env\bin>importPFIdata.bat lmdevipa -f Test.xml
>> upload: lmdevipa | com.lawson.bpm.binding.classic.data.ImpExpData@61ee4296 | true
User : domain\lawson, LongName Lawson Landmark Account
Service factory: com.lawson.webservs.service.ServiceLocalFactory created
*************************************************

#> Table: WFTASK
   Added: 0   Changed: 0   Skipped: 0   Exceptions: 0


      Any ideas?
      Thibaud Lopez Schneider
      Advanced Member
      Posts: 30
      Advanced Member
      9/2/2016 6:01 AM
        I had read the JAXB incorrectly. This is the correct XML: 

        


  
    
        
          ACME Manager


        IT WORKED!!! It added the task to the data area.

        Read the class ImportClassicConfiguration for more table names and column names (User, Task, User-Task, etc.)
        Thibaud Lopez Schneider
        Advanced Member
        Posts: 30
        Advanced Member
        9/2/2016 6:07 AM
          Table names and columns for Users, Tasks, and User-Tasks:

          WFUSRPROFL (WF-RM-ID, FILTER-CATEGORY, FILTER-CATGORY)
          WFTASK (TASK, WF-DESCRIPTION)
          WFUSERTASK (WF-RM-ID, TASK, START-DATE, STOP-DATE, FILTER-CATEGORY, FILTER-CATGORY, DISPLAY-ALL)
          JimY
          Veteran Member
          Posts: 510
          Veteran Member
          9/2/2016 9:29 AM
            Couldn't you have used the Landmark Transaction Node to do the same?
            Thibaud Lopez Schneider
            Advanced Member
            Posts: 30
            Advanced Member
            9/2/2016 5:01 PM

              JimY, see above, " I am aware I can use a Landmark activity node in a process flow, but I am looking for a direct programmatic means such as a command line or a Java class."

              Thibaud Lopez Schneider
              Advanced Member
              Posts: 30
              Advanced Member
              9/12/2016 8:09 PM
                For more details of the importPFIdata command, see https://m3ideas.org/2016/...n-m3-and-ipa-part-2/