Why an inventory comes before the import
The typical starting point of a plant is work orders on paper and in Excel spreadsheets, companies invited by different people, and training validity tracked by hand. The data is therefore scattered, and each source has a different owner and a different format.
The system has no mass import of accounts, so entering people is a loop run on a prepared list. The quality of that list decides how many corrections remain after the start. The inventory is the one moment when corrections cost the least.
Five lists to collect
The inventory consists of five lists: risks, training, companies, locations and forms. Each one is described with four fields: source, owner, state and the form in which the data will enter the system.
For each list it is also recorded what is missing. Missing data is collected before the migration, not during it, because during the migration it blocks the team's work.
- Risks: from the occupational risk assessment, assigned to places of work.
- Training: type, date and validity, including validity tracked by hand.
- External companies: who invited them and who the contact person is.
- Locations: halls, lines, rooms, machine positions.
- Forms: templates of permits and work orders in circulation.
Locations: structure and the source of geometry
The plant structure has five levels: plot, view (department), building, line and location. A view is not a building, so the inventory separates the list of departments from the list of buildings. One mistake had a real effect: treating buildings from a plan as views deleted the only view with a georeferenced calibration, and the editor showed no calibration and the orthophoto disappeared.
Coordinates of locations in old data are sometimes recorded in the coordinate system of another hall that has no georeferencing. That is why for each row it is noted which hall it belongs to before its coordinates are used. Points on an old 2D map are sometimes real machine positions, while a plan approved for migration is sometimes approximate: in one plant, 44 of 45 markers fell outside the area of their line after the plan was used instead of the map from the old system.
Forms and permit templates
The printout of a permit can reproduce the plant's paper form through an uploaded template matrix. No arbitrary form is promised without implementation work on the matrix, so the inventory records which forms are key and must look as they do now.
Permit templates, their tasks and scope are configured in the installation data, without changes to the code. The team therefore collects the list of tasks and scopes from the existing forms, rather than writing requirements for programmers.
Evidence for the audit and cleaning before the start
The inventory is also evidence for an audit that the plant knew the state of its data before the migration. For each list the number of rows, the number of rejected rows and the reason for rejection are recorded. After the migration these numbers are compared with the result in the system.
Cleaning covers removing duplicate people, completing e-mail addresses or employee numbers, and checking company names. Duplicate control in the system works from deployment, not retroactively, so cleaning before the start avoids a separate decision about merging.
Checklist
Video
Frequently asked questions
How long does the inventory take?
It depends on how scattered the data is. With several sources the team finishes it before the migration schedule is set, and the numbers from the inventory are used to estimate the loading time.
Do I need complete data before the pilot starts?
Not all of it. A pilot can run for several months at no extra cost, and modules can be tested in parallel on the same instance.
Who should run the inventory?
The project manager, together with the owners of the lists: OHS, the HR department, heads of departments and the person responsible for the plant plans.
Start with the inventory, not the import
We will provide the data inventory template and go through the five lists with you before the first save.
Let's talk