Submitted by gregory on 2010/03/30 02:38
My main InfoQube database is based on my previous main Ecco file. It therefore contains over 13 000 historical and future appointments, and over 20 000 items in all. It is 43Mb in size.

The calendar is a separate control whose integration into InfoQube appears somewhat tangential. This has serious practical implications.
 
I am a teacher. I have therefore frequently to introduce a whole series of appointments at the same time. The calendar recurring item works fine for regular events, like weekly classes. However, it is not effective for irregular occurrences. I am trying to enter a sequence of events, which do not have a regular frequency but have similar names.
 
It is not possible in the calendar grid itself, specifically to copy an event to the clipboard and then paste it back in another timeslot. Instead, the only thing that can be done is to control and click on the event, creating a new copy; then to change the date and time associated with the new occurrence. Up to a point, this works. There are two events, visible in the calendar grid. However, the items do not become visible in the appointments grid for literally several hours. Meanwhile, back in the calendar grid, the calendar refresh button is greyed out, and the properties pane is not in synchronisation with the new items. When the cursor is hovered above the new item in the grid, an hourglass symbol flickers in and out of view.
 
The calendar looks like this:
 
 
The properties pane is not synchronised:
 
 
Note that the calendar items are not visible in the appointments grid, which is sorted by appointments desc(ending) and has been refreshed:
 
 
 
Even closing and opening the IQbase does not change the situation.The new calendar items are not synchronised with the properties pane.
 
UPDATE: I have just tried to control and click an appointment, creating a third item; when I click on the third item, IQ crashes.

The way I used to create a sequence of events in Ecco was that I worked in the appointments grid (Ecco folder), copying and pasting the event, then changing the date and time property in the calendar view. Although theoretically possible in InfoQube, for me this is wholly impractical because of the very slow synchronisation / refresh between the calendar control and the appointments grid.

I rather suspect that the only way you will be able to investigate the issues in this database is to make a copy of it available to you. However, it is too large to send by e-mail. Can I once again ask that there be provided a parking space on the forum visible only to you and the individual user who is posting the item?

It may well be the case that I will have to delete all the historical appointments, keeping them in a separate IQ base. However, my very large IQ base is probably quite a useful performance test-bed!

Another consequence of the fact that the calendar control is not very well integrated into the rest of the programme is that the calendar has localised itself to my French environment, and therefore displays the names of days, etc in French. However, I currently have the main program setup in the English language. This behaviour is  for me, amusing rather than annoying. Nevertheless, it should perhaps be investigated.
 
Mark
 
UPDATE 0.9.25 pre-rel-20 portable

Comments

Hi Mark,
 
I don't observe any delay when creating calendar events in a grid. It is instantaneous. Do you observe the same delay with a sample database ?
 
If it is only your file, and you can share it, best way for now is to put in on a Dropbox folder and send me the private link to the file. If you want, you can click this link to join DropBox (as a bonus, I'll get 250MB of free storage )
 
 
As for improvements copy/paste not creating calendar events, I've created a Mantis issue : 0918: Copy / Paste item does not copy Calendar event
 
HTH

gregory

2010/04/01 22:35

In reply to by Pierre_Admin

Sorry for the slow reply.
 
Following up on your hint:
 
I have created a completely new IQbase with sample data. I click for Calendar view.
 
Immediately, the behaviour is a little strange:
 
The calendar opens with two appointments for today's date. However, the properties pane shows that the appointments are actually for a date in November last year... The first tells me that I have lunch with Mary. Whoopydo, I rather like Mary, so I'm pleased.
 
Next, I open the Appointments grid. This shows only two appointments, neither corresponding to the items showing in the calendar.
 
Next, I open a Journal view. No calendar items appear. I display the appointments field. None of the display items have appointments. Presumably some filter is in operation, but as yet IQ doesn't show what filters are currently applied.
 
I add an Appointment to an item appearing in the Journal, and click the option to Show in the calendar. I switch to the Calendar, and the item I have just modified is showing today but also, twice, on Friday! And no, I have set no recurrences. Meantime, my lunch appointment with Mary has vanished, which upsets me for two reasons, one being that I rather liked the idea of lunch with Mary, the other being that I do not understand how and why IQ is behaving as it is.
 
 
Back to the Appointments grid. I refresh this, and still no visibility of the various items showing in the Calendar.
 
I search for items including Mary, and discover that there is still an item entitled Lunch with Mary. My hopes rise! I display them in the Scratch grid. I add the Appointments field to the grid - but it is blank. It seems that my lunch is indefinitely postponed. My heart sinks.
 
Qu'est-ce qui se passe ici ? What's going on in all this?
 
I'm running pre-rel 21 portable on Windows XP SP3.
 
Mark Gregory, Rennes, France - GMT +1/+2; EST +6

Pierre_Admin

2010/04/01 23:16

In reply to by gregory

Hi Mark 
  1. Lunch with Mary is a recurring event, that is why it is shown now, even if the properties pane shows November of last year.
  2. Appointment grid: The DateFilter is on. Remove the filter and the other items will now show 10 appointments
  3. Journal grid: Again, these are recurring events so not shown there
  4. 2 entries of the same event: I've seen this a few time but can't reproduce it now. I'll track this before 0.9.25 is released.
  5. Disappearing Lunch with Mary: Can you reproduce this, as I can't.
  6. Found Lunch with Mary in live-seach: No appointment indicates that you deleted the item in the Calendar. If you didn't, it "could" be linked to the duplicate (item 4 above)
 Summarizing:
  • Items 1 to 3 are by design (in fact, Ecco would behave exactly the same)
  • Item 4 is a bug
  • Items 5 and 6 may be consequences of the bug
HTH

gregory

2010/04/02 07:26

In reply to by Pierre_Admin

Thanks for that illuminating reply.
 
Here are some comments / observations:
 
# My original comment Pierre's reply My observation / question
1 The calendar opens with two appointments for today's date. However, the properties pane shows that the appointments are actually for a date in November last year... The first tells me that I have lunch with Mary. Whoopydo, I rather like Mary, so I'm pleased. 1. Lunch with Mary is a recurring event, that is why it is shown now, even if the properties pane shows November of last year. Comment: It's a shame that the fact that the event is recurring is not visible in the properties pane. In fact you can only see that if you click on the Recurrence button in the appointment details screen (or of course it IS made obvious in the Calendar view by the circular-arrow symbol).
2 Next, I open the Appointments grid. This shows only two appointments, neither corresponding to the items showing in the calendar. 2. Appointment grid: The DateFilter is on. Remove the filter and the other items will now show 10 appointments Comment: If I were a new user, I wouldn't know about the source bar. I have just found it difficult (means it took 15 minutes of wandering around the manual and the IQ menus!) even to be able to display the source bar. If I didn't know it existed, I wouldn't have looked for it...
But: Great, I remove the date filter and I can see the other appointments.
3 Next, I open a Journal view. No calendar items appear. I display the appointments field. None of the display items have appointments. Presumably some filter is in operation, but as yet IQ doesn't show what filters are currently applied. 3. Journal grid: Again, these are recurring events so not shown there I thought the whole point of the Journal view was that it shows everything? But no huge issue; I can see all the appointments now that the date filter is off in the Appointments view. I only went to the Journal view because I wasn't previously seeing all the appointments.
4 I add an Appointment to an item appearing in the Journal, and click the option to Show in the calendar. I switch to the Calendar, and the item I have just modified is showing today but also, twice, on Friday! And no, I have set no recurrences. Meantime, my lunch appointment with Mary has vanished, which upsets me for two reasons, one being that I rather liked the idea of lunch with Mary, the other being that I do not understand how and why IQ is behaving as it is. 4. 2 entries of the same event: I've seen this a few time but can't reproduce it now. I'll track this before 0.9.25 is released. I can reproduce this… But I cannot then re- reproduce it!

I attach an IQBase in which an item Groceries appears three times in the current week. I think I created it by using CTRL+click - but only once, not twice as the Friday entries seem to suggest.

Is there an ItemID for a calendar event?
5 Disappearing lunch with Mary 5. Disappearing Lunch with Mary: Can you reproduce this, as I can't. I can reproduce this. Suppose I have Lunch with Mary selected in the calendar.  Then in Appointments view I establish an appointment, say for Groceries, which happens to correspond in date to the event Lunch with Mary. The Calendar displays only the Groceries event - not Lunch with Mary. Going back to Appointments view, Lunch with Mary is NOT visible in the (unfiltered) list.
6 Found lunch with Mary in search grid 6. Found Lunch with Mary in live-search: No appointment indicates that you deleted the item in the Calendar. If you didn't, it "could" be linked to the duplicate (item 4 above) And this time when I search  I cannot find any Lunch appointments at all. Sigh. Then, a few minutes later, without any obviously related activity, Lunch with Mary is suddenly showing in the Quick Search (Search Entire File). It still doesn't show in the calendar, though, until I explicitly reset it to appear there.
 
Mark Gregory, Rennes, France - GMT +1/+2; EST +6