Saturday, July 16, 2016

An eventful day


Creating Historian events tags was the first "cool" thing i learned about the Wonderware Historian Server.

Historian event tags belong to what the suite currently now calls "classic event system". This tags can be configured to be trigger when any other analog or discrete tag has a particular value. When the event tag triggers a set of actions can occur:


  • None
  • Generic SQL
  • Snapshot
  • Email
  • Deadband
  • Summary

With Generic SQL the possibilities become limitless! When Generic SQL is chosen a button called Templates popup, push it and select send an email message, fixed test.

You know can see how we can actually use the variables @EventTagName and @EventTime to this information passed through a script.

If you add a linked server to the SQL where historian exists now you can connect historian with any given database.

A couple of things that you will need to keep in mind:
  •  There is a limit amount of characters you can use with the Generic SQL option (you can overcome this by using store procedures)
  • You will need to setup security correctly for functions, tables and or store procedures used by the event system. Wonderware events will run with a user created with the Wonderware historian installation
  • The event system is not "real time", it will run on a scan basis. The scan works like a SQL Job so apply similar constrains to the scan time.

Saturday, July 2, 2016

Welcome to my story...

Welcome to my story!

I will add articles about my experiences working with a manufacturing software called Wonderware.

I'm not sure anyone will ever read this blog but let me begin with a little story about myself. I'm Jose Schmidt, i was born in Venezuela and lived almost all my life in a little town called Turmero. I went to Jose Maria Benitez school from first to sixth grade, then went to Los proceres to complete my high school (from 7th to 12th grade).

After i graduated from high school i spent about a year going to a small english academy (which i can't unfortunately remember the name of :/ ) and preparing myself to apply for the university.  When the engineering tests became available i completed the test and got myself enough score to enter the engineering faculty. For about 4 years i "tried" to study electrical engineering without much success and it wasn't until that year when i was doing a homework for a electronics class that i realized that the engineering career was just not for me. All my life i've been passionate about computers, since i was a small child when my father got a IBM XT i was so intrigued about them, i remember learning how to use the command line by watching my father and my brother typing on the keyboard until i figured out how to play games by myself. When computers were first introduced at my school i was the little kid who troubleshooted and helped teachers give the computer classes. On High School i enrolled to be the part of the first promotion that graduated under "Almacenamiento y Procesamiento de datos" or in a terrible english translation: Data process and management. So after i realized that electrical engineering was not for me i went and enrolled for Computer Science, and to my very pleased self i got it. Computer science was so different for my, for the very first time i started truly loving a career. Having spent so many years of my life in electrical engineering already i decided i was going to go as fast as i could and so i enrolled on as many summers as i could, i got as many parallel subjects as the professors would allow me and 4 years i had completed a 5 years career. I was so happy, i could not believe that i've done it. I've managed to graduate in 4 years.

The following is a funny true story, keep the following facts in mind as i go on:

  • I got married on the 3rd year of my career
  • Since the 3rd year on the career and on i've forced myself to work as a part timer consultant
  • On the fifth semester i became an assistant professor teaching the lab for Information Systems which was a related subject to what i was working as a consultant anyway
While i was working through the last half year of my career which involved developing my thesis i got a job offer in a town near where i grew up as a kid. The very next day after presenting my thesis i went back home and just started working. 

The actual graduation acts did not came to be but until around June the following year, the acts would last about 3 days total so i ask my boss for that week so i could go back to the university and get my diploma. 

When i got back to the university i went in and started to say hello to everyone i knew like some other students and / or teachers, and everyone was so euphoric saying congratulations it felt really nice. So it comes the day when everyone gets tickets for the diploma act, im starting asking "hey how many tickets are they giving? only 4" was the answer i got, well for sure my mom, dad, wife and sister. Its my turn to receive tickets, and i get 6 tickets. Man i was lucky, i did not tell anyone of course i wanted to keep my two extra tickets so i gave it to a couple more friends and it was fantastic. 

One of the acts come along, this time it was only the students who graduated are in. We sign a piece of paper, a picture is taken and done, that act was pretty small.

The second act comes along, its an act only for scientist, it involves the faculty giving you a small diploma for your completion of the science career. At this point i'm making use of my 6 tickets! Before computer science comes students from other faculties like Medicine, Biologists, etc. About 45 minutes in is time for computer scientist! yeey! I'm celebrating, i'm getting ready and get into line so i can get my small diploma. My turn! started walking to get my small diploma when all the sudden the host says "wait", he continues "all students stand up" , oh oh, omg whats going on " Student Jose Schmidt, you have been granted the title of best computer scientist of your promotion, all students please applause" I could not believe it, i looked at my mom and my wife and they are just crying of happiness. After the act is done and i'm able to go and meet with my family they were pissed that i had not told anyone about it, but the truth was that i didn't know at all! i also realized me getting 6 tickets was not a mistake but an actual fact.

As for after that, i kept on working at the same company for about a year and a half when i got a job offer to come to the United States and work in manufacturing. Some of the stuff that i've worked on since i came to the states are:
  • A RoR web based system to track manufacturing information such as delay, production, etc
  • A RoR historian framework that allow us to provide an XML output out of the historian server (Really Nice!)
  • A RoR application that was developed to integrate a maintenance software called Infor EAM with some machinery health data that we needed to capture. I'm very proud of this particular system, we were able to make operators enter work order information in seconds compared to minutes using the primary system.
  • Most recently i've been involved with Wonderware HMI design, i've thought myself now about InTouch, ArchestraGraphics and some System Platform.
The objective of this blog will be share some of the experience i've gather on the wonderware suite. I plan to at least write a blog article per week after this one, let's see how that goes.

- Have Fun