/
Agent Sync Implementation in FACTS

Agent Sync Implementation in FACTS

Task: https://davies-us.atlassian.net/browse/FCT-408

 

DB changes

  1. Added below columns to the USERS table
    a) NPN_TRACK BIT
    b) NPN_NUMBER

  2. Added below columns to LICENSE table.
    a) ISSUE_DATE
    b) IS_AGENT_SYNC

  3. Added below tables.
    a) LICENSE_AUDIT
    b) AGENT_SYNC_LOGGER
    c) AGENT_SYNC_SERVICE

  4. Added the trigger “tr_License_LicenseUpdate“: It will maintain the license updated history.

 

Web.Config changes- Added the below configuration in the web.config file

<add key="AgentSyncBaseURL" value="https://davies-agentsync--agentsync.sandbox.my.salesforce.com/"/>
<add key="AgentSyncUsername" value="cse-salesforce+davies@agentsync.io.agentsync"/>
<add key="AgentSyncPassword" value="rYsPQg.Jdge3T2z7cLaIYl4fQunX8JNMg3koHAWS"/>
<add key="AgentSyncClientId" value="3MVG98dostKihXN4xzr7fn85NE0s7q0Z1l6prhFhbmOXUf6toRpWCVhiiv7OjljdUOaA2cXhEuZRg3OtU_ZgT"/>
<add key="AgentSyncClientSecret" value="8BDF8D846A6BB4C2A958E4E349C9C4B4679E2B20455DBF8A8A5915C7FB8497FE"/>
<add key="AgentSyncAccountId" value="0014S00000A4CsQQAV"/>

 

Notes: We don’t need to put the username and password for the production box.


Background Service

Name/Solution Name: AgentSync

Azure Repository URL: https://daviesgroup.visualstudio.com/Davies.Frontier/_git/AgentSync




UI changes

  1. Added the “License Information” tab on the user edit page.

 

  1. Added the below
    a) “NPN Track“ next to the licenses
    b) Added the “Issue date” and “Updated By” column in the grid


3. When a will update the license and Track NPN “Yes“. a view button will be visible in the updated history column. when a user will click on it a popup of license history will be displayed.

  1. There will be a background service, it is run by task scheduler, that will sync the license from agent sync to DB of those users whose NPM track is checked “YES“. for that service there will be a report UI that indicates when the service has run and how many licenses has been update for that job.


    Link button to redirect to the agent sync job details

     

  2.  

    Job details(background service details)


  3. When a user will click on any job

     

 

Add label