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?
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.