i have a txt file with data in it like this , i want to import this data to outsystems entity, could please suggest how i can i do that, txt file has almost 1000 records in it, the fileds are first name, last name,,email, with pipe symbol/vertical bar as a delimter in text file
If you plan to automate this within OutSystems, you'll need to code the process yourself. This involves reading the content, splitting it by new lines, and then further splitting each line by the '|' symbol. The resulting array should then be mapped to an Entity Record, which is then inserted into the corresponding entity.
Hi,
You can use the BinaryData API to convert the file to a series of text.
https://success.outsystems.com/documentation/11/reference/outsystems_apis/binarydata_api/
Stringsplit by NewLine() first to get each row of the file and than split again for the character that divide your columns.
Please refer to the component for the implementation.
https://www.outsystems.com/forge/component-overview/4709/convertfiletorecord-o11
which converts file to record but it's in traditional. Guess you can get the logic though.
Reference: https://www.outsystems.com/forums/discussion/42194/read-data-from-txt-file/
Hi,You can import the txt.file to Excel so you can import the Excel file to Outsystems entity. You can follow the instructions here: https://adcogov.org/sites/default/files/7156.pdf
Before uploading the txt.file in Excel make sure to replace all "|" using notepad so that you can select "tab" for its' delimiter.
Hey jeremiah Curz, thanks its working, but i want this process to be automated using timer, is there any way we can do this? please suggest!