Use this wizard to import data directly into staff person records or contract records from a comma-separated values (CSV) format text file. By doing this, you can save yourself a lot of time that you would otherwise spend typing data that already exists in spreadsheet format.
The first row of the CSV file must contain column headings for the data that are the ones used by HESA from their own coding manuals. If the import is to update the person record, there must be a column that contains the employee reference. If the import is to update the contract record, there must also be a column that contains the contract identifier.
For example:
Resource_id, contract_id, TERMS, HEIJOINT,STARTCON
001,01001,1,0024,01/10/2007
002,01002,1,0023,01/10/2007
003,01004,2,0002,01/10/2007
004,01005,1,0102,01/10/2007
005,01006,1,0026,01/10/2007
The data, as it appears in the CSV file, is imported to the appropriate person or contract record. Note that any existing field information is overwritten by the imported values. Unlike when you use the data flood tool, there is no mapping of codes.
File Location & Name
Type the path and filename of the CSV file, or click …, browse to the location, and select the file.
Click Next. Page 2 of the wizard is displayed.
Person or Contract
Select the type of record to update, either Person or Contract.
Click Next. Page 3 of the wizard is displayed.
Employee Reference
Select the column heading of the column that contains the employee references. This reference is used to find the correct staff person record to update. In the above example, the employee reference column heading is resource_id.
If you select Contract on page 2, click Next. Page 4 is displayed.
Contract Reference
Select the column heading of the column that contains the contract references. This reference is used to find the correct staff contract record to update. In the above example, the contract reference column heading is contract_id. This contract reference is required only when the import is to update the staff contract records, as defined on page 2 of the wizard.
Click Finish to run the import process.