Focal Point
[SOLVED] Alternatives for Code Versioning

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

January 27, 2017, 03:29 PM
Sandeep
[SOLVED] Alternatives for Code Versioning
Hi All,

This about code versioning. I understand webfocus 8 does not have ability to integrate with SVN or GIT hub on its own.
But I must commit/check in the codes anyhow. So currently I am manually copying the fax codes from Info Assist and committing them in the SVN. This is a drudgery in 2017.
I was wondering if I can copy the reports from where the FEX codes are stored by Webfocus and create python to script to pick it up and commit it in SVN.

I think in WF8 hex codes are stored in db. Can some one please suggest which table stores it? I would like to using SQL query get the FEX file name and the hex code. Can some one please suggest? thank you in advance. If there are other options, that will be great too. I can not use licensed third party software though.

This message has been edited. Last edited by: Tamra,


WebFocus 8.1 Service Pack 0.5
Build Version branch8105
Build/GEN Number 119

OS/Platform: Apache Tomcat/8.0.21
January 29, 2017, 03:43 PM
Waz
The fexes are stored as (I think) blobs in the respository. Its all been mentioned in the forum before.

Do a search for wf_reposobj


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

January 30, 2017, 06:39 AM
Frans
you can use a 3rd party tool like Pushkok and use DEV studio.

You can also export your files to txt (export scenario with with IBI_CM_format_raw option or webservice) and then commit. You can automate this to export every time there is a change and then commit the txt file. Other option is to query the DB, fex is stored encoded, but you can simply decode.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
January 30, 2017, 07:29 AM
Diane
Source control is available in WebFOCUS 8201M release.


WebFOCUS 8.1.0.5m