0:00
Thank you for joining us on this webinar on downloading data from OCS 360.
0:05
It’s a slightly shorter video this morning.
0:07
Presentations are roughly about 10 minutes for this section.
0:11
But if you have any questions, feel free to put them in and we can get to them at the end.
0:15
Hello and welcome to today’s webinar.
0:19
Today we will look at downloading data from OCS 360.
0:24
Let’s look at our agenda for today.
0:27
We are going to start with a quick review of OCS360 and then we are going to get into today’s topic and answer some questions such as why download your data, what can you do with your data once you have downloaded it and how can you build a special dashboard in OCS360 for historical data and there will be demonstrations throughout and we will finish with a Q &A session.
0:53
Here is a quick review of OCS360 cloud service.
0:58
It is a new cloud service from Horner, making it as easy as possible to push data from a PLC-like device, in this case the Horner OCS to the cloud using a special version of MQTT that is built into the Prime and the Canvas controllers and require no extra licensing.
1:20
Then with OCS360 you get data recorded up to 5 years, dashboarding and alarm notification and notifications.
1:29
And now for today’s topic, why download data from OCS360?
1:35
You might have irregularity reasons for downloading a copy of your data.
1:40
You might need to do some customer reports.
1:43
They might want to have proof of your production process while you are manufacturing their components.
1:49
For instance, you may need it for quality control programs for productions, control reports and planning.
1:57
Now, what can you do with the data once you have downloaded it?
2:01
There are a few different things.
2:03
You can load it into Excel for quick and simple charting and calculations, but you can also load it into a database.
2:11
You can also feed it into a report.
2:14
You can also just take the data.
2:16
you download it and then supply it as it is in a CSV format.
2:21
Now if you are building a special dashboard for historical data and that is what we are going to talk about in today’s presentation, a technique that you can follow in which you can build a special dashboard where the data is ready to be downloaded at any time.
2:38
Just about every widget you put up there that assumes historical data has the ability for the data to be downloaded from it.
2:47
However, with a lot of these widgets you are putting it on your dashboard for downloading data.
2:53
It may be a case where having a longer term time fence will allow you to get a bigger chunk of data.
3:00
Now there are some keys to success as you are doing this and there will be demonstrations for this but let’s summarize it first.
3:08
You are going to want to use a time series line chart that is probably the widget where it is easiest to deal with longer term data and when you are configuring that time series line chart you are going to want to use advanced mode not basic mode.
3:27
You are going to want to use the widget time window not the default of the dashboard time window and you are going to want to set that time window to a long period of time.
3:38
say 30 days or so and then from the widget card control or tab you are going to want to make sure as you scroll all the way down that enable widget data export has been enabled so those are the kind of keys to success as you set up that special dashboard to make sure you have long-term range of historical data that you can download with a single click.
4:05
For our demonstration we are going start by being OCS 360 so before we actually start building the special dashboard for historical data for downloading purposes let’s just reinforce the fact that you can download data from any widget where it has been set up to be downloaded from.
4:26
So let’s go here to our existing dashboard which process history and take a look at this time series line chart that we created back during the dashboard series.
4:39
As you can see here we have got our pressure variable and we have got our temperature and our temperature set point and we have been gathering data for quite a while now but this particular chart only shows the last day because this is what we are interested in from the dashboard.
4:58
We want to see what is going on today with the machine for instance or with the process.
5:05
So that was the purpose of creating this particular time series line chart.
5:10
Now let’s go create one through a special dashboard that is focused on historical data.
5:16
So let’s go back to the dashboards and we are going to hit the plus button to create a new dashboard.
5:24
Let’s give it a name.
5:25
Let’s call it history for data downloads and we will just leave it as it is here.
5:32
Let’s hit the plus sign to add a new widget.
5:35
Let’s select from the charts bundle and the first chart in the list there, the time series line chart.
5:43
Now let’s make sure we cover all those key to success.
5:46
We want advanced mode.
5:48
We want to use the widget time window.
5:51
So those are the two things we want to establish and we want our time fence to be a longer time period let’s go ahead and select all the way out to 30 days so this is our current maximum there is a data aggregation function so if you leave this at the default of the average you are not going to get every single piece of data that was pushed to the ocs360 it is going to aggregate some of it for example two hours average so you will still get a lot of data but it will not be every single data point.
6:31
So if you want every single data point you need to change the data aggregation down here to none and then you can decide if you want to limit the size of the spreadsheet a certain number of values you can do that here but that is the other little key to success so let’s hit update here.
6:52
Now let’s start adding in the data points that we want to include in this time series line chart.
6:59
Now there are a couple different approaches you can take here.
7:03
One approach would be putting all the data that we are interested in into a single chart and then you would have a single download.
7:11
Another approach might be building a series or several of these time series line charts and then we can have it pre-sorted by the data that we are interested in into different categories.
7:24
Let’s go and put these same three variables on this particular time series data chart.
7:31
So we have to select our device which is our epoxymatic.
7:35
This is the OCS that is pushing data and there could be several.
7:40
Let’s go ahead and get rid of the default data key and let’s select temperature and let’s get the temperature set point and let’s get the pressure so we have added this to the chart.
7:53
Now let’s go to our widget carried let’s change the title let’s call this historical process data and the key function here is this is where we want to scroll down on the widget carried and make sure that we have enabled widget data export that way we will have a we will hit add and it is bringing in this data and as you can see here there is a lot of data packed into this chart let’s go ahead and hit save that is when we get our export widget data button to appear and that is going to give us the opportunity to press that anytime we want to download all the data for the last 30 days let’s go ahead and do that now so it has downloaded the data and you can see we have done some previous downloading now that we have done that step now what we can do with all that data we can use it as it is sent off to another department in a CSV form we can use it to build reports we can throw it in the database there’s a lot we can do with it we are going to show you a quick way to take this data and bring it into Excel we are going to start by memorizing our browser here. Let’s go ahead and do a file open.
9:16
Here is the data we just downloaded. We will hit the open button here and let’s drag the data over.
9:24
So here’s our data. So let’s spread out these columns so we can read them easily.
9:30
You can see here is the data going all the way back to the middle of February.
9:36
That is as far as we could go and stay within our 25 ,000 cells.
9:41
Now if we want to have more than that based on the number of entries, we could raise the number of entries in our setting for that particular time series chart above 25 ,000 to get all the data there.
9:55
We could also do some aggregation of the data so we could have it do some averaging.
10:01
We have got two or three weeks worth of data here and we wanted to quickly chart it.
10:07
let’s go ahead and chart some of the data for a quick demonstration purposes.
10:12
We are highlighting the data that we are interested in and then we are going to go to insert, we are going to insert a chart. Let’s make it a line chart. By default it puts us in a window here.
10:25
Let’s change this into something more effective, possibly something like a sheet so it’s much larger.
10:31
And now we have got data for that time period that we highlighted with our three different pieces of data that has a quick demonstration on what you can do with data.
10:43
One example of what you could do with the data and that is to bring it into Excel and explore all the ways you could use this data.
10:51
You could also use this for creating reports. That concludes our webinar for today.
10:57
Thank you so much listening and the Q &A session will begin shortly. Okay, relatively short one this morning.
11:16
We are going to continue on our OCS 360 runner webinars next week with rule chains so that link should be up if you want to register for that and then it’ll be the same time as always.
11:30
Okay I don’t see any questions coming in so I think we can leave it there.
11:35
Thank you all for joining this morning and we hope to see you again.
