Downloadable Professional Body data file examples

The following links point to downloadable examples for Professional Body type data submissions.

1.  Example Professional Body Database (Microsoft Access)

A simple example of the possible data structures that can be implemented for a professional body level information system.
Example.ProfessionalBody.DB.zip

Data tables:  

Data35_Person Table that stores data relating to the person
Data36_Person_Designation

Table that stores data relating to the person’s designation

Lookup tables: 

All tables that have a prefix “Lookup_” are lookup tables used by each of the data tables. Lookup tables that will need to be maintained on a regular basis are 

Lookup_Designation

Export Examples: 

Note that these exports do not include the implementation of the header record for each file:

File35 Person information

  1. Go to the Queries desktop, right click on the EduDex_File35Extract query, select Export and then Text file.
  2. Enter a valid name for the person file (see file specification for naming standard) and click on Ok. Do not make the extension for the file .dat at this stage (this would generate a MS Access error), leave the extension as .txt.
  3. On the Export Text Wizard screen select the Advanced button, on the Export Specification screen select the Specs… button, select the EduDex_File35Extract Export Specification and click on the Open button – this takes you back to the Export Specification screen.
  4. Click on the OK button – this takes you back to the Export Text Wizard screen.
  5. Click on Finish and the Close.
  6. Remember to change the file extension from .txt (see item 2 above) to .dat before submitting the file to Edu.Dex for data validation.

File36 Person designation information

  1. Go to the Queries desktop, right click on the EduDex_File36Extract query, select Export.
  2. Enter a valid name for the designation file (see file specification for naming standard) and click on Ok. Do not make the extension for the file .dat at this stage (this would generate a MS Access error), leave the extension as .txt.
  3. On the Export Text Wizard screen select the Advanced button, on the Export Specification screen select the Specs… button, select the EduDex_File36Extract Export Specification and click on the Open button – this takes you back to the Export Specification screen.
  4. Click on the OK button – this takes you back to the Export Text Wizard screen.
  5. Click on Finish and the Close.
  6. Remember to change the file extension from .txt (see item b above) to .dat before submitting the file to Edu.Dex for data validation.

  

2.  Example Professional Body Excel File (Microsoft Excel)

Simple example of what the Edu.Dex data looks like in MS Excel (Example data used is dummy data with Professional Body type lookup codes).
Example.ProfessionalBody.Files.zip

Export Examples: 

Note that these exports do not include the implementation of the header record for each file:

File35 Person Information

  1. Go to the File35 worksheet.
  2. Select View, Macros, View Macros, select the ExportFile35 macro and click on Run.
  3. The file will be exported to your “My Documents” directory as File35Export.txt.

File36 Person designation Information

  1. Go to the File36 worksheet.
  2. Select View, Macros, View Macros, select the ExportFile36 macro and click on Run.
  3. The file will be exported to your “My Documents” directory as File36Export.txt
× How can we help you? Available from 08:00 to 17:00