Exporting translation from bps_dev to production

0

Hi,

there's no solution for this.

Even if you would export the translations to an Excel file and you try to import them in an another environment you will likely have errors.
- You will have different ids for the elements
- even if they have the same ids, you may have new elements which don't exist on the target environment.

Best regards,
Daniel

Hi!
In Knowledge base was a article about export and import translations. Link below. The functionality worked since Webcon 2023 R1 but there is a resctriction note that export/import translations work only on the one environment(i mean DEV or TEST or PROD) and the same WEBCON version.
I think the best way is import process with translation, in my opinion is the safest way but if you have to do it without import you can try functionality from article. Try import .xlsx to another environment but ID of your fields, steps etc. will be different between environment.


https://community.webcon.com/posts/post/export-and-import-of-translations-in-webcon-bps/418/4

Thanks for the answers but i am looking for a solution to update the translations from the database(i know it is probably not recomended but as we have loads of data rows with sqls, ) therefore i am looking for such solutuions.

If you need to update the translations of data rows/data tables or choose fields, you are even more or less out of luck / likely to run into issues.

The translations are stored in the column WFCON_CONFIG of table [WFConfigurations] in an XML structure

<configuration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<select>
<displayNamesMappings columnName="LatestVersion" displayName="Latest template version">
<isVisible>true</isVisible>
<showAsAlink>false</showAsAlink>
<encodeHtml>true</encodeHtml>
</displayNamesMappings>
<percent />
<indicators />
<bold />
<boldcss>font-weight: bold;</boldcss>
<allowemptytagvalues>true</allowemptytagvalues>
<showColumnsHeaders>true</showColumnsHeaders>
<translations>
<fieldname>LatestVersion</fieldname>
<fieldtranslation>
<language>de-DE</language>
<translationValue>Aktuellste Vorlagenversion</translationValue>
</fieldtranslation>
</translations>
</select>
</configuration>


In theory you could copy over the value from one database to the other using the GUID of the field, but this is something you will do on your own risk and probably against the EULA.

Best regards,
Daniel