Lovro Bajc

Hi,

finally have come to solution. Minor changes and it works fine. I believe also that there can be other ways to do it in order to be more efficient.

here are the modifications:

happinessDb class modifications:

public ArrayList<Integer> getDataForGraph() { ArrayList<Integer> happyValues = new ArrayList<Integer>(); String[] columns = new String[]{KEY_ROWID, KEY_DATE, KEY_TIME,KEY_HAPPY, KEY_NORMAL, KEY_SAD }; Cursor c = ourDatabase.query(DATABASE_TABLE, columns, null, null, null, null, null); //Read the data from columns with cursor int result = 0 ; int iHappy = c.getColumnIndex(KEY_HAPPY); for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()){ result =Integer.parseInt(c.getString(iHappy)); happyValues.add(result); } return happyValues; }

and in Chart class:

public void happyDataFromDb() { happinessDb happyInfo = new happinessDb(this); try { happyInfo.open(); } catch (SQLException e) { e.printStackTrace(); } ArrayList<Integer> data = happyInfo.getDataForGraph(); //myNum = Integer.parseInt(data); happyInfo.close(); happyList = data; }

Hi

I have sort of the same problem. I need to obtain the data in Chart Activity from the database class and use it to populate chart. Since it is dynamic chart I created an ArrayList of Integers, however how to populate it with integers from database class I have no idea.

so far I have come up with a method in Chart calss:



public class Chart extends Activity { public ArrayList<Integer> happyList = new ArrayList<Integer>(); @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_chart); // readHappyLog(); happyDataFromDb(); } public void happyDataFromDb() { happinessDb happyInfo = new happinessDb(this); try{ happyInfo.open(); }catch (SQLException e) { e.printStackTrace(); } happyList = happyInfo.getHappyData(); happyInfo.close(); }

Class getHappyData in the database should return the integers ArrayList HappyList. And here I have an issue how to obtain the integers and put them into HappyList in Chart.class.


public ArrayList<Integer> getHappyData() { String[] columns = new String[]{KEY_ROWID, KEY_DATE, KEY_TIME,KEY_HAPPY, KEY_NORMAL, KEY_SAD }; Cursor c = ourDatabase.query(DATABASE_TABLE, columns, null, null, null, null, null); String result = ""; int iHappiness = c.getColumnIndex(KEY_HAPPY); for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()){ result = result + c.getInt(iHappiness); } return ; }

any advice would be much appreciated.

thank you for your time.

Hi,

I am trying to obtain the ArrayList of Integers from database to be used with the activity containing the Chart (mChartEngine). When the Chart activity (OnCreate) is initiated the code looks for the method happyDataFromDb. It's main purpose should be to obtain the integers from the happinessDb (SQLite database) and store it in an array called happyList in Char activity.

after I try to run the activity i get an error leading to the addHappyData which is initiated for drawing the chart specifically in for loop.

help would be much appreciated!

brg

HappinesDB:

public class happinessDb { public static final String KEY_ROWID = "_id"; public static final String KEY_DATE = "date"; public static final String KEY_TIME = "time"; public static final String KEY_HAPPY = "happy"; public static final String KEY_NORMAL = "normal"; public static final String KEY_SAD = "sad"; public static final String DATABASE_NAME = "happinesMeter"; public static final String DATABASE_TABLE = "practiceReport"; public static final int DATABASE_VERSION = 2; private DbHelper ourHelper; private final Context ourContext; private SQLiteDatabase ourDatabase; //Obtain the integers from the database table public ArrayList<Integer> getHappyData() { String[] columns = new String[]{KEY_ROWID, KEY_DATE, KEY_TIME,KEY_HAPPY, KEY_NORMAL, KEY_SAD }; Cursor c = ourDatabase.query(DATABASE_TABLE, columns, null, null, null, null, null); int result= 0; int iHappiness = c.getColumnIndex(KEY_HAPPY); for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()){ result = result + c.getInt(iHappiness); } return null; } private static class DbHelper extends SQLiteOpenHelper{ public DbHelper (Context context){ super(context, DATABASE_NAME, null, DATABASE_VERSION); } @Override public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE " + DATABASE_TABLE + " (" + KEY_ROWID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + KEY_DATE + " TEXT NOT NULL, " + KEY_TIME + " TEXT NOT NULL, " + KEY_HAPPY + " TEXT NOT NULL, " + KEY_NORMAL + " TEXT NOT NULL, " + KEY_SAD + " TEXT NOT NULL);" ); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE); onCreate(db); } } public happinessDb(Context c){ ourContext = c; } public happinessDb open() throws SQLException{ ourHelper = new DbHelper(ourContext); ourDatabase = ourHelper.getWritableDatabase(); return this; } public void close(){ ourHelper.close(); } public long createEntry(String date, String time, String happy, String normal, String sad) { ContentValues cv = new ContentValues(); cv.put(KEY_DATE, date); cv.put (KEY_TIME, time); cv.put(KEY_HAPPY, happy); cv.put(KEY_NORMAL, normal); cv.put(KEY_SAD, sad); return ourDatabase.insert(DATABASE_TABLE, null, cv); //Insert all puts to table }


Chart Activity:

public class Chart extends Activity { public ArrayList<Integer> happyList = new ArrayList<Integer>(); public ArrayList<Integer> normalList = new ArrayList<Integer>(); public ArrayList<Integer> sadList = new ArrayList<Integer>(); //Chart creation private GraphicalView mChart; private XYMultipleSeriesDataset mDataset = new XYMultipleSeriesDataset(); private XYMultipleSeriesRenderer mRenderer = new XYMultipleSeriesRenderer(); private XYSeries mCurrentSeries; private XYSeriesRenderer mHappyRenderer; private XYSeries mNormalSeries; private XYSeriesRenderer mNormalRenderer; private XYSeries mSadSeries; private XYSeriesRenderer mSadRenderer; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_chart); happyDataFromDb(); } public void happyDataFromDb() { happinessDb happyInfo = new happinessDb(this); try{ happyInfo.open(); }catch (SQLException e) { e.printStackTrace(); } happyList = happyInfo.getHappyData(); happyInfo.close(); } //Create a method for the aChart engine private void initChart() { /** * Add all series to mDataset */ //Happy kids series mCurrentSeries = new XYSeries("Amount of happy kids"); //Creating Happy kids series mDataset.addSeries(mCurrentSeries); //Adding data to Happy kids series //Renderer for happy kids and line characteristics mHappyRenderer = new XYSeriesRenderer(); mRenderer.addSeriesRenderer(mHappyRenderer); mHappyRenderer.setColor(Color.GREEN); mHappyRenderer.setLineWidth(10f); //Normal kids series mNormalSeries = new XYSeries("Amount of normal kids"); mDataset.addSeries(mNormalSeries); //Renderer for normal Kids and line characteristics mNormalRenderer = new XYSeriesRenderer(); mRenderer.addSeriesRenderer(mNormalRenderer); mNormalRenderer.setColor(Color.BLUE); mNormalRenderer.setLineWidth(10f); //Sad kids series mSadSeries = new XYSeries("Amount of sad kids"); mDataset.addSeries(mSadSeries); //Renderer for sad kids and line characteristics mSadRenderer = new XYSeriesRenderer(); mRenderer.addSeriesRenderer(mSadRenderer); mSadRenderer.setColor(Color.RED); mSadRenderer.setLineWidth(10f); //Applying renderer style mRenderer.setAxisTitleTextSize(20); mRenderer.setYLabelsPadding(20); mRenderer.setXLabelsPadding(20); mRenderer.setXTitle(" Date "); mRenderer.setYTitle(" Number of kids "); mRenderer.setApplyBackgroundColor(true); mRenderer.setBackgroundColor(Color.WHITE); mRenderer.setMarginsColor(Color.BLACK); mRenderer.setShowGrid(true); mRenderer.setAxesColor(Color.MAGENTA); mRenderer.setGridColor(Color.MAGENTA); mRenderer.setShowCustomTextGrid(true); } //Add x and y data to series from the array list private void addHappyData() { Integer x = 20; for (Integer happy : happyList) { mCurrentSeries.add(x += 20, happy); } } // Draw the graph @Override protected void onResume() { super.onResume(); LinearLayout layout = (LinearLayout) findViewById(R.id.chart); if (mChart == null) { initChart(); addHappyData(); addNormalData(); addSadData(); mChart = ChartFactory.getCubeLineChartView(this, mDataset, mRenderer, 0.3f); layout.addView(mChart); } else { mChart.repaint(); } } }

Hi everyone,

I am trying to create an onClick method where upon pressed state application would save data in csv to specific folder on public directory. After every click, the application would append the data to that single file which was created the first time. When I run the application, the folder is created and also is the "happy_log.csv, however when i further press the save button it does not add extra line with new data. So far my code looks like this:

public void saveLogOnClick(View view) { String FILENAME = "happy_log.csv"; //Obrain the current text in the files convert it to string and save it to .csv file String entry = edtDate.getText().toString() + "," + edtTime.getText().toString() + "," + happyScore.getText().toString() + "," + normalScore.getText().toString() + "," + sadScore.getText().toString() + "\n"; //Open a file with the streamer/pointer try { File directoryDownload = Environment.getExternalStoragePublicDirectory(Environment.DIRECTORY_DOWNLOADS); File logDir = new File (directoryDownload, "Happy App Logs"); //Creates a new folder in DOWNLOAD directory logDir.mkdirs(); File file = new File(logDir, FILENAME); FileOutputStream out = new FileOutputStream(file); out.write(entry.getBytes()); //Write the obtained string to csv out.close(); toastIt("Entry saved"); } catch (Exception e) { e.printStackTrace(); } }

assistance on this matter would be much appreciated.

Found the solution In the OnCreate the setContentView was missing.

Hi Everyone,

everything was working fine till yesterday, and that out of nowhere appeared following problem. Once the main activity is started there are two buttons which based on the selection initiate new activity. The onClick method checkStats works normally, however method startHappinessMeter (uppon click) results in "Unfortunately, Happy App has stopped":

Main Activity code:

public class MainActivity extends Activity { @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); } @Override public boolean onCreateOptionsMenu(Menu menu) { // Inflate the menu; this adds items to the action bar if it is present. getMenuInflater().inflate(R.menu.main, menu); return true; } @Override public boolean onOptionsItemSelected(MenuItem item) { // Handle action bar item clicks here. The action bar will // automatically handle clicks on the Home/Up button, so long // as you specify a parent activity in AndroidManifest.xml. int id = item.getItemId(); return id == R.id.action_settings || super.onOptionsItemSelected(item); } public void startHappinessMeter(View view) { Intent intent = new Intent(this, happinessMeterMeassurement.class); startActivity(intent); } public void checkStats(View view) { Intent intent = new Intent(this, checkStats.class); startActivity(intent); } }



Error which is returned when I press the button:



E/AndroidRuntime﹕ FATAL EXCEPTION: main java.lang.RuntimeException: Unable to start activity ComponentInfo{com.sportelitemanagement.animus.happyapp/com.sportelitemanagement.animus.happyapp.happinessMeterMeassurement}: java.lang.NullPointerException at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2266) at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2316) at android.app.ActivityThread.access$600(ActivityThread.java:150) at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1298) at android.os.Handler.dispatchMessage(Handler.java:99) at android.os.Looper.loop(Looper.java:213) at android.app.ActivityThread.main(ActivityThread.java:5225) at java.lang.reflect.Method.invokeNative(Native Method) at java.lang.reflect.Method.invoke(Method.java:525) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:741) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:557) at dalvik.system.NativeStart.main(Native Method) Caused by: java.lang.NullPointerException at com.sportelitemanagement.animus.happyapp.happinessMeterMeassurement.onCreate(happinessMeterMeassurement.java:26) at android.app.Activity.performCreate(Activity.java:5133) at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1087) at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2230)             at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2316)             at android.app.ActivityThread.access$600(ActivityThread.java:150)             at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1298)             at android.os.Handler.dispatchMessage(Handler.java:99)             at android.os.Looper.loop(Looper.java:213)             at android.app.ActivityThread.main(ActivityThread.java:5225)             at java.lang.reflect.Method.invokeNative(Native Method)             at java.lang.reflect.Method.invoke(Method.java:525)             at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:741)             at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:557)             at dalvik.system.NativeStart.main(Native Method)

I checked the line 26 in below provided java file and I cant understand why it guides me to the greatBtn onClick listener?

package com.sportelitemanagement.animus.happyapp; import android.content.Intent; import android.os.Bundle; import android.support.v7.app.ActionBarActivity; import android.view.View; import android.widget.Button; import android.widget.Toast; public class happinessMeterMeassurement extends ActionBarActivity implements View.OnClickListener { private static final String GREAT_COUNTER = "great_counter"; private static final String NORMAL_COUNTER = "normal_counter"; private static final String SAD_COUNTER = "sad_counter"; Button greatBtn, normalBtn, sadBtn; int greatCounter, normalCounter, sadCounter; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); //Initiate variables from XML and for counting greatBtn = (Button) findViewById(R.id.great); greatBtn.setOnClickListener(this); normalBtn = (Button) findViewById(R.id.feelingNormal); sadBtn = (Button) findViewById(R.id.feelingSad); normalBtn.setOnClickListener(this); sadBtn.setOnClickListener(this); greatCounter = 0; normalCounter = 0; sadCounter = 0; } //Save the current values when the screen changes @Override protected void onSaveInstanceState(Bundle outState) { super.onSaveInstanceState(outState); outState.putInt(GREAT_COUNTER, greatCounter); outState.putInt(NORMAL_COUNTER, normalCounter); outState.putInt(SAD_COUNTER, sadCounter); } //Recall values when activity is recreated. @Override protected void onRestoreInstanceState(Bundle savedInstanceState) { super.onRestoreInstanceState(savedInstanceState); //repopulate values when the activity is resumed and private static final needs to be created greatCounter = savedInstanceState.getInt(GREAT_COUNTER); normalCounter = savedInstanceState.getInt(NORMAL_COUNTER); sadCounter = savedInstanceState.getInt(SAD_COUNTER); } public void showStats(View view) { Intent intent = new Intent(this, checkStats.class); //Converts the obtained clicks to String for transfer String feelingGreat = String.valueOf(greatCounter); String feelingNormal = String.valueOf(normalCounter); String feelingBad = String.valueOf(sadCounter); //Sends the values to the new intent intent.putExtra("greatCounter", feelingGreat); intent.putExtra("normalCounter", feelingNormal); intent.putExtra("sadCounter", feelingBad); startActivity(intent); } }


Help would me much appreciated!

best regards

Ulf Dittmer wrote:So now everything works ?

Yep work perfectly, thanks a lot. Just one more question still regarding the previous post you made:

Ulf Dittmer wrote:What is the point of storing data as file (no matter the format) if the same app reads it later? Why not keep it in memory?

Obviously there would be a lot of practices and variables stored after certain period of time. Would you still keep it in memory or would you go for something else? I am quite new on this side as you have probably noticed, so any suggestion is most helpful to open my horizons .

thank you again

brg

Ulf Dittmer wrote:You misunderstood. What are the *actual* values? Not what you think they are, but what they actually are. Print them out and make sure they match your assumptions.

Thanks for assisting me with the basic print idea . Since array values were exactly what it was stored in the csv,I took a look at the following part from bottom up and correct it:

public class Chart extends Activity { ArrayList<Integer> stateList = new ArrayList<Integer>(); ArrayList<Integer> normalList = new ArrayList<Integer>(); //Chart creation private GraphicalView mChart; /** * Create multiple data sets to be used on graph */ //Data sets used for graph manipulation private XYMultipleSeriesDataset mDataset = new XYMultipleSeriesDataset(); private XYMultipleSeriesRenderer mRenderer = new XYMultipleSeriesRenderer(); private XYSeries mCurrentSeries; private XYSeries mNormalSeries; private XYSeriesRenderer mHappyRenderer; private XYSeriesRenderer mNormalRenderer; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); // Code which makes activity full screen getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN); setContentView(R.layout.activity_chart); readHappyLog(); } //Create a method for the aChart engine private void initChart() { //Creating series for Happy and normal kids mCurrentSeries = new XYSeries("Amount of happy kids"); //Creating Happy kids series mDataset.addSeries(mCurrentSeries); //Adding data to Happy kids series mNormalSeries = new XYSeries("Amount of normal kids"); mDataset.addSeries(mNormalSeries); //Renderer for happy kids mHappyRenderer = new XYSeriesRenderer(); mRenderer.addSeriesRenderer(mHappyRenderer); mHappyRenderer.setColor(Color.GREEN); mHappyRenderer.setLineWidth(10f); //Renderer for normal Kids mNormalRenderer = new XYSeriesRenderer(); mRenderer.addSeriesRenderer(mNormalRenderer); mNormalRenderer.setColor(Color.YELLOW); mNormalRenderer.setLineWidth(10f); //Applying renderer style mRenderer.setAxisTitleTextSize(24); mRenderer.setYLabelsPadding(20); mRenderer.setXLabelsPadding(10); mRenderer.setXTitle(" Date of practice "); mRenderer.setYTitle(" Number of kids "); mRenderer.setApplyBackgroundColor(true); mRenderer.setBackgroundColor(Color.BLACK); mRenderer.setMarginsColor(Color.BLACK); mRenderer.setPointSize(20); mRenderer.setShowGrid(true); mRenderer.setAxesColor(Color.MAGENTA); mRenderer.setGridColor(Color.MAGENTA); mRenderer.setPanEnabled(true, true); mRenderer.setXAxisMin(0.0); mRenderer.setYAxisMin(0.0); mRenderer.setLabelsTextSize(24); } //Add x and y data to series private void addHappyData() { Integer x = 0; for (Integer happy : stateList) { mCurrentSeries.add(x += 10, happy); } } private void addNormalData() { Integer x = 0; for (Integer normal : normalList) { mNormalSeries.add(x += 10, normal); } } // Draw the graph @Override protected void onResume() { super.onResume(); LinearLayout layout = (LinearLayout) findViewById(R.id.chart); if (mChart == null) { initChart(); addHappyData(); addNormalData(); //Set chart type mChart = ChartFactory.getLineChartView(this, mDataset, mRenderer); layout.addView(mChart); } else { mChart.repaint(); } }

Ulf Dittmer wrote:In that case, an answer to this would be helpful:

Ulf Dittmer wrote:What are the values of the elements of the "a" array for the line that's giving you trouble?

The values are integers, which need to be than used for data projection on graph. Is than array a problem or the Dataset?

Ulf Dittmer wrote:

the problem is that no matter what I try, I cant access the 4th element and use it to draw an extra line to the chart.

normalList.add(Integer.parseInt(a[3]));

The code you posted seems to do just that, so what exactly happens when you you run? TellTheDetails

There is no error, just application does not show the second line on a graph (Data for "mDataNormal") at all, so I was thinking that there is something wrong with obtaining the array.

Ulf Dittmer wrote:What do you mean by "call out"? What exactly is the problem? The code shows how to access the 3rd element - what prevents you from similarly accessing the other elements?

the problem is that no matter what I try, I cant access the 4th element and use it to draw an extra line to the chart.


public class Chart extends Activity { ArrayList<Integer> stateList = new ArrayList<Integer>(); ArrayList<Integer> normalList = new ArrayList<Integer>(); //Chart creation private GraphicalView mChart, mChartNormal; /** * Create multiple data sets to be used on graph */ //Data sets used for graph manipulation private XYMultipleSeriesDataset mDataset = new XYMultipleSeriesDataset(); private XYMultipleSeriesRenderer mRenderer = new XYMultipleSeriesRenderer(); private XYSeries mCurrentSeries; private XYSeriesRenderer mCurrentRenderer; private XYMultipleSeriesDataset mDatasetNormal = new XYMultipleSeriesDataset(); private XYMultipleSeriesRenderer mRendere2 = new XYMultipleSeriesRenderer(); private XYSeries mCurrentSeriesNormal; private XYSeriesRenderer mCurrentRendererNormal; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); // Code which makes activity full screen getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN); setContentView(R.layout.activity_chart); readHappyLog(); } //Create a method for the aChart engine private void initChart() { //Series description for both charts mCurrentSeries = new XYSeries("Amount of happy kids"); mDataset.addSeries(mCurrentSeries); mCurrentSeriesNormal = new XYSeries("Amount of normal kids"); mDatasetNormal.addSeries(mCurrentSeriesNormal); //Renderer for happy kids mCurrentRenderer = new XYSeriesRenderer(); mRenderer.addSeriesRenderer(mCurrentRenderer); mRenderer.setAxisTitleTextSize(24); mRenderer.setYLabelsPadding(20); mRenderer.setXLabelsPadding(10); mRenderer.setXTitle(" Date of practice "); mRenderer.setYTitle(" Number of kids "); //Renderer for normal kids mCurrentRendererNormal = new XYSeriesRenderer(); mRendere2.addSeriesRenderer(mCurrentRendererNormal); mRendere2.setYTitle("Number of normal kids"); //Applying background mRenderer.setApplyBackgroundColor(true); mRenderer.setBackgroundColor(Color.BLACK); mRenderer.setMarginsColor(Color.BLACK); mRenderer.setPointSize(20); mRenderer.setShowGrid(true); mRenderer.setAxesColor(Color.MAGENTA); mRenderer.setGridColor(Color.MAGENTA); mRenderer.setPanEnabled(true, true); mRenderer.setXAxisMin(0.0); mRenderer.setYAxisMin(0.0); mRenderer.setLabelsTextSize(24); //Sets the color of the graph line and width mCurrentRenderer.setColor(Color.GREEN); mCurrentRenderer.setLineWidth(10f); mCurrentRendererNormal.setColor(Color.BLUE); mCurrentRenderer.setLineWidth(10f); } //Add x and y data into the graph and mark the x graph private void addHappyData(){ Integer x = 0; for (Integer happy : stateList ){ mCurrentSeries.add(x += 10, happy); } } //Add x and y for normal to the graph private void addNormalData(){ Integer y = 0; for (Integer happy : normalList ){ mCurrentSeriesNormal.add(y += 10, happy); } } // Draw the graph @Override protected void onResume() { super.onResume(); LinearLayout layout = (LinearLayout) findViewById(R.id.chart); if (mChart == null){ initChart(); addHappyData(); addNormalData(); //Set chart type mChart = ChartFactory.getLineChartView(this, mDataset , mRenderer); layout.addView(mChart); mChartNormal = ChartFactory.getLineChartView(this, mDatasetNormal,mRendere2); }else{ mChart.repaint(); mChartNormal.repaint(); } } /** * create a method to read the happy log */ private void readHappyLog(){ String FILENAME = "happy_log.csv"; //Open the file name under this string FileInputStream inputStream = null; // Import the package String temp; String[] a; try { inputStream = openFileInput(FILENAME); //Open file desceriptor (Object) byte[] reader = new byte [inputStream.available() ]; //Everything from disk is byte while (inputStream.read( reader ) != -1 ){} //Reader array now holds the entire file //Needs to create scanner in order to read the file properly Scanner s = new Scanner (new String(reader)); s.useDelimiter(("\\n")); while (s.hasNext()){ //Split the string lines if he sees comma value temp = s.next(); a = temp.split(","); stateList.add(Integer.parseInt(a[2])); normalList.add(Integer.parseInt(a[3])); } s.close(); }catch (Exception e ){ Log.e("Chart", e.getMessage()); }finally { if (inputStream != null ){ try{ inputStream.close(); } catch (IOException e){ Log.e( "Chart", e.getMessage()); } } } } }

Ulf Dittmer wrote:

but if there is 5 practices per week for a 6 month period, wouldn't it be better to have it stored in file somewhere?

We don't know what that data is intended for, that's why I asked. My question was not about long-term storage, it is about the fact that the app writes to a file and then reads form the same file - that seems inefficient to me. Why convert Java objects to a file representation only to convert that back to Java objects within the same app? (Especially if it gives you problems, I might add :-)

At a quick glance, the CSV looks OK. What are the values of the elements of the "a" array for the line that's giving you trouble?

the problem is that I cant find the way how to call out the 4th column and the 5th to obtain variables with the splitting the string lines. and than use those values as reference numbers for a second data line in the chart.

while (s.hasNext()){ //Split the string lines if he sees comma value temp = s.next(); a = temp.split(","); stateList.add(Integer.parseInt(a[2]));

Ulf Dittmer wrote:Have you looked at the CSV to see if it's properly formatted? Post it here.

What is the point of storing data as file (no matter the format) if the same app reads it later? Why not keep it in memory?

but if there is 5 practices per week for a 6 month period, wouldn't it be better to have it stored in file somewhere?

Unfortunately I cant save the actual file so hope copy of the text will do....

Aug-30-2014,08:06 AM,0,0,0
Sep-05-2014,08:09 AM,0,3,2
Sep-05-2014,08:10 AM,0,3,2

Hi everyone. Firs end foremost a short purpose of application I am trying to create.

Main goal is to provide monitoring widget for my coaches. To be able to do that a certain data needs to be stored. I used for data storing the csv file. The 4 columns are Date, Time,No. of Happy,No of Normal,No of Sad.
Since I want to make a visual graphical interpretation of the results I need to call the data back from the csv.

With the help of different tutorials I was able to get the data out for third column (No of Happy) however, cant find the way how to call than the 4th and 5th column, and also the Date.

The reason behind is, that I would like to plot a chart based on the 3 columns with aChartEngine.

can you please assist me on this matter?

Saving the stats to csv

/** * Saving the stats into * csv after the saveLogOnClick is pressed. * * */ public void saveLogOnClick(View view) { //Name of the file created String FILENAME ="happy_log.csv"; //Obrain the current text in the files convert it to string and save it to .csv file String entry = edtDate.getText().toString() + "," + edtTime.getText().toString() + "," + happyScore.getText().toString() + "," + normalScore.getText().toString() + "," + sadScore.getText().toString() + "\n"; //Open a file with the streamer/pointer try{ FileOutputStream out = openFileOutput(FILENAME, Context.MODE_APPEND); out.write(entry.getBytes()); out.close(); toastIt( "Entry saved"); }catch (Exception e){ e.printStackTrace(); } }

Reading the stats from csv for usage in chart

/** * create a method to read the happy log */ private void readHappyLog(){ String FILENAME = "happy_log.csv"; //Open the file name under this string FileInputStream inputStream = null; // Import the package String temp; String[] a; try { inputStream = openFileInput(FILENAME); //Open file desceriptor (Object) byte[] reader = new byte [inputStream.available() ]; //Everything from disk is byte while (inputStream.read( reader ) != -1 ){} //Reader array now holds the entire file //Needs to create scanner in order to read the file properly Scanner s = new Scanner (new String(reader)); s.useDelimiter(("\\n")); while (s.hasNext()){ //Split the string lines if he sees comma value temp = s.next(); a = temp.split(","); stateList.add(Integer.parseInt(a[2])); } s.close(); }catch (Exception e ){ Log.e("Chart", e.getMessage()); }finally { if (inputStream != null ){ try{ inputStream.close(); } catch (IOException e){ Log.e( "Chart", e.getMessage()); } } } } }

Thank you for your help

Thanks for all the help. With it I cleared up a bit mess in my head . Thanks a lot