Copying an Access Type Scoreboard

2008-11-06T06:47:19Z

Htabepour: New page: A simple workaround to this is to extract the rows from the default scoreboard and then change the access type to the new access type before reloading. Here's an example how. Assume the ...

A simple workaround to this is to extract the rows from the default scoreboard and then change the access type to the new access type before reloading. Here's an example how.

Assume the default scoreboard you would like is from the ‘Administrator’ access type.
Assume the new access type is called 'Help Desk'

1. Assume the 'Administrator' access type has an id of 2402. You can find this out from.

pdm_extract -f "select id from Access_Type where sym='Administrator'"

2. To extract the relevant data related to the scoreboard.
pdm_extract -f "select expanded, factory, label, last_mod_by, last_mod_dt, obj_persid, parent, query, query_set, query_type, sequence from User_Query where obj_persid='acctyp:2402'" > score_out.txt

3. Take a backup of existing table for reference.

pdm_extract -f "select * from User_Query where obj_persid='acctyp:2402'" > score_out2.txt

4. Find the id of the new access type 'Help Desk'

pdm_extract -f "select id from Access_Type where sym='Help Desk'"

(For this example, we will use an id of 400001 for the new access type 'Help Desk')

5. Edit the score_out.txt file produced and change any occurrence of acctyp:2402 to the new access type value of acctyp:400001. Save the modified output to a new file score_out3.txt

6. Load in the new data

pdm_load -v -i -f score_out3.txt

Now comes the hard part of parent relationships.

7. Run..

pdm_extract -f "select id, parent, sequence from User_Query where obj_persid='acctyp:2402'" > par1.txt

8. Run..

pdm_extract -f "select id, parent, sequence from User_Query where obj_persid='acctyp:400001’" > par2.txt

Open both these files and place them side by side.

9. Comparing par1.txt and par2.txt modify par2.txt using "find/replace" so the reference to the id's in the second parent column match the new ids listed in the par2.txt file keeping par1.txt as a reference to the relationship.

Here is an example.
In par1.txt.

TABLE User_Query
id parent sequence
{ "7872" ,"0" ,"100" }
{ "7966" ,"7872" ,"200" }
{ "7967" ,"7872" ,"300" }
{ "7800" ,"7872" ,"400" }
{ "7801" ,"7872" ,"500" }
{ "7802" ,"7872" ,"600" }
{ "7803" ,"7872" ,"800" }
{ "7804" ,"7872" ,"800" }
{ "8051" ,"7872" ,"900" }
{ "8052" ,"7872" ,"1000" }
{ "7805" ,"7872" ,"1100" }
{ "7806" ,"7872" ,"1200" }
{ "7807" ,"7872" ,"1300" }
{ "7808" ,"7872" ,"1400" }
{ "7809" ,"7872" ,"1500" }
{ "7810" ,"7872" ,"1600" }
{ "7811" ,"7872" ,"1700" }
{ "7812" ,"7872" ,"1800" }
{ "7813" ,"7872" ,"1900" }
{ "7968" ,"0" ,"2000" }
{ "7969" ,"7968" ,"2100" }
{ "42000" ,"7969" ,"2150" }
{ "7970" ,"7969" ,"2200" }
{ "7971" ,"7969" ,"2300" }
{ "7972" ,"7969" ,"2400" }
{ "7973" ,"7968" ,"2500" }

In par2.txt.

TABLE User_Query
id parent sequence
{ "400365" ,"0" ,"100" }
{ "400366" ,"7872" ,"200" }
{ "400367" ,"7872" ,"300" }
{ "400368" ,"7872" ,"400" }
{ "400369" ,"7872" ,"500" }
{ "400370" ,"7872" ,"600" }
{ "400371" ,"7872" ,"800" }
{ "400372" ,"7872" ,"800" }
{ "400373" ,"7872" ,"900" }
{ "400374" ,"7872" ,"1000" }
{ "400375" ,"7872" ,"1100" }
{ "400376" ,"7872" ,"1200" }
{ "400377" ,"7872" ,"1300" }
{ "400378" ,"7872" ,"1400" }
{ "400379" ,"7872" ,"1500" }
{ "400380" ,"7872" ,"1600" }
{ "400381" ,"7872" ,"1700" }
{ "400382" ,"7872" ,"1800" }
{ "400383" ,"7872" ,"1900" }
{ "400384" ,"0" ,"2000" }
{ "400385" ,"7968" ,"2100" }
{ "400386" ,"7969" ,"2150" }
{ "400387" ,"7969" ,"2200" }
{ "400388" ,"7969" ,"2300" }
{ "400389" ,"7969" ,"2400" }
{ "400390" ,"7968" ,"2500" }

After modifying par2.txt .

TABLE User_Query
id parent sequence
{ "400365" ,"0" ,"100" }
{ "400366" ," 400365" ,"200" }
{ "400367" ," 400365" ,"300" }
{ "400368" ," 400365" ,"400" }
{ "400369" ," 400365" ,"500" }
{ "400370" ," 400365" ,"600" }
{ "400371" ," 400365" ,"800" }
{ "400372" ," 400365" ,"800" }
{ "400373" ," 400365" ,"900" }
{ "400374" ," 400365" ,"1000" }
{ "400375" ," 400365" ,"1100" }
{ "400376" ," 400365" ,"1200" }
{ "400377" ," 400365" ,"1300" }
{ "400378" ," 400365" ,"1400" }
{ "400379" ," 400365" ,"1500" }
{ "400380" ," 400365" ,"1600" }
{ "400381" ," 400365" ,"1700" }
{ "400382" ," 400365" ,"1800" }
{ "400383" ," 400365" ,"1900" }
{ "400384" ,"0" ,"2000" }
{ "400385" ," 400384" ,"2100" }
{ "400386" ," 400385" ,"2150" }
{ "400387" ," 400385" ,"2200" }
{ "400388" ," 400385" ,"2300" }
{ "400389" ," 400385" ,"2400" }
{ "400390" ," 400384" ,"2500" }

10. Save the par2.txt as file par3.txt

11. Load the new par3.txt file back to update the relevant rows for the new access type.

pdm_load -v -f par3.txt

SDU - User contributions [en]

Copying an Access Type Scoreboard