c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #32223
Re: [Bug 850752] Re: fnct_search missing for many function fields
Hello,
Let me comment that a Akretion we also have several customer very
embarrassed by the lack of filtering of product quantities with 0.
As for the Inventory Analysis, it turns out it is extremely slow in 6.0 with
many moves and indeed, it's impracticable to export as far as I know.
We actually even lost one of our first hardly conquested Brazilian customer
because of such issues and also the useless dashboard (that even need to be
removed thanks to our addons-no-fluff branch) that were making
OpenERP impracticable in a 10 users companies but with many moves (an
audiobook editor). An other customer of us is #2 in the USA and we believe
it's only because of such size that we manage to tackle such bugs one by one
by developing workarounds. Had them been smaller they would have give up
too. So those issues really matter.
So just weighting in to tell that indeed, what Ferdinand has reported is a
quite important issues for companies with many moves.
On Fri, Sep 16, 2011 at 10:27 AM, Olivier Dony (OpenERP) <
850752@xxxxxxxxxxxxxxxxxx> wrote:
> On 09/16/2011 01:33 PM, Ferdinand @ Camptocamp wrote:
> > 1) Warehouse>Reporting>Inventory Analysis the grouping does not work
> > correctly currently (can not group by location AND product - its
> > always product/location regardless in which order the buttons are
> > pressed) so I can not try and confirm
>
> We would have to analyze this as a bug and reproduce it, because as far
> as I can see it works well in the 3 clients I just tested: 6.1-web,
> 6.0-web and 6.1-gtk, and I can have grouping as Location>Products
>
>
> > 1a) IMHO nevertheless needs a button "Show only not zero" (default
> > ON) , because all products where in=out will be shown with 0 Quantity
> > - in the long run almost every product. (instead of making everyone
> > create/save a function "Quantity is not equal 0" - which of course
> > works here as qty is a DB (view) field)
>
> Why not, that could be nice to have.
>
>
> > 1b) the result of any grouped views as "Inventory Analysis" can
> > neither be printed nor exported for further processing - a missing
> > feature
>
> The Print button on any Analysis view should work well in the GTK client
> to export the data as PDF, also respecting the grouping. And for the web
> client, all browsers let you print the current page with their built-in
> print menu.
>
> As for CSV export, we tried to provide a basic support for the "export
> data" wizard on all analysis views, similarly to what works on normal
> tables. Just tested on the 6.0-web branch on runbot (exporting the
> inventory analysis view after unchecking 'import compatible' mode) and
> it seems to mostly work (you can export the data), but maybe not in all
> cases.
>
>
> > BTW we are working on a XML/CSV export utility which is started by a
> > wizard and runs on the server to avoid transfer timeouts etc.
> >
> http://bazaar.launchpad.net/~c2c/c2c-rd-addons/trunk/view/head:/table_generate_xml
> > - draw back - OpenOffice does not import all +100.000 CSV raw data we
> > export.
> > - workaround - create a module/view in OpenERP that groups before
> > export.
>
> Great, all contributions are always welcome!
> The case of timeouts for long-running wizards might need a proper
> solution, though, rather than workarounds.
>
>
> > 2) the wizard that opens inventory for a location could have an
> > option to show only available products * this is what I have done for
> > v5 already - should be come standard and default in many wizards
>
> Excellent, could you perhaps provide a minimalistic merge proposal for
> adding that to trunk, in order to make it available in standard addons?
>
>
> > 3) Koo I thought of incremental display of data to avoid the
> > necessity to compute all lines at once
> > and (new) apply filters on the computed results.
>
> Afraid that won't help for function fields, as performing a correct
> search/filter would still require loading the whole table - no magic
> bullet.
>
>
> > IMHO there is no reason why filters can not be applied to results
> > (appart that it is not coded)
> > the "simple" rule
> > domain
> > * is DB field - add condition to SQL WHERE query
> > * else filter results.
> > would do it.
>
> My opinion is that this is very counter-intuitive and would be a great
> cause of hidden mistakes for most users - how will they be able to tell
> the difference between the two cases?
>
>
> > 4a) one day we will need materialized views (period sums) to avoid
> > expensive computation based on millions of stock_moves in one of our
> > former installations we have some 50000 moves for the most frequent
> > used products (for ~ 10 years)
>
> Yes we have considered several solutions for this, some suggested by
> community contributors, including you ;-)
> We haven't found the right solution yet, but we hope to address this in
> the near future.
>
>
> This is getting long indeed, perhaps this discussion is best continued
> on the mailing-lists rather than this bug report ;-)
>
> Thanks for your feedback, as usual!
>
> --
> You received this bug notification because you are a member of OpenERP
> Drivers, which is subscribed to OpenERP Addons.
> https://bugs.launchpad.net/bugs/850752
>
> Title:
> fnct_search missing for many function fields
>
> Status in OpenERP Addons (modules):
> Won't Fix
>
> Bug description:
> according to
> https://bugs.launchpad.net/bugs/823049
> it will be possible to search for function fields store = false if
> fnct_search is defined
>
> a quick search shows
> 280 function fields in addons
> 14 fnct_search
>
> it would enhance the user experience a lot if at least for the most
> important function a searech could be defined for 6.1
> as it is the rebirth of a lost feature available in v5 it would also easy
> migration.
>
> will you implement search functions if we / the community nominates some
> important candidates ?
> like
> * product stock available / on hand
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-addons/+bug/850752/+subscriptions
>
--
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/850752
Title:
fnct_search missing for many function fields
Status in OpenERP Addons (modules):
Won't Fix
Bug description:
according to
https://bugs.launchpad.net/bugs/823049
it will be possible to search for function fields store = false if fnct_search is defined
a quick search shows
280 function fields in addons
14 fnct_search
it would enhance the user experience a lot if at least for the most important function a searech could be defined for 6.1
as it is the rebirth of a lost feature available in v5 it would also easy migration.
will you implement search functions if we / the community nominates some important candidates ?
like
* product stock available / on hand
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/850752/+subscriptions
References