Admin tools
Files and tools you can use with PeopleHR.
By Robert1 author30 articles
- 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"
- Star P60 loaderUpload P60s from Star Payroll to PeopleHR.
- Salary Updater Tool error - 'Failed to update employee ID'The Salary Updater Tool is showing the error Failed to update employee ID.
- Holiday balance sheetHow can I get the outstanding holiday balance for my accounts team.
- Headcount tool Run-time Error '3709'When adding the API key to the tool it comes up with Microsoft visual Run time error 3709.
- 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.
- Load query data with Excel Power BIHow do I load query data into Microsoft Excel using Power BI.
- Headcount turnover toolHow can I create a report on employee turnover.
- Set up Holiday Sync Service with OAuthSync PeopleHR holidays to Office 365 calendars using OAuth.
- Update salary with Salary Bulk Updater toolUpdate employee salary data using an Excel spreadsheet in CSV format.
- Update existing employee records using the employee updater toolHow to make updates using the Employee Data Updater tool.
- Backup data with the external Offline Backup ToolDownload data in bulk with the Offline Backup tool.
Hotsheets
Everything surrounding excel and Google hotsheets.
- Set up Excel HotsheetsLink live PeopleHR query data to an Excel spreadsheet that you can share securely.
- Change the format of cells on an Excel Hotsheets fileCan I change the format of cells in a Hotsheets file.
- Hotsheet error - 'Invalid query name'Error when adding query to the hotsheet.
- Hotsheets - Error message 'Security Risk'Error message 'Security Risk' Settings on Excel file not working and unable to use Hotsheets.
- 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 is showing incorrect dataLogbook data not showing correctly in hotsheets.
- 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 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"
- Uploading hotsheets on a sharepointIs it possible to share hotsheet excel file on Sharepoint.
- 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'.