Focal Point
[Workaround] Red X when synching owners

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/87810325

March 20, 2009, 03:55 PM
Mighty Max
[Workaround] Red X when synching owners
Working with PMF 5.12

When I try to sync owners. I still get a bunch of Red Xs.

I added myself to the group "administrato" in MR User Administration.
The group "administrato" is member of the domain "Performance Management Framework"

From page 211 of the PMF Manual.
"Red X. User is in the Owners table, but needs to have access setup in the Performance Management Framework MRE domain."

I have the access setup correctly.
Am I missing something?

This message has been edited. Last edited by: Mighty Max,


WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
March 20, 2009, 05:47 PM
Mighty Max
Tracked the problem down to PMF dumping MRE users into a CSV file and then using that CSV file to sync MRE users with PMF.

The csv file is located in the application folder pmfdata and is named mr_users.csv.

Our MRE user are named in the following format "Last Name, First Name".
The "," messes up the sync process in PMF.
The quick fix is to remove the ",".
However, this causes PMF to have the First Name and Last Name be switched around.

I am looking into the fexes that build the csv file for a possible workaround.


WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
March 23, 2009, 08:02 AM
Clinton Side-Kick
Max,
Any particular reason for creating your MRE User id's with the format "Last Name, First Name", apart from keeping them unique?
Just curious


--------------------------------------------------------------------------------
prod: WF/AS 8.2.05; OmniGen;
In FOCUS since 1991
March 25, 2009, 11:19 AM
Mighty Max
The reason that MRE users are in the format "Last Name, First Name" is because that is how the environment was set up.
I would rather not rename each user.
I was able to fix the problem by modifying a fex.

The fex "pmf_users_sync_form.fex" needs to be modified.
Make a copy of "pmf_users_sync_form.fex" and name it "pmf_users_sync_form.fex.original".
The fex uses some javascript functions to create mr_users.csv.
All I did was modify the functions to add double quotes when creating the .csv file.
The functions I modified were docInit() and syncUsers().
Both functions use a variable named userInfo.
Modify userInfo so that when it gets assigned a value double quotes are included.
There were four places in the fex where I modified userInfo.

EXAMPLE

Before
userInfo = mrUsers[x][0] + "," +
           mrUsers[x][1] + "," +
           mrUsers[x][2] + "," +
           mrUsers[x][3] + "," + x + ",N" +;

After
userInfo = "\"" + mrUsers[x][0] + "\"" + "," +
           "\"" + mrUsers[x][1] + "\"" + "," +
           "\"" + mrUsers[x][2] + "\"" + "," +
           "\"" + mrUsers[x][3] + "\"" + "," + 
	  "\"" + x + "\"" + "," + 
           "\"" + "N" + "\"";


  
mr_users.csv - Before
userID,Last Name, First Name,email@address.com,consumer,0,N

mr_users.csv - After
"userID","Last Name, First Name","email@address.com","consumer","0","N"



WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
March 25, 2009, 05:41 PM
EricH
Just a reminder to everyone. If you make changes to delivered PMF code, we recommend that you put your revised versions in a different directory; otherwise your changes will be overlaid when you upgrade to a new PMF release. We recommend that you use a directory named pmfcustom so there will be a common location across all customers.

Note that there are a few exceptions to this recommendation. There are some programs which must stay in the mainstreet folder, for example, pmf_lib.js, mainstreet.css, etc. And to answer the obvious next question, no we do not currently have a complete list of all such programs.