Sometimes you need to make bulk edits to data in PIONEER.
Maybe you need to correct a customer name, or update pipe material, or fill in missing manhole Cover Siazes.
We have long had a CSV bulk editing tool. Now, we are introducing
SewerSheets
- a handy way to edit your data online in PIONEER.*Note: this tool is limited to Admin and Editor/Inspector roles.
Where to find it:
On PIONEER web, between the "AutoCode" and "Export" buttons you will now see "SewerSheet"
How to use it:
- Select a single Project or some other filtered set of data you want to edit
- Click the SewerSheet button
- You will see a table view of the data
- Click into any cell to edit
- Red cells are Required Fields
- Use Ctrl+C and Ctrl+V to Copy and Paste
- Use "drag handles" to copy data, just like Excel
- Hit the "Undo" button if you make a mistake (or Ctrl+Z)
- Use the column picker "Gear" to select column visibility
- Send the URL to someone else for them to edit in the same view
- The Link icon takes you to the inspection page
