Classification translation

[Ahmed_K]

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

[Ahmed_K]

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

[Laszlo Nagy]

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

[runxel]

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

[Ahmed_K]

Python inside archicad or notepad++ ?

[runxel]

bouhmidage wrote:
Python inside archicad or notepad++ ?

The "normal" Python.

[Ahmed_K]

So maybe a programmer here can help

[poco2013]

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.

[Ahmed_K]

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