Topics Map > Accounting > Equipment Management
UAFR - FABweb Batch Uploads – Updates
FABweb Batch Uploads – Updates
Use these steps to complete updates to existing equipment through a Batch Upload file.
NOTE: Parent/Child fixed assets can only be processed directly in FABweb. They cannot be updated using the Batch Upload process.
|
Step |
Task |
|---|---|
|
1. |
Go to the OBFS Equipment Management > Forms > website: http://www.obfs.uillinois.edu/forms/equipment-management-surplus/ |
|
2. |
Click the Updates to Existing Assets link to download the template (Excel format). |
|
3. |
Place your cursor in cell A2 to begin entering update data. Each asset should have its own row. NOTE: The header row is required in its original format and should not be edited. |
|
4. |
Enter data in these required columns for each update:
NOTE: See the FABweb Batch Uploads File Requirements for examples and more information. |
|
5. |
Enter the appropriate update data for any other columns as needed. |
|
6. |
Select File and click Save As. |
|
7. |
Choose a location to save your file. |
|
8. |
In the Save as type list, select CSV (Comma delimited). NOTE: On a Mac, select Windows Comma Separated instead. |
|
9. |
In the File name field, use this naming convention (required): U_MMDDYYYY_XXX.csv MM = 2-digit month DD = 2-digit day YYYY = 4-digit year XXX = any 1-3 digit combination |
|
10. |
Click the Save button. |
|
11. |
If a pop-up window appears to confirm saving your file in CSV format, click the Yes button. |
|
12. |
Login to FABweb at https://fabweb.uillinois.edu/. |
|
13. |
Click Update an existing Banner Fixed Asset. |
|
14. |
Click the Browse button under Upload a File. |
|
15. |
Locate and select the file you saved in step 9. |
|
16. |
Click the Open button. |
|
17. |
In the Asset File field, confirm that the file name is correct and the file type is CSV. |
|
18. |
Click the Upload button. NOTE: A message displays: “Your file has been uploaded. You will receive an email once processing is complete.” |
|
19. |
Review the email thoroughly when you get it. It will summarize the status of all the updates processed. This will be the only communication sent about the status. NOTE: If any updates failed to process, the email will have a spreadsheet attached, with details about the error(s). The error report might contain multiple tabs. |
|
20. |
Correct any processing errors, if needed. Check the FABweb Batch Uploads - Common Entry Errors job aid for help. |