topic Re: Re: Re: Load from google drive in QlikView

Load from google drive

Anonymous — Thu, 23 Jan 2014 18:32:50 GMT

Hi,

How to load file from google drive into Qlikview.

Re: Load from google drive

jaimeaguilar — Thu, 23 Jan 2014 18:39:23 GMT

Hi,

Give it a try to QV source, it can help you to connect to plenty of web platforms including google drive,

www.qvsource.com/

regards

Re: Load from google drive

Clever_Anjos — Thu, 23 Jan 2014 19:03:12 GMT

If you´re using Google Sheets

1) File / Publish into your Google Sheet

2) Google will generate a link. Copy it

3) Into QlikView Script, there´s a button "Web Files", use that link to open your document

Re: Load from google drive

julian_rodriguez — Thu, 23 Jan 2014 19:22:22 GMT

Hello Clever,

Your answer is interesting, but I can't get the file contents...

I get an error saying "Cannot open HTML File".

I have tried Web Page, Txt and csv options but without any result.

How did you did that?

Re: Load from google drive

Clever_Anjos — Thu, 23 Jan 2014 19:33:30 GMT

Well, it seems to work here, we use it a lot check this url (please remove all spaces), i´ve used google to shorten it

http : // goo . gl / XpYPrx

Re: Load from google drive

julian_rodriguez — Thu, 23 Jan 2014 19:40:24 GMT

I really don't know why it doesn't works... your link is working, i get a CSV file.

But if I try to get it from the script, the Qlikview wizard doesn't recognize it.

Do you have the extraction script for this file?

Sorry but I'm really interested on this kind of solution...

Thanks in advance,

Re: Load from google drive

stevedark — Thu, 23 Jan 2014 19:40:35 GMT

Hi Clever,

That is a CSV, rather than a full Google spreadsheet. It's good to know that this works though!

QV Source is probably the simplest way to connect to Google spreadsheets directly.

My company is a re-seller, if you would like a quote please get in touch:

http://www.quickintelligence.co.uk/qvsource/

Steve

Re: Load from google drive

stevedark — Thu, 23 Jan 2014 19:42:19 GMT

You need to use the Web Files button and use the Wizard there. It will generate this script:

LOAD

FROM

[http://goo.gl/XpYPrx]

(txt, utf8, embedded labels, delimiter is ',', msq);

Steve

Re: Re: Load from google drive

Clever_Anjos — Thu, 23 Jan 2014 19:43:10 GMT

GoogleData:
LOAD
  RowNo()                                                                            as GoogleData.Avaliacao,
  timestamp(timestamp#(trim(Timestamp),'MM/DD/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss') as GoogleData.DataHora,
  date(timestamp#(trim(Timestamp),'MM/DD/YYYY hh:mm:ss'),'DD/MM/YYYY')               as GoogleData.Data,
  [Nome do Consultor] as GoogleData.NomedoConsultor,
  [Gestor SWB] as GoogleData.GestorSWB,
  [Nome do Avaliador] as GoogleData.NomedoAvaliador,
  [Considerações finais] as GoogleData.ConsideracoesFinais,
  autonumberhash128(RowNo(), date(timestamp#(trim(Timestamp),'MM/DD/YYYY hh:mm:ss'),'DD/MM/YYYY')) as Chave.Avaliacao
FROM [https://docs.google.com/spreadsheet/pub?hl=en&hl=en&key=0Augcl9bj_QQJdGlCMThXY0k5eHBjaVNNX1Byak1FVWc&output=csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

Re: Re: Load from google drive

Clever_Anjos — Thu, 23 Jan 2014 19:43:55 GMT

My another answer is beeing moderated, because has a link. It must show up in a few minutes

Re: Load from google drive

Clever_Anjos — Thu, 23 Jan 2014 19:45:09 GMT

Try to chance the last word of your link from 'html' to 'csv', can help

Re: Load from google drive

Anonymous — Thu, 23 Jan 2014 19:48:00 GMT

Hi Clever,

I tried in FILE/DOWN LOAD as Web page(.html) and then used URL and it did not work. error says can not open URL

Re: Load from google drive

julian_rodriguez — Thu, 23 Jan 2014 19:49:22 GMT

Clever, I'm trying to use this file:

http: // goo.gl/ rU0cjw

And doesn't works neither...

Re: Re: Load from google drive

Clever_Anjos — Thu, 23 Jan 2014 19:52:08 GMT

Do not Download it, Publish.

Here´s a step by step

Re: Load from google drive

Anonymous — Thu, 23 Jan 2014 19:56:21 GMT

I don't see publish option under File Menu, Is there any other alternative?

Re: Load from google drive

julian_rodriguez — Thu, 23 Jan 2014 19:59:40 GMT

I can't see how do you connect Qlivkview with the Google spreadsheet on this step by step...

Re: Re: Load from google drive

Clever_Anjos — Thu, 23 Jan 2014 20:02:46 GMT

weird...

My printscreens

Re: Re: Load from google drive

Clever_Anjos — Thu, 23 Jan 2014 20:03:49 GMT

Sorry, the step by step is to generate the link.

Just below I´ve attached two images how to connect using QlikView

Re: Re: Load from google drive

Clever_Anjos — Thu, 23 Jan 2014 20:04:26 GMT

Very weird... Is it possible to send my a print of your screen?

Re: Load from google drive

julian_rodriguez — Thu, 23 Jan 2014 20:16:48 GMT

And this is my printscreen...

I don't know why?... it seems to be so easy for you!