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?
I've used it a lot without seeing that error. Line 327 of the AP_CONSTITUENT_IMPORT procedure marks the handling of the create duplicates yes/no parameter, if that helps. I always set that parameter to No.
Always the hardest thing for us was getting the tab-delimited .txt file created, emphasis on tab-delimited. Never got that right except using Excel for desktop (not Office 365, Numbers on a Mac nor Libre Office). But those errors are not your error here.
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.txtThe 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.
Thank you for your help John Trimble and Brian Pedaci. I will double check it is a tab-delimited txt file and use the File Name parameter.
I'm having this exact issue, so following along with interest! Please let me know how you've resolved it, if you have figured it out!