Hi
I am very new to OutSystems. I have a requirement, where a CSV ( or any other file, but mainly text fields) file needs to be parsed, transformation/calculations to be applied and same result should be shown in multiple pages of the web page.
Input file can be 10K+ records
Whats the best step by step process to do this? Including creating UI/applying rules and mapping these results to various fields in different pages
Hi Rohit,
Welcome to the OutSystems community.
The first suggestion I would like to make is to consider following at least the guided path to becoming a reactive web developer.
https://www.outsystems.com/training/paths/
This will enable you to better understand the concepts of OutSystems, which allow you to translate your requirements into code.
Breakdown your requirements and define per requirement how you could solve it.
Upload/Parse a CSV file
The OutSystems Forge has many components around converting CSV to Excel or to import/export CSVs. See https://www.outsystems.com/forge/list?q=csv&t=&o=most-popular&tr=False&oss=False&c=%20&a=&v=&hd=False&tn=&scat=forge
One component I have used multiple times with good results is: https://www.outsystems.com/forge/component-overview/636/csvutil
it also has good documentation on the forge page.
Transform and apply calculations
Once you have imported the CSV into an OutSystems data model it should not be difficult to read and transform data to your needs or do calculations. This is about reading the data, executing some low code logic, and writing the result to some other tables or presenting it on your screen.
OutSystems provides out-of-the-box screen templates to give you a quick start to define the look and feel of screens.
Happy coding!
Regards,
Daniel