Failed dmsconvert message may be misleading !

     To make use if the AutoCAD Civil 3D 2013 Advanced ProjectWise integration features, you must install the ProjectWise V8i Select Series 4 Integration Module for AutoCAD Civil 3D 2013. In the ProjectWise SS4 first versions, there is Advance Integration for AutoCAD Civil 3D features that need a Server side procedure. There is a dmsconvert procedure where you need to add the AutoCAD Civil 3D Program Association, and update mime types.

     The full procedure is outlined in the ProjectWise V8i (SELECTseries 4) Integration Module for AutoCAD Civil 3D ReadMe.

      Part of the procedure (dmsconvert) results in a misleading message at the end of the process.

      On the ProjectWise Integration Server computer, open a command prompt and navigate to the …\ProjectWise\bin  directory. Then run the DMSCONV.EXE utility using the following syntax:

dmsconv.exe -d ODBCDataSourceName -u DatabaseUserName -p Password -appfile “Full_Path_To\

Civil3D.appinfo.xml”

       The dmsconvert does a scan of the database and looks for any Null mime entries, and most likely will find “none” which means it was successful !  However, the dmsconvert logs will return something like the sample below:

    INFO  pwise.database - Statement returned 0 bytes in 0 rows in 0.0333 seconds

    DEBUG dmsconv - resetting '<failed>' MIME type entries to NULL

    INFO  pwise.database - Executing statement 'update dms_doc set o_mimetype=NULL where o_mimetype = N'<failed>''

    INFO  pwise.database - Statement executed in 0.0534 seconds, -1 rows affected

    INFO  dmsconv - 0 '<failed>' MIME entries were reset

       NOTE: The word “Failed” should be ignored here – the wording is misleading – Please read this just

as  “0 MIME entries were reset” which is good, and you should go about testing your AutoCAD Civil 3D Data Shortcuts now !