Uploading / Updating / En Masse Changes to Employees/Contractors

vSure offers the ability to upload Visa Holders en masse from Excel/CSV.

You can start with the existing data in vSure

See this article for how to export existing data to Excel in the same format as the upload.

This means you can:

• Move Prospective Employees/Contractors to Current and/or Previous status/tabs;
• Easily move terminated employees en masse from Current to Previous status;
• Update/Add data to fields such as Employee ID, Start Date, Cease Date, Location, Group from an Excel upload;

OR

Download MS Excel Template

You can download the MS Excel template by going to:

1. Visa Holders tab;
2. Current Visa Holders sub-tab;
3. Clicking the down arrow next to Add New;
4. Select Import Excel Data;
5. Then click the "Import Sheet" hyperlink in the Step "1. Download the Import Sheet"

With the data in Excel/CSV you can then upload into vSure

There are 3 Upload Options

You then have 3 choices for uploading:

Default Import

The upload will add from the import, any uniquely new Visa Holders, only. It will reject any duplicates.

Update duplicate visa holders

The upload will add from the import, any uniquely new Visa Holders;

AND will update any existing visa holders where details such as location, group, DOB etc may have changed.

Full import of all staff

The upload will add from the import, any uniquely new Visa Holders;

AND will update any existing visa holders where details such as location, group, DOB etc may have changed;

AND will move to the Previous sub-tab, any Visa Holders that are missing from the upload;

AND will move back to the Current sub-tab, any Visa Holders present in the upload, that already exist as a Previous Employee.