Uploading content to Translator

[4Casey]

I’m hope someone can help. We are developing a web site using Adobe Content Manager. We are using Translator to house our field labels, error messages, and contextual help… that sort of thing. Right now we are manually copying and pasting information from an Excel file to populate and update this information. We are now up to over 1000 messages so needless to say it is getting very difficult to manage since the content is updated frequently.

Does anyone know of an automated, or at the least faster less error prone way of uploading/updating the content in Translator? To add a little more complexity we are doing English and French.

Thank you in advance for any assistance you can provide!

[justin_at_adobe · Accepted solution]

Hi,

You should use XLIFF for this.

Regards,

Justin

[smacdonald2008]

See this AEM topic:

http://dev.day.com/docs/en/cq/current/developing/cq5-translator.html


Also -- something else jumped out at me about what you described. You mentioned that you are manually copying data from Excel into CQ. You can write a custom CQ service to ingest Excel files, read the data, and place the data into the JCR. See this community article:

http://scottsdigitalcommunity.blogspot.ca/2013/08/creating-custom-excel-service-for-adobe.html

HTH

[4Casey]

I'm very new to Experience Manager this and it is driving me rather crazy, so a big THANK YOU to you and Justin for the assistance. I will research your recommendations and let you know how I make out.

Chris