I need assistance with a script I have created to upload images to a website from a CSV file. However, each time I run the script, it only uploads the first row of data. Here is an excerpt from the script where I attempt to publish all images, descriptions, tags, titles, and colors from the CSV file:
filename = 'img.csv'
line_number = 1
with open(filename, 'r') as f:
mycsv = csv.reader(f)
mycsv = list(mycsv)
images = mycsv[line_number][0]
titels = mycsv[line_number][1]
tags = mycsv[line_number][2]
descriptions = mycsv[line_number][3]
colors = mycsv[line_number][4]
for line in mycsv:
driver.get('https://www.redbubble.com/portfolio/images/')
time.sleep(3)
#scroll down
driver.execute_script("window.scrollTo(0,400)")
#click color element
color = driver.find_element(By.XPATH, "//div[@class='global-background-color-setting']//div[@class='sp-replacer sp-light']")
color.click()
#click element to write color code
color = driver.find_element(By.XPATH, "//div[@class='sp-container sp-light sp-buttons-disabled sp-palette-buttons-disabled sp-palette-disabled']//input[@type='text']")
color.click()
color.clear()
color.send_keys(colors)
time.sleep(2)
#click element to write title
titel = driver.find_element(By.XPATH, "//input[@id='work_title_en']")
titel.click()
titel.clear()
titel.send_keys(titels)
time.sleep(1)
#click element to write tag
tag = driver.find_element(By.XPATH, "//textarea[@id='work_tag_field_en']")
tag.click()
tag.clear()
tag.send_keys(tags)
time.sleep(2)
#click element to write descriptions
description = driver.find_element(By.XPATH, "//textarea[@id='work_description_en']")
description.click()
description.clear()
description.send_keys(descriptions)
time.sleep(2)
# Upload image
upload = "//input[@id='select-image-base']"
upload = driver.find_element("xpath",(upload))
#file path specified with send_keys
time.sleep(2)
upload.send_keys(images)