engineer@anago
New Member
Hi there Alibre users,
I've just finished creating an Excel Add-on that creates a Bill of Materials from the currently opened Alibre Assembly built in C#.
(We needed a customized solution, and the built-in Alibre BoM generator didn't have what we needed).
The Add-on itself works just fine with only one issue: it takes quite a while to load part properties from a part in an assembly on first time use.
Basically, my Add-on walks down the entire tree along all branches of the whole parent assembly and spits out a Bill of Materials in the currently opened Excel document.
On generating a BoM for the first time of opening an Alibre Assembly session, it can take several seconds just to retrieve the part properties of one part file - this can make BoM generation on large assemblies take several minutes to finish. More specifically, accessing the
I have a sliver of hope telling me it might be something to do with the fact that my project is an Office VSTO development project, and perhaps something about that and the Excel COM Interop could be interfering with things, but I doubt it.
What I'd like to know, is if anyone else has ran into this and has found a work-around or not.
(Will provide the files if absolutely necessary. Withholding for now as I'd like to release it only if fixing this problem is possible)
Appreciate the feedback.
I've just finished creating an Excel Add-on that creates a Bill of Materials from the currently opened Alibre Assembly built in C#.
(We needed a customized solution, and the built-in Alibre BoM generator didn't have what we needed).
The Add-on itself works just fine with only one issue: it takes quite a while to load part properties from a part in an assembly on first time use.
Basically, my Add-on walks down the entire tree along all branches of the whole parent assembly and spits out a Bill of Materials in the currently opened Excel document.
On generating a BoM for the first time of opening an Alibre Assembly session, it can take several seconds just to retrieve the part properties of one part file - this can make BoM generation on large assemblies take several minutes to finish. More specifically, accessing the
IADOccurrence.DesignSession.DesignProperties
property is what takes so long. I believe this might be due to Alibre performing some sort of caching; since it doesn't need to hold this property in memory all the time, it will only cache it in memory when it is needed, making it take a long-time to access if it's never been accessed before in the current session.I have a sliver of hope telling me it might be something to do with the fact that my project is an Office VSTO development project, and perhaps something about that and the Excel COM Interop could be interfering with things, but I doubt it.
What I'd like to know, is if anyone else has ran into this and has found a work-around or not.
(Will provide the files if absolutely necessary. Withholding for now as I'd like to release it only if fixing this problem is possible)
Appreciate the feedback.