Thunderstone Support Forums

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

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

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

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.

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.

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

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

The SQL abstract function takes the same arguments as the Vortex function, so you have the same control. You can put a <capture></capture> around the <sql> which will put the output into $ret if you want to manipulate it further.

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>

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.

<!-- 015 /webinator/xmltest:10: Line 1: syntax error at "480" -->
<!-- 000 /webinator/xmltest:10: SQLPrepare() failed with -1 in the function prepntexis -->

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>

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