making charts-graphs

[anuj0sharma]

Hello Experts,
I have an application which periodically calculates few parameters and I want to do this.

1. I want to log this parametric data in some file or database. suggest the simplest one. [may be .dat or .txt as in VB]
2. I want to give a graphical representation to this data.
e.g. say a Time Vs Value chart of parameter1, or
A monthly consumption of power by a source in terms of bar Graph.
3. saving those records to a suitable file format to read it on PC.

How to do 1, 2 and 3?

I am in thinking phase and any type of suggestions/examples/experience are most welcome.

best regards,

 

[Erel]

1. I recommend you to use a database. DBUtils can be helpful: http://www.b4x.com/forum/basic4andr...ls-android-databases-now-simple-new-post.html
2. See the charts framework: http://www.b4x.com/forum/basic4android-getting-started-tutorials/8260-android-charts-framework.html
3. There are many options. You can just copy the database to the PC and open it. Or you can export the data to CSV, or JSON.

 

[anuj0sharma]

Thanks for the reply Erel.

3. There are many options. You can just copy the database to the PC and open it. Or you can export the data to CSV, or JSON.

3 includes graphics as well. I guess it require to use some graphical file format.

secondly, any specific reason to go for DB then normal file storage.?
do not have much experience of handling data bases. Still look for this option and try to learn.

Erel, will you able to share some example programs for 1,2 and 3.

Regards,

Edit: cant compile this code http://www.b4x.com/forum/basic...-new-post.html

I am getting this error..

Compiling code. Error
Error compiling program.
Error description: Unknown member: getcolumnname
Occurred on line: 269
sb.Append("<th>").Append(c.GetColumnName(i)).Append("</th>")
Word: getcolumnname

Regards,

 

[anuj0sharma]

ok..found the reason for the error...was using SQL 1.01..updated to 1.02.
regards,

 

[Erel]

There are examples in the provided links.

Choosing the file format depends on your program needs. A database will allow you to manipulate and extract the data in many ways.

 

[anuj0sharma]

this works when I have modified data in editBoxes...
this gives the below error if the data is same as previous data..

android.database.sqlite.SQLiteConstraintException: error code 19: constraint failed

Sub RefreshData
   Dim listOfMaps As List 
   listOfMaps.Initialize
   
   Dim data As Map   
   data.Initialize
   data.Put("Power",edtPower.Text)
   data.Put("Temperature",edtTemp.Text)
   data.Put("Ambient_Light",edtAmbLite.Text)
   data.Put("Illumination",edtIllumin.Text)

   listOfMaps.Add(data)
   DBUtils.InsertMaps(SQL,"luminaire",listOfMaps)
   
   WebView1.LoadHtml(DBUtils.ExecuteHtml(SQL,"SELECT * FROM luminaire",Null,0))   
End Sub

Edit: I guess the reason for the error is coz of duplication of primaryKey..."Power" was also specified as PrimaryKey while creating the table..
changing only power value everytime takes a new entry..please confirm on this.

 

[Erel]

I guess the reason for the error is coz of duplication of primaryKey

Yes.