Reports from Accudemia + Informer 4
Login to Accudemia
Ship maintenance is a separate login:
https://maritime.accudemia.net/Private/Reports/ReportList.aspx
Go to Reports > Attendance by Student
Choose to include student IDs, CSV as format, and make sure the starting date is set to 2017 or earlier for all records
View the report, download and open the file in Excel.
Remove Rows 1-3.
6. Format Student2 to be 7-digit ID
7. Save as excel - Accudemia_05272021
8. Save as csv Accudemia_05272021
Open FileMaker Pro STCW Sea Time
Change the layout to Ship Maintenance
File >> Import Records >> File...
Find your file and choose to ADD. If you are going to do a full refresh then you would download a Full Report from Accudemia and perform a Replace
You are all set!