I had a question about using the Expression Builder for Item types. I have my excel set up and the Item types but when I go to use the expression builder it gives me a choice for everything except the one I am currently trying to make an expression for. I added some pictures to show how my expression builder looks and the excel for reference. If anyone could help with how my expression should be set up that would be great!
I believe I found the issue yesterday. I still had the extra information really far down on the excel. Thank you so much for all your help!
Yes, make sure you have your ITEMTYPE_LOOKUP variable mapped to pull the excel sheet from your WorkSet location. You can have multiple instances of this variable, just make sure the appropriate operator is used in your CFGs.
2022R1 Item Type Test.dgn
5125.Project Information.xlsx
Justin Guiliano, PE
I know its been a few days but can I place this excel in each workset and it still work? I changed my configuration variable to look in the workset that I am currently in and go to that file location within the workset and when I test the expression builder it says it works but still isn't showing the value that I set. Is there a certain way to set up the configuration variable to do this?
I have my preferences set up to where the explorer always on the left side of my screen so I don't believe that would be the issue.
Hi Richard,
There is a Microstation defect that is present in ORD where text fields based on Item Types will not update unless Explorer is open at session start (its ridiculous, i know). Could that be causing your update issues?
Regards,
Mark
OpenRoads Designer 2022 R3 (10.12) | Microstation 2023 | ProjectWise CE 3.4