Importing data from a CSV file online

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

tvonbrasch
Posts: 540
Joined: Fri Apr 15, 2011 5:35 am

Importing data from a CSV file online

Postby tvonbrasch » Fri May 26, 2017 12:44 am

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13305
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing data from a CSV file online

Postby EViews Gareth » Fri May 26, 2017 6:06 am

Code: Select all

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

tvonbrasch
Posts: 540
Joined: Fri Apr 15, 2011 5:35 am

Re: Importing data from a CSV file online

Postby tvonbrasch » Fri May 26, 2017 8:01 am

that was just to easy ... :-)
thanks

tvonbrasch
Posts: 540
Joined: Fri Apr 15, 2011 5:35 am

Re: Importing data from a CSV file online

Postby tvonbrasch » Fri May 26, 2017 8:42 am

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13305
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing data from a CSV file online

Postby EViews Gareth » Fri May 26, 2017 8:54 am

EViews doesn't support HTTPS
Follow us on Twitter @IHSEViews

tvonbrasch
Posts: 540
Joined: Fri Apr 15, 2011 5:35 am

Re: Importing data from a CSV file online

Postby tvonbrasch » Fri May 26, 2017 10:13 am

ok, maybe this is something you can add for Eviews 10 ?
Thomas

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13305
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing data from a CSV file online

Postby EViews Gareth » Fri May 26, 2017 10:21 am

Perhaps.
Follow us on Twitter @IHSEViews

tvonbrasch
Posts: 540
Joined: Fri Apr 15, 2011 5:35 am

Re: Importing data from a CSV file online

Postby tvonbrasch » Sun May 28, 2017 11:51 pm

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.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 24 guests