Daily recalc issue (and -- presumably -- related question)

Submitted by Armando on 2016/11/25 11:54
My nightly/daily recalcs stop when IQ doesn't have the focus.
The problem appeared with v86 for the first recalc, but then the problem mysteriously disappeared... to reappear with 87. Maybe will it disappear after the firs complete recalc. Will see.
 
Small question:
Background recalc is unchecked in my options:
 
 
 
What does it do? I couldn't find any info about it.
(checking/unchecking this option doesn't seem to make any difference. )
 

Using the Status Bar

The Status Bar is shown at the bottom of the InfoQube's main window. Use View > Status Bar to show / hide it.
 
 
It is divided into 9 sections (from left to right)
  1. Lineage and other "status-type" information (non-intrusive messages)
  2. Higher importance messages (shown with a bright yellow background)
  3. Timers. See Using Timers below for details
  4. Google Calendar Sync button and status: Click on the icon to start a manual sync with your Google calendars. All enabled calendars will sync
  5. EmailToIQ button and status. See 2. Send To InfoQube using EmailToIQ for details on using EmailToIQ
  6. Arrow keys behavior when editing in grids: When ON, arrow keys will never terminate editing.

HTML Pane Keyboard Shortcuts
   Shortcut  Comments

File

    
Open  Ctrl+O  
Save  Ctrl+S  
Print preview  Ctrl+P  
 Navigating in the grid F7, F8 Previous item, Next item
 Edit item name F2 Hit enter to save.

Can't clip webpage into current grid

Submitted by DavidF on 2016/11/23 14:43
hi,
 
I have "Assign to Current Grid" checked in the Add Item window, but it doesn't seem to be working. That is, the clipped item doesn't show up in the current grid. I have a grid called "Everything" that has no source, so it turns up there, otherwise it would fall into a gridless limbo I guess... "Assign to Inbox" works as it should.
 
I'm getting round it by using the Fields pull-down list to assign the Yes/No field of my choice, but "Assign to current grid" is handy.
 
DavidF.

Synchronization with Remote Databases

InfoQube can pull data from external data sources, such as SQL Server, mySQL, Oracle, MSAccess, etc. Any ODBC data source can be used.
When configured correctly, a click of a button is all that is required to refresh the data!

This is an advanced feature which requires some database query knowledge to configure it correctly.

The sync is done through a configuration file (xml type). This file defines:
  • The connection string
  • The SQL statement to retrieve the data (use Access, Enterprise Manager or other similar tool to generate the statement)
  • The field mapping between the back-end database and InfoQube ( back-end fields are [ ] enclosed, otherwise a fixed value will be imported)
  • The synchronization parameters. (Unique record identifier field, Last update date, etc)

Synchronization

InfoQube supports the following types of synchronization:
  1. Synchronization between computers using Dropbox
  2. Synchronization with Google Services
  3. Synchronization with Remote Databases
 

Users can contribute to any documentation page.
 
But if you feel that what you wrote doesn't quite fit in the current organization, or for whatever other reason, you can also put it under this section, to clearly indicate that this is from the community.
 
Thanks to all contributers
 
Pierre_Admin