Hi guys,
This week we were faced with a customer that made translations needed for their website. These translations were saved in Excel and needed to be added to the translations.xml file in Dynamicweb. The problem was that the file contained over 9000 records, not something to be done by hand.
We created a small console app to merge records from an Excel file (after saved as a tab delimeted text file because of encoding problems) into a translations.xml file (or any file you say you want to have your records merged into).
We've published it through Bitbucket (https://bitbucket.org/Innovadis/dw-languagemapper/overview) for people to use it and enhance it for future us. Feel free to use it whenever you need it and if you have modifications for it your free to create pull requests four your project!