You can export punch items to an Excel file where you can edit them and create new ones. Then you can import the file, which can only be used once, back into ProjectSight. If there are any errors, you can review and fix them in a new Excel file.
- Record permissions, field permissions, and workflow status permissions are checked when you export punch items to an Excel file and when you import the file into ProjectSight.
- In the Excel file, required fields are light red, and read-only fields are light blue.
- To avoid an import error, make sure you enter information in the Resolution field if the Date Resolved and Resolved By fields contain information.
- The Excel file can only be imported into the project that it was exported from.
When you import the Excel file back into ProjectSight:
- If new values were entered after this spreadsheet was exported, your edits are flagged.
- Blank rows and fields are ignored.
- If a non-draft workflow status is selected, and a required field is invalid or empty, the new record remains a draft.
- The Resolution, Date Resolved, and Resolved By fields are updated in the record. If the Date Resolved and Resolved By fields are empty in the Excel file and in the record, the current user and time stamp are used.
To edit and create punch items using the Excel import sheet
- In the Punch Items module, filter the records that will be exported to Excel.
- In the Search panel, set the filters.
- To export specific punch items, select their checkboxes. If none are selected, all the punch items are exported.
- In the list view, add and rearrange the columns, and then save the custom view.
The Excel file will display the columns for the fields in the list view followed by the remaining fields.
- On the navigation toolbar, select
(Import/Export) > Export to Excel.
The Excel file contains the required fields and the fields that you have permission to view.
- Open the Excel file.
- On the Punch Items tab, enter the punch item details in a new row.
- Edit any existing punch items.
Tip
You can copy and paste unlocked cells.
- Save the Excel file.
- In ProjectSight, open the Punch Items module.
- On the navigation toolbar, select
(Import/Export) > Update from Excel.
- Select the Excel file to import.
To review and fix import errors
- In the import error message, select Review Errors.
The punch items with errors are exported to a new Excel file.
- Review the Feedback column and fix the associated errors.
- Save the Excel file.
- In ProjectSight, open the Punch Items module.
- On the navigation toolbar, select
(Import/Export) > Update from Excel.
- Select the Excel file to import.