Hi. Please I would like to know how to structure the data of a spreadsheet (xslx) to import the data to the OpenRoads item type section.
In this case I have entered them manually:
excell:
OpenRoads:
but I would like to automate it ...
I attach the spreadsheet and my dgnlib. Thank you!7652.Features_Annotations_Levels_Elem Temp Metric.dgnlib3187.GENERIC_ACAT_20200110.xlsx
Have a look at Asset Manager - while this is a Technology Preview at the moment, it may be what you are looking for. One link is given below.
http://bentleyuser.dk/sites/default/files/files/f13_-_conveying_asset_management_with_openroads_designer.pdf
Thanks Mark for the information but I still don't know how to import the item types. Please is there a well structured xlsx spreadsheet to import directly? for you to use as a template. Thank you!
There is the Import/Export button - I have not used it, so my suggestion would be to export your Item Types to Excel to see what format it uses.
The attached is what I got when I exported one library (Sample) with one ItemType (Ex01) - the Item Type had one attribute of each type i.e. Interger, number etc.
SampleExport.xlsx
thanks for the suggestion but i have already done it but i get an error when i try to import even the same exported sheet:
I have attached the sheet that I exported first and then tried to import. Thank you
ELEMENTOS DE LA CARRETERA.xlsx
Your spreadsheet is not the same format as mine. How did you export your data, and what version of ORD are you using?
Hello Mark.
this is my version of openroads:
To export I'm going to a dgn, I'm going to link items, activate the ones I want to associate and then export:
then he associated them to an element:
With the element selected I go to the export section:
this is the result file:
I have done tests with this file, I have replaced the data with others to import different ones. And I have even tried to import the same xslx with the same data but I get error:
thanks for everything Mark! Keep investigating!
I did not select anything - I exported the library using the right icon (you have selected the left icon). I want the general Item Type layout, not a specific element.
ok Mark, I'll do it as you say and then I'll explain how the experience has been. Thank you!
Got Mark !!
thank you!!