Smart Arbor Statistics Guide

What This Plugin Does

Smart Arbor Statistics lets you:

1. Add one or more Arbor export endpoints.

2. Optionally attach Basic auth credentials per endpoint.

3. Fetch JSON data from Arbor and store each leaf value in the database.

4. Output any stored value using a shortcode ID.

5. Build calculated values using a math shortcode.

Admin Menu

After activation, go to:

1. Arbor Statistics > Endpoints

2. Arbor Statistics > Values & Shortcodes

Endpoints Page

Use this page to create and manage Arbor data sources.

Add a New Endpoint

1. Go to Arbor Statistics > Endpoints.

2. Click + Add New.

3. Complete the form:

   1. Label: A friendly name for this feed.

   2. Arbor Export URL: Full JSON export URL from Arbor.

   3. Basic Auth Token (optional): The Base64 token value that comes after Basic in the header.

   4. Active: If enabled, the endpoint is included in automatic daily refresh.

4. Click Save Endpoint.

5. Click Refresh to fetch data immediately.

Endpoint Actions

1. Refresh: Fetch this endpoint now and update stored values.

2. Edit: Update label, URL, auth token, or active status.

3. Delete: Remove the endpoint and all values linked to it.

4. Refresh All Active: Runs refresh for active endpoints from the list.

Values & Shortcodes Page

This page lists all stored values generated from endpoint JSON responses.

Each row shows:

1. ID (used by shortcode)

2. Endpoint label

3. JSON key path (dot notation)

4. Current value

5. Last updated timestamp

6. Ready-to-copy shortcode

You can filter values by endpoint and delete individual value rows.

Shortcodes

1) Output a Stored Value

JavaScript[arbor-data-export id="123"]

Optional attributes:

JavaScript[arbor-data-export id="123" decimals="0" prefix="£" suffix=" pupils" fallback="N/A"]

Attributes:

1. id (required): Stored value ID.

2. decimals (optional): Number formatting for numeric values.

3. prefix (optional): Text before value.

4. suffix (optional): Text after value.

5. fallback (optional): Returned if ID is missing or value is empty.

2) Math Shortcode (Content Form)

JavaScript[arbor_math decimals="0"]
([arbor-data-export id="1"] + [arbor-data-export id="2"]) / 2
[/arbor_math]

3) Math Shortcode (Inline Attribute Form)

JavaScript[arbor_math math='[arbor-data-export id="1"] / [arbor-data-export id="2"] * 100' decimals="1" suffix="%"]

Use opposite quote styles when nesting shortcodes in the math attribute.

Math Rules Supported

The evaluator supports:

1. Operators: +, -, *, /, %

2. Multiplication aliases: x, X, ×

3. Parentheses: ( ... )

4. Implicit multiplication: 2(3+4) and (2+3)4

5. Unicode variants for minus/divide/percent/full-width parentheses

Behavior notes:

1. Division by zero returns 0.

2. Modulo by zero returns 0.

3. Non-math characters are ignored where possible.

Refresh Behavior

1. Manual Refresh fetches immediately.

2. Automatic refresh is scheduled daily (sas_daily_refresh).

3. Endpoints are refreshed at most once per ~23-hour window in automatic runs.

Authentication Notes

This plugin uses Basic auth token value.

If your token is:

JavaScriptBasic abc123...

Enter only:

JavaScriptabc123...

Do not include the word Basic in the token field.