473,890 Members | 1,773 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

context searching

I'm trying to help a friend setup a database to track resumes. The
candidates will submit their resume in a Word doc format, and I'd like to
make a search that will do a context search of the word files and generate a
report that matches the keyword search.

How would you do something like this in access?
Nov 12 '05 #1
5 1777
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Open the Word docs using Automation & search thru the docs using the
Word find function.

See the Access help articles on GetObject & CreateObject functions and
Automation. The see the Word help articles on using VBA to do
searches (Find).

HTH,

MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQAH8+4echKq OuFEgEQLQTACgmx RnUs+UN59jEeJ8w yUmwRW6R7oAnRKx
re2hODWwTaXPLRg gJpelCIe/
=BJ9U
-----END PGP SIGNATURE-----
jayjay wrote:
I'm trying to help a friend setup a database to track resumes. The
candidates will submit their resume in a Word doc format, and I'd like to
make a search that will do a context search of the word files and generate a
report that matches the keyword search.

How would you do something like this in access?


Nov 12 '05 #2
I recall from about 7 or 8 yrs ago, there was a dos command that you could
enter in the search string and it would return a list of files containing
that.

This database could have hundreds of files to search, so opening each really
isn't going to be a viable option. But I do appreciate the post.
"MGFoster" <me@privacy.com > wrote in message
news:O1******** ********@newsre ad1.news.pas.ea rthlink.net...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Open the Word docs using Automation & search thru the docs using the
Word find function.

See the Access help articles on GetObject & CreateObject functions and
Automation. The see the Word help articles on using VBA to do
searches (Find).

HTH,

MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQAH8+4echKq OuFEgEQLQTACgmx RnUs+UN59jEeJ8w yUmwRW6R7oAnRKx
re2hODWwTaXPLRg gJpelCIe/
=BJ9U
-----END PGP SIGNATURE-----
jayjay wrote:
I'm trying to help a friend setup a database to track resumes. The
candidates will submit their resume in a Word doc format, and I'd like to make a search that will do a context search of the word files and generate a report that matches the keyword search.

How would you do something like this in access?

Nov 12 '05 #3
Could you use the Windows Search utility?

i.e. Windows Start button -> Search -> for Files or Folders
and then
use the "Containing Text" option.

That would at least get you a list of the right files but not the report you
desire...

"jayjay" <jj****@notmail .com> wrote in message
news:bt******** ****@ID-87431.news.uni-berlin.de...
I recall from about 7 or 8 yrs ago, there was a dos command that you could
enter in the search string and it would return a list of files containing
that.

This database could have hundreds of files to search, so opening each really isn't going to be a viable option. But I do appreciate the post.
"MGFoster" <me@privacy.com > wrote in message
news:O1******** ********@newsre ad1.news.pas.ea rthlink.net...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Open the Word docs using Automation & search thru the docs using the
Word find function.

See the Access help articles on GetObject & CreateObject functions and
Automation. The see the Word help articles on using VBA to do
searches (Find).

HTH,

MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQAH8+4echKq OuFEgEQLQTACgmx RnUs+UN59jEeJ8w yUmwRW6R7oAnRKx
re2hODWwTaXPLRg gJpelCIe/
=BJ9U
-----END PGP SIGNATURE-----
jayjay wrote:
I'm trying to help a friend setup a database to track resumes. The
candidates will submit their resume in a Word doc format, and I'd like to make a search that will do a context search of the word files and generate a report that matches the keyword search.

How would you do something like this in access?


Nov 12 '05 #4
"jayjay" <jj****@notmail .com> wrote in message
news:bt******** ****@ID-87431.news.uni-berlin.de...
I recall from about 7 or 8 yrs ago, there was a dos command that you could
enter in the search string and it would return a list of files containing
that.

This database could have hundreds of files to search, so opening each really isn't going to be a viable option. But I do appreciate the post.
"MGFoster" <me@privacy.com > wrote in message
news:O1******** ********@newsre ad1.news.pas.ea rthlink.net...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Open the Word docs using Automation & search thru the docs using the
Word find function.

See the Access help articles on GetObject & CreateObject functions and
Automation. The see the Word help articles on using VBA to do
searches (Find).

HTH,

MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQAH8+4echKq OuFEgEQLQTACgmx RnUs+UN59jEeJ8w yUmwRW6R7oAnRKx
re2hODWwTaXPLRg gJpelCIe/
=BJ9U
-----END PGP SIGNATURE-----
jayjay wrote:
I'm trying to help a friend setup a database to track resumes. The
candidates will submit their resume in a Word doc format, and I'd like to make a search that will do a context search of the word files and generate a report that matches the keyword search.

How would you do something like this in access?



The key to getting anything useful out of this system would be to store some
properly formatted data at the time you first receive the document. Sure
you could write some code which scans for key words but that is not very
sophisticated and, since resumes for people in the IT sector often contain
vast lists of software / technologies with which they are supposedly
familiar with, I'm not sure it's of much help. Perhaps it's because of this
sort of automated search by employment agencies is so common that applicants
feel the need to write such long lists.

If you gave examples of the sort of searches you intend to do, someone might
be able to offer better advice. If you simply wanted, for example, a list
of any people whose resume mentions the term 'visual basic', 'vb', or 'vba'
then perhaps this is OK but my guess is that the list would be pretty long
and not very useful. If you wanted to find someone within 25 miles of
London with at least 5 years' database development experience, including
project management, with German language skills being an advantage, then you
may well wish that you had read (or at least skim-read) these resumes and
entered some key details into a proper database structure.

Alternatively, use the established agency techniques of trying to match
candidate to employment without anyone actually reading any resumes and,
ideally, without reading the job requirements from the client.

</rant>

Fletcher
Nov 12 '05 #5
"Jayjay" <jj****@notmail .com> wrote in message
news:40******** *******@news.ci s.dfn.de...
On Mon, 12 Jan 2004 15:25:32 +0000 (UTC), "Fletcher Arnold"
<fl****@home.co m> wrote:

The key to getting anything useful out of this system would be to store someproperly formatted data at the time you first receive the document. Sure
you could write some code which scans for key words but that is not very
sophisticate d and, since resumes for people in the IT sector often containvast lists of software / technologies with which they are supposedly
familiar with, I'm not sure it's of much help. Perhaps it's because of thissort of automated search by employment agencies is so common that applicantsfeel the need to write such long lists.

If you gave examples of the sort of searches you intend to do, someone mightbe able to offer better advice. If you simply wanted, for example, a listof any people whose resume mentions the term 'visual basic', 'vb', or 'vba'then perhaps this is OK but my guess is that the list would be pretty longand not very useful. If you wanted to find someone within 25 miles of
London with at least 5 years' database development experience, including
project management, with German language skills being an advantage, then youmay well wish that you had read (or at least skim-read) these resumes and
entered some key details into a proper database structure.

Alternativel y, use the established agency techniques of trying to match
candidate to employment without anyone actually reading any resumes and,
ideally, without reading the job requirements from the client.

</rant>

Fletcher

Point well taken. :-)

These resumes are for biological research or medical research type
companies.

I've asked the guy to give me a list of the technologies he
specializes in. The database of his company contacts is broken down
as such

3 company types. Biological, Medical and Diagnostic

Areacode for phone number. then State. for contact information.

Then he wanted a search for technologies available. Technologies can
be things like molecular research, cellular division, etc (he's
compling a list).

This database is a contact list of companies to market the candidates
to. So its backwareds. He gets a resume and then goes in and does a
search on technologies to get a list of companies that this candidate
might be good for.

But, he gets his resume's from candidates in Word format. (he
requests them to come in that way). He would like a way to store the
files in a directory, then run a search on the text inside the
document for some of the key words - to be able to backwards market
certain companies.

He didn't really want to put the word files into his database as
candidates come and go and he was trying to keep away from the
maintenance of cleaning up the records. Also, he prefers the paper
trail and having the full resume on hand in front of him so he can
read it. :-)

Then again, maybe a simply thing would be to have the database setup
that when he opens the word file, he runs a macro that selects all the
text, and copies it, then pastes to a memo field in the database.
That way I can have the database search the text in the memo field.

(The guy is breaking out on his own as a recruiter. so he doesn't
have the funds at this point in time to purchase the recruiting
software that is marketed out there. He's my husband's best friend
and a great guy, so I'm just trying to give him a hand here).

Those are certainly reasonable ideas - and I would agree that keeping the
Word documents is important. I was simply suggesting that you could add
some more structured data in addition to the actual Word document.

I am less convinced that cutting and pasting from the document is a good
idea, since individual resumes can contain elements which won't conform
nicely to a plain-text memo-field. At best the discrepancy might only be a
few funny-looking characters, but if they have created their name with a
Word Art object to make the document look nice, your plain-text memo field
will obviously miss this.

It depends how much time you have to build this, but you could write an
import routine that might attempt to do a better conversion than cut and
paste. For example, whenever a new document is received you could save them
in a standard place like "C:\Resumes\Inb ox\" the import routine would then
create a record with some basic input such as name, surname, etc and other
fields being completed automatically (such as DateEntered). The document
would then be renamed to a standard name like a 6-figure format of the
RecordID and some form of 'automated cut and paste' would be done. The file
could be moved to "C:\Resumes\Wor dDocs\000156.do c" and this path would be
stored with the database record.

Whatever you decide though, having data in the tables (for speed and
structure) and retaining the original document is the way to go. I'm sure
there is no software which offers a magic fix and provided you are sensible,
I don't see why you couldn't hand him a perfectly workable solution. Good
luck.

Fletcher

Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
1384
by: DavidM | last post by:
I'm developing a middle tier business object that can be called from either a Windows Form or Web Form front-end. Is there a way to detemine the context of the call to determine if the call is coming from an http request or a window call?
1
1346
by: cool_jaggs | last post by:
Hi , I am new to this group, but it would be really nice if you can really help me out. I am trying to Export a file from my application to windows explorer through drag and drop using right mouse button . But once i am doing it i am getting the DragandDropContext Menu Handler, but i don't want to show that menu instead of that i wanna show my own context menu . Can that pe possible ? How? Waiting for ur response Thankx in Advance
5
5969
by: Flip | last post by:
I'm trying to reference images in my webapp. I'm coming from j2ee and I just write a small jsp scriplet that says to go grab the context path. How do I do that with C#? If it's done differently in C#/.NET, please set me straight (please be gentle :>). If my current setup is this +References +Dilbert.jpg Default.aspx +Searching
0
1038
by: Graeme M via DotNetMonster.com | last post by:
Hi, I'm using visual basic.net 2003 and in two separate projects now i have encountered a frustrating issue where all context menu functionality (copy, paste, delete etc) is disabled on a TabControl in a windows form. I have scoured the internet searching for a solution, and have noted several similar posts but no real solution to the problem. Has anyone encountered this before and figured out how to fix it? or is there a fix that i need...
2
2414
by: nicholas | last post by:
Hi folks, I'm diving into XPathNavigator.SelectDescendants method. There's a boolean type parameter matchSelf, and MSDN says "To include the context node in the selection, true; otherwise, false". But I don't understand how to use it. The sample code in MSDN is below, but I didn't find any difference of the result while setting the value of this parameter to true and false inspectively. So could anybody show me how to use the parameter...
0
1189
by: news.microsoft.com | last post by:
I have a 2 columns, 5 rows datagrid with 1st column ReadOnly, and 2nd Column Editable, (e.g ResourceFiles, Path) I am trying to make a context menu to open file dialog for path searching. But I am not able to correctly locate the selected row from the datagrid. Example: ResourceFiles Path res.txt XXXXXXXXXXXXXXXXXXXX My codes is as follows.
3
1383
by: andrew | last post by:
Been searching around and seems that most people say it's impossible because people can steal your code or images a million different ways but here's what I want to do: I'm trying to make a javascript slideshow. I want the left click to next slide but the right-click to go to the previous slide. My code works. It does what I want. But every time I right click on the div in addition to going to previous slide it also opens up the context...
1
3112
by: giddy | last post by:
Hi , I've read this a long time ago , read it again: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/shellcc/platform/shell/programmersguide/shell_basics/shell_basics_extending/context.asp I know how to make file associations and then add an option to the shell context menu if the user clicks that file. My application adds an extra option for .cs files.
1
14342
by: Preeti | last post by:
Hi all I am a fresher and have been given a requirement in VB.net I have to make an application in VB.net which will run as a system tray icon and will add one or two items in the default windows right clink context menu. on clicking on that menu item the application should write a signature on the current cursor position
0
9976
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9815
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10802
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10451
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9618
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8008
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5835
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4665
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4259
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.