Start a conversation

Candidate Import from MS Excel

If you have a list of Candidates in an MS Excel sheet, it is possible to quickly/easily import these into your Influence database. 

Note: This tool is designed for importing NEW data into the system; it will not update existing records with changes.

How it Works

1) Login to the database as the user "ADM" (or your own login if you have access to the [Maintenance] part of the system). 

Note: If you have a Multi Office system remember to login to the correct Office that you want the candidates imported into.

2) Choose Maintenance > Tools > Candidate import from Excel

3) Once the candidate import screen opens, click the [New] button at the bottom left to open an Excel template for you to use.
The template will have the column headings you can use,  e.g.

If you are using the spreadsheet to import candidates then you must specify a Forename/Surname and a status in addition to any other information.

Important: Please leave the column titles as they are, i.e. UPPER CASE.

4) Copy/Paste the information from your excel sheet into the template under the correct column heading(s).
When done, save the template using Save As.... and save the file as an MS Excel 97-2003 type sheet. (i.e. *.xls)

Tip: When saving the spreadsheet please ensure that there are no Filters/Auto-filters and no rows or columns are "Hidden".

5) Before importing create a test spreadsheet by re-saving it with the first 2-3 lines only.

NOTE: We recommend you try importing this small sample first, before proceeding to import the rest of your (much bigger) sheet of information.

6) From the Influence Candidate import from Excel, click the [Next] button. A window will appear asking for the spreadsheet containing the information to be imported.

Simply Drag/Drop the test spreadsheet that you saved in step (5) onto the window, and press [OK]. The system will then import the contacts into your database.

7) Ensure the information has imported correctly from the test spreadsheet. When satisfied repeat Step(6) with the full spreadsheet.

Note: When importing data the system will ignore the "TITLE" row, and will then import rows until it hits a blank ROW. The first totally blank row will stop the import at that point and any data below this will not be imported.

Back to Top

Important considerations when using the Import Tool

 If a candidate already exists, then it will not be added again if  the name in the import spreadsheet is IDENTICAL. If any part is different (Including CASE), then the import will add the candidate.

(E.g: Tom Smith  at Super Products Ltd   is different than
Tom Smith at Super products LTD, and would create a NEW record because of the different CASE)

Be patient. When importing data it can take some time.
Depending on the speed of the machine/connection etc. the process may take some time. Typically records are imported at the rate of 1 record per second, so a file containing 1800 records would take approx. 30mins to load.

If data is imported incorrectly it will need to be removed form the database before re-importing. If it is not removed then any future imports will be treated as duplicates and not imported.

(NOTE: Newer versions of the software will add all the imported items into a GROUP, which can be accessed from the left of the [Candidate] workbench to make it easier to remove any incorrectly loaded data.)

Back to Top

Choose files or drag and drop files
  1. Glenn Eve

  2. Posted
  3. Updated