How to remove automatic decimal separator from publication output property field value?

Question

Hi All,

[Using SDL Tridion Docs 14.0.4101.2]

I have a custom metadata field implemented in MetadataConfig.xml as follows:

<ishfrmfield id="PublicationOutput.EditionYearField" name="PublicationOutput.EditionYearField" ishfieldref="FNIEDITIONYEAR" level="lng" ishfielddatatype="typestring">
<label resourceref="FNIEDITIONYEAR.Label">&Edition year</label>
<description resourceref="FNIEDITIONYEAR.Description">Edition year</description>
</ishfrmfield>

Despite this, I if I open the publication output properties in the Content Manager, it displays the value with decimal separators:
Screenshot of Trados Studio's Publication Output Properties dialog showing fields for Output Format, Language combination, Part number, Edition Year, Edition Month, Output Name, and Print Location.

And it is still validated as if it would be a numbers only field. Even though I can't seem to find anything that would indicate that. The following screenshot was taken in Publication Manager, but I get a similar error in Content Manager as well:
Error message in Trados Studio stating 'Value 'valuehere' is invalid for the 'Edition Year' field of object '...' The given value 'valuehere' is not a valid number format (decimal separator - group separator).'

I think I'm missing some additional configuration. Could someone tell where to look for additional field configurations (if not in MetadataConfig.xml)? The current behavior is desired (only allow numbers), but I'd like to remove automatic decimal points for aesthetic reasons.

Thank You in advance!

Generated Image Alt-Text
[edited by: Trados AI at 6:43 AM (GMT 0) on 5 Mar 2024]

Dave De Meyer · Answer

Hi Gerg&ouml; 
 The field FNIEDITIONYEAR seems to be created in the database (over DatabaseUpgradeTool) as a NUMBER field. MetadataConfig.xml only decides if/when/how the field gets rendered, but the basic type was already decided in the database upon field creation. 
 So you need to verify with whoever created the field for you. They probably relied on docs.sdl.com/.../customizing-metadata-fields-and-values 
 If you want to know the type of your fields (or on which level and card types they are), you can use the PowerShell ISHRemote module over the web services... Look in the demo script and recording for "Get-IshTypeFieldDefinition | Out-GridView", see community.sdl.com/.../automating-on-sdl-tridion-docs-tds2019---business-process-examples 
 Best wishes, Dave

Tridion Docs > 01 - General Discussion Forum

How to remove automatic decimal separator from publication output property field value?