Hi, I have one *.txt file (event log file) which generating from one of our machine. I want to read this text file & pick required event data from this file & store it on SQL for future reference. How to read the text file from Outsystems. So, help me on this matter.
Marcelo Ferreira wrote:
Hi Skumar,
Check if this can help you https://www.outsystems.com/forge/Component_Overview.aspx?ProjectId=4709
Regards,
Marcelo
Hi Marcelo,
Thanks for sharing sample OML to read text file.
But I am not getting data from the text file. The table record showing 'No items to show...' . While debug found BinaryData showing 0 bytes. See below image.
Also attached Text.txt file which try to read in Outsystems.
You can use this function BinaryDataToText and than stringsplit by NewLine() first to get each row of the file and than split again for the character that divide your columns.
Thanks Mr. Marcelo for quick replay.
Do have any sample OML with you. Pl, share here.
Use that extension: https://www.outsystems.com/forge/component/99/network-filesystem/
Skumar wrote:
Now it is working, actually I set OK button method property to Ajax Submit, now I change to Submit. After this it is working fine.
Hi,
Glad I could help. Yes to get files from upload you need to use a submit button. The Ajax Refresh on OK is the one that should be deleted