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

Comments

Please log in to comment

Answers

0

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
Fourth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity