Gå til innhold

Splitte opp xml fil med Biztalk.

bønna35

Av bønna35
i Datamaskiner

Anbefalte innlegg

bønna35

bønna35

Skrevet
Skrevet

Har en xml fil som inneholder 3 records.

 

<?xml version="1.0" encoding="utf-16" ?>

- <INVRPT xmlns="http://test.splitt">

<LAGRAP RCDID="DCINV" FIRMK="01" EDILN="9156421" KUNNR="0002632211" KNEDI="003701113816" VARNR="BG586" TRKKD="78" TRKEN="2" TRKAN="6" TRNEG="0" TRKBC="20090714-220952" KUNBC="825A1VDN99" FIFOD="20090714" KNVNR="" KNPNR="300123430155771202" FLAG2="B" TRKAS="" TRKDT="1090623" TRKTI="1433" DCTRK="-B" BEMRK="" FRAVN="" FRABC="" RVSKD="" ACIN1="" ACIN2="" ACIN3="" RECNR="17390" />

<LAGRAP RCDID="DCINV" FIRMK="01" EDILN="9156421" KUNNR="0002632211" KNEDI="003701113816" VARNR="BG586" TRKKD="78" TRKEN="2" TRKAN="48" TRNEG="0" TRKBC="20090714-220952" KUNBC="825A1VDN99" FIFOD="20090714" KNVNR="" KNPNR="" FLAG2="B" TRKAS="" TRKDT="1090623" TRKTI="1433" DCTRK="-B" BEMRK="" FRAVN="" FRABC="" RVSKD="" ACIN1="" ACIN2="" ACIN3="" RECNR="17391" />

<LAGRAP RCDID="DCINV" FIRMK="01" EDILN="9156422" KUNNR="0002632211" KNEDI="003701113816" VARNR="CW553" TRKKD="78" TRKEN="2" TRKAN="100" TRNEG="0" TRKBC="20111012-220819" KUNBC="806E1DEN99" FIFOD="20111012" KNVNR="CW553" KNPNR="" FLAG2="B" TRKAS="" TRKDT="1090623" TRKTI="1434" DCTRK="-B" BEMRK="" FRAVN="" FRABC="" RVSKD="" ACIN1="" ACIN2="" ACIN3="" RECNR="17392" />

</INVRPT>

 

 

Denne filen skal jeg dele opp slik, så att den lager 3 xml filer med 1 records i hver.

 

Her er skjema som jeg bruker, når jeg leser xml filen inn i Biztalk.

 

 

<?xml version="1.0" encoding="utf-16" ?>

- <xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://test.splitt" xmlns:xs="http://www.w3.org/2001/XMLSchema">

- <xs:element name="INVRPT">

- <xs:complexType>

- <xs:sequence>

- <xs:element maxOccurs="unbounded" name="LAGRAP">

- <xs:complexType>

<xs:attribute name="RCDID" type="xs:string" use="required" />

<xs:attribute name="FIRMK" type="xs:unsignedByte" use="required" />

<xs:attribute name="EDILN" type="xs:unsignedInt" use="required" />

<xs:attribute name="KUNNR" type="xs:unsignedInt" use="required" />

<xs:attribute name="KNEDI" type="xs:unsignedInt" use="required" />

<xs:attribute name="VARNR" type="xs:string" use="required" />

<xs:attribute name="TRKKD" type="xs:unsignedByte" use="required" />

<xs:attribute name="TRKEN" type="xs:unsignedByte" use="required" />

<xs:attribute name="TRKAN" type="xs:unsignedByte" use="required" />

<xs:attribute name="TRNEG" type="xs:unsignedByte" use="required" />

<xs:attribute name="TRKBC" type="xs:string" use="required" />

<xs:attribute name="KUNBC" type="xs:string" use="required" />

<xs:attribute name="FIFOD" type="xs:unsignedInt" use="required" />

<xs:attribute name="KNVNR" type="xs:string" use="required" />

<xs:attribute name="KNPNR" type="xs:string" use="required" />

<xs:attribute name="FLAG2" type="xs:string" use="required" />

<xs:attribute name="TRKAS" type="xs:string" use="required" />

<xs:attribute name="TRKDT" type="xs:unsignedInt" use="required" />

<xs:attribute name="TRKTI" type="xs:unsignedShort" use="required" />

<xs:attribute name="DCTRK" type="xs:string" use="required" />

<xs:attribute name="BEMRK" type="xs:string" use="required" />

<xs:attribute name="FRAVN" type="xs:string" use="required" />

<xs:attribute name="FRABC" type="xs:string" use="required" />

<xs:attribute name="RVSKD" type="xs:string" use="required" />

<xs:attribute name="ACIN1" type="xs:string" use="required" />

<xs:attribute name="ACIN2" type="xs:string" use="required" />

<xs:attribute name="ACIN3" type="xs:string" use="required" />

<xs:attribute name="RECNR" type="xs:unsignedShort" use="required" />

</xs:complexType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>

 

 

Så har jeg laget ett Envelope skjema, som ser slik ut.

 

Her har jeg valgt att det skal være ett Envelope skjema.

 

Jeg har satt body_xpath til: "/*[local-name()=Record' and namespace-uri()='http://test.splitt]"

 

 

<?xml version="1.0" encoding="utf-16" ?>

- <xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://test.splitt" xmlns:xs="http://www.w3.org/2001/XMLSchema">

- <xs:annotation>

- <xs:appinfo>

<b:schemaInfo is_envelope="yes" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" />

</xs:appinfo>

</xs:annotation>

- <xs:element name="Record">

- <xs:annotation>

- <xs:appinfo>

<b:recordInfo body_xpath="/*[local-name()=Record' and namespace-uri()='http://test.splitt]" />

</xs:appinfo>

</xs:annotation>

- <xs:complexType>

- <xs:sequence>

- <xs:element name="INVRPT">

- <xs:complexType>

- <xs:sequence>

- <xs:element name="LAGRAP">

- <xs:complexType>

<xs:attribute name="RCDID" type="xs:string" use="required" />

<xs:attribute name="FIRMK" type="xs:unsignedByte" use="required" />

<xs:attribute name="EDILN" type="xs:string" use="required" />

<xs:attribute name="KUNNR" type="xs:unsignedByte" use="required" />

<xs:attribute name="KNEDI" type="xs:unsignedByte" use="required" />

<xs:attribute name="VARNR" type="xs:string" use="required" />

<xs:attribute name="TRKKD" type="xs:unsignedByte" use="required" />

<xs:attribute name="TRKEN" type="xs:unsignedByte" use="required" />

<xs:attribute name="TRKAN" type="xs:unsignedByte" use="required" />

<xs:attribute name="TRNEG" type="xs:unsignedByte" use="required" />

<xs:attribute name="TRKBC" type="xs:string" use="required" />

<xs:attribute name="KUNBC" type="xs:string" use="required" />

<xs:attribute name="FIFOD" type="xs:unsignedByte" use="required" />

<xs:attribute name="KNVNR" type="xs:string" use="required" />

<xs:attribute name="KNPNR" type="xs:string" use="required" />

<xs:attribute name="FLAG2" type="xs:string" use="required" />

<xs:attribute name="TRKAS" type="xs:string" use="required" />

<xs:attribute name="TRKDT" type="xs:unsignedByte" use="required" />

<xs:attribute name="TRKTI" type="xs:unsignedByte" use="required" />

<xs:attribute name="DCTRK" type="xs:string" use="required" />

<xs:attribute name="BEMRK" type="xs:string" use="required" />

<xs:attribute name="FRAVN" type="xs:string" use="required" />

<xs:attribute name="FRABC" type="xs:string" use="required" />

<xs:attribute name="RVSKD" type="xs:string" use="required" />

<xs:attribute name="ACIN1" type="xs:string" use="required" />

<xs:attribute name="ACIN2" type="xs:string" use="required" />

<xs:attribute name="ACIN3" type="xs:string" use="required" />

<xs:attribute name="RECNR" type="xs:unsignedByte" use="required" />

</xs:complexType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>

 

Så når jeg tester denne filen, så sender den bare igjennom hele filen.

Det kommer ut bare 1 fil med 3 records i. Ikke 3 filer med 1 records i.

 

Noen som har forslag til hva jeg gjør feil?

Lenke til kommentar

Opprett en konto eller logg inn for å kommentere

Du må være et medlem for å kunne skrive en kommentar

Opprett konto

Det er enkelt å melde seg inn for å starte en ny konto!

Start en konto

Logg inn

Har du allerede en konto? Logg inn her.

Logg inn nå
Gå til emneliste

  • Hvem er aktive   0 medlemmer

    • Ingen innloggede medlemmer aktive
×
×
  • Opprett ny...