April 9, 2009 at 2:44 am
Hi,
I have an XML which needs to be transferred to tables. I don't have any specific table to transfer here. I just have an XML and test database. I wanted to transfer XML data to temporary table and then I wanted to utilize the temporary table data for my purpose. Is there any way that I can import the data from XML to table / tables (if XML has multiple nodes)?
Thanks in advance.
Mahesh
April 11, 2009 at 1:03 pm
Can someone help me on this? I am posting my XML file here
-
-
-
-
-
April 11, 2009 at 1:04 pm
Can someone help me on this? I am posting XML here
(?xml version="1.0" encoding="UTF-8" ?>
(?test-Property-Set EscapeNames="false"?>
- (testMessage xmlns="http://schemas.microsoft.it.relationshipmanagement/2007/test/testaccountmessage" TimeZone="W. Europe Standard Time" SegmentationNewId="1+7CP4+0" IsPrimaryChange="" UserId="1-PMIZNX" SubsidiaryNewId="1-8471-22" SegmentationOldId="1+7CP4+0" SubsidiaryOldName="Germany" MessageId="1-12DR9S" SubsidiaryNewName="Germany" Action="Update" EntityName="testaccountPARTNER" IntObjectName="MSCRM testaccount Partner IO" MessageType="Integration Object" Source="test" IntObjectFormat="test Hierarchical" UserAlias="V-CHBEND" LastUpdated="03/18/2009 13:23:43" SubsidiaryOldId="1-8471-22">
- (ListOftestaccountIo>
- (testaccount xmlns="http://schemas.microsoft.it.relationshipmanagement/2007/test/testaccount">
(testaccountId>1-PP93T8(/testaccountId>
(Created>11/21/2008 02:43:13(/Created>
(Modified>11/24/2008 04:56:04(/Modified>
(AccountId>1-42OAQ(/AccountId>
(CurrencyCode>EUR(/CurrencyCode>
(Description>Mayer &60x Office deployment(/Description>
(MSAtRisk>N(/MSAtRisk>
(MSClosedDate />
(MSCustomerConsentforDataTransmission>N(/MSCustomerConsentforDataTransmission>
(MSDueDate>04/18/2009 15:00:00(/MSDueDate>
(SalesStageDate>11/21/2008 00:00:00(/SalesStageDate>
(Status>Active(/Status>
- (ListOftestaccountPartner>
- (testaccountPartner xmlns="http://schemas.microsoft.it.relationshipmanagement/2007/test/testaccountpartner" IsPrimaryMVG="Y">
(Id>1-PPC5G7(/Id>
(Created>11/21/2008 03:12:40(/Created>
(AccountId>13-2R20(/AccountId>
(Comments />
(CompetitorPartner />
(Forecast>Y(/Forecast>
(MSPSP />
(MSPartnerHardwareRevenue>0(/MSPartnerHardwareRevenue>
(MSPartnerSalesStageandDueDateRestrict>N(/MSPartnerSalesStageandDueDateRestrict>
(Outcome />
(PartnerProductRevenue>0(/PartnerProductRevenue>
(PartnerServicesRevenue>0(/PartnerServicesRevenue>
(Rating />
(Role />
(ServicesRelationship />
(SolutionName />
(Status>Removed(/Status>
(/testaccountPartner>
(/ListOftestaccountPartner>
(/testaccount>
(/ListOftestaccountIo>
(/testMessage>
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply