Import Data Files

Importing WorkExpo data files from several different schools has the effect of combining the student, employer and arrangement records into a single file. Using this single consolidated file you could print multi-school reports and/or gather Work Placement information for detailed analysis across a range of schools.

Here are some things to be aware of when importing WorkExpo data files from other schools.

Before importing any school data file it's a very good idea to ensure that you have a good backup of your current data file.
The information you import from a particular school data file is only as good as has been entered into that file in the first place. For example, it duplicate records exist in the original then the consolidated database will also contain duplicates.
Only the student, employer, arrangement and school details records are imported. No lookup tables are imported, neither are any support tables containing information about visiting teacher lists, work experience type lists, supervisor lists, student tracking, student preferences, student counselling, exit details or user defined information.
When you import a school data file all student records imported with that data file are assigned as members of the imported school. Of course you can change this once the records are imported.
Once the records have been imported and you try to re-import the same data file again WorkExpo will warn you that the school's records have already been imported but will allow you to proceed if you choose. This of course will lead to several duplicate records including duplicate arrangement records.
You cannot un-import a data file.
It is recommended that if you are dealing with a large number of schools you create a schools folder under the WorkExpo data file folder. This will make working with the data file easier.
You can always create a new blank WorkExpo data file easily. Select File / New from the WorkExpo menu bar. This create a blank empty data file and links to it, then opens it. If sample records records are not required they can easily be deleted. Choose Delete Sample Records from the Tools / Utilities menu in WorkExpo.
You can generate statistical information showing trends across a range of schools. See generating statistical information
You can assign students as members of a particular school within WorkExpo. See assigning students to schools

You cannot import school data files which themselves contain multiple schools.

To learn more about	See
Adding, editing and deleting school records.	Adding Editing and Deleting School Records in WorkExpo
How to import data files into WorkExpo from several schools.	Importing data in WorkExpo Multi Schools Edition
Dealing with schools that do not support WorkExpo.	Working with non-WorkExpo schools
Working with the School data file and Multi-school projects.	Working with the School data file and Multi-school projects
Generating statistical information from multi-school sources.	Generating statistical information from multi-school sources