Help csv data to tinydb or list

[gurusonwheels (Brian)]

I have a data from a website thats being output to a csv file .

im grabbing like this :

i would like to put the data in a tinydb and update it every 10 min thats what my timer is set to .

my data looks like this

“device_id”,“type”,“bucket_step_minutes”,“timestamp”,“wind_lull”,“wind_avg”,“wind_gust”,“wind_dir”,“wind_interval”,“pressure”,“temperature”,“humidity”,“lux”,“uv”,“solar_radiation”,“precip”,“precip_type”,“strike_distance”,“strike_count”,“battery”,“report_interval”,“local_daily_precip”,“precip_final”,“local_daily_precip_final”,“precip_analysis_type”
80500,obs_st,null,1597173090,0,0,0,0,3,991,31.7,66,135470,5.15,1129,0,0,0,0,2.73,1,0,0,

this is my first time using this . any help would be appreciated .

tinydb a list or dictionary whatever would be easiest to search for a key later
and return its value

actually i can get more data from a json file over the web but it looks like this
and i have no idea where to start if i used it .

obs lines 0-19 are define like this :

[Mohamed_Tamer]

You can try list or csv ( can be converted easily to list )…Dictionaries must have key and value and your csv doesn’t have…You can store it as list then use select list item to slect the item you want by it’s index…
To convert csv to list use this block:

[gurusonwheels (Brian)]

1st line of csv is the keys

“device_id”,“type”,“bucket_step_minutes”,“timestamp”,“wind_lull”,“wind_avg”,“wind_gust”,“wind_dir”,“wind_interval”,“pressure”,“temperature”,“humidity”,“lux”,“uv”,“solar_radiation”,“precip”,“precip_type”,“strike_distance”,“strike_count”,“battery”,“report_interval”,“local_daily_precip”,“precip_final”,“local_daily_precip_final”,“precip_analysis_type”

second line is the values for the keys

80500,obs_st,null,1597173090,0,0,0,0,3,991,31.7,66,135470,5.15,1129,0,0,0,0,2.73,1,0,0,0,0

[Mohamed_Tamer]

Then you can store it as dictionary…You can see here:

Guide: Dictionary Blocks

0 — Basics 0.1 — What Is Dictionary Dictionary is actually object JSON. Therefore, you have to know the basics of JSON. It is a way to store information in an organized, easy-to-access manner. It is formed with a key, and a value. It is called a pair. It uses a key to call the value. If you still don’t understand, search on Google for more information. Dictionary in Kodular is a built-in block. [image] Object uses { bracket at the start, } at the end. Colon is between the key and the value. C…

Simple use of dictionary and TinyDB

Introduction Have you ever use tinyDB or other databases to store value? When there are so many data you have to store, you won’t want to store it with so many call tinyDB store block. Therefore, the dictionary can be used to help. What is a dictionary? Dictionary is a built-in component. Generally speaking, a dictionary uses a key to call and get the value. For example, It will return the string "whatever". [blocks (2)] How to use it? As mentioned, a dictionary uses a key to call and ge…

[gurusonwheels (Brian)]

i copied this little project and changed the json file to mine .

keep getting error

attached is project
test.aia (3.2 KB)

you can get the weather.json file from the assets .

this is how the file is served to me from the provider .
whats going on

[gurusonwheels (Brian)]

a csv does not contain colons . comma separated values . many csv are exported the way mine is i have no control how the manufacture exports there data .

i just want to use the data .

im not a programmer . i just need a little help . thanks ahead .

ive been reading on the json file and i think that error is coming because its a nested json file … but i could be wrong .

[Mohamed_Tamer]

@gurusonwheels

a csv does not contain colons . comma separated values

CSV basicly is a Comma-Seperated-Values…
It must be a comma seperated value…Else it won’t be a CSV…I will see your aia and i’ll try to help

[Boban (Boban Stojmenovic)]

[gurusonwheels (Brian)]

that works . can you please walk me through your index logic so i can understand it …

also any way to turn that data into a dictionary now . when i try turning into dictionary i get stuck because of the formatting of the json with no values at some places .

thanks for your help

[Rogerio_Rios (Professional Support)]

@gurusonwheels

can you please walk me through your index logic so i can understand it …

Exercise of logical reasoning… Try it, you will make it

[gurusonwheels (Brian)]

think i figured it . 1 and 2 or the first two sections of the json and 5 is the 5th . skipping the problemmatic 4th section that had no values and skipping the 3rd as it was not needed …

correct ?

so this includes data from all three sections or only the 5th

[Rogerio_Rios (Professional Support)]

@gurusonwheels

think i figured it . 1 and 2 or the first two sections of the json and 5 is the 5th . skipping the problemmatic 4th section that had no values

1- He gave you the solution.
2- Did you understand that it is the solution
3- Study what you received
4- Keep it as learning …

[gurusonwheels (Brian)]

i know he gave me the solution … and i marked as so … but im trying to understand the solution
and asking you if what i wrote is the reason the solution works .

i dont know how else to word it .

will never learn if no one confirms what i suspect .

its like watching a video of something and repeating . monkey see monkey do …
if you dont understand it your still no better off .

i want to understand .

[Rogerio_Rios (Professional Support)]

@gurusonwheels

but im trying to understand the solution

Again: read the solution, study it … it’s all you have to do to learn …

[Boban (Boban Stojmenovic)]

I’m not good in explaining how all this works so you would understand, but you can read from some links in post below…

Can we programmatically generate lists, such that we don't have to manually assign a new variable to each new list?

How to work with Lists by Saj How to work with Lists and Lists of lists (pdf) by appinventor.org A very good way to learn App Inventor or Kodular is to read the free Inventor’s Manual here in the AI2 free online eBook App Inventor 2 Book: Create Your Own Android Apps … the links are at the bottom of the Web page. The book ‘teaches’ users how to program with AI2 blocks. There is a free programming course here Course In A Box and the aia files for the projects in the book are here: App …

@gurusonwheels

also any way to turn that data into a dictionary now

First time playing with dictionary so I wouldn’t know exactly how to explain this either

[Rogerio_Rios (Professional Support)]

@Boban

I’m not good in explaining how all this works so you would understand

But , understanding the solutions , is part of learning, from him, who received the solution.

[gurusonwheels (Brian)]

thank you very very much .