MarketplaceListingsTemplateOpteamix LLC - Timesheet Automation

Opteamix LLC - Timesheet Automation

by Opteamix LLC

0

18

Opteamix LLC - Timesheet Automation

by Opteamix LLC

0

Template

18

carouselImage0

Summary

Summary


Overview

Overview

  • Extract employee ID and name from PDF files and store it in a variable.
  • Use the start process to open PDF files and extract table format data using Extract structure data activity.
  • Remove unwanted empty rows and keep only required data (in this example having project code and a total number of hours for the entire week).
  • Update the date into the respective weekly data table from the weekly folder structure.
  • Merge all the data tables and get unique employee ID and again join all the weekly data table (1,2,3,4,5) with unique ID table using join data table activity.
  • Now, all the data will be updated into the master data table and calculate all the weekly hours (if there is no weekly hours place ‘-’ in the blank cell).
  • Merge the duplicate item into one cell and format the report structure using simple VBA code (if required – optional).

Features

Features


Additional Information

Additional Information

Dependencies


Code Language

Visual Basic

Publisher

Opteamix LLC

Visit Publisher's Page

Trusted Source

License & Privacy

MIT

Privacy Terms

Technical

Version

1.1

Updated

11 Aug 2021

Certification

Silver Certified

Tags

attendance list
attendance record
attendance sheet
employee's daily record
hours of operation
hours of service
report card
sign in sheet
time card
time sheets
time study
timecard
Timesheet
week schedule
working timetable

Support

UiPath Community Support

Resources

Similar Listings