Skip to Content

Changes for page Excel to CSV < 2007

Last modified by Erik Bakker on 2023/01/31 10:20
From version 20.1
edited by Erik Bakker
on 2022/10/07 15:16
Change comment: There is no comment for this version
To version 9.1
edited by Erik Bakker
on 2022/05/02 09:34
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -Excel to CSV < 2007
1 +eMagiz Data Sink
Content
... ... @@ -2,35 +2,31 @@
2 2  {{container layoutStyle="columns"}}
3 3  (((
4 4  == About ==
5 -With the help of this store item, you can transform 'old' Excel files that consist of one workbook and one sheet to a CSV so eMagiz can transform it to an XML file.
5 +With the help of this functionality, you can sink your messages into the eMagiz data sink bucket. Once the message is stored in the eMagiz data sink bucket, you will have the option to view this message in the Manage phase.
6 6  
7 7  == Documentation ==
8 8  
9 9  ==== 1. How to use====
10 -With the help of this store item, you can transform 'old' Excel files that consist of one workbook and one sheet to a CSV so eMagiz can transform it to an XML file.
10 +Once stored, eMagiz can retrieve all messages with the same ID attached during the sink action via the Manage phase. In this case, it is assumed that your eMagiz data sink is such that you can review them on the fly. Other eMagiz data sink variants are offered that required specific on-demand queries.
11 11  
12 12  ==== 2. Keynotes & restrictions====
13 13  
14 -* Note that any Excel file with the extension .xsl is considered an 'old' Excel file.
15 -* Note that these are custom Groovy scripts that work on the current infrastructure of eMagiz.
16 -* Any custom additions that are needed for your specific use cases need to be created by you and eMagiz will not create it for you.
17 -* The store item uses external libraries that are not supported by the eMagiz platform nor covered by the eMagiz SLA.
18 -* Note that the Groovy script only works for Excel files with one workbook and one sheet.
19 -* The store item does not specify where you retrieve the Excel file from nor where the CSV file needs to go. It is up to you to determine this.
20 -* Please check out the following link to learn a bit more about Groovy: https://www.tutorialspoint.com/groovy/index.htm
21 -
14 +* Note that you should think about when you want to archive your data to the eMagiz data sink. That choice determines what the impact on the functional flow is.
15 +* Don't use a wiretap to invoke this part of the flow, as that causes the sink's behavior to happen before the actual processing. If the sink fails, the message will not be delivered via the functional part of the flow.
16 +* Note that we define (among others) how the message is stored in the data sink bucket in this component. The file structure expression should not be altered, as changing this would break the functionality.
17 +* Note that the 'standard' eMagiz headers to define the source system (i.e. relevant systems) and the messageType need to be available upon sinking to make this functionality work.
18 +
22 22  ==== 3. License Information====
23 -Part of the standard license agreement as agreed upon when using the store for the first time.
20 +To use this store item you need to secure an additional license on the eMagiz platform. If you are interested in such a license please contact us at productmanagement@emagiz.com.
24 24  
25 -==== 4. Relevant eMagiz Academy Microlearnings====
22 +Would you please consult the privacy policy of eMagiz at the following link: [[https:~~/~~/www.emagiz.com/privacy-policy/?>>url:https://www.emagiz.com/privacy-policy/?]])))
26 26  
27 -[[Handle Groovy Script>>doc:Main.eMagiz Academy.Microlearnings.Expert Level.Data Handling.expert-data-handling-groovy-script.WebHome||target="blank"]]
28 -[[https:~~/~~/my.emagiz.com/p/question/172825635700361387>>url:https://my.emagiz.com/p/question/172825635700361387]]
29 29  
30 -//Would you please consult the privacy policy of eMagiz at the following link:// [[https:~~/~~/www.emagiz.com/privacy-policy/?>>url:https://www.emagiz.com/privacy-policy/?]])))
31 31  
32 -
33 -
34 -((()))
26 +((((% border="2" cellpadding="10" cellspacing="10" style="width:292px" %)
27 +|=(% style="width: 45px;" %)#|=(% style="width: 241px;" %)Option
28 +|(% style="width:45px" %) a|(% style="width:241px" %) XML message(s)
29 +|(% style="width:45px" %) b|(% style="width:241px" %) JSON Message(s)
30 +)))
35 35  {{/container}}
36 36  {{/container}}