How to Build an HTML Wrapper in LiveReports?

Here is an interesting application For LiveReports: With LiveReports, SQL, and knowledge of the schema one can virtually list out any information on a Livelink object. Combine this, with knowledge of the CGI syntax and you should be able to construct your own custom Livelink interface/report with HTML without using Builder or LAPI. (Yes - XML is the future for this but hear me out)Take for example this snippet of HTML:testThis fetches the document test inside of Livelink. Now lets wrap this in a SQL (or LiveReport) to list all fetch links to documents beginning with test:Something like:select ""+name+"" from dtree where name like 'test%'This works great outside of LiveReports. You have HTML output with fetch hyperlinks to documents named like test%.But luck would have it. LiveReports REPLACES the nicely formatted HTML with literal representation preventing HTML incorporating. Too Bad. This could be a HUGE time saver.Anyway around this? Anyone else interested or doing this? OT your thoughts?Ray generate HTML tags within my SQL to select "TD>"+rtrim(name)+"" from dbo.dtree where name like 'Test%%' order by name

Find more posts tagged with

Comments

Liz_Connors_(sunvalleyfoodadmin_-_(deleted))

You mention using a CGI with a live report, why not use a CGI for the entire thing and then just add a link to that CGI into Livelink ?

Norman_Leung_(ImvecAdmin_(Delete)_2148619)

I modified a HTML template to get this done.You may try this to modify \installdirectory\module\report_2_2_0\html\autoreport-run.htmlThere is a line to print the values to browser: `val` Change it to: `%Lval` Now, all the values will not be transformed and printed exactly as what it is to the browser. In case if you really want to print special characters like "<" and ">", use "<" and ">" may do.Best regards,Desmond Yeung

Norman_Leung_(ImvecAdmin_(Delete)_2148619)

Please use the suggested method with caution.After modifying the HTML template, the data retrieved from database directly contain those special characters, the data MAY NOT be displayed correctly!In response to your topic content:This works great outside of LiveReports. You have HTML output with fetch hyperlinks to documents named like test%.But luck would have it. LiveReports REPLACES the nicely formatted HTML with literal representation preventing HTML incorporating. Too Bad. This could be a HUGE time saver.Actually, I would like to say, Livelink is just trying its best to display the raw data as what it is to users.Best regards,Desmond

Frank_Schwager_(schwager-f_-_(deleted))

I will take your advice and give this a try - thanks for your reponse.Ray

Norman_Leung_(ImvecAdmin_(Delete)_2148619)

You may put the following coding in your html template so that only those values starting with '!~' will be converted to hyperlink.autoreport-run.html:...;for s in ext.fields ;dynamic val = nodeRec.( s ) ;integer t = Type( val ) ;String alignString = align.( t ) ;if t == DateType `.FmtDate( nodeRec.(s), TRUE )` ;else ;val = Str.String( val );// ADD THE CODE IN YOUR autoreport-run.html FROM HERE ;if (val[:2] == "!~") ;val = val[3:] `%Lval` ;else `val` ;end;// TO HERE ;end;end...Hope this helps.Best Regards,Desmond YeungProject Manager, Imvec (HK) Ltd.desmond@imvec.com.hk

Brett_Sanders_(brettsanders_-_(deleted))

has anyone got this working in the past 9 years? I notice everyone is editing the "auto-live report" , does this also apply to the standard "livereport"?

John W. Simon, Jr.

AFAIK this IS the solution. We've been running this way for the past 10 years without any problems. Yes it applies to all LiveReports.

Heini

Hi Norman,

I know, it's a time ago, that this discussion was actual, but can you provide me with the that has to be done to autoreport-run.html?

Thanks,

Roland

eLink User

This was shown to me by John Simon (Who else

) when I was learning stuff.OT does not like you changing the template of their files so if we did not feel like using WebReports we wrapped the code in a wrapper .Also so long as dtree.dataid.kuaf.id etc with which objects can be done OT allows you Hyperlinking with standard live reports
JQuery can be used to make HyperLinks there is an example in this forum

The sample file (do not blindly replace in a livelink install )

autoreport-run_edited_for_hyperlink.html"can be accessed via the following link: https://knowledge.opentext.com/knowledge/cs.dll/properties/54867653

A word document describing code and setup and a lot of disclaimer stuff

"John's method ofdoing hyperlink's without purchasing webreports.docx" can be accessed viathe following link: https://knowledge.opentext.com/knowledge/cs.dll/properties/54873711

..Appu

I wonder how one could debug livelink if Fiddler, Wireshark and Softerra LDAP browser was not invented and not free

On Wed, Oct 8, 2014 at 9:16 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

RE How to Build an HTML Wrapper in LiveReports? Posted byrrottlaender@seepex.com (Rottlander, Roland)On 10/08/2014 10:08 AM

Hi Norman, I know, it's a time ago, that this discussion was actual, but can you provide me with the that has to be done to autoreport-run.html? Thanks, Roland
[To post a comment, use the normal reply function]
Topic: How to Build an HTML Wrapper in LiveReports?
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

John W. Simon, Jr.

There is a Livereport Extensions module that makes it so you no longer have to do this (it also provides some other nice features if you do a lot of Livereports). Any chance you have this module?

Heini

Hi John,

thank you for your reply.

Unfortunately, I do not have this module available. Do you know how the modifikation for the autoreport-run.html looks like?

Regards,

Roland

Heini

Hi John,

sorry for my too fast reply - I didn't see, that my question was answered some lines before...

I found the needed modification and it works perfect for me.

Thank you all!

Regards,

Roland