Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Using Excel to populate Continuum personnel object attributes from a 32 digit FASC number

Issue

A third party personnel management system stores nine separate pieces of information in a single thirty two digit FASC number. 

In order to migrate personnel data from a third party system into Continuum, the nine values that make up the FASC number must be separated in order to populate the various fields in each Continuum personnel Object.

Product Line

Andover Continuum

Environment

  • Continuum
  • Personnel
  • Import
  • Parse
  • Excel

Cause

In order to migrate personnel data from a third party system into Continuum, the nine values that make up the FASC number must be separated in order to populate the various fields in each Continuum personnel Object.

Resolution

  1. Import the third party information into an Excel spreadsheet.
  2. Under the Data menu, use Text to Column to parse the nine values combined in the FASC number into nine columns based on fixed width.
  3. Import the personnel data in CSV format or use Personnel Import Utility to import the parsed data.  (Note:  The Personnel Import Utility is a available as a paid for option in Continuum).

Also see the following Knowledge Base Articles for information on importing personnel information:

Personnel.csv file fails to import into Continuum
Creating Personnel objects via CSV import file that include area assignment and photo

Tags (1)
Labels (1)
No ratings
Version history
Revision #:
2 of 2
Last update:
‎2018-10-22 09:21 AM
Updated by:
 
Contributors