In the current version of Kinetic I don’t get the paste new/update in the grid for UD Column maintenance. Since I have 60 fields to add I really don’t want to hand enter each of them. So I looked to DMT, I used the template builder for Extended UD Fields and any of the optional fields DMT will say are invalid. For example FieldScale which sets the number of decimal places DMT says is invalid. DMT will ONLY process the required fields. This works sort of fine for text fields but you do need to go back and change the format. But for decimal fields DMT rejects that row because you don’t have a value for the number of decimals. So catch 22, can’t have the Field column that says how many decimals but can’t enter the record because you don’t have the number of decimals.
Anyone successfully use DMT to create User Defined Fields?
This template will fail since it has FieldScale which is the name of the field the template builder inserted. DMT will not even attempt to process it so the column in my example having no value isn’t an issue.
If I remove the FieldScale column DMT will process file but the underlying BO will reject it because there is no value for FieldScale for decimal. If this was text field it would process and insert it without complaint.
that was an attempt to see if I could get DMT to ignore things and I uploaded the wrong example. I updated my post with an updated screenshot and spreadsheet.
I just retried again adding in FieldScale and DMT rejected it.
