Hello,
I have created a spread sheet in excel with the properties of some items.
In Descartes I created an item type library with item types and properties definition.
I am wondering if there is a way to link the cells from the spread sheets to the properties definition in a way that if I have a value in the spread sheet this is linked to the properties definition automatically in a way I just need to update the spread sheet.
For example if the property in the spread sheet excel file for purchased date is 20/04/2019 and I have to change it to a different value like 12/04/2020, if that is updated automatically in the descartes item properties.
Thanks
Regards
Roberto
The Item Types Import/Export tool, can be used to Export the Item Type Definitions to an Excel file. Once in Excel the Item Definitions value ( Date in your case ) can then be changed in Excel and reimported back into MicroStation using the Item Type Import/Export tool.
If you have attached your Item Type to elements these may have various values (dates) applied, again the Item Types Import/Export tool, can be used to export all ( or a selected few elements ) of these Instances to Excel. Having opened and modified the values in Excel they can be imported back into MicroStation using the Item Type Import Export tool to update the elements
See also Help for further information
There are currently a couple of outstanding Enhancements in this regard.
Enhancement 913885 : Create persistent link between dgn and Excel file with Item Types instance data
Enhancement 798811 : Link Excel cells directly to Item Type Properties
Hello Carl,
Thanks for your post. I managed to export the type instance and type definition to excel but I have not managed to import the amended values into Descartes.
Is there a way to see graphical example or video?
Hi Carl,
Thanks for replying. I don't know where to see the Descartes version I am using. I am updating the connection client from version 10.00.17.10 to the newest one.
How can I attached the files here?
The Descartes version can be found by Selecting Reality Modeling > Help > About.
A compatibility matrix can be found here
When replying in the Forum a file can be attached using Insert > Insert Image/Video/File, if the information is sensitive then use Secure File Upload
Thanks for replying. I do not have the help menu on reality modeling. Please see below screen shot.
Not sure about the matrix meanings. Sorry. What version should I have?
I have uploaded the file called BLABF OFFICE BIM.rar
Thanks for posting the files, I was able to Export and Import date changes. Please could I ask you to raise a Service Request and let me know the number so we can investigate why this is not working for you.
https://communities.bentley.com/communities/other_communities/sign-in_assistance_and_web_services/w/wiki/47172/how-to-create-a-new-service-request-online
Following some further testing I have now been able to get the same message in the Message Center "Cannot import item type instance". In my case it was an error on my part in that I modified the date to a none existing date in Excel.
Originally the 'On site Date' attribute was
I changed it to
Obviously there is no 15 Month …. once corrected I was able to import successfully.
Perhaps you could check the date format in Excel.
I have check and realized that the problem was the format. Now everything is fine. Thanks a lot.
You are a star.