Current Progress
I successfully developed a Python script that utilizes Selenium to open a Firefox browser and extract data to an excel file. Furthermore, I have converted this script into an executable file without encountering any errors thanks to Pyinstaller.
Challenges Faced
Unfortunately, when attempting to run the newly created executable on my work laptop, it fails to launch the browser or generate any output. Instead, a command window briefly appears before closing automatically.
My Objective
The purpose of this project is to streamline the process of data extraction for my colleagues by providing them with a user-friendly script. This eliminates the need to manually retrieve information from the website every time. Additionally, I aim to restrict their access to system settings and prevent multiple browsers from opening simultaneously.
Query
Could the lack of geckodriver path be hindering the execution of Firefox in the executable? Do I need to ensure the geckodriver presence on each PC where the script will be used?
Code Implementation
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.support.ui import WebDriverWait
import pandas as pd
productName = []
number = []
divList = []
driver = webdriver.Firefox()
driver.get("website")
radioBtn = driver.find_element_by_id("ContentPlaceHolder1_company")
radioBtn.click()
element = driver.find_element_by_id("ContentPlaceHolder1_TextBoxInput1")
element.send_keys("CompanyName")
Search = driver.find_element_by_id("ContentPlaceHolder1_view1Continue")
Search.click()
driver.implicitly_wait(10)
driver.find_element_by_id("ctl00_ContentPlaceHolder1_92564").click()
driver.implicitly_wait(2)
divList = driver.find_elements_by_class_name('nopgbrk')
for div in divList:
number.append(div.find_element_by_xpath('a').text)
productName.append(div.find_element_by_xpath('span').text)
df = pd.DataFrame({'Product':productName, 'Registration': number})
df.to_excel("C:\Python\Scrapeddata\Scrape.xls")