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?

Post by **John** » Wed Apr 25, 2001 9:39 pm

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.

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