Hello All
I have a Use Case where i have One entity Called Employees in Service Studio and i want to update Employees data using excel sheet on Button Click through Application User.
Can anyone help me in this case?
Thanks in Advance,
Sanjay
Hi @Sanjay Bankar
What I understood to your post that you want to update employees table not to create new records
If this is correct then you need to maintain one column in Excel file with unique value which will be also available in employees table for ex- EmployeesId or EmployeesName etc.
Once you set this unique column to excel then simply use exceltorecord list action to convert binary data into list then filter data in employee aggregate using that unique value and update that record.
Regards
Arun
Thank you @Arun Rajput
Your idea helped me .
Thanks
Hi Sanjay,You can check the use of Excel to record list document.https://success.outsystems.com/documentation/11/reference/outsystems_language/logic/implementing_logic/logic_tools/excel_to_record_list/.After uploading the Excel you will get the binary and pass it to the ExcelToRecordList by this you will be able to insert the data in your Employe table.Please let me know if you have more queries.Regards,Anubhav
Hi Sanjay,
few steps you need to follow
you should have an server action for use of outsystems excel to record list. and you have to set the record definition it should be. for example i am using user entity for import in the oml file. then you will get the list of the excel sheet. and then you need to use create user entity action. few validations you can apply for example excel should not be empty, the file type and so on. i am adding an oml file you can go through it. Thanks and regards Prince
hello
Sanjay Bankar
In the Bootstrap dataAchion Created In Logic Tap Remove The Check To Which Check If The entity Is Emty
On the screen Creat File Uplode With A button ON Button Click Run This Modifie Server Action
Ahmed