<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi Mark,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I earlier developed an AutoCAD Map VBA application
that can import data from AcadMap into PostGIS using ODBC/ADO</FONT></DIV>
<DIV><FONT face=Arial size=2>The application reads a configuration file, which
can be customized via GUI. This lets you set up the mapping between AutoCAD
layers and most AutoCAD specific graphical attributes to PostgreSQL/PostGIS
tables/columns. You can also configure mapping of object data.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>As an FME user I figured I soon wont need this
anymore since FME now supports PostGIS, but FME doesn't yet support AutoCAD Map
Object Data, ufortunately.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If you're interested I can send you a snapshot of
the GUI and also the .bas files for you to try out. It was developed for
PostgreSQL 7.2.x, but shouldn't require much work, if any, to work with
7.3</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have also developed a check-in / check-out VBA
application in AutoCAD Map. I was planning to do this as a true/live editing
client to PostGIS, but the event handlers in AutoCAD Map were just too unstable
so I gave up. Instead my application can check out an user specified area
(either by box, or other means) and then store all identifiers of checked out
objects in a separate table. During check-in the data is compared to that
table, and any new objects, deleted objects, updated objects, are detected. New
and deleted objects were easy, but we had to compromise for the updated objects,
telling the operators to insert a code to indicate update in an AutoCAD object
data field.</FONT></DIV>
<DIV><FONT face=Arial size=2>This application is not that generic, and it's
based on the now obsolete RDO. But if people are interested I might spend a day
or two to shine it up and try to make it more reusable.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>regards,</FONT></DIV>
<DIV><FONT face=Arial size=2> erik brenn</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>