Hi all
I want to upload a file with data type .txt and then the uploaded file becomes one database table.
like bootstrap excel, but I don't know how to bootstrap a file with the .txt data type
Hello
You cannot bootstrap data from a text file directly, you need a conversion, and convert it to Excel file with headers as columns matching your entity col , then you can bootstrap the data from a text file, directly not possible.
ThanksTousif Khan
Hi Sherly Se,
If that file is a csv txt file you can import using excel to have the file in excel format. Then add a row to place a column field name.
Use that excel in service studio to create an entity based on excel.
Hope that it helps you
Hi Sherly,
I noticed that this question is identical to this one.
So, I will suggest you try the same: first, you will need an upload node to upload the .txt file, then, I would suggest you take a look at this API:
https://success.outsystems.com/documentation/11/reference/outsystems_apis/binarydata_api/
You might want to use the BinaryDataToText.
After that, you will need to create some logic, perhaps using some StringSplit to normalize the data before saving it to the database.
Regards,
PZ