Hi I'm looking for the simplest way to get a small .txt file in csv format from my PC to an arduino uno with ethernet shield on the same local network, and then have the arduino read that data (which will then affect it's behaviour). Obviously I could physically move the SD card from the PC to the Arduino or keep the arduino connected directly to the PC but that's not going to be possible.
So far it seems a webserver might be the way to go but I was hoping I could simply push the .txt to the arduino SD card over the local network somehow and let the Arduino take it from there..?
Thanks for any help & sorry if this question seems basic., I'm just looking for the right avenue to investigate.
If your Arduino is the web server, your PC can just post the file and then the arduino can do whatever with the data, including saving it to the SD card.
If you want more of a transfer like like Serial, then look at the telnet example that comes with the ethernet library. With this, you would have to have some program on your PC to actually do the push.
Thanks Steve I was not aware of MQTT, it looks interesting.
Bill, the file is tiny and can change arbitrarily, but usually only once every few weeks. Its the coded output from my excel-based front-end for my garden watering system. I bult it in Excel because I'm ok with VBA and I can have a nice top down visual representation of the garden so I dont have to remember what plant is where. Clicking buttons increses/decreases how much water each plant gets, how cold its allowed to get at night etc.
Once the tinkering on the spreadsheet is done, it spits out about 30 numbers into a txt file. These numbers represent the new values for the variables in the arduino code.
cosmovitelli:
Thanks Steve I was not aware of MQTT, it looks interesting.
Bill, the file is tiny and can change arbitrarily, but usually only once every few weeks. Its the coded output from my excel-based front-end for my garden watering system. I bult it in Excel because I'm ok with VBA and I can have a nice top down visual representation of the garden so I dont have to remember what plant is where. Clicking buttons increses/decreases how much water each plant gets, how cold its allowed to get at night etc.
Once the tinkering on the spreadsheet is done, it spits out about 30 numbers into a txt file. These numbers represent the new values for the variables in the arduino code.
Sounds like the hard way to me. I do it all on a Raspberry Pi running Node-Red. At the garden end I have relay modules that run Tasmota software (compiled on Arduino) and sensors running on Wemos D1 Mini boards, all the code is done on the Adruino IDE.
But, if you can publish MQTT messages from Excel/VBA, a visual overview would be nice.
SteveMann:
Sounds like the hard way to me. I do it all on a Raspberry Pi running Node-Red. At the garden end I have relay modules that run Tasmota software (compiled on Arduino) and sensors running on Wemos D1 Mini boards, all the code is done on the Adruino IDE.
But, if you can publish MQTT messages from Excel/VBA, a visual overview would be nice.
I'm also working on adding a routinely updated top shot from a camera which gets inserted into the sheet background in Ecel with the buttons overlaid by the appropriate beds, with a button to jump to earlier pics so you can use it as a sort of interactive timelapse when judging how things are getting on with the current settngs.. mounting the camera is the big pain there though..