• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Script from S3 using IPA

 2 Replies
 1 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
3/4/2015 1:32 PM
We're currently in the process of implementing Certpoint, and need to be able to create a daily file to upload to the Certpoint site.

ssoconfig is used to perform the creation of the .csv file that we will then use IPA to SFTP the file to the site.

Here are the manual steps to create the file:

To export employees using the custom script:
1.) Go to ssoconfig
2.) Choose User Provisioning
3.) Choose Employees Export using custom xml file
4.) DataArea = PROD
5.) Agent Name = PROD_EMPLOYEE
6.) Custom XML file for export = E:\certpoint\custom_scripts\Employees_custom.xml
7.) File Name = filename in csv format

If this is possible, could you please instruct me on how to script this, either VBscript or .bat?
JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
3/16/2015 12:29 PM
Have you tried running the below from the command line? You should be able to script it if it works from the command line.

Exporting employees using the command-line
This command exports all employees through a single command.
•
Type:
ssoconfig –e YourPWD [all OR delta] YourDataArea YourDataArea_EmployeeAllEmployees OR UpdatedEmployees.csv
where
YourPWD is the password for ssoconfig at your site
all Or delta specifies whether you want to export all employee records or only updated. Type "all"for all employees or "delta" for updated.
YourDataArea is the data area that contains the employees
YourDataArea_Employee is the name of the agent
AllEmployees.csv OR UpdatedEmployees.csv is the output file for the exported records
JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
3/16/2015 12:37 PM
I got this from Infor Lawson AuthenticationConfiguration Guide--Windows. I have used IPA to execute bat files via the syscmd node. You have to have your main system configuration pointed to your LSF application server.