Converting FileNet ID's based on Oracle/DB2 from byte reversal format to GUID [and vice-versa]

If you have been working on FileNet based on various database, you would be familiar that MSSQL stores the FileNet GUID is the same exact format as what can be seen in FileNet Enterprise Manager using the datatype 'uniqueidentifier'

But when using DB2 or Oracle, the data related to GUID is stored in a byte reversal format. If you are not really familiar with it, there is a technote available from IBM explaining this and the process to get the GUID out of the byte reversed format.

http://www-01.ibm.com/support/docview.wss?uid=swg21587420

I have attached a small html file which can perform this operation in bulk, for use during testing or for any other reason where you might find it useful. It can also can perform GUID to hexadecimal format. 

• Download the html file locally on your machine, open it in your favorite browser. 

GUIDv3.zip

• Copy the byte reversed string from the database

• Paste the byte reversed string into the text area, one per line.

• Click the 'Get GUID' button to get the GUID format of the byte reversed string.

Use the GUID to search within FEM, ACCE or using FileNet API's.

You can also used the GUID string from FEM/ACCE or any other source and convert them to a hexadecimal byte reversed format using the same utility for use in SQL script. You can also have a mix of these values for conversion.