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
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
    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
      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.