topic Re: Classification translation in Collaboration with other software

Classification translation

Ahmed_K — Sun, 17 Jan 2021 14:48:36 GMT

Hello,
i want to translate the Uniformat classification downladed from Archicad website,
the xml file, once loaded in excel, it can't be saved back as an xml to load it ino archicad,
Is there a way to translate it ? or workaround ?
Note : I have an excel sheet with only ID + translated classifications
Thanks

Re: Classification translation

Laszlo Nagy — Sun, 17 Jan 2021 17:20:42 GMT

Try editing the XML file with a dedicated XML editor, like Notepad++ (it is free). Then, if you save changes, the XML files should still have the same format.

Re: Classification translation

Ahmed_K — Sun, 17 Jan 2021 17:48:57 GMT

i already tried this, , the problem is : how to translate only the classification names,

Re: Classification translation

Laszlo Nagy — Sun, 17 Jan 2021 18:39:19 GMT

Well, if you post a concrete example of what you are trying to achieve, I can take a look at it to see if I can find a way of doing it.
A screenshot or two would also be helpful.

Re: Classification translation

Ahmed_K — Mon, 18 Jan 2021 12:32:43 GMT

This Is the classification system, all in English, ( Masterfomat )
To translate names in frensh, to do this on archicad is a waste of time
translating the file in a XML editor will also translate commands

Re: Classification translation

Laszlo Nagy — Mon, 18 Jan 2021 13:40:07 GMT

OK, and what are you trying to do?

Re: Classification translation

Ahmed_K — Mon, 18 Jan 2021 14:41:51 GMT

translating classification names, from english to frensh

Re: Classification translation

Ahmed_K — Mon, 18 Jan 2021 16:06:05 GMT

open file in excel => translate => save as XMl , don't work too

Re: Classification translation

Laszlo Nagy — Mon, 18 Jan 2021 21:44:34 GMT

And what if you simply save the XML under another name, and change the texts in the XML itself?
Looking at the XML, I would assume the simply changing the following

<Name>Procurement and Contracting Requirements</Name>

<Name>French Translation Text</Name>

should work.

Re: Classification translation

Laszlo Nagy — Mon, 18 Jan 2021 21:55:20 GMT

Actually, I was curious so I tried it. I just modified the XML file in Notepad++, saved and I could import it into the Classification Manager Dialog without any problems.
As you can see, I have translated a few English entries into Hungarian and they are correctly displayed.

Re: Classification translation

Ahmed_K — Tue, 19 Jan 2021 10:45:14 GMT

Thanks LaszloNagy !

It works yes, but teadious for 1200 name 😛

i'm searching for a way to automate this
in XML, there is a function that highlights all same words, so , this inspires me , it may work :

* Search for <name>

* Highlight them

* select lines with highlited names

* Copy lines to a new file

* translate them with translate function ( it exists )

* Copy them back to replace lines ( i think there is a function like this, i did some researches)

It may work after some research, that would be a huge help for the community

Re: Classification translation

Laszlo Nagy — Tue, 19 Jan 2021 11:53:21 GMT

Cool, let us know if you manage to work out a good solution.

Re: Classification translation

runxel — Tue, 19 Jan 2021 12:05:07 GMT

Sure enough a small Python (or whatever floats your boat) script could handle this easily.
Only the automatic translation would be "tricky"; I mean, we all know the quality of those

Re: Classification translation

Ahmed_K — Tue, 19 Jan 2021 13:24:42 GMT

Python inside archicad or notepad++ ?

Re: Classification translation

runxel — Tue, 19 Jan 2021 13:45:36 GMT

bouhmidage wrote:
Python inside archicad or notepad++ ?

The "normal" Python.

Re: Classification translation

Ahmed_K — Tue, 19 Jan 2021 13:48:25 GMT

So maybe a programmer here can help

Re: Classification translation

poco2013 — Sun, 24 Jan 2021 06:29:41 GMT

Actually this is "somewhat" doable in Python using Google's google_trans_new module, which uses the Goolge translator site.

One: Google site has a limit and will periodically shut down without warning if overused. You can purchase a paid service.

two: The translations are not very Good.

Three: Some English words or phases will translate to the same French word or Phase. This will cause duplicate ID's and invalid the XML file. I worked around the problem by appending a line count to the end of any duplicate phase to make it unique. This may not be acceptable.

Four: Since the translations may not be acceptable-- they would still have to be manually reviewed. This somewhat defeats the purpose.

I have attached a French translation XML
from Google to demonstrate the possibilities.

Re: Classification translation

Ahmed_K — Sat, 14 Aug 2021 17:36:07 GMT

Hello again !

this application can open, edit, and save again any archicad classification XML file,

https://www.oxygenxml.com/

i tested it and it works like a charm