Conversion of UNSTRUCTURED DATA (.doc,.docx,.pdf..etc..) to BLOB (SQLite)

[renz027nico]

Greetings!

We are developing an "Android Mobile Lecture Organizer" using B4A which will store unstructured data such as .doc,.docx,.pdf,.txt, etc.. files onto to the SQLite database of the application, but we're finding a hard time how to convert these UNSTRUCTURED DATA to BLOB data type of SQLite, can you please give us a sample code on how to CONVERT these DATA to BLOB Data type and HOW TO RETRIEVE it and convert it into its original format?

And ALSO, after retrieval, how we will open these kind of FILES in the B4A Application? please..we need your help...This PROJECT is our THESIS so we need to work well on this and we will be GLAD if you, guys, fellas, experts, master programmers, could help us with these things,

THANK YOU!!! We hope for your great response, THANK YOU... ^_^


Lorenz Nicole Lopez
BSIT-IV

 

[NJDude]

Here is a SQLite TUTORIAL that will help you save data as BLOB, however, there are no native Android ways to read .doc,.docx,.pdf, you will be able to read .txt only.

 

[renz027nico]

THANK YOU for that Tutorial. But is there any possible solution we could use to be able to open/read those files into an Android Application developed in B4A?

 

[NJDude]

THANK YOU for that Tutorial. But is there any possible solution we could use to be able to open/read those files into an Android Application developed in B4A?

You will need a 3rd party app able to handle those formats.

 

[renz027nico]

You will need a 3rd party app able to handle those formats.

After we retrieved the file from the database as BLOB we could convert into its original file format, right? hmm, the problem now is how to open after retrieval, can you give us an example of those 3rd party app? ^_^

 

[NJDude]

Sure, an app like THIS one for example, however, you will need to know also about Intents in order to instruct the 3rd party app to open your docs.

 

[Beja]

you will be able to read .txt only.

Since you can read the text then why don't you parse it in SQLite table row by row?