[SOLVED] python3, tkinter, pull down list write to file

kleinde66 · 09-12-2022, 09:55 AM

good morning all
i am by know means a programmer, with that said i try.
i have this file made from bits and pieces:

Code:

#!/usr/bin/python
# -*- coding: utf-8 -*-

from tkinter import *
from datetime import datetime
import os

root = Tk()
root.geometry( "400x200" )

def show01():
    label001.config( text = clicked001.get() )
    insulin = open("insulin.txt", "a")
    now = datetime.now()
    date = now.strftime(" %d/%m/%Y ")
    time = now.strftime(" %H:%M:%S:%f ")
    insulin.write(f' {time}')
    insulin.write(f' {date}')
    insulin.write(f' {label001 }\n')
    insulin.close()


pop001 = [
    "20 units novolog",
    "21 units novolog",
    "22 units novolog",
    "23 units novolog",
    "24 units novolog",
    "25 units novolog",
    "26 units novolog",
    "27 units novolog",
    "28 units novolog",
    "29 units novolog",
    "51 units basaglar",
    "52 units basaglar",
    "53 units basaglar",
    "54 units basaglar",
    "55 units basaglar",
    "56 units basaglar",
    "57 units basaglar",
    "58 units basaglar",
    "59 units basaglar",
    "60 units basaglar"
]

clicked001 = StringVar()
clicked001.set( "24 units novolog" )

drop001 = OptionMenu( root , clicked001 , *pop001 )
drop001.place(x=20, y=20)

button001 = Button( root , text = "click Me" , command = show01 ).place(x=175, y=20)

label001 = Label( root , text = " " )
label001.place(x=275, y=20)

def show02():
    label002.config( text = clicked002.get() )

pop002 = [
    "3 x eggs",
    "oatmeal",
    "salad",
    "peanuts",
    "porkchops",
    "1 x hamburg",
    "2 x hamburg",
    "shepards pie",
    "3 x pizza",
    "5 x pizza",
    "ice cream",
    "ice cream cake",
    "cake"
]


clicked002 = StringVar()
clicked002.set( "3 x eggs" )

drop002 = OptionMenu( root , clicked002 , *pop002 )
drop002.place(x=20, y=55)

button002 = Button( root , text = "click Me" , command = show02 ).place(x=175, y=55)

label002 = Label( root , text = " " )
label002.place(x=275, y=55)

root.mainloop()

the code is not finished.
it will run, a work in progress.
goal is to record insulin and food intake.
in two text files with time and date stamp.

my first problem is when i try to record the contents of insulin spin box.
line 19 :

Code:

     insulin.write(f' {label001 }\n')

what ever i put in there it isn't giving me what i need:

Code:

  22:46:08:956981   11/09/2022  PY_VAR0
  22:46:30:507360   11/09/2022  PY_VAR0
  23:11:18:516333   11/09/2022  <bound method Variable.set of <tkinter.StringVar object at 0x7f66369ab250>>
  23:12:51:642025   11/09/2022  PY_VAR2
  23:13:23:440598   11/09/2022  PY_VAR3
  23:13:24:232237   11/09/2022  PY_VAR4
  23:14:48:589680   11/09/2022  .!label

i have tried several things, the out put should look like:

Code:

  23:14:48:589680   11/09/2022  (contents of spin box)

def show02 works but it doesn't time and date stamp.
i'm going to have the same thing with time/date with it too.

p.s.
after i have the two files, i'm going to try to use that data in a existing data base .sqlite from my glucose meter.

thanks in advance for any help or guidance.

boughtonp · 09-12-2022, 10:54 AM

Your title says "python3" but your script says "/usr/bin/python" which is usually Python 2.

You should check with "/usr/bin/python --version" and if it isn't 3.something then switch the script to either "/usr/bin/python3" or "/usr/bin/env python3"

To get the contents of the dropdown, you should read the contents of the dropdown, i.e. change

Code:

insulin.write(f' {label001 }\n')

to

Code:

insulin.write(f' {clicked001.get()}\n')

There are a number of other things I would do differently in your script, but that's the simplest change to get it doing what you ask.

Since you mention SQLite, I will point out that its primary date/time format is ISO 8601 and it's usually a good idea to use a variation of that for any log files - e.g. "now.strftime('%Y-%m-%d %H:%M:%S.%f')"

kleinde66 · 09-12-2022, 11:53 AM

thank you boughtonp
worked great
will my two text files into-grate with my .sqlite file?

boughtonp · 09-12-2022, 12:13 PM

Quote:

Originally Posted by kleinde66

will my two text files into-grate with my .sqlite file?

If you format them as CSV files, you could probably use the Sqlite import command to read their data.

Or you could simply use Python's sqlite3 module to interface directly with a database file instead of the text files.

(Either way, you'll want to ensure you have a safe verified backup of all important data.)

kleinde66 · 09-12-2022, 01:21 PM

thank you boughtonp
i looked at your two suggestions and will have to do a lot of reading, i know nothing of CSV files and as far as the database files
i only have access to them after they are downloaded from the meter. so i will have to add my files to the file created by the meter.

kleinde66 · 09-12-2022, 03:00 PM

boughtonp
i chose to convert the text file to csv file.
then i went in and changes the program to write straight to csv file.
the files seem to be fine, DB Browser for SQLite Version 3.12.2 opens the files.
now i need to learn how to plot.