topic Re: How to read files in a directory in QlikView

How to read files in a directory

Tue, 19 Aug 2014 17:40:21 GMT

Hello guys,

I have a directory that has several images and their name is the product code.

How do I read all images to the directory?

Re: How to read files in a directory

Wed, 27 Aug 2014 18:51:59 GMT

UAU,

The entire community could not answer me how do I do it?

I'm not believing.

Has a solution that is load frame by frame but believe QlikView is better than that.

Re: How to read files in a directory

rwunderlich — Wed, 27 Aug 2014 19:06:40 GMT

See BUNDLE INFO LOAD in he Help.

-Rob

Re: How to read files in a directory

Wed, 27 Aug 2014 19:15:32 GMT

Rob,

This will help me much need something that is inserted when new images he can read this form and I need to always be updating the CSV files.

is to solve?

Re: How to read files in a directory

MarcoWedel — Wed, 27 Aug 2014 21:27:18 GMT

can you post a sample and describe how you would like to use those images?

thanks

regards

Marco

Re: How to read files in a directory

Wed, 27 Aug 2014 21:48:17 GMT

Discover how I can do.

I'll run a BAT every day where the result will be a text file containing the names of all the files of that folder.

With that the Qlikview only need to read this file.

With its hint of .cvs can get this result.

Thank you very much.

Re: How to read files in a directory

Wed, 27 Aug 2014 22:00:34 GMT

Hi,

Well .. I try creating a Catalog with the ProductID and concatenate it the path at the beginig and then concatenate at the end the image format (jpg, png...) something like this:

LET vImagePath = 'C:\MyDocuments\Project1\Images\';

LET vImageFormat = '.jpg';

MyImageCatalog:

LOAD

ProductID, // to link with my model

'$(vImagePath)' & ProductID & '$(vImageFormat)' as ImageProduct

Resident ProductTable;

Finally you can use ImageProduct field in a Text Box or Straight Table specifing Representation = Image.

Best regards.

Re: Re: How to read files in a directory

Wed, 27 Aug 2014 22:20:30 GMT

I do not understand how you did.

I am posting here an example of what I need.

A file with the images.

If you can post a qvw it'll be very grateful.

About .bat did not work, I'm still working on it.

Re: Re: How to read files in a directory

Wed, 27 Aug 2014 22:50:20 GMT

It was hard, but I get.

Attached hereto and print the file.