Jaggaer eProcurement Software

GitLab

• NSU_Enterprise > Jaggaer > jaggaer_invoice_feed

  • https://gitlab.nsuok.edu/NSU-Enterprise/jaggaer/jaggaer_invoice_feed

• NSU_Enterprise > Jaggaer > jaggaer_user_import

  • https://gitlab.nsuok.edu/NSU-Enterprise/jaggaer/jaggaer_user_import

Procedures

• PPRD & PROD

  • NSU_JAGGAER.NSU_JAGGAER_UPDATE_INVOICE_DELTA

  • NSU_JAGGAER.NSU_JAGGAER_UPDATE_USER_DELTA

Tables

• PPRD & PROD

  • NSU_JAGGAER.NSU_INVOICE_FEED_XML_DELTA

  • NSU_JAGGAER.NSU_USER_IMPORT_XML_DELTA

Argos

• Server: Unique (Test-MAPS) & Server: TQ-MAPS

  • Data Feeds.Jaggaer.Invoice Feed XML

  • Data Feeds.Jaggaer.User Import XML

  • Finance.Jaggaer.Department Feed

  • Finance.Jaggaer.Supplier Feed

Scripts

• MAPS.Pre-Production.TQP-MAPS01 & MAPS.Production.TQ-MAPS01

  • C:\Argos_Utils\Jaggaer\jaggaer_invoice_feed

    • app.py

    • argos_start_script.bat

    • EchoArgs.exe

  • C:\Argos_Utils\Jaggaer\jaggaer_user_import

    • app.py

    • argos_start_script.bat

    • EchoArgs.exe

Import Process

User & Invoice Feed

• Every day at 3:00 AM the Argos Schedule runs Invoice Feed XML and User Import XML datablocks.
• The query for each is ran against the corresponding Delta Table, to ensure we are only sending them new data.
• The XML is then sent to our Scripts on MAPS.Production.TQ-MAPS01.
• App.py will parse the XML to see if there is new data, if no new data is found then a message will be sent to the logs in the same folder and the process will stop.
• If new data is found then the DOCTYPE will be added and it will be sent through Jaggaer’s API. We get a response back from Jaggaer and parse it, the results are added to the logs as well as emailed to jaggaer_feed@groups.nsuok.edu.
• If the response was an error then the process will end.
• If the response was successful then the Delta Table will be updated through the corresponding Procedure.

Known Issues

• 201: Success but with an error. This usually happens when the user is uploaded to a department that isn’t active for us in Jaggaer. Austin will need to do a manual import of departments.
• 403 & 500: Errors with our authentication or the XML formatting. The Argos Datablocks and Scripts will need to be checked for the error.
• Other errors can be found at: https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10

Supplier & Department Feed

These reports are manually run by Austin as needed, he then uploads them to Jaggaer manually.

Lucid Chart Diagram  

https://lucid.app/lucidchart/6e99793c-d02e-471a-abfe-4636cbb88924/edit?beaconFlowId=7567AA89EBC98A4D&invitationId=inv_2769f475-e66e-4731-b7e2-a60b57d56b44&page=dQT0ABlkK2XS#