InfoQube IM - Community

Submitted by EveryWord on 2014/02/12 16:32

GCal2Excel.com is a potentially useful online tool for us while we're waiting for the enhanced Calendar w/ sync. It produces either an Excel file or a .CSV file from one or more Google calendar exports.

It's output is a simple file with only 5 fields; however, I don't know how the GCal2Excel columns should be mapped to something in IQ so as to make them appear in the IQ Calendar.

Can I get a little help?

Comments

Hi EveryWord,

Sounds like a good idea -- note, however that the calendar syncing capabilities will come soon as it's the next logical step.

That said, there is:

1- an "Appointments" date field which -- I think -- is used by default

2- an "ItemDuration" field (in hours) for the event/appointment duration

3- an "ItemInCalendar" Boolean (Y/N) field that indicates whether the item appears in the calendar or not.

Event text goes in the "item" field

HTH!

-------------------------------------------------------

Windows 8

Sony Vaio S Series 13 (SVS131E21L)

Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

Just an small addendum to what Armando wrote, once imported, you'll need to select imported items, right-click and select Create Event

HTH

And just another addendum

To select the imported items :

- Open the "Appointments" grid (or create a grid named "Appointments" if you don't have one -- > Right click on any tab : "New Grid", name it Appointments; open it etc.)

- OR use the "journal" grid (if you have such a grid in your setup) and use the date filter toolbar (alt+S to see the source/filter bar and then click on the "D" button to activate the date filter toolbar) to see items just created. The journal grid is just grid without a source (the main filter) or any secondary filter, except for... the Date filter toolbar. See "5.2 Filtering" in the help file.

(Then, you can select the imported items, right-click and select Create Event)

-------------------------------------------------------

Windows 8

Sony Vaio S Series 13 (SVS131E21L)

Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

OK, I've taken a whack at this, and it proved to be an interesting exercise for learning about fields & grids. I'd say I was ~70% successful; here's where I had hang-ups:

I mapped the GCal2Excel fields this way: Event Title into Item; Start Date/Time into Appointments; End Date/Time into EndDate; and Event Duration into Duration. No problems there.
Couldn't for the life of me figure out how to map the Event Description/Details into a useful IQ field:
- In the grid view, I'd like this to go into the HTML Editing Pane for visibility & markup;
- In the Calendar view, I'd like it to appear in the Event Description field of the Event dialog box that pops up when you double-click an item in the calendar.
- What are these fields in IQ?
Similarly, the "Where," "Meeting," and "Private" fields in the Event dialog/pop-up: What fields are these? Can they be shown in the Appointments grid?
I've seen how items in a grid view can be selected and calendarized via "Item - Creat Event," but shouldn't I be able to do this by showing ItemInCalendar in the Appointments grid, and then toggling them on or off in the grid view, via the Boolean check box?
In the Calendar view, I see controls for scrolling horizonally, but not vertically. This is true no matter which view I'm looking at (1, 5, 7 days, etc.). This is a problem because most of my meetings happen in the evening, but I can't scroll down to see them.

Thanks *very much* for your suggestions --

>I mapped the GCal2Excel fields this way: Event Title into Item; Start Date/Time into Appointments; End Date/Time into EndDate; and Event Duration into Duration. No problems there.

That seems ok. But I don't think you really need to map the end date/time field -- duration takes care of that since the end date/time is calculated from the start date. End date time could be useful in the case of a gant chart maybe, where you have some time off between start and end... Or if you want to recompute the start date by moving the end, or something like that. Just guessing.

>Couldn't for the life of me figure out how to map the Event Description/Details into a useful IQ field:

The problem is that I think that the IQ's fields and the calendar aren't completely mapped yet. When they'll be, you should prbably be able to map the event details to the ItemHTMLText or somethin like that. You could probably already do it, but I don't think they'd appear in the calendar.

>Similarly, the "Where," "Meeting," and "Private" fields in the Event dialog/pop-up: What fields are these? Can they be shown in the Appointments grid?

Same thing here.

The calendar is somewhat functional, but not completely finished yet.

-------------------------------------------------------

Windows 8

Sony Vaio S Series 13 (SVS131E21L)

Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

Thanks Armando for reminding me to map those Calendar fields to IQ regular fields.

BTW, you're 100% correct in your comment, nothing to add

>In the Calendar view, I see controls for scrolling horizonally, but not vertically. This is true no matter which view I'm looking at (1, 5, 7 days, etc.). This is a problem because most of my meetings happen in the evening, but I can't scroll down to see them.

Click on the TimeScale. This will alternate between the various settings. And yes, vertical scroll needs to be implemented properly.