To allow the user data to be recovered, you must Convert the
User Personal Keys (UPK) to
Regular keys. The conversion allows you to successfully import the Regular Key into a later version of ePO.
IMPORTANT: If no user name is specified within the brackets, the keys can't be imported into any version of ePO. In this situation, the only option is to convert to Regular keys. User Personal Keys are listed under
Settings, User Personal Keys, FRP Key Management, in the Key Type column as
User ().
Convert the User Personal Keys to Regular keys via ePO:
- Click Edit in the FRP Settings header page.
- In the Edit Key window, select the Available as a regular key checkbox, then click OK.
- Each key type has a value in the ePO Database. The table name is dbo.EEFFKeys.
KeyType could be 1, 2, or 3
- Regular
- User ()
- Regular, User()
NOTES:
- Once the key is selected to be converted to a Regular key, the option can't be deselected,
- After you convert the keys to Regular key type, if it is shown as Regular, User (), it means it also can't be imported in another ePO Server.
- Log on to the SQL Server, and locate the ePO Database instance.
- Navigate to the dbo.EFFFKeys table, and select the rows in the KeyType column.

- Before you update the key, select the required Row, database, then click New Query.

- Execute the following query where AutoID is the unique number given to system and user:
select * from dbo.EEFFKeys where KeyType = 3 and AutoID = 20
- To covert the keys to Regular, run the following query:
update dbo.EEFFKeys set KeyType = 1 where AutoID = 20 and KeyType = 3
- When it is converted to a Regular key, it can be exported from one ePO Server and imported to a new ePO Server.
