Importing Plant Information from Excel
Use the Import Plant Information from Spreadsheet action to import new or updated plant data and department data objects from an Excel file. This file is created when you use Export to Excel in the Manage Department Information window. For more information, see Selecting a Plant for Editing and Editing Plant Information.
 |
• The Import Plant Information from Spreadsheet action imports only plant data and department data objects. The action ignores other objects, such as parts.
• You cannot use the Import from Spreadsheet action to import plant data and department data objects.
|
To import plant information, perform the following steps:
1. On the Details page of a product, select Import Plant Information from Spreadsheet from the Actions menu. The Import Plant Information from Spreadsheet window opens.
2. Click Browse and navigate to the Excel file.
3. Click Import.
The job is submitted to the queue and is validated in the background. Check the Import Job Monitor page to confirm that the job succeeds. Resolve errors, if any, in the Excel file and resubmit the job. For more information, see Import Job Monitor and Import Job Information Page.