Microsoft Word to MySQL Table. Newb.

[Skyphoxx]

Hello all.

I have a Newb question here. And I'm pulling my hair out.

Ok. I have installed a Job Board Script (almost exactly like Monster.com) that uses PHP and MySQL. It works perfectly. However the only way currently to enter a resume is by creating an account for each person and then filling out the resume form manually. I have over 100 resumes I need to throw up on this thing.

I know Monster.com allows you to upload .doc files and it essentially extracts the info into the form fields. Like first name, last name, college, etc.

That being said I have two questions.

(1) I assume that the MySQL table holds the info for each account I create. I also assume that I fill out ot create accounts just inputs that info into the MySQL table. Is there any script out there I can run that puts all of this .doc info into the proper table areas in my MySQL table?

(2) Is there a script or easy way to get my form to read and extract the .doc file and insert the info into the form?

Manually I am currently entering 5 resumes an hour. Which is far from fast.

Please help anyone.
Dave

 

[mcturkey]

Without knowing the specific software you are using, my guess is that there is not a specific script that will do it for you, as the structure of the tables would vary depending on the software. Now, it wouldn't be all that tough to write your own script to do it once you get passed the process of reading the .doc file (which from what I have read after briefly Googling it, is not cheap or easy). Parsing and converting .doc files is one of the items on my to-do list for a CMS I'm writing, but I haven't done any research on it yet.

Sorry to not be more helpful! Let us know if you come up with anything.