Microsoft Project Customizable to link to Geospatial Database? RRS feed

  • Question

  • I haven't used Microsoft Project yet.  Currently we're surveying what's on the market to meet our needs.  Does anyone know if Project is customizable to either link to a geodatabase (spatial representation of action at a geographical location) or has a built in geographical interface?

    Saturday, December 1, 2012 4:11 PM


All replies

  • Out of the box there is no connection, However, Project Client has the VBA macro language which can talk to just about any database. Project Server has a PSI interface that allows connectivity to Project Server data.

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    • Marked as answer by jennnnnnnn Sunday, December 2, 2012 5:24 PM
    Saturday, December 1, 2012 9:45 PM
  • Agree with Rod.  It kind of depends on what you're trying to do.
    If you're looking to do something like linear scheduling, TILOS makes a nice
    add on to MS Project to enable that - and I am sure there are others.
    If you're just looking to pull progress into geographic representations,
    that could be handled with some custom fields and an export mechanism - or
    in 2013, using some OOTB Excel reporting such as PowerView.  Visio can also
    support a number of use cases.

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Sunday, December 2, 2012 8:10 PM
  • Yes, we're looking to pull progress but also ensure every expenditure is tied to actions for a large landscape-level restoration project where managers can view the progress and people working on the project can access for map generation. The only thing I'm thinking about now is the learning curve time for the program to do what we need.  Thanks so much for your feedback!  Thoughts on that?
    Monday, December 3, 2012 12:56 AM
  • Here's some information on a Visio based approach...http://blogs.catapultsystems.com/epm/archive/2010/04/29/optimizing-drilling-schedules-with-microsoft-project-2010-part-1-–-setting-the-stage.aspx

    ....and in Excel 2013, it's a lot easier to do geospatial as it will basically translate the data into Bing maps and use the Bing search engine to map the data to a location....i.e. you can simply enter "Downtown Boston stadium" instead of an actual series of coordinates.  Here's a rough overview:


    That being said, it sounds like an export to Visio is probably the way to go.

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

    Monday, December 3, 2012 2:36 AM
  • I hear what you're saying and I think you may be right that Bing maps may work for some overhead (people/budget managers) on the project that doesn't know GIS or RS software, but the data needs to feed into other software (remote sensing) so we can monitor and quanitify change through time with other ancillary data.  I'll check out the details w/the links you sent and provide thoughts shortly.  Thanks!
    Monday, December 3, 2012 3:36 AM
  • So two things-Project Server isn't an option for us (w/out going into too much detail).  Also, points (spatial) are interesting, but polys will be more efficient for us in some instances since we need to feed other reporting systems w/this format and we could use it in these other programs I was mentioning above. We could just keep them seperate (for now) and take the tables from project and relate them back in a geodatabase, that way we'd have all the pieces together at the end later.  Thanks so much for all of your feedback! 

    If you are following what I'm thinking and know of another route which can keep all the 'pieces' together, please do tell...I'm all ears.

    Monday, December 3, 2012 3:55 AM