Exporting Certificate data

As an RTO, you may be required to provide reports of the certificates you have issued to your VET Regulator. In Western Australia, a defined format for providing this information existing in a format called the Client Qualifications Register (CQR).

In other states and territories, there is no set defined format, outside the AVETMISS data reporting of the NAT00130 file.

onCourse contains both a CQR layout export CSV option for use in WA and a generic Certificate CSV export option for use in other jurisdictions. Both of these file formats can be opened in Excel, Numbers or other spreadsheet or text editing tool of your choice to view or edit.

To access these exports, first select the records in the certificate window you wish to export by either running an advanced search or by highlighting the records in the window. Then click the Share icon, select 'Excel', then select the CSV export and click Share.

The export will download the spreadsheet to your browser after running.

Figure 439. Exporting certificate registrar data in the CQR format