Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[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 <ssl2468@gmail.com>
To   statalist@hsphsun2.harvard.edu
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 <serjradyakin@gmail.com> 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 <serjradyakin@gmail.com> 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 <serjradyakin@gmail.com> 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 <ssl2468@gmail.com> 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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index