Cannot link IQ grid to Microsoft Excel - 64-bit Windows / Office

Submitted by gregory on 2017/07/08 01:31
I’m trying to link IQ data into Microsoft Word. To do this, I'm creating a Microsoft Office ODC file in IQ, following:

7.30 Live Links to IQ Grids from Word and Excel (node 1254)

This used to work, on another computer running Windows 7.  On 10/06/2015 Wednesday, I note that I had successfully linked InfoQube to Excel.

My current setup is a new computer running Windows 10 Creators’ Edition, Microsoft Office Subscription Product Microsoft Office 365, Version 1706 (Build 8229.2073 Click-to-Run), Office Updates are automatically downloaded and installed,  Microsoft® Word 2016 MSO (16.0.8229.2073) 64-bit.

I’m using InfoQube 0.9.98a

I get this message in Excel if when I open the ODC file I specify ‘Add this data to the data model’:

IQ as a Relational Database: Book Review Process

InfoQube is exceptionally powerful and allows user to create functionality which traditionally requires a significant investment of time and programming knowledge using a relational database.
 
In this example, we'll describe a end-to-end book review process with the following pieces of information:
  • Authors
  • Books
  • Reviewers
  • Book Reviews
  • Rating (individual and overall)
  • Outcome
  • Communications
In addition, specific views will ease these management tasks:
  • Flagging late reviews
  • List of book reviews for each reviewer with status
  • Pivot pie chart showing the count of Authors per country
The end result will be a dashboard to manage all aspects of this process:
 

How to select columns / rows?

Submitted by WayneK on 2017/07/06 16:51
Has something changed with column / row selection?  I used to select a row by clicking on the leftmost outline number column.  Now nothing happens.  I used to select a column by selecting the header.  Now it appears to do a sort.
 
Unrelated observation: why does this website make me repeatedly log in?  Most websites can be set to remember you.
 
Wayne

Grid source can be changed inadvertently after pop-up list selection [FIXED 0.9.98b]

Submitted by gregory on 2017/07/06 02:08
I use fields defined as list of items pop-up extensively. I have a field called Tags with Editor settings List of items pop-up,multi-select. If I select value(s) and close the dialogue using Alt+o or by clicking OK when I have the source bar displayed, the focus is shifted to the source bar. So when I press down-arrow - hoping to move to the next item in the current grid - IQ selects a different field as the the grid source! That isn't necessarily catastrophic because IQ warns you that you are about to change the grid source, but it is annoying to have to shift the focus back to the grid data.

Sync with a fictitious SQL Server database

The fictitious SQL Server back-end database contains contact information (companies, contacts, record status, etc). It is used as part of a secure web-site, where users can view/modify their information. The managing organization already uses InfoQube for CRM type information and wanted to link to the web-site information as its agents were answering calls/emails.

The following configuration file can be used:

<ConnectionString>PROVIDER=SQLOLEDB.1;PASSWORD=SomePassword;PERSIST SECURITY INFO=TRUE;USER ID=SomeUser;INITIAL CATALOG=YourDataBase;DATA SOURCE=SQLServerIP;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096
</ConnectionString>

Citation parser anyone ?

Submitted by Pierre_Admin on 2017/07/04 08:55
Hi IQUsers !
 
Anyone interested in a built-in citation parser (user customizable of course) ?
 
The idea would be that you could select an article reference, clip and the Add Item dialog would recognize a citation and fill-in fields for you. From the PMID, it would be able to detect duplicates.
 
 
---------------
Freedman SB, Adler M, Seshadri R, Powell EC. Oral ondansetron for gastroenteritis in a pediatric emergency department. N Engl J Med. 2006 Apr 20;354(16):1698-705. PubMed PMID: 16625009.
---------------
 
Interesting idea or not ?

Grid Source EditBox

 

Source

  1. Source Box
  2. Dropdown for the Source Box

The Source is the first level of filtering. That is, of all the items in your IQBase, the Source sets which ones to show. Further filtering (Filter, Alpha / Date filter, column filter) can limit even further what items are shown, but the Source is the first level

Source can be as simple as a single field or a single tag, such as AddressBook, or #News. But it can be more than just a field / tag name, in fact it's also a filter. It's the query that indicates what items are selected for the current Grid.

For example, instead of just AddressBook you could put AddressBook and Archived is null to only show unarchived contacts.

Filtering the Grid Source

The grid source filters items to show only items matching the source. It mimics the "folder" concept, with the added advantage that if can also be a more complex source (e.g. (Field1 OR Field2) AND Field3)
 
An additional filter can be toggled on / off and has a dropdown list of recently used filters:
 
 

1. Filter Box Syntax

Filter Syntax is close to Transact-SQL syntax.
 
The best way to learn it is to experiment using Live-Search which can generates the filter string for you. For that you can either:
  • Invoke the Live-Search (View > Live-Search).