When using Import set to register translated text record, Documents field is empty.

[ubido]

Dear folks,

I'm having the same problem as described in this post from about a year ago:

https://community.servicenow.com/community?id=community_question&sys_id=936d4be9db9cdbc01dcaf3231f96...

And I applied the same solution and it did not work; what I'm doing is trying to use an import set to translate a few catalog items contained in an order guide to French. I did the translation manually in our development instance and exported the entries from the sys_translated and sys_translated_text to a couple of Excel files.

I successfully imported sys_translated into our QA instance, but when I try to do the same for sys_translated_text, the Document field only has an "(empty)" value. However, when I open the record the information is there and I'm actually able to save the record again by manually reentering the expected value for the Document field. But this is not practical and defeats the purpose of using an import set (given that I have tons of translations to do).

I'm including the following fields in the Excel file I'm trying to import:


Document
Field Name
Table Name
Document Sys ID
Value
language


This is following the recommendation in the link above, but then now the document information is not there (originally I was not including the Document Sys ID field). My apologies if this has been answered before, but I have been looking in the community site for a solution unsuccessfully. If somebody has answered this question before, please provide the URL to the correct answer or help me find the solution for this one.

The enclosed screen shots show the resulting entries in the Translated Text.

Best regards,

ubido

[denis hoffmann · Accepted solution]

On your DEV instance,when you check one of your record of sys_translated_text, in Form mode,  with "right click/Show XML",

Does the sys_id in 'documentkey'  xml tag match the sys_id value in your "Document Sys ID" column of the excel file ?

Maybe the sys_id currently set in excel is of the translation record in sys_translated_text, instead of the sys_id of the referenced document to translate ?

[ubido]

Dennis,

No, it does not; I used the document_key and it worked! Thanks a lot for your valuable assistance with this matter. If I may, is there an easier way to get the document_key value?  If I can display it on the list view it would make the translation process very easy to implement.

Best regards,

ubido

[ubido]

Thanks for your help with this; the solution was to include the documentkey in the Excel file.

Regards,

ubido

[denis hoffmann]

also a warning from HI :

Customized translated text gets overwritten when the instance is upgraded ( if BR are not run)

https://hi.service-now.com/kb_view.do?sysparm_article=KB0521522

[ubido]

Thanks, I've seen this warning before and I always make sure that the "Run business rules" checkbox is selected in my transform maps.  Does this means I don't have to worry about losing my custom translated text after an instance upgrade?

Regards,

ubido