Real flows.
Drawn from the product.
Every diagram here is generated from a template that ships with SentraBridge. Open one to see each step explained, then preview it on your own data.
Advanced flows
Branches, sub-flows, lookups and several destinations.
311 triage: route every request to the right system
Cleans and checks changed 311 requests, sends bad ones to a data-quality sub-flow, checks the city database to see if each is new, then…
Meter reads from AMI to utility billing with zero-read check
Every morning, reads the Neptune 360 export from the SFTP folder. Reads that look wrong (35 days with no flow, a skipped read or a read…
File CivicCA agendas and minutes in Laserfiche
Every hour, files each newly published CivicCA agenda and set of minutes in the city's Laserfiche repository, in the folder for that board,…
Morning operations digest from three systems
Weekdays at 7 am, reads 311 requests, SentraQueue lobby visits and database work orders, puts them in one shape, combines and sorts them,…
Daily payment file from Paymentus posts to utility billing
Every weekday morning, reads Paymentus's payment file from the SFTP folder, keeps accepted payments, checks each account exists in utility…
Permit pipeline: map issued, report finaled, file expired
Nightly, reads changed permits with a SQL query, cleans and checks them, then puts issued permits on the ArcGIS map, emails building a…
Everyday flows
One source, one destination, done well.
New pothole requests become Scheduler visits
Every 15 minutes, takes new or changed pothole requests from Sentra 311 and creates a visit for the street repair crew in Sentra Scheduler.
311 code-enforcement requests become Accela records
When Sentra 311 sends request.created, code-enforcement requests become new Accela records. Everything else is ignored.
Copy 311 requests into the city database, with map points
Every 15 minutes, upserts new and changed Sentra 311 requests into a PostGIS table, with a map point built from latitude and longitude.
Weekly 311 summary for department heads
Every Monday at 7 am, counts last week's closed 311 requests by type and emails the summary.
Closed Accela records close their 311 requests
Every 15 minutes, finds Accela records closed since the last run and closes the matching Sentra 311 request.
Make a Laserfiche folder for each new Accela permit
Every hour, creates a folder in Laserfiche for each new building record in Accela, named with the record number and address.
Publish agendas on the website after the clerk approves
Every morning, finds upcoming meetings with a published agenda in CivicCA and asks the city clerk to approve them. Approved agendas become…
Nightly backup: Sentra 311 requests to S3
Every night, copies all Sentra 311 requests to a dated JSON file in the city's own S3 bucket. The backup lives in the city's storage;…
Nightly backup: a database table to CSV in S3
Every night, exports a city database table (here: permits) to a dated CSV file in S3, so there's always a plain-text copy outside the…
Load the bank's daily payment file into the city database
Every morning, reads new payment CSV files from the bank's SFTP folder, cleans and checks them, loads them into a database table, and…
Publish upcoming CivicCA meetings to the website
Every night at 1 am, takes upcoming meetings with a published agenda from CivicCA and adds them as pages on the Sentra CMS website.
Data quality alert (sub-flow)
A reusable sub-flow: other flows hand it the records that failed their checks, and it emails the data team a summary with a CSV attached.
Reverse sync: database work orders become Sentra 311 requests
Every 15 minutes, reads work orders created or changed in the city database and creates matching Sentra 311 requests, so phone and…
EnerGov issued permits to ArcGIS
Every night, reads permits issued or changed in EnerGov since the last run and adds them to the permits map layer in ArcGIS.
Munis paid checks to the bank positive pay file
Every weekday afternoon, reads the AP checks Munis issued and writes the bank's positive pay file to the SFTP outbox, so the bank only…
New hires from NEOGOV to Munis (employee and payee vendor)
Every morning, reads yesterday's hires from NEOGOV and creates each one in Munis: an employee record for payroll, and a payee vendor so…
Nightly 311 export as a CSV file on SFTP
Every night, writes yesterday's changed Sentra 311 requests to a dated CSV file in an SFTP folder for another system to pick up.
Post severe weather alerts on the city website
Every 15 minutes, takes severe or extreme National Weather Service alerts for your state and posts them as website alerts in Sentra CMS.
Publish OpenGov permits to the open-data portal
Nightly, upserts changed OpenGov permit records into a Socrata / Tyler Data & Insights dataset.
Publish issued permits to an ArcGIS map layer
Nightly, reads permits issued since the last run from the city database and adds them as points on an ArcGIS feature layer.
Follow up with SentraQueue no-shows
Every hour, emails visitors who were called but didn't show, with a link to rejoin the line.
Salesforce web cases become Sentra 311 requests
Every 15 minutes, turns new Salesforce cases from the web into Sentra 311 service requests.
Utility billing vs general ledger daily balance check
Every morning, compares each day's payment total in utility billing with the cash receipts journal entry in Munis. Days that don't match,…
Want one of these on your data?
We'll set up a workspace with your systems in a sandbox and build your first flow with you.