Import Button, via Vendor P/N Repair Capability

MANUALS > Settings > Settings Module > Settings, Update Menu > P/N Master (General Inventory) > P/N Master (General Inventory) Buttons > R/O Capability, via P/N Master (General Inventory) > Vendor P/N Repair Capability Buttons > Import Button, via Vendor P/N Repair Capability

This Import is currently not working as per Mathias Testing

The Import Button, via R/O Capability button is used to quickly import vendor and/or location capability information which may not exist in your database.

First, the user must prepare the file. For information regarding how to prepare the import file, refer to Preparing File For Import, via the Import Button of the System Standards Training Manual.

Note: Import files for eMRO should be saved as .csv (comma delimited) or .xlsx and cannot have spaces in the title of the file. Spaces in the file path will cause errors when importing.

Criteria for R/O Capability Import file:

Column Name	Data Type	Limitation	Path
Part Number	Alphanumeric	25	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Vendor	Alphanumeric	10	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Condition	Alphanumeric	8	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Prefer	Y/N	1	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Price	Numeric	16	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Currency	Alphanumeric	8	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Lead Days	Numeric	5	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Warranty Hours	Numeric	5	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, Warranty tab
Warranty Cycles	Numeric	5	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, Warranty tab
Warranty Days	Numeric	5	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, Warranty tab
Schedule A/C Days	Numeric	5	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Minimum Order QTY	Numeric	5	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Valid Until Date	Numeric	8	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Minimum Order QTY 2	Numeric	5	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Price 2	Numeric	16	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Minimum Order QTY 3	Numeric	5	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Price 3	Numeric	16	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Minimum Order QTY 4	Numeric	5	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Price 4	Numeric	16	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Location	Alphanumeric	3	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab/ Auto R/O By Location button
Under Contract	Alphanumeric	10	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Auto RO Locations	Alphanumeric	10	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
RO Global	Alphanumeric	10	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Earliest	Alphanumeric	10	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab
Component Group	Alphanumeric	40	Settings/ Update/ P/N Master/ RO Capability Button/ Vendor P/N Repair Capability, General tab

Select the Import button for the quick import of many records (instead of manually entering) into the R/O Capability window.

Vendor PN Repair Capability Import-0.1

From the Import From File window complete all of the Import steps.

Vendor PN Repair Capability Import

For information regarding how to Import a file, refer to Importing a File via Import Button of the System Standards Training Manual.

The following information/options are available in this window:
_____________________________________________________________________________________

Import File

The file to be imported must be Tab delimited. Individual records that will be imported must contain a Location/Site that matches the location that is currently selected.

First Line Is Header checkbox

Check to indicate that the first line in the Tab delimited text file represents a Header line and should not be imported.

_____________________________________________________________________________________