topic Re: File functions not working in QlikView

File functions not working

martynlloyd — Wed, 22 Feb 2017 11:26:45 GMT

Hi,

I have this script below, FileSize and FileTime are returning data, but FilePath, FileDir, FileExtension are not returning anything - what is wrong?

sub
DoDir (Root)
for each Ext in 'bmp', 'jpg', 'png', 'tif'

for each File in filelist (Root&'\*.' &Ext)
LOAD
'$(File)' as [Image Name],
FilePath('$(File)') as [Image Path],
FileDir('$(File)') as [Image Dir],
FileExtension('$(File)') as [Image Ext],
FileSize('$(File)') as [Image Size],
FileTime('$(File)') as [Image Time],
Year(Date(FileTime('$(File)'))) as [Year]

autogenerate 1;

next File
next Ext

for each Dir in dirlist (Root&'\*' )
call DoDir (Dir)
next Dir

end sub

Re: File functions not working

sasikanth — Wed, 22 Feb 2017 11:36:45 GMT

May be this

sub

DoDir (Root)
for each Ext in 'bmp', 'jpg', 'png', 'tif'

for each File in filelist (Root&'\*.' &$(Ext))

LOAD
'$(File)' as [Image Name],
FilePath('$(File)') as [Image Path],
FileDir('$(File)') as [Image Dir],
FileExtension('$(File)') as [Image Ext],
FileSize('$(File)') as [Image Size],
FileTime('$(File)') as [Image Time],
Year(Date(FileTime('$(File)'))) as [Year]

autogenerate 1;

next File
next Ext

for each Dir in dirlist (Root&'\*' )
call DoDir (Dir)
next Dir

end sub

Re: File functions not working

marcus_sommer — Wed, 22 Feb 2017 11:50:11 GMT

You need to use these functions without a parameter like:

filepath() as [Image Path]

Another way to get these informations could be to use string-functions like subfield() or '$(EXT)' for the file-extension.

- Marcus

Re: File functions not working

martynlloyd — Wed, 22 Feb 2017 16:15:58 GMT

Marcus,

I tried that first, that doesn't work either.

Regards,

Marty.

Re: File functions not working

marcus_sommer — Wed, 22 Feb 2017 16:28:09 GMT

If I look closer on your example I see now that you didn't load from a file else per autogenerate and therefore you couldn't use those file-functions. Instead of them use:

...

'$(File)' as [Image Path],

subfield('$(File)', '.', 2) as [Image Ext],

mid('$(File)', 1, index('$(File)', '\', -1) - 1) as [Image Dir]

...

- Marcus

Re: File functions not working

martynlloyd — Wed, 22 Feb 2017 16:36:26 GMT

Thanks Marcus ,

But how come the FileSize and FileTime worked?

Regards,

Marty.

Re: File functions not working

marcus_sommer — Wed, 22 Feb 2017 16:39:05 GMT

No, I meant only those file-functions which didn't work - by filetime() and filesize() you could further use your previous and working approach.

- Marcus