• Replies 4 replies
  • Subscribers 343 subscribers
  • Views 94 views
  • Users 0 members are here
Options
Related

Constituent Import Utility Report

Amber Sanders
$organization

I am attempting to use the Constituent Import Utility Report using the ConstituentImportStandardFormat.xml format in File Mover.  I followed all the instructions, formatted the constituent list to match the xml format, saved it as a text file, but still receive this Error 537, Severity 16, State 2, Procedure AP_CONSTITUENT_IMPORT, Line 327, Invalid length parameter passed to the LEFT or SUBSTRING function. 

I have no idea what that means or where to check to correct this error.  Does anyone use this utility regularly? Can you share any tips or information of the proper way to format your lists to import constituents in Tessitura?

Parents
  • $organization

    Hello Amber,
    Please fill in the full path to your data file in the File Name report parameter, e.g. \\AWS.TNHS.CLOUD\us-west-2\Clients\UNVWA0USWA0\Test\User Reports\Donor Imprt List\Donor Import List.txt

    The error comes because the utility tries to separate the path from the file name based on the last instance of the \ character. When there is no \ in the file name, it cannot calculate the start position of the actual file name in the string. 

Reply
  • $organization

    Hello Amber,
    Please fill in the full path to your data file in the File Name report parameter, e.g. \\AWS.TNHS.CLOUD\us-west-2\Clients\UNVWA0USWA0\Test\User Reports\Donor Imprt List\Donor Import List.txt

    The error comes because the utility tries to separate the path from the file name based on the last instance of the \ character. When there is no \ in the file name, it cannot calculate the start position of the actual file name in the string. 

Children
No Data