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 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

Import Rules for Requirements Column Data

When importing, all variation of specification types are listed as separate columns on the import template. This is to make importing easier for our system to determine the input and make it reportable and useful. This means tolerance type is not a column in the requirements group for import. The system will automatically determine the tolerance type using the following logic:

• If entry includes an upper and lower specification and no nominal then treat as tolerance type “Range Inclusive”
• If only an upper specification or high tolerance is entered, treat tolerance type as “Unilateral Upper”
• If only a lower specification or low tolerance is entered, treat tolerance type as “Unilateral Lower”
• If only nominal entered, treat tolerance type as “Basic Dimension”
• If nominal and high and low tolerances are entered, treat tolerance type as “Bilateral”
• If nominal and high and low tolerances are added (which are the same), treat tolerance type as “Symmetrical”
• If no specification data is entered, tolerance type is "Blank"

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
	The file being imported is open	Close the import file and try again
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
[Column Name] column(s) are part of a row group and contain unique value(s).  Please update all rows in a row group to the same value for that column.	The specified row is part of a row group which means one or more of the shared/ linked columns are the same as one or more rows.	All values in one or more linked columns for a row group must be the same to import.  If you wish to make them different, please remove the changes and update via the online form instead.