Batch Extension Issue

Nick McGinnis

Hello,


I am working on a batch extension. The data gets imported correctly but when I open the batch the extended fields are just showing their default values. When I look in the database the extension table has the data that was imported but the ID is different than what is stored in the OOB batch table. I have not had this issue with other batch extensions so I am not sure if there is something strange about the batch I am extending (Direct Marketing Effort Batch)


These are my add and edit rows: batch extension issue.txt

Ryan Aldin

Looking at your insert statement, I don't see that you are specifying the ID. You'll need to set the ID in your table to be equal to @ID.

Harry Frank

Working from this example:
https://www.blackbaud.com/files/support/guides/infinitydevguide/infsdk-developer-help.htm#../Subsystems/batch-developer-help/Content/Exercises/coexExercise15CreatingTBatchTypeExtensionSpec.htm


You didn't provide the header of the spec, so I wonder if you have the PrimaryKeyAsForeignKeyTablename attribute set. This would require the ID in the extension to match the OOB table.

Harry Frank

Just saw Ryan's post, and yeah, that too!

Nick McGinnis

Thank you both for your answers, I can't believe I overlooked that ?‍♂️. It was both issues, I was not setting ID on the insert and I also did not have the PrimaryKeyAsForeignKeyTablename set on the table spec.