Post reply

Indexing .doc files(adding functionality like monsterindia.com)

  • October 18, 2006 at 5:30 am

    #115890

    i run a jobsite, i have around 26000 registered users,

    iam using ms-access to save data, and there .doc file resumes iam saving it on the hosting folder on the disk.

    now i want to add functionality where employers can type a text and it will search in .doc files for matching text.

    iam using shared hosting, is it possible ?

    any suggestions

     

     

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • October 23, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • October 24, 2006 at 11:37 am

    #667653

    well friends is it so difficult question.

    iam making a site for IT Professionals

    iam having a search functionality but also like to add keyword based search functionality how can i do that

    i think monsterindia, they are storing data in ms-sql and using some kinda indexing feature,

    iam not sure, but iam also making a jobsite,

    and how do i index those documents, what kind of servers shud i use, iam using shared hosting of godaddy.com

    i want to add monsterindia.com like funcationality how do i do that

     

     

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • October 24, 2006 at 2:39 pm

    #667692

    As part of your insert of a new document, along wtih inserting the document as a BLOB object you could open the document using the JET database driver in an openrowset and select the data from the document to a seperate column.

    You could then process that column of large text to find keywords (words over 3 letters or something using a split on space and subselect insert it to a keywords table.

    Then you have a column of keywords to search in for each document (in your keywords table)

    Well, it's a start

    I know you can openrowset an excel document, i've never tried it with word.

  • October 24, 2006 at 5:22 pm

    #667726

    How well would the windows indexing service work? Store the files in the files system and use that and not sql server? Not sure what sort of speeds you'd get but it could be worth investigating as it already has abilities to index word documents (I believe).

  • October 24, 2006 at 10:38 pm

    #667760

    i run a jobsite , which has around 27000+ IT Professionals registered

    but i still cannot charge the employers for accessing database.

    the other big jobsites features provide is

    employers can type the keywords like "MCSD,MCSE" or there profile "SQL DBA"

    and this jobsites engines goes into the .doc files and check whether they have these words in there c.v and if its there it presents to them

    they save there .doc file resume in the sql server, most of the jobsites do.

    iam using shared hosting, and saving data in ms-access and saving .doc files in the hosting servers hard disk.

    employers need a feature where they type in the profile name like "software programmer,team leader" and they shud be able to see the c.v of those matching keywords.

    any idea how to implement this feature

    i can shift to sql server, i know about sql server indexing documents, but don't know much about it

     

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • October 25, 2006 at 6:08 am

    #667817

    well thank yu for your suggestions, but still doesn't give much idea how to do it,

    if monsterindia.com can implement it, so can i,

    from where do i begin thats the problem

    definately its not a rocket science, sure it is something to do with sql indexing documents

    if the documents are huge if about 100,000 resumes in .doc format,

    well i guess rowset idea wudn't work, any clear good ideas ?

    thank you in advance

     

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • October 29, 2006 at 10:25 pm

    #668659

    iam still stuck up, anybody has the right answer

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • November 6, 2006 at 9:37 am

    #670112

    iam still not finding the solution,anybody has answer here ?.

    atleast tell me where to get the solution for this.?

    its not a rocket science sql genius r in this forum, but i guess they never had such a scene and never did any solution for this

    but still any one has answer?

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • November 10, 2006 at 5:43 pm

    #671195

    Can you make use of SQL server full text indexing?

    Either way I could suggest a few options.

    SQL guy and Houston Magician

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply