Some changes to the data structure of Easy Security have been done in ES1.20.xx,
requiring a conversion of some data. This can all been accomplished from the application by removing
values in deleted fields and preparing the data before importing the new objects.
The copy of data in Field Level and Data Security is the main area of changes.
In earlier versions, data was copied from a company.
Now the data is pushed from a central company (the install company).
Before upgrading to ES1.20.xx, ensure that all data in the tables "Field Level Security Code" and "Data
Security Code" is copied to the install company.
Deleted fields in ES1.20.xx
Table Number | Table Name | Field No. | Field Name |
14123801 | ES FLADS Setup | 14 | Copy Field Level Sec from Comp |
14123801 | ES FLADS Setup | 15 | Copy Data Security from Comp. |
14123801 | ES FLADS Setup | 17 | Last Copy Date/Time |
14123801 | ES FLADS Setup | 18 | Last Copy by User |
14123802 | ES Source Table Setup | 13 | Copy Field Level Sec from Comp |
14123802 | ES Source Table Setup | 14 | Copy Data Security from Comp. |
14123802 | ES Source Table Setup | 15 | Created Date/Time |
14123802 | ES Source Table Setup | 16 | Created By |
14123802 | ES Source Table Setup | 17 | Modified Date/Time |
14123802 | ES Source Table Setup | 18 | Modified By |
14123802 | ES Source Table Setup | 27 | Last FldLvl Sec Copy Date/Time |
14123802 | ES Source Table Setup | 28 | Last Fld Lvl Sec. Copy by User |
14123802 | ES Source Table Setup | 29 | Last Data Sec. Copy Date/Time |
14123802 | ES Source Table Setup | 30 | Last Data Sec. Copy by User |
14123802 | ES Source Table Setup | 31 | User Security Manager User ID |
14123802 | ES Source Table Setup | 32 | Field Level Sec. Mgr. User ID |
14123802 | ES Source Table Setup | 33 | Data Security Manager User ID |
14123803 | ES Field Level Security Code | 13 | Copy from Company |
14123803 | ES Field Level Security Code | 14 | Last Copy Date/Time |
14123803 | ES Field Level Security Code | 15 | Last Copy by User |
14123804 | ES Data Security Code | 13 | Copy from Company |
14123804 | ES Data Security Code | 14 | Last Copy Date/Time |
14123804 | ES Data Security Code | 15 | Last Copy by User |
The conversion tool resets all fields to blank in all companies before importing the latest version of the Easy Security objects.
Refer to the Documentation for the processes in Easy Security
Like


© 2015 Mergetool.com. All rights reserved.
