Converting Between Colleague IDs And Prox IDs

NOTE: The prox IDs are now available by accessing the Person file fields PERSON.ALT.ID.TYPES and PERSON.ALT.IDS in the Colleague database.  Select the entry in PERSON.ALT.IDS which has the ID Type of "PROX".


To convert a list of Colleague IDs into a list that includes prox IDs, use the Informer report called, "Doors System - Records by Person Type".  With Informer open, click on the report name, click on the Data tab, and enter a list of comma-separated Colleague IDs in the input box labelled "Cedarville ID (7-digit)".  Click the "Launch Report" button, and after the processing is completed, the output list can be stored by clicking the "Export Results" link toward the upper-right corner of the window.  Choose the output format that is desired (usually "Excel Comma-Separated Values"), provide the Output Filename, and select other options as necessary for the job.  Then, click the Export button, and if necessary, navigate to the target output folder.

NOTE: Be sure that your input and output counts match up.  If they do not, check for possible missing Colleague IDs (may indicate an invalid Colleague ID was provided, or that there is no prox ID assigned for a Colleague ID); alternatively, multiple prox IDs may be assigned to a Colleague ID in such a case.  ALSO: There is a limit to the number of Colleague IDs that can be specified in the Informer report input box, so missing IDs in the output may indicate that the number of Colleague IDs specified for the run were too many.

A similar process, using the same Informer report, can be used to generate a list of Colleague IDs, when provided a list of prox IDs.

Was this helpful?
0 reviews