Start a conversation

CV Import Tool (Automatic)

AUTOMATIC CV Import Tool

Overview

The Influence Professional database has the ability to scan a mailbox folder for emails with CVs attached and automatically import the CVs into the database and create new candidate records if applicable.

Effectively the system will periodically scan an MS Exchange mailbox folder looking for CVs and then import them into the database.

In order to run the import you will need to setup a specific UserID in your influence database and you will need to leave session logged-in to the database constantly scanning the mailbox for CVs.
(Note: Because of the need for an additional session constantly monitoring the mailbox you may need to purchase an additional Influence user licence)


MS Exchange Considerations

Because the system will be scanning a MS Exchange mail folder, you may need to speak to your IT support provider and ask them to setup a suitable mailbox.  
(e.g. Applicants@mycompany.com)

You will also want to consider how the emails arrive in this mailbox. You could simply take emails that you receive yourself and email them to this address, thus ensuring that only emails suitable for processing are in the mailbox, or you could ask your IT provider to setup forwarding rules so that emails with CVs attached are copied to you <and> sent to the auto-import mailbox as well.

When deciding whether to forward emails or allow applicants to send their emails directly to this mailbox you may want to consider if you are going to run the auto-import in Move Mode or in Delete Mode; each mode has its advantages, but in delete mode, you may want to make sure that another copy of the email has been stored elsewhere by any forwarding rules, whereas move mode will keep a copy of the email after processing.

Please contact your IT Support provider or see the Microsoft help documentation for assistance with MS Exchange forwarding rules.

System Parameters and Controls

The operation of the automatic CV import tool is controlled by various system parameters within Maintenance > Setup > Parameters. These parameters are described below.

PRO-WBEN, Text(3)  UserID Outlook Auto Mode:  Specifies the UserID  which will run the import tool in AUTO mode.
When users login with this UserID (often AUTO) then choosing the CV Import tool will cause it to run in auto-mode, which will examine a mailbox for CVs, detach them from the emails, parse them for skills/attributes and create Candidates.

WORKBENCH, Flag(2) “CV Tool Auto Mode D'elete or M'ove” This specifies if the auto-import runs in Delete Mode or Move Mode (Default is “D”)

 

Import mode - Delete Mode vs Move Mode

Auto with D’elete Mode

Any emails processed are added as Candidates to the database then deleted from the folder being polled.

If the system processes a CV which it believes to be a duplicate* of an existing candidate on the database, then the system will update the CV&Skills Page of the existing Candidates(s) in the database, store a copy of the CV on the Docs page of the candidate record, Create a new folder on the DOCS page of a candidate and store the duplicate and also update the date field called "Duplicate Added" to record the date that a duplicate CV was processed and added (automatically) to the database.

(* To detect a duplicate the system looks at the email address, Mobile Tel or phone number from the processed CV and compares these with existing records in the database.)

NB: When updating an existing candidate the system will replace the text shown on the CV*Skills page of the existing candidate record in the database but will not amend any of the name/address/tel/email details of the existing record, as then may not be correct.
If desired users can easily report on candidates that have had a "Duplicate Added" over a period using the 'duplicate added' date, and then manually decide if they wish to amend any of the contact details for these

Auto with M’ove Mode

When running in this mode, processed emails are moved to 1 of 3 folders. Users will be asked to select the three folders from the mailbox when they start the import process, as well as a source folder for the CVs to be processed.


Folders

There are 4 folders which need to be specified.

Source:-  The folder which will be scanned by the Auto-import process.

Processed:-  Any emails which resulted in a CV being created will be moved to this folder.

Duplicated:-  Any emails which contain CVs which the system believes to be duplicates of existing candidates in the database OR are duplicates in the current batch OR have little or no details (i.e. No Forename and Surname can be extracted from the attached CV) will be moved to this folder.  The idea is that someone should periodically review this folder and manually take any CVs from this folder and decide if they wish to add them to the database or update the existing candidate.

Unselected: - Any email which has multiple attachments which are not ALL detected as CVs will be moved to this folder.


Note
: If emails have come from specified email addresses. e.g. cv@jobserve.com the system can be told to treat all attachments as CVs and they will be processed and moved to the "Processed" folder. See Appendix 1 for how to specify email addresses.


Selecting the destination folders:-

Whilst logged in as the Auto-import userID (AUTO) select the Toolbox workbench and cick on each 'select folder' icon.
The system will display the MS Outlook mailbox and you can choose the relevant folder for each item.


Note
All four mailboxes must be specified. If no source folder is specified it will use the default mailbox (Inbox). If you try and start the process running you will be automatically prompted to specify the 3 other destination folders.

  

CV Word Detection  (from ver 1.00.18.253)

From version 1.00.18.253 (or later) it is possible to specify "CV word" Detection. This will attempt to determine if an attachment is a CV in one of several ways.

i) The system looks at the filename - if it contains CV, Curriculum Vitae or Resume as part of the file name, it will assume the attachment is a CV to be parsed.

ii) The system will look at the 'from' email address for the CV. Emails coming from specified addresses such as Monster, CV Library, etc will be treated as CVs

ii) Optionally, the system can be made to look at CV words - this will work in conjunction with method (ii) and will convert the file to an RTF document on the server and will then scan the content of the document looking for specific words or phrases.


CV Enquiry Source Detection (from ver 1.00.18.253)

From version 1.00.18.253 (or later) it is possible to specify the source of the CV.
If the subject line of the email contains the code for the Enquiry Source in the subject line between double square brackets, it will be set.

e.g.  If the mail subject said:   CV from john Smith, from [[HM]] 

Then the system would take the 'HW' bit and set this as the Enquiry Source

NB: Enquiry Sources are held in the code table Candidate Enquiry Source [913]


System Setup

The CV word detection is controlled with two parameters.

Workbench, Flag(11) - CV Import recognition, Filename, Content or Both

Set to F to use the FILENAME as the only method for identifying the CV
Set to C to simply scan the content of the file looking at 'buzz words' irrespective of filename.
Set to B to use a combination of Both - i.e. a suitable filename AND some matching words

Workbench, Integer(17) - CV Import Buzzword hits needed for CV

You can specify a number of the Buzzwords which must be identified before the system will treat the document as a CV, e.g. 3 or 4.


The buzzwords referred to above are stored in a code table, and are CASE SENSITIVE.
i.e. The phrase Work History is treated differently than work history when scanning for word patterns.


An example of code table CV Tool Words [458] is shown below.
The Extra_Info column labelled Is CV  determines if that phrase or word ALWAYS means a CV, or if it is accumulated as HITS.

e.g.
When scanning the content of an attachment, the system would see the phrase
C U R R I C U L U M    and instantly treat the document as a CV.

However, if it saw the phrase Hobbies or Education it would require sufficient "Hits" before it then treated the document as a CV.



Appendix 1

It is possible to specify certain email addresses as specific Enquiry Sources. When processing emails from these email addresses the system will AUTOMATICALLY set the Enquiry Source filed for the candidate, and will also KNOW that the attachments are to be treated as CVs irrespective of the filename for the *.doc or *.pdf attachments.


To do this go to Maintenance > Setup > Codes tables and select the Cand Enq Source [913] code table.


Tick the Extra info [  ] box then use the Email/Sender column to specify the domain or email address which relates to the selected Enquiry Source.




Choose files or drag and drop files
Helpful?
Yes
No
  1. Martin Parkinson

  2. Posted
  3. Updated

Comments