Click here to Skip to main content
15,867,568 members
Articles / Programming Languages / C#

Merging SAP PS with Microsoft Project

Rate me:
Please Sign up or sign in to vote.
4.83/5 (5 votes)
6 Feb 2011CPOL2 min read 32.1K   482   12   1
Installation instructions for the CodeProject “Merging SAP PS with Microsoft Project”

Prerequisites

  • Microsoft Project Professional 2007 Client
  • Microsoft Visual Studio 2008

Step by Step Installation Instructions

  1. Unzip the “Merging SAP PS with Microsoft Project.zip” file to a working directory. This creates the “Projects” directory and sub folders listed below:

    Image 1

  2. Run Microsoft Visual Studio 2008 and open D:\Projects\ProjectAddIn2\ProjectAddIn2.sln.
  3. In the ProjectAddIn2 -> Properties -> Settings page, modify the settings to match your configuration:

    Image 2

  4. Make sure that the solution reference to CSAPData points to: D:\Projects\CSAPData\bin\Debug\CSAPData.dll.
  5. Compile the project and run it.
  6. A merged working copy of the selected SAP Project is saved to the “TestDir” listed above as a Microsoft Project .mpp file.
  7. The SAPProject.mpt template file in the TestDir folder has our global constructs.
  8. To recompile the CSAPData.dll, you must open the project in Microsoft Visual Studio .NET 2003. There is a reference article listed in the “CodeProject Merging SAP PS with Microsoft Project” document detailing how to do this.

Please feel free to send any questions or pointers to PBremner@bak.rr.com or go to www.VisualSAP.net and use the contact option (top center).

Sample project (which you don't have in your SAP system):

Image 3

Alternative SAP Connection string:

C#
String sConn = "CLIENT=" + Properties.Settings.Default.Client +
               " USER=" + Properties.Settings.Default.User +
               " PASSWD=" + Properties.Settings.Default.Password +
               " LANG=" + Properties.Settings.Default.Lang +
               " ASHOST=" + Properties.Settings.Default.ASHOST +
               " SYSNR=" + Properties.Settings.Default.SYSNR;

Image 4

Running the Applet

This project updates or inserts a new Network-Activity (MSP Task) to/from SAP<–> Microsoft Project.

  1. From Microsoft Visual Studio, run the project. You should get the following Microsoft Project screen. The status bar tells us the “SAP Addin loaded successfully”.

    Image 5

  2. Click on the “GetSAPProject” button. This will log in to your SAP system and retrieve a list of available SAP projects. Select a project.
  3. If the selected project (e.g. 7004) exists as an MSP .mpp file in the TestDir, the SAP Project and the MSP .mpp file are merged together.

    Image 6

  4. Let's insert a new Activity task and set the system to just move our new activity/task from MSP to SAP. We set the “SAP Object” field to “No” for all tasks except our new task. On task 17, we populate the:
    SAP Object     = "Yes"     , our control field
    Object Type    = "Activity"    , our control field
    WBS#       = "7004.001"      , SAP field
    Network        = "000000903899"  , SAP field
    Activity       = "0031"          , we create, must be unique in SAP
    
  5. Click on the “Save to SAP” button. Status bar says “Project saved to SAP successfully.

    Image 7

If you have any questions, email me at PBremner@bak.rr.com.

Thanks,
Phil

History

  • 3rd November, 2009: Initial version

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Unknown
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
QuestionThisAddIn constructor error when compiling…? Pin
Mohammed Shaneeb30-May-13 1:37
Mohammed Shaneeb30-May-13 1:37 
ProjectAddIn2.ThisAddIn' does not contain a constructor that takes 0 arguments

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.