Skip to main content
Question

Translate text type attributes

  • 30 July 2024
  • 2 replies
  • 45 views

Hello,
Is there a way to translate text attributes? I’m currently working on a translation project and was able to find, for example, how Acumatica saves translations for item descriptions and where translations for multi-combo attributes are stored. However, is there a way to translate text attributes?

We have multiple text attributes assigned to different stock item classes:

 

 

I tried collecting unbound strings in the screen SM200540, but the values for the text attributes are not showing up:

 

 

I believe that Acumatica DB is prepared to store translations for this kind of attributes, but not sure how to do it:

 

 

I need to create GIs to export the original text in English along with the translations. So far, I’ve created views for the KvExt tables to use them in DACs and have the information available in the GIs. However, I would like to understand if I can populate the translation somehow using the standard solution for text attributes

Here is a little more information in case this helps to clarify what I need.

For attributes like this one:


I can get the description translation from the CSAttributeKvExt table:

the description values in the main language using the CSAttributeDetail table

 

and the translations using the table CSAttributeDetailKvExt:
 


but for text attributes, like the next one used on stock item attributes, I can't find a way to translate each text and populate one of the KvExt tables:

 


in this example, I have to translate the text value '160/pack.' Is there a way to translate these text values?

Any suggestions or ideas would be appreciated. Thank you!​​​​​​


Looking for a solution to this as well.


Reply