Item Typed elements from Excel: bulk import?

This seems simple, but it's kicking my butt:

I have a spread sheet with x,y,z and some attributes.  I would like to add a graphic for each row at the specified x,y,z, with the attributes.

Item Types seems like it would be easy, but I don't know how to read a column and assign it to the graphic's Item.

Is there a command line syntax?   Is there an import interface (Text Import Wizard?)

I use OpenRoads Designer but am having trouble with those tools as well (ModelBuilder to a utility with User Data Extensions; Survey Import has some limitations and some backend setup (code to Featuer Def).

Thanks for any help,

-jeff

Parents
  • What is the exact version no. (e.g. v10.x.y.z) of MicroStation that you are using? Use key-in VERSION to see the version no. in the MicroStation Message Center, or Help→About MicroStation in the backstage.

    See this blog that shows you how to obtain MicroStation's version number.

    I have a spread sheet with x,y,z and some attributes.  I would like to add a graphic for each row at the specified x,y,z

    The Import Coordinates tool is used to import coordinates from an ASCII text file and place them as points, text, or cells.

    There is no option to import from Excel; you must write a CSV file from your Excel worksheet.

    I don't know how to read a column and assign it to the graphic's Item

    There is a tool to Import Item Type Instances: The item type instances get imported from Excel files.

     
    Regards, Jon Summers
    LA Solutions

  • Thanks, Jon.  v10.10.21.04.

    Example input:

    X, Y, Z, trackable info 1, trackable info 2, trackable info 3.

    This seems like a two step input and they're unrelated.

    1. I can get cells at x, y, z.
    2. Import Item Type Instances assigns the info via an Element ID. 

    (here's the Export Instance file format (I don't see a discussion of the required Import file format, so i assume this is my only option):

    ElementID, trackable info 1, etc.

    I think my understand of how it should work and how it actually works are very different.

    Here's how I think it should work:

    Define an Item Type Definition that can store the source data fields that I want to store.

    Import the source file mapping source columns to x,y,z positions and to the Item Types.  Pretty much like every Text Import Wizard or Data Mapper anywhere, but instead of a destination spreadsheet row, a graphic is created and the information populated.

    It seems that there is a two step process: creating dumb graphics and somehow mapping data rows to the correct graphic.

    Thanks for your reply.  I guess I'll see if going farther down the video rabbit hole will clarify my understanding.

  • Wouldn't FlexiTable be able do this?

    Thanks for your confidence, Lorys!

    FlexiTable V8i could not do this because Item Types don't exist in that generation of MicroStation.

    I can see how FlexiTable CONNECT Edition might be easily extended to populate a DGN model with elements tagged with Item data.  I haven't been overwhelmed with requests for that functionality.

     
    Regards, Jon Summers
    LA Solutions

  • ok New track this is how  we used to do it  in good old XM days .. thats how long ago I needed to do bulk import from survey  where  they only had point cells and I want to replace them with our company  style real cells at readable scale no good having a bollard in the middle of my  road design  that nobody can see from the survey file represented as a tiny dot or point cell.

    Like you already alluded to  if in the csv file  you were to define a cell name in the C column for each graphic needed then the  xyz import could use  xyzC where c is the cell name.

    and  provided the cell library was active contained the named cell(s) it would place those  cells at the coordinates in one run of the mdl and CSV file.. but if you want  it to have  specific  Business meta data like used in Items .. you would need to do as Jon suggests.. if there are only few differences between the items  you could create specific cells that have different names and  add information to these .... well that how I would do a one off job  that I already had cells for and  not have to build items.. but it is pretty old school way of getting a result and  not easy to do reports like you can with Items.

    Maybe  via a GIS package  you can add those item attributes via a table and  export out as shape file and  then import back into microstation and the special  attributes would be  retained...

    Jeff could you  paste a picture of what you actually want stuff to look like  graphically at least..  and  how often do you need to do this is it  a one  off or  once in a long while or regular occurance

    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 

  • Not sure, but you also could try Import Points?

    3) Ability to automatically create Item Types from the input data

    In any case the source code is included...

    Answer Verified By: Jeff Martin 

  • Hi Lorys,

    I don't care what it looks like.  Any cell would do.  I was able to get OpenRoads Utilities User Data Extensions to build the data structure that I wanted and ModelBuilder to import the data properly.  For Civil, there is a lot of talk about Item Types but not a peep about how to do Bulk Import of data to them.  It just seems odd that such a core functionality is not mentioned.   The emphasis is common data being applied to all elements with a particular Item Type, and any varying info to be typed in manually (ack!).  It's as if Bentley has a different technology they prefer us to use.  I would mind knowing what that is.  Kinda wish they'd read the Communities.  Jon's macro seems to fit the bill.

Reply Children
No Data