jaivee wrote: ↑Tue Sep 10, 2019 8:48 am
Code: Select all
VERSION BUILD=1005 RECORDER=CR
Chromebook, German
Chrome version 76.0.3809.102
iMacros= for Chrome, free Edtition
Thank you very much for the insight. I have tried to follow up the above, but it seems Google might have changed the functionality so the EVENT does not seem to work anymore (or I am doing something wrong)
The reason why I am building this script / procedure is
Vimeo.com
At Vimeo.com, once you do not further pay them an annual fee, they do delete nearly ALL your videos.
So far so understandable, even if it is not publicly displayed in the offer process and when I was uploading >3000 private videos over the last couple of years.
On request they send you a CSV file with links to download your 3000 videos, but this is only valid for 24h and you have to click every single link, unless you upgrade to PRO which is more money. Hence....pretty much a ripp off
So here comes iMacros into play. Since I have a Chromebook I dont have the file access extension (yet, hopefully soon) I would like to reach out to Google Spreadsheets to go through the links and then with ONDOWNLOAD do the trick
Google Spreadsheet does offer an XPATH with a URL
but I was not able to integrate it properly into iMacros.
Do you maybe have and idea how to adress the cell? Google blocked the inspect element function.
for the Vimeo procedure I thought of something like that
Code: Select all
' Step 1 adressing the right cell in Google Spreadsheets. A1 at first, then A{{LOOP}} in a later version, once it works
TAB T=1
URL GOTO=https://docs.google.com/spreadsheets/d/1t6yelDzGwpX1O99gAXWWR21SM-VgwB-7TickMyZShj8/edit#gid=0
TAG XPATH=
' Google is offering range=A1 as the xpath but it remains unclear how to translate that into an iMacro accessible link
EXTRACT=TXT
PROMPT {{EXTRACT}}
' then the downloading process - by the nature of the link the download should happen automatically
https://player.vimeo.com/play/1033101[...]&loc=external&context=.&download=1
SET !TIMEOUT_PAGE 300
ONDOWNLOAD FOLDER=* FILE=* WAIT=YES
URL GOTO= {{EXTRACT}}
WAIT SECONDS=1
thank you very much. your input is highly appreciated
Oh...!, I first thought you were the "useless" original @OP from this Thread who never followed up, ah-ah...!
Alright, so my "(Maybe one day, that Thread might still be useful for some other User(s)...

)" is apparently coming a bit true, good-good...
But you say it doesn't "really" work anymore..., hum, well, I'm not "too" surprised, the Interface keeps changing "constantly"...
But-but-but..., hum..., I would have a much easier Approach in your Case, I would think..., ah-ah...!
So, if I understood correctly, you've received a "real" '.CSV' File from 'Vimeo', that you managed to open from your ChromeBook or some Desktop/Laptop, and then using some Text Editor like 'Notepad' or some Spreadsheet Software like 'Excel'/'OpenOffice'/'LibreOffice', and you copied the whole Content of that '.CSV' to some New GoogleSheet.
Yeah, OK, but here comes my "better" Approach, ah-ah...!
If you can go back to opening the '.CSV' in 'Excel' or similar App ('OO' or 'LO'), but not 'Notepad'...
Shift all existing Content to the Right by inserting a first Col on the complete Left of your Data Sheet.
You give a "Vid_1" Name to the 1st Cell corresponding to your 1st Video Link.
Click on the Bottom Right Corner of that Cell (you might need to press 'Ctrl' at the same time...) and drag it down until Row 3000, and you should get [Vid_1,Vid_2,...,Vid_3000] in that 1st Col.
(Really use "Vid_1"/"Vid_2" etc and not "Vid_0001"/"Vid_0002" etc...)
Give those 2 Cols a different Colour...!! (Probably not really needed in your Case, but it's a Trick that can be useful...

)
And now the "big Trick"...!: Save your Sheet as 'HTML'...! (and not as '.CSV' or any other Format the Software will want you to use...)
=> Now you have your complete original '.CSV'/DataSource converted to a (Local) '.HTML' File that you can simply open in your Browser in 'TAB_1', from which you can extract one by one all 3000 Video Links to then download them all from 'TAB_2', and maybe a 2nd Tab is not even needed if you use '
SAVETARGETAS' as I guess all Links will be automatically made as Hyperlinks by CR...
But your Script should look like stg like that...:
Code: Select all
TAB T=1
SET !LOOP 1
TAG POS={{!LOOP}} TYPE=TD ATTR=TXT:Vid_{{!LOOP}}
TAG POS=R1 TYPE=A ATTR=TXT:* CONTENT=EVENT:SAVETARGETAS
WAIT SECONDS=10
Not tested of course...
Using the 'Free' Version of v10.0.5 for CR, you cannot use the 'ONDOWNLOAD' Command to control the Name + Location where you want to download all the Videos..., and Looping is limited to 100, but once you've done the 1st Batch of Vids [1-100], you modify the "SET !LOOP 1" into "SET !LOOP 101", hum-hum-hum [...], I'm not sure where the Check on the Loop=Max 100 is for the 'Free' Limitation, then OK, this one should work, and you each time loop it 100 times from 1 to 100, and you only modify the "SET !VAR1 0" to "100" => "200" etc...:
Code: Select all
TAB T=1
SET !VAR1 0
ADD !VAR1 {{!LOOP}}
TAG POS={{!VAR1}} TYPE=TD ATTR=TXT:Vid_{{!VAR1}}
TAG POS=R1 TYPE=A ATTR=TXT:* CONTENT=EVENT:SAVETARGETAS
WAIT SECONDS=10
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE').
- I don't even read the Qt if that (required) Info is not mentioned...!
- Script & URL help a lot for more "educated" Help...