Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Importing an Excel file directly from https URL
From
Sergiy Radyakin <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: Importing an Excel file directly from https URL
Date
Fri, 26 Apr 2013 18:52:41 -0400
Dear Scott,
the problem is not with importing an Excel file but with the secure
protocol. Stata does not support the secure version of the HTTP
and responds to an attemp of using it as error 671.
See here for some workarounds. Basically you will need to use other tools
to get the file prior to importing.
http://www.stata.com/statalist/archive/2011-02/msg00288.html
Best, Sergiy
On Fri, Apr 26, 2013 at 2:29 PM, Sergiy Radyakin <[email protected]> wrote:
>
> Dear Scott,
>
> the problem is not with importing an Excel file but with the secure
> protocol. Stata does not support the secure version of the HTTP
> and responds to an attemp of using it as error 671.
>
> See here for some workarounds. Basically you will need to use other tools
> to get the file prior to importing.
> http://www.stata.com/statalist/archive/2011-02/msg00288.html
> Best, Sergiy
>
>
> On Fri, Apr 26, 2013 at 12:35 PM, Sergiy Radyakin <[email protected]> wrote:
>>
>> Dear Scott,
>>
>> the problem is not with importing an Excel file but with the secure protocol. Stata does not support the secure version of the HTTP and responds to an attemp of using it as error 671.
>>
>> See here for some workarounds. Basically you will need to use other tools to get the file prior to importing.
>> http://www.stata.com/statalist/archive/2011-02/msg00288.html
>> Best, Sergiy
>>
>>
>>
>> On Thu, Apr 25, 2013 at 11:02 PM, Scott Lee <[email protected]> wrote:
>>>
>>> Is it possible to import an Excel file directly into Stata from a
>>> secure (https) URL?
>>>
>>> Per http://www.stata.com/statalist/archive/2012-06/msg00394.html , the
>>> following routine works perfectly for the first, unsecure URL, but the
>>> second -copy- gives an "unknown network protocol" (r671) error:
>>>
>>> tempfile raw
>>> copy "http://[URL]"; `raw'
>>> import excel `raw'
>>>
>>> copy "https://[URL]"; `raw', replace
>>> import excel `raw'
>>>
>>> Many thanks for any assistance.
>>> *
>>> * For searches and help try:
>>> * http://www.stata.com/help.cgi?search
>>> * http://www.stata.com/support/faqs/resources/statalist-faq/
>>> * http://www.ats.ucla.edu/stat/stata/
>>
>>
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/