You are viewing limited content. For full access, please sign in.

Question

Question

How to find the EntryID using a physical file path

asked one day ago

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
replied one day ago

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')

 

3 0

Replies

replied one day ago

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
replied one day ago

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')

 

3 0
You are not allowed to follow up in this post.

Sign in to reply to this post.