Special Pricing for Desktop Package Solution. Learn more.

How to import employee’s health check information (and other data) into the Employee Log Sheet.

See Using the Health Check Extra for child records.

Summary

You’ll export a template in .CSV format from Procare Select containing employees only, add in your health check information, then use the Health Check utility (known as a Procare “Extra”) to bring the information for the day/week back into Procare Select.

Each time you run the Extra and import the file into Procare, the information will be added to the employee’s log notes as one entry for the date of the import. If an employee is listed multiple times (on multiple rows) they will have multiple entries added to their log.

Before You Begin

  • You must have spreadsheet software (like Excel) or other software that can open and save files in .CSV format.
  • You must have Procare Desktop version 2020.2 or higher installed.
  • You may want to create a Employee Log Sheet Type specifically for the information you will import, such as a type named “Employee Health Check”.

Download the Health Check “Extra”

  1. Log on to your computer with local administrator privileges and close all programs, including Procare Select.
  2. Download
  3. When the download is complete, double click on the exe file.
  4. Once the installation is complete, restart Procare.
  5. The Extra will now be available under Procare Home > Utilities> Extras.

Getting There

From the Procare Home screen go to Utilities > Procare Extras > Health Check Import.

Using Procare’s Health Check Extra

  1. Go to Reports> Data Viewer> Employee Data> Employee Contact Information.
  2. Click on the Employee Contact Information view.
  3. Click Create.
  4. Important! Drag the column labelled Employee ID over to the first column if it is not already the first column (this identifies the employee and MUST be the first column when you import) so that it looks like this:
  5. Next to that column, you may want the employee’s first name, last name, DOB and Primary Work Area for easy identification later.
  6. Optional: Click the column header of employee last name, which will sort the table by last name.
  7. Optional: Other than the Employee ID, you can now deselect the fields you don’t want by using the Choose Fields button
  8. When you have completed selecting the existing fields you want to see in your spreadsheet, you can save your work by entering a Title and clicking Save. That way you will be able to reuse the Data View you have created without starting from scratch each time.
    Note: You will add additional columns for health check information you wish to track when you open the file in your spreadsheet application.
  9. Click Export.
  10. Select Save as type as .CSV. Then name the file something EmployeeHealthCheck05102021 (MMDDYYYY) and save it to your desktop or preferred location.
  11. Open the file using your spreadsheet software (Excel recommended).
  12. Add any additional columns where you will enter the daily/weekly information. Below is a sample of answers to two questions (y,y for yes, yes) and a temperature (98, etc.) with columns for each day of the week. The columns and answers you create can be anything you would like.
  13. At the end of the day or week (depending on how often you import the file back into Procare Select) enter the health check information in the fields you created.
  14. Save the file. Note: Since you opened the file in .CSV format, saving it should preserve the .CSV format. If you accidentally save it in Excel format, be sure to export it (or Save As) to .CSV format.
  15. When you are ready to import the data into Procare, right-click on the file you just saved, and rename the extension from .CSV to .HCEF (health check extra format).
  16. From the Procare Home screen go to Utilities > Procare Extras > Health Check Import.
  17. Browse to the location where you saved the .HCEF file.
  18. Select the log file name you want the records to be in, and select import.
  19. The data will be in each employee’s log file.