Skip to Content

Changes for page Exercises

Last modified by Carlijn Kokkeler on 2022/10/20 14:28
From version 2.1
edited by Carlijn Kokkeler
on 2022/10/19 13:55
Change comment: There is no comment for this version
To version 3.1
edited by Carlijn Kokkeler
on 2022/10/19 15:15
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -11,230 +11,21 @@
11 11  
12 12  This microlearning centers around understanding the concept of transformations. Please note that these are follow-up exercises from the Data modeling in Design exercises, which can be found [[here>>doc:Main.eMagiz Academy.Use Cases.Data modeling in Design.Exercises.WebHome||target="blank"]].
13 13  
14 -== 3. CDM, CDM & system message, message mapping ==
15 -By following the steps below, you should gain a better understanding of the differences between CDM, CDM messages, and system messages.
14 +== 3. Transformations in Create ==
15 +By following the steps below, you should gain a better understanding of transformations.
16 16  
17 -* Creating a CDM
18 - ** Please import the file Order.xsd in your CDM. The code for this file can be found in section 4. Code for xsd files.
19 -* Creating a CDM message
20 - ** Now, go to your CDM message and select Order as root entity.
21 - ** Add all other entities and attributes from Order.xsd, which were imported into the CDM, to your CDM message definition.
22 -* Creating a system message
23 - ** In one of your System messages, import the file TransportOrder.xsd. The code for this file can be found in section 4. Code for xsd files.
24 -* Creating a CDM message
25 - ** Select CreateOrder as root entity and add all other entities and attributes to your system definition.
26 -* Complete message mapping
27 - ** Now that you have completed these steps, go to Message mapping and complete the mapping. Please add the following to the Design mapping
28 - *** Ensure to properly map the address type
29 - *** Ensure to properly document mappings where required
30 -* Update the CDM and CDM message and remove the housenumber attribute
31 - ** Update the mapping accordingly
32 -* Update the System and CDM message to set the country attributes as enumerations
33 - ** System message uses an ISO-2 standard for country code
34 - ** CDM message uses an ISO-3 standard for country code
35 -
17 +* Enumeration value mapping
18 +** CDM message uses an ISO-3 standard for country code. Add an enumeration for the attribute Country according to this standard.
19 +** System message uses an ISO-2 standard for country code. Add an enumeration for the attribute Country according to this standard.
20 +* Boolean value mapping TBD
21 +* Fixed value
22 +** Add a fixed value to the attribute 'Type' from the entity 'Address'. Please carefully look at the desired value(s).
23 +* If exists
24 + ** Make sure that a Description attribute is only generated if a description exists.
25 +* XPath TBD
36 36  
37 -The solutions to these exercises can be found [[here>>doc:Main.eMagiz Academy.Use Cases.Data modeling in Design.Exercises.Solutions.WebHome||target="blank"]].
27 +The solutions to these exercises can be found [[here>>doc:Main.eMagiz Academy.Use Cases.Transformations.Exercises.Solutions.WebHome||target="blank"]].
38 38  
39 -== 4. Code for xsd files ==
40 -=== 4.1 Code for Order.xsd ===
41 -{{code language="xml"}}
42 -<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
43 - xmlns="http://www.mappingexercises.com/ns/capetms/cdm/1.0/"
44 - attributeFormDefault="unqualified"
45 - elementFormDefault="qualified"
46 - targetNamespace="http://www.mappingexercises.com/ns/capetms/cdm/1.0/">
47 - <xs:complexType name="Order">
48 - <xs:sequence>
49 - <xs:element name="Date" type="xs:dateTime"/>
50 - <xs:element name="OrderId" type="nonEmptyString"/>
51 - <xs:element name="Customer" type="Customer"/>
52 - <xs:element name="PickupAddress" type="PickupAddress"/>
53 - <xs:element name="DeliveryAddress" type="DeliveryAddress"/>
54 - <xs:element maxOccurs="unbounded" name="OrderLine" type="OrderLine"/>
55 - </xs:sequence>
56 - </xs:complexType>
57 - <xs:complexType name="Customer">
58 - <xs:sequence>
59 - <xs:element name="Name" type="nonEmptyString"/>
60 - <xs:element name="Email" type="nonEmptyString"/>
61 - </xs:sequence>
62 - </xs:complexType>
63 - <xs:complexType name="PickupAddress">
64 - <xs:sequence>
65 - <xs:element name="Name" type="nonEmptyString"/>
66 - <xs:element name="Street" type="nonEmptyString"/>
67 - <xs:element name="StreetNumber" type="nonEmptyString"/>
68 - <xs:element name="PostalCode" type="nonEmptyString"/>
69 - <xs:element name="City" type="nonEmptyString"/>
70 - <xs:element name="Country" type="nonEmptyString"/>
71 - </xs:sequence>
72 - </xs:complexType>
73 - <xs:complexType name="DeliveryAddress">
74 - <xs:sequence>
75 - <xs:element name="Name" type="nonEmptyString"/>
76 - <xs:element name="Street" type="nonEmptyString"/>
77 - <xs:element name="StreetNumber" type="nonEmptyString"/>
78 - <xs:element name="PostalCode" type="nonEmptyString"/>
79 - <xs:element name="City" type="nonEmptyString"/>
80 - <xs:element name="Country" type="nonEmptyString"/>
81 - </xs:sequence>
82 - </xs:complexType>
83 - <xs:complexType name="OrderLine">
84 - <xs:sequence>
85 - <xs:element name="PackageUnit" type="nonEmptyString"/>
86 - <xs:element name="Quantity" type="xs:long"/>
87 - <xs:element name="Description" type="nonEmptyString"/>
88 - <xs:element name="Weight" type="xs:decimal"/>
89 - </xs:sequence>
90 - </xs:complexType>
91 - <xs:simpleType name="nonEmptyString">
92 - <xs:restriction base="xs:string">
93 - <xs:minLength value="1"/>
94 - </xs:restriction>
95 - </xs:simpleType>
96 - <xs:element name="Order" type="Order"/>
97 -</xs:schema>
98 -{{/code}}
99 -
100 -=== 4.2 Code for TransportOrder.xsd ===
101 -{{code language="xml"}}
102 -<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
103 - xmlns="https://transportinc.nl/ns/tms/1.0/"
104 - attributeFormDefault="unqualified"
105 - elementFormDefault="unqualified"
106 - targetNamespace="https://transportinc.nl/ns/tms/1.0/">
107 - <xs:complexType name="CreateOrder">
108 - <xs:sequence>
109 - <xs:element name="Order" type="Order"/>
110 - </xs:sequence>
111 - </xs:complexType>
112 - <xs:complexType name="Order">
113 - <xs:sequence>
114 - <xs:element name="OrderID">
115 - <xs:simpleType>
116 - <xs:restriction base="xs:string">
117 - <xs:maxLength value="200"/>
118 - </xs:restriction>
119 - </xs:simpleType>
120 - </xs:element>
121 - <xs:element name="OrderDate" type="xs:dateTime"/>
122 - <xs:element minOccurs="0" name="Order_Customer" type="Order_Customer"/>
123 - <xs:element name="Address" type="Address"/>
124 - <xs:element name="PartnerInfo_Order" type="PartnerInfo_Order"/>
125 - <xs:element name="OrderLine_Order" type="OrderLine_Order"/>
126 - </xs:sequence>
127 - </xs:complexType>
128 - <xs:complexType name="Order_Customer">
129 - <xs:sequence>
130 - <xs:element minOccurs="0" name="Customer" type="Customer"/>
131 - </xs:sequence>
132 - </xs:complexType>
133 - <xs:complexType name="Customer">
134 - <xs:sequence>
135 - <xs:element name="Name">
136 - <xs:simpleType>
137 - <xs:restriction base="xs:string">
138 - <xs:maxLength value="200"/>
139 - </xs:restriction>
140 - </xs:simpleType>
141 - </xs:element>
142 - <xs:element minOccurs="0" name="Contact_Customer" type="Contact_Customer"/>
143 - </xs:sequence>
144 - </xs:complexType>
145 - <xs:complexType name="Contact_Customer">
146 - <xs:sequence>
147 - <xs:element maxOccurs="unbounded"
148 - minOccurs="0"
149 - name="Contact"
150 - type="Contact"/>
151 - </xs:sequence>
152 - </xs:complexType>
153 - <xs:complexType name="Contact">
154 - <xs:sequence>
155 - <xs:element name="eMail">
156 - <xs:simpleType>
157 - <xs:restriction base="xs:string">
158 - <xs:maxLength value="200"/>
159 - </xs:restriction>
160 - </xs:simpleType>
161 - </xs:element>
162 - <xs:element minOccurs="0" name="Name">
163 - <xs:simpleType>
164 - <xs:restriction base="xs:string">
165 - <xs:maxLength value="200"/>
166 - </xs:restriction>
167 - </xs:simpleType>
168 - </xs:element>
169 - </xs:sequence>
170 - </xs:complexType>
171 - <xs:complexType name="Address">
172 - <xs:sequence>
173 - <xs:element name="Type" type="nonEmptyString"/>
174 - <xs:element name="Name" type="nonEmptyString"/>
175 - <xs:element name="Street" type="nonEmptyString"/>
176 - <xs:element name="PostalCode" type="nonEmptyString"/>
177 - <xs:element name="City" type="nonEmptyString"/>
178 - <xs:element name="Country" type="nonEmptyString"/>
179 - </xs:sequence>
180 - </xs:complexType>
181 - <xs:complexType name="PartnerInfo_Order">
182 - <xs:sequence>
183 - <xs:element maxOccurs="unbounded"
184 - minOccurs="0"
185 - name="PartnerInfo"
186 - type="PartnerInfo"/>
187 - </xs:sequence>
188 - </xs:complexType>
189 - <xs:complexType name="PartnerInfo">
190 - <xs:sequence>
191 - <xs:element name="UUID">
192 - <xs:simpleType>
193 - <xs:restriction base="xs:string">
194 - <xs:maxLength value="64"/>
195 - </xs:restriction>
196 - </xs:simpleType>
197 - </xs:element>
198 - </xs:sequence>
199 - </xs:complexType>
200 - <xs:complexType name="OrderLine_Order">
201 - <xs:sequence>
202 - <xs:element maxOccurs="unbounded"
203 - minOccurs="0"
204 - name="OrderLine"
205 - type="OrderLine"/>
206 - </xs:sequence>
207 - </xs:complexType>
208 - <xs:complexType name="OrderLine">
209 - <xs:sequence>
210 - <xs:element name="Description">
211 - <xs:simpleType>
212 - <xs:restriction base="xs:string">
213 - <xs:maxLength value="200"/>
214 - </xs:restriction>
215 - </xs:simpleType>
216 - </xs:element>
217 - <xs:element name="Quantity" type="xs:long"/>
218 - <xs:element name="Unit" type="Enum"/>
219 - <xs:element minOccurs="0" name="Weight" type="xs:double"/>
220 - </xs:sequence>
221 - </xs:complexType>
222 - <xs:simpleType name="nonEmptyString">
223 - <xs:restriction base="xs:string">
224 - <xs:minLength value="1"/>
225 - </xs:restriction>
226 - </xs:simpleType>
227 - <xs:simpleType name="Enum">
228 - <xs:restriction base="xs:string">
229 - <xs:enumeration value="COLLI"/>
230 - <xs:enumeration value="EURO"/>
231 - <xs:enumeration value="BOX"/>
232 - <xs:enumeration value="SACK"/>
233 - </xs:restriction>
234 - </xs:simpleType>
235 - <xs:element name="CreateOrder" type="CreateOrder"/>
236 -</xs:schema>
237 -{{/code}}
238 238  == 5. Key takeaways ==
239 239  
240 240  * The CDM holds all entities and attributes that are relevant within the context of your complete integration landscape.