Admin tools
Files and tools you can use with PeopleHR.
Backup data with the external Offline Backup ToolDownload data in bulk with the Offline Backup tool.
Upload documents in bulk with CSV file in the Advanced Document Loader toolUpload documents in bulk.
Upload documents in bulk with Document Loader toolLoad a number of documents from your computer into employee records.
Update existing employee records using the employee updater toolHow to make updates using the Employee Data Updater tool.
Holiday sync service with Exchange serverLink holidays to Exchange server.
Update salary with Salary Bulk Updater toolUpdate employee salary data using an Excel spreadsheet in CSV format.
Headcount turnover toolHow can I create a report on employee turnover.
Set up Holiday Sync Service with Office365 OAuthHow do I use Office365 OAuth with the Holiday Sync Service.
Holiday balance sheetHow can I get the outstanding holiday balance for my accounts team.
Load query data with Excel Power BIHow do I load query data into Microsoft Excel using Power BI.
Star P60 loaderUpload P60s from Star Payroll to PeopleHR.
Headcount tool Run-time Error '3709'When adding the API key to the tool it comes up with Microsoft visual Run time error 3709.
Salary Updater Tool error - 'Failed to update employee ID'The Salary Updater Tool is showing the error Failed to update employee ID.
Timesheet Uploader Tool error - 'Error praising path'I have tried using the external tool to upload timesheets but it is not working due to this error Error praising path.
Salary Bulk Updater tool Error: "This entitlement element is already present for current salary"Salary Bulk Updater tool returning Error: "This entitlement element is already present for current salary"
Hotsheets
Everything surrounding excel and Google hotsheets.
Set up Excel HotsheetsGive external people access to a report.
Grant a manager access to a holiday query for their direct reports.
Uploading hotsheets on a sharepointIs it possible to share hotsheet excel file on Sharepoint.
Change the format of cells on an Excel Hotsheets fileCan I change the format of cells in a Hotsheets file.
Excel hotsheets: Error: 'Excel cannot open the file because the file format or file extension is not valid'Error message 'Excel cannot open the file because the file format or file extension is not valid' is being presented.
Hotsheets - Error message 'Security Risk'Error message 'Security Risk'
Settings on Excel file not working and unable to use Hotsheets.
Hotsheet is showing incorrect dataLogbook data not showing correctly in hotsheets.
Hotsheets API error 'API calls will be limited to a 50 per minute'When I try to run the hotsheet I get an API error:
"API calls will be limited to a 50 per minute"
"Action": "QueryName"
Hotsheet error - 'Invalid query name'Error when adding query to the hotsheet.
Excel error - 'Cannot run the macro.'Why am I getting the error message 'Cannot run the macro. The macro may not be available in this workbook or all macros may be disabled.'?
Hotsheet error - 'JSON Parsing Error: 13 Type Mismatch'Error message: JSON Parsing Error: 13 Type Mismatch.
We get an error message when running the Hotsheet excel spreadsheet.
Mail Merge
Integrated Mail Merge Word with PeopleHR.
Use mail merge in Microsoft WordHow to merge documents and upload them to employee records.
Errors when running the Mail Merge in Word toolSorry, we couldn't find your file. Was it moved, renamed, or deleted.
Merge tag not available on the Mail Merge Word toolWithin the mail merge fields, there is no option to pull through the upcoming salary and future salary effective date.
Mail merge error - 'Access Denied'Mail merge coming up with error message.
Get the comma to show for salary in mail merge in WordWhy doesn't the comma show in mail merge.
Microsoft mail merge error - 'Microsoft has blocked macros from running because the source of this file is untrusted'I'm getting this error on mail merge - 'Microsoft has blocked macros from running because the source of this file is untrusted'.