search

pegros / PEG_EXCEL

Set of LWC Components leveraging the SheetJs library to import / export records from / to Excel spreadsheet directly from the Lightning UI.
MIT License
0 stars 0 forks source link

[feat] sfpegExcelLoaderCmp - Possibility to download import results #1

Closed priyancajogoo closed 1 year ago

priyancajogoo commented 1 year ago

Is your feature request related to a problem? Please describe. Regarding the import results are shown in an iteration using only the key. However for bulk imports the way the failures and success are shown is not convenient/ readable for end users.

Describe the solution you'd like The possibility to download the failures and success in a CSV/Excel file with the same columns as the import file + the Id of the success and errors of the failures.

Describe alternatives you've considered Having the excel import file headers and import results exposed as a property so it can be handled and exported by a parent component.

Additional context Import with Id and without Id and Name

pegros commented 1 year ago

Simplest solution would be to export results as CSV, leveraging existing feature on sfpegListCmp (see _PEGLIST repo). I shall give it a try rapidly. @priyancajogoo

priyancajogoo commented 1 year ago

Hello @pegros , will it be possible to export the result in the same format as the import file which will be an excel file? For large imports, there is also a delay between clicking the button and displaying the results. Will be possible to disable the import button or display a spinner after the import button is clicked to avoid multiple clicks?

Thank you.

pegros commented 1 year ago

@priyancajogoo I implemented a first version of the Summary export and tried to add a spinner for the initial upload. This is still work in progress but it should already help you.

pegros commented 1 year ago

FYI @jstukas

priyancajogoo commented 1 year ago

Hello @pegros, Will it be possible to make the component accessible in flow please? Thank you

pegros commented 1 year ago

@priyancajogoo I shall give it a try

pegros commented 1 year ago

@priyancajogoo I just added Flow Builder support (see commit c4da1c4) FYI @jstukas

priyancajogoo commented 1 year ago

Hello @pegros , could you give us an update on the status of the export functionality please?

pegros commented 1 year ago

Have you tried the latest version ? Is it not enough ?

priyancajogoo commented 1 year ago

Hello @pegros, Yes we have tried the latest version where the errors are exported in another tab. However it would be more helpful for users to receive the error on in the same sheet as the input with the error column in the last position (same as data loader/salesforce inspector's result format). Hence, users can simply correct the lines needed without having to do a find/vlookup.

pegros commented 1 year ago

@priyancajogoo Final update done. The summary export provides details per original imported line. see 94a4767

FYI @jstukas