Loading ...
Sorry, an error occurred while loading the content.
 

direction in learning...

Expand Messages
  • keith_d_savage
    Hi! So glad to see that this group exists...I ve been given a challenge at work that involves processing the contents of an xml file and conditionally loading
    Message 1 of 5 , May 3 9:00 AM
      Hi!

      So glad to see that this group exists...I've been given a challenge
      at work that involves processing the contents of an xml file and
      conditionally loading it into a SQL Server database. "No problem" I
      first thought, having worked some with xml files beofre.

      Turns out that this xml file will come to us via web serice, which I
      grasp the concept of but have never actually used. I was also given
      a sample of the XML file and a file with a ".wsdl" extension. I was
      told I'll need that, but was not told what for. Anyway, the XML file
      was not at all what I expected and I am not sure how to handle all of
      this. If someone could be so kind as to give me some direction, or
      even recommend some specific "cut to the chase" literature or
      resources on how to get this done, I would REALLY appreciate it!
      Please respond here or to my email address of
      keith_d_savage@....

      Below if a sample of the XML file.

      Keith

      <?xml version="1.0" encoding="utf-8" ?>
      <DataSet xmlns="http://apps.imercer.com/Mercer.Web.GetJobsObject/">
      <xs:schema id="JobsObjectData" xmlns=""
      xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-
      microsoft-com:xml-msdata">
      <xs:element name="JobsObjectData" msdata:IsDataSet="true">
      <xs:complexType>
      <xs:choice maxOccurs="unbounded">
      <xs:element name="Table">
      <xs:complexType>
      <xs:sequence>
      <xs:element name="SET_ID" type="xs:string" minOccurs="0" />
      <xs:element name="COMPANY_GROUP_CODE" type="xs:string"
      minOccurs="0" />
      <xs:element name="COMPANY_GROUP_NAME" type="xs:string"
      minOccurs="0" />
      <xs:element name="JOBCODE" type="xs:string" minOccurs="0" />
      <xs:element name="JOBTITLE" type="xs:string" minOccurs="0" />
      <xs:element name="CAPRI_CODE" type="xs:string" minOccurs="0" />
      <xs:element name="CAPRI_NAME" type="xs:string" minOccurs="0" />
      <xs:element name="SOC_CODE" type="xs:string" minOccurs="0" />
      <xs:element name="SOC_NAME" type="xs:string" minOccurs="0" />
      <xs:element name="JOB_GROUP" type="xs:string" minOccurs="0" />
      <xs:element name="JOB_GROUP_DESC" type="xs:string" minOccurs="0" />
      <xs:element name="JOB_FAMILY_CODE" type="xs:string"
      minOccurs="0" />
      <xs:element name="JOB_FAMILY_DESCRIPTION" type="xs:string"
      minOccurs="0" />
      <xs:element name="JOB_FAMILY_PURPOSE" type="xs:string"
      minOccurs="0" />
      <xs:element name="FLSA_CODE" type="xs:string" minOccurs="0" />
      <xs:element name="FLSA_DESCRIPTION" type="xs:string"
      minOccurs="0" />
      <xs:element name="CAREER_LEVEL" type="xs:string" minOccurs="0" />
      <xs:element name="JOB_FAMILY_RESPONSIBILITE" type="xs:string"
      minOccurs="0" />
      <xs:element name="KEY_RESPONSIBILITES" type="xs:string"
      minOccurs="0" />
      <xs:element name="EDUCATION" type="xs:string" minOccurs="0" />
      <xs:element name="KNOWLEDGE" type="xs:string" minOccurs="0" />
      <xs:element name="EXPERIENCE" type="xs:string" minOccurs="0" />
      <xs:element name="DIRECTION_OF_OTHERS" type="xs:string"
      minOccurs="0" />
      <xs:element name="KEY_WORKING_RELATIONSHIPS" type="xs:string"
      minOccurs="0" />
      <xs:element name="SOC_SPECIFIC_RESPONSIBILI" type="xs:string"
      minOccurs="0" />
      <xs:element name="GRADE_LABEL" type="xs:string" minOccurs="0" />
      <xs:element name="EEO_CATEGORY" type="xs:string" minOccurs="0" />
      <xs:element name="EEO_GROUP" type="xs:string" minOccurs="0" />
      <xs:element name="SOC_COMPETENCY_URL" type="xs:string"
      minOccurs="0" />
      <xs:element name="SOC_SALARY_STRUCTURE_URL" type="xs:string"
      minOccurs="0" />
      </xs:sequence>
      </xs:complexType>
      </xs:element>
      </xs:choice>
      </xs:complexType>
      </xs:element>
      </xs:schema>
      <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
      xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
      <JobsObjectData xmlns="">
      <Table diffgr:id="Table1" msdata:rowOrder="0">
      <SET_ID>050US</SET_ID>
      <COMPANY_GROUP_CODE>SMS</COMPANY_GROUP_CODE>
      <COMPANY_GROUP_NAME>SMS Group of Companies</COMPANY_GROUP_NAME>
      <JOBCODE>AF105</JOBCODE>
      <JOBTITLE>National Account Manager 2</JOBTITLE>
      <CAPRI_CODE>100215</CAPRI_CODE>
      <CAPRI_NAME>Business Development Specialist</CAPRI_NAME>
      <JOB_GROUP>04</JOB_GROUP>
      <JOB_GROUP_DESC>Sales</JOB_GROUP_DESC>
      <JOB_FAMILY_CODE>1055</JOB_FAMILY_CODE>
      <JOB_FAMILY_DESCRIPTION>Business Development
      Specialist</JOB_FAMILY_DESCRIPTION>
      <JOB_FAMILY_PURPOSE>Develops strategic business plans, marketing
      programs, and partnerships to support sales in designated market
      segments.</JOB_FAMILY_PURPOSE>
      <FLSA_CODE>E</FLSA_CODE>
      <FLSA_DESCRIPTION>Exempt</FLSA_DESCRIPTION>
      <CAREER_LEVEL>3</CAREER_LEVEL>
      <JOB_FAMILY_RESPONSIBILITE>> Develops business plans to support
      market share objectives. > Applies an expert understanding of product
      and/or system scope and application ¿ consulting with others as
      required to provide a complete solution. > Provides advanced and
      comprehensive technical application assistance in key sales
      situations. > Applies current knowledge of competitive products and
      competitors¿ activities ¿ recommending appropriate products to fill
      application gaps. > Determines and implements pricing and bid
      strategies. > Implements a profitable market
      strategy.</JOB_FAMILY_RESPONSIBILITE>
      <KEY_RESPONSIBILITES>> Performs full range of standard work for the
      professional field. > Refers complex, unusual problems to others. >
      Identifies and resolves more complex problems and applies problem-
      solving skills in order to deal with most
      situations.</KEY_RESPONSIBILITES>
      <EDUCATION>Typically BS/BA in related discipline or advanced
      degree. Certification may be required in some areas.</EDUCATION>
      <KNOWLEDGE>> Demonstrates and applies a broad knowledge of field of
      specialization through successful completion of moderately complex
      assignments. > Successfully applies complex knowledge of fundamental
      concepts, practices, and procedures of particular area of
      specialization. > Demonstrates knowledge of organization's business
      practices and issues.</KNOWLEDGE>
      <EXPERIENCE>Typically 5-8 years of successful experience in related
      field and successful demonstration of Key Responsibilities and
      Knowledge as presented above. Advanced degree MAY be substituted for
      experience, where applicable.</EXPERIENCE>
      <DIRECTION_OF_OTHERS>Provides general guidance or train support
      and/or professional staff.</DIRECTION_OF_OTHERS>
      <KEY_WORKING_RELATIONSHIPS>Primarily intra-organizational contacts
      and external contacts.</KEY_WORKING_RELATIONSHIPS>
      <GRADE_LABEL>C</GRADE_LABEL>
      <EEO_CATEGORY>2</EEO_CATEGORY>
      <EEO_GROUP>M8</EEO_GROUP>
      </Table>
      <Table diffgr:id="Table2" msdata:rowOrder="1">
      <SET_ID>050US</SET_ID>
      <COMPANY_GROUP_CODE>SMS</COMPANY_GROUP_CODE>
      <COMPANY_GROUP_NAME>SMS Group of Companies</COMPANY_GROUP_NAME>
      <JOBCODE>940</JOBCODE>
      <JOBTITLE>Account Executive III</JOBTITLE>
      <CAPRI_CODE>100383</CAPRI_CODE>
      <CAPRI_NAME>Account Representative</CAPRI_NAME>
      <JOB_GROUP>04</JOB_GROUP>
      <JOB_GROUP_DESC>Sales</JOB_GROUP_DESC>
      <JOB_FAMILY_CODE>1027</JOB_FAMILY_CODE>
      <JOB_FAMILY_DESCRIPTION>Account
      Representative</JOB_FAMILY_DESCRIPTION>
      <JOB_FAMILY_PURPOSE>Sells products, services, solutions to new
      and/or existing customers and establishes and/or maintains customer
      relationships.</JOB_FAMILY_PURPOSE>
      <FLSA_CODE>E</FLSA_CODE>
      <FLSA_DESCRIPTION>Exempt</FLSA_DESCRIPTION>
      <CAREER_LEVEL>4</CAREER_LEVEL>
      <JOB_FAMILY_RESPONSIBILITE>> Guides unit to achieve business
      objectives at key accounts (for example, penetration of account with
      product/solution/service offerings). > Leverages Siemens global reach
      to influence decisions on projects for delivery to the customer in
      the US, or purchased by the customer in the US. > Guides the
      development and execution of strategic account plans to ensure
      achievement of assigned business goals. > Develops / builds /
      cultivates long-term relationships with key management within the
      customer organization. > Assists management in devising sales plans
      and strategies > May form account teams and coordinate team
      activities while minimizing sales and marketing costs and maximizing
      sales. > May lead team reviews and updates of account plan based on
      changing market, customer conditions, and competitive
      activity.</JOB_FAMILY_RESPONSIBILITE>
      <KEY_RESPONSIBILITES>> Performs advanced areas of work for the
      professional field. > Applies advanced skills to resolve complex
      problems not covered by existing procedures or practices
      independently. > Displays a high level of critical thinking in
      bringing successful resolution to high-impact, complex, and/or cross-
      functional problems.</KEY_RESPONSIBILITES>
      <EDUCATION>Typically BS/BA in related discipline or advanced
      degree. Certification may be required in some areas.</EDUCATION>
      <KNOWLEDGE>> Demonstrates and applies comprehensive knowledge of
      field of specialization to the successful completion of complex
      assignments. > Demonstrates advanced knowledge of concepts,
      practices, and procedures of particular area of specialization. >
      Demonstrates significant knowledge of organization's business
      practices and issues faced and contributes to problem resolution of
      those issues.</KNOWLEDGE>
      <EXPERIENCE>Typically 8-10 years of successful experience in
      related field and successful demonstration of Key Responsibilities
      and Knowledge as presented above. Advanced degree MAY be substituted
      for experience, where applicable.</EXPERIENCE>
      <DIRECTION_OF_OTHERS>Provides specialized guidance or train support
      and/or professional staff. Leadership qualities and role model
      qualities demonstrated.</DIRECTION_OF_OTHERS>
      <KEY_WORKING_RELATIONSHIPS>Primarily intra-organizational contacts
      and external contacts.</KEY_WORKING_RELATIONSHIPS>
      <GRADE_LABEL>D</GRADE_LABEL>
      <EEO_CATEGORY>4</EEO_CATEGORY>
      <EEO_GROUP>04</EEO_GROUP>
      </Table>
      </JobsObjectData>
      </diffgr:diffgram>
      </DataSet>
    • Graeme Riddell
      I see the msdata attribute in the XML response, suggesting this is a .Net web service. Are you using .Net to implement your client or do you have a Java
      Message 2 of 5 , May 3 9:10 AM
         
        I see the "msdata" attribute in the XML response, suggesting this is a .Net web service. Are you using .Net to implement your client or do you have a Java toolset (WSAD, Systinet, BowStreet, Axis, etc)? At a high level it doesn't really matter, you'll have a tool that consumes that WSDL doc and creates some artifacts that at runtime will make the service call and give you your XML file. (Ready for your next task of loading into SqlServer ;-)   ).  But knowing the tool you're using will help us give a more focused response to your question. Can you post the wsdl doc too just for grins?
         
        -gr
         
         
         
        -----Original Message-----
        From: keith_d_savage [mailto:keith_d_savage@...]
        Sent: Monday, May 03, 2004 12:01 PM
        To: wsdl@yahoogroups.com
        Subject: [wsdl] direction in learning...

        Hi!

        So glad to see that this group exists...I've been given a challenge
        at work that involves processing the contents of an xml file and
        conditionally loading it into a SQL Server database.  "No problem" I
        first thought, having worked some with xml files beofre.

        Turns out that this xml file will come to us via web serice, which I
        grasp the concept of but have never actually used.  I was also given
        a sample of the XML file and a file with a ".wsdl" extension.  I was
        told I'll need that, but was not told what for.  Anyway, the XML file
        was not at all what I expected and I am not sure how to handle all of
        this.  If someone could be so kind as to give me some direction, or
        even recommend some specific "cut to the chase" literature or
        resources on how to get this done, I would REALLY appreciate it! 
        Please respond here or to my email address of
        keith_d_savage@....

        Below if a sample of the XML file.

        Keith

        <?xml version="1.0" encoding="utf-8" ?>
        <DataSet xmlns="http://apps.imercer.com/Mercer.Web.GetJobsObject/">
        <xs:schema id="JobsObjectData" xmlns=""
        xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-
        microsoft-com:xml-msdata">
        <xs:element name="JobsObjectData" msdata:IsDataSet="true">
        <xs:complexType>
        <xs:choice maxOccurs="unbounded">
        <xs:element name="Table">
        <xs:complexType>
        <xs:sequence>
          <xs:element name="SET_ID" type="xs:string" minOccurs="0" />
          <xs:element name="COMPANY_GROUP_CODE" type="xs:string"
        minOccurs="0" />
          <xs:element name="COMPANY_GROUP_NAME" type="xs:string"
        minOccurs="0" />
          <xs:element name="JOBCODE" type="xs:string" minOccurs="0" />
          <xs:element name="JOBTITLE" type="xs:string" minOccurs="0" />
          <xs:element name="CAPRI_CODE" type="xs:string" minOccurs="0" />
          <xs:element name="CAPRI_NAME" type="xs:string" minOccurs="0" />
          <xs:element name="SOC_CODE" type="xs:string" minOccurs="0" />
          <xs:element name="SOC_NAME" type="xs:string" minOccurs="0" />
          <xs:element name="JOB_GROUP" type="xs:string" minOccurs="0" />
          <xs:element name="JOB_GROUP_DESC" type="xs:string" minOccurs="0" />
          <xs:element name="JOB_FAMILY_CODE" type="xs:string"
        minOccurs="0" />
          <xs:element name="JOB_FAMILY_DESCRIPTION" type="xs:string"
        minOccurs="0" />
          <xs:element name="JOB_FAMILY_PURPOSE" type="xs:string"
        minOccurs="0" />
          <xs:element name="FLSA_CODE" type="xs:string" minOccurs="0" />
          <xs:element name="FLSA_DESCRIPTION" type="xs:string"
        minOccurs="0" />
          <xs:element name="CAREER_LEVEL" type="xs:string" minOccurs="0" />
          <xs:element name="JOB_FAMILY_RESPONSIBILITE" type="xs:string"
        minOccurs="0" />
          <xs:element name="KEY_RESPONSIBILITES" type="xs:string"
        minOccurs="0" />
          <xs:element name="EDUCATION" type="xs:string" minOccurs="0" />
          <xs:element name="KNOWLEDGE" type="xs:string" minOccurs="0" />
          <xs:element name="EXPERIENCE" type="xs:string" minOccurs="0" />
          <xs:element name="DIRECTION_OF_OTHERS" type="xs:string"
        minOccurs="0" />
          <xs:element name="KEY_WORKING_RELATIONSHIPS" type="xs:string"
        minOccurs="0" />
          <xs:element name="SOC_SPECIFIC_RESPONSIBILI" type="xs:string"
        minOccurs="0" />
          <xs:element name="GRADE_LABEL" type="xs:string" minOccurs="0" />
          <xs:element name="EEO_CATEGORY" type="xs:string" minOccurs="0" />
          <xs:element name="EEO_GROUP" type="xs:string" minOccurs="0" />
          <xs:element name="SOC_COMPETENCY_URL" type="xs:string"
        minOccurs="0" />
          <xs:element name="SOC_SALARY_STRUCTURE_URL" type="xs:string"
        minOccurs="0" />
          </xs:sequence>
          </xs:complexType>
          </xs:element>
          </xs:choice>
          </xs:complexType>
          </xs:element>
          </xs:schema>
        <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
        xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
        <JobsObjectData xmlns="">
        <Table diffgr:id="Table1" msdata:rowOrder="0">
          <SET_ID>050US</SET_ID>
          <COMPANY_GROUP_CODE>SMS</COMPANY_GROUP_CODE>
          <COMPANY_GROUP_NAME>SMS Group of Companies</COMPANY_GROUP_NAME>
          <JOBCODE>AF105</JOBCODE>
          <JOBTITLE>National Account Manager 2</JOBTITLE>
          <CAPRI_CODE>100215</CAPRI_CODE>
          <CAPRI_NAME>Business Development Specialist</CAPRI_NAME>
          <JOB_GROUP>04</JOB_GROUP>
          <JOB_GROUP_DESC>Sales</JOB_GROUP_DESC>
          <JOB_FAMILY_CODE>1055</JOB_FAMILY_CODE>
          <JOB_FAMILY_DESCRIPTION>Business Development
        Specialist</JOB_FAMILY_DESCRIPTION>
          <JOB_FAMILY_PURPOSE>Develops strategic business plans, marketing
        programs, and partnerships to support sales in designated market
        segments.</JOB_FAMILY_PURPOSE>
          <FLSA_CODE>E</FLSA_CODE>
          <FLSA_DESCRIPTION>Exempt</FLSA_DESCRIPTION>
          <CAREER_LEVEL>3</CAREER_LEVEL>
          <JOB_FAMILY_RESPONSIBILITE>> Develops business plans to support
        market share objectives. > Applies an expert understanding of product
        and/or system scope and application ¿ consulting with others as
        required to provide a complete solution. > Provides advanced and
        comprehensive technical application assistance in key sales
        situations. > Applies current knowledge of competitive products and
        competitors¿ activities ¿ recommending appropriate products to fill
        application gaps. > Determines and implements pricing and bid
        strategies. > Implements a profitable market
        strategy.</JOB_FAMILY_RESPONSIBILITE>
          <KEY_RESPONSIBILITES>> Performs full range of standard work for the
        professional field. > Refers complex, unusual problems to others. >
        Identifies and resolves more complex problems and applies problem-
        solving skills in order to deal with most
        situations.</KEY_RESPONSIBILITES>
          <EDUCATION>Typically BS/BA in related discipline or advanced
        degree. Certification may be required in some areas.</EDUCATION>
          <KNOWLEDGE>> Demonstrates and applies a broad knowledge of field of
        specialization through successful completion of moderately complex
        assignments. > Successfully applies complex knowledge of fundamental
        concepts, practices, and procedures of particular area of
        specialization. > Demonstrates knowledge of organization's business
        practices and issues.</KNOWLEDGE>
          <EXPERIENCE>Typically 5-8 years of successful experience in related
        field and successful demonstration of Key Responsibilities and
        Knowledge as presented above. Advanced degree MAY be substituted for
        experience, where applicable.</EXPERIENCE>
          <DIRECTION_OF_OTHERS>Provides general guidance or train support
        and/or professional staff.</DIRECTION_OF_OTHERS>
          <KEY_WORKING_RELATIONSHIPS>Primarily intra-organizational contacts
        and external contacts.</KEY_WORKING_RELATIONSHIPS>
          <GRADE_LABEL>C</GRADE_LABEL>
          <EEO_CATEGORY>2</EEO_CATEGORY>
          <EEO_GROUP>M8</EEO_GROUP>
          </Table>
        <Table diffgr:id="Table2" msdata:rowOrder="1">
          <SET_ID>050US</SET_ID>
          <COMPANY_GROUP_CODE>SMS</COMPANY_GROUP_CODE>
          <COMPANY_GROUP_NAME>SMS Group of Companies</COMPANY_GROUP_NAME>
          <JOBCODE>940</JOBCODE>
          <JOBTITLE>Account Executive III</JOBTITLE>
          <CAPRI_CODE>100383</CAPRI_CODE>
          <CAPRI_NAME>Account Representative</CAPRI_NAME>
          <JOB_GROUP>04</JOB_GROUP>
          <JOB_GROUP_DESC>Sales</JOB_GROUP_DESC>
          <JOB_FAMILY_CODE>1027</JOB_FAMILY_CODE>
          <JOB_FAMILY_DESCRIPTION>Account
        Representative</JOB_FAMILY_DESCRIPTION>
          <JOB_FAMILY_PURPOSE>Sells products, services, solutions to new
        and/or existing customers and establishes and/or maintains customer
        relationships.</JOB_FAMILY_PURPOSE>
          <FLSA_CODE>E</FLSA_CODE>
          <FLSA_DESCRIPTION>Exempt</FLSA_DESCRIPTION>
          <CAREER_LEVEL>4</CAREER_LEVEL>
          <JOB_FAMILY_RESPONSIBILITE>> Guides unit to achieve business
        objectives at key accounts (for example, penetration of account with
        product/solution/service offerings). > Leverages Siemens global reach
        to influence decisions on projects for delivery to the customer in
        the US, or purchased by the customer in the US. > Guides the
        development and execution of strategic account plans to ensure
        achievement of assigned business goals. > Develops / builds /
        cultivates long-term relationships with key management within the
        customer organization. > Assists management in devising sales plans
        and strategies > May form account teams and coordinate team
        activities while minimizing sales and marketing costs and maximizing
        sales. > May lead team reviews and updates of account plan based on
        changing market, customer conditions, and competitive
        activity.</JOB_FAMILY_RESPONSIBILITE>
          <KEY_RESPONSIBILITES>> Performs advanced areas of work for the
        professional field. > Applies advanced skills to resolve complex
        problems not covered by existing procedures or practices
        independently. > Displays a high level of critical thinking in
        bringing successful resolution to high-impact, complex, and/or cross-
        functional problems.</KEY_RESPONSIBILITES>
          <EDUCATION>Typically BS/BA in related discipline or advanced
        degree. Certification may be required in some areas.</EDUCATION>
          <KNOWLEDGE>> Demonstrates and applies comprehensive knowledge of
        field of specialization to the successful completion of complex
        assignments. > Demonstrates advanced knowledge of concepts,
        practices, and procedures of particular area of specialization. >
        Demonstrates significant knowledge of organization's business
        practices and issues faced and contributes to problem resolution of
        those issues.</KNOWLEDGE>
          <EXPERIENCE>Typically 8-10 years of successful experience in
        related field and successful demonstration of Key Responsibilities
        and Knowledge as presented above. Advanced degree MAY be substituted
        for experience, where applicable.</EXPERIENCE>
          <DIRECTION_OF_OTHERS>Provides specialized guidance or train support
        and/or professional staff. Leadership qualities and role model
        qualities demonstrated.</DIRECTION_OF_OTHERS>
          <KEY_WORKING_RELATIONSHIPS>Primarily intra-organizational contacts
        and external contacts.</KEY_WORKING_RELATIONSHIPS>
          <GRADE_LABEL>D</GRADE_LABEL>
          <EEO_CATEGORY>4</EEO_CATEGORY>
          <EEO_GROUP>04</EEO_GROUP>
        </Table>
        </JobsObjectData>
        </diffgr:diffgram>
        </DataSet>



        -----------------------------------------------------------------
        This group is a forum for the discussion of the WSDL specification and its implementation.  Please stay on-topic.


      • keith_d_savage
        Thank you sooo much for the quick response! The only two ways I know how to implement a client is through visual basic (using MSXML) or through a stored
        Message 3 of 5 , May 3 10:47 AM
          Thank you sooo much for the quick response! The only two ways I know
          how to implement a client is through visual basic (using MSXML) or
          through a stored procedure (using sp_xml_preparedocument). I've been
          unsuccessful in using either of these so far, and have no java
          or .Net experience.

          Here is the what the .wsdl file looks like. I really cannot say
          enough how much I appreciate the reply.

          Keith

          <?xml version="1.0" encoding="utf-8"?>
          <definitions xmlns:http="http://schemas.xmlsoap.org/wsdl/http/"
          xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
          xmlns:s="http://www.w3.org/2001/XMLSchema"
          xmlns:s0="http://apps.imercer.com/Mercer.Web.GetJobsObject/"
          xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
          xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/"
          xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/"
          targetNamespace="http://apps.imercer.com/Mercer.Web.GetJobsObject/"
          xmlns="http://schemas.xmlsoap.org/wsdl/">
          <types>
          <s:schema elementFormDefault="qualified"
          targetNamespace="http://apps.imercer.com/Mercer.Web.GetJobsObject/">
          <s:import namespace="http://www.w3.org/2001/XMLSchema" />
          <s:element name="Execute">
          <s:complexType>
          <s:sequence>
          <s:element minOccurs="0" maxOccurs="1" name="UserName"
          type="s:string" />
          <s:element minOccurs="0" maxOccurs="1" name="Password"
          type="s:string" />
          <s:element minOccurs="0" maxOccurs="1" name="Filter"
          type="s:string" />
          </s:sequence>
          </s:complexType>
          </s:element>
          <s:element name="ExecuteResponse">
          <s:complexType>
          <s:sequence>
          <s:element minOccurs="0" maxOccurs="1"
          name="ExecuteResult">
          <s:complexType>
          <s:sequence>
          <s:element ref="s:schema" />
          <s:any />
          </s:sequence>
          </s:complexType>
          </s:element>
          </s:sequence>
          </s:complexType>
          </s:element>
          <s:element name="DataSet" nillable="true">
          <s:complexType>
          <s:sequence>
          <s:element ref="s:schema" />
          <s:any />
          </s:sequence>
          </s:complexType>
          </s:element>
          </s:schema>
          </types>
          <message name="ExecuteSoapIn">
          <part name="parameters" element="s0:Execute" />
          </message>
          <message name="ExecuteSoapOut">
          <part name="parameters" element="s0:ExecuteResponse" />
          </message>
          <message name="ExecuteHttpGetIn">
          <part name="UserName" type="s:string" />
          <part name="Password" type="s:string" />
          <part name="Filter" type="s:string" />
          </message>
          <message name="ExecuteHttpGetOut">
          <part name="Body" element="s0:DataSet" />
          </message>
          <message name="ExecuteHttpPostIn">
          <part name="UserName" type="s:string" />
          <part name="Password" type="s:string" />
          <part name="Filter" type="s:string" />
          </message>
          <message name="ExecuteHttpPostOut">
          <part name="Body" element="s0:DataSet" />
          </message>
          <portType name="GetJobsObjectSoap">
          <operation name="Execute">
          <documentation>Executes a query on the Jobs CPA object in a
          given user's data dictionary.</documentation>
          <input message="s0:ExecuteSoapIn" />
          <output message="s0:ExecuteSoapOut" />
          </operation>
          </portType>
          <portType name="GetJobsObjectHttpGet">
          <operation name="Execute">
          <documentation>Executes a query on the Jobs CPA object in a
          given user's data dictionary.</documentation>
          <input message="s0:ExecuteHttpGetIn" />
          <output message="s0:ExecuteHttpGetOut" />
          </operation>
          </portType>
          <portType name="GetJobsObjectHttpPost">
          <operation name="Execute">
          <documentation>Executes a query on the Jobs CPA object in a
          given user's data dictionary.</documentation>
          <input message="s0:ExecuteHttpPostIn" />
          <output message="s0:ExecuteHttpPostOut" />
          </operation>
          </portType>
          <binding name="GetJobsObjectSoap" type="s0:GetJobsObjectSoap">
          <soap:binding transport="http://schemas.xmlsoap.org/soap/http"
          style="document" />
          <operation name="Execute">
          <soap:operation
          soapAction="http://apps.imercer.com/Mercer.Web.GetJobsObject/Execute"
          style="document" />
          <input>
          <soap:body use="literal" />
          </input>
          <output>
          <soap:body use="literal" />
          </output>
          </operation>
          </binding>
          <binding name="GetJobsObjectHttpGet" type="s0:GetJobsObjectHttpGet">
          <http:binding verb="GET" />
          <operation name="Execute">
          <http:operation location="/Execute" />
          <input>
          <http:urlEncoded />
          </input>
          <output>
          <mime:mimeXml part="Body" />
          </output>
          </operation>
          </binding>
          <binding name="GetJobsObjectHttpPost"
          type="s0:GetJobsObjectHttpPost">
          <http:binding verb="POST" />
          <operation name="Execute">
          <http:operation location="/Execute" />
          <input>
          <mime:content type="application/x-www-form-urlencoded" />
          </input>
          <output>
          <mime:mimeXml part="Body" />
          </output>
          </operation>
          </binding>
          <service name="GetJobsObject">
          <documentation>Accesses the Jobs CPA object.</documentation>
          <port name="GetJobsObjectSoap" binding="s0:GetJobsObjectSoap">
          <soap:address
          location="http://gisqawebclstr/GetJobsObject/GetJobsObject.asmx" />
          </port>
          <port name="GetJobsObjectHttpGet"
          binding="s0:GetJobsObjectHttpGet">
          <http:address
          location="http://gisqawebclstr/GetJobsObject/GetJobsObject.asmx" />
          </port>
          <port name="GetJobsObjectHttpPost"
          binding="s0:GetJobsObjectHttpPost">
          <http:address
          location="http://gisqawebclstr/GetJobsObject/GetJobsObject.asmx" />
          </port>
          </service>
          </definitions>















          --- In wsdl@yahoogroups.com, Graeme Riddell <griddell@b...> wrote:
          >
          > I see the "msdata" attribute in the XML response, suggesting this
          is a .Net
          > web service. Are you using .Net to implement your client or do you
          have a
          > Java toolset (WSAD, Systinet, BowStreet, Axis, etc)? At a high
          level it
          > doesn't really matter, you'll have a tool that consumes that WSDL
          doc and
          > creates some artifacts that at runtime will make the service call
          and give
          > you your XML file. (Ready for your next task of loading into
          SqlServer ;-)
          > ). But knowing the tool you're using will help us give a more
          focused
          > response to your question. Can you post the wsdl doc too just for
          grins?
          >
          > -gr
          >
          >
          >
          >
          > -----Original Message-----
          > From: keith_d_savage [mailto:keith_d_savage@y...]
          > Sent: Monday, May 03, 2004 12:01 PM
          > To: wsdl@yahoogroups.com
          > Subject: [wsdl] direction in learning...
          >
          >
          > Hi!
          >
          > So glad to see that this group exists...I've been given a challenge
          > at work that involves processing the contents of an xml file and
          > conditionally loading it into a SQL Server database. "No problem"
          I
          > first thought, having worked some with xml files beofre.
          >
          > Turns out that this xml file will come to us via web serice, which
          I
          > grasp the concept of but have never actually used. I was also
          given
          > a sample of the XML file and a file with a ".wsdl" extension. I
          was
          > told I'll need that, but was not told what for. Anyway, the XML
          file
          > was not at all what I expected and I am not sure how to handle all
          of
          > this. If someone could be so kind as to give me some direction, or
          > even recommend some specific "cut to the chase" literature or
          > resources on how to get this done, I would REALLY appreciate it!
          > Please respond here or to my email address of
          > keith_d_savage@y...
          >
          > Below if a sample of the XML file.
          >
          > Keith
          >
          > <?xml version="1.0" encoding="utf-8" ?>
          > <DataSet xmlns=" http://apps.imercer.com/Mercer.Web.GetJobsObject/
          > <http://apps.imercer.com/Mercer.Web.GetJobsObject/> ">
          > <xs:schema id="JobsObjectData" xmlns=""
          > xmlns:xs=" http://www.w3.org/2001/XMLSchema
          > <http://www.w3.org/2001/XMLSchema> " xmlns:msdata="urn:schemas-
          > microsoft-com:xml-msdata">
          > <xs:element name="JobsObjectData" msdata:IsDataSet="true">
          > <xs:complexType>
          > <xs:choice maxOccurs="unbounded">
          > <xs:element name="Table">
          > <xs:complexType>
          > <xs:sequence>
          > <xs:element name="SET_ID" type="xs:string" minOccurs="0" />
          > <xs:element name="COMPANY_GROUP_CODE" type="xs:string"
          > minOccurs="0" />
          > <xs:element name="COMPANY_GROUP_NAME" type="xs:string"
          > minOccurs="0" />
          > <xs:element name="JOBCODE" type="xs:string" minOccurs="0" />
          > <xs:element name="JOBTITLE" type="xs:string" minOccurs="0" />
          > <xs:element name="CAPRI_CODE" type="xs:string" minOccurs="0" />
          > <xs:element name="CAPRI_NAME" type="xs:string" minOccurs="0" />
          > <xs:element name="SOC_CODE" type="xs:string" minOccurs="0" />
          > <xs:element name="SOC_NAME" type="xs:string" minOccurs="0" />
          > <xs:element name="JOB_GROUP" type="xs:string" minOccurs="0" />
          > <xs:element name="JOB_GROUP_DESC" type="xs:string"
          minOccurs="0" />
          > <xs:element name="JOB_FAMILY_CODE" type="xs:string"
          > minOccurs="0" />
          > <xs:element name="JOB_FAMILY_DESCRIPTION" type="xs:string"
          > minOccurs="0" />
          > <xs:element name="JOB_FAMILY_PURPOSE" type="xs:string"
          > minOccurs="0" />
          > <xs:element name="FLSA_CODE" type="xs:string" minOccurs="0" />
          > <xs:element name="FLSA_DESCRIPTION" type="xs:string"
          > minOccurs="0" />
          > <xs:element name="CAREER_LEVEL" type="xs:string" minOccurs="0" />
          > <xs:element name="JOB_FAMILY_RESPONSIBILITE" type="xs:string"
          > minOccurs="0" />
          > <xs:element name="KEY_RESPONSIBILITES" type="xs:string"
          > minOccurs="0" />
          > <xs:element name="EDUCATION" type="xs:string" minOccurs="0" />
          > <xs:element name="KNOWLEDGE" type="xs:string" minOccurs="0" />
          > <xs:element name="EXPERIENCE" type="xs:string" minOccurs="0" />
          > <xs:element name="DIRECTION_OF_OTHERS" type="xs:string"
          > minOccurs="0" />
          > <xs:element name="KEY_WORKING_RELATIONSHIPS" type="xs:string"
          > minOccurs="0" />
          > <xs:element name="SOC_SPECIFIC_RESPONSIBILI" type="xs:string"
          > minOccurs="0" />
          > <xs:element name="GRADE_LABEL" type="xs:string" minOccurs="0" />
          > <xs:element name="EEO_CATEGORY" type="xs:string" minOccurs="0" />
          > <xs:element name="EEO_GROUP" type="xs:string" minOccurs="0" />
          > <xs:element name="SOC_COMPETENCY_URL" type="xs:string"
          > minOccurs="0" />
          > <xs:element name="SOC_SALARY_STRUCTURE_URL" type="xs:string"
          > minOccurs="0" />
          > </xs:sequence>
          > </xs:complexType>
          > </xs:element>
          > </xs:choice>
          > </xs:complexType>
          > </xs:element>
          > </xs:schema>
          > <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-
          msdata"
          > xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
          > <JobsObjectData xmlns="">
          > <Table diffgr:id="Table1" msdata:rowOrder="0">
          > <SET_ID>050US</SET_ID>
          > <COMPANY_GROUP_CODE>SMS</COMPANY_GROUP_CODE>
          > <COMPANY_GROUP_NAME>SMS Group of Companies</COMPANY_GROUP_NAME>
          > <JOBCODE>AF105</JOBCODE>
          > <JOBTITLE>National Account Manager 2</JOBTITLE>
          > <CAPRI_CODE>100215</CAPRI_CODE>
          > <CAPRI_NAME>Business Development Specialist</CAPRI_NAME>
          > <JOB_GROUP>04</JOB_GROUP>
          > <JOB_GROUP_DESC>Sales</JOB_GROUP_DESC>
          > <JOB_FAMILY_CODE>1055</JOB_FAMILY_CODE>
          > <JOB_FAMILY_DESCRIPTION>Business Development
          > Specialist</JOB_FAMILY_DESCRIPTION>
          > <JOB_FAMILY_PURPOSE>Develops strategic business plans, marketing
          > programs, and partnerships to support sales in designated market
          > segments.</JOB_FAMILY_PURPOSE>
          > <FLSA_CODE>E</FLSA_CODE>
          > <FLSA_DESCRIPTION>Exempt</FLSA_DESCRIPTION>
          > <CAREER_LEVEL>3</CAREER_LEVEL>
          > <JOB_FAMILY_RESPONSIBILITE>> Develops business plans to support
          > market share objectives. > Applies an expert understanding of
          product
          > and/or system scope and application ¿ consulting with others as
          > required to provide a complete solution. > Provides advanced and
          > comprehensive technical application assistance in key sales
          > situations. > Applies current knowledge of competitive products and
          > competitors¿ activities ¿ recommending appropriate products to fill
          > application gaps. > Determines and implements pricing and bid
          > strategies. > Implements a profitable market
          > strategy.</JOB_FAMILY_RESPONSIBILITE>
          > <KEY_RESPONSIBILITES>> Performs full range of standard work for
          the
          > professional field. > Refers complex, unusual problems to others. >
          > Identifies and resolves more complex problems and applies problem-
          > solving skills in order to deal with most
          > situations.</KEY_RESPONSIBILITES>
          > <EDUCATION>Typically BS/BA in related discipline or advanced
          > degree. Certification may be required in some areas.</EDUCATION>
          > <KNOWLEDGE>> Demonstrates and applies a broad knowledge of field
          of
          > specialization through successful completion of moderately complex
          > assignments. > Successfully applies complex knowledge of
          fundamental
          > concepts, practices, and procedures of particular area of
          > specialization. > Demonstrates knowledge of organization's business
          > practices and issues.</KNOWLEDGE>
          > <EXPERIENCE>Typically 5-8 years of successful experience in
          related
          > field and successful demonstration of Key Responsibilities and
          > Knowledge as presented above. Advanced degree MAY be substituted
          for
          > experience, where applicable.</EXPERIENCE>
          > <DIRECTION_OF_OTHERS>Provides general guidance or train support
          > and/or professional staff.</DIRECTION_OF_OTHERS>
          > <KEY_WORKING_RELATIONSHIPS>Primarily intra-organizational
          contacts
          > and external contacts.</KEY_WORKING_RELATIONSHIPS>
          > <GRADE_LABEL>C</GRADE_LABEL>
          > <EEO_CATEGORY>2</EEO_CATEGORY>
          > <EEO_GROUP>M8</EEO_GROUP>
          > </Table>
          > <Table diffgr:id="Table2" msdata:rowOrder="1">
          > <SET_ID>050US</SET_ID>
          > <COMPANY_GROUP_CODE>SMS</COMPANY_GROUP_CODE>
          > <COMPANY_GROUP_NAME>SMS Group of Companies</COMPANY_GROUP_NAME>
          > <JOBCODE>940</JOBCODE>
          > <JOBTITLE>Account Executive III</JOBTITLE>
          > <CAPRI_CODE>100383</CAPRI_CODE>
          > <CAPRI_NAME>Account Representative</CAPRI_NAME>
          > <JOB_GROUP>04</JOB_GROUP>
          > <JOB_GROUP_DESC>Sales</JOB_GROUP_DESC>
          > <JOB_FAMILY_CODE>1027</JOB_FAMILY_CODE>
          > <JOB_FAMILY_DESCRIPTION>Account
          > Representative</JOB_FAMILY_DESCRIPTION>
          > <JOB_FAMILY_PURPOSE>Sells products, services, solutions to new
          > and/or existing customers and establishes and/or maintains customer
          > relationships.</JOB_FAMILY_PURPOSE>
          > <FLSA_CODE>E</FLSA_CODE>
          > <FLSA_DESCRIPTION>Exempt</FLSA_DESCRIPTION>
          > <CAREER_LEVEL>4</CAREER_LEVEL>
          > <JOB_FAMILY_RESPONSIBILITE>> Guides unit to achieve business
          > objectives at key accounts (for example, penetration of account
          with
          > product/solution/service offerings). > Leverages Siemens global
          reach
          > to influence decisions on projects for delivery to the customer in
          > the US, or purchased by the customer in the US. > Guides the
          > development and execution of strategic account plans to ensure
          > achievement of assigned business goals. > Develops / builds /
          > cultivates long-term relationships with key management within the
          > customer organization. > Assists management in devising sales plans
          > and strategies > May form account teams and coordinate team
          > activities while minimizing sales and marketing costs and
          maximizing
          > sales. > May lead team reviews and updates of account plan based on
          > changing market, customer conditions, and competitive
          > activity.</JOB_FAMILY_RESPONSIBILITE>
          > <KEY_RESPONSIBILITES>> Performs advanced areas of work for the
          > professional field. > Applies advanced skills to resolve complex
          > problems not covered by existing procedures or practices
          > independently. > Displays a high level of critical thinking in
          > bringing successful resolution to high-impact, complex, and/or
          cross-
          > functional problems.</KEY_RESPONSIBILITES>
          > <EDUCATION>Typically BS/BA in related discipline or advanced
          > degree. Certification may be required in some areas.</EDUCATION>
          > <KNOWLEDGE>> Demonstrates and applies comprehensive knowledge of
          > field of specialization to the successful completion of complex
          > assignments. > Demonstrates advanced knowledge of concepts,
          > practices, and procedures of particular area of specialization. >
          > Demonstrates significant knowledge of organization's business
          > practices and issues faced and contributes to problem resolution of
          > those issues.</KNOWLEDGE>
          > <EXPERIENCE>Typically 8-10 years of successful experience in
          > related field and successful demonstration of Key Responsibilities
          > and Knowledge as presented above. Advanced degree MAY be
          substituted
          > for experience, where applicable.</EXPERIENCE>
          > <DIRECTION_OF_OTHERS>Provides specialized guidance or train
          support
          > and/or professional staff. Leadership qualities and role model
          > qualities demonstrated.</DIRECTION_OF_OTHERS>
          > <KEY_WORKING_RELATIONSHIPS>Primarily intra-organizational
          contacts
          > and external contacts.</KEY_WORKING_RELATIONSHIPS>
          > <GRADE_LABEL>D</GRADE_LABEL>
          > <EEO_CATEGORY>4</EEO_CATEGORY>
          > <EEO_GROUP>04</EEO_GROUP>
          > </Table>
          > </JobsObjectData>
          > </diffgr:diffgram>
          > </DataSet>
          >
          >
          >
          > -----------------------------------------------------------------
          > This group is a forum for the discussion of the WSDL specification
          and its
          > implementation. Please stay on-topic.
          >
          >
          >
          > _____
          >
          > Yahoo! Groups Links
          >
          >
          > * To visit your group on the web, go to:
          > http://groups.yahoo.com/group/wsdl/
          <http://groups.yahoo.com/group/wsdl/>
          >
          >
          > * To unsubscribe from this group, send an email to:
          > wsdl-unsubscribe@yahoogroups.com
          > <mailto:wsdl-unsubscribe@yahoogroups.com?subject=Unsubscribe>
          >
          >
          > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
          Service
          > <http://docs.yahoo.com/info/terms/> .
        • Anne Thomas Manes
          Keith, The Web service returns an ADO.NET Dataset. (See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
          Message 4 of 5 , May 4 7:14 AM
            Keith,

            The Web service returns an ADO.NET Dataset. (See
            http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
            l/cpconoverviewofadonet.asp) I suggest that you build your client using
            Visual Basic .NET. The VB.NET client can easily consume the Dataset and load
            it into SQL Server for you. See these sample applications:

            Consuming a Dataset from a Web service:
            http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
            l/cpconconsumingdatasetfromwebservice.asp

            Processing a Dataset:
            http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
            l/cpconsampleapplication.asp

            Anne

            -----Original Message-----
            From: keith_d_savage [mailto:keith_d_savage@...]
            Sent: Monday, May 03, 2004 1:47 PM
            To: wsdl@yahoogroups.com
            Subject: [wsdl] Re: direction in learning...

            Thank you sooo much for the quick response! The only two ways I know
            how to implement a client is through visual basic (using MSXML) or
            through a stored procedure (using sp_xml_preparedocument). I've been
            unsuccessful in using either of these so far, and have no java
            or .Net experience.

            Here is the what the .wsdl file looks like. I really cannot say
            enough how much I appreciate the reply.

            Keith

            <?xml version="1.0" encoding="utf-8"?>
            <definitions xmlns:http="http://schemas.xmlsoap.org/wsdl/http/"
            xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
            xmlns:s="http://www.w3.org/2001/XMLSchema"
            xmlns:s0="http://apps.imercer.com/Mercer.Web.GetJobsObject/"
            xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
            xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/"
            xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/"
            targetNamespace="http://apps.imercer.com/Mercer.Web.GetJobsObject/"
            xmlns="http://schemas.xmlsoap.org/wsdl/">
            <types>
            <s:schema elementFormDefault="qualified"
            targetNamespace="http://apps.imercer.com/Mercer.Web.GetJobsObject/">
            <s:import namespace="http://www.w3.org/2001/XMLSchema" />
            <s:element name="Execute">
            <s:complexType>
            <s:sequence>
            <s:element minOccurs="0" maxOccurs="1" name="UserName"
            type="s:string" />
            <s:element minOccurs="0" maxOccurs="1" name="Password"
            type="s:string" />
            <s:element minOccurs="0" maxOccurs="1" name="Filter"
            type="s:string" />
            </s:sequence>
            </s:complexType>
            </s:element>
            <s:element name="ExecuteResponse">
            <s:complexType>
            <s:sequence>
            <s:element minOccurs="0" maxOccurs="1"
            name="ExecuteResult">
            <s:complexType>
            <s:sequence>
            <s:element ref="s:schema" />
            <s:any />
            </s:sequence>
            </s:complexType>
            </s:element>
            </s:sequence>
            </s:complexType>
            </s:element>
            <s:element name="DataSet" nillable="true">
            <s:complexType>
            <s:sequence>
            <s:element ref="s:schema" />
            <s:any />
            </s:sequence>
            </s:complexType>
            </s:element>
            </s:schema>
            </types>
            <message name="ExecuteSoapIn">
            <part name="parameters" element="s0:Execute" />
            </message>
            <message name="ExecuteSoapOut">
            <part name="parameters" element="s0:ExecuteResponse" />
            </message>
            <message name="ExecuteHttpGetIn">
            <part name="UserName" type="s:string" />
            <part name="Password" type="s:string" />
            <part name="Filter" type="s:string" />
            </message>
            <message name="ExecuteHttpGetOut">
            <part name="Body" element="s0:DataSet" />
            </message>
            <message name="ExecuteHttpPostIn">
            <part name="UserName" type="s:string" />
            <part name="Password" type="s:string" />
            <part name="Filter" type="s:string" />
            </message>
            <message name="ExecuteHttpPostOut">
            <part name="Body" element="s0:DataSet" />
            </message>
            <portType name="GetJobsObjectSoap">
            <operation name="Execute">
            <documentation>Executes a query on the Jobs CPA object in a
            given user's data dictionary.</documentation>
            <input message="s0:ExecuteSoapIn" />
            <output message="s0:ExecuteSoapOut" />
            </operation>
            </portType>
            <portType name="GetJobsObjectHttpGet">
            <operation name="Execute">
            <documentation>Executes a query on the Jobs CPA object in a
            given user's data dictionary.</documentation>
            <input message="s0:ExecuteHttpGetIn" />
            <output message="s0:ExecuteHttpGetOut" />
            </operation>
            </portType>
            <portType name="GetJobsObjectHttpPost">
            <operation name="Execute">
            <documentation>Executes a query on the Jobs CPA object in a
            given user's data dictionary.</documentation>
            <input message="s0:ExecuteHttpPostIn" />
            <output message="s0:ExecuteHttpPostOut" />
            </operation>
            </portType>
            <binding name="GetJobsObjectSoap" type="s0:GetJobsObjectSoap">
            <soap:binding transport="http://schemas.xmlsoap.org/soap/http"
            style="document" />
            <operation name="Execute">
            <soap:operation
            soapAction="http://apps.imercer.com/Mercer.Web.GetJobsObject/Execute"
            style="document" />
            <input>
            <soap:body use="literal" />
            </input>
            <output>
            <soap:body use="literal" />
            </output>
            </operation>
            </binding>
            <binding name="GetJobsObjectHttpGet" type="s0:GetJobsObjectHttpGet">
            <http:binding verb="GET" />
            <operation name="Execute">
            <http:operation location="/Execute" />
            <input>
            <http:urlEncoded />
            </input>
            <output>
            <mime:mimeXml part="Body" />
            </output>
            </operation>
            </binding>
            <binding name="GetJobsObjectHttpPost"
            type="s0:GetJobsObjectHttpPost">
            <http:binding verb="POST" />
            <operation name="Execute">
            <http:operation location="/Execute" />
            <input>
            <mime:content type="application/x-www-form-urlencoded" />
            </input>
            <output>
            <mime:mimeXml part="Body" />
            </output>
            </operation>
            </binding>
            <service name="GetJobsObject">
            <documentation>Accesses the Jobs CPA object.</documentation>
            <port name="GetJobsObjectSoap" binding="s0:GetJobsObjectSoap">
            <soap:address
            location="http://gisqawebclstr/GetJobsObject/GetJobsObject.asmx" />
            </port>
            <port name="GetJobsObjectHttpGet"
            binding="s0:GetJobsObjectHttpGet">
            <http:address
            location="http://gisqawebclstr/GetJobsObject/GetJobsObject.asmx" />
            </port>
            <port name="GetJobsObjectHttpPost"
            binding="s0:GetJobsObjectHttpPost">
            <http:address
            location="http://gisqawebclstr/GetJobsObject/GetJobsObject.asmx" />
            </port>
            </service>
            </definitions>















            --- In wsdl@yahoogroups.com, Graeme Riddell <griddell@b...> wrote:
            >
            > I see the "msdata" attribute in the XML response, suggesting this
            is a .Net
            > web service. Are you using .Net to implement your client or do you
            have a
            > Java toolset (WSAD, Systinet, BowStreet, Axis, etc)? At a high
            level it
            > doesn't really matter, you'll have a tool that consumes that WSDL
            doc and
            > creates some artifacts that at runtime will make the service call
            and give
            > you your XML file. (Ready for your next task of loading into
            SqlServer ;-)
            > ). But knowing the tool you're using will help us give a more
            focused
            > response to your question. Can you post the wsdl doc too just for
            grins?
            >
            > -gr
            >
            >
            >
            >
            > -----Original Message-----
            > From: keith_d_savage [mailto:keith_d_savage@y...]
            > Sent: Monday, May 03, 2004 12:01 PM
            > To: wsdl@yahoogroups.com
            > Subject: [wsdl] direction in learning...
            >
            >
            > Hi!
            >
            > So glad to see that this group exists...I've been given a challenge
            > at work that involves processing the contents of an xml file and
            > conditionally loading it into a SQL Server database. "No problem"
            I
            > first thought, having worked some with xml files beofre.
            >
            > Turns out that this xml file will come to us via web serice, which
            I
            > grasp the concept of but have never actually used. I was also
            given
            > a sample of the XML file and a file with a ".wsdl" extension. I
            was
            > told I'll need that, but was not told what for. Anyway, the XML
            file
            > was not at all what I expected and I am not sure how to handle all
            of
            > this. If someone could be so kind as to give me some direction, or
            > even recommend some specific "cut to the chase" literature or
            > resources on how to get this done, I would REALLY appreciate it!
            > Please respond here or to my email address of
            > keith_d_savage@y...
            >
            > Below if a sample of the XML file.
            >
            > Keith
            >
            > <?xml version="1.0" encoding="utf-8" ?>
            > <DataSet xmlns=" http://apps.imercer.com/Mercer.Web.GetJobsObject/
            > <http://apps.imercer.com/Mercer.Web.GetJobsObject/> ">
            > <xs:schema id="JobsObjectData" xmlns=""
            > xmlns:xs=" http://www.w3.org/2001/XMLSchema
            > <http://www.w3.org/2001/XMLSchema> " xmlns:msdata="urn:schemas-
            > microsoft-com:xml-msdata">
            > <xs:element name="JobsObjectData" msdata:IsDataSet="true">
            > <xs:complexType>
            > <xs:choice maxOccurs="unbounded">
            > <xs:element name="Table">
            > <xs:complexType>
            > <xs:sequence>
            > <xs:element name="SET_ID" type="xs:string" minOccurs="0" />
            > <xs:element name="COMPANY_GROUP_CODE" type="xs:string"
            > minOccurs="0" />
            > <xs:element name="COMPANY_GROUP_NAME" type="xs:string"
            > minOccurs="0" />
            > <xs:element name="JOBCODE" type="xs:string" minOccurs="0" />
            > <xs:element name="JOBTITLE" type="xs:string" minOccurs="0" />
            > <xs:element name="CAPRI_CODE" type="xs:string" minOccurs="0" />
            > <xs:element name="CAPRI_NAME" type="xs:string" minOccurs="0" />
            > <xs:element name="SOC_CODE" type="xs:string" minOccurs="0" />
            > <xs:element name="SOC_NAME" type="xs:string" minOccurs="0" />
            > <xs:element name="JOB_GROUP" type="xs:string" minOccurs="0" />
            > <xs:element name="JOB_GROUP_DESC" type="xs:string"
            minOccurs="0" />
            > <xs:element name="JOB_FAMILY_CODE" type="xs:string"
            > minOccurs="0" />
            > <xs:element name="JOB_FAMILY_DESCRIPTION" type="xs:string"
            > minOccurs="0" />
            > <xs:element name="JOB_FAMILY_PURPOSE" type="xs:string"
            > minOccurs="0" />
            > <xs:element name="FLSA_CODE" type="xs:string" minOccurs="0" />
            > <xs:element name="FLSA_DESCRIPTION" type="xs:string"
            > minOccurs="0" />
            > <xs:element name="CAREER_LEVEL" type="xs:string" minOccurs="0" />
            > <xs:element name="JOB_FAMILY_RESPONSIBILITE" type="xs:string"
            > minOccurs="0" />
            > <xs:element name="KEY_RESPONSIBILITES" type="xs:string"
            > minOccurs="0" />
            > <xs:element name="EDUCATION" type="xs:string" minOccurs="0" />
            > <xs:element name="KNOWLEDGE" type="xs:string" minOccurs="0" />
            > <xs:element name="EXPERIENCE" type="xs:string" minOccurs="0" />
            > <xs:element name="DIRECTION_OF_OTHERS" type="xs:string"
            > minOccurs="0" />
            > <xs:element name="KEY_WORKING_RELATIONSHIPS" type="xs:string"
            > minOccurs="0" />
            > <xs:element name="SOC_SPECIFIC_RESPONSIBILI" type="xs:string"
            > minOccurs="0" />
            > <xs:element name="GRADE_LABEL" type="xs:string" minOccurs="0" />
            > <xs:element name="EEO_CATEGORY" type="xs:string" minOccurs="0" />
            > <xs:element name="EEO_GROUP" type="xs:string" minOccurs="0" />
            > <xs:element name="SOC_COMPETENCY_URL" type="xs:string"
            > minOccurs="0" />
            > <xs:element name="SOC_SALARY_STRUCTURE_URL" type="xs:string"
            > minOccurs="0" />
            > </xs:sequence>
            > </xs:complexType>
            > </xs:element>
            > </xs:choice>
            > </xs:complexType>
            > </xs:element>
            > </xs:schema>
            > <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-
            msdata"
            > xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
            > <JobsObjectData xmlns="">
            > <Table diffgr:id="Table1" msdata:rowOrder="0">
            > <SET_ID>050US</SET_ID>
            > <COMPANY_GROUP_CODE>SMS</COMPANY_GROUP_CODE>
            > <COMPANY_GROUP_NAME>SMS Group of Companies</COMPANY_GROUP_NAME>
            > <JOBCODE>AF105</JOBCODE>
            > <JOBTITLE>National Account Manager 2</JOBTITLE>
            > <CAPRI_CODE>100215</CAPRI_CODE>
            > <CAPRI_NAME>Business Development Specialist</CAPRI_NAME>
            > <JOB_GROUP>04</JOB_GROUP>
            > <JOB_GROUP_DESC>Sales</JOB_GROUP_DESC>
            > <JOB_FAMILY_CODE>1055</JOB_FAMILY_CODE>
            > <JOB_FAMILY_DESCRIPTION>Business Development
            > Specialist</JOB_FAMILY_DESCRIPTION>
            > <JOB_FAMILY_PURPOSE>Develops strategic business plans, marketing
            > programs, and partnerships to support sales in designated market
            > segments.</JOB_FAMILY_PURPOSE>
            > <FLSA_CODE>E</FLSA_CODE>
            > <FLSA_DESCRIPTION>Exempt</FLSA_DESCRIPTION>
            > <CAREER_LEVEL>3</CAREER_LEVEL>
            > <JOB_FAMILY_RESPONSIBILITE>> Develops business plans to support
            > market share objectives. > Applies an expert understanding of
            product
            > and/or system scope and application ¿ consulting with others as
            > required to provide a complete solution. > Provides advanced and
            > comprehensive technical application assistance in key sales
            > situations. > Applies current knowledge of competitive products and
            > competitors¿ activities ¿ recommending appropriate products to fill
            > application gaps. > Determines and implements pricing and bid
            > strategies. > Implements a profitable market
            > strategy.</JOB_FAMILY_RESPONSIBILITE>
            > <KEY_RESPONSIBILITES>> Performs full range of standard work for
            the
            > professional field. > Refers complex, unusual problems to others. >
            > Identifies and resolves more complex problems and applies problem-
            > solving skills in order to deal with most
            > situations.</KEY_RESPONSIBILITES>
            > <EDUCATION>Typically BS/BA in related discipline or advanced
            > degree. Certification may be required in some areas.</EDUCATION>
            > <KNOWLEDGE>> Demonstrates and applies a broad knowledge of field
            of
            > specialization through successful completion of moderately complex
            > assignments. > Successfully applies complex knowledge of
            fundamental
            > concepts, practices, and procedures of particular area of
            > specialization. > Demonstrates knowledge of organization's business
            > practices and issues.</KNOWLEDGE>
            > <EXPERIENCE>Typically 5-8 years of successful experience in
            related
            > field and successful demonstration of Key Responsibilities and
            > Knowledge as presented above. Advanced degree MAY be substituted
            for
            > experience, where applicable.</EXPERIENCE>
            > <DIRECTION_OF_OTHERS>Provides general guidance or train support
            > and/or professional staff.</DIRECTION_OF_OTHERS>
            > <KEY_WORKING_RELATIONSHIPS>Primarily intra-organizational
            contacts
            > and external contacts.</KEY_WORKING_RELATIONSHIPS>
            > <GRADE_LABEL>C</GRADE_LABEL>
            > <EEO_CATEGORY>2</EEO_CATEGORY>
            > <EEO_GROUP>M8</EEO_GROUP>
            > </Table>
            > <Table diffgr:id="Table2" msdata:rowOrder="1">
            > <SET_ID>050US</SET_ID>
            > <COMPANY_GROUP_CODE>SMS</COMPANY_GROUP_CODE>
            > <COMPANY_GROUP_NAME>SMS Group of Companies</COMPANY_GROUP_NAME>
            > <JOBCODE>940</JOBCODE>
            > <JOBTITLE>Account Executive III</JOBTITLE>
            > <CAPRI_CODE>100383</CAPRI_CODE>
            > <CAPRI_NAME>Account Representative</CAPRI_NAME>
            > <JOB_GROUP>04</JOB_GROUP>
            > <JOB_GROUP_DESC>Sales</JOB_GROUP_DESC>
            > <JOB_FAMILY_CODE>1027</JOB_FAMILY_CODE>
            > <JOB_FAMILY_DESCRIPTION>Account
            > Representative</JOB_FAMILY_DESCRIPTION>
            > <JOB_FAMILY_PURPOSE>Sells products, services, solutions to new
            > and/or existing customers and establishes and/or maintains customer
            > relationships.</JOB_FAMILY_PURPOSE>
            > <FLSA_CODE>E</FLSA_CODE>
            > <FLSA_DESCRIPTION>Exempt</FLSA_DESCRIPTION>
            > <CAREER_LEVEL>4</CAREER_LEVEL>
            > <JOB_FAMILY_RESPONSIBILITE>> Guides unit to achieve business
            > objectives at key accounts (for example, penetration of account
            with
            > product/solution/service offerings). > Leverages Siemens global
            reach
            > to influence decisions on projects for delivery to the customer in
            > the US, or purchased by the customer in the US. > Guides the
            > development and execution of strategic account plans to ensure
            > achievement of assigned business goals. > Develops / builds /
            > cultivates long-term relationships with key management within the
            > customer organization. > Assists management in devising sales plans
            > and strategies > May form account teams and coordinate team
            > activities while minimizing sales and marketing costs and
            maximizing
            > sales. > May lead team reviews and updates of account plan based on
            > changing market, customer conditions, and competitive
            > activity.</JOB_FAMILY_RESPONSIBILITE>
            > <KEY_RESPONSIBILITES>> Performs advanced areas of work for the
            > professional field. > Applies advanced skills to resolve complex
            > problems not covered by existing procedures or practices
            > independently. > Displays a high level of critical thinking in
            > bringing successful resolution to high-impact, complex, and/or
            cross-
            > functional problems.</KEY_RESPONSIBILITES>
            > <EDUCATION>Typically BS/BA in related discipline or advanced
            > degree. Certification may be required in some areas.</EDUCATION>
            > <KNOWLEDGE>> Demonstrates and applies comprehensive knowledge of
            > field of specialization to the successful completion of complex
            > assignments. > Demonstrates advanced knowledge of concepts,
            > practices, and procedures of particular area of specialization. >
            > Demonstrates significant knowledge of organization's business
            > practices and issues faced and contributes to problem resolution of
            > those issues.</KNOWLEDGE>
            > <EXPERIENCE>Typically 8-10 years of successful experience in
            > related field and successful demonstration of Key Responsibilities
            > and Knowledge as presented above. Advanced degree MAY be
            substituted
            > for experience, where applicable.</EXPERIENCE>
            > <DIRECTION_OF_OTHERS>Provides specialized guidance or train
            support
            > and/or professional staff. Leadership qualities and role model
            > qualities demonstrated.</DIRECTION_OF_OTHERS>
            > <KEY_WORKING_RELATIONSHIPS>Primarily intra-organizational
            contacts
            > and external contacts.</KEY_WORKING_RELATIONSHIPS>
            > <GRADE_LABEL>D</GRADE_LABEL>
            > <EEO_CATEGORY>4</EEO_CATEGORY>
            > <EEO_GROUP>04</EEO_GROUP>
            > </Table>
            > </JobsObjectData>
            > </diffgr:diffgram>
            > </DataSet>
            >
            >
            >
            > -----------------------------------------------------------------
            > This group is a forum for the discussion of the WSDL specification
            and its
            > implementation. Please stay on-topic.
            >
            >
            >
            > _____
            >
            > Yahoo! Groups Links
            >
            >
            > * To visit your group on the web, go to:
            > http://groups.yahoo.com/group/wsdl/
            <http://groups.yahoo.com/group/wsdl/>
            >
            >
            > * To unsubscribe from this group, send an email to:
            > wsdl-unsubscribe@yahoogroups.com
            > <mailto:wsdl-unsubscribe@yahoogroups.com?subject=Unsubscribe>
            >
            >
            > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
            Service
            > <http://docs.yahoo.com/info/terms/> .




            -----------------------------------------------------------------
            This group is a forum for the discussion of the WSDL specification and its
            implementation. Please stay on-topic.
            Yahoo! Groups Links
          • keith_d_savage
            Thanks Ann, I appreciate your taking the time to help. This is kind of a rhetorical question, but isn t the purpose of XML to enable data transformation in a
            Message 5 of 5 , May 4 8:46 AM
              Thanks Ann, I appreciate your taking the time to help. This is kind
              of a rhetorical question, but isn't the purpose of XML to enable data
              transformation in a platform-independent way? Why then would a web
              service be written in such a way that its results need to be
              processed via a specific platform?

              Sorry, that was two rhetorical questions...I will get on with seeing
              what I can do about taking a dive into .NET.

              Thanks,

              Keith



              --- In wsdl@yahoogroups.com, "Anne Thomas Manes" <anne@m...> wrote:
              > Keith,
              >
              > The Web service returns an ADO.NET Dataset. (See
              > http://msdn.microsoft.com/library/default.asp?url=/library/en-
              us/cpguide/htm
              > l/cpconoverviewofadonet.asp) I suggest that you build your client
              using
              > Visual Basic .NET. The VB.NET client can easily consume the Dataset
              and load
              > it into SQL Server for you. See these sample applications:
              >
              > Consuming a Dataset from a Web service:
              > http://msdn.microsoft.com/library/default.asp?url=/library/en-
              us/cpguide/htm
              > l/cpconconsumingdatasetfromwebservice.asp
              >
              > Processing a Dataset:
              > http://msdn.microsoft.com/library/default.asp?url=/library/en-
              us/cpguide/htm
              > l/cpconsampleapplication.asp
              >
              > Anne
              >
              > -----Original Message-----
              > From: keith_d_savage [mailto:keith_d_savage@y...]
              > Sent: Monday, May 03, 2004 1:47 PM
              > To: wsdl@yahoogroups.com
              > Subject: [wsdl] Re: direction in learning...
              >
              > Thank you sooo much for the quick response! The only two ways I
              know
              > how to implement a client is through visual basic (using MSXML) or
              > through a stored procedure (using sp_xml_preparedocument). I've
              been
              > unsuccessful in using either of these so far, and have no java
              > or .Net experience.
              >
              > Here is the what the .wsdl file looks like. I really cannot say
              > enough how much I appreciate the reply.
              >
              > Keith
              >
              > <?xml version="1.0" encoding="utf-8"?>
              > <definitions xmlns:http="http://schemas.xmlsoap.org/wsdl/http/"
              > xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
              > xmlns:s="http://www.w3.org/2001/XMLSchema"
              > xmlns:s0="http://apps.imercer.com/Mercer.Web.GetJobsObject/"
              > xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
              > xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/"
              > xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/"
              > targetNamespace="http://apps.imercer.com/Mercer.Web.GetJobsObject/"
              > xmlns="http://schemas.xmlsoap.org/wsdl/">
              > <types>
              > <s:schema elementFormDefault="qualified"
              > targetNamespace="http://apps.imercer.com/Mercer.Web.GetJobsObject/">
              > <s:import namespace="http://www.w3.org/2001/XMLSchema" />
              > <s:element name="Execute">
              > <s:complexType>
              > <s:sequence>
              > <s:element minOccurs="0" maxOccurs="1" name="UserName"
              > type="s:string" />
              > <s:element minOccurs="0" maxOccurs="1" name="Password"
              > type="s:string" />
              > <s:element minOccurs="0" maxOccurs="1" name="Filter"
              > type="s:string" />
              > </s:sequence>
              > </s:complexType>
              > </s:element>
              > <s:element name="ExecuteResponse">
              > <s:complexType>
              > <s:sequence>
              > <s:element minOccurs="0" maxOccurs="1"
              > name="ExecuteResult">
              > <s:complexType>
              > <s:sequence>
              > <s:element ref="s:schema" />
              > <s:any />
              > </s:sequence>
              > </s:complexType>
              > </s:element>
              > </s:sequence>
              > </s:complexType>
              > </s:element>
              > <s:element name="DataSet" nillable="true">
              > <s:complexType>
              > <s:sequence>
              > <s:element ref="s:schema" />
              > <s:any />
              > </s:sequence>
              > </s:complexType>
              > </s:element>
              > </s:schema>
              > </types>
              > <message name="ExecuteSoapIn">
              > <part name="parameters" element="s0:Execute" />
              > </message>
              > <message name="ExecuteSoapOut">
              > <part name="parameters" element="s0:ExecuteResponse" />
              > </message>
              > <message name="ExecuteHttpGetIn">
              > <part name="UserName" type="s:string" />
              > <part name="Password" type="s:string" />
              > <part name="Filter" type="s:string" />
              > </message>
              > <message name="ExecuteHttpGetOut">
              > <part name="Body" element="s0:DataSet" />
              > </message>
              > <message name="ExecuteHttpPostIn">
              > <part name="UserName" type="s:string" />
              > <part name="Password" type="s:string" />
              > <part name="Filter" type="s:string" />
              > </message>
              > <message name="ExecuteHttpPostOut">
              > <part name="Body" element="s0:DataSet" />
              > </message>
              > <portType name="GetJobsObjectSoap">
              > <operation name="Execute">
              > <documentation>Executes a query on the Jobs CPA object in a
              > given user's data dictionary.</documentation>
              > <input message="s0:ExecuteSoapIn" />
              > <output message="s0:ExecuteSoapOut" />
              > </operation>
              > </portType>
              > <portType name="GetJobsObjectHttpGet">
              > <operation name="Execute">
              > <documentation>Executes a query on the Jobs CPA object in a
              > given user's data dictionary.</documentation>
              > <input message="s0:ExecuteHttpGetIn" />
              > <output message="s0:ExecuteHttpGetOut" />
              > </operation>
              > </portType>
              > <portType name="GetJobsObjectHttpPost">
              > <operation name="Execute">
              > <documentation>Executes a query on the Jobs CPA object in a
              > given user's data dictionary.</documentation>
              > <input message="s0:ExecuteHttpPostIn" />
              > <output message="s0:ExecuteHttpPostOut" />
              > </operation>
              > </portType>
              > <binding name="GetJobsObjectSoap" type="s0:GetJobsObjectSoap">
              > <soap:binding transport="http://schemas.xmlsoap.org/soap/http"
              > style="document" />
              > <operation name="Execute">
              > <soap:operation
              >
              soapAction="http://apps.imercer.com/Mercer.Web.GetJobsObject/Execute"
              > style="document" />
              > <input>
              > <soap:body use="literal" />
              > </input>
              > <output>
              > <soap:body use="literal" />
              > </output>
              > </operation>
              > </binding>
              > <binding name="GetJobsObjectHttpGet"
              type="s0:GetJobsObjectHttpGet">
              > <http:binding verb="GET" />
              > <operation name="Execute">
              > <http:operation location="/Execute" />
              > <input>
              > <http:urlEncoded />
              > </input>
              > <output>
              > <mime:mimeXml part="Body" />
              > </output>
              > </operation>
              > </binding>
              > <binding name="GetJobsObjectHttpPost"
              > type="s0:GetJobsObjectHttpPost">
              > <http:binding verb="POST" />
              > <operation name="Execute">
              > <http:operation location="/Execute" />
              > <input>
              > <mime:content type="application/x-www-form-urlencoded" />
              > </input>
              > <output>
              > <mime:mimeXml part="Body" />
              > </output>
              > </operation>
              > </binding>
              > <service name="GetJobsObject">
              > <documentation>Accesses the Jobs CPA object.</documentation>
              > <port name="GetJobsObjectSoap" binding="s0:GetJobsObjectSoap">
              > <soap:address
              > location="http://gisqawebclstr/GetJobsObject/GetJobsObject.asmx" />
              > </port>
              > <port name="GetJobsObjectHttpGet"
              > binding="s0:GetJobsObjectHttpGet">
              > <http:address
              > location="http://gisqawebclstr/GetJobsObject/GetJobsObject.asmx" />
              > </port>
              > <port name="GetJobsObjectHttpPost"
              > binding="s0:GetJobsObjectHttpPost">
              > <http:address
              > location="http://gisqawebclstr/GetJobsObject/GetJobsObject.asmx" />
              > </port>
              > </service>
              > </definitions>
              >
              >
              >
              >
              >
              >
              >
              >
              >
              >
              >
              >
              >
              >
              >
              > --- In wsdl@yahoogroups.com, Graeme Riddell <griddell@b...> wrote:
              > >
              > > I see the "msdata" attribute in the XML response, suggesting this
              > is a .Net
              > > web service. Are you using .Net to implement your client or do
              you
              > have a
              > > Java toolset (WSAD, Systinet, BowStreet, Axis, etc)? At a high
              > level it
              > > doesn't really matter, you'll have a tool that consumes that WSDL
              > doc and
              > > creates some artifacts that at runtime will make the service call
              > and give
              > > you your XML file. (Ready for your next task of loading into
              > SqlServer ;-)
              > > ). But knowing the tool you're using will help us give a more
              > focused
              > > response to your question. Can you post the wsdl doc too just for
              > grins?
              > >
              > > -gr
              > >
              > >
              > >
              > >
              > > -----Original Message-----
              > > From: keith_d_savage [mailto:keith_d_savage@y...]
              > > Sent: Monday, May 03, 2004 12:01 PM
              > > To: wsdl@yahoogroups.com
              > > Subject: [wsdl] direction in learning...
              > >
              > >
              > > Hi!
              > >
              > > So glad to see that this group exists...I've been given a
              challenge
              > > at work that involves processing the contents of an xml file and
              > > conditionally loading it into a SQL Server database. "No
              problem"
              > I
              > > first thought, having worked some with xml files beofre.
              > >
              > > Turns out that this xml file will come to us via web serice,
              which
              > I
              > > grasp the concept of but have never actually used. I was also
              > given
              > > a sample of the XML file and a file with a ".wsdl" extension. I
              > was
              > > told I'll need that, but was not told what for. Anyway, the XML
              > file
              > > was not at all what I expected and I am not sure how to handle
              all
              > of
              > > this. If someone could be so kind as to give me some direction,
              or
              > > even recommend some specific "cut to the chase" literature or
              > > resources on how to get this done, I would REALLY appreciate it!
              > > Please respond here or to my email address of
              > > keith_d_savage@y...
              > >
              > > Below if a sample of the XML file.
              > >
              > > Keith
              > >
              > > <?xml version="1.0" encoding="utf-8" ?>
              > > <DataSet xmlns=" http://apps.imercer.com/Mercer.Web.GetJobsObject/
              > > <http://apps.imercer.com/Mercer.Web.GetJobsObject/> ">
              > > <xs:schema id="JobsObjectData" xmlns=""
              > > xmlns:xs=" http://www.w3.org/2001/XMLSchema
              > > <http://www.w3.org/2001/XMLSchema> " xmlns:msdata="urn:schemas-
              > > microsoft-com:xml-msdata">
              > > <xs:element name="JobsObjectData" msdata:IsDataSet="true">
              > > <xs:complexType>
              > > <xs:choice maxOccurs="unbounded">
              > > <xs:element name="Table">
              > > <xs:complexType>
              > > <xs:sequence>
              > > <xs:element name="SET_ID" type="xs:string" minOccurs="0" />
              > > <xs:element name="COMPANY_GROUP_CODE" type="xs:string"
              > > minOccurs="0" />
              > > <xs:element name="COMPANY_GROUP_NAME" type="xs:string"
              > > minOccurs="0" />
              > > <xs:element name="JOBCODE" type="xs:string" minOccurs="0" />
              > > <xs:element name="JOBTITLE" type="xs:string" minOccurs="0" />
              > > <xs:element name="CAPRI_CODE" type="xs:string" minOccurs="0" />
              > > <xs:element name="CAPRI_NAME" type="xs:string" minOccurs="0" />
              > > <xs:element name="SOC_CODE" type="xs:string" minOccurs="0" />
              > > <xs:element name="SOC_NAME" type="xs:string" minOccurs="0" />
              > > <xs:element name="JOB_GROUP" type="xs:string" minOccurs="0" />
              > > <xs:element name="JOB_GROUP_DESC" type="xs:string"
              > minOccurs="0" />
              > > <xs:element name="JOB_FAMILY_CODE" type="xs:string"
              > > minOccurs="0" />
              > > <xs:element name="JOB_FAMILY_DESCRIPTION" type="xs:string"
              > > minOccurs="0" />
              > > <xs:element name="JOB_FAMILY_PURPOSE" type="xs:string"
              > > minOccurs="0" />
              > > <xs:element name="FLSA_CODE" type="xs:string" minOccurs="0" />
              > > <xs:element name="FLSA_DESCRIPTION" type="xs:string"
              > > minOccurs="0" />
              > > <xs:element name="CAREER_LEVEL" type="xs:string"
              minOccurs="0" />
              > > <xs:element name="JOB_FAMILY_RESPONSIBILITE" type="xs:string"
              > > minOccurs="0" />
              > > <xs:element name="KEY_RESPONSIBILITES" type="xs:string"
              > > minOccurs="0" />
              > > <xs:element name="EDUCATION" type="xs:string" minOccurs="0" />
              > > <xs:element name="KNOWLEDGE" type="xs:string" minOccurs="0" />
              > > <xs:element name="EXPERIENCE" type="xs:string" minOccurs="0" />
              > > <xs:element name="DIRECTION_OF_OTHERS" type="xs:string"
              > > minOccurs="0" />
              > > <xs:element name="KEY_WORKING_RELATIONSHIPS" type="xs:string"
              > > minOccurs="0" />
              > > <xs:element name="SOC_SPECIFIC_RESPONSIBILI" type="xs:string"
              > > minOccurs="0" />
              > > <xs:element name="GRADE_LABEL" type="xs:string"
              minOccurs="0" />
              > > <xs:element name="EEO_CATEGORY" type="xs:string"
              minOccurs="0" />
              > > <xs:element name="EEO_GROUP" type="xs:string" minOccurs="0" />
              > > <xs:element name="SOC_COMPETENCY_URL" type="xs:string"
              > > minOccurs="0" />
              > > <xs:element name="SOC_SALARY_STRUCTURE_URL" type="xs:string"
              > > minOccurs="0" />
              > > </xs:sequence>
              > > </xs:complexType>
              > > </xs:element>
              > > </xs:choice>
              > > </xs:complexType>
              > > </xs:element>
              > > </xs:schema>
              > > <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-
              > msdata"
              > > xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
              > > <JobsObjectData xmlns="">
              > > <Table diffgr:id="Table1" msdata:rowOrder="0">
              > > <SET_ID>050US</SET_ID>
              > > <COMPANY_GROUP_CODE>SMS</COMPANY_GROUP_CODE>
              > > <COMPANY_GROUP_NAME>SMS Group of Companies</COMPANY_GROUP_NAME>
              > > <JOBCODE>AF105</JOBCODE>
              > > <JOBTITLE>National Account Manager 2</JOBTITLE>
              > > <CAPRI_CODE>100215</CAPRI_CODE>
              > > <CAPRI_NAME>Business Development Specialist</CAPRI_NAME>
              > > <JOB_GROUP>04</JOB_GROUP>
              > > <JOB_GROUP_DESC>Sales</JOB_GROUP_DESC>
              > > <JOB_FAMILY_CODE>1055</JOB_FAMILY_CODE>
              > > <JOB_FAMILY_DESCRIPTION>Business Development
              > > Specialist</JOB_FAMILY_DESCRIPTION>
              > > <JOB_FAMILY_PURPOSE>Develops strategic business plans,
              marketing
              > > programs, and partnerships to support sales in designated market
              > > segments.</JOB_FAMILY_PURPOSE>
              > > <FLSA_CODE>E</FLSA_CODE>
              > > <FLSA_DESCRIPTION>Exempt</FLSA_DESCRIPTION>
              > > <CAREER_LEVEL>3</CAREER_LEVEL>
              > > <JOB_FAMILY_RESPONSIBILITE>> Develops business plans to support
              > > market share objectives. > Applies an expert understanding of
              > product
              > > and/or system scope and application ¿ consulting with others as
              > > required to provide a complete solution. > Provides advanced and
              > > comprehensive technical application assistance in key sales
              > > situations. > Applies current knowledge of competitive products
              and
              > > competitors¿ activities ¿ recommending appropriate products to
              fill
              > > application gaps. > Determines and implements pricing and bid
              > > strategies. > Implements a profitable market
              > > strategy.</JOB_FAMILY_RESPONSIBILITE>
              > > <KEY_RESPONSIBILITES>> Performs full range of standard work for
              > the
              > > professional field. > Refers complex, unusual problems to others.
              >
              > > Identifies and resolves more complex problems and applies problem-
              > > solving skills in order to deal with most
              > > situations.</KEY_RESPONSIBILITES>
              > > <EDUCATION>Typically BS/BA in related discipline or advanced
              > > degree. Certification may be required in some areas.</EDUCATION>
              > > <KNOWLEDGE>> Demonstrates and applies a broad knowledge of
              field
              > of
              > > specialization through successful completion of moderately
              complex
              > > assignments. > Successfully applies complex knowledge of
              > fundamental
              > > concepts, practices, and procedures of particular area of
              > > specialization. > Demonstrates knowledge of organization's
              business
              > > practices and issues.</KNOWLEDGE>
              > > <EXPERIENCE>Typically 5-8 years of successful experience in
              > related
              > > field and successful demonstration of Key Responsibilities and
              > > Knowledge as presented above. Advanced degree MAY be substituted
              > for
              > > experience, where applicable.</EXPERIENCE>
              > > <DIRECTION_OF_OTHERS>Provides general guidance or train support
              > > and/or professional staff.</DIRECTION_OF_OTHERS>
              > > <KEY_WORKING_RELATIONSHIPS>Primarily intra-organizational
              > contacts
              > > and external contacts.</KEY_WORKING_RELATIONSHIPS>
              > > <GRADE_LABEL>C</GRADE_LABEL>
              > > <EEO_CATEGORY>2</EEO_CATEGORY>
              > > <EEO_GROUP>M8</EEO_GROUP>
              > > </Table>
              > > <Table diffgr:id="Table2" msdata:rowOrder="1">
              > > <SET_ID>050US</SET_ID>
              > > <COMPANY_GROUP_CODE>SMS</COMPANY_GROUP_CODE>
              > > <COMPANY_GROUP_NAME>SMS Group of Companies</COMPANY_GROUP_NAME>
              > > <JOBCODE>940</JOBCODE>
              > > <JOBTITLE>Account Executive III</JOBTITLE>
              > > <CAPRI_CODE>100383</CAPRI_CODE>
              > > <CAPRI_NAME>Account Representative</CAPRI_NAME>
              > > <JOB_GROUP>04</JOB_GROUP>
              > > <JOB_GROUP_DESC>Sales</JOB_GROUP_DESC>
              > > <JOB_FAMILY_CODE>1027</JOB_FAMILY_CODE>
              > > <JOB_FAMILY_DESCRIPTION>Account
              > > Representative</JOB_FAMILY_DESCRIPTION>
              > > <JOB_FAMILY_PURPOSE>Sells products, services, solutions to new
              > > and/or existing customers and establishes and/or maintains
              customer
              > > relationships.</JOB_FAMILY_PURPOSE>
              > > <FLSA_CODE>E</FLSA_CODE>
              > > <FLSA_DESCRIPTION>Exempt</FLSA_DESCRIPTION>
              > > <CAREER_LEVEL>4</CAREER_LEVEL>
              > > <JOB_FAMILY_RESPONSIBILITE>> Guides unit to achieve business
              > > objectives at key accounts (for example, penetration of account
              > with
              > > product/solution/service offerings). > Leverages Siemens global
              > reach
              > > to influence decisions on projects for delivery to the customer
              in
              > > the US, or purchased by the customer in the US. > Guides the
              > > development and execution of strategic account plans to ensure
              > > achievement of assigned business goals. > Develops / builds /
              > > cultivates long-term relationships with key management within the
              > > customer organization. > Assists management in devising sales
              plans
              > > and strategies > May form account teams and coordinate team
              > > activities while minimizing sales and marketing costs and
              > maximizing
              > > sales. > May lead team reviews and updates of account plan based
              on
              > > changing market, customer conditions, and competitive
              > > activity.</JOB_FAMILY_RESPONSIBILITE>
              > > <KEY_RESPONSIBILITES>> Performs advanced areas of work for the
              > > professional field. > Applies advanced skills to resolve complex
              > > problems not covered by existing procedures or practices
              > > independently. > Displays a high level of critical thinking in
              > > bringing successful resolution to high-impact, complex, and/or
              > cross-
              > > functional problems.</KEY_RESPONSIBILITES>
              > > <EDUCATION>Typically BS/BA in related discipline or advanced
              > > degree. Certification may be required in some areas.</EDUCATION>
              > > <KNOWLEDGE>> Demonstrates and applies comprehensive knowledge
              of
              > > field of specialization to the successful completion of complex
              > > assignments. > Demonstrates advanced knowledge of concepts,
              > > practices, and procedures of particular area of specialization. >
              > > Demonstrates significant knowledge of organization's business
              > > practices and issues faced and contributes to problem resolution
              of
              > > those issues.</KNOWLEDGE>
              > > <EXPERIENCE>Typically 8-10 years of successful experience in
              > > related field and successful demonstration of Key
              Responsibilities
              > > and Knowledge as presented above. Advanced degree MAY be
              > substituted
              > > for experience, where applicable.</EXPERIENCE>
              > > <DIRECTION_OF_OTHERS>Provides specialized guidance or train
              > support
              > > and/or professional staff. Leadership qualities and role model
              > > qualities demonstrated.</DIRECTION_OF_OTHERS>
              > > <KEY_WORKING_RELATIONSHIPS>Primarily intra-organizational
              > contacts
              > > and external contacts.</KEY_WORKING_RELATIONSHIPS>
              > > <GRADE_LABEL>D</GRADE_LABEL>
              > > <EEO_CATEGORY>4</EEO_CATEGORY>
              > > <EEO_GROUP>04</EEO_GROUP>
              > > </Table>
              > > </JobsObjectData>
              > > </diffgr:diffgram>
              > > </DataSet>
              > >
              > >
              > >
              > > -----------------------------------------------------------------
              > > This group is a forum for the discussion of the WSDL
              specification
              > and its
              > > implementation. Please stay on-topic.
              > >
              > >
              > >
              > > _____
              > >
              > > Yahoo! Groups Links
              > >
              > >
              > > * To visit your group on the web, go to:
              > > http://groups.yahoo.com/group/wsdl/
              > <http://groups.yahoo.com/group/wsdl/>
              > >
              > >
              > > * To unsubscribe from this group, send an email to:
              > > wsdl-unsubscribe@yahoogroups.com
              > > <mailto:wsdl-unsubscribe@yahoogroups.com?subject=Unsubscribe>
              > >
              > >
              > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
              > Service
              > > <http://docs.yahoo.com/info/terms/> .
              >
              >
              >
              >
              > -----------------------------------------------------------------
              > This group is a forum for the discussion of the WSDL specification
              and its
              > implementation. Please stay on-topic.
              > Yahoo! Groups Links
            Your message has been successfully submitted and would be delivered to recipients shortly.