If you have several attendees to report to the CE Registry, we recommend uploading the information in a spreadsheet. You can report one to 500 entries at once. More than one course can also be reported within the same spreadsheet.
First an attendance upload spreadsheet, saved as a .csv file, will need to be created in a specific format, which you can download by clicking Download Template in the lower right hand corner of the Upload Program Attendance Page.
The headers are as follows:
Program Approval Code
|
Completion Date
|
Participant Hours Earned
|
NAB Id
|
First Name
|
Last Name
|
Sessions Attended
|
Some items to remember when using the upload attendance spreadsheet:
- In column 4, NAB ID, you can also use a person’s email address or primary state license number, if you do not have their NAB ID. This must be the email address or primary state license number the individual has used to create their NAB ID. If you use a license number, the format will need to be the state abbreviation-license number (i.e. NJ-12345)
- The date format needs to be MM/DD/YYYY.
- The last column, Sessions Attended, can be left blank, but the header needs to be present.
Once you have completed the upload attendance spreadsheet within Excel, please Save As a .CSV (Comma delimited) file.
Next, you will need to log into https://www.nabweb.org/ and click on Member Login at the top right of the page. Please enter your credentials to access the website.
Once you have signed in, please click on the NCERS Homepage/ Third Party Certification Programs link on the Mange My Account page.
While on the NCERS Homepage, please click on Sponsor, below the NAB logo, and then select Attendance.
To upload attedance from a spreadsheet, while on the Program Attendance page, please click on Upload Attendance.
Once the file is saved as a .CSV file, it can be uploaded. Please click on “Choose File” on the Upload Program Attendance page and browse to find the attendance file to be uploaded, then click Open. The Provider field will be completed with your sponsor name.
After the attendance file has been selected from your computer, please click Process File.
If you receive any alerts, the row number will be included for investigation of the issue.
Some common alerts include:
Completion Date [MM/DD/YYYY] must be greater than or equal to the Start Date [MM/DD/YYYY] associated with the Activity.
This means that the date of the course is incorrect for the approval code you have used.
Verify that the year is formatted as a four digit number, i.e. 2018.
Please confirm that the program approval code dates are correct for the completion date you are entering.
If the program ran over the course of several days, please use the last day of the course as the completion date.
- First Name [JIM] doesn't match the name on file [JAMES].
Please change the name in your file accordingly.
This can also happen for a person’s last name. If need be, please consult your attendance sheet to verify you have the correct person.
- NAB ID [RXXXXXXX] was not found.
This means there could be an error in the NAB ID. You can always look up the administrator and verify their NAB ID.
Some common mistakes include a space between the R & the number or at the end of the number.
The NAB ID could be too short. It should be an R, followed by 7 digits.
Lines that have an error can be cut and saved to a different spreadsheet to be corrected later. Those lines that are acceptable can then be uploaded. Once issues are fixed with the problem lines, they too can be uploaded. Course attendance does not need to be uploaded all at the same time.