You can use this feature to create or update multiple asset numbers. Using this feature, you can:

• Download a Microsoft Excel template populated with asset numbers.

• Create or update asset numbers in the Excel spreadsheet.

• Upload the revised data from the Excel spreadsheet into the application.

You can access this feature by clicking the Asset Number WebADI button on the following pages:

• Assets > Capital Asset: Simple Search

• Assets > Capital Asset: Advanced Search

• Assets > Rebuildable Inventory: Simple Search

• Assets > Rebuildable Inventory: Advanced Search

   To create multiple asset numbers using the Asset Number WebADI feature:

1. Navigate to the Asset Numbers page (Maintenance Super User > Home > Assets).

2. Enter the search criteria for the asset.

3. Click the Asset Number WebADI button.

   The Select Viewer page appears.

4. Select the specific version of Excel from the Viewer list.

5. Click Next, and the Desktop Integration Manager window appears.

   A message appears that a file is ready to be downloaded.

6. Save the file.

7. Open the file in Excel.

   Enable the macro for the Excel template.

8. Revise the data and save your work.

9. Optionally, click the Download button to re-download the data if you do not want to upload the saved changes. This process retrieves the data using same criteria entered in the web page.

10. Save your work.

    The Upl column will contain an indicator if the row has been updated. The system recognizes this flag and uploads the rows with changes.

11. Click the Upload button.

    The Upload Parameters page appears.

12. Optionally select Automatically Submit Import check box to automatically submit the Import Asset Number concurrent program.

    If the option is unselected, the system uploads the modified data into the staging table, and the user can submit the request in the Import Asset Number interface at a later time.

13. In the Commit Rows region, select one of the options:

    • All Rows: Commit all rows at the same time. If one row fails, the commit process fails.

    Each Row: Commits each row independently. If one row fails, the commit process continues.

14. Click the Upload button.

15. A confirmation message appears indicating that the upload was successful. The number of rows uploaded and request ID for the process appear in the message.

16. Click the Close button to return to the spreadsheet.

17. Use the Monitor Requests page to check the status of the request process.