Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Load from google drive


Hi,

How to load file from google drive into Qlikview.

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

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

View solution in original post

44 Replies
jaimeaguilar
Partner - Specialist II
Partner - Specialist II

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

Clever_Anjos
Employee
Employee

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

julian_rodriguez
Partner - Specialist
Partner - Specialist

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?

Clever_Anjos
Employee
Employee

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

julian_rodriguez
Partner - Specialist
Partner - Specialist

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,

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Clever_Anjos
Employee
Employee

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...]

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

Clever_Anjos
Employee
Employee

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