Export table to csv

[Ruben Matt]

Hi, i'm trying to export data i have in my sqlite database to csv. I don't know much about this so i searched code and tried to adapt to what i need but when i try to export it gives many errors.

When i click the button this runs:

Errors:

Could not find class 'au.com.bytecode.opencsv.CSVWriter', referenced from method com.exaple.listview.MainActivity$2.onClick
04-21 11:51:20.358: D/gralloc_goldfish(1201): Emulator without GPU emulation detected.
04-21 11:51:26.348: E/MainActivity(1201): open failed: EACCES (Permission denied)
04-21 11:51:26.348: E/MainActivity(1201): java.io.IOException: open failed: EACCES (Permission denied)
04-21 11:51:26.348: E/MainActivity(1201): 	at java.io.File.createNewFile(File.java:946)
04-21 11:51:26.348: E/MainActivity(1201): 	at com.exaple.listview.MainActivity$2.onClick(MainActivity.java:119)
04-21 11:51:26.348: E/MainActivity(1201): 	at android.view.View.performClick(View.java:4438)
04-21 11:51:26.348: E/MainActivity(1201): 	at android.view.View$PerformClick.run(View.java:18422)
04-21 11:51:26.348: E/MainActivity(1201): 	at android.os.Handler.handleCallback(Handler.java:733)
04-21 11:51:26.348: E/MainActivity(1201): 	at android.os.Handler.dispatchMessage(Handler.java:95)
04-21 11:51:26.348: E/MainActivity(1201): 	at android.os.Looper.loop(Looper.java:136)
04-21 11:51:26.348: E/MainActivity(1201): 	at android.app.ActivityThread.main(ActivityThread.java:5017)
04-21 11:51:26.348: E/MainActivity(1201): 	at java.lang.reflect.Method.invokeNative(Native Method)
04-21 11:51:26.348: E/MainActivity(1201): 	at java.lang.reflect.Method.invoke(Method.java:515)
04-21 11:51:26.348: E/MainActivity(1201): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:779)
04-21 11:51:26.348: E/MainActivity(1201): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:595)
04-21 11:51:26.348: E/MainActivity(1201): 	at dalvik.system.NativeStart.main(Native Method)
04-21 11:51:26.348: E/MainActivity(1201): Caused by: libcore.io.ErrnoException: open failed: EACCES (Permission denied)
04-21 11:51:26.348: E/MainActivity(1201): 	at libcore.io.Posix.open(Native Method)
04-21 11:51:26.348: E/MainActivity(1201): 	at libcore.io.BlockGuardOs.open(BlockGuardOs.java:110)
04-21 11:51:26.348: E/MainActivity(1201): 	at java.io.File.createNewFile(File.java:939)
04-21 11:51:26.348: E/MainActivity(1201): 	... 12 more

[Ruben Matt]

I managed to get it to work but it's exporting to the sd card but i wanted it to export my any directory in my internal storage. How can i do that??

 
  File exportDir = new File(Environment.getExternalStorageDirectory(), "");   
if (!exportDir.exists()){
exportDir.mkdirs();
 }
File file = new File(exportDir, "teste.csv");
	        	try{
	        		file.createNewFile();                
		            CSVWriter csvWrite = new CSVWriter(new FileWriter(file));
		            Cursor curCSV = mydb.rawQuery("SELECT * FROM test",null);
		            csvWrite.writeNext(curCSV.getColumnNames());
		            while(curCSV.moveToNext()){
			                String arrStr[] ={curCSV.getString(1)};
			                csvWrite.writeNext(arrStr);
		            }
			            csvWrite.close();
			            curCSV.close();
		        }catch(Exception sqlEx){
			            Log.e("MainActivity", sqlEx.getMessage(), sqlEx);
		        }
			}

[Steve Luke]

You are using Environment.getExternalStorageLocation() which naturally gets the location for the SD card. Here is the API for Environment: http://developer.android.com/reference/android/os/Environment.html. Are there any methods there that might give you a better location?

[Ruben Matt]

Hi. Thanks for replying.

Which one is better to save the file on the downloads folder?? I saw the getStorageState(String filepath), but i dont know if its the correct one.

[Steve Luke]

Tell me, what does getStorageState() do?

[Ruben Matt]

From what i understood it return the state of the path i gave.
But actually i thougth better and i moved on, so i'm trying to send the file via e-mail because the user had to connect the phone to the pc and then transfer but there's a problem. When i click send it shows the file attached but when it sends it says "It wasnt possible to show the attached file".

When i check my e-mail, it's everything there but no file.

String to=destinatario.getText().toString().trim();
				String subj=subject.getText().toString().trim();
				String msg=message.getText().toString().trim();
				
				if(to.length() < 1)
				{
					Toast.makeText(getApplicationContext(), "Mete para quem quer mandar", Toast.LENGTH_LONG).show();
				}
				else if (subj.length() < 1) {
					Toast.makeText(getApplicationContext(), "Introduza o Tema", Toast.LENGTH_LONG).show();
				}
				else if (msg.length() < 1) {
					Toast.makeText(getApplicationContext(), "Introduza Mensagem", Toast.LENGTH_LONG).show();
				}
				else {
					Intent emailIntent = new Intent(android.content.Intent.ACTION_SEND); 
				    //emailIntent.setType("image/jpeg");
					emailIntent.setType("message/rfc822");
				    emailIntent.putExtra(android.content.Intent.EXTRA_EMAIL, new String[]{to}); 
				    emailIntent.putExtra(android.content.Intent.EXTRA_SUBJECT, subj); 
				    emailIntent.putExtra(android.content.Intent.EXTRA_TEXT, msg); 
				    emailIntent.putExtra(Intent.EXTRA_STREAM, Uri.parse(file.getAbsolutePath()));
				    startActivity(Intent.createChooser(emailIntent, "A enviar..."));
				}	
			}

[Ruben Matt]

Never mind, it's working. I had to add this:

emailIntent.putExtra(Intent.EXTRA_STREAM, Uri.parse("file://" + file.getAbsolutePath()));

And thank you Steve, really, you already helped me with all my questions
By the way, was i wrong with the getStorageState()??