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
- Import the third party information into an Excel spreadsheet.
- 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.
- 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