Home > Forum > Database > Translaation query from database

Translaation query from database
0

we are currently in a process of compare which translations we have and which we do not. I do not want to do it by going through each application than dowload the excel but I would like to generate a report with app,worfklow and form fields where there is no tranlsation. Can anyone help me with this issue?

Hey atleast I can help you with tables with contains data what you need


Table: Translates
Description: Table contains translations provided by users about process configuration.

Table: DicTranslationsObjects
Description: Dictionary table contains translations for BPS objects

Excelent doc with description about keys columns types etc.
Table Of Contents
https://developer.webcon.com/2024/resources/db/?PageSpeed=off

Would be nice to share your result query and we can help with some tips :)

MVP
In reply to: gelu100

Cheers but this not clarify the question as I am aware of those tables, however i have no clue how to join it with the thing that we have in wfelements/wfelementsdeatails. I tried to look for the file that you generate for translations

Hi,

Currently I have no access to WEBCON, so I will just provide a few information.


The translates table contains all translation for all objects. The linked dictionary contains an overview what the ids mean.

https://developer.webcon.com/2024/resources/db/?PageSpeed=off#DicTranslationsObjects

You can also read up on the whole topic here:

https://daniels-notes.de/posts/2021/series-expert-guide-part-5#retrieving-translations-of-webcon-bps-elements

If you want to identify the missing translations you will have to left join the WFConfiguration and WFDetailsConfig with the languages and translations.
You can also take a look at this sql statement also it’s for another use case it should help:

https://daniels-notes.de/posts/2023/updating-to-bps-2023#fields

The WfElement* contains only workflow instance data and no configuration information.

Best regards,

Daniel

In reply to: gelu100

Cheers but this not clarify the question as I am aware of those tables, however i have no clue how to join it with the thing that we have in wfelements/wfelementsdeatails. I tried to look for the file that you generate for translations

Can you explain why did you mark wrong answer?
Its not my foult you wont read documentaion about tables, it shows everything as you need.
I also didn't know which tables to connect, but when I read the section where translations are stored, everything became clear.
I try to help you without hesitation. Do you know how works forum ?
it helps you solve a task, don't just give it a done job, just commit and do something yourself and don't require a ready-made solution.

Be more respectful beacuse u get what you need to do get result. Forget to add JUST DO IT ;)