The file adapter is a very powerlful tool to read files with structured data. Most of the time you will read simple csv files with one record per row. But what if your csv file contains multiple records with different types. Even then you can use the file adapter.
Case
Assume you have some laptimes of the wordcup Worldcup speedskating. Saved as csv format this file looks as followed:
Pair 1; Innerlane;Outerlane; 45;M. ANESI;ITA;126;R. BEDFORD;USA Distance:;Time:;Lap:;Distance:;Time:;Lap: 300m;23.87;23.8;300m;24.54;24.5 700m;50.96;27;700m;51.56;27 1100m;01:19.2;28.2;1100m;01:20.0;28.4 1500m;01:49.3;30;1500m;01:50.2;30.2 Pair 2; Innerlane;Outerlane; 124;J. ERIKSSON;SWE;122;A. YESIN;RUS Distance:;Time:;Lap:;Distance:;Time:;Lap: 300m;24.02;24;300m;23.89;23.8 700m; etc.. etc..
When we examine the file we can determine 5 records:
Pair 1; –rec 1
Innerlane;Outerlane; –rec 2
45;M. ANESI;ITA;126;R. BEDFORD;USA –rec 3
Distance:;Time:;Lap:;Distance:;Time:;Lap: –rec 4
300m;23.87;23.8;300m;24.54;24.5 –rec 5 repeating 4 times
700m;50.96;27;700m;51.56;27
1100m;01:19.2;28.2;1100m;01:20.0;28.4
1500m;01:49.3;30;1500m;01:50.2;30.2
By using the knowledge of how the data is repeating we can use the file adapter to read the file.
Tutorial
1. Start JDeveloper
2. Create a new SOA Application by choosing menu option “File” -> “New”.
3. From cateory “General” -> “Applications”, choose “SOA Application” and click “Ok”.
4. Enter as application name “Speedskating”. Press Next.
5. Enter as project name “Speedskating”. Press Next.
6. Enter as composite name SpeedSkating. Select the ‘Empty Composite’ as composite template
7. Drag an instance of the file adapter to the exposed service swimlane.
8. This will launch the ‘Adapter Configuration Wizard. In the the ‘Welcome to the Adapter Configuration Wizard, press next.
9. Enter the name ‘ReadSkateResult’ for the service and press next.
10. Leave the default selected interface and press next.
12. Select radio button read file and set the Operation Name to ‘ReadSpeedResult’. Press next.
13. Enter the directory where csv files is located. Notice the the selected checkbox ‘Delete files after succesful retrieval’. We want our service to process the file one time. After each Speedskate event we can place a new file with new results in the directory to process. Press next.
14. Enter the in field ‘Include files..’ the value ‘*worldcup*.csv. Press next.
15. Change the polling frequency to 2 minutes. Later when our services succesfully has been tested and deployed succesfully we can change this value. Press next.
16. Now we will create our own schema. Click the gear button.
17. Select the radio button ‘Delimeted’. Press next.
18. Browse for the csv file. Notice that the content of the file is loaded. The other setting we will not change. Press next.
The complete csv can be copied here.
<br /> Pair 1;<br /> Innerlane;Outerlane;<br /> 45;M. ANESI;ITA;126;R. BEDFORD;USA<br /> Distance:;Time:;Lap:;Distance:;Time:;Lap:<br /> 300m;23.87;23.8;300m;24.54;24.5<br /> 700m;50.96;27;700m;51.56;27<br /> 1100m;01:19.2;28.2;1100m;01:20.0;28.4<br /> 1500m;01:49.3;30;1500m;01:50.2;30.2<br /> Pair 2;<br /> Innerlane;Outerlane;<br /> 124;J. ERIKSSON;SWE;122;A. YESIN;RUS<br /> Distance:;Time:;Lap:;Distance:;Time:;Lap:<br /> 300m;24.02;24;300m;23.89;23.8<br /> 700m;50.94;26.9;700m;50.71;26.8<br /> 1100m;01:19.7;28.7;1100m;01:18.9;28.2<br /> 1500m;01:50.5;30.7;1500m;01:48.3;29.3<br /> Pair 3;<br /> Innerlane;Outerlane;<br /> 60;D. BABENKO;KAZ;40;R. LEHMANN;GER<br /> Distance:;Time:;Lap:;Distance:;Time:;Lap:<br /> 300m;25.05;25;300m;24.19;24.1<br /> 700m;52.27;27.2;700m;51.53;27.3<br /> 1100m;01:20.1;27.8;1100m;01:19.9;28.3<br /> 1500m;01:48.7;28.5;1500m;01:48.9;29<br /> Pair 4;<br /> Innerlane;Outerlane;<br /> 98;M. FLYGIND-LARSEN;NOR;13;P. RIOPEL;CAN<br /> Distance:;Time:;Lap:;Distance:;Time:;Lap:<br /> 300m;23.91;23.9;300m;24;24<br /> 700m;50.01;26.1;700m;50.62;26.6<br /> 1100m;01:17.6;27.5;1100m;01:19.4;28.7<br /> 1500m;01:46.7;29.1;1500m;01:50.2;30.8<br /> Pair 5;<br /> Innerlane;Outerlane;<br /> 82;R. KET;NED;109;K. NIEDZWIEDZKI;POL<br /> Distance:;Time:;Lap:;Distance:;Time:;Lap:<br /> 300m;23.55;23.5;300m;23.84;23.8<br /> 700m;49.89;26.3;700m;50.88;27<br /> 1100m;01:17.7;27.8;1100m;01:19.9;29<br /> 1500m;01:47.8;30;1500m;01:50.2;30.3<br /> Pair 6;<br /> Innerlane;Outerlane;<br /> 116;Y. LALENKOV;RUS;68;J. LEE;KOR<br /> Distance:;Time:;Lap:;Distance:;Time:;Lap:<br /> 300m;23.77;23.7;300m;23.85;23.8<br /> 700m;50.19;26.4;700m;50.11;26.2<br /> 1100m;01:17.5;27.3;1100m;01:18.4;28.2<br /> 1500m;01:47.6;30;1500m;01:48.3;29.9<br /> Pair 7;<br /> Innerlane;Outerlane;<br /> 130;J. KUCK;USA;10;L. MAKOWSKY;CAN<br /> Distance:;Time:;Lap:;Distance:;Time:;Lap:<br /> 300m;24.75;24.7;300m;24.45;24.4<br /> 700m;51.34;26.5;700m;50.91;26.4<br /> 1100m;01:18.7;27.3;1100m;01:18.4;27.4<br /> 1500m;01:47.3;28.6;1500m;01:47.3;28.9<br /> Pair 8;<br /> Innerlane;Outerlane;<br /> 80;S. GROOTHUIS;NED;121;I. SKOBREV;RUS<br /> Distance:;Time:;Lap:;Distance:;Time:;Lap:<br /> 300m;23.67;23.6;300m;24.57;24.5<br /> 700m;49.49;25.8;700m;51.63;27<br /> 1100m;01:16.7;27.2;1100m;01:18.9;27.2<br /> 1500m;01:46.4;29.6;1500m;01:47.1;28.2<br /> Pair 9;<br /> Innerlane;Outerlane;<br /> 47;E. FABRIS;ITA;88;W. OLDE HEUVEL;NED<br /> Distance:;Time:;Lap:;Distance:;Time:;Lap:<br /> 300m;24.45;24.4;300m;24.18;24.1<br /> 700m;51.45;27;700m;51.07;26.8<br /> 1100m;01:18.9;27.4;1100m;01:18.5;27.4<br /> 1500m;01:46.9;28;1500m;01:46.8;28.2<br /> Pair 10;<br /> Innerlane;Outerlane;<br /> 131;T. MARSICANO;USA;92;M. TUITERT;NED<br /> Distance:;Time:;Lap:;Distance:;Time:;Lap:<br /> 300m;23.91;23.9;300m;23.71;23.7<br /> 700m;50.03;26.1;700m;49.59;25.8<br /> 1100m;01:17.4;27.3;1100m;01:16.8;27.2<br /> 1500m;01:47.4;29.9;1500m;01:46.0;29.1<br /> Pair 11;<br /> Innerlane;Outerlane;<br /> 85;S. KUIPERS;NED;128;S. DAVIS;USA<br /> Distance:;Time:;Lap:;Distance:;Time:;Lap:<br /> 300m;23.55;23.5;300m;23.56;23.5<br /> 700m;49.53;25.9;700m;49.11;25.5<br /> 1100m;01:16.7;27.1;1100m;01:16.2;27.1<br /> 1500m;01:45.5;28.7;1500m;01:45.0;28.8<br /> Pair 12;<br /> Innerlane;Outerlane;<br /> 11;D. MORRISON;CAN;96;H. BØKKO;NOR<br /> Distance:;Time:;Lap:;Distance:;Time:;Lap:<br /> 300m;26.65;26.6;300m;23.85;23.8<br /> 700m;52.87;26.2;700m;50.52;26.6<br /> 1100m;01:20.5;27.6;1100m;01:18.4;27.8<br /> 1500m;01:50.4;29.8;1500m;01:47.2;28.8</p> <p>
19. Select the radio buttons ‘File Contains multiple record instances’, ‘Multiple records are of different type’. Press next.
20. Our file contains 5 different records. The colored rectangles contain the inforbmation we are interested in.
The remainder data we can sonsider as ‘metadata’.
21. Notice that the field delimiters are set to semicolon. Press next.
22. Unfortunately we can not make use of the functionality offered in this step. We have to manually change our xsd later. Press next.
Press next.
23. So now we have an generated xsd. Let’s give it a try and test it by pressing the test button.
24. An error was to be expected. We did almost nothing till now. So why should it work ;-). Press ok twice to close the error message and the test window.
25. In our csv file we have a “list of elements”. The file adapter generated a xsd with a ‘choice’ element. This combination is causing the fault. We have to replace this by a sequence tag to match our list of ‘elements’ in our csv. Not forget to change the closing ‘choice’ tag also. Let’s test again by pressing the test button.
26. Although the xsd is not well formatted we can test it succesfully. WARNING: do not use the back button all changes you have made in your xsd will be lost.
27. Click on the link below to see the complete generated xsd. If we take a closer look we see that for every row in our csv file a record element has been generated. This is not what we want. First of all we want more clear names for the elements in our xsd. Second we want one element with data for one pair of riders. See step 20. Press ok to close the test window
28. Our revised xsd is shown in the second source block. Copy the content of this to the ‘Native Format Builder Step 8 of 8’ xsd editor.
<xsd:element name="Root-Element">
<xsd:complexType>
<xsd:choice minOccurs="1" maxOccurs="unbounded" nxsd:choiceCondition="terminated" nxsd:terminatedBy=";">
<xsd:element name="RECORD1" nxsd:conditionValue="Pair 1">
<xsd:complexType>
<xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD10" nxsd:conditionValue="124">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD11" nxsd:conditionValue="Pair 3">
<xsd:complexType>
<xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD12" nxsd:conditionValue="60">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD13" nxsd:conditionValue="Pair 4">
<xsd:complexType>
<xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD14" nxsd:conditionValue="98">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD15" nxsd:conditionValue="Pair 5">
<xsd:complexType>
<xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD16" nxsd:conditionValue="82">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD17" nxsd:conditionValue="Pair 6">
<xsd:complexType>
<xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD18" nxsd:conditionValue="116">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD19" nxsd:conditionValue="Pair 7">
<xsd:complexType>
<xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD2" nxsd:conditionValue="Innerlane">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD20" nxsd:conditionValue="130">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD21" nxsd:conditionValue="Pair 8">
<xsd:complexType>
<xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD22" nxsd:conditionValue="80">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD23" nxsd:conditionValue="Pair 9">
<xsd:complexType>
<xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD24" nxsd:conditionValue="47">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD25" nxsd:conditionValue="Pair 10">
<xsd:complexType>
<xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD26" nxsd:conditionValue="131">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD27" nxsd:conditionValue="Pair 11">
<xsd:complexType>
<xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD28" nxsd:conditionValue="85">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD29" nxsd:conditionValue="Pair 12">
<xsd:complexType>
<xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD3" nxsd:conditionValue="45">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD30" nxsd:conditionValue="11">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD4" nxsd:conditionValue="Distance:">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD5" nxsd:conditionValue="300m">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD6" nxsd:conditionValue="700m">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD7" nxsd:conditionValue="1100m">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD8" nxsd:conditionValue="1500m">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C3" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C4" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="C6" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="RECORD9" nxsd:conditionValue="Pair 2">
<xsd:complexType>
<xsd:sequence>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:choice>
</xsd:complexType>
</xsd:element>
</xsd:schema>
29. Notice line 17 and 18. The attribute maxOccurs in line 17 has been added to process all ‘records’ in our csv file and not just one (see below). Also we added and element pair to group each pair of riders. As you can see all record elements have been removed.
Pair 1;
Innerlane;Outerlane;
45;M. ANESI;ITA;126;R. BEDFORD;USA
Distance:;Time:;Lap:;Distance:;Time:;Lap:
300m;23.87;23.8;300m;24.54;24.5
700m;50.96;27;700m;51.56;27
1100m;01:19.2;28.2;1100m;01:20.0;28.4
1500m;01:49.3;30;1500m;01:50.2;30.2
<?xml version="1.0" encoding="UTF-8" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd"
xmlns:tns="http://TargetNamespace.com/ReadSkateResult"
targetNamespace="http://TargetNamespace.com/ReadSkateResult"
elementFormDefault="qualified"
attributeFormDefault="unqualified"
nxsd:version="NXSD"
nxsd:stream="chars"
nxsd:encoding="ASCII"
>
<xsd:element name="Root-Element">
<xsd:complexType>
<xsd:sequence maxOccurs="unbounded">
<xsd:element name="Pair">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="PairNo" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";${eol}" nxsd:quotedBy=""" />
<xsd:element name="InnOut" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Inn" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="Out" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="Riders" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="RideInn" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="NameInn" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="CountryInn" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="RiderOut" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="NameOut" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="CountryOut" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="DistanceHeading" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="h1" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="h2" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="h3" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="h4" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="h5" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="h6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="Distance" minOccurs="4" maxOccurs="4">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="DistanceInner" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="TimeInner" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="LapInner" type="xsd:int" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="DistanceOut" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="TimeOut" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=";" nxsd:quotedBy=""" />
<xsd:element name="LapOut" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy=""" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
<!--NXSDWIZ:D:\blog\essent_worldcup.csv:-->
<!--USE-HEADER:false:-->
30. When perform a test again we will get the following output.
<Root-Element xmlns="http://TargetNamespace.com/ReadSpeedSkate">
<Pair>
<Ride>Pair 1</Ride>
<In_out_heading>
<RiderInr>Innerlane</RiderInr>
<RiderOut>Outerlane</RiderOut>
</In_out_heading>
<Deelnemers>
<RiderInr>45</RiderInr>
<NameInr>M.?ANESI</NameInr>
<CountryIn>ITA</CountryIn>
<RiderOut>126</RiderOut>
<NameOut>R.?BEDFORD</NameOut>
<CountryIOut>USA</CountryIOut>
</Deelnemers>
<Distance>
<heading1>Distance:</heading1>
<heading2>Time:</heading2>
<heading3>Lap:</heading3>
<heading4>Distance:</heading4>
<heading5>Time:;Lap:</heading5>
</Distance>
<Round>
<DistInn>300m</DistInn>
<TimeInn>23.87</TimeInn>
<LapInn>23.8</LapInn>
<DistOut>300m</DistOut>
<TimeOut>24.54</TimeOut>
<LapOut>24.5</LapOut>
</Round>
<Round>
<DistInn>700m</DistInn>
<TimeInn>50.96</TimeInn>
<LapInn>27</LapInn>
<DistOut>700m</DistOut>
<TimeOut>51.56</TimeOut>
<LapOut>27</LapOut>
</Round>
<Round>
<DistInn>1100m</DistInn>
<TimeInn>01:19.2</TimeInn>
<LapInn>28.2</LapInn>
<DistOut>1100m</DistOut>
<TimeOut>01:20.0</TimeOut>
<LapOut>28.4</LapOut>
</Round>
<Round>
<DistInn>1500m</DistInn>
<TimeInn>01:49.3</TimeInn>
<LapInn>30</LapInn>
<DistOut>1500m</DistOut>
<TimeOut>01:50.2</TimeOut>
<LapOut>30.2</LapOut>
</Round>
</Pair>
<Pair>
<Ride>Pair 2</Ride>
<In_out_heading>
<RiderInr>Innerlane</RiderInr>
<RiderOut>Outerlane</RiderOut>
</In_out_heading>
<Deelnemers>
<RiderInr>124</RiderInr>
<NameInr>J.?ERIKSSON</NameInr>
<CountryIn>SWE</CountryIn>
<RiderOut>122</RiderOut>
<NameOut>A.?YESIN</NameOut>
<CountryIOut>RUS</CountryIOut>
</Deelnemers>
<Distance>
<heading1>Distance:</heading1>
<heading2>Time:</heading2>
<heading3>Lap:</heading3>
<heading4>Distance:</heading4>
<heading5>Time:;Lap:</heading5>
</Distance>
<Round>
<DistInn>300m</DistInn>
<TimeInn>24.02</TimeInn>
<LapInn>24</LapInn>
<DistOut>300m</DistOut>
<TimeOut>23.89</TimeOut>
<LapOut>23.8</LapOut>
</Round>
<Round>
<DistInn>700m</DistInn>
<TimeInn>50.94</TimeInn>
<LapInn>26.9</LapInn>
<DistOut>700m</DistOut>
<TimeOut>50.71</TimeOut>
<LapOut>26.8</LapOut>
</Round>
<Round>
<DistInn>1100m</DistInn>
<TimeInn>01:19.7</TimeInn>
<LapInn>28.7</LapInn>
<DistOut>1100m</DistOut>
<TimeOut>01:18.9</TimeOut>
<LapOut>28.2</LapOut>
</Round>
<Round>
<DistInn>1500m</DistInn>
<TimeInn>01:50.5</TimeInn>
<LapInn>30.7</LapInn>
<DistOut>1500m</DistOut>
<TimeOut>01:48.3</TimeOut>
<LapOut>29.3</LapOut>
</Round>
</Pair>
<Pair>
<Ride>Pair 3</Ride>
<In_out_heading>
<RiderInr>Innerlane</RiderInr>
<RiderOut>Outerlane</RiderOut>
</In_out_heading>
<Deelnemers>
<RiderInr>60</RiderInr>
<NameInr>D.?BABENKO</NameInr>
<CountryIn>KAZ</CountryIn>
<RiderOut>40</RiderOut>
<NameOut>R.?LEHMANN</NameOut>
<CountryIOut>GER</CountryIOut>
</Deelnemers>
<Distance>
<heading1>Distance:</heading1>
<heading2>Time:</heading2>
<heading3>Lap:</heading3>
<heading4>Distance:</heading4>
<heading5>Time:;Lap:</heading5>
</Distance>
<Round>
<DistInn>300m</DistInn>
<TimeInn>25.05</TimeInn>
<LapInn>25</LapInn>
<DistOut>300m</DistOut>
<TimeOut>24.19</TimeOut>
<LapOut>24.1</LapOut>
</Round>
<Round>
<DistInn>700m</DistInn>
<TimeInn>52.27</TimeInn>
<LapInn>27.2</LapInn>
<DistOut>700m</DistOut>
<TimeOut>51.53</TimeOut>
<LapOut>27.3</LapOut>
</Round>
<Round>
<DistInn>1100m</DistInn>
<TimeInn>01:20.1</TimeInn>
<LapInn>27.8</LapInn>
<DistOut>1100m</DistOut>
<TimeOut>01:19.9</TimeOut>
<LapOut>28.3</LapOut>
</Round>
<Round>
<DistInn>1500m</DistInn>
<TimeInn>01:48.7</TimeInn>
<LapInn>28.5</LapInn>
<DistOut>1500m</DistOut>
<TimeOut>01:48.9</TimeOut>
<LapOut>29</LapOut>
</Round>
</Pair>
<Pair>
<Ride>Pair 4</Ride>
<In_out_heading>
<RiderInr>Innerlane</RiderInr>
<RiderOut>Outerlane</RiderOut>
</In_out_heading>
<Deelnemers>
<RiderInr>98</RiderInr>
<NameInr>M.?FLYGIND-LARSEN</NameInr>
<CountryIn>NOR</CountryIn>
<RiderOut>13</RiderOut>
<NameOut>P.?RIOPEL</NameOut>
<CountryIOut>CAN</CountryIOut>
</Deelnemers>
<Distance>
<heading1>Distance:</heading1>
<heading2>Time:</heading2>
<heading3>Lap:</heading3>
<heading4>Distance:</heading4>
<heading5>Time:;Lap:</heading5>
</Distance>
<Round>
<DistInn>300m</DistInn>
<TimeInn>23.91</TimeInn>
<LapInn>23.9</LapInn>
<DistOut>300m</DistOut>
<TimeOut>24</TimeOut>
<LapOut>24</LapOut>
</Round>
<Round>
<DistInn>700m</DistInn>
<TimeInn>50.01</TimeInn>
<LapInn>26.1</LapInn>
<DistOut>700m</DistOut>
<TimeOut>50.62</TimeOut>
<LapOut>26.6</LapOut>
</Round>
<Round>
<DistInn>1100m</DistInn>
<TimeInn>01:17.6</TimeInn>
<LapInn>27.5</LapInn>
<DistOut>1100m</DistOut>
<TimeOut>01:19.4</TimeOut>
<LapOut>28.7</LapOut>
</Round>
<Round>
<DistInn>1500m</DistInn>
<TimeInn>01:46.7</TimeInn>
<LapInn>29.1</LapInn>
<DistOut>1500m</DistOut>
<TimeOut>01:50.2</TimeOut>
<LapOut>30.8</LapOut>
</Round>
</Pair>
<Pair>
<Ride>Pair 5</Ride>
<In_out_heading>
<RiderInr>Innerlane</RiderInr>
<RiderOut>Outerlane</RiderOut>
</In_out_heading>
<Deelnemers>
<RiderInr>82</RiderInr>
<NameInr>R.?KET</NameInr>
<CountryIn>NED</CountryIn>
<RiderOut>109</RiderOut>
<NameOut>K.?NIEDZWIEDZKI</NameOut>
<CountryIOut>POL</CountryIOut>
</Deelnemers>
<Distance>
<heading1>Distance:</heading1>
<heading2>Time:</heading2>
<heading3>Lap:</heading3>
<heading4>Distance:</heading4>
<heading5>Time:;Lap:</heading5>
</Distance>
<Round>
<DistInn>300m</DistInn>
<TimeInn>23.55</TimeInn>
<LapInn>23.5</LapInn>
<DistOut>300m</DistOut>
<TimeOut>23.84</TimeOut>
<LapOut>23.8</LapOut>
</Round>
<Round>
<DistInn>700m</DistInn>
<TimeInn>49.89</TimeInn>
<LapInn>26.3</LapInn>
<DistOut>700m</DistOut>
<TimeOut>50.88</TimeOut>
<LapOut>27</LapOut>
</Round>
<Round>
<DistInn>1100m</DistInn>
<TimeInn>01:17.7</TimeInn>
<LapInn>27.8</LapInn>
<DistOut>1100m</DistOut>
<TimeOut>01:19.9</TimeOut>
<LapOut>29</LapOut>
</Round>
<Round>
<DistInn>1500m</DistInn>
<TimeInn>01:47.8</TimeInn>
<LapInn>30</LapInn>
<DistOut>1500m</DistOut>
<TimeOut>01:50.2</TimeOut>
<LapOut>30.3</LapOut>
</Round>
</Pair>
<Pair>
<Ride>Pair 6</Ride>
<In_out_heading>
<RiderInr>Innerlane</RiderInr>
<RiderOut>Outerlane</RiderOut>
</In_out_heading>
<Deelnemers>
<RiderInr>116</RiderInr>
<NameInr>Y.?LALENKOV</NameInr>
<CountryIn>RUS</CountryIn>
<RiderOut>68</RiderOut>
<NameOut>J.?LEE</NameOut>
<CountryIOut>KOR</CountryIOut>
</Deelnemers>
<Distance>
<heading1>Distance:</heading1>
<heading2>Time:</heading2>
<heading3>Lap:</heading3>
<heading4>Distance:</heading4>
<heading5>Time:;Lap:</heading5>
</Distance>
<Round>
<DistInn>300m</DistInn>
<TimeInn>23.77</TimeInn>
<LapInn>23.7</LapInn>
<DistOut>300m</DistOut>
<TimeOut>23.85</TimeOut>
<LapOut>23.8</LapOut>
</Round>
<Round>
<DistInn>700m</DistInn>
<TimeInn>50.19</TimeInn>
<LapInn>26.4</LapInn>
<DistOut>700m</DistOut>
<TimeOut>50.11</TimeOut>
<LapOut>26.2</LapOut>
</Round>
<Round>
<DistInn>1100m</DistInn>
<TimeInn>01:17.5</TimeInn>
<LapInn>27.3</LapInn>
<DistOut>1100m</DistOut>
<TimeOut>01:18.4</TimeOut>
<LapOut>28.2</LapOut>
</Round>
<Round>
<DistInn>1500m</DistInn>
<TimeInn>01:47.6</TimeInn>
<LapInn>30</LapInn>
<DistOut>1500m</DistOut>
<TimeOut>01:48.3</TimeOut>
<LapOut>29.9</LapOut>
</Round>
</Pair>
<Pair>
<Ride>Pair 7</Ride>
<In_out_heading>
<RiderInr>Innerlane</RiderInr>
<RiderOut>Outerlane</RiderOut>
</In_out_heading>
<Deelnemers>
<RiderInr>130</RiderInr>
<NameInr>J.?KUCK</NameInr>
<CountryIn>USA</CountryIn>
<RiderOut>10</RiderOut>
<NameOut>L.?MAKOWSKY</NameOut>
<CountryIOut>CAN</CountryIOut>
</Deelnemers>
<Distance>
<heading1>Distance:</heading1>
<heading2>Time:</heading2>
<heading3>Lap:</heading3>
<heading4>Distance:</heading4>
<heading5>Time:;Lap:</heading5>
</Distance>
<Round>
<DistInn>300m</DistInn>
<TimeInn>24.75</TimeInn>
<LapInn>24.7</LapInn>
<DistOut>300m</DistOut>
<TimeOut>24.45</TimeOut>
<LapOut>24.4</LapOut>
</Round>
<Round>
<DistInn>700m</DistInn>
<TimeInn>51.34</TimeInn>
<LapInn>26.5</LapInn>
<DistOut>700m</DistOut>
<TimeOut>50.91</TimeOut>
<LapOut>26.4</LapOut>
</Round>
<Round>
<DistInn>1100m</DistInn>
<TimeInn>01:18.7</TimeInn>
<LapInn>27.3</LapInn>
<DistOut>1100m</DistOut>
<TimeOut>01:18.4</TimeOut>
<LapOut>27.4</LapOut>
</Round>
<Round>
<DistInn>1500m</DistInn>
<TimeInn>01:47.3</TimeInn>
<LapInn>28.6</LapInn>
<DistOut>1500m</DistOut>
<TimeOut>01:47.3</TimeOut>
<LapOut>28.9</LapOut>
</Round>
</Pair>
<Pair>
<Ride>Pair 8</Ride>
<In_out_heading>
<RiderInr>Innerlane</RiderInr>
<RiderOut>Outerlane</RiderOut>
</In_out_heading>
<Deelnemers>
<RiderInr>80</RiderInr>
<NameInr>S.?GROOTHUIS</NameInr>
<CountryIn>NED</CountryIn>
<RiderOut>121</RiderOut>
<NameOut>I.?SKOBREV</NameOut>
<CountryIOut>RUS</CountryIOut>
</Deelnemers>
<Distance>
<heading1>Distance:</heading1>
<heading2>Time:</heading2>
<heading3>Lap:</heading3>
<heading4>Distance:</heading4>
<heading5>Time:;Lap:</heading5>
</Distance>
<Round>
<DistInn>300m</DistInn>
<TimeInn>23.67</TimeInn>
<LapInn>23.6</LapInn>
<DistOut>300m</DistOut>
<TimeOut>24.57</TimeOut>
<LapOut>24.5</LapOut>
</Round>
<Round>
<DistInn>700m</DistInn>
<TimeInn>49.49</TimeInn>
<LapInn>25.8</LapInn>
<DistOut>700m</DistOut>
<TimeOut>51.63</TimeOut>
<LapOut>27</LapOut>
</Round>
<Round>
<DistInn>1100m</DistInn>
<TimeInn>01:16.7</TimeInn>
<LapInn>27.2</LapInn>
<DistOut>1100m</DistOut>
<TimeOut>01:18.9</TimeOut>
<LapOut>27.2</LapOut>
</Round>
<Round>
<DistInn>1500m</DistInn>
<TimeInn>01:46.4</TimeInn>
<LapInn>29.6</LapInn>
<DistOut>1500m</DistOut>
<TimeOut>01:47.1</TimeOut>
<LapOut>28.2</LapOut>
</Round>
</Pair>
<Pair>
<Ride>Pair 9</Ride>
<In_out_heading>
<RiderInr>Innerlane</RiderInr>
<RiderOut>Outerlane</RiderOut>
</In_out_heading>
<Deelnemers>
<RiderInr>47</RiderInr>
<NameInr>E.?FABRIS</NameInr>
<CountryIn>ITA</CountryIn>
<RiderOut>88</RiderOut>
<NameOut>W.?OLDE HEUVEL</NameOut>
<CountryIOut>NED</CountryIOut>
</Deelnemers>
<Distance>
<heading1>Distance:</heading1>
<heading2>Time:</heading2>
<heading3>Lap:</heading3>
<heading4>Distance:</heading4>
<heading5>Time:;Lap:</heading5>
</Distance>
<Round>
<DistInn>300m</DistInn>
<TimeInn>24.45</TimeInn>
<LapInn>24.4</LapInn>
<DistOut>300m</DistOut>
<TimeOut>24.18</TimeOut>
<LapOut>24.1</LapOut>
</Round>
<Round>
<DistInn>700m</DistInn>
<TimeInn>51.45</TimeInn>
<LapInn>27</LapInn>
<DistOut>700m</DistOut>
<TimeOut>51.07</TimeOut>
<LapOut>26.8</LapOut>
</Round>
<Round>
<DistInn>1100m</DistInn>
<TimeInn>01:18.9</TimeInn>
<LapInn>27.4</LapInn>
<DistOut>1100m</DistOut>
<TimeOut>01:18.5</TimeOut>
<LapOut>27.4</LapOut>
</Round>
<Round>
<DistInn>1500m</DistInn>
<TimeInn>01:46.9</TimeInn>
<LapInn>28</LapInn>
<DistOut>1500m</DistOut>
<TimeOut>01:46.8</TimeOut>
<LapOut>28.2</LapOut>
</Round>
</Pair>
<Pair>
<Ride>Pair 10</Ride>
<In_out_heading>
<RiderInr>Innerlane</RiderInr>
<RiderOut>Outerlane</RiderOut>
</In_out_heading>
<Deelnemers>
<RiderInr>131</RiderInr>
<NameInr>T.?MARSICANO</NameInr>
<CountryIn>USA</CountryIn>
<RiderOut>92</RiderOut>
<NameOut>M.?TUITERT</NameOut>
<CountryIOut>NED</CountryIOut>
</Deelnemers>
<Distance>
<heading1>Distance:</heading1>
<heading2>Time:</heading2>
<heading3>Lap:</heading3>
<heading4>Distance:</heading4>
<heading5>Time:;Lap:</heading5>
</Distance>
<Round>
<DistInn>300m</DistInn>
<TimeInn>23.91</TimeInn>
<LapInn>23.9</LapInn>
<DistOut>300m</DistOut>
<TimeOut>23.71</TimeOut>
<LapOut>23.7</LapOut>
</Round>
<Round>
<DistInn>700m</DistInn>
<TimeInn>50.03</TimeInn>
<LapInn>26.1</LapInn>
<DistOut>700m</DistOut>
<TimeOut>49.59</TimeOut>
<LapOut>25.8</LapOut>
</Round>
<Round>
<DistInn>1100m</DistInn>
<TimeInn>01:17.4</TimeInn>
<LapInn>27.3</LapInn>
<DistOut>1100m</DistOut>
<TimeOut>01:16.8</TimeOut>
<LapOut>27.2</LapOut>
</Round>
<Round>
<DistInn>1500m</DistInn>
<TimeInn>01:47.4</TimeInn>
<LapInn>29.9</LapInn>
<DistOut>1500m</DistOut>
<TimeOut>01:46.0</TimeOut>
<LapOut>29.1</LapOut>
</Round>
</Pair>
<Pair>
<Ride>Pair 11</Ride>
<In_out_heading>
<RiderInr>Innerlane</RiderInr>
<RiderOut>Outerlane</RiderOut>
</In_out_heading>
<Deelnemers>
<RiderInr>85</RiderInr>
<NameInr>S.?KUIPERS</NameInr>
<CountryIn>NED</CountryIn>
<RiderOut>128</RiderOut>
<NameOut>S.?DAVIS</NameOut>
<CountryIOut>USA</CountryIOut>
</Deelnemers>
<Distance>
<heading1>Distance:</heading1>
<heading2>Time:</heading2>
<heading3>Lap:</heading3>
<heading4>Distance:</heading4>
<heading5>Time:;Lap:</heading5>
</Distance>
<Round>
<DistInn>300m</DistInn>
<TimeInn>23.55</TimeInn>
<LapInn>23.5</LapInn>
<DistOut>300m</DistOut>
<TimeOut>23.56</TimeOut>
<LapOut>23.5</LapOut>
</Round>
<Round>
<DistInn>700m</DistInn>
<TimeInn>49.53</TimeInn>
<LapInn>25.9</LapInn>
<DistOut>700m</DistOut>
<TimeOut>49.11</TimeOut>
<LapOut>25.5</LapOut>
</Round>
<Round>
<DistInn>1100m</DistInn>
<TimeInn>01:16.7</TimeInn>
<LapInn>27.1</LapInn>
<DistOut>1100m</DistOut>
<TimeOut>01:16.2</TimeOut>
<LapOut>27.1</LapOut>
</Round>
<Round>
<DistInn>1500m</DistInn>
<TimeInn>01:45.5</TimeInn>
<LapInn>28.7</LapInn>
<DistOut>1500m</DistOut>
<TimeOut>01:45.0</TimeOut>
<LapOut>28.8</LapOut>
</Round>
</Pair>
<Pair>
<Ride>Pair 12</Ride>
<In_out_heading>
<RiderInr>Innerlane</RiderInr>
<RiderOut>Outerlane</RiderOut>
</In_out_heading>
<Deelnemers>
<RiderInr>11</RiderInr>
<NameInr>D.?MORRISON</NameInr>
<CountryIn>CAN</CountryIn>
<RiderOut>96</RiderOut>
<NameOut>H.?B?KKO</NameOut>
<CountryIOut>NOR</CountryIOut>
</Deelnemers>
<Distance>
<heading1>Distance:</heading1>
<heading2>Time:</heading2>
<heading3>Lap:</heading3>
<heading4>Distance:</heading4>
<heading5>Time:;Lap:</heading5>
</Distance>
<Round>
<DistInn>300m</DistInn>
<TimeInn>26.65</TimeInn>
<LapInn>26.6</LapInn>
<DistOut>300m</DistOut>
<TimeOut>23.85</TimeOut>
<LapOut>23.8</LapOut>
</Round>
<Round>
<DistInn>700m</DistInn>
<TimeInn>52.87</TimeInn>
<LapInn>26.2</LapInn>
<DistOut>700m</DistOut>
<TimeOut>50.52</TimeOut>
<LapOut>26.6</LapOut>
</Round>
<Round>
<DistInn>1100m</DistInn>
<TimeInn>01:20.5</TimeInn>
<LapInn>27.6</LapInn>
<DistOut>1100m</DistOut>
<TimeOut>01:18.4</TimeOut>
<LapOut>27.8</LapOut>
</Round>
<Round>
<DistInn>1500m</DistInn>
<TimeInn>01:50.4</TimeInn>
<LapInn>29.8</LapInn>
<DistOut>1500m</DistOut>
<TimeOut>01:47.2</TimeOut>
<LapOut>28.8</LapOut>
</Round>
</Pair>
31. This output we can use in our mediator. Press next to finish the Native format builder.
32. Now we have to create a database adapter to insert the Speedskaters in our database.
In our example we will insert them in the table riders
create table RIDERS ( PAIR VARCHAR2(10), RIDERINN VARCHAR2(40), RIDERNAMEINN VARCHAR2(40), COUNTRYINN VARCHAR2(40), RIDEROUT VARCHAR2(40), RIDERNAMEOUT VARCHAR2(40), COUNTRYOUT VARCHAR2(40) )
33. Drag and drop the database adapter in the external references swinlane of the composite diagram. Press next in the welcome screen.
34. Enter as servive name “dbSpeedSkate”. Press next.
35. Configure your database and select the correct connection and enter the correct JNDI name. For more information about configuring your database connection read the blogpost Oracle 11g SOA Suite-Service…. Press next.
36. Select the radio button “Perform an Operation on a Table’ and select the checkbox “Insert Only”. Press Next.
37. Use the import wizard to select the table riders created in step 30. Press next.
38. Select the checkboxes pair,riderinn,riderout to define a primary key . Normaly you would define a primary key in the database.
Because the primary goal of this tutorial is to learn the file adapter we will not pay much attention to this.
39. Press next in step 7 relationships
Press next in step 8 filtering
Press next in step 9 advanced
Press finish.
40. Got back to composite diagram and add a mediator service component to the component swinlane.
41. Enter the name ‘MediatorSpeedSkate’ as name for the mediator. Accept the default Template ‘Define Interface Later’. Press ok.
42.
- Connect the exposed service ‘ReadSkateResults’ in the left swinlane with the mediator
- Connect the mediator with de exterlan reference dbSpeedSkate in the right swimlane
43. The next step is to configure the routing rules for the mediator. Double click on the mediator “MediatorspeedSkate” to start editing.
44. Press the button just right of the drop down list ‘Transform Using’
45. Select the radio button ‘Create New Mapper File’. Accept the deault mapper file name and press ok.
46. Remember that our csv contains multiple pairs or riders. These have to be processed one-by-one. We need to tell this to the mapper by using a for each xslt element
- In the xslt Constructs there is a for-each element. Drag and drop the for-each element just between the elements ‘RidersCollection’ and ‘Riders’
- Connect the rider elements in the left panel with the riders in the right panel as shown in the image.
- When you are ready save all changes.
47. Deploy the application
48. Check the Enterprise manager for the deployed application. Your application should be visible
49. Looking at the dashboard tab, region ‘Recent Instances’ we can see that our application has already. Remeber that we told the file adapter to run every 2 minutes. If the instance has not run succesfull you meaby forgot to place the csv file in the correct directory.
50. Looking at the instance trail we can see the data has succesfully passed to the database.
51. Let’s check or the data is in the database table riders.
Resume
We created a succesful service to read the content of a file into the database. Although it would be likely to structure our data more elegant with the mediator. We succeeded in reading a file with multiple records with different types.
The next step will be make use of an other xslt construct e.g. ‘if’. The data can then be made more structured.
Excellent Article….Keep writing….:)
Thanks for your wonderful tutorials. I have a query regarding file content polling using file adapter. Say, I poll for a text file whose data is updated every second. I would like to read the content and insert it into the Db. The idea is that everytime I read, I should read only the newly added data and insert to the Db. Please help
Thank you very much for a very nice tutorial.
R
Bishnu
Really dam good. Thanks . I Implemented in my project and helped me to solve my problem.
This is one great tutorial Jan-Leendert. Very useful, very clear and instructive. Thanks for sharing this. I had not yet worked with multiple messages of different types through the File Adapter, and you make it seem pretty straighforward. Good job.
kind regards,
Lucas