Skip to Content
Last modified by Erik Bakker on 2024/08/26 12:38
From version 19.1
edited by eMagiz
on 2022/05/22 21:30
Change comment: There is no comment for this version
To version 28.2
edited by Erik Bakker
on 2022/06/10 13:13
Change comment: Update document after refactoring.

Summary

Details

Page properties
Title
... ... @@ -1,0 +1,1 @@
1 +novice-file-based-connectivity-processing-a-file-per-line
Parent
... ... @@ -1,0 +1,1 @@
1 +WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.marijn
1 +XWiki.ebakker
Content
... ... @@ -1,18 +1,9 @@
1 -{{html wiki="true"}}
2 -<div class="ez-academy">
3 - <div class="ez-academy_body">
1 +{{container}}{{container layoutStyle="columns"}}(((
2 +In this microlearning, we will learn how you can define a header line in which you specify the naming of the various columns. Some external systems require a header line when you supply them with data via a flat file that is placed somewhere.
4 4  
5 -<div class="doc">
4 +Should you have any questions, please contact [[academy@emagiz.com>>mailto:academy@emagiz.com]].
6 6  
7 -
8 -
9 -= Annotations =
10 -
11 -In this microlearning, we will focus on using annotations to clarify your thought process. In the annotation, you either describe a best practice everyone should follow when they change that flow (i.e. within the asynchronous routing), describe how the (more complex) parts of the flow work or describe (parts of) of your message definitions (i.e. CDM, API Gateway Data model, system message, etc.). This will help yourself and others every time changes are needed.
12 -
13 -Should you have any questions, please contact academy@emagiz.com.
14 -
15 -* Last update: May 9th, 2021
6 +* Last update: May 28th, 2021
16 16  * Required reading time: 5 minutes
17 17  
18 18  == 1. Prerequisites ==
... ... @@ -21,64 +21,51 @@
21 21  
22 22  == 2. Key concepts ==
23 23  
24 -This microlearning centers around using annotations.
25 -With annotations, we mean: A piece of text to explain something to yourself and others
15 +This microlearning centers around learning how to place a header line on a flat-file output.
26 26  
27 -Annotations can be used for:
17 +By header line we mean: A line in the output that defines the naming of the various columns
28 28  
29 -* Describing a best practice everyone should follow
30 -* Describing (more complex) parts of the flow
31 -* Describe (parts of) your message definitions
19 +Some external parties require that the first line in the flat file output (i.e. CSV) is filled with column names (i.e. headers). In eMagiz, we call this line a header line.
32 32  
21 +== 3. Header line ==
33 33  
23 +In this microlearning, we will learn how you can define a header line in which you specify the naming of the various columns. Some external systems require a header line when you supply them with data via a flat file that is placed somewhere. The header line is the first line in the flat file output. Within this line, the various column names are specified for clarity.
34 34  
35 -== 3. Annotations ==
25 +To add such a header line in eMagiz you need to navigate to the Create phase of eMagiz and open the exit flow in which you want to drop the file to a certain location. Within the context of this flow, we need to add functionality that will ensure that a header line is written to the output before any functional lines are added. To do so first enter "Start Editing" mode on flow level. After you have done so please add a file outbound channel adapter to the flow including an input channel. We will use this component to write our header line to the flat file output.
36 36  
37 -In this microlearning, we will focus on using annotations on the flow level to clarify our thought process. In the annotation, you either describe a best practice everyone should follow when they change that flow (i.e. within the asynchronous routing) or describe how the (more complex) parts of the flow work. This will help yourself and others every time changes are needed within the flow.
27 +Ensure that the directory to which you reference is the same as in your functional file outbound channel adapter.
38 38  
39 -Annotations can be used for:
29 +[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-header-line--file-outbound-channel-header-line.png]]
40 40  
41 -* Describing a best practice everyone should follow
42 -* Describing (more complex) parts of the flow
43 -* Describe (parts of) your message definitions
31 +Now it is time to turn our attention to the Advanced tab. For the Mode select Ignore. Select this option to ensure that the header line is only written down once when there is no output created yet and not somewhere in the middle, in the end, or every time. Furthermore, select the option Append New Line to ensure that the remainder of the information is not appended to the same line.
44 44  
45 -To clarify the use cases let us take a look at how annotations can be added within the eMagiz platform. In our first example, we will take a look at asynchronous routing. In many eMagiz projects, a best practice is followed on how to add something to the asynchronous routing (or change something within the asynchronous routing). Because the best practice contains multiple steps it makes sense to use the annotation functionality of eMagiz to define all these steps and register them at the place you need them (i.e. the asynchronous routing). Having done so will result in something like this:
33 +[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-header-line--file-outbound-channel-header-line-advanced.png]]
46 46  
47 -<p align="center">[[image:novice-devops-perspectives-annotations--annotation-best-practice-async-routing.png||]]</p>
35 +After you have done so we need to add a standard transformer that defines the various column names to be written to the flat file output. To do so add the standard transformer component to the canvas including an input channel. After you have done so define the relevant SpEL expression. In this case, we advise using a property value that represents a string of column names. The value of the property should be something as follows:
48 48  
49 -The second example is about using annotations on the flow level to describe parts of the flow. In this example, we will use the annotation to describe that we use a filter to determine which messages are picked up from a local directory and how we filter. That way anyway opening the flow has to merely read the annotation to get the context. Having done so will result in something like this:
37 +'Header1;Header2;Header3;Header4'
50 50  
51 -<p align="center">[[image:novice-devops-perspectives-annotations--describe-parts-of-flow.png||]]</p>
39 +Do note that the separator, in this case, needs to match the requirements of the external system. At the flow configuration level, the standard transformer should look as follows.
52 52  
53 -The third example does not take place on the flow level but the message definition level. Therefore instead of going to Create, we go to Design. In Design when you navigate to the CDM, API Gateway Data model, Event Streaming Data model, message definitions, etc. you have the option to add annotations to the canvas. In this example, we want to make clear to all that make changes that a certain part of our CDM is used by a lot of integrations within eMagiz and therefore everyone should be careful and think twice before adjusting anything related to that part. Having done so will result in something like this:
41 +[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-header-line--define-columns-names.png]]
54 54  
55 -<p align="center">[[image:novice-devops-perspectives-annotations--describe-crucial-part-of-cdm.png||]]</p>
43 +Our last step is to ensure that this piece of logic is tied to the main flow and is executed before writing the functional line(s) to the output file. To make that happen we need to add a wiretap to the flow. With the help of this functionality, you can define which part of the logic takes precedence over another part of the logic. To do so double click on the channel on which you want to place a wiretap, select the option wiretap and select the correct wiretap channel. After you have done this the result should be something as follows:
56 56  
57 -Now that we saw some examples let us turn our attention to the how. How can I add an annotation and how can I link it. Adding the annotation is simple. You drag the annotation icon from the left context menu onto the canvas. As a result, an empty annotation will be shown on the canvas. By double-clicking on it you can type whatever you want. Note that you need to be in "Start Editing" mode to change anything, including annotations.
45 +[[image:Main.Images.Microlearning.WebHome@novice-file-based-connectivity-header-line--wiretap-result.png]]
58 58  
59 -<p align="center">[[image:novice-devops-perspectives-annotations--annotation-icon-context-menu.png||]]</p>
47 +With these couple of steps, you have now successfully added logic to your flow that will ensure that a header line is added before any functional line(s) are written to the output file.
60 60  
61 -When you are satisfied with what you have written down you can press the Save button. After you have done so you can rescale the annotation to ensure that the complete text is visible. To link the annotation to a component (on flow level) or an entity (on message definition level) you hover over the annotation until your mouse indicator changes to a + icon, execute a right-click and drag from the annotation to the component in question.
62 -
63 -Now you know what annotations are good for and how you can add them within the eMagiz platform.
64 -
65 -===== Practice =====
66 -
67 67  == 4. Assignment ==
68 68  
69 -Add annotation on the flow level that describes how (a part of) a flow works.
51 +Configure an exit in which you define and write a header line to a flat-file output before adding functional lines.
70 70  This assignment can be completed with the help of the (Academy) project that you have created/used in the previous assignment.
71 71  
72 72  == 5. Key takeaways ==
73 73  
74 -* Annotations can be used for:
75 - * Describing a best practice everyone should follow
76 - * Describing (more complex) parts of the flow
77 - * Describe (parts of) your message definitions
78 -* You can add annotations by dragging and dropping the annotation icon on the canvas.
56 +* The header line contains the names of the columns of the flat file output
57 +* Use the Ignore mode to ensure the header line is created once
58 +* Use the wiretap to ensure the header line is created first
79 79  
80 -
81 -
82 82  == 6. Suggested Additional Readings ==
83 83  
84 84  There are no suggested additional readings on this topic
... ... @@ -87,11 +87,6 @@
87 87  
88 88  This video demonstrates how you could have handled the assignment and gives you some context on what you have just learned.
89 89  
90 -<iframe width="1280" height="720" src="../../vid/microlearning/novice-devops-perspectives-annotations.mp4" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
68 +{{video attachment="novice-file-based-connectivity-header-line.mp4" reference="Main.Videos.Microlearning.WebHome"/}}
91 91  
92 -</div>
93 -
94 -</div>
95 -</div>
96 -
97 -{{/html}}
70 +)))((({{toc/}}))){{/container}}{{/container}}
novice-devops-perspectives-annotations--annotation-best-practice-async-routing.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.marijn
Size
... ... @@ -1,1 +1,0 @@
1 -25.7 KB
Content
novice-devops-perspectives-annotations--annotation-icon-context-menu.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.marijn
Size
... ... @@ -1,1 +1,0 @@
1 -774 bytes
Content
novice-devops-perspectives-annotations--describe-crucial-part-of-cdm.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.marijn
Size
... ... @@ -1,1 +1,0 @@
1 -15.5 KB
Content
novice-devops-perspectives-annotations--describe-parts-of-flow.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.marijn
Size
... ... @@ -1,1 +1,0 @@
1 -18.9 KB
Content