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.