Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jaswantc
Contributor II

Load from google drive


Hi,

How to load file from google drive into Qlikview.

1 Solution

Accepted Solutions
Employee
Employee

Re: Load from google drive

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

44 Replies
jaimeaguilar
Valued Contributor II

Re: Load from google drive

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

Employee
Employee

Re: Load from google drive

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_rodrigue
Valued Contributor

Re: Load from google drive

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?

Employee
Employee

Re: Load from google drive

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_rodrigue
Valued Contributor

Re: Load from google drive

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,

MVP
MVP

Re: Load from google drive

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

MVP
MVP

Re: Load from google drive

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

Employee
Employee

Re: Re: Load from google drive

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);

Employee
Employee

Re: Re: Load from google drive

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

Community Browser