Submitted by gregory on 2013/09/04 04:32
Hello. Sorry for the long silence... Pierre, bonjour et j'espère que tout est bien en ordre à l'égard de mon paiement même si ceci a été fait par beaucoup trop tard ?
 
A simple query to which I can no longer find the answer. I have imported  a lot of appointments from Excel. They do not, of course, actually appear in the calendar and field ItemInCalendar is not checked. I understand that that is achieved when the date in the item is clicked. However there is no option that I can discover to request that the item be shown in the calendar, either on left- or right-click. The dialogue shown in the calendar documentation does not appear.
 
What do I need to do to get these items to apear in the calendar? And, given that I have something like eighty such items to import at a time, can some bulk import be considered, rather than having to deal with each item in turn?
 
Thank you for any useful advice!
 
 

Comments

Hi gregory !
 
Glad to see you back here on the IQ forum.
 
The simplest way to add multiple items to the calendar is to
  1. display them in a grid (numerous ways to do this, I can help if need be)
  2. select them all (mouse or Ctrl+a)
  3. Item > Create Event. By default, it will use the Appointment field as date field. If you want to use another, show that other date in the grid and select items using that column.
  4. All items will not be shown in the calendar
HTH !

gregory

2013/09/24 23:35

Permalink

Hello Pierre.
 
I forgot to say: that works, thanks!
 
Hello everyone. 
 
Note the importance of selecting the right date column before applying Item > Create Event. In my main IQbase, the appointment field is called Appointments (plural) for some ghastly historical reason which I have long since forgotten! So it's Appointments which I need to have selected when I create the events.
 
Mark Gregory, Rennes, France - GMT +1/+2; EST +6