Import Button, via P/N Pool Detail

MANUALS > Inventory > Inventory Module > Inventory, Update Menu > P/N Pool > P/N Pool Detail > P/N Pool Detail Buttons > Import Button, via P/N Pool Detail

The Import button appears throughout the system and is used to quickly import files that do not exist in the system. The same process can be applied to any import found within the system.

The Import button, via the P/N Pool Detail Buttons is used to quickly import the information found in the P/N Pool Detail window into the system.

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 P/N Pool Detail Import file:

Column Name	Data Type	Limitation	Path
P/N	Alphanumeric	25	Inventory/Update/P/N Pool
Owner	Alphanumeric	10	Inventory/Update/P/N Pool
Quantity	Numeric	6	Inventory/Update/P/N Pool
Contract Number	Alphanumeric	15	Inventory/Update/P/N Pool
Pool Type	Alphanumeric	10	Inventory/Update/P/N Pool
Create Auto Exchange	Yes/No	N/A	Inventory/Update/P/N Pool
Currency	Alphanumeric	8	Inventory/Update/P/N Pool
Vendor	Alphanumeric	8	Inventory/Update/P/N Pool
Location	Alphanumeric	10	Inventory/Update/P/N Pool
Priority	Alphanumeric	8	Inventory/Update/P/N Pool
Order Category	Alphanumeric	8	Inventory/Update/P/N Pool
Condition	Alphanumeric	8	Inventory/Update/P/N Pool Detail, General, tab
G/L Company	Alphanumeric	8	Inventory/Update/P/N Pool
G/L Expenditure	Alphanumeric	8	Inventory/Update/P/N Pool
G/L	Alphanumeric	8	Inventory/Update/P/N Pool
G/L Cost Center	Alphanumeric	8	Inventory/Update/P/N Pool
Exchange Repair	Alphanumeric	8	Inventory/Update/P/N Pool
Unit Cost	Numeric	15	Inventory/Update/P/N Pool Detail, General, tab
Return P/N Within Days	Numeric	3	Inventory/Update/P/N Pool
Lead Days	Numeric	3	Inventory/Update/P/N Pool
Exclusion	Yes/No	N/A	Inventory/Update/P/N Pool
Expenditure	Alphanumeric	20	Inventory/Update/P/N Pool

From the P/N Pool window select the Import button. The system displays the Import From File window.

Once the path is specified, select the Import button.

eMRO_ImportButton(PNPoolDetail)(1)

Complete all of the Import steps.

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

The information from the .txt file is imported into the P/N Pool as shown below:

eMRO_ImportButton(PNPoolDetail)(2)