Looking to write some code to translate a wirelist from excel to XML in order to import it into the harness model. Is there a document that discusses the required parameters for the components and Connection sections? the Ninja cabling technical bulletin package did a great job of describing wire spools. Hopefully there is an equivalent for the Components and Connections.
I haven't seen any reference documents for the xml-format. We used also excel wire list generator for a while but that macro generated Neutral Format wire lists. Some pointers to NWF wirelists are available e.g.
Later we switched to using Kicad to make our wire lists (starting from this https://github.com/lassefyr/kicadToCreo). The switch was made because we didn't get the paid version of the creo schematic and the maintenance was way too difficult with our version of the excel macro. In Kicad we can copy-paste working harness designs and we can have our own connector and spool libraries. Best feature is the visuality of the connections. You will need some python programming skills to update the scripts to your specific needs but python is not that different from the Excel macro programming...
PTC considers the XML schema to be proprietary. Make it difficult to create one on your own, but, for them it means that they can add new features without needing to send out a lot of new documentation
