Activation Hub

• Click on “Refer Subscribe-HR.”
• In the lightbox there is a table (which will hold all the referrals you make).
• Click “New Referral.”
• Complete the following information for the referral (all of which are mandatory):
  • Company Name.
  • First Name.
  • Last Name.
  • Email Address.

The Referee will the receive a series of emails from “Subscribe-HR,” including:

Follow these steps to quickly, easily and accurately do bulk data uploads to set up your Free Trial or official Customer Account. Users MUST complete these steps in the order specified below or the process will not work.

1. Format and export the “Export Template – Support Data spreadsheet.”
2. Add data to each of the Support Data spreadsheets (see below for further explanation) and upload the spreadsheet via the “Upload Template – Support Data step.”
3. Format and export the “Export Template – Employee Data spreadsheet.”
4. Add data to each of the Support Data spreadsheets (see below for further explanation) and upload the spreadsheet via the “Upload Template – Employee Data.”

Outlined in this section is the format and export the “Export Template – Support Data” step. For the remaining steps, see the relevant section below.

To format the Support Data spreadsheet, click on “Export Template (Support Data)” and specify the following information:

• Select the Template type you want to create/export from the dropdown list.
• Search the available fields to find the ones you want to upload data for.
• Drag each field from the table on the left to the table on the right (you can reorder these fields too – to do so simply drag the fields up and down to reorder them).
• Once complete, click “Export.”

Users will need to create and export a formatted spreadsheet for each of the following 'Support' data types:

• Locations.
• Jobs.
• Company Property.
• Leave Settings.

These completed spreadsheets will then need to be uploaded into the System in the next step: Upload Template – Support Data.

If you do not format, fill and upload data for ALL FOUR support data types BEFORE uploading Employee data, the process WILL NOT work.

NOTE: The Excel file that is created by the Export Template tool is formatted to appear with specific columns, column headings and formulas embedded into the spreadsheet to validate data before it is imported back into the System/User Account. Mandatory System fields will be highlighted in red in the spreadsheet. DO NOT change the content, format or formulas on any of the tabs in this spreadsheet as this may prevent the data from being accurately uploaded into the System by the Upload Template tool. Also, the columns in the spreadsheet have been formatted to force Users to input the correct data type (e.g. numbers in number fields, text in text fields, or make a selection from dropdown lists). If you do not input the correct type of data in the right field, the spreadsheet will not validate upon upload back in the Subscribe-HR System and the upload process will fail. However, there is an inbuilt data validation process during upload and the Subscribe-HR System will flag and give you the opportunity to correct any/all errors during the upload/validation process.

To upload the Support Data spreadsheet, click on “Upload Template (Support Data)” and specify the type of data you want to import from the dropdown list:

• Locations.
• Jobs.
• Company Property.
• Leave Settings.
• Select the relevant/appropriate file to upload.
• Click on “Preview.” Preview runs a validation process on the spreadsheet. If you have selected the incorrect spreadsheet/file to go with the relevant/associated data type, or if there are other validation issues then you will receive an error message.

If the data in the spreadsheet is formatted and input in the correct way, then you will be shown a validation table. This validation table highlights any remaining issues with the data and allows you to correct them.

In the top row of the table you will see a list of colour coded fields and data types and a calculation of the number of errors (if any) for that data/field type. If there is an error you can click on the name of the error type (e.g. mandatory field, email address) and this will show only/all the rows in the spreadsheet that contain that validation error type. You can then click on ‘Clear Filter’ next to the name of the error type to clear those rows and return to an "all rows" view.

Validation error types are colour coded in the following manner:

• Boolean values: purple.
• Date format: orange.
• Numeric value: blue.
• Email address: pink.
• Lookup Row: brown.
• Mandatory field: green.

In the table below the top validation errors row, you will see all the data (columns and rows) being imported into the System. Any validation errors will appear in the colour related to the type of validation error listed above. To edit/fix data issues, click on the green “Edit’ button for the row in which the error occurs, then once you've corrected the cell with the error in it, click the Orange ‘Review’ button to check and complete. Or click directly into the cell with the error and resolve it that way. Users can also ‘Delete’ data rows by click on ‘Delete.’

When all data is correct and has been validated, you will see an orange bar across the top of the table to indicate that your data is ready to Upload. Click “Upload Now” to upload data.

Follow these steps to quickly, easily and accurately do bulk data uploads to set up your Free Trial or official Customer Account. Users MUST complete these steps in the order specified below or the process will not work.

To format the Employee Data spreadsheet, click on “Export Template (Employee Data)” and specify the following information:

• Select the Template type you want to create/export from the dropdown list.
• Search the available fields to find the ones you want to upload data for.
• Drag each field from the table on the left to the table on the right (you can reorder these fields too – to do so simply drag the fields up and down to reorder them).
• Once complete, click “Export.”

Outlined in this section is the Format and export the “Export Template – Employee Data” step. For the remaining steps, see relevant section below.

To format the Employee Data spreadsheet, click on “Export Template (Employee Data)” and specify the following information:

• Select the Template type you want to create/export from the dropdown list.
• Search the available fields to find the ones you want to upload data for.
• Drag each field from the table on the left to the table on the right (you can reorder these fields too – to do so simply drag the fields up and down to reorder them).
• Once complete, click “Export.”

Users will need to create and export a formatted spreadsheet for each of the following data types:

• Employee.
• Employee Address.
• Employee next of kin.
• Employee bank details.
• Employee jobs.
• Employee working hours.
• Employee leave profiles.
• Employee salary.
• Employee training records.
• Employee incident.

These completed spreadsheets will then need to be uploaded into the System in the next step: Upload Template – Employee Data.

Users will need to format, create, fill and upload data for ALL of the Employee data you want to bulk upload in your Free Trial/Customer System.

NOTE: The Excel file that is created by the Export Template tool is formatted to appear with specific columns, column headings and formulas embedded into the spreadsheet to validate data before it is imported back into the System/User Account. Mandatory System fields will be highlighted in red in the spreadsheet. DO NOT change the content, format or formulas on any of the tabs in this spreadsheet as this may prevent the data from being accurately uploaded into the System by the Upload Template tool. Also, the columns in the spreadsheet have been formatted to force Users to input the correct data type (e.g. numbers in number fields, text in text fields, or make a selection from dropdown lists). If you do not input the correct type of data in the right field, the spreadsheet will not validate upon upload back in the Subscribe-HR System and the upload process will fail. However, there is an inbuilt data validation process during upload and the Subscribe-HR System will flag and give you the opportunity to correct any/all errors during the upload/validation process. </tr>

To upload the Employee Data spreadsheet, click on “Upload Template (Employee Data)” and specify the type of data you want to import from the dropdown list:

• Employee.
• Employee Address.
• Employee next of kin.
• Employee bank details.
• Employee jobs.
• Employee working hours.
• Employee leave profiles.
• Employee salary.
• Employee training records.
• Employee incident.
• Select the relevant/appropriate file to upload.
• Click on “Preview.” Preview runs a validation process on the spreadsheet. If you have selected the incorrect spreadsheet/file to go with the relevant/associated data type, or if there are other validation issues then you will receive an error message.

If the data in the spreadsheet is formatted and input in the correct way, then you will be shown a validation table. This validation table highlights any remaining issues with the data and allows you to correct them.

In the top row of the table you will see a list of colour coded fields and data types and a calculation of the number of errors (if any) for that data/field type. If there is an error you can click on the name of the error type (e.g. mandatory field, email address) and this will show only/all the rows in the spreadsheet that contain that validation error type. You can then click on ‘Clear Filter’ next to the name of the error type to clear those rows and return to an all rows view.

Validation error types are also colour coded using the colours:

• Boolean values: purple.
• Date format: orange.
• Numeric value: blue.
• Email address: pink.
• Lookup Row: brown.
• Mandatory field: green.

In the table below the top validation errors row, you will see all the table (columns and rows) of data being imported into the System. Any validation errors will appear in the colour related to the type of validation error listed above. To edit/fix data issues, click on the green “Edit’ button for the row in which the error occurs, then click the Orange ‘Review’ button to check and complete. Or click directly into the cell with error and resolve it. Users can also ‘Delete’ data rows by click on ‘Delete.’

When all data is correct and has been validated, you will see an orange bar across the top of the table to indicate that your data is ready to Upload. Click “Upload Now” to upload data.