Cause import from Excel skips rows: "Equipment not found", "Station not found"

[DataStream]

We have a list of about 120 downtime causes from our old paper system and I want to load them into Proveris OEE web instead of typing them one by one. On the CAUSES page I used Import from Excel. Some causes were added, but I got a list of errors like:

• Station not found: Line2-Filler
• Equipment not found (code or "Machine > Equipment" path): Filler > Capper
• Causes cannot be assigned to equipment that has sub-equipment: Filler > Conveyor

What format does the file need exactly? I built the Excel file myself with columns Name, Planned, Machine, Equipment.

[Technical Support]

The easiest way to get the format right is to start from an export rather than building the file by hand. Add one or two causes manually, export the list, and use that file as your template. The importer reads these columns: Name, Alarm Description, Planned/Unplanned Downtime, Effect to Availability, Station(s), Equipment. If a column is missing, the choices you make in the import dialog are used instead. Duplicate names are skipped.
Now the three errors:
"Station not found"
The Station(s) column must match the machine names exactly as they are defined in Proveris. "Line2-Filler" vs "Line 2 Filler" is enough to fail. Copy the names from the machines list.
"Equipment not found"
The Equipment column accepts either the Equipment Code or the full Machine > Equipment path. The equipment has to exist on the EQUIPMENT page before you import causes. If a path matches more than one item, you'll see "This path matches more than one equipment, use the equipment code", so codes are the safer choice.
"Causes cannot be assigned to equipment that has sub-equipment"
Causes are attached to the lowest level of the hierarchy. If "Conveyor" has children such as "Motor" and "Belt", assign the cause to one of those.
There is one more rule: the equipment's machine must be one of the cause's stations.
Note that when only the equipment links are invalid, the causes are still imported and you get the warning "Causes imported; the equipment links below were not written". You can fix those links afterwards with Edit Cause instead of importing again.
Recommended order: machines → equipment → causes.