The error you're getting is because VizAlerts found two fields in your data whose name matches a single defined property.
There's a little funkiness there because we changed the field names a few versions ago to make them more generic (as we wanted VizAlerts to do more than just emails). But, we also wanted the new version to be backwards-compatible with everyone's previous alerts. You can see the regex patterns used to match the fields in this portion of the code:
# General # consolidated and sort have backwards-compatible options for v1.x self.action_field_dict[GENERAL_SORTORDER_FIELDKEY] = \ ActionField(GENERAL_SORTORDER_FIELDKEY, GENERAL_ACTION_TYPE, False, False, u'.*Consolidated.Sort|.*Sort.Order') self.action_field_dict[CONSOLIDATE_LINES_FIELDKEY] = \ ActionField(CONSOLIDATE_LINES_FIELDKEY, GENERAL_ACTION_TYPE, False, False, u'.*Consolidate.Lines|.*Email.Consolidate')
So your two fields are being matched like so:
Email Consolidate Lines - Closed C/R
Email Consolidated Sort Order - Closed C/R
So, just rename the second to "Sort Order - Closed C/R" or something similar, and it will work fine. Just make sure "Sort Order" comes first--the rest doesn't matter.
Does that answer your question?
My question was: why the naming worked in the first worksheet but failed in the second worksheet in the same workbook...? I would think if the naming does not work, then it shouldn't have worked in the first worksheet either as it has both "Consolidate Lines - xxx" and "Consolidated Sort - xxx" as well. Yet, it worked in the first worksheet -- the VizAlerts went out with no errors... That's what confuses me. If it didn't work in the first worksheet, I would have figured it out earlier...
That I can't answer without seeing the logs. My guess is that there was something different between them, somehow.