Integration of Vignette with Texis/Webinator

joshua_augustin · Post by **joshua_augustin** » Wed Apr 25, 2001 1:33 am

Can anyone please provide me any small scripts that works as a bridge between Texis and the TCL(of the Vignette CMS) front end?

bart · Post by **bart** » Wed Apr 25, 2001 4:33 am

Vignette has developed an integration package for Thunderstone's Texis product.

Contact Andrew Coulson at Vignette's Advanced Solutions Team: 512-306-4730

joshua_augustin · Post by **joshua_augustin** » Wed Apr 25, 2001 7:14 am

hi bart,
does the thunderstone texis specifically give an intergration package using it's APIs with TCL or with any other third party product like BroadVision.
sorry for repeating the same question.

bart · Post by **bart** » Wed Apr 25, 2001 7:50 am

There are no direct APIs currently for TCL or Broadvision.

Vignettte used the 'C' API and Vortex to develop their interfaces to Texis.

The easiest way to communicate to Texis without resorting to the 'C' API is to set up RPC/Soap-ish calls via HTTP and Vortex. For the most part these are no-brainer apps to write in Vortex. A typical insert, delete, and search app that communicates in XML would only take about an hour to code in Vortex.

bart · Post by **bart** » Wed Apr 25, 2001 8:29 am

Here's a complete example XML search script that'll talk to a Webinator DB:

<script language=vortex>
<db=/usr/people/mosaic/htdocs/webinator/db>
<a name=main>
<sql max=10 row output=xml:ado
"select Title,Url,abstract(Body) Abs from html
where Title\Meta\Body likep $QUERY_STRING">
</sql>
</a>
</script>

to execute it via HTTP, you'd use a url like:

http://myserver/texis/xmlsearch?find+me

rkac · Post by **rkac** » Wed Apr 25, 2001 5:51 pm

Looks interesting.. but since the output is not a variable do you lose the capability of controlling query markup or abstract parameters?

bart · Post by **bart** » Wed Apr 25, 2001 10:28 pm

Rcak, If you want to do that kind of stuff then just use Vortex in its more common mode and just let it do it for you:

eg:

<sql max=10 row "select Title,Url,abstract(Body) Abs from html
where Title\Meta\Body likep $QUERY_STRING">

<a href=http://$Url>$Title</a>
<br>$Abs
<p>
</sql>

rkac · Post by **rkac** » Thu Apr 26, 2001 10:39 am

We are attempting to write an xml interface and need the query string to be longer then default. When I attempt to use the abstract syntax I recieve a sql syntax error.




What is the appropriate syntax?

Here is the code I used...

<sql max=10 row output=xml:ado
"select Title,Url,abstract(Body 480 smart $QUERY_STRING) Abs from html
where Title\Meta\Body likep $QUERY_STRING">
</sql>

Post by **mark** » Thu Apr 26, 2001 10:45 am

Abstract has the same controls, but the syntax is slightly different. Please see the manual: http://www.thunderstone.com/site/texisman/node67.html

rkac · Post by **rkac** » Thu Apr 26, 2001 11:39 am

Thanks that worked.

Now the only problem that I have is that of providing term highlighting on the xml format. You have suggested using <capture> sql statement capture </capture> then a $ret is available for formatting. Unfortunately the xml schema format is corrupted in that the <,>,and " symbols are converted to &lt, &gt , and &quot. Doing a replace on these would unfortunately remove &lt and &gt from the xml data section where it is needed.
Any ideas?