I am looking to create a report for my business partners on the content in our installation of Tridion. They want to know the following:
- What content has not been translated
- what content has been translated
- Does a new version need to be translated
- What is currently out for translation
The status of jobs is fairly easy. However, the translation status of items is not. We are currently on Tridion 2011 SP1. The translation information in question is not stored in the TM Database (that I can tell). My fear is that it is in application cache files on the local file system. I have written some ajax to call the TM load service:
/WebUI/Models/TM2010/Services/TranslationInfoManager.svc/Load
but that is very tedious and does not support JSONp...so it must be ran from the server. With no TM hookup in the CoreService, is there any easier way to do this?
Thanks in advance.