Load Constituent Address Correction File

After the batch process has been run through Intelligent Search Technology, Ltd, the next step in this process is to load the corrected batch into CAMS. As part of this load process, CAMS will create a new entry for the previously designated address type, marking the original entry as Inactive and the new entry as Active. If the prospect also has a student record and/or a development record then the corrected address is displayed in those modules as well provided that a link has been established through the Student Load or Constituent Transfer processes.

To load Address correction file:

Return to the CAMS Enterprise Development Address Validation screen (Development >Constituent >Address Correction) and click the Load tab.
Navigate to the location of the returned file. The path must be in UNC format (cannot be a C:\ type path).
Click Load Batch File. The list of names and the corrected address information display.
Click the Insert tab to map the new address record fields into Constituent records in CAMS. New address record fields will only need to be mapped once to include all Constituents in the import file.
Select the import file field name in the Select Options drop-down then select the CAMS field in the Field drop-down. Click Append to add that import field to the CAMS field.
Multiple import fields can be linked or merged into one CAMS field by simply selecting another import field then click Append to merge the additional field(s) into the same CAMS field. In the example above, the Street Number and Street Name have been linked into the CAMS Address 1 field and the import file Apt Name and Apt Number have been linked into the CAMS Address 2 field.
If an incorrect import field is appended, you can highlight and delete any of the appended fields scroll box to clear the data.
Click Build SQL. CAMS will build the SQL statement to merge the fields and display the Process tab.
The Process Results page displays with the SQL script that will run to enter the verified addresses into CAMS Enterprise.
Click Execute SQL. The corrected addresses are inserted into the constituent records.

Note: If the file to be loaded contains a large amount of addresses certain timeout settings should be changed to ensure that the file is completely loaded into CAMS Enterprise.

Set Component Services Transaction Timeout - On the IIS server open Component Services and right click on My Computer. Select Properties >Options and set Transaction timeout (seconds): to a higher number.

Set Remote Server Connections - On the SQL server open SQL Server Properties and click the Connections tab. Set Query time-out (sec, 0 = unlimited): to zero.