Skip to Content

Changes for page Excel to CSV < 2007

Last modified by Erik Bakker on 2023/01/31 10:20
From version 8.1
edited by Erik Bakker
on 2022/05/02 09:31
Change comment: There is no comment for this version
To version 19.1
edited by Erik Bakker
on 2022/05/02 15:14
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
... ... @@ -2,40 +2,34 @@
2 2  {{container layoutStyle="columns"}}
3 3  (((
4 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.
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 7  == Documentation ==
8 8  
9 9  ==== 1. How to use====
10 -Ensure to locate the right connectivity method and import the right flow fragment.
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 12  ==== 2. Keynotes & restrictions====
13 13  
14 -* These flow fragments will contain only the eMagiz components to make a call to a SOAP based webservice.
15 -* 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.
16 -
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 +
17 17  ==== 3. License Information====
18 18  Part of the standard license agreement as agreed upon when using the store for the first time.
19 19  
20 20  ==== 4. Relevant eMagiz Academy Microlearnings====
21 -[[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]]
22 22  
27 +[[https:~~/~~/my.emagiz.com/p/question/172825635700361387>>url:https://my.emagiz.com/p/question/172825635700361387]]
23 23  
24 -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/?]])))
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/?]])))
25 25  
26 26  
27 27  
28 -((((% border="2" cellpadding="10" cellspacing="10" style="width:292px" %)
29 -|=(% style="width: 45px;" %)#|=(% style="width: 241px;" %)Option
30 -|(% style="width:45px" %) a|(% style="width:241px" %) Basic Authentication
31 -|(% style="width:45px" %) b|(% style="width:241px" %) WS Addressing - Call back
32 -|(% style="width:45px" %) c|(% style="width:241px" %) Client certificate
33 -|(% style="width:45px" %) d|(% style="width:241px" %) Mapped headers
34 -|(% style="width:45px" %) e|(% style="width:241px" %) Token based - static
35 -|(% style="width:45px" %) f|(% style="width:241px" %) Token based - dynamic
36 -|(% style="width:45px" %) g|(% style="width:241px" %) SSL
37 -|(% style="width:45px" %) h|(% style="width:241px" %) No authentication
38 -|(% style="width:45px" %) i|(% style="width:241px" %) Dynamic URL
39 -)))
33 +((()))
40 40  {{/container}}
41 41  {{/container}}