Saving resumes to a database

[burak]

Hello,

 

My company is thinking of setting up a resume web

page where candidates will be able to upload their

resumes to our database. The hr personnel will

then use another page to search these resumes for the skills they need.

 

I have not done any apps involving uploading of

files and storing/searching MSWord documents.

I would appreciate any suggestions on how I might

go about doing this.

 

 

I looked at a microsoft page and the code shows the files as being saved on the web server.

 

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q323/2/46.asp&NoWebContent=1

(watch for URL wrapping)

 

 

I have two questions:

 

1) Is this the way it's generaly done? I had always imagined resumes would get saved on a database, not on the web server.

 

2) After the file is saved on the web server, how do you implement searching? Do you open a file and read it line by line looking for the search parameters or is there an easier way to do it?

 

Thank you,

 

Burak

[mutant]

Most people post their resumes in PDF or Word format if they want them to look good, so I dont think you would be able to parse them and put them in database fields they belong to. Storing files in the database is not a widely used idea too, but instead of that you cans tore the path to a file in the database and the file on the server.

[burak]

Thank you,

 

How do you search the file then? Do you do open/read on the file or is there a way to execute a command like unix grep to search for a word in many files?

[mutant]

One way you could do it if you are working with plain text file is to open it, read all of it using the ReadToEnd() method of the StreamReader, and then use RegularExpressions to parse it for a pattern which in your case could be a single word or maybe more.

[Mothra]

Resumes...

 

Actully, it's fairly common to have a potential employer ask for "text only" or *.txt file versions of resumes. That, combined with the storing of the path to the file should work great.