PDF content to DB

[DreamOn]

Hi guys. Is there anyway so that when i upload a PDF file to the DB i store its content on a DB field?

Thanks in advance ;)

[computerfox]

The first step would be to extract the content.
This can be done via TET: http://www.pdflib.com/download/tet/
Or you can convert to a Word document->change the file extension to zip->unzip->find the right xml files->gather data

Then you can insert into your database.

[DreamOn]

Could you explain how the conversion works?

Edit: As i read there TET only works for PDF with max 10 pages and 1MB. Or not but i need to pay for that :/

[Luuk]

I suggest to take a look at this site:

http://www.pdf2txt.com/

It can convert a PDF to text. (Other tools like this exist too!, search for 'PDF to TEXT conversion')

[DreamOn]

Is it possible to use this converter when clicking the upload button? example: I choose a pdf file for upload and click the button. When i click it this would convert the pdf to text and store it in a database field.

[DreamOn]

Basically it would be:

-Choose file (done)
-Click upload (done)
-Onclick run program and convert selected file (trickiest part)
-Save text to a variable (tricky part)
-Save variable content to a field in DB (easy enough)

[Luuk]

I see a lot 'trickiest part'

1) Break down your problem in to small parts (you've already done that)
2) Do not start to give the first task the status 'trickiest part', end the last 'easy enough'. You do not seem to have a clue how to solve the 'Onclick run program and convert selected file', so stop claiming that 'Save variable content to a field in DB ' is easy. It can be easy, but what help is this if you do not know how to do the earlier part?

What program did you find to convert the selected file?

Please share the code you have, someone reading this will give tips on how to proceed....