1 2 Previous Next 17 Replies Latest reply on Sep 25, 2014 9:05 AM by Artur Tkaczyk

    AO and Project Server Integration - QueueCreateProject error

    Artur Tkaczyk

      Hello

      Dose any one did itegration with Microsoft project server?

      I have problem with part that suppose to create project: I'm issuing similar request:

      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"

      xmlns:proj="http://schemas.microsoft.com/office/project/server/webservices/Project/"

      xmlns:projds="http://schemas.microsoft.com/office/project/server/webservices/ProjectDataSet/">

         <soapenv:Header/>

         <soapenv:Body>

            <proj:QueueCreateProject>

               <proj:jobUid>77c2fcd2-93c6-4386-8089-847136dc259f</proj:jobUid>
               <proj:dataset>
                <projds:ProjectDataSet>
                      <projds:Project>
                              <projds:PROJ_UID>9087f21b-8503-4445-9a27-af08cba1c4d0</projds:PROJ_UID>
                              <projds:PROJ_NAME>Project Name</projds:PROJ_NAME>
                              <projds:PROJ_TYPE>0</projds:PROJ_TYPE>
                      </projds:Project>
              </projds:ProjectDataSet>
               </proj:dataset>
               <proj:validateOnly>false</proj:validateOnly>
            </proj:QueueCreateProject>
         </soapenv:Body>
      </soapenv:Envelope>

      Response is:

      <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

         <s:Body>

            <s:Fault>

               <faultcode>s:Server</faultcode>

               <faultstring xml:lang="en-US">ProjectServerError(s) LastError=GeneralUnhandledException Instructions: Pass this into PSClientError constructor to access all error information</faultstring>

               <detail>

                  <errinfo>

                     <general>

                        <class name="An unhandled exception occurred in Microsoft.Office.Project.Server.BusinessLayer.Project.QueueCreateProject.">

                           <error id="42" name="GeneralUnhandledException" uid="9ccbf91c-9537-4988-adbd-35d6382aae56" Exception="System.Data.StrongTypingException: The value for column 'PROJ_TYPE' in table 'Project' is DBNull. ---> System.InvalidCastException: Specified cast is not valid.

         at Microsoft.Office.Project.Server.Schema.ProjectDataSet.ProjectRow.get_PROJ_TYPE()

         --- End of inner exception stack trace ---

         at Microsoft.Office.Project.Server.Schema.ProjectDataSet.ProjectRow.get_PROJ_TYPE()

         at Microsoft.Office.Project.Server.BusinessLayer.Project.FixupProjectType(ProjectDataSet projDS)

         at Microsoft.Office.Project.Server.BusinessLayer.Project.QueueCreateProject(Guid jobUid, ProjectDataSet dataset, Boolean validateOnly)

         at Microsoft.Office.Project.Server.Wcf.Implementation.ProjectImpl.QueueCreateProject(Guid jobUid, ProjectDataSet dataset, Boolean validateOnly)"/>

                        </class>

                     </general>

                  </errinfo>

               </detail>

            </s:Fault>

         </s:Body>

      </s:Envelope>

       

      Any ideas?

        • 1. Re: AO and Project Server Integration - QueueCreateProject error
          Aryan Anantwar

          Hi Artur,

           

          you are doing this using WebService, so no matter which application you are integrating.

          In response you can see the error:

          System.Data.StrongTypingException: The value for column 'PROJ_TYPE' in table 'Project' is DBNull. ---> System.InvalidCastException: Specified cast is not valid.


          The value you are passing to <projds:PROJ_TYPE>0</projds:PROJ_TYPE> is correct?

          are you able to test the same webservice & operation with same values through SOUPUI.


          HTH.


          Regards,

          Aryan Anantwar


          • 2. Re: AO and Project Server Integration - QueueCreateProject error
            Artur Tkaczyk

            Yes result is the same

             

            On Wednesday, September 3, 2014, Aryan Anantwar <forums@developer.bmc.com>

            • 3. Re: AO and Project Server Integration - QueueCreateProject error
              Aryan Anantwar

              Then get the valid values for the fields.

              test in SOUPUI first, after it is running ok in SOUPUI use same in BAO.

              • 4. Re: AO and Project Server Integration - QueueCreateProject error
                Richard De Vries

                I agree with Aryan; SOAPUI is your friend

                • 5. Re: AO and Project Server Integration - QueueCreateProject error
                  Artur Tkaczyk

                  Gents

                  I know SoapUI is my friend, unfortunately on two different environments I get the same result. So my question is did anybody manage to create such SOAP call and how the correct one looks like.

                   

                  Regards

                  Artur

                  • 6. Re: AO and Project Server Integration - QueueCreateProject error
                    Richard De Vries

                    I wish I could help you out here but I myself have not yet had the opportunity to try to integrate AO with Microsoft Project Server. Do you have an existing integration in your environment somewhere that works from which you can run a wireshark capture of sorts?

                     

                    Have you looked at Microsoft's Dev Center? I did a quick google and found this: http://msdn.microsoft.com/en-us/library/office/gg223766(v=office.15).aspx

                    1 of 1 people found this helpful
                    • 7. Re: AO and Project Server Integration - QueueCreateProject error
                      Artur Tkaczyk

                      I wish I had.

                      Basically I did was going step by step using MSDN, and in it there is specified that you have to pass PROJ_UID, PROJ_NAME and PROJ_TYPE via SOAP and you should get created project

                      • 8. Re: AO and Project Server Integration - QueueCreateProject error
                        Artur Tkaczyk

                        Hello all

                        I have made it. Later will post solution to the problem

                        • 9. Re: AO and Project Server Integration - QueueCreateProject error
                          Richard De Vries

                          Artuk, if you have an opportunity (and are allowed) to do so, please post your solution. It may be of value to anyone else trying to do something similar.

                           

                          Thank you.

                          • 10. Re: AO and Project Server Integration - QueueCreateProject error
                            Artur Tkaczyk

                            OK

                            The call looks like this:

                            <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" >

                            <soapenv:Header />

                            <soapenv:Body>

                            <QueueCreateProject xmlns="http://schemas.microsoft.com/office/project/server/webservices/Project/">

                            <jobUid> </jobUid>

                            <dataset>

                            Until now nothing unusual, but now:

                            <xs:schema attributeFormDefault="qualified" elementFormDefault="qualified" id="ProjectDataSet" targetNamespace="http://schemas.microsoft.com/office/project/server/webservices/ProjectDataSet/" xmlns="http://schemas.microsoft.com/office/project/server/webservices/ProjectDataSet/" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:mstns="http://schemas.microsoft.com/office/project/server/webservices/ProjectDataSet/" xmlns:xs="http://www.w3.org/2001/XMLSchema">

                               <xs:element msdata:IsDataSet="true" msdata:UseCurrentLocale="true" name="ProjectDataSet">

                                  <xs:complexType>

                                     <xs:choice maxOccurs="unbounded" minOccurs="0">

                                        <xs:element name="Project">

                                           <xs:complexType>

                                              <xs:sequence>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="PROJ_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_TYPE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_PROP_AUTHOR" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="CAL_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="CAL_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_PROP_CATEGORY" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_PROP_COMPANY" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_PROP_KEYWORDS" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_PROP_MANAGER" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_PROP_SUBJECT" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_PROP_TITLE" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_CALC_ACT_COSTS" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_CRITICAL_SLACK_LIMIT" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_CURRENCY_DIGITS" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_CURRENCY_POSITION" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_CURRENCY_SYMBOL" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_CURRENCY_CODE" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_NEW_TASKS_ARE_EFFORT_DRIVEN" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_INFO_CURRENT_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_OPT_DEF_FINISH_TIME" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_DEF_FIX_COST_ACCRUAL" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_DEF_OVT_RATE" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_DEF_STD_RATE" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_OPT_DEF_START_TIME" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_DEF_TASK_TYPE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="WPROJ_TRACKING_METHOD" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_DUR_ENTRY_FMT" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_INFO_FINISH_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_HONOR_CONSTRAINTS" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_MULT_CRITICAL_PATHS" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_INFO_SCHED_FROM" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_SPLIT_IN_PROGRESS" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_SPREAD_ACT_COSTS" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_SPREAD_PCT_COMP" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_INFO_START_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="PROJ_INFO_STATUS_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_TASK_UPDATES_RES" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_WORK_ENTRY_FMT" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_NEW_TASK_EST" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_PROTECTED_ACTUALS_SYNCH" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ProjectOptionDefaultOvertimeRateFormat" type="xs:short"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ProjectOptionDefaultStandardRateFormat" type="xs:short"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_FY_START_MONTH" type="xs:short"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_FY_USE_START_YR" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_MINUTES_PER_DAY" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_MINUTES_PER_WEEK" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_DAYS_PER_MONTH" type="xs:short"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_MOVE_ACTUAL_IF_LATER" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_MOVE_ACTUAL_TO_STATUS" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_MOVE_REMAINING_IF_EARLIER" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_MOVE_REMAINING_TO_STATUS" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_SHOW_EST_DUR" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_WEEK_START_DAY" type="xs:short"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="WPROJ_ISSUE_LIST_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="WPROJ_RISK_LIST_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="WPROJ_STS_SUBWEB_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="WSTS_SERVER_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="ProjectOwnerID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="PROJ_CHECKOUTBY" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_CHECKOUTDATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="PROJ_SESSION_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_SESSION_DESCRIPTION" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_STALE_FLAGS" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="WPROJ_DESCRIPTION" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="WPROJ_LAST_PUB" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_LAST_SAVED" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="CREATED_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="ENTERPRISE_PROJECT_TYPE_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ENTERPRISE_PROJECT_TYPE_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="WORKFLOW_INSTANCE_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="PHASE_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PHASE_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="STAGE_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="STAGE_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="SKIP_TO_STAGE_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="OPTIMIZER_SOLUTION_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="PLANNER_SOLUTION_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="OPTIMIZER_DECISION" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PLANNER_DECISION" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PLANNER_START_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PLANNER_END_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="OPTIMIZER_FORCE_ALIAS_LT_VALUE_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="PLANNER_FORCE_ALIAS_LT_VALUE_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_NEW_TASKS_ARE_MANUAL" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_WINPROJ_VERSION_NUMBER" type="xs:decimal"/>

                                              </xs:sequence>

                                           </xs:complexType>

                                        </xs:element>

                                        <xs:element name="Task">

                                           <xs:complexType>

                                              <xs:sequence>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="PROJ_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="TASK_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="TASK_PARENT_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="TASK_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_ID" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_IS_MILESTONE" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_IS_SUMMARY" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TASK_IS_MARKED" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_IGNORES_RES_CAL" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TASK_IS_EFFORT_DRIVEN" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_IS_CRITICAL" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_IS_EXTERNAL" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_IS_FROM_FINISH_SUBPROJ" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_IS_OVERALLOCATED" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_IS_RECURRING" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_IS_RECURRING_SUMMARY" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_IS_SUBPROJ" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_IS_READONLY_SUBPROJ" type="xs:boolean"/>

                                                 <xs:element default="false" name="TASK_LOCKDOWN_BY_MANAGER" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TASK_LEVELING_DELAY" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_LEVELING_DELAY_FMT" type="xs:short"/>

                                                 <xs:element minOccurs="0" name="TASK_LEVELING_CAN_SPLIT" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TASK_LEVELING_ADJUSTS_ASSN" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TASK_DUR_IS_EST" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TASK_DUR" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_DUR_FMT" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_DUR_VAR" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_EAC" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_VAC" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_ACT_DUR" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_REM_DUR" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_CONSTRAINT_TYPE" type="xs:short"/>

                                                 <xs:element minOccurs="0" name="TASK_CONSTRAINT_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="TASK_ACT_START" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="TASK_ACT_FINISH" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="TASK_PRIORITY" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_PCT_COMP" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_PCT_WORK_COMP" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_TYPE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_FIXED_COST_ACCRUAL" type="xs:short"/>

                                                 <xs:element minOccurs="0" name="TASK_DEADLINE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="TASK_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_OVT_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_REG_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="TASK_ACT_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_ACT_OVT_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="TASK_REM_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_REM_OVT_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="TASK_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_OVT_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="TASK_FIXED_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="TASK_ACT_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_ACT_OVT_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_REM_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_REM_OVT_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="TASK_PHY_PCT_COMP" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_EVMETHOD" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_OUTLINE_LEVEL" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_OUTLINE_NUM" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="TASK_CAL_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="TASK_START_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_START_VAR" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_FINISH_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_FINISH_VAR" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_RESUME_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_STOP_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_PRELEVELED_START" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_PRELEVELED_FINISH" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_EARLY_START" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_EARLY_FINISH" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_LATE_START" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_LATE_FINISH" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TB_START" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TB_FINISH" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TB_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TB_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TB_DUR" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TB_DUR_FMT" type="xs:short"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_BCWS" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_BCWP" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_ACWP" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_FREE_SLACK" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_TOTAL_SLACK" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_HAS_LINKED_FIELDS" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TASK_WBS" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="AddPosition" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="AddAfterTaskUID" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="DurationType" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="WOBJ_DOC_REF_CNT" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="WOBJ_ISSUE_REF_CNT" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="WOBJ_RISK_REF_CNT" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="WOBJ_OTHER_REF_CNT" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="CREATED_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="MOD_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_TYPE" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_OPT_CURRENCY_DIGITS" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_OPT_CURRENCY_POSITION" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_OPT_CURRENCY_SYMBOL" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="TASK_EXT_PROJ_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_BUDGET_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_IS_NULL" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_BUDGET_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_CONTACT" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_COST_VAR" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_CPI" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_CV" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TaskCVP" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_START_SLACK" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_FINISH_SLACK" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_HYPERLINK_FRIENDLY_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_HYPERLINK_ADDRESS" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_HYPERLINK_SUB_ADDRESS" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_IS_ROLLED_UP" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_NOTES" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_SPI" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_SV" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TaskSVP" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_TCPI" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_WORK_VAR" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_COMPLETE_THROUGH" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="TASK_IS_MANUAL" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TASK_IS_ACTIVE" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TASK_IS_DISPSUMMARY" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_SCHED_START" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_SCHED_FINISH" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="TASK_START_TXT" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="TASK_FINISH_TXT" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="TASK_SCHED_DUR" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_SCHED_DUR_FMT" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="TASK_DUR_TXT" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="StatusManager" type="xs:string"/>

                                              </xs:sequence>

                                           </xs:complexType>

                                        </xs:element>

                                        <xs:element name="ProjectResource">

                                           <xs:complexType>

                                              <xs:sequence>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="PROJ_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="RES_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="RES_AD_GUID" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="RES_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_ID" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="RES_INITIALS" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="RES_PHONETICS" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="RES_CODE" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="RES_GROUP" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="RES_HYPERLINK_ADDRESS" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="RES_HYPERLINK_FRIENDLY_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="RES_HYPERLINK_SUB_ADDRESS" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="RES_TYPE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="RES_BOOKING_TYPE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="RES_MATERIAL_LABEL" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="RES_STD_RATE" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="RES_STD_RATE_FMT" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_PEAK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_OVT_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="RES_OVT_RATE" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="RES_OVT_RATE_FMT" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="RES_COST_PER_USE" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_ACT_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_ACT_OVT_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_REM_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_REM_OVT_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_ACT_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_ACT_OVT_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_OVT_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_REM_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_REM_OVT_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_REG_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="RES_ACCRUE_AT" type="xs:short"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_AVAIL_FROM" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_AVAIL_TO" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="RES_MAX_UNITS" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_HAS_NOTES" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="WRES_ACCOUNT" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="WRES_EMAIL" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_ASSN_START" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_ASSN_FINISH" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_ACWP" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_BCWP" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_BCWS" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_PCT_WORK_COMPLETE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="RES_CAN_LEVEL" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_HAS_LINKED_FIELDS" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_IS_OVERALLOCATED" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_IS_ENTERPRISE_RESOURCE" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="RES_DEF_ASSN_OWNER" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ResourceIsBudget" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_BUDGET_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_BUDGET_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="RES_COST_CENTER" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_CURRENCY_DIGITS" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_CURRENCY_POSITION" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_CURRENCY_SYMBOL" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_NOTES" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_COST_VAR" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_CV" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ResourceIsGeneric" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_SV" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_VAC" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_WORK_VAR" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RB_BASE_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RB_BASE_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="MOD_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="CREATED_DATE" type="xs:dateTime"/>

                                              </xs:sequence>

                                           </xs:complexType>

                                        </xs:element>

                                        <xs:element name="Assignment">

                                           <xs:complexType>

                                              <xs:sequence>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="PROJ_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="TASK_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="ASSN_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="RES_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" name="ASSN_PARENT_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="ASSN_ACT_START" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" name="ASSN_ACT_FINISH" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_WORK_CONTOUR" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_DELAY" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_LEVELING_DELAY" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="ASSN_COST_RATE_TABLE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="ASSN_UNITS" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="ASSN_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="ASSN_ACT_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="ASSN_REG_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="ASSN_OVT_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="ASSN_REM_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="ASSN_ACT_OVT_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="ASSN_REM_OVT_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_START_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_FINISH_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="AB_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="AB_START" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="AB_FINISH" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="AB_COST_PER_USE" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="AB_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_RESUME_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_STOP_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_ENTSUMPROJID" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="ASSN_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="ASSN_ACT_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="ASSN_ACT_OVT_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_REM_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_REM_OVT_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_OVT_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="TASK_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="RES_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="ASSN_PCT_WORK_COMPLETE" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_ACWP" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_BCWP" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_BCWS" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="ASSN_BOOKING_TYPE" type="xs:short"/>

                                                 <xs:element minOccurs="0" name="ASSN_DEMAND_REQ" type="xs:unsignedByte"/>

                                                 <xs:element minOccurs="0" name="ASSN_MATERIAL_RATE_FMT" type="xs:short"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_DELAY_FMT" type="xs:short"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_START_VAR" type="xs:int"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_FINISH_VAR" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="ASSN_HAS_LINKED_FIELDS" type="xs:boolean"/>

                                                 <xs:element default="false" name="WASSN_LOCKDOWN_BY_MANAGER" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_IS_CONFIRMED" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_IS_PUBLISHED" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_IS_OVERALLOCATED" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="ASSN_RES_TYPE" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_RESPONSE_PENDING" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_UPDATE_NEEDED" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="RES_UID_OWNER" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="ASSN_BUDGET_COST" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="ASSN_BUDGET_WORK" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="PROJ_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_CURRENCY_DIGITS" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_CURRENCY_POSITION" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="PROJ_OPT_CURRENCY_SYMBOL" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_COST_VAR" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_CV" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_HYPERLINK_FRIENDLY_NAME" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_HYPERLINK_ADDRESS" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="AssignmentHyperlinkHref" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_NOTES" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_SV" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_VAC" type="xs:double"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ASSN_WORK_VAR" type="xs:double"/>

                                                 <xs:element minOccurs="0" name="RES_MATERIAL_LABEL" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="RES_BOOKING_TYPE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="RES_TYPE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="RES_GROUP" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="ResourceIsGeneric" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="MOD_DATE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="CREATED_DATE" type="xs:dateTime"/>

                                              </xs:sequence>

                                           </xs:complexType>

                                        </xs:element>

                                        <xs:element name="Dependency">

                                           <xs:complexType>

                                              <xs:sequence>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="LINK_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="PROJ_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="LINK_PRED_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="LINK_SUCC_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="LINK_TYPE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="LINK_LAG" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="LINK_LAG_FMT" type="xs:int"/>

                                              </xs:sequence>

                                           </xs:complexType>

                                        </xs:element>

                                        <xs:element name="ProjectCustomFields">

                                           <xs:complexType>

                                              <xs:sequence>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="CUSTOM_FIELD_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="PROJ_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="MD_PROP_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="MD_PROP_ID" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="FIELD_TYPE_ENUM" type="xs:unsignedByte"/>

                                                 <xs:element minOccurs="0" name="FLAG_VALUE" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TEXT_VALUE" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="DATE_VALUE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="CODE_VALUE" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="DUR_VALUE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="NUM_VALUE" type="xs:decimal"/>

                                                 <xs:element minOccurs="0" name="DUR_FMT" type="xs:unsignedByte"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="INDICATOR_VALUE" type="xs:int"/>

                                              </xs:sequence>

                                           </xs:complexType>

                                        </xs:element>

                                        <xs:element name="TaskCustomFields">

                                           <xs:complexType>

                                              <xs:sequence>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="CUSTOM_FIELD_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="PROJ_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="TASK_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="MD_PROP_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="MD_PROP_ID" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="FIELD_TYPE_ENUM" type="xs:unsignedByte"/>

                                                 <xs:element minOccurs="0" name="FLAG_VALUE" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TEXT_VALUE" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="DATE_VALUE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="CODE_VALUE" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="DUR_VALUE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="NUM_VALUE" type="xs:decimal"/>

                                                 <xs:element minOccurs="0" name="DUR_FMT" type="xs:unsignedByte"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="INDICATOR_VALUE" type="xs:int"/>

                                              </xs:sequence>

                                           </xs:complexType>

                                        </xs:element>

                                        <xs:element name="ProjectResourceCustomFields">

                                           <xs:complexType>

                                              <xs:sequence>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="CUSTOM_FIELD_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="PROJ_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="RES_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="MD_PROP_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="MD_PROP_ID" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="FIELD_TYPE_ENUM" type="xs:unsignedByte"/>

                                                 <xs:element minOccurs="0" name="FLAG_VALUE" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TEXT_VALUE" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="DATE_VALUE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="CODE_VALUE" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="DUR_VALUE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="NUM_VALUE" type="xs:decimal"/>

                                                 <xs:element minOccurs="0" name="DUR_FMT" type="xs:unsignedByte"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="INDICATOR_VALUE" type="xs:int"/>

                                              </xs:sequence>

                                           </xs:complexType>

                                        </xs:element>

                                        <xs:element name="AssignmentCustomFields">

                                           <xs:complexType>

                                              <xs:sequence>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="CUSTOM_FIELD_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="PROJ_UID" type="xs:string"/>

                                                 <xs:element msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="ASSN_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="MD_PROP_UID" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="MD_PROP_ID" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="FIELD_TYPE_ENUM" type="xs:unsignedByte"/>

                                                 <xs:element minOccurs="0" name="FLAG_VALUE" type="xs:boolean"/>

                                                 <xs:element minOccurs="0" name="TEXT_VALUE" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="DATE_VALUE" type="xs:dateTime"/>

                                                 <xs:element minOccurs="0" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="CODE_VALUE" type="xs:string"/>

                                                 <xs:element minOccurs="0" name="DUR_VALUE" type="xs:int"/>

                                                 <xs:element minOccurs="0" name="NUM_VALUE" type="xs:decimal"/>

                                                 <xs:element minOccurs="0" name="DUR_FMT" type="xs:unsignedByte"/>

                                                 <xs:element minOccurs="0" msdata:ReadOnly="true" name="INDICATOR_VALUE" type="xs:int"/>

                                              </xs:sequence>

                                           </xs:complexType>

                                        </xs:element>

                                     </xs:choice>

                                  </xs:complexType>

                                  <xs:unique msdata:PrimaryKey="true" name="ProjectKey">

                                     <xs:selector xpath=".//mstns:Project"/>

                                     <xs:field xpath="mstns:PROJ_UID"/>

                                  </xs:unique>

                                  <xs:unique msdata:PrimaryKey="true" name="TaskKey">

                                     <xs:selector xpath=".//mstns:Task"/>

                                     <xs:field xpath="mstns:TASK_UID"/>

                                     <xs:field xpath="mstns:PROJ_UID"/>

                                  </xs:unique>

                                  <xs:unique msdata:PrimaryKey="true" name="ResourceKey">

                                     <xs:selector xpath=".//mstns:ProjectResource"/>

                                     <xs:field xpath="mstns:RES_UID"/>

                                     <xs:field xpath="mstns:PROJ_UID"/>

                                  </xs:unique>

                                  <xs:unique msdata:PrimaryKey="true" name="AssignmentKey">

                                     <xs:selector xpath=".//mstns:Assignment"/>

                                     <xs:field xpath="mstns:ASSN_UID"/>

                                     <xs:field xpath="mstns:PROJ_UID"/>

                                  </xs:unique>

                                  <xs:unique msdata:PrimaryKey="true" name="DependencyKey">

                                     <xs:selector xpath=".//mstns:Dependency"/>

                                     <xs:field xpath="mstns:LINK_UID"/>

                                     <xs:field xpath="mstns:PROJ_UID"/>

                                  </xs:unique>

                                  <xs:unique msdata:PrimaryKey="true" name="ProjectCustomFieldsKey">

                                     <xs:selector xpath=".//mstns:ProjectCustomFields"/>

                                     <xs:field xpath="mstns:CUSTOM_FIELD_UID"/>

                                  </xs:unique>

                                  <xs:unique msdata:PrimaryKey="true" name="TaskCustomFieldsKey">

                                     <xs:selector xpath=".//mstns:TaskCustomFields"/>

                                     <xs:field xpath="mstns:CUSTOM_FIELD_UID"/>

                                  </xs:unique>

                                  <xs:unique msdata:PrimaryKey="true" name="ProjectResourceCustomFieldsKey">

                                     <xs:selector xpath=".//mstns:ProjectResourceCustomFields"/>

                                     <xs:field xpath="mstns:CUSTOM_FIELD_UID"/>

                                  </xs:unique>

                                  <xs:unique msdata:PrimaryKey="true" name="AssignmentCustomFieldsKey">

                                     <xs:selector xpath=".//mstns:AssignmentCustomFields"/>

                                     <xs:field xpath="mstns:CUSTOM_FIELD_UID"/>

                                  </xs:unique>

                               </xs:element>

                            </xs:schema>

                             

                            You have to pass whole schema for ProjectDataSet if you do not do this your call will not work, after this you have:

                            <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">

                            <ProjectDataSet xmlns="http://schemas.microsoft.com/office/project/server/webservices/ProjectDataSet/">

                            <Project diffgr:id="Project1" msdata:rowOrder="0" diffgr:hasChanges="inserted">

                            <PROJ_UID> </PROJ_UID>

                            <PROJ_NAME>Test3</PROJ_NAME>

                            <PROJ_TYPE>0</PROJ_TYPE>

                            </Project>

                            </ProjectDataSet>

                            </diffgr:diffgram>

                            </dataset>

                            <validateOnly>false</validateOnly>

                            </QueueCreateProject>

                            </soapenv:Body>

                            </soapenv:Envelope>

                             

                            Of course you have to generate UIDs for PROJ_UID element and JobUid. If you want to create tasks during project creation it is possible but you have to remember that

                            <Task diffgr:id="Project1" diffgr:hasChanges="inserted" msdata:rowOrder="0" > have to look like this maybe the numbers need to change because <Task diffgr:id="Project1" msdata:rowOrder="0" diffgr:hasChanges="inserted"> will not work (no project no tasks) also there is possibility to fill custom fields but you have to know UIDs for those fields ID and also if the value is predefined in lookup table UID of the value.

                             

                            Updates is a story too. You can not pass to Project Server plan id, field id with new value, you have to pass whole project with new value and old value on the end ... aaa I forget you have to also check-out project and after update check-in

                             

                            And to end this story, non of those is described in MS documentation.

                             

                            Thanks

                            Artur

                             

                            BTW I will need help with XSLT transformations to change one value in the project xml, any volunteer?

                             

                             

                             

                             

                            Note: updated by Richard de Vries to fix formatting issue.

                            • 11. Re: AO and Project Server Integration - QueueCreateProject error
                              Richard De Vries

                              Thanks for sharing. I took the liberty of updating the xml formatting issue in your post since it appeared as one big blob.

                               

                              I'd be more than happy to have an attempt at helping you with your transformation issue. Let me know what you need.

                               

                              Cheers,

                               

                                 R

                              • 12. Re: AO and Project Server Integration - QueueCreateProject error
                                Artur Tkaczyk

                                Thx

                                In the <xs:schema> ... </xs:schema> it is just one looooooong line ...

                                 

                                With XSLT it is a problem because you never know how the project look like and you have to change value of the one xml tag, actually remove it from the soap response and add on the end like this:

                                 

                                <diffgr:before>

                                <ProjectCustomFields diffgr:id="ProjectCustomFields1" msdata:rowOrder="0" xmlns="http://schemas.microsoft.com/office/project/server/webservices/ProjectDataSet/">

                                <CUSTOM_FIELD_UID>27f1fc6b-fcab-4f97-bfc9-a53610c151e3</CUSTOM_FIELD_UID>

                                <PROJ_UID>91062336-1a3d-490c-a859-7f847eb25d7e</PROJ_UID>

                                <MD_PROP_UID>d21cdf80-429d-4b14-bd80-01df677cf99c</MD_PROP_UID>

                                <MD_PROP_ID>190873753</MD_PROP_ID>

                                <FIELD_TYPE_ENUM>21</FIELD_TYPE_ENUM>

                                <TEXT_VALUE>UPDATED VALUE</TEXT_VALUE>

                                </ProjectCustomFields>

                                </diffgr:before>

                                 

                                I know the

                                <MD_PROP_UID>d21cdf80-429d-4b14-bd80-01df677cf99c</MD_PROP_UID>

                                <MD_PROP_ID>190873753</MD_PROP_ID>

                                up front, the rest is hidden.

                                 

                                How can I attach file to the discussion to put whole soap call ?

                                • 13. Re: AO and Project Server Integration - QueueCreateProject error
                                  Richard De Vries

                                  To attach, click on "advanced editor" in the upper right corner of your reply, then "attach" in the bottom right next to @ Mention.

                                  • 14. Re: Re: AO and Project Server Integration - QueueCreateProject error
                                    Artur Tkaczyk

                                    Thx

                                     

                                    Soap call need to look similar to the attached one (deletesoap.xml) . It is starting with read project which gives you the whole project

                                    I just need to remove custom field from project structure

                                     

                                            <ProjectCustomFields xmlns="http://schemas.microsoft.com/office/project/server/webservices/ProjectDataSet/" diffgr:id="ProjectCustomFields1" msdata:rowOrder="0">
                                              <CUSTOM_FIELD_UID>27f1fc6b-fcab-4f97-bfc9-a53610c151e3</CUSTOM_FIELD_UID>
                                              <PROJ_UID>91062336-1a3d-490c-a859-7f847eb25d7e</PROJ_UID>
                                              <MD_PROP_UID>d21cdf80-429d-4b14-bd80-01df677cf99c</MD_PROP_UID>
                                              <MD_PROP_ID>190873753</MD_PROP_ID>
                                              <FIELD_TYPE_ENUM>21</FIELD_TYPE_ENUM>
                                              <TEXT_VALUE>UPDATED VALUE</TEXT_VALUE>
                                            </ProjectCustomFields>

                                     

                                    and create such call. The read project response looks like update call but without <diffgr:before> tag

                                    Cheers

                                    1 2 Previous Next