Skip to Content

Changes for page Excel to CSV < 2007

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

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -REST - Request & Response
1 +Excel to CSV < 2007
Content
... ... @@ -1,33 +1,35 @@
1 1  {{container}}
2 2  {{container layoutStyle="columns"}}
3 -(((1. How to use
4 -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.
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.
5 5  
6 -2. Keynotes & restrictions
7 -Note that you need to select the valid authentication based on the requirement of the external system.
7 +== Documentation ==
8 8  
9 -3. License Information
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 +
12 +==== 2. Keynotes & restrictions====
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====
10 10  Part of the standard license agreement as agreed upon when using the store for the first time.
11 11  
12 -4. Relevant eMagiz Academy Microlearnings
13 -https://emagiz.github.io/docs/microlearning/intermediate-rest-webservice-connectivity-index
25 +==== 4. Relevant eMagiz Academy Microlearnings====
14 14  
15 - Would you please consult the privacy policy of eMagiz at the following link: https://www.emagiz.com/privacy-policy/
16 -]])))
27 +[[https:~~/~~/my.emagiz.com/p/question/172825635700361387>>url:https://my.emagiz.com/p/question/172825635700361387]]
17 17  
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/?]])))
18 18  
19 19  
20 -((((% border="2" cellpadding="10" cellspacing="10" style="width:292px" %)
21 -|=(% style="width: 45px;" %)#|=(% style="width: 241px;" %)Option
22 -|(% style="width:45px" %) a|(% style="width:241px" %) OAuth 2.0 - Authorization Code
23 -|(% style="width:45px" %) b|(% style="width:241px" %) REST - Basic Auth
24 -|(% style="width:45px" %) c|(% style="width:241px" %) REST - Client Certificate
25 -|(% style="width:45px" %) d|(% style="width:241px" %) REST - Header Mapper
26 -|(% style="width:45px" %) e|(% style="width:241px" %) OAuth 2.0 - Client Credentials
27 -|(% style="width:45px" %) f|(% style="width:241px" %) REST - SSL
28 -|(% style="width:45px" %) g|(% style="width:241px" %) Dynamic Token
29 -|(% style="width:45px" %) h|(% style="width:241px" %) Token
30 -|(% style="width:45px" %) i|(% style="width:241px" %) No Authentication (Fire & Forget)
31 -)))
32 +
33 +((()))
32 32  {{/container}}
33 33  {{/container}}