Skip to Content

Changes for page Excel to CSV < 2007

Last modified by Erik Bakker on 2023/01/31 10:20
From version 4.1
edited by Erik Bakker
on 2022/05/02 08:17
Change comment: There is no comment for this version
To version 21.1
edited by Erik Bakker
on 2023/01/31 10:19
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -SOAP Web service Connectivity
1 +Excel to CSV < 2007
Content
... ... @@ -1,40 +1,36 @@
1 1  {{container}}
2 2  {{container layoutStyle="columns"}}
3 3  (((
4 -= About =
5 -This store element will allow you to create an easy connection to SOAP based web services. XML data can be send to these web services, and for each connectivity type there is a Flow Fragment available.
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.
6 6  
7 -= Documentation =
7 +== Documentation ==
8 8  
9 - **~1. How to use**
10 -With this store component, you can easily set up a connection to a REST endpoint using various authentication mechanisms while taking the response into account.
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.
11 11  
12 -**2. Keynotes & restrictions **
12 +==== 2. Keynotes & restrictions====
13 13  
14 -a. Note that you need to select the valid authentication based on the requirement of the external system.
15 -
16 -**3. License Information**
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 +
22 +==== 3. License Information====
17 17  Part of the standard license agreement as agreed upon when using the store for the first time.
18 18  
19 -**4. Relevant eMagiz Academy Microlearnings**
20 -[[https:~~/~~/emagiz.github.io/docs/microlearning/intermediate-rest-webservice-connectivity-index>>url:https://emagiz.github.io/docs/microlearning/intermediate-rest-webservice-connectivity-index]]
25 +==== 4. Relevant eMagiz Academy Microlearnings====
21 21  
27 +* [[Handle Groovy Script>>doc:Main.eMagiz Academy.Microlearnings.Expert Level.Data Handling.expert-data-handling-groovy-script.WebHome||target="blank"]]
28 +* [[Q&A Question>>https://www.emagiz.com/privacy-policy/||target="blank"]]
22 22  
23 -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/?]])))
30 +//Would you please consult the privacy policy of eMagiz at the following [[link>>https://www.emagiz.com/privacy-policy/||target="blank"]])))
24 24  
25 25  
26 26  
27 -((((% border="2" cellpadding="10" cellspacing="10" style="width:292px" %)
28 -|=(% style="width: 45px;" %)#|=(% style="width: 241px;" %)Option
29 -|(% style="width:45px" %) a|(% style="width:241px" %) OAuth 2.0 - Authorization Code
30 -|(% style="width:45px" %) b|(% style="width:241px" %) REST - Basic Auth
31 -|(% style="width:45px" %) c|(% style="width:241px" %) REST - Client Certificate
32 -|(% style="width:45px" %) d|(% style="width:241px" %) REST - Header Mapper
33 -|(% style="width:45px" %) e|(% style="width:241px" %) OAuth 2.0 - Client Credentials
34 -|(% style="width:45px" %) f|(% style="width:241px" %) REST - SSL
35 -|(% style="width:45px" %) g|(% style="width:241px" %) Dynamic Token
36 -|(% style="width:45px" %) h|(% style="width:241px" %) Token
37 -|(% style="width:45px" %) i|(% style="width:241px" %) No Authentication (Fire & Forget)
38 -)))
34 +((()))
39 39  {{/container}}
40 40  {{/container}}