Forum Discussion
Formatting grandpa's TV overview
- Dec 26, 2020
ScoIaro Sorry, overlooked your comment explaining that you had used the email option already. The automation can be achieved if you can/want to use Power Query. Rather than sending and e-mail, download the marked programs as an XML file (although the extension becomes .rss).
Then in PowerQuery, you can connect to the downloaded file do some transformations once and the next time it will all go automatic. Tried it works great, but it will have to be adopted to your own system.
ScoIaro Sorry, overlooked your comment explaining that you had used the email option already. The automation can be achieved if you can/want to use Power Query. Rather than sending and e-mail, download the marked programs as an XML file (although the extension becomes .rss).
Then in PowerQuery, you can connect to the downloaded file do some transformations once and the next time it will all go automatic. Tried it works great, but it will have to be adopted to your own system.
Riny_van_Eekelen I took a look at Power Query and will definitely give it a shot!
(On top of that I contacted the Klack.de website and asked them to change the ANSI extracts to Unicode, so let's see who's quicker solving the problem, me or them. ^^)
Thank you very much for taking the time to check this and reply to me!