#pushingbox

In the previous article, it shows the following information. 

1. Gather Temperature information & Humidity values from a DHT11 sensors to W5500-EVB

2. Communicate with a cloud server call pushing box for delivery information to a destination location. 

3. Using W5500-EVB as the gateway & pushingbox cloud server to deliver all the sensor information to twitter.

If you have any problems on how to communicate a cloud server with W5500 solution or getting a detail information about this IOT application. Please refer the previous article “Develop a IOT solution by using W5500 part 1″ for more information.

For this article, I’m going to towards one more step to manage these data into google spreadsheet for recording purpose. 

For this part, it includes the following parts need to do. 

1. Create a google spreadsheet 

2. Create a google script by java codes to dump the data into google spreadsheet

3. Set the correct format on pushingbox to delivery the message through google script link.

Create a google spreadsheet:

I think this is the most simple part for this article. As normally, most of the people will have google account or gmail account for searching information or checking emails. 

Anyways, I will still briefly shows the method on creating a google spreadsheet. 

After you had a google or gmail account, it normally includes a google drive storage system for you to save information. 

Please go to google drive page and press “New”, it should directly open a choice for google spread sheet. Please press it and it will open a blank spread sheet. The following figure shows the steps for opening a spread sheet through google drive.

After you created a spreadsheet, please modified as you want. However, the first 3 columns will use for saving the results that collected from the sensors. 

a) Received time     b) Temperature     c) Humidity 

Therefore please keep the first 3 columns for the usage on these information inputs. 

In the figure, it shows the location of ID number, this is for the usage of the script to communication with the spreadsheet. 

Before you start writing your script, please remember to unlock the editing and viewing rights to public. Therefore you could allow the script to modify the spreadsheet. 

Google Script:

For this section, I found a very useful link that I wanted to introduce to you. This developer has develop a google script that is specific for IOT application base on W5100 Ethernet shield. The developer has created a Youtube video and provided his google script to everyone to easily get used on this code. 

For more information, you may visit the following link: 

http://jarkomdityaz.appspot.com/

Scrolling down to the bottom will have all the information that you need.

By having this script, it reduce a lot of workload on developing my version of script with our W5500. Thus, I had made the following modification on the script. 

1. Adding the ID of the spreadsheet from the source code. 

2. Add an extra column for humility value

The following figure shows the modification part of the codes.

Please remember to modify all your settings before you activate these codes into Web app. 

After you had saved all these data, you are required to do the following steps to make sure this script is working normal in web app. 

1. Upload for personal use - Testing the application is it working normally. It requires access to google drive confirmation window. Please press allow to proceed  

After you pressed deploy or update, it will show the following link for you to use. 

2. Copied the link to test the script. It will show  “ok” for result.

3. Change the settings to allow other people to modified 

4. Change the values with the new link and add values into end of the link. 

&tempData=1&column_C=2

The above are the parameters input to the second and third row. (The first row is for received time)

Then, you will see the following result. 

Pushingbox delivery:

Right now, we could go back to pushingbox to put the sensor information to the spreadsheet. 

If you have any problem on this section, please refer my previous article - Develop a IOT solution by using W5500 part 1.

The following are the steps to set an whole scenario. 

1. Create a custom URL link for the location platform

2. Input the link and create a name for this service

3. Set to get format and create this service

4. Create an scenario 

5. Add an action for this scenario and put the custom URL service into this scenario

6. Add the message as below. 

Message : ?tempData=$temp$&column_C=$humid$

As you create the a new scenario, the device ID will be different. Thus, you are required to change the device ID as follow to communicate with the spreadsheet.

After you run the source code, you should see the following information from your spreadsheet.

From having the experience on developing source code for communicate with Cloud Servers, I think this is the best time for us to head into creating the whole IOT concept design. 

For the first article, I will show you the basic on communicating with W5500-EVB to another Cloud Server called Pushing box . 

After that, It will connected with DHT11 sensor to publish these data on Twitter. 

The following figure shows the section in this article.  

For this section of development, we required the following items.

1. W5500- EVB (If you don’t know anything about this Evaluation board, you may read my previous article on How to communicate with MQTT server through W5500)

2.  Ywrobot’s Easy Module Shield’s DHT11 Sensor that records Temperature and Humidity.

3. Cloud Server - This time, I will use Pushing box cloud server. This server is simple to use and it has a function that pushing the received information to the location that you wanted to post.  In example, Twitter.

For this Cloud server, it could only send out only 1000 messages per day.  

PushingBox Cloud Server

This Pushing Cloud server is very simple to register and operate. 

Link: https://www.pushingbox.com/

Registration: Using google account to login. 

As the name of this cloud server is called PushingBox, this cloud will directly push out (Send out) the data received data from the W5500-EVB to the location that you set. 

First, we need to know the location platform to push. This require us to set from “My services” setting. 

About adding devices, it means it will add the location platform for pushing those data. You could choose Twitter, email or even push to a specific link for your own use. 

For this cloud server, you are capable to modified the delivery message to the system. By setting “My Scenarios”, you could changed it in any kind of format.

As there is a default scenario in this server, we will just change this for our testing with Sensor’s result. 

After we pressed the manage button at the right corner, it will show the following information.

As the above figure shows, there are few things that you could be modified.

1. Add an extra platform to received your message. (Please remember to add the platform on My Services)

2. Editing your message

3. It could accept changing variables in certain of format. ($xxx$) 

Now, we could move to the next stage for modifying the source code for W5500-EVB.

Source code

For the source code, we will use the HTTP client reference source code for the this testing. 

The connection method to this cloud server, the IP address could find from the Help section of this website. 

 If you have any difficulties on connecting with the Cloud Server, you may read the previous blog article - How to communicate with Xively server based on W5500 chip.

The next step is changing the HTTP request method for this server. 

For the HTTP request method for PushingBox Cloud server, it is very simple. You are required to send the format as follow will be fine to communicate with the server. 

As the above figure shows, the HTTP request method does not required any key’s or password to login into the Server. 

The only requirement is the Device ID that needs to add before the Changing variables inputs.

The Changing variables name are required to define from the PushingBox "My scenarios” Section and used equal sign for adding the value for that specific variables. 

Pushing Box has provided some other API sources code. 

Please refer the link: https://www.pushingbox.com/api.php

For the method on changing the variables, you could set your code by changing the related variables from the array. The result value from the DHT11 sensor will replace those value as follow. 

About connecting with Easy Module Shield, you could also read the previous article for more information -  How to communicate with Xively server based on W5500 chip.

Finally, you will have the following result on twitter.