Project data & BIM
About BIM-based management of attributes, schedules, templates, favorites, hotlinks, projects in general, quality assurance, etc.

XL2XML Classification manager - Open source

Ahmed_K
Advisor

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

AMD Ryzen 9 3900X, 32 GB RAM, RTX 3080 10 GB
Archicad 27
Windows 11 professional
https://www.behance.net/Nuance-Architects
4 REPLIES 4
Ahmed_K
Advisor

Video Tutorial : 

AMD Ryzen 9 3900X, 32 GB RAM, RTX 3080 10 GB
Archicad 27
Windows 11 professional
https://www.behance.net/Nuance-Architects
Simona
Contributor

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 🙂 

XL2XML.png

Ahmed_K
Advisor

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.

 

 

AMD Ryzen 9 3900X, 32 GB RAM, RTX 3080 10 GB
Archicad 27
Windows 11 professional
https://www.behance.net/Nuance-Architects

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 😄 

Setup info provided by author