Export the SQLITEDB into .csv or .pdf

-
If you want to export the sqlite db into .csv  or .pdf. You are going use the following libraries


Task of Creating CSV

public class ExportCSVTask extends AsyncTask<String, Void, Boolean> {
           private final ProgressDialog dialog = new ProgressDialog(
                     MainActivity.this);

           protected void onPreExecute() {
                this.dialog.setMessage("Exporting database...");
                this.dialog.show();
           }

           @Override
           protected Boolean doInBackground(String... params) {
                File dbFile = getDatabasePath("basic_db");
                File exportDB = new File(Environment.getExternalStorageDirectory(),
                           "");
                if (!exportDB.exists()) {
                     exportDB.mkdirs();
                }
                File file = new File(exportDB, getDateTime() + ".csv");
                try {
                     file.createNewFile();
                     CSVWriter csvWriter = new CSVWriter(new FileWriter(file));
                     SQLiteDatabase db = dbHelper.getReadableDatabase();
                     Cursor curCSV = db.rawQuery("SELECT * FROM basic_table", null);
                     csvWriter.writeNext(curCSV.getColumnNames());
                     while (curCSV.moveToNext()) {
                           String arrStr[] = { curCSV.getString(0),
                                     curCSV.getString(1), curCSV.getString(2),
                                     curCSV.getString(3), curCSV.getString(4) };
                           csvWriter.writeNext(arrStr);
                     }
                     csvWriter.close();
                     curCSV.close();
                     return true;
                } catch (SQLException sqlEx) {
                     Log.e("MainActivity", sqlEx.getMessage(), sqlEx);
                     return false;
                } catch (IOException e) {
                      Log.e("MainActivity", e.getMessage(), e);
                     return false;
                }
           }

           protected void onPostExecute(final Boolean success) {
                if (this.dialog.isShowing()) {
                     this.dialog.dismiss();
                }
                if (success) {
                     Toast.makeText(MainActivity.this, "Export File successfully",
                                Toast.LENGTH_SHORT).show();
                } else {
                     Toast.makeText(MainActivity.this, "Export failed",
                                Toast.LENGTH_SHORT).show();
                }
           }
     }

    
Task of Creating PDF
      
     public class ExportPDFTask extends AsyncTask<String, Void, Boolean> {
           private final ProgressDialog dialog = new ProgressDialog(
                     MainActivity.this);

           protected void onPreExecute() {
                this.dialog.setMessage("Exporting database...");
                this.dialog.show();
           }

           @Override
           protected Boolean doInBackground(String... arg0) {
                // TODO Auto-generated method stub
                SQLiteDatabase db = dbHelper.getWritableDatabase();
                Cursor c1 = db.rawQuery("SELECT * FROM basic_table", null);
                File dbFile = getDatabasePath("basic_db");
                File exportDB = new File(Environment.getExternalStorageDirectory(),
                           "");
                Document document = new Document();
                if (!exportDB.exists()) {
                     exportDB.mkdirs();
                }
                File file = new File(exportDB, getDateTime() + ".pdf");
                try {
                     PdfWriter.getInstance(document, new FileOutputStream(file));
                     document.open();
                     Paragraph header = new Paragraph();
                     header.add("PDF Export Example by using iTextPDF");
                     PdfPTable pdfPTable = new PdfPTable(5);
                     pdfPTable.addCell("ID");
                     pdfPTable.addCell("NAME");
                     pdfPTable.addCell("AGE");
                     pdfPTable.addCell("ADDRESS");
                     pdfPTable.addCell("BLOODGROUP");
                     while (c1.moveToNext()) {
                           String _id = c1.getString(0);
                           String c_name = c1.getString(1);
                           String c_age = c1.getString(2);
                           String c_address = c1.getString(3);
                           String c_bgroup = c1.getString(4);
                           pdfPTable.addCell(_id);
                           pdfPTable.addCell(c_name);
                           pdfPTable.addCell(c_age);
                           pdfPTable.addCell(c_address);
                           pdfPTable.addCell(c_bgroup);
                     }
                     document.add(pdfPTable);
                     document.addCreationDate();
                     document.close();
                     return true;
                } catch (FileNotFoundException e) {
                     // TODO Auto-generated catch block
                     e.printStackTrace();
                     return false;
                } catch (DocumentException e) {
                     // TODO Auto-generated catch block
                     e.printStackTrace();
                     return false;
                }
           }

           protected void onPostExecute(final Boolean success) {
                if (this.dialog.isShowing()) {
                     this.dialog.dismiss();
                }
                if (success) {
                     Toast.makeText(MainActivity.this, "Export File successfully",
                                Toast.LENGTH_SHORT).show();
                } else {
                     Toast.makeText(MainActivity.this, "Export failed",
                                Toast.LENGTH_SHORT).show();
                }
           }
     }


You can also download the source from Github

Also download the app from Google Play

Comments

Post a Comment

Popular posts from this blog

Mastering API Development: Why Postman Reigns Supreme Over Swagger

-
Image
In the evolving landscape of API development, tools like Postman and Swagger have become indispensable for developers. While Swagger (now known as OpenAPI) is incredibly useful for designing and documenting APIs, Postman emerges as a more comprehensive solution for testing, documenting, and sharing APIs. This blog delves into why Postman is often considered more crucial than Swagger and how you can leverage its full potential to streamline your API development workflow. Why Postman Shines Ease of Use: Postman's intuitive GUI makes it super accessible for developers regardless of experience level. Building, sending, and analyzing API requests is a breeze. Powerful Testing: Postman is more than just firing off requests. You can craft sophisticated test suites with scripts, assertions, and chaining requests, ensuring API behavior is as expected. Collaboration Made Easy: Postman's workspaces and sharing features streamline teamwork. You can share collections of requests, environ...
Read more

Email Address Validation

-
Lot of peoples validate their field by using field length or Regular Expressions . In this way, Email Addresses validation has been difficult some times. Format of Email Address: The format of email addresses is local-part@domain where the local-part may be up to 64 characters long and the domain name may have a maximum of 253 characters - but the maximum 256 characters length of a forward or reverse path restricts the entire email address to be no more than 254 characters.<sup id="cite_ref-0"> [1] </sup> The formal definitions are in RFC 5322 (sections 3.2.3 and 3.4.1) and RFC 5321 - with a more readable form given in the informational RFC 3696 <sup id="cite_ref-1">[2]</sup> and the associated errata. Supported Characters: The local-part of the email address may use any of these ASCII characters RFC 5322 Section 3.2.3: Uppercase and lowercase English letters (a–z, A–Z) (ASCII: 65-90, 97-122) Digits 0 to 9 (ASCII: 48-57) Cha...
Read more

Flutter web view

-
 Hey friends, have a happy weekend. After a long gap of lock down, I just came back. I know 2020 will be so hard for everyone. Hope everything fine soon.  Today we gonna see the flutter web view. In android we used call WebView. It's similar like that. Let's dive on that. First of all, add the library in pubspec.yaml webview_flutter: ^0.3.21 then If you want to load the html page from your assets, you add into pubspec.yaml like below:   assets:     - assets/sample.html Please be careful with intent, because yaml is very sensed on that. Either it won't be work. you can see the full example in my gist: https://gist.github.com/vignarajj/59a518610a2bfeb09ad4b0b6d8fe7c69 If you directly call url, just call like that, WebView(           initialUrl: 'https://google.com',           javascriptMode: JavascriptMode.unrestricted,           onWebViewCreated: (WebViewController webViewController) { ...
Read more