29
Views
5
Comments
Solved
How to Import Data using excel so as to update the existing Data in Entity
Application Type
Reactive

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


Champion
Solution

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 

importrecords.oml
Champion
Solution

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

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

Regards

Ahmed 

853970f0-2b81-4da7-bf1f-941d89ae0ab1.jpg
WhatsApp Image 2023-10-27 at 4.12.29 PM.jpeg
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.