Calendar View not shows all records

[René Glauser]

The calendar-view does not show every entry in calendar. There seems to be a global limit of 100 records. If there are more then 100 records in the database, a lot of records are not visible in calendar-view. The limit should be only on the visible part of the calendar-view !

[DBR (OpenERP) (dbr-openerp)]

Hello ,

For show more than 100 records in calendar view,
You have to assign limit from that object's action.
Please check it and notify us. [See the attached screenshot]

Thanks.

[René Glauser (rene-glauser)]

Yes I can increase limit in object's action, but this does not solve my problem. I made tests with a completely new database and created a total of 150 meeting records (one meeting-record per day started 1st of April 2011). When I then open calendar list-view ther is no problem...every meeting is shown in the tree depending on the limit set. But when I then change to calendar view, only the first 100 records (ore more if limit increased as discribed above) startet from 1st April are shown when i switch through different months. When limit is reached, calendar view stays completely empty even if there are meeting-records (one per day) in the database for the days shown in the actual month/week/day in calendar view...
In my opinion it seems to be a bug, that the limit ist not applied to the visible part of the calendar-view.....

[DBR (OpenERP) (dbr-openerp)]

Hello René Glauser ,

Would you please elaborate more like you have problem with month option or also with day and week option.
Still I am not able to get actual problem. Because as specification, one record per day so as per month its work ok .
if one day have multi records then limit comes in action, for week it is working fine.

I have tested calendar view as you specified, with some dummy data :)
On the basis of that I have attached video so please check it and notify us where you face the problem.
Waiting for your replay...

Thanks.

[René Glauser (rene-glauser)]

Hello
I have realy strange behaviour with day & week & month view in GTK-Client. Behaviour is not exactly the same in Web-Client but very similar. Records are not shown correctly. I attached some screenshots, where you can see the strange behauviour during switching from month<>week<>day view for exactly the sam data. I can't discover a regularity how records are shown or not....but it has something to do with the limit set. I could also discover that displaying of records is different when I switch back to tree-view, doing some sortings with table-columns and switching back to calendar-view.

[DBR (OpenERP) (dbr-openerp)]

Hello,

On the basis of comment # 6, I have tested the calendar view and face the problem.
So, I am confirming this issue.

Thanks .

[Ravi Gadhia (OpenERP) (rga-openerp)]

Hello René Glauser,
          In lp:~openerp-dev/openobject-client/trunk-calendar_speed_imp-rga we improve switching between month<>week<>day same as web client (comment # 6) and it will merge soon with trunk client

         Calendar view should not display all record irrelevant of the limit. At time of switch from list view --> calendar view list view's limit should apply on calendar view. or we can change limit by action in case of direct load calendar view

         If we try to load all the records without considering the limit then it takes much time to load all the record(e.g. 1000+ event in a day) so it's not feasible as default behavior and as a result the end user needs to wait for unpredictable time to see the results.

correct me if I am missing something.

Thanks

[Quentin Peyramale (ADN) (peyramale-q)]

Hello everyone,

it is not corrected or it is a similar bug that I have but it happens on two servers and databases with no link (6.0.2 and 6.0.3). One have +400 meetings and the lasts ones do not appear at all in calendar view on Web and GTK. I make a backup and delete until I have 100 meetings, and the problem gone! It's a big issue, i can't keep all my records in the same table.
I attached th differences between +400 and 100 meetings view on September.

[Naresh(OpenERP) (nch-openerp)]

Hello Quentin Peyramale,

As ravi has already explained in comment #8 may be you didn't understand it well. Let me explain it again .
Calendar view is either accessed by switching from form/list view to calendar view or an action created which directly launches action for calender view. in the first case we take into account the limit defined on the list view and in the latter we take into account the limit defined in the action / the default limit 80 records. Now imagine if we dont consider the limit and load all the meetings/events then how much time consuming it will be say if there are 1000+ events. The user will have to wait for unpredicted time to get all his records loaded. So it does not seem feasible to have by default all records loaded in a calendar view.
if you want you can increase your default limit.

and the fix for the mode switch in calender has already been fixed at lp:~openerp-dev/openobject-client/trunk-calendar_speed_imp-rga

Correct me if I am missing something !

[Quentin Peyramale (ADN) (peyramale-q)]

Thanks for your response.

I understood and I tried this trick before add this comment. But it has no effect on GTK and Web (normal) client on the calendar view, just on the tree view. And even if I just want to display the meetings of one person (around 10 meetings), the bug still there. Maybe I can make an access on our demo server with a special database? Where can I send you the elements if you agree?

[Remy van Nieuwenhoven (kalpa)]

I have the same problem that more then 100 appointments are not visible in the calendar-view. It is really very sad that the company is not doing anything to fix this bug.

I have practically solved it by first going to the search-view. There I select the date from today until 3 months further. My past appointments are hundreds, but my future appointments maximum 25. So in this way I have maximum 25 appointments in my selection, and I see all (future) appointments in the calendar-view.

[Quentin Peyramale (ADN) (peyramale-q)]

Hi

Check this: https://bugs.launchpad.net/openobject-addons/+bug/873399
Don't forget to raise the limit in get_recurrent_ids.
It loads now the meetings of current interval date on 6.0.3.
I make a little update by add:
  1332 if result:
  1333 ids = list(set(result)-set(recur_dict))
+1334 else: return [] #to load empty day

Now I faced to the limit of 196 meetings in 1 month on th Web Client. With 197 it won't load. Even if I increase the limit.

With the GTK, it works.
Thanks

[Quentin Peyramale (ADN) (peyramale-q)]

Oops! Forget the: else: return []#to load empty day
You have a empty Tree after that otherwise , sorry.