Mapping FileNet content files on the filesystem to their metadata in the database

Does anyone know how FileNet relates metadata from the Element table to the content files in the individual shelves?

There is what appears to be the unique identifier in the Element.ENAME field, but that doesn't match the syntax of the filenames on the file system. Those file names are similar to __2pq2aa_.001

There is an Ename_KW table that maps the ENAME to a KW field, but it's not known where that KW field is used.

Nowhere can we find out how the filename is mapped to the metadata. If anyone has any leads for us, they would be much appreciated.

Thanks!
LVL 8
Rsulliv1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rsulliv1Author Commented:
it appears that there are some utility apps that can decipher the encoding, but I would still like to know the encoding algorithm, if possible.

The utilities were file2id and id2file.

Thanks again!
0
Rsulliv1Author Commented:
The filename is base 36 encoded. There doesn't appear to be any version information in the encoded filename although the file2id does output version information.

I'll close this thread, but I hope it helps someone else in the future!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Content Management

From novice to tech pro — start learning today.