Clayton Peacock

WHENCE PRODUCT_MAINTENANCE_REQUEST MASTER Had same issue master file was in FOCCACHE, above helped me.

Hi @J. J. See created by @Patrick Huebgen once you have the connection setup to the client repository navigate to the wfcsampl/list_repositorytree.fex(samples generated for you by the adapter). Running this list_repositorytree.fex will give you 5 levels in the repository - this should help you find the objects owned by a specific user.

@Patrick Huebgen thank you - here is a how to connect to the WebFOCUS client repository

Think should do a tips and tricks post 🙂 ibi adapter is very powerful.

Hi @Erin Trotter Why not use the WebFOCUS client adapter instead of going directly to the database? The adapter will generate some sample queries for you to get up and running very quickly and you can add/update/delete users/content etc and interact with the client repository - this is the solution you are requesting. We automated this process, ReportCaster job runs daily to get all the users that haven't logged in for 90 days(GET_USERS) we then use this list to loop through and update the users status'(ADD_USER). Below should get you started: DEFINE FILE GET_USERS -* GMT+2 = 7200000 BOT_START/D14 = EDIT(LASTSIGNIN) + 7200000; BASE_DATE/YYMD = 19700101; HBASE_DATE/HYYMDIA = HDTTM(BASE_DATE,8,'HYYMDIA'); LAST_SIGNIN/HYYMDS MISSING ON = IF LASTSIGNIN EQ '' THEN MISSING ELSE HADD(HBASE_DATE,'MILLISECONDS',BOT_START,8,'HYYMDS'); LAST_SIGNIN_YYMD/YYMD = HDATE(LAST_SIGNIN,'YYMD'); DAYS_SINCE_LOGIN/I9 MISSING ON = IF LAST_SIGNIN_YYMD EQ '' THEN MISSING ELSE DATEDIF(LAST_SIGNIN_YYMD, '&YYMD', 'D') END TABLE FILE GET_USERS PRINT GET_USERS.ITEM.NAME3 AS 'Userid' GET_USERS.ITEM.DESCRIPTION1 AS 'User Description' GET_USERS.ITEM.EMAIL AS 'Email Address' GET_USERS.ITEM.NAME2 AS 'Status' LAST_SIGNIN AS 'Last Signin(DT)' LAST_SIGNIN_YYMD AS 'Last Signin' DAYS_SINCE_LOGIN AS 'Days since login' BY HIGHEST DAYS_SINCE_LOGIN NOPRINT WHERE DAYS_SINCE_LOGIN GE 90; END -RUN

Online channels and forums are great for how to's - very happy the forums are back. Training fuels adoption and expansion with the organization - WebFOCUS is the best kept secret. Clients are asking for formal certified training with roadmaps that's readily avaiable - a comprehensive list of set courses available that are offered to clients online, based on their role within the organisation (admin/developer/business user) etc. In the good old days we offered our clients a variety courses; these are just some of the courses I could find. 305 ReportCaster Scheduling and Distribution 340 Metadata Essentials 351 Building Reports with Report Painter (Part 1) 354 Report Painter (Part 2) 361 Security Administration 372 Application Administration Essentials 402 Reporting Techniques for Relational Databases Course 340 Metadata Essentials Course 351 Building Reports with Report Painter (Part 1) Course 354 Report Painter (Part 2) Course 361 Security Administration Course 363A Building a Business Intelligence Portal - Part 1 Course 363B Building a Business Intelligence Portal - Part 2 Course 365 InfoAssist Essentials - Part 1 Course 366 InfoAssist Essentials - Part 2 Course 367 InfoAssist Essentials - Part 3 Course 372 Application Administration Essentials Course 402 Reporting Techniques for Relational Databases Course 500 WebFOCUS Bootcamp

Hi @Dave Pfeiffer, My pleasure, if we don't actively request and log NFR's IBI won't know what can be improved on - just logged a NFR for RC task to link to a CM export scenario. Thanks for the above comprehensive response, we hope to see these enhancements will be implemented soon, especially the legacy, RC, CM, Security Center and admin pages updated. Our developers still prefer to use /ibi_apps/home(Home) vs /ibi_apps/start(Hub). We have 70+ workspace, Home loads a lot quicker... The search and locate item is great, I see this is only in the Hub and not on the Home page search. Kind Regards, Clayton

I looked at the fexes generated by the WebFOCUS client adapter, get_reportinfo.fex, the report lists the masters used in a specific fex. BUT you will need to do a lot of looping through the repository tree structure and this will be a lengthy exercise.

I would export all the workspaces via CM export package and then scan the fexes with a text editor seaching for the master - this I think is the easiest. The impact analysis on server console to my knowledge only looks at fexes in the app path. Also possible to use WebFOCUS client webservices adapter but might be tricky and lengthy approach.

In my environment we have a welcome page tab, on the welcome page in a collaborative portal clicking on the hyperlink will drill/navigate to a tab/page in the portal. To get the correct name for the portal page, navigate to the workspace root folder, inside the root folder there will be a hidden folder with the name of your <portal name> resources. If you have created multiple tabs with the same names or renamed tabs the original "<tab name>.page" is the page/tab that you want to use to navigate to in your function - this caused me some frustration. TYPE=DATA, COLUMN=N2, JAVASCRIPT=navigateToPage('Resources_Filtered'), $ Online references: JAVASCRIPT=navigateToPage How to Use JavaScript to Navigate to a Portal Page

Pleasure! We are on WF9.2.1. ReportCaster and Change management also interfaces could also do with a nice refresh 🙂

Pleasure @Dave Pfeiffer think there are a number of things that could be considered and might ask some clients to view and give their options in a beta release to get some feedback eveyone uses WebFOCUS a little differently that's the beauty. Some more off the top of my head: WebFOCUS Default landing page: Ability to select default landing page for all users and the views on the landing page - Our developers access the WebFOCUS home page and need to select Workspaces menu item each time after the page loads currently by default the Recents/Favs view loads. List of portals on the landing page would be great - ability to customise - I would remove recent, only show favs and portals(collaborative) for all our end users but developers able to set preference. A portals(collaborative) button would be helpful - ability to select by default as per above White labelling: Theme/CSS needs to be applied to all client pages, navigating to security center, admin console(sub menu's) all look different - icons purple and padding. Clicking on <server>/admin you cant see some of the labels and options to select including save button. Navigating to the server console directly :8121 ignores white labelling only get white labelling via client navigation Metadata: Opens Designer after creating content, annoying developers as they close this window each time - we dont use designer as yet. Search Workspaces(client home): Ability to right click and open the location of the searched item found in Workspaces. At the moment you need to right click and select properties and copy the path so you can find the exact location of the searched item - tedious. Ability to search for content inside procedures etc would be really helpful. Text Editor: Most of our developers spend their time here, the icons not always explanatory - need to onHover to find out what the button/icon does. Additional shortcuts and commonly used functions etc here to enhance developers experience compared to other editors would be appreciated Including functions references etc here

We encountered a similar scenario involving a large workforce of over 30k employees. To address this, we implemented the following changes: Employee Name Search We replaced the droplist/combobox with a text box - free text or consider typeahead custom solution The text box performs a fuzzy search on employee names, allowing for more flexible and accurate searches. Conditional Loading of Supervisor and Class In your example, the Supervisor and Class fields load dynamically only after the user selects a specific Department(onChange event). This approach optimizes performance by fetching relevant data only when necessary to load Supervisor/Class which will be a smaller subset of data. Performance Optimization FOCCACHE File Creation: Consider creating the necessary files in FOCCACHE before the HTML loads so they wait only once for the unique values, these files can be referenced by your filters, leading to potential speed improvements. ReportCaster Job for XFOCUS Table: Alternatively, can run a daily ReportCaster job to create an XFOCUS table for faster data retrieval with unique combinations for controls. We use JQuery to create our magical filters.

I was in the same situation where I had to view some content created in WF 8.2.07 and agree with you the old design was much better, easier on the eye. In the tile view we had custom images for our portals, in WF 9.2.1 the image is so tiny on the tile it not viewable. Many of our business users created thumbnails(camera button) in InfoAssist which they really liked. When you click on workspaces on the home page in our env for split second when it loads you see the very old navigation with "Ask WebFOCUS" on the menu. On the plus side, in WF 9, we finally have custom white labelling - still some CSS issues(bug logged on TechSupport) like in admin console/security center with purple pngs and padding - I dont use Hub still use admin console link.

Thanks @Martin Yergeau wanted to incorporate a MORE FILE for one of my developers 🙂