Its all programming at this point and you just use code to get to the data directly where it lives. You manipulate things directly through programatic API or you go to lower level stuff like, filesystem or network. You rarely automate a UI or do screen scraping as a developer, its simply not a good way to get the job done. You could write python to process the files. It could be stuff stored in files on the filesystem etc. If you are after reports generally its easier to hit the data directly, it could be in MySQL or Postgres database on webserver in which case you can write SQL queries and save the results as CSV. So this week, I started looking into python and came across something called Pyinstaller, which builds and compiles a script and creates an executable, then I managed to get this to work with windows task scheduler - so that is a win. I did have a program called system scheduler that would run this but that stopped and I could not work out how and why, I also tried a few others like Z cron, task till dawn and task scheduler - these would not produce the report I needed. I have some regular boring tasks I have to do, one was to run a report to t let us know how many assignments have been created, all I would do for this was remote onto the computer in work, locate, edit with IDLE and then run or press F5. Its actually quite good when you get in to all of thisīeen looking into a few options to be honest. The first thing I am going to do with this is write the whole process down and then do it in chunks, I know I can use selenium and other things, possibly Scrapy or similar, I just need to work out the elements of the web pages that carry out the actions and put them in a script, then I can use Pyinstaller and task scheduler to do its thing. My next thing I want to do, involves logging into a website and downloading the results of an attendance register and on the Friday of each week, placing them into a teams group for someone. Click to expand.Been looking into a few options to be honest.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |