Updating Machine Notes Information
Using a tool like MySQL Workbench how would I go about updating the Machine fields notes table with data that I have in a text or csv file for hundreds of machines?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
grayematter
10 years ago
Unfortunately, you cannot update the tables from Workbench. Other than asset imports which only update assets, the only way to mass update other data is through a ticket rule. To do a mass update, you could import the data file into an asset type. Then run a ticket rule to do the updates to copy the data from the asset field to the Machine notes field. You should be able to find a few examples by searching here.
