Bookmark and Share

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   Scott Lee <[email protected]>
To   [email protected]
Subject   Re: st: Importing an Excel file directly from https URL
Date   Sat, 27 Apr 2013 21:53:51 -0400

Hi Sergiy,

Thanks for pointing me to that Statalist thread -- I had searched but
didn't come across it. I'll try the wget approach.

Many thanks,
Scott


On Fri, Apr 26, 2013 at 6:52 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 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/
*
*   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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index