topic Download/store PDF files using QlikView ?! in QlikView

Download/store PDF files using QlikView ?!

ivan_will — Fri, 08 Jul 2011 07:41:37 GMT

Hi all,

I want to store some PDF files automatically from a web site (apprx. 20n) but using QlikView for that ?

Like: Store <table_name> into C: ... .pdf

Is it possible ?

Or is it possible to load that files into a QlikView file like bundle load ....?

Download/store PDF files using QlikView ?!

Miguel_Angel_Baeyens — Fri, 08 Jul 2011 07:59:01 GMT

Hi,

PDF is not a format for the STORE function in QlikView so far. THe only two values allowed are TXT and QVD. The Publisher license, among other things, allows you to create and distribute PDF files into shared folders.

I don't know what a bundle load would help here. It is used to get external binary data (say, images) into QlikView document, so you don't need any longer the external files and visualize them through expressions or the info button.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Download/store PDF files using QlikView ?!

ivan_will — Fri, 08 Jul 2011 08:16:15 GMT

Hmmm,

Is it possible then using some macro to dawnload them ? (any simple example for this if it's possible)

And after that "bundle load" them in a qlikview file ?

I have read about budle load for pdf and word files into qlikview (called BLOBS) but only when you use ODBC connection.

Download/store PDF files using QlikView ?!

Miguel_Angel_Baeyens — Fri, 08 Jul 2011 08:41:24 GMT

Hello Ivan and sorry for not getting the issue properly,

If you want to download several PDF files, I'd recommend you to do using the Windows Task Scheduler instead of using QlikView. But yes, since macros allow the execution of VBScript you can create a macro to connect to the server where they are (ftp or something) and download them.

But the part that is getting me wrong is what you want to do later on with those PDF files. Do you want to display them in your QlikView document?

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Download/store PDF files using QlikView ?!

ivan_will — Fri, 08 Jul 2011 08:50:26 GMT

Actually,

now I am testing what files can I insert in a QV app. Till now I have made pics and sound files in it.

Now I want pdf and doc files and just testing.

If I can visualize those pdfs files will be great but think that impossible.

Regards,Ivan

Download/store PDF files using QlikView ?!

IAMDV — Fri, 08 Jul 2011 08:57:03 GMT

Ivan – I am following this post and I have similarrequirement to show some pictures & music files. Please can you share anapplication to learn? Or can you explain on how you got this working..?

Thanks - DV

Download/store PDF files using QlikView ?!

ivan_will — Fri, 08 Jul 2011 09:20:53 GMT

thats the codes:

//for the pics

Plus:

LOAD * INLINE [

Plus_Pic,

http:// .gif

];

Bundle load Plus_Pic,Plus_Pic Resident Plus;

//for the sounds

MainSounds:

LOAD * INLINE [

mainsound,dir,name

attemptstart.wav,$(SoundPathMain), attemptStart

start.wav,$(SoundPathMain), start

greetings.wav,$(SoundPathMain), greetings

];

Bundle load mainsound,dir&mainsound Resident MainSounds;

Download/store PDF files using QlikView ?!

IAMDV — Fri, 08 Jul 2011 09:22:52 GMT

Ivan – Thanks so much mate. I’ll check this out and comeback to you for any further questions.

Cheers - DV

Download/store PDF files using QlikView ?!

Miguel_Angel_Baeyens — Fri, 08 Jul 2011 10:20:20 GMT

Hello Ivan,

You can visualize them provided you have a PDF reader installed into your computer or any program registered to open PDF files. If you want to show them within the QlikView document you will need to add an OCX control that allows you to do that. I'm pretty sure it's possible and that these controls exist, although I've never used them.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Download/store PDF files using QlikView ?!

ivan_will — Fri, 08 Jul 2011 15:03:33 GMT

Other ideas ?

Thanks!

Re: Download/store PDF files using QlikView ?!

VivenReddy — Wed, 27 Oct 2021 19:13:26 GMT

Did you manage to find a solution Ivan? I am also trying to embed a PDF doc within Qlikview but cannot seem to find a solution. The solution that @mabaeyens proposed using OCX is not making sense to me. From what I've read about OCX, its used to embed Qlikview into other apps. I havent found any documentation suggesting that OCX can be used to embed other apps into Qlikview.

If someone has a solution please assist. Thanks.