PPAP Deliverables: Import from Excel

Net-Inspect provides an excel template that must be used to import data into PPAPD records.  When transferring data to the excel file, please copy and paste as values (ALT +E+S+V or right click and paste as values) to ensure proper data formatting.  The first row below the header of the import template details the formatting requirements/restrictions (you do not need to delete this to import).  Be sure to use the most recent template as changes may have been made that may impact your ability to import.

Users can import data into PPAPD in two ways:

1. Via the create: import page.  This option will import into all three deliverables if shared columns are populated or other columns related to the deliverables: PFD, PFMEA, and CP
2. Via the import/copy option inside each deliverable tab.  This is accessed via the "Actions" drop down.  Read more about this specific action via this article: PPAP Deliverables: Import/Copy

Excel Import Validation Errors

When importing via Excel into Net-Inspect, validation errors may occur such as the ones displayed below.

We will identify import errors for the following reasons:

• Document type is not valid
• Character limits are reached
• Date formats are incorrect
• Cell type is incorrect.  All text columns are of cell type "General" or "Text".  Numerical columns are "General" cell types but use a drop down
• Lack of entry for a required column

All errors will include the specific row # and column name in the error message which allows you to pinpoint the exact cell causing the errors.  All errors must be resolved in the excel spreadsheet and can then be reselected for import from the create page.

You may also experience errors while trying to paste data into the import template.  Please note:

• We have cell character limitations imbedded in the excel file but they do not work if data is pasted over a cell: only if data is entered in the cell while it is "open" or when values are pasted as text (ALT + E+S+V)
• We do not allow RPN to pasted into.  Please copy and paste data around that column

Validation errors

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
	Excel file tab name was changed (the identifier at the bottom of the excel view)	Download the excel template provided by Net-Inspect.  Always use the latest version and do not change the worksheet name
[Column Name] exceeds max length of X characters	The number of characters (including spaces) exceeds the limit of the cell	Reference the 6th row in the template to see the specific column character limits and modify the cell accordingly (taking spaces and newlines into consideration)
[Column Name] must be numeric	Some columns are required to select either from the drop down or must contain an integer	Enter an integer or select from the drop down for specific columns.  These columns are Process Step and SEV/OCC/DET/RPN.
Target Date must be datetime	Datetime format on the cell is incorrect or the cell type is not datetime	Date columns match MM/DD/YYYY regardless of Net-Inspect account setting or local preference
We were unable to process this request.	A file other than an excel file was selected for import	Use the required excel template
	System update is simultaneously occurring	Please refresh and try again
	Another issue is happening	Please contact helpdesk here
Only one Excel template may be imported.  Please review the selected files list	More than one file was selected for import	Remove files until only one template remains
Only 1 True value can be selected between columns: Administration, Packaging Interaction, Lift, Load and Install, Fabrication and Transformation, Move, Store, Inspect and Rework	The process step "category" (symbol) columns for a given row contains more than one true statement	Ensure each row only contains one true statement for these columns.  The other columns can state false or be left blank
Row is not linked to any deliverable.  At least 1 linkage indicator should be set to true	Columns PFD, PFMEA, and Control Plan linkage indicator columns are all blank	Row must be associated with at least one deliverable.  Select or enter TRUE for one or more of the three columns