Main Area and Open Discussion > General Software Discussion

automate database building

<< < (2/4) > >>

Renegade:
The only thing I can think of is building some custom software/script to parse the text and create the database like that.

But without knowing much more, that's about all I can say.

For a single file, maybe store the PDFs in the DB as a blob in a single table?

kalos:
You mean to use EXCEL files?
That sounds good., and are there any kind of files similar? That can store blobs., etc

Renegade:
You mean to use EXCEL files?
That sounds good., and are there any kind of files similar? That can store blobs., etc
-kalos (April 24, 2012, 05:49 PM)
--- End quote ---

Excel doesn't use data types like that, so you can't store a blob in it. Blobs are for RDBMSes.

Can you post a PDF?

kalos:
You mean to use EXCEL files?
That sounds good., and are there any kind of files similar? That can store blobs., etc
-kalos (April 24, 2012, 05:49 PM)
--- End quote ---

Excel doesn't use data types like that, so you can't store a blob in it. Blobs are for RDBMSes.

Can you post a PDF?
-Renegade (April 24, 2012, 08:26 PM)
--- End quote ---

but, cant EXCEL store a pdf or any other type, file in a cell?
if not, which specific RDBM would you suggest? (for a veeery simple task as this, that doesnt require to learn much)

as for the pdfs, an example is this:
http://www.purolite.com/RelId/606346/ISvars/default/customized/uploads/pdfs/Regen%20Chem%20Specs.pdf
(renamed as Hydrochloric Muriatic Acid.pdf)

Ath:
as for the pdfs, an example is this:
http://www.purolite.com/RelId/606346/ISvars/default/customized/uploads/pdfs/Regen%20Chem%20Specs.pdf
(renamed as Hydrochloric Muriatic Acid.pdf)
-kalos (April 25, 2012, 02:12 AM)
--- End quote ---
Does that mean there are more then 1 chemical components described in 1 pdf file, or is this the kind of resulting pdf you want to have output eventually?

And how are the chemical components in the 'word list' separated from each other, by comma's or each on a new line? Or just try to find a word as a pdf, if not there, add the next word and retry, etc.?

Navigation

[0] Message Index

[#] Next page

[*] Previous page