Accessing non-QV file metadata on load

[#1]

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.

[deepakk]

hi,

You can use

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

and

filetime( 'xyz.xls' )

[gauravkhare]

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.

[#4]

Thanks Deepak.

FileTime() is exactly what I was looking for.

[#5]

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.

[#6]

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

[#7]

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