02.10.2024
12:58
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?
03.10.2024
08:43
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 :)
03.10.2024
09:25
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 :)
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
03.10.2024
22:20
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
04.10.2024
08:17
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 ;)
