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:
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.
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!
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 !!
Excellent - can you please 'Verify Answer' so that the thread is 'closed'. Thanks.
Answer Verified By: Santiago Martinez Pardo