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.

44 Replies
Clever_Anjos
Employee
Employee

QV 11.2 SR5 here too, if it helps

Clever_Anjos
Employee
Employee

Check how you published your document. It HAS to be public

Clever_Anjos
Employee
Employee

I don´t know. I always used my @gmail.com account. Maybe sharing from your company to your gmail account and then publishing?

julian_rodriguez
Partner - Specialist
Partner - Specialist

Hello Clever,

Thanks for the script, but I'm running it and I get this error message: "Field not found - <Timestamp>". I mean, WHAT?... Qlikview is not recognizing the Timestamp function?

Error Timestamp.JPG.jpg

Now, I changed the script code to:

GoogleData: 

LOAD 

  *

FROM [https://docs.google.com/spreadsheet/pub?hl=en&hl=en&key=0Augcl9bj_QQJdGlCMThXY0k5eHBjaVNNX1Byak1FVWc...

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

And when reloading it, the error changes and it's even weird Error: File extdata.cpp, line 2897

It seems a problem with a Qlikview Library, don't you think so?

Error Reload.JPG.jpg

Well, I don't really know why I can't get the same behavior as you. It's a shame.

Julian

Clever_Anjos
Employee
Employee

Weird.

Which version of QV are you using?

Can you open that URL into your Internet Explorer?

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

about the timestamp error it seems that a parenthesis was misplaced. And the second error, it could be the version of QlikView, I've seen that using QV Desktop 11.2 SR5 may lead to this error.

regards

Clever_Anjos
Employee
Employee

I´m using 11.20 SR5 here and it´s working

julian_rodriguez
Partner - Specialist
Partner - Specialist

Absolutely weird Clever,

I'm using QV 11.2 SR5 (public release).

And yes, I can open the file from any browser.

I think that it's a problem with my computer (either SO or any component), because I have tried with another computer and your solution works fine.

It's so sad and frustrating.

Regards...

Not applicable
Author

Hi Steve

is there a possibility to test QV Source (free trial) with Personal Edition?

Best regards

Chris

Clever_Anjos
Employee
Employee

Are you computer behind a firewall? Is it possible to test without any restriction?