Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Provide mass export of Data to Excel #547

Closed
metasnw opened this issue Aug 24, 2017 · 5 comments
Closed

Provide mass export of Data to Excel #547

metasnw opened this issue Aug 24, 2017 · 5 comments
Assignees
@metas-lc
Labels
branch:master branch:release priority:high type:enhancement
Milestone
2017-37

Comments

@metasnw
Copy link
Member

metasnw commented Aug 24, 2017 •
edited
Loading

Is this a bug or feature request?

feature request

What is the current behavior?

you can only copy the data you see on one page of a window

Which are the steps to reproduce?

NA

What is the expected or desired behavior?

Have a way to export all data which is selected to a File that can be downloaded and opened in excel
@metasnw
Copy link
Member Author

metasnw commented Sep 7, 2017

want to use that feature to export huge amounts of data (e.g. contacts and addresses) from a generic window

@metas-mk
Copy link
Member

metas-mk commented Sep 11, 2017 •
edited
Loading

I would propose to start the export in a given window. Then the job is triggered async. the data/ file is selected and stored. The user receives a notification that includes the download link.
Reason:
a) we don't let the user wait unnecessary time.
b) we have control over the export/transform/download of large data and can queue so that the overall system performance remains fast, even if for example 100 users decide to export at the same time.

@metas-mk metas-mk added this to the 2017-37 milestone Sep 11, 2017
teosarca added a commit to metasfresh/metasfresh that referenced this issue Sep 13, 2017
@teosarca
AbstractExcelExporter cleanup; get rid of legacy warnings
db925eb 
metasfresh/metasfresh-webui-api-legacy#547
teosarca added a commit to metasfresh/metasfresh that referenced this issue Sep 13, 2017
@teosarca
AsyncIOStreamProducerExecutor
bdb5ab3 
metasfresh/metasfresh-webui-api-legacy#547
teosarca added a commit that referenced this issue Sep 13, 2017
@teosarca
document
5d08624 
#547
teosarca added a commit that referenced this issue Sep 13, 2017
@teosarca
/{viewId}/export/excel
918a875 
#547
teosarca added a commit that referenced this issue Sep 13, 2017
@teosarca
remove debugging code
98a96f1 
#547
teosarca added a commit that referenced this issue Sep 13, 2017
@teosarca
DocumentIdsSelection: accept ALL (upper case) too
5a614fd 
#547
teosarca added a commit that referenced this issue Sep 13, 2017
@teosarca
{viewId}/export/excel?selectedIds=...
98f3a4c 
#547
@teosarca teosarca mentioned this issue Sep 13, 2017
Closed
@teosarca
Copy link
Member

teosarca commented Sep 13, 2017 •
edited
Loading

update: the export is done in a separate thread (managed by a special thread pool executor service).
I didn't implemented it using the async framework because on that level i don't have all the infos.

At the moment the executor service config is hardcoded, but easily, we will able able make it configurable. See https://github.com/metasfresh/metasfresh-webui-api/blob/98f3a4c56bfc10c97b3e2d37a84e1872eef8c666/src/main/java/de/metas/ui/web/view/ViewRestController.java#L118-L125

@teosarca
Copy link
Member

note to IT: would be easier to test when the frontend task is done.
Also pls make sure you are testing following cases:

  • no selection
  • select some rows
  • select ALL rows (from all pages)

metas-ts added a commit to metasfresh/metasfresh that referenced this issue Sep 15, 2017
@metas-ts
Update ReleaseNotes.md
88b86e3 
[#2218](#2218) User would
like to import default values for contact and address
[#2245](#2445) Support
quantity in flatrate term import
[#2361](#2361) Invoice
Candidates Action Approval for Invoicing
[#2387](#2387)
Autocomplete for zip / postal code and city
[#2298](#2298) Introduce
source-HU to fine-Picking
[#2247](#2474) Extend
Partner Import with ad_language
[#585](metasfresh/metasfresh-webui-api-legacy#585)
Lookup validation rule shall support @CtxName/Default@ annotation
[#2459](#2459) shipto and
billto contact / user
[#2436](#2436) Use
default values for IsShipTo and isBillTo when importing bpartner
[#2457](#2457) Duplicate
locations on partner import when multiple contacts
[#2463](#2463) Extend
Partner Import to support contact flags
[#142](metasfresh/metasfresh-webui-api-legacy#142)
Provide v11 / CAMT 54 File Import
[#2429](#2429) hide qty
TU when HU name is empty
[#2423](#2423) fix
jaspers for vendor return with quality issue
[#2430](#2430) Invoice
candidate close is retrieving the invoice candidates out of transaction
[#547](metasfresh/metasfresh-webui-api-legacy#547)
Provide mass export of Data to Excel
[#570](metasfresh/metasfresh-webui-api-legacy#570)
clicking print on non-document window shows error page
[#2431](#2431) Product
Filter in Handling Unit Editor
[#2413](#2413) Make
request status a search field in request window
[metasfresh/metasfresh-parent-legacy#14](metasfresh/metasfresh-parent-legacy#14)
Look for a way of not having the "placeholder" on local builds
[#178](metasfresh/metasfresh-webui-api-legacy#178)
Have Letter Feature in Sales Order Window
[#2401](#2401) vendor
return with quality discount
[#2434](#2434) Make field
ad_user_incharge_id from C_Flatrate_Term optional
[#2397](#2397) Import and
Store Contract meta-data e.g. startdate on flatrate
[#2412](#2412)
OrderCheckout Jaspers display empty C_BPartner_Product.ProductName
[#582](metasfresh/metasfresh-webui-api-legacy#582)
Cannot invoice disposal's invoice candidates
[#1060](metasfresh/metasfresh-webui-frontend-legacy#1060)
Locale viewing and editing in User Interface
[#583](metasfresh/metasfresh-webui-api-legacy#583)
Provide the document's standard actions
[#581](metasfresh/metasfresh-webui-api-legacy#581)
API to provide user session's locale

me-45
teosarca added a commit that referenced this issue Sep 18, 2017
@teosarca
DocumentStandardAction.DownloadSelected
503e59d 
#547
@metas-lc metas-lc self-assigned this Sep 20, 2017
@metas-lc
Copy link

IT
tested in metasfresh/metasfresh-webui-frontend-legacy#1197 OK

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@metas-lc metas-lc

Labels
branch:master branch:release priority:high type:enhancement
Projects
None yet
Milestone
2017-37
Development

No branches or pull requests
5 participants
@teosarca @metas-ts @metas-mk @metas-lc @metasnw