Importing tags form Wonderware

IF you are slightly familar with Visual Basic, you can use the VBA in Excel to process the data from the Wonderware DBSave export .CSV into an Ignition import .CSV.

I have used VBA in Excel to actually write code that has lots of repetitions. It will take a list of tagnames in an Excel column, process them against a template of what should be done with the tag in another column, and output the resulting code in another column.

This pupply will process thousands of tagnames and write bug free code. If the template is right, the resulting code will be right. Then you just have to select the output, right click and select copy, goto the the desired destination and paste the code just created.

I am a lousy typist, so this eliminates a bunch of typos that are hard to find.

Dennis