EDGEBIC Platform

EDGEBIC Scheduled Integration Runs Explained: Import Masks on a Timer

User Solutions TeamUser Solutions Team
|
8 min read

EDGEBIC by User Solutions can run its import masks automatically, on a timer or when a watched file changes, with a persistent end-to-end run history and a built-in simulator, so data flows in from other systems without manual re-imports and without a native ERP connector. Getting data into a scheduling system reliably is half the battle, and EDGEBIC's answer is to automate the import mechanism it already has rather than bolt on a fragile connector. The result is a mapped, scheduled feed you can see into.

This is the automation layer over the import masks that define how outside data lands in EDGEBIC's fields. If the mask is the contract, scheduled integration runs are the timer that executes it.

Masks, Automated, Not a Connector

The honest framing comes first because it shapes everything else. EDGEBIC integrates with other systems through import and export masks: a mask maps columns from a spreadsheet, a CSV, or a database query into EDGEBIC's fields. That is the whole integration model, and it is deliberately transparent. Scheduled integration runs do not replace masks with a certified plug-in for a particular ERP; they automate the masks.

A definition names a source and a mask. The source is either a file to watch or a database query to run. When the definition fires, its rows are read from the source, mapped through the mask, and processed by the exact same import pipeline you would use by hand. What changes is that you no longer launch it manually; a schedule or a file change does.

Calling this a mapped scheduled feed rather than a connector is not modesty, it is accuracy, and the accuracy is the point. You can see precisely what is mapped where, change it without waiting on a vendor, and audit what came in.

Two Ways to Trigger

A run can be driven two ways. A watched file means EDGEBIC notices when a file changes and imports it, which suits a workflow where your ERP or another system drops a fresh export into a location on a regular basis. An interval schedule means the definition runs on a timer, which suits pulling from a database query on a cadence.

Either way, the row-level behavior is identical to a manual import, because it is the same pipeline. If your masks already work by hand, automating them does not introduce a new set of rules to learn; it just removes the hand. For building the mask itself, see how to build an import mask.

End-to-End Run History

Automation you cannot see into is automation you cannot trust, so every run is recorded. Each execution writes a persistent record: when it ran, what source it read, how many rows it processed, whether it succeeded, and a pointer to its log. Crucially, the run row is written before the work begins and finalized when it ends, so a run that is interrupted still leaves a detectable record rather than disappearing.

That end-to-end history is what turns a background process into an accountable one. When someone asks whether last night's orders came in, the answer is a run row with a count and a status, not a shrug. It is the same instinct behind the rest of EDGEBIC's auditing, like the way it tracks every schedule change.

Guardrails Against Disturbing the System

Automated imports run against a live scheduling database, so the design leans hard on containment. Runs are time-boxed and row-capped, so a runaway source cannot churn forever or flood the store. A manual import and a scheduled run of the same mask serialize rather than collide, so two writers never fight over the same records. Each integration is isolated, so one failing definition cannot take down the others or the scheduling application. And the runner is built never to throw its way out of a run without leaving that finalized history record.

The overall goal is automation that does not disturb the running system, and these guardrails are how it holds to that.

The Built-In Simulator

Because pointing an automated pipeline at real data is a leap of faith, EDGEBIC includes a simulator: it generates demo data and exercises the whole flow, so you can rehearse a scheduled integration end to end before it touches anything real. You watch a run happen, read its history, and confirm the mapping behaves, all against safe generated data. When you are satisfied, you point the definition at your actual source.

That rehearsal capability is what makes the feature approachable. You do not have to trust the automation blind; you can prove it to yourself first.

Where It Fits

Scheduled integration runs sit at the edge of the system, feeding the same sales orders, products, and routings that everything downstream depends on. The mask defines the mapping, the schedule or file trigger runs it, the history records it, and the simulator lets you rehearse it. For the whole system the feed supplies, the complete EDGEBIC guide is the map.

The Point of Automating the Mask

The temptation in integration is to promise a magic connector and deliver a brittle one. EDGEBIC takes the other road: automate the transparent, mappable, auditable import you already control, and give it a run history and a simulator so you can trust it. You trade the illusion of plug-and-play for the reality of a scheduled feed you can see, change, and verify, which is the trade most plants would make on purpose.

Want to see a mapped feed run on a timer against your own export? Bring an export to a demo and we will schedule it.

They are the same import masks EDGEBIC already uses, run automatically on a timer or when a watched file changes, instead of being launched by hand each time. A definition points at a source, a file to watch or a database query to run, maps its rows through an import mask, and executes on an interval. Every run is recorded end to end, so you get automated data flow with a full audit trail. It is automation of the import-export masks, not a native or certified ERP connector.

No, and it is important to be clear about that. EDGEBIC integrates with other systems through import and export masks that map spreadsheet, CSV, or database-query data into EDGEBIC's fields. Scheduled integration runs automate those masks; they do not replace them with a certified plug-in for a specific ERP. The honesty of that framing matters: you are configuring a mapped import that runs on a schedule, which is robust and transparent, rather than a black-box connector.

Each run writes a persistent record of what happened: when it ran, what source it read, how many rows it processed, whether it succeeded, and a link to its log. The run row is written before the work starts and finalized when it ends, so even a run that is interrupted leaves a detectable record rather than vanishing. That end-to-end history is what makes an automated pipeline trustworthy instead of a silent background process you have to take on faith.

Expert Q&A: Deep Dive

Q: How should I think about connecting EDGEBIC to our ERP given it is masks, not a connector?

A: Think of it as a mapped, scheduled data feed rather than a plug-and-play integration, and treat that as a strength rather than a limitation. You already export data from your ERP as spreadsheets or reach a database view of it; an import mask defines exactly how those columns land in EDGEBIC's fields, and a scheduled integration run executes that mapping on a timer or when a fresh file appears. The advantage over a black-box connector is transparency: you can see precisely what is mapped where, change it without waiting on a vendor, and read a run history that tells you what came in and when. The tradeoff is that you own the mapping, which is exactly the control most plants want over data entering their schedule.

Q: We are nervous about automated imports running against our live schedule. What keeps this safe?

A: Several deliberate guardrails. Runs are time-boxed and row-capped so a runaway source cannot churn forever or flood the database. A manual import and a scheduled run of the same mask serialize rather than colliding, so two writers never fight over the same records. Each run is isolated and one failing integration cannot take down the others or the scheduling application. And nothing runs silently: the run history records every execution, and a built-in simulator lets you rehearse the whole thing against generated demo data before you point it at anything real. The design goal was automation that does not disturb the running system, and the run history plus the simulator are how you verify that for yourself.

Frequently Asked Questions

Ready to Transform Your Production Scheduling?

User Solutions has been helping manufacturers optimize their production schedules for over 35 years. One-time license, 5-day implementation.

User Solutions Team

User Solutions Team

Manufacturing Software Experts

User Solutions has been developing production planning and scheduling software for manufacturers since 1991. Our team combines 35+ years of manufacturing software expertise with deep industry knowledge to help factories optimize their operations.

Let's Solve Your Challenges Together