Skip to Content

Changes for page Excel to CSV < 2007

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

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -Excel to CSV < 2007
1 +Call AS400 (IBM iSeries)
Content
... ... @@ -2,32 +2,28 @@
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 +This store element contains the Groovy script that allows you to invoke a custom AS400 program on that machine. The program will most likely require parameters that are needed to execute the program. These parameters can be modeled as system message.
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 +Ensure to understand what iSeries Program is invoked including the parameters of that program. These parameters are the system message.
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.
14 +* Note that this is a custom Groovy script that works on the current infrastructure of eMagiz.
16 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 -
16 +* The headers in the header component need to match the names on the third line of the groovy script
17 +* Please check out the following link to learn a bit more about Groovy: https://www.tutorialspoint.com/groovy/index.htm
18 +
22 22  ==== 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 25  ==== 4. Relevant eMagiz Academy Microlearnings====
26 26  
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"]]
24 +None
29 29  
30 -//Would you please consult the privacy policy of eMagiz at the following [[link>>https://www.emagiz.com/privacy-policy/||target="blank"]])))
26 +//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 32  
33 33