Reply to thread

Message

<blockquote data-quote="nabl" data-source="post: 980512" data-attributes="member: 43512">Here's the code that will work just as well for three as for a thousand. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />[code]-- Set the input file's location; a file with one &quot;URL &lt;tab&gt; filename&quot; on each line is expected.set tabDelimitedInputFile to choose file with prompt &quot;Choose a file containing tab-separated URL-filename pairs.&quot;-- Set the location to place the images that are downloaded.set downloadFolder to the POSIX path of (choose folder with prompt &quot;Choose a folder to save the download images to.&quot;)-- Read in the text from the input file.set theFile to (open for access tabDelimitedInputFile)set fileContents to read theFileclose access theFile-- Change the delimeters to tabs to separate the URL and filename on each line (save the old value).set oldDelimiters to AppleScript's text item delimitersset AppleScript's text item delimiters to tab-- Repeat through each line of the file, downloading the image and naming it as specified.repeat with i from 1 to the count of paragraphs in fileContents&nbsp; &nbsp; set thisLine to paragraph i of fileContents&nbsp; &nbsp; -- Extract the URL and image name.&nbsp; &nbsp; set lineItems to the text items of thisLine&nbsp; &nbsp; set imageURL to item 1 of lineItems&nbsp; &nbsp; set imageName to item 2 of lineItems&nbsp; &nbsp; -- Download the image and place it in the specified folder.&nbsp; &nbsp; do shell script &quot;curl &quot; &amp; imageURL &amp; &quot; -o &quot; &amp; downloadFolder &amp; imageNameend repeat-- Reset the text item delimitersset AppleScript's text item delimiters to oldDelimiters[/code]Just export your spreadsheet as tab-delimited data in a text file and run the script. It assumes two things: first, that the data is formatted as one URL &lt;tab&gt; filename pair per line, and second, that the filename includes the file extension. If not, let me know and I can help work toward a dynamic solution (using the extension from the URL).Oh, and here's the data I tested it with (just a few random images from Apple's homepage; of course, be sure to respect their copyright):[code]http://images.apple.com/home/images/promo_iphone3gs_20091218.jpg&nbsp; &nbsp; iphone.jpghttp://images.apple.com/home/images/promo_macbook_20091020.jpg&nbsp; &nbsp; macbook.jpghttp://images.apple.com/home/images/promo_ipodnano_20091123.jpg&nbsp; &nbsp; ipodnano.jpg[/code]</blockquote>

[QUOTE="nabl, post: 980512, member: 43512"] Here's the code that will work just as well for three as for a thousand. :) [code]-- Set the input file's location; a file with one "URL <tab> filename" on each line is expected. set tabDelimitedInputFile to choose file with prompt "Choose a file containing tab-separated URL-filename pairs." -- Set the location to place the images that are downloaded. set downloadFolder to the POSIX path of (choose folder with prompt "Choose a folder to save the download images to.") -- Read in the text from the input file. set theFile to (open for access tabDelimitedInputFile) set fileContents to read theFile close access theFile -- Change the delimeters to tabs to separate the URL and filename on each line (save the old value). set oldDelimiters to AppleScript's text item delimiters set AppleScript's text item delimiters to tab -- Repeat through each line of the file, downloading the image and naming it as specified. repeat with i from 1 to the count of paragraphs in fileContents set thisLine to paragraph i of fileContents -- Extract the URL and image name. set lineItems to the text items of thisLine set imageURL to item 1 of lineItems set imageName to item 2 of lineItems -- Download the image and place it in the specified folder. do shell script "curl " & imageURL & " -o " & downloadFolder & imageName end repeat -- Reset the text item delimiters set AppleScript's text item delimiters to oldDelimiters[/code] Just export your spreadsheet as tab-delimited data in a text file and run the script. It assumes two things: first, that the data is formatted as one [font="Lucida Console"]URL <tab> filename[/font] pair per line, and second, that the filename includes the file extension. If not, let me know and I can help work toward a dynamic solution (using the extension from the URL). Oh, and here's the data I tested it with (just a few random images from Apple's homepage; of course, be sure to respect their copyright): [code]http://images.apple.com/home/images/promo_iphone3gs_20091218.jpg iphone.jpg http://images.apple.com/home/images/promo_macbook_20091020.jpg macbook.jpg http://images.apple.com/home/images/promo_ipodnano_20091123.jpg ipodnano.jpg[/code] [/QUOTE]

Verification

Name this item. 🍎