File path in vault
Hi,
I am looking to identify path to actual files in the ifs vault. I noticed that in most cases, the FILES table has a ifs_filepath that shows the relative path to the file. However, in the past we have used dfm (which has since been disabled), and in cases where the files are on multiple locations, the file path is null in the database. Is it stored elsewhere? Agile does allow to download the Fe in the UI.
Hi Anand,
Same was the case with me, however when i execute the following query :
Select * from file_info where IFS_FILEPATH is null
I can see entry in the HFS_FILEPATH column. Generally the location specified here resides inside the Custom filepath set for iFS.
Just verify if your iFS filepath has any other location specified for Vault_Type =”Custom”. If you go to that path probably you can see those files. I was able to see for myself.
Regards,
Arif
I have only ever seen file path information in IFS_FILEPATH (when the file is located in the normal file vault) and HFS_FILEPATH (when the file is located in a custom file vault). I have never seen where EIFS_FILEPATH or FILE_PATH were filled in.
You can also calculate the relative file path using the ID of the file. Drop off the 2 rightmost/least significant digits off the file ID, zero-pad on the left out to 9 digits, and then separate into 3-digit directory names.
Thus, 4833369 would be “48333”, then “000048333”, and then 000 48333
and 81096253 would be “810962”, and then “000810962” and then 00810962.