Company: Link Technologies
Case No: L13116. Project: 15.70: LinkSOFT Version 15.70
Logged By: Sanjay (Link Technologies) on 26 Feb 2025 02:47PM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 5.00 (Weight: 16.00)
Assigned To: Vineet (Link Business Solutions)
Circulation: Sanjay, Vineet
Resolve By: Monday, 30 June 2025 02:47 PM [96 days since logged date]
Status: Closed
Subject: Data Scramble Utility to handle Client Database sent to Link for Analysis
Summary:    We need a "Data Scramble" or "Randomise" Utility to handle Client Database sent to Link for Analysis.
Audit Notes:Edited by sanjay on 15/05/25 09:33. Edited by sanjay on 15/05/25 09:27. Edited by sanjay on 05/03/25 10:59. Edited by sanjay on 05/03/25 10:59. Edited by sanjay on 05/03/25 10:59. Edited by sanjay on 05/03/25 10:57. Edited by sanjay on 03/03/25 13:09. 
03 Mar 202501:09PM Comment 1 by Sanjay (Link Technologies) ETC was changed from 26/02/2025 to 30/06/2025
05 Mar 202510:57AM Comment 2 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 14-03-2025 10:56 AM Time Taken: 2.00 Notes: Edited by sanjay on 05/03/25 11:06. Edited by sanjay on 05/03/25 11:04. 

Hi Vineet, there is already a utility that does this. (Refer to Case 12706).

See script in figure below:

Figure 1 - Data Randomize Script
EXEC LT_SAA_UTILITY_RandomizeData
    @Username = ''
      ,@Password = ''


05 Mar 202510:57AM Comment 3 by Sanjay (Link Technologies) Case L13116 removed from project 15.70
05 Mar 202510:59AM Comment 4 by Sanjay (Link Technologies) Case L13116 added to project 15.70
05 Mar 202511:03AM Comment 5 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 14-03-2025 10:59 AM Time Taken: 3.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 15.70

2. The following changes were made (Include Database object names, Program classes, and any other relevant information):

  1. Added parameter so we can recognize some data for the purpose of Diagnostics.
  2. See figure 1 below for Ful Randomize.
  3. Figure 2 does the same except it does not randomize "FIRST Names" and Company name so we can perform diagnostics with some data recognition.

3. Affected Areas:

  1. Existing Utility

4. The issue was caused by:

  1. Improvement

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation): Closure


Figure 1 - Randomise data Including FirstName

EXEC LT_SAA_UTILITY_RandomizeData

    @Username = ''

   ,@Password = ''

   ,@RandomiseName = 0


Figure 2 - Randomise data Excluding FirstName

EXEC LT_SAA_UTILITY_RandomizeData

    @Username = ''

   ,@Password = ''

   ,@RandomiseName = 1


If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L13116 in the subject line of all emails regarding this issue.

Document size: 6.2 KB
For call complaints, please contact the Managing Director of the company using this form