Re: Mappping source xml to destination element ?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Finally i hv done my things,Thanks for all ur suggestions.
Reason for not to work, may be: "OutputMessage.Parameters."
1..Chk fileds/attributes ur trying to access through
"OutputMessage.Parameters." is avilable in ur schema r not.
2.if there pls please promote them as distinguished fileds.

Reason for my issue is:
There is no XML data element in my SP while generating the schema.
So i hv added them(elements) manually to my reponse element of SP Schema by
looking into xml out put generated from SP.

If this is not working ,Pls send ur details steps of wt ur doing






"Jayendra" wrote:

> HI,
> "OutputMessage.Parameters."
>
> Ur trying to write above exprssion after getting response from SP,Right ?
> Even myself is facing the same problm,I think this is bcs actual response
> elements in the schema generated wizard is different from the results what ur
> SP is returning.
>
> Today iwill wk on it ..and reply bk ..:)
> jay..
>
>
>
>
>
>
> "Jyoti Khetan" wrote:
>
> > Thanks For the reply, but somehow I am not able to type cast my varaiable to
> > string.. The intellisense just shows
> >
> > OutputMessage.Parameters.
> >
> > It does not allw me to go deeper into the nodes.. So while type casting I
> > get the error that
> > "Cannot convert Request object to String."
> >
> > So this statement
> >
> > Outputmessage.request.customer.customerdata=System.comvert.string(Var_incomingmsg.InnerXml);
> >
> > is not working...Do you have any idea why this is happening?
> > Regards
> > Jyoti
> >
> >
> > "Jayendra" <Jayendra@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:CA4D5C6D-4515-47DC-A938-241BF693BCA8@xxxxxxxxxxxxxxxx
> > >i got it,
> > > 1)Jst create variable of type (xml doc) and assign ur incoming schema
> > > instance to it.
> > > 2)Assaign this variable to multipart message by type casting to string
> > > type.
> > >
> > > eg:
> > > Var_incomingmsg=msg_incoming;
> > > Outputmessage.request.customer.customerdata=System.comvert.string(Var_incomingmsg.InnerXml);
> > >
> > >
> > > Hoping u too will get it,Thanks once again
> > > Jayendra
> > >
> > >
> > > "Jyoti Khetan" wrote:
> > >
> > >> Hey Jayendra,
> > >>
> > >> I am facing the same problem. I am not able to map the entire XML
> > >> document
> > >> to a schema node. Nor could I find a way to open a file through a stored
> > >> procedure.
> > >>
> > >> What I have done for the time being is this:
> > >> 1. I have created a source schema with a node of type xs:anyURI.
> > >> 2. Here I pass the URI of the XML document.
> > >> 3. Next I created a DLL which takes as parameter a file URI and returns
> > >> the
> > >> entire text of the file as string.
> > >> 4. I called this DLL from a fuctoid in my mapper which takes the URI
> > >> from
> > >> the source schema and returns the XML string to the destination schema.
> > >> 5. Thus I have the entire XML doc in a schema node attribute, which can
> > >> be
> > >> passed to a SP
> > >>
> > >> This method works fine, the only problem being, that the URI is fixed.
> > >> I am still working on it. If I find a solution, I will let u know, u do
> > >> the
> > >> same please.
> > >>
> > >> Regards,
> > >> Jyoti
> > >>
> > >> "Jayendra" <Jayendra@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > >> news:9DE9E35D-68AD-46C3-857B-66E1AFFF0BC6@xxxxxxxxxxxxxxxx
> > >> > My requirement is to pass entire incoming xml doc(Customer.xsd) as
> > >> > parameter
> > >> > to SP multipart message(Customer_req).
> > >> > One of the parm in Customer_req (SP message)takes customer.xml
> > >> > (Customer.xsd).
> > >> >
> > >> > Then how to map this entire incoming(customer.xml) to destination
> > >> > shcema(SP)
> > >> > elment.
> > >> >
> > >> >
> > >> > Thanks for reply,
> > >> > Jay..
> > >> >
> > >> > "BA" wrote:
> > >> >
> > >> >>
> > >> >> It sounds like a direct mapping. Maybe you haven't generated another
> > >> >> schema?
> > >> >>
> > >> >> Your explanation needs to be more detailed
> > >> >>
> > >> >> BA
> > >> >>
> > >> >>
> > >> >> "Jayendra" <Jayendra@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > >> >> news:D52AD22D-927A-46D3-87F0-EF27EAC25BED@xxxxxxxxxxxxxxxx
> > >> >> > Can any one helpme in mapping source xml file to destination schema
> > >> >> element.
> > >> >> >
> > >> >> > Source:XML
> > >> >> >
> > >> >> > <customersdata>
> > >> >> > <customers>
> > >> >> > <custname/>
> > >> >> > <custage/>
> > >> >> > </custoemrs>
> > >> >> >
> > >> >> >
> > >> >> > </customersdata>
> > >> >> >
> > >> >> >
> > >> >> > Expected destiantion :XMl
> > >> >> >
> > >> >> >
> > >> >> > In the above file root data info(customers) must be copied to
> > >> >> customersdata
> > >> >> > elment in destination schema.
> > >> >> >
> > >> >> > Can any one helpme..
> > >> >> >
> > >> >> > Jay,,
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >
.

Relevant Pages

  • Re: Update Row question
    ... Usually, one would do this with multiple columns, but I suspect that in your case, the reason for confusion is that the gamut of information is not known in advance. ... It is most likely to work for you, and will fit in easily with any schema - including your apparently gratuitous use of an identity column and row number ... follow ISO-11179 data element naming ... If you don't know anything about RDBMS, then get a copy of the ...
    (microsoft.public.sqlserver.programming)
  • Re: Update Row question
    ... the reason for confusion is that the gamut of information is not known in advance. ... It is most likely to work for you, and will fit in easily with any schema - including your apparently gratuitous use of an identity column and row number ... follow ISO-11179 data element naming ... If you don't know anything about RDBMS, then get a copy of the ...
    (microsoft.public.sqlserver.programming)
  • Re: Problem with creating classes as runtime - PLEASE HELP
    ... represent the data and set a propertyGrid control's SelectedObject ... Then I can serialize the runtime class to create my XML ... file that conforms to the schema I was originally given. ... The reason for the Collection class is for nested elements in the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Error reading XML file through XML Receive default pipeline
    ... otherwise it has to be a bug. ... And in this case it was my mistake. ... I can't recall the reason but it was something gross ). ... Like applying a different schema... ...
    (microsoft.public.biztalk.general)
  • Re: There MUST be a better way...
    ... Instead of manually modifying the huge file that will be generated, ... all public properties and be ready to data bind to the DataGrid ... > You may also need Response Content, Response Form (depending on what your ... > Save each of these schema to a separate XSD file. ...
    (microsoft.public.dotnet.xml)