Help With Simple External DB Sync

Submitted by Muadib on 2017/12/28 09:45
I'm trying to automate data entry into InfoQube. Using http://sqlitebrowser.org/ I created db with 3 rows: id, start, end. I added 10 entries to it, using sqlite3 python module. When I use following code in sync file, I get error: "3 fields found for mapping, RecordID field not found (cd is not a field in your IQBase).
 
 
<ConnectionString>

Database=D:\Inbox\db1.sqlite;

</ConnectionString>

<FieldMap>
    [id]    cd
    [name]    Started Timer
    [number]    Ended Timer
</FieldMap>

<RecordIDField>cd</RecordIDField>
 
Anyone can help?
 
P.S. I have created field called "cd" in InfoQube
 

Cell Images Cut Off

Submitted by WayneK on 2017/12/15 15:41
When I do a screen capture of this image:
 
 
 
Note that the bottom and right-side of the image is cut off.  I thought it was because the image was too big so I zoomed out before the screen capture and it still cut it off at the same point.
 
Nothing wrong with the screen capture because when I paste into another program, the full image is pasted correctly.
 
Wayne
9.106b

Make Grid Options Easier

Submitted by WayneK on 2017/12/12 20:47
Is there a way to set the defaults for the following grid options?
 
1) Item font applies to fields: 
2) Item color applies to fields:
 
I create a lot of grids and I want all of them to have the same settings (item font and color applied to item field only).  It's fairly annoying to have to
do this manually for each grid created.
 
Assuming there is no present way to do this, my suggestion is to add these two default options to Tools>options.  This would apply the choices to every new grid created.  Could still leave options in "manage grids" for those cases where you want to deviate from the default settings.
 
Wayne

Using down arrow : problem scrolling/going down from item to item in grids

Submitted by Armando on 2017/12/11 14:31
[it's been like that for a long time -- before v100]
 
Using the down arrow to go from item to item after reaching the bottom of the grid (not the actual total list of displayed item, but really the bottom of what's *visible*) isn't smooth.
 
Once the focus reaches the bottom, it doesn't "scroll" smothly, one item at a time : it becomes somwwhat sluggish, jumpy/unsteady, and the focus is hard to follow.  
It  can suddenly jump 2 or 3 items above the bottom of the grid. This is especially true while word wrap is ON, but it also happens otherwise, if some other column has wordwrap on. 
 
Really difficult to work on a long list.

Improving Forms

Submitted by WayneK on 2017/12/10 09:39
One of my most common tasks is creating a new grid and assigning items to it.  I find the existing set up for doing this to be a little cumbersome:
 
1) Create new grid (InfoQube automatically creates a matching yes/no field and sets it as the source - very nice)
2) Right click on forms> manage forms
3) Scroll down list of fields to find the one you just created (cumbersome)
4) Select field
 
My question: is there a more straight-forward way to do this?
 
My suggestions for improvement (either or both):
 
#1 In new field dialogue, add an option for "assign to form"
 
#2 In context menu: add right-click grid tab>add to form
 
Wayne
 
 

New Item dialog small issues

Submitted by Armando on 2017/12/07 10:54
1- "Enter" now directly adds the item to the DB (i.e. enter triggers the "add item" button) -- it could be a new standard, but we now need to press shift+enter to change line, which is different than how it used to be.
 
2- When win+n is pressed while in another app (let's say Chrome), IQ minimizes and the New Item dialog appears, but it doesn't have the focus.
 
Thanks!

0.9.106a: E-mail auto-import not working when check every x second is set to 0

Submitted by MaciejWasyluk on 2017/12/06 07:52
Hi Pierre.
 
The e-mail auto-import is not working when “check every x seconds” is set to 0. The icon shows there are e-mails to be imported and asks to click the icon to import them, yet it does not import after clicking the icon again.
 
It does work properly with the previous version to which I have switched back to test it out. It does also work properly if “check every x second” is bigger then 0.
 
Maciej
 
 
 

Synchronization with Google Services

InfoQube can sync with the following Google Services:
  1. Calendar
  2. Tasks
The end goal is to enable synchronization with many Google services, such as:
  • Contacts
  • Keep
  • Drive
  • GMail
The steps to enable sync are:
  1. Authorize access
    n.b.: If the current IQBase was authorized using a previous version of IQ (v114 and previous), it needs re-authorization. Disconnect and Reconnect to perform this
  2. Set sync parameters for each Google Calendar
  3. Set sync parameters for Google Tasks

Version 0.9.106c is now available !

Submitted by Pierre_Admin on 2017/12/01 18:17
Hi IQ Users !
 
Version v0.9.106c is now available: 
  1. New: Calendar: Google Calendar Sync: Support for repeating events. This is the second step in implementing Google Calendar sync:
    1. v105: Read-only view of non-repeating events
    2. v106: Support for Repeating Event
    3. v107: Read / Write for non-repeating events
    4. v108: Read / Write for Repeating events
    5. v109: Support one-way sync to InfoQube items
    6. v110: Support two-way sync to InfoQube items
    7. v111: Calendar UI improvements
  2. New: Calendar: Improved navigation with mouse and arrow keys
  3. New: New Item dialog n
Subscribe to