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.

Caption

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:

  • TransNum
  • PTag

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.




Keywords:FABweb Batch Uploads – Updates   Doc ID:119991
Owner:Erik O.Group:University of Illinois Training and Development Resources
Created:2022-07-28 14:06 CSTUpdated:2022-11-09 11:57 CST
Sites:University of Illinois Training and Development Resources
CleanURL:https://answers.uillinois.edu/training/uafr-fabweb-batch-uploads-updates
Feedback:  0   0