topic Re: Loading timestamps in QlikView

Loading timestamps

Fri, 26 Dec 2014 10:58:49 GMT

Hi,

Is it possible to load only the timestamps of all the files present in a folder without loading it's data?

Re: Loading timestamps

anbu1984 — Fri, 26 Dec 2014 11:08:55 GMT

Do you mean timestamp in filenames?

Re: Loading timestamps

Fri, 26 Dec 2014 11:21:38 GMT

Hi Asma,

Below VB Script may be of help.

Function ShowFileAccessInfo(filespec)

Dim fso, a, s

Set fso = CreateObject("Scripting.FileSystemObject")

Set a = fso.GetFile(filename)

msgbox f.DateLastModified

End Function

You can use this in macro and trigger as per requirement. Small change is required e.g. giving path of the file and so.

Thanks & Regards

Suhas Gupta

Re: Loading timestamps

Fri, 26 Dec 2014 11:54:10 GMT

Yes timestamp of a file

Re: Loading timestamps

varunjain — Fri, 26 Dec 2014 12:03:40 GMT

Is the timestamp appended with the Filename?

Re: Loading timestamps

anbu1984 — Fri, 26 Dec 2014 12:07:51 GMT

You can use appropriate function to retrieve timestamp from filenames. What is the format of filenames?

LOAD SubField(FileName(),'_',2) As Ts

FROM

(ooxml, embedded labels, table is Sheet1) Where RecNo() < 2 ;

Re: Loading timestamps

Fri, 26 Dec 2014 12:09:26 GMT

No, the file timestamp is not appended to the file name.

Re: Loading timestamps

anbu1984 — Fri, 26 Dec 2014 12:11:12 GMT

Then which file timestamp you need? Last modification timestamp?

Re: Loading timestamps

Anonymous — Fri, 26 Dec 2014 12:19:41 GMT

Try something like this

LET vPath = Replace (DocumentPath (), '\' & DocumentName (), '')&'\QVDs';

trace $(vPath);

FOR Each File in filelist ('$(vPath)\*.*')

trace $(File);

fileTable:

LOAD '$(File)' as Name,

FileSize( '$(File)' ) as Size,

FileTime( '$(File)' ) as FileTime

autogenerate 1;

TRACE folderpath-- $(vPath) . filename-- $(File);

NEXT File

Which was pasted from this thread

http://community.qlik.com/message/649037#649037

Re: Loading timestamps

Fri, 26 Dec 2014 12:55:16 GMT

I have used filetime() function to get the filestamps of all the files present in the folder. But the problem is while loading the timestamp of all the files, it also loads the data present in those files. In the script execution box, i am able to see the number of lines fetched. How can i load timestamp without loading all the rows

Re: Loading timestamps

anbu1984 — Fri, 26 Dec 2014 13:02:18 GMT

LOAD filetime() As Ts

FROM

(ooxml, embedded labels, table is Sheet1) Where RecNo() < 2 ;

Re: Loading timestamps

MarcoWedel — Sat, 27 Dec 2014 12:21:21 GMT

LOAD DISTINCT

Filename() as Filename,

Filetime() as Filetime

FROM path\*.*;

Re: Loading timestamps

prieper — Sat, 27 Dec 2014 20:39:50 GMT

This is not correct, please check reply from Marco.

Peter