Page 1 of 1

Importing data from a CSV file online

Posted: Fri May 26, 2017 12:44 am
by tvonbrasch
Hi

Is there a way to import data from a CSV file online directly through program codes in Eviews?

For example, the address http://www.ssb.no/nasjonalregnskap-og-konjunkturer/tabeller/_attachment/103301?_ts=15c0b99a670 links to a csv file holding national accounts data. Is there a way of importing this data directly into Eviews, say by using a command similar to:

Code: Select all

wfopen "http://www.ssb.no/nasjonalregnskap-og-konjunkturer/tabeller/_attachment/103301?_ts=15c0b99a670" custom=";"

?

It would be really great if this was doable.

Thomas

Re: Importing data from a CSV file online

Posted: Fri May 26, 2017 6:06 am
by EViews Gareth

Code: Select all

wfopen(type=txt) "http://www.ssb.no/nasjonalregnskap-og-konjunkturer/tabeller/_attachment/103301?_ts=15c0b99a670" custom=";"

Re: Importing data from a CSV file online

Posted: Fri May 26, 2017 8:01 am
by tvonbrasch
that was just to easy ... :-)
thanks

Re: Importing data from a CSV file online

Posted: Fri May 26, 2017 8:42 am
by tvonbrasch
But why will not the following command work:

Code: Select all

wfopen(type=txt) "https://data.norges-bank.no/api/data/EXR/M.NOK.CHF.SP.A?format=csv-:-comma-true-x" custom=";"


?

The example is taken from the Norwegian Central Bank, see http://www.norges-bank.no/en/Statistics/open-data/get-data/. Is there a way to import this type of data as well?

Thomas

Re: Importing data from a CSV file online

Posted: Fri May 26, 2017 8:54 am
by EViews Gareth
EViews doesn't support HTTPS

Re: Importing data from a CSV file online

Posted: Fri May 26, 2017 10:13 am
by tvonbrasch
ok, maybe this is something you can add for Eviews 10 ?
Thomas

Re: Importing data from a CSV file online

Posted: Fri May 26, 2017 10:21 am
by EViews Gareth
Perhaps.

Re: Importing data from a CSV file online

Posted: Sun May 28, 2017 11:51 pm
by tvonbrasch
I asked if Norges Bank could switch to http, but they said no and referred to the article
https://developers.google.com/web/fundamentals/security/encrypt-in-transit/why-https

(see below)


So, hopefully you can support https in Eviews 10.
Thomas

Why HTTPS Matters

Kayce Basques
By Kayce Basques
Technical Writer at Google

You should always protect all of your websites with HTTPS, even if they don’t handle sensitive communications. Aside from providing critical security and data integrity for both your websites and your users' personal information, HTTPS is a requirement for many new browser features, particularly those required for progressive web apps.

TL;DR

Intruders both malignant and benign exploit every unprotected resource between your websites and users.
Many intruders look at aggregate behaviors to identify your users.
HTTPS doesn't just block misuse of your website. It's also a requirement for many cutting-edge features and an enabling technology for app-like capabilities such as service workers.
HTTPS protects the integrity of your website

HTTPS helps prevent intruders from tampering with the communications between your websites and your users’ browsers. Intruders include intentionally malicious attackers, and legitimate but intrusive companies, such as ISPs or hotels that inject ads into pages.

Intruders exploit unprotected communications to trick your users into giving up sensitive information or installing malware, or to insert their own advertisements into your resources. For example, some third parties inject advertisements into websites that potentially break user experiences and create security vulnerabilities.

Intruders exploit every unprotected resource that travels between your websites and your users. Images, cookies, scripts, HTML … they’re all exploitable. Intrusions can occur at any point in the network, including a user’s machine, a Wi-Fi hotspot, or a compromised ISP, just to name a few.

HTTPS protects the privacy and security of your users

HTTPS prevents intruders from being able to passively listen to communications between your websites and your users.

One common misconception about HTTPS is that the only websites that need HTTPS are those that handle sensitive communications. Every unprotected HTTP request can potentially reveal information about the behaviors and identities of your users. Although a single visit to one of your unprotected websites may seem benign, some intruders look at the aggregate browsing activities of your users to make inferences about their behaviors and intentions, and to de-anonymize their identities. For example, employees might inadvertently disclose sensitive health conditions to their employers just by reading unprotected medical articles.

HTTPS is the future of the web

Powerful, new web platform features, such as taking pictures or recording audio with getUserMedia(), enabling offline app experiences with service workers, or building progressive web apps, require explicit permission from the user before executing. Many older APIs are also being updated to require permission to execute, such as the geolocation API. HTTPS is a key component to the permission workflows for both these new features and updated APIs.