Arduino DS18B20 temperature sensor data logging to CSV/Excel

[@MohamedElPrince]

David , i am facing a problem with my project , i want to connect the TX ( DS18B20 + Arduini uno + NRF24L01 ) with the RX ( arduino uno + 16*2 LCD ) , i want o send he temp data from the tx to the rx

[@sammyyboyy12]

I actually used the DS18B20 before in a school weather balloon. I was using PICAXE but it was really simple to use. I don't know much about components but I did think this was a good one.

[@raschad007]

Great project, I'm doing a research and this seems perfect for a budget data longer using on hand parts

[@phils6926]

Hello there, Super stuff, nice presentation. Far from not very interesting, it's just up my street. I'm building up a network of sensors with a view to improving my house energy efficiency - it's a mix of utility meter monitoring, XBee's and active control of room temperatures etc. Some of it is still on commercial stuff like USB temperature loggers, but involves climbing ladders. I will use your code to get going as I'm too old to be a good programmer and breaking pelvis after unplanned exit from loft tells me there's a better way. Thanks again

[@Theresamallory9279]

Thank you David, great video. I am doing a similar project, but am looking to get data from eight different temp sensors. I am using the DS18B20 sensors as well. Any recommendations?

[@DavidWatts]

No real advice needed, each sensor can have a unique address so you are pretty much set. I would really like to see your setup when it is done, I haven't tried reading from multiple locations before.

[@stagcapri]

fantastic but I'm not getting a time stamp like your video the second file stays empty

[@shisqo]

Do you know what is the configuration for this sensor could work with labview?

[@nourqrahmohammad5280]

hello , how i can save the data of the temperature sensor through sd card module used for arduino ?

[@meteoroman100]

Great video! Unfortunately, I don't have the LCD display and the shield. Is there an alternative way? Can I simply eliminate the LCD and SD references in the sketch?

[@beehive808]

Thanks to David Watts and Richard F, I got the code to verify

[@jaguarpaw1638]

hi great presentation and project do you have a circuit diagram?

[@terrehautehackers]

If I change the code a little can I use a serial lcd, or is it being used?

[@beehive808]

David, I want to try your code, but I get a error of \libraries\SD\src\utility\Sd2Card.ccp: In function 'void spiSend(uint8_t)' Where can I find the libraries you used?

[@DavidWatts]

I have just updated the zip file to included the libraries, download it again and they will be included. You can add them to your libraries folder.

[@beehive808]

Thanks

[@beehive808]

Dave I download your zip file, but I still get the following error Arduino: 1.5.4 (Windows 7), Board: "Arduino Uno" C:\Users\Ron\Documents\Arduino All types of Files 131017\arduino-1.5.4-r2-windows\arduino-1.5.4\libraries\SD\src\utility\Sd2Card.cpp: In function 'void spiSend(uint8_t)': C:\Users\Ron\Documents\Arduino All types of Files 131017\arduino-1.5.4-r2-windows\arduino-1.5.4\libraries\SD\src\utility\Sd2Card.cpp:35: error: 'SPI' was not declared in this scope C:\Users\Ron\Documents\Arduino All types of Files 131017\arduino-1.5.4-r2-windows\arduino-1.5.4\libraries\SD\src\utility\Sd2Card.cpp: In function 'uint8_t spiRec()': C:\Users\Ron\Documents\Arduino All types of Files 131017\arduino-1.5.4-r2-windows\arduino-1.5.4\libraries\SD\src\utility\Sd2Card.cpp:44: error: 'SPI' was not declared in this scope C:\Users\Ron\Documents\Arduino All types of Files 131017\arduino-1.5.4-r2-windows\arduino-1.5.4\libraries\SD\src\utility\Sd2Card.cpp: In member function 'uint8_t Sd2Card::init(uint8_t, uint8_t)': C:\Users\Ron\Documents\Arduino All types of Files 131017\arduino-1.5.4-r2-windows\arduino-1.5.4\libraries\SD\src\utility\Sd2Card.cpp:251: error: 'SPI' was not declared in this scope C:\Users\Ron\Documents\Arduino All types of Files 131017\arduino-1.5.4-r2-windows\arduino-1.5.4\libraries\SD\src\utility\Sd2Card.cpp: In member function 'uint8_t Sd2Card::setSckRate(uint8_t)': C:\Users\Ron\Documents\Arduino All types of Files 131017\arduino-1.5.4-r2-windows\arduino-1.5.4\libraries\SD\src\utility\Sd2Card.cpp:507: error: 'SPI' was not declared in this scope

[@DavidWatts]

bee Hive Hi, I am using an older version than you it seems. I hadn't checked in a while. I am using 1.0.5 so that could well be the reason. I will look at updating it. Use the SD-->Datalogger example in your version of Arduino IDE and copy out the appropriate code for initialising and writing.

[@chollidfadillah184]

Hai David, thanks for your video but I ask for something on your code.. Why text in the serial monitor not reading?

[@DavidWatts]

Can you be more specific about your problem?

[@chollidfadillah184]

David Watts has been done. Thanks

[@komandyko]

The data is stored in .txt, not in .csv :( Can you help me with the code to save in csv? tkx

[@DavidWatts]

You just change the files extension from txt to csv on your computer, or set it as csv in your code. The file is encoded as a CSV as it is created, I had it set to txt just so I could open it up in notepad by default. CSV stands for comma-separated values which is how this file is encoded.

[@romanroman1975]

Well done, thank you for the code!

[@komandyko]

Thanks for answering, you did a great job, good night

[@DavidWatts]

You are very welcome.

[@kiko59bis]

Hey David. I'd like to know which resistors do you use for 1) the LCD screen, 2) the temp sensor. I had to set a potentiometer to display correctly on the lcd screen. Thanks a lot. Antoine

[@DavidWatts]

Thanks for the comment Antoine. I think it was 560 ohms for the LCD backlight and 4.7k for the DS18b20 pull-up.

[@kiko59bis]

Thanks David! I'm building a sprinkler system for the garden and I'm also adding kind of meteo station.

[@gurleenkaur4996]

hi david, it will really be helpful if share me code and schematic wiring connection of this project

[@MrBobWareham]

Love your videos but when you show your code can you make it bigger so it is easy to follow with your discription please Many thanks Bob

[@m0gga]

Great project, thanks for sharing. I am curious as to why you used an Ethernet shield which was hogging all your pins, was it just to make use of the on board sd card? If so, surely you could have used an Arduino data logging shield instead, cheap as chips and not as pin hungry :).

[@DavidWatts]

+Fred Morris It was just what I had handy at the time I think, My preference now would be to just use an SD card module.

[@kalbjungblut]

Hello, Is the connection with the LCD really necessary? If I just need the Data as Excel later, should it be enough, if I just change the code of yours, so it just save it like that?

[@DavidWatts]

+THe newone No need for the LCD at all

[@agrxdrowflow958]

Very nice. You rock!

[@DavidWatts]

+Scott Wolford Thanks mate :-)

[@jakaknafelc6638]

Great project. Thanks for code.

[@nielsdaemen]

4:52 Wow, thats realy beatiful code to bad i can't read it! Seriously, what screenrecorder do you use????

[@DavidWatts]

No idea, this was over 4 years ago.

[@yrecious]

Hello david, How did you add date and time

[@deeshan555]

hello, very nice video dude, im currently working on a particular project in order to monitor temperatures at different places. how do i do to add more temperature sensors on the same board? thnks.

[@DavidWatts]

+Deeshan Zeline You can add multiple sensors but you need to find out the address for each one. This is a great tutorial on that - arduino-info.wikispaces.com/Brick-Temperature-DS18B20 (find this bit - Read Temperatures from multiple DS18B20 sensors on 1 Arduino Pin:)

[@kimbeleh]

Hey, I'm logging data at the moment using your setup. One question i have, could you also make your excel sheet available? i really suck at charting. would really help. Thanks in advance and great vid.

[@DavidWatts]

Sure, here you go. I don't have excel, it is an open office document. I hope that is ok. davidjwatts.com/youtube/TEMPER.zip

[@kiwimgti3644]

David I like your project nice work can you help me with the code to use multiple DS 18 B 20 sensors and display on an ST7735 OLED?

[@Hibaebnbary]

thnk you sooo much you really helped me ,, GOD bless you

[@emilysigmund8896]

Hi David, thank you for the video. Can you share the code? It's not readable in the video :( I'd like to use this setup on my project.

[@DavidWatts]

Emily Sigmund Hi Emily, thanks for the comment. The code is in the video description.

[@emilysigmund8896]

David Watts You're too kind! I hope you have the best day :D

[@gedtoon6451]

Can't access your source code. Can you give an updated link?

[@DavidWatts]

Looks like the link needed the https, try that now.

[@gedtoon6451]

@@DavidWatts​ Thanks, got it! This video is 10 years old, but is still relevant.

[@AlexMStarr]

Thanks man ☺ really interesting vid, well presented. Off to find out more on Arduino now.. Cheers

[@DavidWatts]

You are most welcome, if you need any help or advice just give me a shout.

[@cangmengen5252]

Hi David! Nice Video bro!! One question, I couldn't see your code clearly, can you please show me your code as I want to log the temp sensor data into a text file, but I am not sure how to do it.

[@DavidWatts]

+CANG MENGEN Hi, the code is in the video description to download.

[@anlkocakurek3800]

Hello David, Thank you for your video. Do you have circuit schematic ?

[@DavidWatts]

anıl kocakürek Sorry, this was a couple of years ago now and I don't have anything from that time anymore.

[@cybergogo1111]

Hi David, the code works well, i've got the display on the lcd, the sd card is detected and is working because i can see the .txt files when i put it in my laptop. But there is no data in the files. Is there a procedure to follow to disconnect the SD card correctly?

[@DavidWatts]

Hi Mate, the best thing you can do is to add some serial output statements in the 'writeDataToCard' function to see if it is triggering. It records the temperature data every minute so you may want to decrease that for testing.

[@carmenvillafruela7400]

hi great explanation! is there any way to read the csv from arduino?

[@DavidWatts]

+Carmen Villafruela Sure, it is just like reading any text file with a bunch of 'if' statements to filter the data.

[@j.m.b.4252]

can i use the thermocouple for my temperature?

[@DavidWatts]

+J. M. B. Sure, Adafruit has a great tutorial - learn.adafruit.com/thermocouple/

[@tanmayagarwal8513]

Video is amazing! But unfortunately, the link for the code ain't working anymore.

[@DavidWatts]

Copy the link and paste it into a new tab, it does work.

[@tanmayagarwal8513]

@@DavidWatts Yep it does work! Thanks!

[@44avalanche]

Good job!

[@jrayalac]

thanks dude!

[@duongxuanthuy8199]

Thank you

[@kiwimgti3644]

And datalog to a teensy 3.6

[@CampuStellae]

Hello What is the software's name ...? Thanks

[@DavidWatts]

Johnny Limia Hi mate, sorry for the late reply. You can grab the code from the video description.

[@vrishabin7910]

The code is written in Arduino IDE ( arduino.cc/en/main/software ) The logged data is loaded in Openoffice ( www.openoffice.org/download/ ) - which is open source equivalent of MS excel

[@karthigeshsiva6461]

Hi David, would you please send the code ?

[@DavidWatts]

Or you could download it from the description

[@alaninkarachi]

David, been trying to send you a message on your web site. I fill in the forms (appear unlabeled) and cannot get a confirmation my message has been sent. Please pm me with contact details. Need project help. Tks

[@DavidWatts]

Hi Alan, you are better off posting in the MKme community. Lots of people there can help and I will pop along and take a look. plus.google.com/communities/103332553771769294133

[@ouicham]

thanx a lot :)

[@nielsdaemen]

1:50 Could you please stop shaking that camera!