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   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



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.

Answered 02/12/2014 by: grayematter
Fifth Degree Black Belt

Please log in to comment