Search the Community

This may be a bit complex, so please bear with me. We are a water utility and have thousands of detail drawings of service taps and hydrant connections (maybe 11,000 total). These are in the old Microstation J format. Each drawing is divided into a top half and bottom half. The bottom half of the drawing is the actual drawing portion. The top half of the drawing is text that comes out of an Old Oracle database, into Microsoft Word 2000 through mail merge then is copied and pasted into the top portion of the card. Newer drawings done like this and opened in AutoCAD have the top portion identified as an OLE object (embedded object), while the older drawings just look like a drawing in the top. I'm looking to update the system to ArcGIS and AutoCAD. The data will be moved to a Microsoft Access database (probably later SQL Server), and I want to convert all the old Microstation drawings into an AutoCAD format. ArcGIS will provide the basemap and be linked to the database, with clickable hyperlinks to open the AutoCAD drawings. I would like to be able to keep the bottom drawing half while changing the top half of each drawing to reflect updated data in the database. If this can be automatically updated, that would be awesome. So, I'm looking for a couple things: One is the best program to automatically bulk convert the drawings from Microstation J to AutoCAD (I have 2011). Also, I'm looking for a method to display the text from the database in the top portion of the card using either mail merge with AutoCAD or some automatic method of pulling the info out of the database. Can I just copy-paste this info into AutoCAD as we did with Microstation or is there a better way? Thanks, Nick McNamara GIS Coordinator South Norwalk Electric & Water Norwalk, CT