• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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:

[code]
[/code]

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

[code] 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 [/code]

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

[code] ACME Manager
[/code]

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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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/