How to create XML file from Excel for V3.10.02 - EN - ES - ZH - ZT - PT

[IrwinMFletcher]

I exported the EN-US language pack and had it professionally translated into Spanish-Mexico, Portuguese-Brazil, Chinese-Simplified and Chinese-Traditional.

It is in an Excel spreadsheet with the English text in column A the ES in column B and so on.

What is the best and or easiest way to get this into an XML file that will import successfully into SupportSuite V 3.10.02?

I will gladly give these translations to anyone, actually the whole community, if someone can help me get these things into a proper XML file for import.



Thanks

Joe

[Sheep]

Damn that's going to be harder as we're losing some informations

<phrase section="knowledgebase" code="articles"><![CDATA[Articles]]></phrase>

We're missing the section and the code

We can still try to get the code and section back by matchin the CDATA from the english column.
Send me the excel i'll try to do it using KETTLE

[IrwinMFletcher]

Sure, where would you like me to send the file to?

[Sheep]

you can send it to --done--

[IrwinMFletcher]

En
Es
Pt
Zh
Zt

[Sheep]

Sorry but it seems like that the chinese is giving me troubles What charset should be used?

Here is all i could do for Port and Esp
I'll let you finish the xml file (the biggest part is done)

[IrwinMFletcher]

The Chinese should use UTF-8.

Thanks for the help on the Spanish and Portuguese. I'll take a look at them soon and get them posted when they are working.

Joe

[Sheep]

Ha ha! Guess what... i had forgotten to set UTF-8 in the last step (put content to file)

I got them all working (and the esp and port were not in UTF-8, here comes the updated ones)

Greetings,
Antoine

[IrwinMFletcher]

I exported the English language pack and then hand translated every line into Portuguese.

It still won't import.

Here is EXACTLY what I am doing and seeing along with the file.

Language>Import

Browse to the xml file - It's on my Desktop in this case.
Merge with: -- Create New Language --
Ignore Version: No
Click Import XML

I get a message that Language "" has been imported succesfully. However, it has not.

The XML file is attached. What is up?

I have 4 other languages to do this with and I will submit them all, for free, to these forums.

I am guessing the error is in here:


<?xml version="1.0" encoding="UTF-8"?>
<!-- XML Generated On: Monday, July 23, 2007 07:48 AM -->
<swiftlanguage>
<title><![CDATA[Portuguese (BR)]]></title>
<isocode><![CDATA[pt-br]]></isocode>
<author><![CDATA[Irwin M. Fletcher]></author>
<charset><![CDATA[UTF-8]]></charset>
<textdirection><![CDATA[LTR]]></textdirection>
<version><![CDATA[3.10.02]]></version>



Joe

[Sheep]

Sorry for not answering sooner

<author><![CDATA[Irwin M. Fletcher]></author>

Theres a missing "]"

<author><![CDATA[Irwin M. Fletcher]]></author>