Hello, apex team and Joel Kallman.
This is my second bug report with translations today.
REGION TITLE TRANSLATIONS IS LOST WITH APEXexport AND APEX_APPLICATION_INSTALL COMBINATION.
Oracle XE 11g Linux 64bit.
Development app 110.
Production app 111.
en-us - primary lang
es - secondary
ru - secondary
How to reproduce:
Export app 110 with bash command:
$ java oracle.apex.APEXExprt -db xxx.private:1521:XE -user apex_040100 -password `cat secret.txt` -applicationid 110 -skipExportDate -expTranslations
Import with this script (as apex_040100 user)
select workspace_id into l_workspace_id
where workspace = 'PROD';
apex_application_install.set_workspace_id( l_workspace_id );
apex_application_install.set_schema( 'PROD' );
apex_application_install.set_application_alias( 'FPROD_APP' );
Then SEED and PUBLISH in Apex Builder.
At this point Region Title translations is lost for every region in app.
I use blog post "Moving your XLIFF files" by Joel Kallman on YABAOAE from the very first day it was published.
It is only way to use DEV and TEST/UAT env. on the same database with translated apps. Thanks to Joel.
If it is not a bug, please, explain me better way to workaround it for me.
Thanks for reporting this issue as well.
I filed this as Bug 13801807. I researched this and understand what the issue is. But I need to think carefully about what would be the best solution for it. I'll report back to this thread with an answer.