How do Industrial IoT sensor measurements help your organization save your time and your money?
Monitoring systems tell you what’s going on with your remote assets. They also alert you when something needs your attention, like a dangerously high water level and/or low temperature.
You have powerful options for integrating your IoT sensor data with various business intelligence and analytics software platforms. For example, Valarm Tools Cloud integrates with various software platforms, like those made by Amazon, Google, and Microsoft.
You’ll see a step-by-step tutorial guide in the video above, which shows you how to link your Tools.Valarm.net account to your Google Drive. You’ll then have automatic IoT sensor data exports to your Google Drive folder at regular time intervals, as often as you need, whether it’s once a day or once a week.
After you’ve watched the video, please don’t hesitate to get in touch with me at Info@Valarm.net if you’ve got any questions. We are adding additional export destinations like Box, so let us know if you’ve got a software feature request for Tools.Valarm.net.
For more information, have a gander at our Industrial IoT customer success stories page. You’ll see the organizations that requested features like this, as well as how our customers use these and other IoT software features to save time, money, and lives.
Video Transcript / Voiceover :
Howdy, this is Edward from Valarm.
In this video you’ll learn how to use Tools.Valarm.net software features for exporting your IoT sensor data Google Drive.
Let’s get started by logging in to Tools.Valarm.net .
After you’re logged in you’ll go to your Device Manager page and verify which IoT sensor device you’d like to export.
Here you can see the sensor measurements for a device on Tools.Valarm.net that we’ll use for exporting data to Google Drive.
Go to your Device Manager when you’re ready to set up your Export job.
Click the Export Jobs button on the left part of your Device Manager page.
Now you’re on your export jobs page.
Click the Authorize Google Drive button up top and follow the steps to link your Google Drive to Tools.Valarm.net.
After you’ve authorized Google Drive, click the Create New Export Job button on your Export Jobs page.
A window will pop up where you can configure and customize your export job.
Give your Job a name and some notes so you, your teams, and others at your organization can remember why you made this.
Next up, under Output Destination you’ll choose Google Drive as your Storage Service.
If you’d like to compress your IoT sensor data then you can choose a compression algorithm. We’ll use Zip compression in this demo.
Type in the folder directory where you’d like to save your sensor measurements on Google Drive.
In the file name format drop down menu you can choose how you’d like your file to be named. We’ll type in a custom, static fixed name here. Remember to include the extensions on your file. In our case we’re exporting in the csv, comma separated values, data file format and using zip compression. This means we’ll add .csv.zip to the end of our file name.
If you’ll be exporting multiple times and you only want the latest version of your file to be saved, you’ll want to check the force file overwrite box. You can click the question mark button next to any feature or option in order to learn more details about it.
Under Data Generation, you’ll set the schedule of how often you’d like your Export Jobs to happen. I recommend you start with Manual and get used to your settings and confirm that you’ve set up your configuration exactly how you want it. Then you can later change the schedule to export automatically once a day or as often as your organizations needs it.
Choose what time zone you’d like to use for time stamping your exported data.
Use the calendars in your Date Range option to select what time range you’d like to include in your data export.
For the source type we’ll export sensor data from a single IoT device in this demo.
Which IoT device do you want to export data for? Select your source IoT device in the drop down menu.
Pick which output data file format you’d like to use, whether it’s CSV, JSON, or SHEF.
Choose which output column names and field headers you’d like to use for your exported data. You’ll see a list of the aliases and custom field names you’ve set up previously in your device manager. If you haven’t already done this, then take a gander at our blog and HowTo docs for making these in your device manager.
If you’d like to use any threshold filtering you can set that up. You can do things like only export sensor measurements where temperature is greater than 10 degrees, humidity is less than 90%, or any other combination for anything your sensors are monitoring, whether it’s water levels, flood warning systems, water usage, flow meters, managing water resources or anything else.
Your last option in the list is sort order. You can choose whether you want to sort by ascending or descending order based on the time stamps of each of your sensor measurements.
You’re all done. Save your configuration.
Click Run Now to run your job.
Refresh your Export Jobs page and you’ll see a status update. If everything ran ok you’ll see Status OK and a time stamp for when your Export job was Last Run.
Our export job finished successfully so let’s go see the export file results on Google Drive.
Here we see our exported IoT sensor data in a .zip file on Google Drive in the folder we specified on Tools.Valarm.net
Let’s download the file and unzip it.
Now we see the CSV file inside that we can open with Microsoft Excel.
You see that we’ve now confirmed a successful export job. We’re looking at our sensor information exported from Valarm Tools to Google Drive.
That’s your overview of how to get started with your Google Drive export jobs on http://Tools.Valarm.net . Try all of the export jobs you need, like Dropbox, Microsoft OneDrive, Google Sheets, and Amazon AWS.
Please don’t hesitate to get in touch with me at Info@Valarm.net if you’ve got any questions.
And thanks for watching!