Using Clarity 14.2 (cloud environment).
I have seen lot of threads discussing on this topics.
I have a customer requirement for reading excel data from a ftp location and xog the OBS into Clarity. As per my understanding we cannot read excel file data directly from GEL script, we can only read text data. Just wanted to know is there any best method to achieve this from GEL script.
Please share your thoughts.
Well there are many ways to solve what I think your problem is, however "reading an Excel file from GEL" probably isn't the best one for all the reasons above.
Why are you fixated on GEL - what has GEL got to do with the business problem you are trying to solve? Take a step back from the solution that you think you have started with (i.e. GEL) and look at your real problem ; "putting data into Clarity from an Excel workbook" - you can do that in a number of different ways (Java, VBA, *anything* that can read the excel file and call a web-service). There are also commercial products on the market that might make all this relatively simple for you (ITROI's stuff springs to mind).
Thanks for your suggestion Dave.
Yes, I am thinking alternative way to do this.
Retrieving data ...