To import multiple idler failures into the Idler Management software, the import template must be used. The template can be downloaded by clicking on the Import button on the idler records screen for a individual conveyor. Click on the "import template" link to download an Excel template. The same template can be used for Idler or Structure failures. Note - The template set-up should not be changed in any way or the import will fail. Copy and paste your data into the template, not the other way around.
When creating an idler failure in either the Web or iPad versions of the software, the idler position is selected via a graphic of the idler set. This is not possible when bulk importing, so a description of the idler position is required. The attached spreadsheet called Idler Positions contains all these descriptions. Use only the descriptions in the "Idlerposition" column. Left and right positions are as you would look at them on the computer or iPad screen.
As with creating an individual idler failure, there are some mandatory fields in the template, which are marked with a "*". These must match the drop down values in the Idler Failure screen exactly. Either click the Import Idler Tags button (works for both Idler and Structure import) or drag the spreadsheet to the grey upload area.
For any errors, you should receive an error message specifying what caused the failure, as shown below. If there are a large number of records (over 1k), be aware that the import could take 5-10 minutes, so please be patient and wait until you get the completed message. Interrupting and restarting could cause duplicate records.
A sample spreadsheet is attached with examples for both idler and structure import. Do not use this one however. Always use the one from the "Import Template" link.
If you have more complex requirements that are not covered by this guide, please contact support@pdsglobal.com