Page last modified 20:41, 24 Nov 2008 by robertm
Table of contents
- 1. Templates
- 1.1. Testing Salesforce
- 1.2. Testing SugarCRM
- 1.3. Testing Visifire
- 1.4. Testing MS SQL
- 1.5. Testing Access
| VMWare Image | Debian | Ubuntu | Red Hat | CentOS | OpenSUSE | SLES | 2k3 | IIS 7 | |
| Install is successful | |||||||||
| Trial Activation is Successful | |||||||||
| Create a page | |||||||||
| Edit and save | |||||||||
| Attach an image | |||||||||
| Verify Save as PDF works | |||||||||
| (Enterprise only) Salesforce adapter | |||||||||
| (Enterprise only) SugarCRM adapter | |||||||||
| (Enterprise only) Visifire adapter | |||||||||
| (Windows Enterprise only) SQL Adapter | |||||||||
| (Windows Enterprise only) Access adapter |
Templates
Testing Salesforce
- Add theSalesforce native extension.
Name: Salesforce
SID: sid://mindtouch.com/ent/2008/05/salesforce
username: salesforce@corp.mindtouch.com
password: QWE32199UWc1pgnYXcRUJuWWKIRTkMmc3 - Add the following DekiScript snippet to a page.
{{ salesforce.leads() }} - Save the page and a result set should appear.
Testing SugarCRM
- Add the SugarCRM native extension.
Name: Sugar
SID: sid://mindtouch.com/ent/2008/05/sugarcrm
username: admin
password: password
api-uri: http://192.168.168.151/sugarcrm/soap.php - Add the following DekiScript snippet to a page.
{{ sugarcrm.leads() }} - Save the page and a result set should appear.
Testing Visifire
- Add the Visifire native extension.
Name: Visifire
SID: sid://mindtouch.com/ent/2008/05/visifire - Create a page, and paste the following into the body:
<vc:Chart xmlns:vc="clr-namespace:Visifire.Charts;assembly=Visifire.Charts" Width="600" Height="400" Color="#F7F7F7" Theme="Theme1" View3D="True" AnimationEnabled="True" AnimationType="Type2" ColorSet="VisiRed" UniqueColors="True" Watermark="False"> <vc:AxisY Title="Sales ($,000)"> </vc:AxisY> <vc:AxisX Title="Product Name"> <vc:AxisLabels FontSize="8" Interval="1" /> </vc:AxisX> <vc:DataSeries Name = "Series1" RenderAs="Bar" YValueFormatString="$#,0.00"> <vc:DataPoint YValue="351139" /> <vc:DataPoint YValue="345254" /> <vc:DataPoint YValue="318845" /> <vc:DataPoint YValue="274316" /> <vc:DataPoint YValue="207349" /> </vc:DataSeries> </vc:Chart> - Place the cursor into the formatted area, and select "visifire.Chart" from the transformations drop-down menu.
- Save the page and a graph should appear.
Testing MS SQL
- Add the SQL extension
Name: MS SQL
SID: sid://mindtouch.com/ent/2008/06/microsoft.sqlserver
db-password: password
db-server: 192.168.168.161
db-catalog: AdventureWorks
db-user: rionm - Add the following DekiScript snippet to a page
{{ sql.table("SELECT CustomerID FROM Sales.Individual") }} - Save the page and a result set should appear.
Testing Access
- Copy the test Access database to a location accessible by the server (hereon referred to as ABSOLUTE-ACCESSDB-FILE-LOCATION). Make sure that the folder that the database resides in has sufficient rights to allow the lock file to be created; if not, you will receive a "Could not create lock file" when you attempt to use the DekiScript.
- Add the Access native extension.
Name: MS Access
SID: sid://mindtouch.com/ent/2008/06/microsoft.access
mdb-filepath: ABSOLUTE-ACCESSDB-FILE-LOCATION - Add the following DekiScript snippet to a page.
{{ access.recordlist('SELECT DISTINCTROW Categories.CategoryID, Categories.CategoryName, Sum([Order Details Extended].ExtendedPrice) AS Sales
FROM Categories INNER JOIN (Products INNER JOIN (Orders INNER JOIN [Order Details Extended] ON Orders.OrderID = [Order Details Extended].OrderID) ON Products.ProductID = [Order Details Extended].ProductID) ON Categories.CategoryID = Products.CategoryID
WHERE (((Orders.OrderDate) Between #1/1/95# And #12/31/95#))
GROUP BY Categories.CategoryID, Categories.CategoryName
ORDER BY Categories.CategoryName;') }} - Save the page and a result set should appear.
- Tag page
- What links here
Images 0
You must login to post a comment.