I'm sorry to start a new thread, but I have a mix of two problems from two other completed threads (links below).
I was able to use the Download tool to use the hyperlinks in an Excel spreadsheet to download one document per URL which the tool placed in a folder for me Beautiful.
But now I can't seem to get it to work using a new spreadsheet, new URLs and placing into a new folder. I get the error message in the subject line. And after that (in the workflow messages), I will get ONE output. So, it works, but only once. What is stopping it? Or what's causing it?
None of the solutions have helped me so far, so looking for other ideas. Thanks in advance!!!
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Display-static-webpage/td-p/75921/page...
downloading from a webpage
https://community.alteryx.com/t5/forums/replypage/board-id/server-discussions/message-id/4039
error message
Solved! Go to Solution.
There must be a setting somewhere that's interfering with it.
Which tool is causing the error ?
Can you attach a screenshot of the tool configuration ?
I have a similar problem using the download tool.
For some reason the system does not run much futher than 20-30 files. I should receive 1000+.
I have tried adding a throttle tool in the workflow to pace the amount of upload/download -> no difference.
I have tried adding a block until done tool -> no difference.
Hi @MarqueeCrew
I'm not familiar with macros yet. Could you suggest a way to batch my records?
I managed to group them using the tile tool, but cannot get further to repeat the task.
A quick strategy is:
Assign a RECORD ID to each record (you'll start with batches of 1).
You'll need to either open a batch macro or look for one that is part of a lesson or a weekly challenge. Likely, someone will post here, but I'm heading out now. Have a filter that checks for recordid = 1. You'll configure the batch macro to have the control update the filter and switch 1 to the next incoming record id.
Essentially, this will create a synchronous download of 1 file at a time.
Cheers,
Mark
@cmcclellan , can you please help here?
Thank you! I am not sure why it worked for me with 1600 records without needing a macro but now trying 45 records, I do, but I'll take it. I made a bad batch macro (worked, but not exactly the output I wanted), so I will retweak and get it right shortly. There was also this thread about a one-at-a-time iteration. https://community.alteryx.com/t5/Alteryx-Designer-Discussions/1-record-per-interation/td-p/94320
Brilliant, it took a bit of tweaking and 20 minutes processing but it worked.
Thank you.
The link provided by @summarizer did it!