{"id":42,"date":"2017-03-23T14:36:10","date_gmt":"2017-03-23T14:36:10","guid":{"rendered":"http:\/\/www.polysyncronism.com\/wordpress\/?page_id=42"},"modified":"2017-03-23T14:36:10","modified_gmt":"2017-03-23T14:36:10","slug":"get-pics-from-url","status":"publish","type":"page","link":"http:\/\/www.polysyncronism.com\/wordpress\/get-pics-from-url\/","title":{"rendered":"Get Pics from URL"},"content":{"rendered":"<pre class=\"toolbar:1 lang:default highlight:0 decode:true  \" title=\"CSV File Sample\">URL,Filename\r\n\"http:\/\/www.polysyncronism.com\/pics\/heart.jpg\",\"c:\\work\\pics\\myheart.jpg\"\r\n\"http:\/\/www.polysyncronism.com\/pics\/ovaltine.jpg\",\"c:\\work\\pics\\myovaltine.jpg\"<\/pre>\n<p>Make a directory named c:\\work and create the VBScript file<\/p>\n<pre class=\"toolbar:1 lang:vb decode:true \" title=\"VB Script\">On Error Resume Next\r\n\r\nConst adOpenStatic = 3\r\nConst adLockOptimistic = 3\r\nConst adCmdText = &amp;amp;H0001\r\n\r\nSet objConnection = CreateObject(\"ADODB.Connection\")\r\nSet objRecordSet = CreateObject(\"ADODB.Recordset\")\r\n\r\nstrPathtoTextFile = \"C:\\work\\\"\r\n\r\nobjConnection.Open \"Provider=Microsoft.Jet.OLEDB.4.0;\" &amp;amp; _\r\n          \"Data Source=\" &amp;amp; strPathtoTextFile &amp;amp; \";\" &amp;amp; _\r\n          \"Extended Properties=\"\"text;HDR=YES;FMT=Delimited\"\"\"\r\n\r\nobjRecordset.Open \"SELECT URL,Filename FROM URLList.csv\", _\r\n          objConnection, adOpenStatic, adLockOptimistic, adCmdText\r\n\r\n\r\nDo Until objRecordset.EOF\r\n\r\nWScript.Echo \"Processing File\" + objRecordset.Fields.Item(\"Filename\")\r\n\r\nURL = objRecordset.Fields.Item(\"URL\")\r\nsaveTo = objRecordset.Fields.Item(\"Filename\")\r\n\r\n' Fetch the file\r\nSet objXMLHTTP = CreateObject(\"MSXML2.ServerXMLHTTP.6.0\")\r\nobjXMLHTTP.send()\r\n\r\nIf objXMLHTTP.Status = 200 Then\r\nSet objADOStream = CreateObject(\"ADODB.Stream\")\r\nobjADOStream.Open\r\nobjADOStream.Type = 1 'adTypeBinary\r\n\r\nobjADOStream.Write objXMLHTTP.ResponseBody\r\nobjADOStream.Position = 0    'Set the stream position to the start\r\n\r\nSet objFSO = Createobject(\"Scripting.FileSystemObject\")\r\nIf objFSO.Fileexists(saveTo) Then objFSO.DeleteFile saveTo\r\nSet objFSO = Nothing\r\n\r\nobjADOStream.SaveToFile saveTo\r\nobjADOStream.Close\r\nSet objADOStream = Nothing\r\nEnd if\r\n\r\nSet objXMLHTTP = Nothing\r\n\r\nobjRecordset.MoveNext\r\n\r\nLoop<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>URL,Filename &#8220;http:\/\/www.polysyncronism.com\/pics\/heart.jpg&#8221;,&#8221;c:\\work\\pics\\myheart.jpg&#8221; &#8220;http:\/\/www.polysyncronism.com\/pics\/ovaltine.jpg&#8221;,&#8221;c:\\work\\pics\\myovaltine.jpg&#8221; Make a directory named c:\\work and create the VBScript file On Error Resume Next Const adOpenStatic = 3 Const adLockOptimistic = 3 Const adCmdText = &amp;amp;H0001 Set objConnection = CreateObject(&#8220;ADODB.Connection&#8221;) Set objRecordSet = CreateObject(&#8220;ADODB.Recordset&#8221;) strPathtoTextFile = &#8220;C:\\work\\&#8221; objConnection.Open &#8220;Provider=Microsoft.Jet.OLEDB.4.0;&#8221; &amp;amp; _ &#8220;Data Source=&#8221; &amp;amp; strPathtoTextFile &amp;amp; &#8220;;&#8221; &amp;amp; _ &#8220;Extended Properties=&#8221;&#8221;text;HDR=YES;FMT=Delimited&#8221;&#8221;&#8221; objRecordset.Open &hellip; <a href=\"http:\/\/www.polysyncronism.com\/wordpress\/get-pics-from-url\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Get Pics from URL&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-42","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/pages\/42","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/comments?post=42"}],"version-history":[{"count":9,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/pages\/42\/revisions"}],"predecessor-version":[{"id":51,"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/pages\/42\/revisions\/51"}],"wp:attachment":[{"href":"http:\/\/www.polysyncronism.com\/wordpress\/wp-json\/wp\/v2\/media?parent=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}