It is possible to upload data to Explainum chart just from local folder, and have it updated every day. Below, I will explain how to do this using as example my chart where just for fun I indicate my mood and explain changes in it.
To do something like this you will need cloud-based file-sharing service, e.g. Dropbox. Every registered on Dropbox user gets 2GB of space for free which is more than enough for our purpose. Once you have installed Dropbox on your computer -- notice that it has created folder named Public.
Create CSV-formatted file, using either Notepad or Excel. If you prefer Excel -- in Excel create a table on a sheet. This is how it looks in my case:
Then save it using Save As command as Comma Separated Values (CSV) file to the Dropbox's Public folder. When you save file into a Dropbox's folder, Dropbox automatically uploads it into its web-based cloud storage.
After saving I recommend to open it once again in Notepad to check date format, as Excel can have its own date formatting preferences.
When the CSV file is ready get the public link for the file -- right-click on the file and choose in the context menu Dropbox -> Copy Public Link.
Finally, the last step -- go to Explainum, create chart, add new series using "CSV file over HTTP" data source. Then just paste the copied public link and choose appropriate date format. Don't forget to check Autoupdate checkbox to force Explainum get updates from your file every 24 hours.
Complete uploading by following instructions. Your chart is created. Now, when you add new rows in your local CSV file, your chart is automatically updated every 24 hours with this new rows. View it, comment it and share it with others.
Here is how my chart look like (it's interactive -- try playing with it):
Every day I add new row with date and value to my local CSV file, which then is automatically uploaded into Explainum and added to the chart.

This won't work with Dropbox, because it enforces HTTPS over HTTP...
ReplyDelete