What is this guide?

The MTIC dashboard at tinyurl.com/28lxntmc reads its data from a database called PocketBase. Whenever trade figures, factory details, or KPI numbers change, you update them here — no coding required. This guide shows you exactly what to click, using screenshots that match the real interface.

Open PocketBase in a second browser tab, then follow this guide step by step.

🔗 Open PocketBase Admin →
📦
The Three Collections (Tables)
You will see three collections in the left sidebar. Each one maps to a part of the dashboard.

value_chains

The 9 priority chains — trade figures, Uganda position, 2040 targets, priority tags, map descriptions, company lists, constraints, projections.

9 records

facilities

All manufacturing facilities on the Locations map — name, GPS coordinates, capacity, employees, ownership, products.

89 records

kpi_indicators

The six headline KPI cards at the top of the dashboard — GDP, Per Capita Income, Manufacturing Share, Capacity Utilisation, Exports, Employment.

6 records
1
Log In
Go to http://89.167.121.193:8090/_/ in your browser. Enter your admin email and password, then click Login.
http://89.167.121.193:8090/_/
PB
Welcome back!
PocketBase — MTIC Admin
Password
••••••••••••
Login
The admin email is [email protected]. If you have forgotten your password, contact Hillary Arinda.
2
Find Your Collection in the Sidebar
After logging in you will see this screen — exactly as in your screenshot. The left panel lists all collections. Click the one you want to edit: value_chains, facilities, or kpi_indicators.
89.167.121.193:8090/_/#/collections?collectionId=value_chains
🗄️
📈
⚙️
👤 users
📁 facilities
📁 kpi_indicators
📁 value_chains
Collections / value_chains  ⚙️ 🔄
🔑id Tname Tposition_tag Tpriority_tag 📅updated
abc1234… Iron & Steel Downstream only High — anchor chain 2026-06-12 ⋯
def5678… Copper & Allied Metals Downstream only High — mineral export 2026-06-12 ⋯
ghi9012… Automotive Assembly only Medium — KMC pivot 2026-06-12 ⋯
… 6 more records
Total found: 9Docs | PocketBase v0.22.7
Click any row to open that record and edit its fields. The ⋯ button on the right of each row also gives you Edit and Delete options.
3
Edit a Value Chain Record
Click a row in value_chains. A form slides open on the right side of the screen. Update only the fields that have changed, then click Save.
89.167.121.193:8090/_/#/collections/value_chains/abc1234
🗄️
📈
⚙️
👤 users
📁 facilities
📁 kpi_indicators
📁 value_chains
Collections / value_chains / Iron & Steel
key_import_2024 text ← update when new TradeMap data arrives
key_export_2024 text
position_tag text
position_color select
target_2040 text
priority_tag text
Only edit the fields that have actually changed. Leave everything else exactly as it is — the dashboard reads every single field.
4
Update a KPI Indicator
Click kpi_indicators in the sidebar, then click the row for the KPI you need to update. Change current_value and current_pct to reflect the latest published figures. Click Save.
89.167.121.193:8090/_/#/collections/kpi_indicators/def456
🗄️
📈
⚙️
👤 users
📁 facilities
📁 kpi_indicators
📁 value_chains
Collections / kpi_indicators / gdp
label text
current_value text ← change this
current_pct number ← and this
ndp_value text
ndp_pct number
tenfold_value text
tenfold_pct number
current_pct is a whole number 0–100 showing progress towards the tenfold target. Example: GDP is USD 53B, tenfold target is USD 500B → current_pct = 11. The progress bar on the dashboard uses this number.
5
Add a New Facility
Click facilities in the sidebar, then click + New record (top right). Fill in the form and click Save. The factory will appear on the Locations map.
89.167.121.193:8090/_/#/collections/facilities/new
🗄️
📈
⚙️
👤 users
📁 facilities
📁 kpi_indicators
📁 value_chains
Collections / facilities / New record
chain_name text required
name text required
lat number from Google Maps
lng number
location text
products text
Getting GPS coordinates: Go to maps.google.com, right-click exactly on the facility building, then click the coordinates shown at the top of the menu. The first number is lat, the second is lng.
6
After Saving — Push Changes to the Live Dashboard
Your PocketBase edits are saved in the database immediately. But the public dashboard at tinyurl.com/28lxntmc needs a deployment to pick them up. Use one of these two options:

Option A — Trigger it yourself

  1. Open GitHub Actions
  2. Click Deploy MTIC Value Chains App
  3. Click Run workflow → Run workflow
  4. Wait ~3 minutes
  5. Refresh the dashboard — data is updated

Option B — Ask the tech team

  1. WhatsApp Solomon or Hillary
  2. Say: "I've updated data in PocketBase"
  3. They trigger the deployment
  4. Dashboard updates within a few minutes
The team is working on making the dashboard refresh automatically whenever PocketBase data changes — no manual trigger will be needed eventually.