lundi 5 octobre 2015

Sqlite to Csv conversion Failed

Here is the code please suggest me how to export csv from existing db, I have already added "opencsv-2.3.jar" to the project java build path but still shows below error.

LogCat: 10-05 23:20:31.482: E/AndroidRuntime(15756): Caused by: java.lang.ClassNotFoundException: Didn't find class "au.com.bytecode.opencsv.CSVWriter" on path: DexPathList[[zip file "/data/app/eom.ecollector-2/base.apk"],nativeLibraryDirectories=[/vendor/lib, /system/lib]]

public class ExportCsv extends Activity {


protected void onCreate(Bundle savedInstanceState) {
    // TODO Auto-generated method stub
    super.onCreate(savedInstanceState);
    setContentView(R.layout.import_database);
//Button btnExport;
  SQLiteDatabase db = this.getDB();

  //File dbFile = getDatabasePath("odsr.db");

  // DataBaseHelper DBob = new DataBaseHelper(MainActivity.this);

  File exportDir = new File(Environment.getExternalStorageDirectory()
        .getPath(),+"/Database/");

  if (!exportDir.exists())

  {

    exportDir.mkdirs();

   }

  File file = new File(exportDir, "Filename.csv");

  try

 {

    file.createNewFile();

    CSVWriter csvWrite = new CSVWriter(new FileWriter(file));

    //SQLiteDatabase db = this.getDB();
    String Table_Name = "RECORDS";
    Cursor curCSV = db.rawQuery("SELECT * FROM "+Table_Name, null);

   //int c = curCSV.getColumnCount();

    csvWrite.writeNext(curCSV.getColumnNames());

    while (curCSV.moveToNext())  {

        String arrStr[] = { curCSV.getString(0), curCSV.getString(1),

        curCSV.getString(2),curCSV.getString(3), curCSV.getString(4),

        curCSV.getString(5),curCSV.getString(6), curCSV.getString(7)};

        csvWrite.writeNext(arrStr);

    }
   csvWrite.close();
   curCSV.close();
   }
   catch (SQLException sqlEx)   {
   Log.e("ExportCsv", sqlEx.getMessage(), sqlEx);
  }
  catch (IOException e) {
  Log.e("ExportCsv", e.getMessage(), e);
 }
 }

          private SQLiteDatabase getDB()
           {

                String DB_NAME = "odsr.db";
                return openOrCreateDatabase(DB_NAME,         SQLiteDatabase.OPEN_READWRITE, null);
           }

}

Aucun commentaire:

Enregistrer un commentaire