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 Lessons Learned Articles for information on importing personnel information:

Lessons Learned Article #4809: Personnel.csv file fails to import into Continuum
Lessons Learned Article #4966: Creating Personnel objects via CSV import file that include area assignment and photo.