Hey everyone.
I'm indexing a report with a standardized header used for a dozen different report types. The problem is, for a subset of those report types, one of the date fields isn't populated. And that would normally be fine, but arsload doesn't appear to be using the default value I've specified, even when I feel it should be.
When the field is empty, and I don't do any character removal, I get:
ARS1129E Row 1: The string " " could not be converted to a date from the format of %m/%d/%Y.
Fine. It found some spaces where there should have been some numbers. So I changed the Application configuration under the 'Load Information' tab to remove all leading, trailing, and embedded spaces. So I run the report again, and I get:
ARS1129E Row 1: The string "" could not be converted to a date from the format of %m/%d/%Y.
So it's done the right thing in terms of character removal, resulting in a blank/null/zero-length value. I would expect that when faced with a null value, that CMOD would substitute the default value, and load the data. No such luck.
I'm kinda out of ideas for this. I was thinking of adding a field mask for the date value, but I suspect it would just cause indexing to fail immediately when it doesn't find data matching that mask.
Any assistance would be greatly appreciated, as always.
-JD.