I have the following references hierarchy (first image) and I run the report manager obtaining the result showed in the second image. Now I wolud like to have a table sorted like the original hierarchy, with the nested references under the father, is it possible?
Can it be exported to excel and use the excel tools to do it better?
Sorry I'm a beginner when it comes to connect and haven't had enough training or experience yet.. but have been using mstn for over 25 years... I don't think aggregation and sorting is fully developed in CE yet but to be fair I'm going off hearsay not fact checked but I know how to do this in excel... it might be a quick work around until you get definitive answer for CE.
Lorys
Started msnt work 1990 - Retired Nov 2022 ( oh boy am I old )
But was long time user V8iss10 (8.11.09.919) dabbler CE update 16 (10.16.00.80)
MicroStation user since 1990 Melbourne Australia.click link to PM me
Hi Lorys,
thank you for the reply, what you said was correct, unfortunately since the fact that the hierarchy could be completely random (has no rules or scheme) it could be difficult or impossible to create an excel routine that automaticly rebuilds the hierarchy, and you had to do it handly. For this reason I woluld like to extract the reference tree already sorted.
Kind regards,
Antonio
I've no idea if CONNECT edition can sort a report in the manner you seek but for the sake of discussion, I'll assume it cannot and suggest an alternative.
You haven't stated what format the information is to be used as and also, how many files that you are looking to list each reference file and their nested references.
If its just to create a list of text of text, something like:
DGN File 1Parent Ref 1Nested Child Ref 1-1Nested Child Ref 1-2Parent Ref 2Parent Ref 3Nested Child Ref 3-1Nested Child Ref 3-2Nested Child Ref 3-3DGN File 2etc...
If this was a task I had to do, I would write a VBA project to automate the process. This could be done either within MicroStation or Excel (the latter I would use if wanted to use a worksheet to display the output data not only at the final stage but at intermediate stages as well, which can be helpful).
The VBA project would do something like the following:
Barry Lothian said:I would write a VBA project
Here's a starting point: Reference Logging with MicroStation VBA. The project is ancient and could do with an update.
Regards, Jon Summers LA Solutions
Answer Verified By: Antonio Commone
Hi Jon,
Thank you for your answer. I am trying to run the macro "LogRefs.mvba" but it returns the "Interface not registered" error.
Do you Know how can I solve it?
I use MicroStation CONNECT Edition Update 16 - Version 10.16.00.80, on Windows 10 Pro OS 64 bit.
Kind Regards,
Antonio Commone said:I am trying to run the macro "LogRefs.mvba" but it returns the "Interface not registered"
Apologies: The project is ancient and could do with an update. The message is about a separate module that is no longer available. It's not vital, because it's there to save/restore preferences and there are other ways to achieve that. The VBA project is open to investigation, so you and others are welcome to use the VBA Interactive Development Environment (IDE) and poke around inside.