Action Log - Quick Reference

/OpenForum/AddOn/ActionLog Sevice API Version 0.0.7

Get Actions

Action search

Parameters

Name	Description
actionType (required=false)	{{parameter.description}}
term (required=false)	{{parameter.description}}
fromTs (required=false)	{{parameter.description}}
toTs (required=false)	{{parameter.description}}

Example Get Request

/OpenForum/AddOn/ActionLog?action=search

Example Response

Example Error Response

Action getActionTypes

Parameters

Name	Description
(required=true)	{{parameter.description}}

Example Get Request

/OpenForum/AddOn/ActionLog?action=getActionTypes

Example Response

Example Error Response

Post Actions

Action logAction

Parameters

Name	Description
actionType (required=true)	{{parameter.description}}
action (required=true)	{{parameter.description}}

Example Post Request

/OpenForum/AddOn/ActionLog?action=logAction

Example Response

Example Error Response

/OpenForum/AddOn/Alert Sevice API Version 1.0.4

Get Actions

Action getAlerts

Parameters

Name	Description

Example Get Request

/OpenForum/AddOn/Alert?action=getAlerts /OpenForum/AddOn/Alert?action=getAlerts

Example Response

Example Error Response

Action addAlert

Parameters

Name	Description
name (required=true)	{{parameter.description}}

Example Get Request

/OpenForum/AddOn/Alert?action=addAlert{{action.example.request}} /OpenForum/AddOn/Alert?action=addAlert{{action.example.request}}

Example Response

Example Error Response

Action removeAlert

Parameters

Name	Description
name (required=true)	{{parameter.description}}

Example Get Request

/OpenForum/AddOn/Alert?action=removeAlert{{action.example.request}} /OpenForum/AddOn/Alert?action=removeAlert{{action.example.request}}

Example Response

Example Error Response

Action triggerAlert

Parameters

Name	Description
name (required=true)	{{parameter.description}}
reason (required=true)	{{parameter.description}}

Example Get Request

/OpenForum/AddOn/Alert?action=triggerAlert{{action.example.request}} /OpenForum/AddOn/Alert?action=triggerAlert{{action.example.request}}

Example Response

Example Error Response

Action beatAlert

Parameters

Name	Description
name (required=true)	{{parameter.description}}

Example Get Request

/OpenForum/AddOn/Alert?action=beatAlert{{action.example.request}} /OpenForum/AddOn/Alert?action=beatAlert{{action.example.request}}

Example Response

Example Error Response

Action cancelAlert

Parameters

Name	Description
name (required=true)	{{parameter.description}}

Example Get Request

/OpenForum/AddOn/Alert?action=cancelAlert{{action.example.request}} /OpenForum/AddOn/Alert?action=cancelAlert{{action.example.request}}

Example Response

Example Error Response

Quick Reference

Anonymous Session provides the ability to offer tokens to store assets against like Zoom call ids. You can also combine them with passwords as an extra security step.

Example Use

/OpenForum/AddOn/AnonymousSession?action=validateSession&key=3ACDC2D4

Content Editor - Quick Reference

The content editor is a two panel editor. It is intended for pages that just contain text and images rather than those that are part of a web application.

Editor Panels

The two panels can be resized by dragging the separator between them.

The left hand panel gives an over view of the page being edited at the top, a list of pages to edit in the middle and a view of the image library at the bottom.

The right hand panel gives a view of the page content for editing. At the top is the title as shown on the browser tab and below are the sections of the page.

Adding Blocks

Above and below each page section are + buttons that will add content either above or below existing elements of content. There are also up and down buttons to move the content up and down the sections in the page.

On clicking + you are presented with a list of blocks that can be added to the page.

For simple formatted text and images, the WYSIWYG block allows you to enter text and type set it adding text styles, links and lists etc.

Images

To add an image into the WYSIWYG panel, find the image in the image library in the left hand pane or select to upload one. Drag the image into the WYSIWYG content block. Click on it to set any alternative text or its placement in the text.

A number of other block types are available that add either configurable page elements or page layouts.

Preview and Publish

To see how your page will look once published, click on Preview at the top of the left hand pane. This will save the page to a space for unpublished pages and make the page visible in another browser tab. Saving the page once the preview has been opened will automatically update the preview tab.

Once you are happy with your page, click Publish and the page will be published to the live area of your website.

New Pages

To create a new page select Create A New Page. In the popup window, enter the new pages title and optionally select a category. Select Create New Page and a new page will be added to the list and the editor for the page opened.

API Reference

Data Transformer - Quick Reference

The data transformer is intended take text from the input and transform it, then place it in the output. No data is shared or sent to our server unless you choose to save it. To do this you will need to have an Electric Llama Company account
To perform a data transformation, you have to do all the hard work, by writing Javascript in the code editor at the bottom of the screen.
The text in the input editor is made available as the variable input and the text in the output can be set by setting the output variable.
A number of useful transformer examples are given below to get you started.
If you have an Electric Llama Company account, you can save any transformers you have written for later use, alternatively each text editor has a download to desktop option.
You can drag and drop files into any of the editors on the transformer page.

Examples

//An example of transorming data from an xml document

//Comment out or remove this if you have valid xml in the input editor
input = "<a>"123 ">345</a>";

//Generate an xml parser by reusing the javascript html dom parser
var parser = new DOMParser();

//Javascript is happier using json objects rather than xml
//This method converts an xml document string to a json object
function xmlStringToJson( data ) {
  //parse a string into an xml document object
  var xml = parser.parseFromString(data, "application/xml");
  //convert that object into json
  return xml2json(xml);
}

//Takes an xml document object and converts it into a json object
//It does not include any xml node parameters, so in the example string above
//val="123" will be ignored and only 345 included
function xml2json(xml) {
 try {
 var obj = {};
 if (xml.children.length > 0) {
 for (var i = 0; i < xml.children.length; i++) {
 var item = xml.children.item(i);
 var nodeName = item.nodeName;

if (typeof (obj<a href="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName"target="editor" style="color: red" title="The page /OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName does not exist. Click to create it.">nodeName</a>) == "undefined") {
 obj<a href="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName"target="editor" style="color: red" title="The page /OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName does not exist. Click to create it.">nodeName</a> = xml2json(item);
 } else {
 if (typeof (obj<a href="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName"target="editor" style="color: red" title="The page /OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName does not exist. Click to create it.">nodeName</a>.push) == "undefined") {
 var old = obj<a href="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName"target="editor" style="color: red" title="The page /OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName does not exist. Click to create it.">nodeName</a>;

obj<a href="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName"target="editor" style="color: red" title="The page /OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName does not exist. Click to create it.">nodeName</a> = <a href="/OpenForum/AddOn/DataTransformer/QuickReference/" target="newTab"><img src='/OpenForum/Images/icons/png/link_go.png' /></a>;
 obj<a href="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName"target="editor" style="color: red" title="The page /OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName does not exist. Click to create it.">nodeName</a>.push(old);
 }
 obj<a href="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName"target="editor" style="color: red" title="The page /OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/nodeName does not exist. Click to create it.">nodeName</a>.push(xml2json(item));
 }
 }
 } else {
 obj = xml.textContent;
 }
 return obj;
 } catch (e) {
 console.log(e.message);
 }
}

var xml = xmlStringToJson( input );

output = JSON.stringify( xml, null, 4 );

//Add a message to the log
print("I've finished");

//An example of transorming data from a csv

//Comment out or remove this if you have valid a csv file in the input editor
input = "a,b,c n1,2,3 n4,5,6";

//Separate the csv rows
var rows = input.split(" n");
var DELIMITER = ","; //Use " t" for tab separated

output = "";

print("Rows:" + rows.length);

for(var r in rows) {
 //Ignore the title row
 if( r==0 ) continue;
 
 //Separate each row into a row of cells
 var cells = rows<a href="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/r"target="editor" style="color: red" title="The page /OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/r does not exist. Click to create it.">r</a>.split(DELIMITER);
 
 //Create a list of cells
 for(var c in cells) {
 	output += cells<a href="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/c"target="editor" style="color: red" title="The page /OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/c does not exist. Click to create it.">c</a> + " : "; 
 }
}

//Add a message to the log
print("I've finished");

//Split into lines
var lines = input.split(" n");

//Sort alphabetically
lines = lines.sort();

//Count repeated lines
var unique = {};
for(var l in lines) {
 if( unique<img src="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/ lines<a href="/OpenForum/AddOn/DataTransformer/QuickReference/" target="newTab"><img src='/OpenForum/Images/icons/png/link_go.png' /></a>l" alt=" lines<a href="/OpenForum/AddOn/DataTransformer/QuickReference/" target="newTab"><img src='/OpenForum/Images/icons/png/link_go.png' /></a>l" title=" lines<a href="/OpenForum/AddOn/DataTransformer/QuickReference/" target="newTab"><img src='/OpenForum/Images/icons/png/link_go.png' /></a>l"/>] ) {
 unique<img src="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/ lines<a href="/OpenForum/AddOn/DataTransformer/QuickReference/" target="newTab"><img src='/OpenForum/Images/icons/png/link_go.png' /></a>l" alt=" lines<a href="/OpenForum/AddOn/DataTransformer/QuickReference/" target="newTab"><img src='/OpenForum/Images/icons/png/link_go.png' /></a>l" title=" lines<a href="/OpenForum/AddOn/DataTransformer/QuickReference/" target="newTab"><img src='/OpenForum/Images/icons/png/link_go.png' /></a>l"/> ] ++;
 } else {
 	unique<img src="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/ lines<a href="/OpenForum/AddOn/DataTransformer/QuickReference/" target="newTab"><img src='/OpenForum/Images/icons/png/link_go.png' /></a>l" alt=" lines<a href="/OpenForum/AddOn/DataTransformer/QuickReference/" target="newTab"><img src='/OpenForum/Images/icons/png/link_go.png' /></a>l" title=" lines<a href="/OpenForum/AddOn/DataTransformer/QuickReference/" target="newTab"><img src='/OpenForum/Images/icons/png/link_go.png' /></a>l"/> ] = 1;
 }
}

//Display unique lines followed by a count of repeats
for(var u in unique) {
 output += u + " : " + unique<a href="/OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/u"target="editor" style="color: red" title="The page /OpenForum/Editor?pageName=/OpenForum/AddOn/DataTransformer/QuickReference/u does not exist. Click to create it.">u</a> + " n";
}
 
//Add a message to the log
print("I've finished");

Mailer Quick Reference

Notes

Menu Editor - Quick Reference

A menu bar editor.

QuickReference

The Publisher AddOn enables the publishing of packages from the developent area of a site into prodction.

All text files in the package (page and sub pages) are translated before publishing. References to Development are removed so a path /MyPage becomes /MyPage

Deletions are not processed immediately, but placed in a deletions script file to run later.

Special files

development-translation.sjs - This is an optional script that will translate the contents of files. The script is passed the contents of each text file as the variable data and is expected to return the transformed version.
publish-config.json - Can contain a list of files to exclude eg.
do-not-release.txt - Marks a page as not to be published. Should contain text stateing the reason
process-deletions.sjs - A script that is generated with files to be deleted after publishing
release-notes.html.fragment - Notes generated during the release are saved here

Generator

Include script: } Function to generate 3 sizes of QR Code }

Scanner

Include script: OpenForum.includeScript("/OpenForum/AddOn/QRCode/Scanner/qr-code-scanner.js"); Create required variables: var qrCodeScanner; var qrcode = { data: "", timeStamp: "", error: true }; Create the scanner and add a listener: OpenForum.init = function() { qrCodeScanner = new QRCodeScanner(); qrCodeScanner.addListener( function( newQR ) { qrcode = newQR; } ); };

Released Packages - Quick Reference

The Release AddOn enables the releaseing of packages for use on other sites.

Special files

pre-release.sjs - This script is run on the releasing server before the release package is built
release-excludes-files.json - A list of files to exclude from the release. This can include regex like .
- -test.js
- release-info.json - Contains release information
- install.sjs - Run on the server where the package is installed after the package has been installed

QuickReference

Server Side

Include DB.sjs on your sjs file

var DB = js.getObject("/OpenForum/AddOn/SQL","DB.sjs"); DB.setAlias("your database name"); // Create a new DB object for each database you need access to

Create a Simple DB Select

var sql = { action: "select", table: "my_table", columns: <a href="/OpenForum/Editor?pageName=/OpenForum/AddOn/SQL/QuickReference/ "column_a", "column_b" "target="editor" style="color: red" title="The page /OpenForum/Editor?pageName=/OpenForum/AddOn/SQL/QuickReference/ "column_a", "column_b" does not exist. Click to create it."> "column_a", "column_b" </a> }; var rows = DB.execute( SQL );

Create a DB Select that returns all columns

var sql = { action: "select", table: "my_table" }; var rows = DB.execute( SQL );

Create a Simple DB Insert

var sql = { action: "insert", table: "my_table", data: { column_a: "value a", column_b: "value b" } }; DB.execute( SQL );

Create a Simple DB Insert that returns a column

var sql = { action: "insert", table: "my_table", data: { column_a: "value a", column_b: "value b" }, returnColumn: "column_c" }; var returnedColumn = DB.execute( SQL );

Create a Simple DB Delete

var sql = { action: "delete", table: "my_table", where: { column_a: "value a", column_b: "value b" } }; DB.execute( SQL );

Create a Simple DB Upsert

var sql = { action: "upsert", table: "my_table", data: { column_a: "value a", column_b: "value b", column_c: "value c", column_d: "value d" }, where: { column_a: "value a", column_b: "value b" } }; DB.execute( SQL );

Create a Simple DB Query

var sql = { query: "select column_c, column_d from my_table where a = { {valueA} } and b = { {valueB} } data: { valueA: "value a", valueB: "value b" } }; DB.execute( SQL );

/OpenForum/AddOn/Update Sevice API Version 0.1.9

Get Actions

Action getUpdate

Parameters

Name	Description
pageName (required=true)	{{parameter.description}}
ignoreChanges (required=false)	{{parameter.description}}

Example Get Request

/OpenForum/AddOn/Update?action=getUpdate

Example Response

Example Error Response

Action getUpdateInfo

Parameters

Name	Description
pageName (required=true)	{{parameter.description}}

Example Get Request

/OpenForum/AddOn/Update?action=getUpdateInfo

Example Response

Example Error Response

Action getReleases

Parameters

Name	Description

Example Get Request

/OpenForum/AddOn/Update?action=getReleases

Example Response

Example Error Response

Post Actions

Action upsertToJSONList

Parameters

Name	Description
row (required=true)	{{parameter.description}}
indexName (required=true)	{{parameter.description}}
pageName (required=true)	{{parameter.description}}
fileName (required=true)	{{parameter.description}}

Example Post Request

/OpenForum/AddOn/Update?action=upsertToJSONList

OpenForum Add Ons

ActionLog

Alert

AnonymousSession

ContentEditor

DataLogger

DataTransformer

Developer

DifferenceView

DocumentGenerator

ImageProcessor

Mailer

Notes

MenuEditor

NotePad

Publisher

QRCode

Generator

ReleasedPackages

RemoteAdministration

RemoteLogger

SQL

ServiceBuilder

SiteMapBuilder

Spider

Update