Prerequirement:
Have Manager use use Synopsys ServiceNow to request permission to Synopsys Citrix link (Synopsys | CTXSTORE) virtual machine "cdcw11exton02".
Username: jams2docebo
Password: B8ajt73j2Gz64K1
Full Path: jams2docebo@dcuwsftp-dmz.ansys.com
Go to filepath /home/jams2docebo/outbound
1. In AGI Salesforce run the All Active ALH Users - Reduced | Salesforce report
Q: How do I know when to move the ALH AGI file?
A: In AGI SF under Reports > Open the "All Active ALH User report > Upper right do Edit > Subscribe > Choose time to receive notification email.
2. Export the Report
- Details Only
- Format = CSV
- Encoding = Unicode UTF 8
3. Open exported file in Excel and make these edits
-
Edit first row to appear as follows
|
EmailAddress
|
FirstName
|
LastName
|
CustomerGroup
|
ExpirationDate
|
-
Change formatting for Column E (Expiration Date) to be mm/dd/yyyy
- Select Cell E2 then do CTRL SHIFT down arrow and change all the values in that column.
- In Number section Format the cells
- Category = Custom
- Type = mm/dd/yyyy
- Click OK
- Save (if prompted classify doc as 'ANSYS internal all')
- Close Excel
- NOTE: If need to check/inspect file don't do so in Excel as it reverts the date, use text editor instead.
4. Rename to "AGI_ALH_customer_users.csv".
5. Move "AGI_ALH_customer_users.csv" file from your saved location to AGI Support Team > Shared> on Synopsys teams using the Upload option. When prompted accept and replace the existing file by the same name.
6. On Synopsys Chrome profile go to the Synopsys Citrix link (Synopsys | CTXSTORE) virtual machine "cdcw11exton02"
Text version of the link above is https://access-cdc.synopsys.com/logon/LogonPoint/tmindex.html
7. Launch WINSCP from Desktop shortcut or from Windows search. Go to "jams2docebo" WinSCP shortcut. After first time the Login info is saved, but if not,
Username: jams2docebo
Password: B8ajt73j2Gz64K1
Full Path: jams2docebo@dcuwsftp-dmz.ansys.com
Go to filepath /home/jams2docebo/outbound where you'll see the existing copy of "AGI_ALH_customer_users.csv".
8. On the same "cdcw11exton02" VM computer bring up Synopsys Teams and go to AGI Support Team > Shared folder then download "AGI_ALH_customer_users.csv" to any folder like downloads or desktop.
9. Move "AGI_ALH_customer_users.csv" you downloaded into its final destination in WINSCP /home/jams2docebo/outbound folder using drag and drop or upload option. When prompted to overwrite existing file say yes and the process is complete.
