Jump to content

Clayton Peacock

  • Posts

  • Joined

  • Last visited

  • Days Won


Clayton Peacock last won the day on May 8

Clayton Peacock had the most liked content!


Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Clayton Peacock's Achievements

  1. Hi @David Briars tried with a couple arguments recursionDepth=-1 but looks like the web services on the test page doesnt have any argument options. I would use the client adapter, as you can create hold files etc of the groups and subgroups and merge these to get all the users.
  2. Pleasure @David Briars check out option 3 suggested above as well can do some really cool reports on the client repository
  3. Hi @Sara Smith might be useful see function UFMT? TABLE FILE CAR SUM CAR NOPRINT COMPUTE NAME_UMLAUTS/A50 = 'Günther'; COMPUTE NAME/A50 = 'Gunther'; COMPUTE HEXCODE_UMLAUTS/A6 = UFMT(NAME_UMLAUTS, 50, HEXCODE_UMLAUTS); COMPUTE HEXCODE_NAME/A6 = UFMT(NAME, 50, HEXCODE_NAME); END UFMT: Converting an Alphanumeric String to Hexadecimal The UFMT function converts characters in an alphanumeric source string to their hexadecimal representation. This function is useful for examining data of unknown format. As long as you know the length of the data, you can examine its content.
  4. Hi @David Briars there are 3 ways to get any information from the client repository. Connect directly to client repository database Connect using webservices XML returned: https://<your server name>/ibi_apps/WFServlet?IBFS1_action=TEST Connect using the WebFOCUS client repository adapter The 3 option is probably the easiest way to retrieve this information and there is a host of example fexes that the adapter generates.
  5. WHENCE PRODUCT_MAINTENANCE_REQUEST MASTER Had same issue master file was in FOCCACHE, above helped me.
  6. 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.
  7. 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
  8. 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
  9. 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
  10. 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.
  11. 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.
  12. 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
  13. Pleasure! We are on WF9.2.1. ReportCaster and Change management also interfaces could also do with a nice refresh 🙂
  • Create New...