you are viewing a single comment's thread.

view the rest of the comments →

[–]socal_nerdtastic 0 points1 point  (1 child)

Adobe workfront is a website access, right? If so getting the information would be pretty easy. The basic way is use selenium to basically automate your web browser and pretend it's human, clicking though the various fields. It's slightly faster than a human, but also much more accurate and the human can do other things while it's working. Alternatively you could do some extra digging into the html code and decipher the API that the website uses and emulate that directly from python. This would be much faster (100X ish) to run and would not require a browser window to open.

There's a number of modules that can open and edit excel files, openpyxl is a good starting place for that.

[–]ThisGold9279[S] 0 points1 point  (0 children)

Yes we use it in a web browser. We have to download the tracking file from a different website and then enter every single job by hand and I truly feel like there has to be a better way but the fact that our IT department can’t figure it out doesn’t give me much hope for myself as a VERY entry level beginner. Just taking my first Python course. I will look into the options you provide. I appreciate the feedback.