update multiple asset state and substate

Luca Brambilla
Kilo Explorer

Hi All,

I have to update multiple asset task with the same State-Substate and Work Notes, and would like to know if I can create a script/task to do it in one click.

All the asset have the state "In Stock | Pending Disposal"  and I have to move Them on "Retired | Returned to Vendor" , adding  also a work note with a small test that will change everytime.

So, I need to create a script that will move the asset between the 2 state/substate and add the note ( note update is not mandatory, I can do is selecting the filed in a report and updating all ).
Would be better if I could add a condition where I can select the serial number I want to change.

There's a way to do it ?

 

Thanks

 

Luca

4 REPLIES 4

ABHAY_M
Tera Guru

you have to run fix script for bulk update 

Thanks Abhay,

 

I cannot find the System Application in my interface, probably it has restricted access.

Will go to update them manually...

demaroj
Tera Contributor

Luca,

 

Why not go to the list view and use Personalize List columns to include serial number, state, sub state and comments.  Filter the list to only the records to add data. Then click the hamburger and select import from the list.

You want to update records so select that radio button.  Then, leave create excel template box checked. Un check include all fields box.  

Click Create Excel template button.

An excel file is created.  Make the updates by copy paste or dragging values.

Then save the excel file and select choose file in Step 2.  Select the excel file and upload data.  

Errors in some records might occur but can be fixed in the form or be fixing in the excel sheet and reimporting.

I don't have "import from the list" option in the context menù.

Probably restricted from admin