Reseting personal profiles to the base profile

In Enterprise Explorer, you can navigate to the base profile to accomplish this.

Presentation object layouts can be found with a pattern like this:

User/Windows/Features/frmCustomerOrder

(You may want to start on the “Layout” branch under the presentation object, which will limit the scope to just the screen layout without disturbing the user’s latest search condition.)

Right-mouse-click on the folder with the presentation object name, then select “Delete Values in Profiles”.

On the left side of the screen, under “Personal Profiles”, you have some options depending on your version:

• “For users in User Group”
• “For users in Company”
• “For users on Site”
• “For users with Language”
• “Has Base Profile ‘’”

I’ve resorted to doing most of my profile maintenance in SQL for this reason, but be prepared to fully own your mistakes if you decide to do the same.

In Enterprise Explorer, the “Layout” branches are masted by the keys found in each OutlineNames key. Each of these entries is stored in the database as a comma-separated string of values. The position within the OutlineNames CSV string gives you the meaning of each of the values inside the CSV strings for Left, Top, Width, Height, Visible, and the enabled tabs.

If the base profile OutlineNames doesn’t match your personal profile OutlineNames or can’t be sensibly remapped, it’ll become corrupt.

If the profile OutlineNames doesn’t match what the application is expecting, it’ll become corrupt. (IFS doesn’t deliver profile uplifts when they deliver updates and extensions.)

If an entry is added to OutlineNames without shifting the entries appropriately, such as a new custom field, it’ll become corrupt.

Hi,

I solved this by scripting. It was not enough to just delete the profile entries in some cases, so I ended up copying profile entries from the base profile to all the personal profiles. 

I made a query for fetching the profile entries of interest.  

select
 cp.owner,
 cpv.* from fndrr_client_profile cp 
join fndrr_client_profile_value cpv on cpv.profile_id = cp.profile_id
where ( 
cpv.profile_section like '%tbwPartSerial%' or
dbms_lob.instr(cpv.profile_binary_value, 'find custom search by title or other values') >=1 o
)

Profile entries are not in First Normal Form. They’re concatenated in CSV format for IEE or in JSON format for Aurena.

If you add a field, it will need to be added to the OutlineNames entry. All the other entries like Left, LeftLabel, Top, TopLabel, etc. will need to be shifted by the same degree.

Old:
OutlineNames: FIELD_A,FIELD_B,FIELD_D
Top: 100,120,140

New, broken by the system:
OutlineNames: FIELD_A,FIELD_B,FIELD_C,FIELD_D
Top: 100,120,140

(This moves the value 140 to FIELD_C and leaves FIELD_D with no value.)

New, fixed by you:
FIELD_A,FIELD_B,FIELD_C,FIELD_D
Top: 100,120,160,140