topic Re: XL2XML Classification manager - Open source in Project data & BIM

XL2XML Classification manager - Open source

Ahmed_K — Tue, 18 Jun 2024 20:49:26 GMT

I was looking for a tool to manage the classification system outside archicad for easier hierarchical numbering, mass editing and more,

Since there's no solution for my wish, my brother, a junior developper, came to my rescue with this tool,

The XL2XML plugin converts the archicad classification into an excel sheet structured in 4 columns

ID
Name
Description
Level

The level indice is generated according to the xml structure, when you convert an xml to excel,

When converting exel to xml , level indice are used to create the hierarchical structure of the classification

The project is opensource, so if someone want to amelorate it, or add new functionality, it will always be welcome,

Here is the donwload link from the developer's Github ,

The file is named Excel2XML.zip

https://github.com/KhaledKammoun/EXCEL2XML

Any encouragement will be appreciated for him 😃

Operating system used: Windows 11

Re: XL2XML Classification manager - Open source

Ahmed_K — Wed, 19 Jun 2024 09:19:11 GMT

Video Tutorial :

Re: XL2XML Classification manager - Open source

Simona — Fri, 21 Jun 2024 12:26:36 GMT

The program is really cool, unfortunately it cannot be used for renaming classifications because it does not preserve attached properties, and the IFC converter converts all classifications to ElementProxy. However, it is an excellent tool for creating a completely new classification system. Thank you and your brother 🙂

Re: XL2XML Classification manager - Open source

Ahmed_K — Fri, 21 Jun 2024 13:30:44 GMT

Thank you Simona,

I noticed in your Screenshot that you put the class name in the ID field, you work like that, i guess that's a classification system you build your self.

I suggest you to take theese notes in consideration and try if it works for you :

ArchiCAD uses the ID field to match between a class and selected properties,
also, the ID field can't receive an duplicated value in the same classification system , Exp : you can't set the ID to "wall" in two branches.
if you set an ID system for your classification ( numbered tree ) and put your classes in the name field, then , when you rename your classes you won't loose the connection to properties,
only the branches where the ID changes will loose the connection to propreties, because archicad won't recognize that NEW ID in the XML file, to match it to the properties that have the OLD ID

that's why you loose your connections to properties,

the general rule is : Fixed ID, modifiable name.

Re: XL2XML Classification manager - Open source

Simona — Fri, 21 Jun 2024 13:49:17 GMT

It is actually original Czech version of Archicad 22 and 2.0 classification system. I noticed that your xlsx looks different, but I didnt realized this could be the problem. It explains a lot of issues I've been having past week 😄