APQP/PPAP: Bulk Update

Users can update APQP/PPAP item and package dates utilizing the Bulk Update functionality found on each items list page.  If you do not have access to this functionality, please contact your APQP Administrator.

 

How to Use Bulk Update

1. From a package's list page, change the "Type" drop down to "Items"
2. On an Items list page, click "Bulk Update" button
3. Within the Bulk Update modal, click the "Download Template" button
   • This template populates the export/import file with the filtered last page.  Changing the columns and filters on the list page will change what is download the next time the button is clicked
4. Once the file is ready with changes, add it via "Select Files" then click the import button that appears
   • Import status will appear on the import log and an email will be sent to you with specifics

 

Import/Export Template

The "Download Template" button will export the current list page view including all filters, sorting, and active column selections.

The columns available for update are on the left of the spreadsheet.  The columns from the list page are listed to the right of these columns and are greyed out to indicate they are not editable.  They are filterable and sortable though.

Note: all dates entered must match MM/DD/YYYY format regardless of your company's date preferences.

Fields available to update:

1. View Internal page
   • Item Planned Completion Date
   • Item Due Date
   • Pkg Due Date
2. View Supplier page
   • Item Due Date
   • Pkg Due Date
3. View Customer Page
   • Item Planned Completion Date
   • Pkg Due Date

Note: Users with access to this function can remove and add checklist confirmation signatures regardless of assigned package owner

Validation errors

Below is a comprehensive list of import errors which will result in a failed import.

Validation Error	Cause	Resolution
The uploaded file does not match the format of a Net-Inspect import template. Please restore the template's original format or download a new template above and try again.	Excel file used is not the template provided	Download the excel template provided by Net-Inspect.  Always use the latest version
APQP package type must match import type of [Internal, Supplier, Customer]	Excel file type does not match the list page type	Ensure the template selected is for the same list page type.  The exported file name will have Supplier, Internal, or Customer in the name to correspond to its list page origin
[Column Name] must be datetime formatted as MM/DD/YYYY	An invalid date was entered	Check the date entry is for a real date
	A different date format was entered	Update the date format to match MM/DD/YYYY (including zeros before single digits months)
	Cell type was changed from "Text"	Change the cell type back to text
Missing [Column Name]	A change was made to a greyed out cell	Revert any changes to the grey cells indicated in the email or redownload the template, do not modify grey cells, and attempt re-uploading
Invalid [Column Name]
Cannot update package because it is not In-Work	Only In-Work packages may be updated	Double check the entry on the import, change the status of the package and retry, or contact your APQP Administrator
Cannot update item because it has already been submitted	Only In-Work items may be updated	Double check the entry on the import, remove the item's submission signature(s), or contact the package owner listed
Cannot apply signature to record because one or more required Item Due Dates are missing	Checkbox to apply signature was selected in the modal but no entries were made in the spreadsheet	Modify one or more dates in the spreadsheet and attempt to re-upload
Cannot update [Column Date] because the record's Final Approval Form (PSW) has been [initiated, submitted, or approved]	Changes cannot be made to the indicated item dates because a final PSW exists and is not Rejected	Request the Final PSW is rejected or voided if changes are required; otherwise, contact your APQP Administrator
Cannot modify [Column Name] on a [Supplier or Customer] APQP	Attempted to update the Item Planned Completion Date when your company is the customer on the package	Only suppliers can update Item Planned Completion Dates on packages (unless the item is internal to your company)
	Attempted to update the Item Due Date when your company is the supplier on the package	Only customers can update Item Due Dates on packages (unless the item is internal to your company)
	Attempted to update the Pkg Due Date when your company is the supplier on the package	Only customers can update Pkg Due Dates on packages (unless the package is internal to your company)
Multiple Package Due Dates given for the same APQP/PPAP #	Items within the same package contain different entries in the "Package Due Dates" column	Only one instance of a Pkg Due Date is required to update the pkg due date.  Either remove all but one entry or ensure all entries are consistent
Cannot update [Column Date] because the applicable Confirmation Signature must first be removed	Checkbox is blank for removing existing checklist confirmation signature	Add the checkbox for removing existing checklist confirmation signature