Question

How to find the EntryID using a physical file path

Laserfiche

Updated two days ago

asked on July 3

Dears,

Regarding one of the Laserfiche files in the repository, I have an antivirus alert.

To check, I need to locate the EntryID.

How is this possible?

The file path is this:

D:\\LFRepositories\\MainRep\\DEFAULT\\DEFAULT000008\\e00\\00\\04\\00000412

0 0

Answer

APPROVED ANSWER SELECTED ANSWER

replied on July 3

What Bill said (mostly). Take the number in the file name and put it into Windows Calculator in Programmer mode to convert it from hex to decimal

Since the folder name starts with "e" (" e00"), that's an electronic document component, so you need to look it up in the TOC table directly.

SELECT tocid, name
FROM toc
WHERE edoc_storeid = 1042

If there was no "e" in the folder name, it would be an individual image page in a document and you'd want to look it up in the DOC table instead. But since those page storeIDs are assigned per volume, there is a possibility of multiple hits, so further filtering by volume name would be needed.

SELECT tocid, name 
FROM toc 
WHERE tocid IN (SELECT tocid FROM doc WHERE storeid = 1042)
AND vol_id IN (SELECT vol_id FROM vol WHERE vol_name = 'DEFAULT000008')

4 0

Replies

replied on July 3

The part of the filename after the zeros is a hexidecimal number, which in this case resolves to decimal 1042. That is the StoreID in the Doc table, which in turn links to the EntryID.

2 0

APPROVED ANSWER SELECTED ANSWER

replied on July 3

What Bill said (mostly). Take the number in the file name and put it into Windows Calculator in Programmer mode to convert it from hex to decimal

Since the folder name starts with "e" (" e00"), that's an electronic document component, so you need to look it up in the TOC table directly.

SELECT tocid, name
FROM toc
WHERE edoc_storeid = 1042

SELECT tocid, name 
FROM toc 
WHERE tocid IN (SELECT tocid FROM doc WHERE storeid = 1042)
AND vol_id IN (SELECT vol_id FROM vol WHERE vol_name = 'DEFAULT000008')

4 0

replied two days ago

Thanks Miruna - Nicely illustrated, and good correction. I assumed that was an image. Those "e"s will get you.

0 0

You are not allowed to follow up in this post.

Question

Question

How to find the EntryID using a physical file path

Answer

Replies

Sign in to reply to this post.