Upgrade to ES1.20.xx from an earlier version

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.

Like   Don't Like © 2017 Mergetool.com. All rights reserved.

Related resources

Download software from Mergetool.com