What will be the best way of developing this kind of database?

Hi,

I got a lot of products. Each product has a PDF with info/description.
My thought process is:
- Create a website/database, so I can access this website from any computer to use this database.
- Each product has its own entry, there should be a framework able to parse the PDF and store the info for each product.
- With the info I got from the PDF, I can start computing things I need to do.

Any idea how should I start this? Or is there any developer interested in this project?

Thank you

 

I can help you to set this up!. Please PM me if you are interested.

 

Basically,

1. Sort the PDF files in directories or upload them one by one
2. Parse them in PHP by http://www.pdfparser.org/
3. With parsed text in structured arrays, insert them in pre-created tables of MySQL database
4. Normalize the database structure and develop the website based from the data.

I would do it this way. Hope it helps.

 

Hi, Are you interested in developing this database/web for me?

Thank you.

 

Use Open Cart free ecommerce script.

You don't have to be selling the products. Just use the script as a catalog to organize the products, decsription, associated files (pdf), etc.

 

Thanks but seems not what I need.
Main idea is i want to compute the info from the PDF, and if I have 1000+ products, I will able to do my analysis.

Thanks,

 

Personally,

I would upload the pdf files structured directory based off of genre / category etc.
Then parse these pdf's out into JSON attached to a NOSQL db on the backend
that way you could establish the website based off the array in the db as well as scale out into the mobile wordspace if ever needed.

D

 

Nice approach. NoSQL seems really in these days.

 

Yeah, I implement NoSQL when and where I can any more.

 

are you able to help me out?
the pdf will keep building every year, probably 13K per year, and each is unique
each will have a sale price, a buyer, a vendor details associate with it

lets say A product and B product, B product can be related to A product and will show on both A and B description

i was thinking to use pandas or numpy to do calculations

first thing is i need to have a good setup to gather all information is a correct manner

please contact me if you are interested

thanks mate

 

basically you need to add data to your database using PDF's, so best option is making solution with something like this

 

By using access 2010 you can share your data throught the company or in the web server, to make it accessable from any computer. Or you can make a software at your own. It will take around 2 months to get ready.