Create an upload function to update the entity

Jace Jace

Question

Hi,

I would like to create a upload function to update my entity with excel sheet.

My plan was to delete the data in the entity and then update the entity with the new excel sheet (data).

The update function have to make sure that all the data format are correct and rollback the transaction if there are error.

Thanks

06 Oct 2017

IQ78

hi, jace

- you can upload the excel

- then use excel to record list

- loop the list

- raise exception if wrong.. it will rollback in the exception handler

regards,

06 Oct 2017

2 replies

Last reply 09 Oct 2017

Show thread

Hide thread

Jace Jace

hi, jace

- you can upload the excel

- then use excel to record list

- loop the list

- raise exception if wrong.. it will rollback in the exception handler

regards,

ok i will give it a try. It is using screen action?

09 Oct 2017

Kilian Hekhuis

MVP

ok i will give it a try. It is using screen action?

Hi Jace,

You can put it in a Screen Action, but that has two downsides:

It may take too long if the Excel file is really big. The browser can then generate a time-out, and you're import is aborted. If that is the case, you need to think about using a timer to do the import.
If the logic to import and save is complex, i.e. there's actual business logic involved (rather than just dump the data in an Entity), it's better to keep that seperated from your screen logic, for better code maintainability (you may even want to put it in a seperate eSpace).

09 Oct 2017

IQ78

you create server action and run it from screen action or using timer.

regards,

09 Oct 2017

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.