Opteamix is shape-shifting the business and IT landscape with RPA.

Opteamix is a digital automation technology consulting firm with deep expertise in Application Development, Robotic Process Automation, AI, DevOps, Enterprise Mobility, and Test Automation Services.

At Opteamix, we have deep expertise in both Robotics Automation Process and Artificial Intelligence solutions that enable organizations to build and maintain their digital workforce. 

We help you implement innovative solutions for your company, by leveraging our expertise in building the RPA Centre’s of Excellence (CoE) and our proprietary Process Assessment framework that puts you on the right track towards efficient processes automation.

513fb232-d216-4bad-a133-273fffaac59b.png

b64bddb4-98e6-498c-8d9a-8bd2f9f6fb63.jpg

RPA Solution Architect

12cbe484-6140-45c2-90b3-0d12b7e67f05.zip

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).

Reusable template for extracting employee ID, name, approver name, date, and total hours from weekly timesheet (PDF files) and consolidating monthly report.

22a2716b-8ede-4f71-bf74-14b0733dea99.PNG

4df8e9ef-5148-4502-b7ae-6b998270e159.PNG

d878180f-29e7-4f33-9ade-1e3d83ede6b2.PNG

89fb2acb-792d-4cbf-96e3-0d69b915113f.PNG

43e409fe-8913-4738-ba6b-4448b63459ef.PNG

d702c790-48cb-45a3-8c36-4409e57d8daa.PNG

6bb8af0b-71af-4496-bced-daba159127d4.PNG

2f66dca2-3e69-4c15-b7f9-87179cf5dcbf.PNG

dac0c2b6-da3f-4d27-aef1-bf147fde75b9.PNG

2bca67e1-68c0-46ac-a38e-42ac840da368.PNG

f8570c90-ae78-4824-b517-d7106d652461.PNG

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Visual Basic

c0ce8108-6250-4f15-b2ce-79f399f5cd99.docx

97a6dcce-1a01-4a28-920c-9f62084fe382.zip

fb529fcc-7c6b-4fa3-b9fa-766d49d1bfd4.nupkg

Conversion to .nupkg file for availability in Studio Template Feed

Version	Release Date	Download Link
1.1	Wed, 11 Aug 2021
Conversion to .nupkg file for availability in Studio Template Feed
1.0	Invalid date
First Release

Opteamix LLC - Timesheet Automation

Opteamix LLC - Timesheet Automation