The Global Archicad Community

[gdford]

Classification XML editor
What is the best editor for creating archicad classification system XML files external to archicad. I have not been able to tweak the excel merging of XML data and the non-repeating elements to generate an XML file that archicad will import without prior additional editing as Excel seems to leave out necessary items. Surly there exist an XML editor system that can be set up which will let me deal with the data and not have to cleanup all of the stuff that doesn't change. Preferably i could feed the new data in through an excel spread sheet or an Access database. I understand how to create an XML classification file that will import into archicad. My goal here is to merge new XML data into an existing XML file and need to deal with only the actual data and not the XML formatting or the XML header information that never changes. Someone must have a way to automate this??

Anyone have thoughts on this?

[kzaremba]

Usually with xml's from AC Excel doesn't work because the data structure is too complex for default XML deserialization procedure. In order to make it work you need some VB/C# script to handle reading and writing back proper XML structure.

[gdford]

Thanks for the confirmation ..... this is what i was expecting.
Is there an editor out there that can handle this???

[B.E.A.T.]

Looking for an answer to this question, I came across this topic. Still relevant imho...

I have a simple "office" Classification looking like this:

10. Chapter 10
⎣10.00. Chapter 10 - general
⎣10.01. Chapter 10, part 01
⎣_10.01.01. Chapter 10, part 01, element type 01
⎣_10.01.02. Chapter 10, part 01, element type 02
⎣10.02. Chapter 10, part 02
20. Chapter 20
⎣20.00. Chapter 20 - general
⎣20.01. Chapter 20, part 01
⎣_20.01.01. Chapter 20, part 01, element type 01
⎣_20.01.02. Chapter 20, part 01, element type 02

I have the whole "outline" in a Word-doc/Excel-sheet, but would love to 'migrate' this to AC-classification, without to much manual typing... Seems straightforward, but alas...

Any thoughts on XML-editors helping in the process (I tried Atom and Xcode)

[gdford]

To my knowledge the answer is no, but there are many xml editors out there and it is possible that there is one that you can teach the archicad expected format and supply it with the data via a spreadsheet and off it will go. Excel can take your list and export it into XML and in theory i believe there is a way to teach excel the required format but i could not figure out how to do it. I built my own xlm generator in excel using visual basic. I proved it can be done, but it is not a general all purpose classification generator. It was very specific to my needs. The best solution is to hire an excel visual basic programmer to build you a classification generator. You could probably get this done for a few hundred dollars as there are millions of excel programmers all over the planet looking for work. Then you could just enter your classification in the spreadsheet and let the visual basic code create the xml file.
If you haven't already inspected archicad classification format you can export any of the default classification systems and inspect the xml using Notepad++. This can be a bit overwhelming. To really understand how the xml is put together build a new very small classification system and export it for study. Make small changes in the classification system and see how that changes the exported XML.
I feel your pain.

[B.E.A.T.]

Thanks for the reply. Unfortunately on my Mac, VBA is not really an option... Maybe Applescript would work or even Python in Archicad. I'll see if I can come up with a solution.

[gdford]

My understanding is that Apple does not implement scripting in excel....
However you could hire someone to just code this from scratch.