Python Selenium Script for GSCCCA

**Overview:** I need an experienced Python/Selenium developer to fix a nearly complete web automation script that searches the Georgia Superior Court Clerks' Cooperative Authority (GSCCCA) website for mechanic's/materialman's liens against properties. I have worked extensively with Claude AI to build this script over the past 24+ hours. The script is approximately 90% complete and functional. One specific issue remains that is preventing it from returning results. **What the Script Does:** 1. Reads a list of 757 properties from an Excel file (FMLS properties under contract) 2. For each property, searches the GSCCCA PT-61 Premium Address Search to identify the current owner's name 3. Takes that owner name and searches the GSCCCA Lien Index Name Search for "Mechanics and Materialmens Liens" filed between 01/01/2015 and today minus 395 days 4. If a lien is found that matches the property address and has not been cancelled, flags it as an INVESTIGATE opportunity 5. Outputs results to a CSV file **What's Working:** - PT-61 address search correctly finds owner names ✅ - Name parsing (Last, First format) correctly extracts names ✅ - Script navigates to the Lien Index Name Search page ✅ - Correct field names identified: txtSearchName, txtFromDate, txtToDate ✅ - Enter key submission navigates to liennames.asp correctly ✅ - Radio button selection and Display Details button click working ✅ - Reaches liennamesselected.asp correctly ✅ - Cancellation detection logic in place ✅ - Address verification logic in place ✅ - Session expiry detection in place ✅ **The Problem:** Despite the script completing all 757 properties with zero errors, it returns zero opportunities. We believe the issue is one or both of the following: 1. The Party Type dropdown (should be set to "Direct Party (Debtor)") and/or the Instrument Type dropdown (should be set to "Mechanics and Materialmens Lien") are not being set correctly before the search is submitted. The field names tried include SearchType, InstrumentType, and others — but the actual field names on the page may differ. 2. The lien detail parsing on the final page (lienfinal.asp) may not be extracting the correct date filed, amount, or claimant information. We have confirmed manually that searching LAST, FIRST format with Direct Party (Debtor) and Mechanics and Materialmens Lien selected DOES return results for known test cases. **What I Need:** - Inspect the actual GSCCCA Lien Index page in a live browser session to identify the exact field names for the Party Type and Instrument Type dropdowns - Fix the dropdown selection code - Verify the lien detail parsing is reading the correct date, amount, and claimant - Confirm end-to-end the script finds at least one known test case lien correctly - The script should run cleanly on all 757 properties and correctly identify mechanic's liens that are 395+ days old with no cancellation recorded **Tech Stack:** - Python 3.14 - Selenium with ChromeDriver (webdriver-manager) - pandas, openpyxl **Deliverable:** A working Python script that correctly searches the GSCCCA Lien Index and returns real mechanic's/materialman's lien opportunities. **Budget:** Open to discussion — estimated 2-4 hours of work for an experienced Selenium developer. **Note:** I will provide the full existing script, the Excel data file, and my GSCCCA premium login credentials to the selected developer. I am available to screen share and demonstrate the issue live. Please let me know the fee you'll charge to complete this project.