How to Export a Registration List in LMS for HM Batch Upload

How to Export a Registration List in LMS for HM Batch Upload

Log into the Learning Portal
 
6.1.png
 
 
 
 
 
 
Click the tool icon below
 
6.2.png
 
 
On the left hand side scroll down and click "Reports"
 
 
6.3.png
 
 
 
Select "HHS Custom Reports" for category and click the search button
 
6.4.png
 
 
 
Scroll down until you see "HHS Course Compliance/Exception Report by Organization"
 
6.5.png
 
 
 
 
 
Hover your mouse over “Actions” and then click the “Execute” link.
6.6.png
 
 
 
 
On this page, search for course title to populate title field.
From Date: should be any date before the course began or start date of course.
To Date: should be current day
Oganization ID is DKKN% if you are returning results for CDER. If you want results for all of FDA it would be D%.
Person status: All accounts
Report Type: Compliance
Click “Generate Report”
 
6.7.png
 
 
At this point your browser may or may not ask you to load unsafe scripts. If it does just click the link shown below to do so. This part is difficult to screen capture in its entirety so if you have questions please ask me.
 
6.8.png
 
 
 
Your report should load as shown below.
 
6.9.png
 
 
 
Click the export button at the top left of the page
 
6.10.png
 
 
 
A small export window will appear. From the drop down select “Microsoft Excel Data Only” as shown below. then click the export button.
 
6.11.png
 
 
 
This will load your report in excel format.
 
6.12.png