[SOLVED] Automate the Content tree Extract process as an attempt of weekly backup

Hi Team,

Is there a way to automate the Content tree Extract process in Change Management as an attempt of weekly backup.

Also Is there a way to search inside a fex in content tree - the impact of tables / columns used
if the reports are text edits rather than opening each and searching manually.

Reason why am asking for automated backup is if there is a CM folder , then for any table usage i can grep on the folder for any string.

Thanks,
Rajna

This message has been edited. Last edited by: FP Mod Chuck,

WebFOCUS 8.1.05
Windows
Excel, PDF, HTML

Posts: 72 | Location: Flowood , MS | Registered: May 11, 2011

FP Mod Chuck

Virtuoso

posted

Hide Post

Hi Rajna

The WebFOCUS Web Services Enablement option (Extra cost feature) allows you to create change management packages.

Without this I have have an example below wher you read the repository directly and join the wf_reposobj and wf_content_revs tables and search for strings.

Below is the code used for a SQL Server repository.


SET SQLENGINE = SQLMSS
ENGINE SQLMSS SET DEFAULT_CONNECTION WF_Repository
SQL SQLMSS  PREPARE SQLOUT FOR
SELECT
T2.PRT_PATH + '/' + T2.OBJNAME AS WFCPATH,
T2.OBJNAME,
T2.PRT_PATH,
T1.OBJ_HANDLE,
CAST(CAST(BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX))  AS CODE
FROM dbo.WF_CONTENT_REVS T1
INNER JOIN dbo.WF_REPOSOBJ T2
        ON T1.OBJ_HANDLE = T2.HANDLE
WHERE CAST(CAST(BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX)) LIKE '%&SEARCH_STRING|%';
END
DEFINE FILE SQLOUT
MYCOUNT/I5 WITH WFCPATH=1;
END
TABLE FILE SQLOUT
HEADING
"Objects containing the string:  &SEARCH_STRING "
"Number of Objects = SUM MYCOUNT NOPRINT
PRINT
 CODE/A255 NOPRINT
BY WFCPATH AS 'Object'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(,,,).Select type of display output.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = /WFC/Repository/Repository/Hidden_Content/ENWarm.sty,
$
ENDSTYLE
END

Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats

Posts: 2127 | Location: Customer Support | Registered: April 12, 2005

Ignored post by FP Mod Chuck posted

Show Post

Rajna Nannat

Gold member

posted

Hide Post

Thanks Chuck, That works beautifully.

Thanks,
Rajna

WebFOCUS 8.1.05
Windows
Excel, PDF, HTML

Posts: 72 | Location: Flowood , MS | Registered: May 11, 2011

Ignored post by Rajna Nannat posted

Show Post

BI Consultant

Member

posted

Hide Post

SET SQLENGINE = SQLMSS

ENGINE DB2 SET DEFAULT_CONNECTION wf_repository

SQL DB2

SELECT
CAST(CAST(BCONTENT AS VARBINARY(4200)) AS VARCHAR(4200)) AS CODE, BCONTENT
FROM WF8REPOS.WF_CONTENT_REVS
WHERE CAST(CAST(BCONTENT AS VARBINARY(4200)) AS VARCHAR(4200)) LIKE '%employeeInfo%'
FETCH FIRST 100 ROW ONLY
END

TABLE FILE SQLOUT

PRINT CODE
BCONTENT
END

Hi Chuck - I tried running this query on DB2 and it doesnt work.It returns zero records.If i dont apply a WHERE condition it comes up with Binary Values.

WebFOCUS 8

Windows, All Outputs

Posts: 3 | Registered: March 28, 2018

Ignored post by BI Consultant posted

Show Post

Michael L Meagher

Platinum Member

posted

Hide Post

Shouldn't it be SET SQLENGINE = SQLDB2?