Skip to Content

Changes for page Excel to CSV < 2007

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

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -Excel to CSV < 2007
1 +SOAP Web service Connectivity
Content
... ... @@ -1,35 +1,40 @@
1 1  {{container}}
2 2  {{container layoutStyle="columns"}}
3 3  (((
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.
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.
6 6  
7 -== Documentation ==
7 += Documentation =
8 8  
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.
9 + **~1. How to use**
10 +Ensure to locate the right connectivity method and import the right flow fragment.
11 11  
12 -==== 2. Keynotes & restrictions====
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 -
22 -==== 3. License Information====
14 +a. These flow fragments will contain only the eMagiz components to make a call out to the SOAP based webservice - These components do not hold any system messages - The basic authentication flow fragment requires empty key and trust store that are to be added separately. These are not included in this store component.
15 +
16 +**3. License Information**
23 23  Part of the standard license agreement as agreed upon when using the store for the first time.
24 24  
25 -==== 4. Relevant eMagiz Academy Microlearnings====
19 +**4. Relevant eMagiz Academy Microlearnings**
20 +[[https:~~/~~/emagiz.github.io/docs/microlearning/novice-soap-webservice-connectivity-authorization-calling-a-soap-webservice>>url:https://emagiz.github.io/docs/microlearning/novice-soap-webservice-connectivity-authorization-calling-a-soap-webservice]]
26 26  
27 -[[https:~~/~~/my.emagiz.com/p/question/172825635700361387>>url:https://my.emagiz.com/p/question/172825635700361387]]
28 28  
29 -//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/?]])))
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 30  
31 31  
32 32  
33 -((()))
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" %) Basic Authentication
30 +|(% style="width:45px" %) b|(% style="width:241px" %) WS Addressing - Call back
31 +|(% style="width:45px" %) c|(% style="width:241px" %) Client certificate
32 +|(% style="width:45px" %) d|(% style="width:241px" %) Mapped headers
33 +|(% style="width:45px" %) e|(% style="width:241px" %) Token based - static
34 +|(% style="width:45px" %) f|(% style="width:241px" %) Token based - dynamic
35 +|(% style="width:45px" %) g|(% style="width:241px" %) SSL
36 +|(% style="width:45px" %) h|(% style="width:241px" %) No authentication
37 +|(% style="width:45px" %) i|(% style="width:241px" %) Dynamic URL
38 +)))
34 34  {{/container}}
35 35  {{/container}}