I got binary data in the form of XLSX from an api i want to insert that data in one of my table i want to convert that binary data into text or CSV format when I a using binary to text conversion it does not work properly please suggest me some forge component or any other way to achive this
Hi,
You can try then to use this extension:https://www.outsystems.com/forge/component-overview/9990/xlsxtocsv
Regards,
Daniel
Hi Piyush,
You cannot use functions like binarytotext conversion to convert an XLSX file to text or comma separated file. How would that function know the type of file to convert?
Either you use the OutSystems Built in widget to convert an excel in a Record List that you than can convert to a CSV file, or you use a more advanced Forge component for more advanced scenarios.
Here are a few Forge components to explore:
@Daniel Kuhlmann I want to apply this logic in the timer i am getting binary data from API then i have to insert them in a table server side both of these component does not help
Why not just store the binary in an entity.
And then use these components to read the binary and convert it to CSV on request?
Both of these component does not offer any server action to convert Excel to CSV and after storing it in entity we still have to convert them and i cannot find any action to convert excel into CSV
@Daniel Kuhlmann This component is not download able nor it is opening
Yes it is, but it is an extension .xif
So what you have to do is.go to the Forge via www.outsystems.com.
Download it from there and then load it into your environment via service studio or service center
thanks @Daniel Kuhlmann It worked