49

Robotic proces automation excel to desktop application

UpworkNLNot specifiedexpert
PythonRobotic Process Automation
Here is the professional English version of the inquiry, optimized for international freelancers on platforms like Upwork or for specialized IT agencies. Subject: Inquiry: Python Automation (RPA) – Data Entry for Legacy Desktop Application Dear [Freelancer Name], I am looking for a developer to build a Python script (or a robust RPA solution) to automate the daily entry of shifts into our planning software, Service Cruiser. The Challenge: We attempted to automate this process using Power Automate Desktop, but the Service Cruiser interface proved "invisible" to standard UI Automation frameworks (UI elements and selectors are not recognized). This caused the bot to fail when trying to identify buttons and text fields. There is no API or bulk import function available. The Process (Step-by-Step): The script needs to read an Excel file (.xlsx) and execute the following steps for each row within the desktop application: Navigation: Open the 'Capacity Management' module. Search: Enter the technician's name from the Excel file into the 'Full Text Search' field. Identification: Locate the correct row in the table (the application typically highlights the matching row in yellow after the search). Selection: Click the checkbox corresponding to that specific technician. Initiation: Click the 'Create Shifts/Absences' button. Data Entry: In the resulting pop-up window, enter the 'Start Time' and 'End Time' from the Excel file and save the entry. Required Solution: Due to the limitations of standard UI tools, I am looking for a solution based on Python (e.g., using PyAutoGUI, OpenCV, or a similar image-recognition library). The script should: Use image recognition or smart keyboard navigation to interact with the interface. Be resilient to window position shifts (resolution-independent where possible). Include error handling (e.g., logging if a technician is not found within the list of 200+ names). Available Material: I have screenshots of all relevant screens, the Excel structure, and logs of the errors encountered during our initial automation attempts. Could you please provide an estimate of the turnaround time and a fixed-price quote for developing a working script? I look forward to your proposal. Best regards,
View Original Listing
Unlock AI intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/mo

Client

Spent: $14,524.41Rating: 5.0Verified