topic Accessing non-QV file metadata on load in QlikView

Accessing non-QV file metadata on load

Mon, 24 Jan 2011 12:14:05 GMT

When loading data from a non .QVD file - for example an Excel spreadsheet - is it possible to access the file's metadata?

In particular I'd like to be able to access and display the file's Last Modified date.

This would give the user confidence that the data they're viewing is the most up to date.

Accessing non-QV file metadata on load

deepakk — Mon, 24 Jan 2011 12:17:52 GMT

hi,

You can use

QvdCreateTime('C:\MyDir\MyFile.qvd')

and

filetime( 'xyz.xls' )

Accessing non-QV file metadata on load

gauravkhare — Mon, 24 Jan 2011 12:23:59 GMT

Dear SparkleHorse,

what will you get by accessing the matadata info?????????????????

Actually how this idea came into your mind!

you want to tell the users the last modified time. Then simply do- Take a text object and write-last Modified date&'time(reload(time))'.. this will give a clear picture about the last reload time.

Accessing non-QV file metadata on load

Mon, 24 Jan 2011 12:33:21 GMT

Thanks Deepak.

FileTime() is exactly what I was looking for.

Accessing non-QV file metadata on load

Mon, 24 Jan 2011 12:45:34 GMT

Gaurav,

I dont want to display the last time the QVD was created or loaded - this is performed every night. I want to display the last time the source file was updated.

Deepak has given me the answer I needed.

Accessing non-QV file metadata on load

Mon, 24 Jan 2011 14:47:07 GMT

I now have a slight problem with this.

If I load from an .XLS file from a network folder everything works fine and I can see the Last Modified Date by using the FileTime() method.

However, my problem is that the .XLS file I am loading from is hosted in Sharepoint and is accessed via a URL (rather than a UNC path). In this scenario I am not getting any information back from FileTime(). I have tried two methods:

1) LOAD *, FileTime() AS LastModifiedTime FROM '<url>' (biff);

2) LET lastModifiedTime = FileTime('<url>');

Is this a known issue? Does anyone have any suggestions?

Thanks

Jon

Re: Accessing non-QV file metadata on load

Thu, 12 Sep 2013 09:04:19 GMT

Hello Jon,

I am having exactly the same issue: I get a NULL value when trying to get the last modified file from Sharepoint.

Seems as if "Filetime()" function only works for local files, but not for files stored in a server.

Does anybody managed to obtain this info by other ways?

Thanks!

Jon Ander