MicroStation CONNECT Reporting with connection to Look up tables

Are you using plain old MicroStation CONNECT, or an application such as AECOSim?

Unknown said:

I have a catalog #

Please clarify, in the context of MicroStation, what you mean by 'have a catalog #'. 

Unknown said:

I want to populate additional columns

Additional columns in what?

Unknown said:

I to populate additional columns with look up tables

Where/what are those look up tables?

I am just using plain old MicroStation CONNECT version 10.03.00.30.
We have a Traffic Sign Face catalog, based on the catalog # I would like to harvest Height, Width, Material, Background color, text and symbol color of each Sign Face I have in a dgn. I have an Item Type that has a Property Definition for Catalog Number I am using in my report definition. The look up tables would be external, I am thinking Excel, Access or a database.

Unknown said:

I have an Item Type that has a Property Definition for Catalog Numbe

Excellent innovatory use of Item Types!  So you've assigned Item data to various signs in your DGN model?  If so, you're also able to create a report of those data.

I don't think that there is currently a way to merge report data with data stored externally to MicroStation.  You can export a MicroStation report to Excel, and perform further work from there.  Where do you want to see the merged data: in MicroStation, in Excel or in a DB table?

We are trying to work out a solution for CAD to GIS and GIS to CAD for Asset Management. We need to easily assign item types to our MicroStation elements and create a report and then export the data out to be consumed by a GIS system.

Bentley Map has a join capability that would let you join to an external database or spreadsheet. You could then export the data to SHP, including the joined data for import into GIS. Which I guess is Esri?