Recurring Calendar Events Question

Submitted by David_H on 2016/08/28 20:28
I am playing around with recurring calendar events.  Some of the calendar dialogs suggest that when recurring events are created, they are distinct events, but obviously tied together programmatically inside IQ.  For instance, if I try to change a description a dialog asks me if I want to change just the event I am modifying, or all of them.  Or at least sometimes it does, not sure what's up with that.  And I do appear to be able to modify a single recurring event with a different description.
 
However otherwise in practice they don't appear to be separate, but rather the same event showing up on many different calendar days.  For instance, if I create (7) recurring events, and mark (1) done, they are all marked done.  They also all seem to share the same HTML pane, and show up in grids as (1) item.
 
Could you add some clarification on this Pierre?
 
Thanks!
 <

Orphan Search

Submitted by David_H on 2016/08/27 22:43
Orphan search seems to work well if an item truly has no values beyond an item name and fields that get created automatically.  However it doesn't seem to be working correctly with regard to fields that are supposed to be ignored.  See the (2) attachments as an example, this test item had nothing other than two HTML values, both of which are ignored (fields 26 and 39).  Yet a search would not return it.  But a search should, based on the settings, correct?
 
Thanks
 
 

YourIQBase.ini (sync settings file) - use of "DBDataFilePath" variable

Submitted by jimspoon on 2016/08/27 15:03
I'm trying to understand how the sync settings file (YourIQBase.ini), introduced in v80, works.
 
My database is main.sndb, and after running v.80 I found a main.ini file in the same folder as main.sndb.
 
I looked at its contents and found the following, which shows how I had things configured:
 
[Data]
DBBackupPath=c:\infoqube backup
DBDataFilePath=
FilesPath=..\sync\main.sndb.Files
MonitorFolder=False
MonitorDelay=1
MonitorFolderPath=..\sync

Editing Default HTML Formatting

Submitted by David_H on 2016/08/26 19:02
Is anyone familiar with HTML that can tell me how to modify the default code so that it doesn't insert unwanted spaces?  Especially with bulleted items, when I want them to appear eight below nonbulleted items?  I'm aware I can get around the regular spaces by holding shift when I press enter, but that doesn't solve the bullets issue.
 
Thanks
 
<HTML><HEAD>
<META name=GENERATOR content="InfoQube 0.9.80b">
<META charset=UTF-8>
<STYLE> body {font-family:MS Sans Serif; font-size:18;}table {font-family:MS Sans Serif; font-size:18;}</STYLE>
</HEAD>
<BODY style="ZOOM: 1" bottomMargin=0 leftMargin=2 rightMargin=2 topMargin=2 bgColor=#ffffff>
<DIV>&nbsp;</DIV></BODY></HTML>

Search Question

Submitted by David_H on 2016/08/24 18:15
Why do some items in search come back with "shown in" blank, even when they should (I would think) have a result.  Please see attachment with example.
 
Also, is there a reason we cannot add columns to the search grid?  Being able to do so would make it much easier to figure out which item you're looking for when they are many results, for instance if I could display the parent column.
 
Thanks

Version 0.9.80d is now available !

Submitted by Pierre_Admin on 2016/08/23 14:18
Hi IQ Users,
 
Release v0.9.79 had a fairly serious issue which could affect your precious data. All users are encouraged to upgrade to the current v80d.
 
In this release (v0.9.80d):
  • New: Tools > Options > Program Title bar (1.1.6), added {CurrentView}
  • Fixed: Data: The performance improvements of v79 could cause some issues.

Question about PivotTables

Submitted by ethanrox on 2016/08/22 15:42
I want to use PivotTables in InfoQube, yet at the moment I get this message when I try to open a PivotTable for a Grid (see attachment).
 
Running v79a portable, Win7 64Bit, Office 2010 Pro (additionally installed the Office Web Components 2003 - followed a link from the forum to get it).
 
Do you have any suggestions?

Problems solved by going back to 0.78

Submitted by DavidF on 2016/08/21 16:28
hi Pierre,
 
you might want to know that two of the problems I reported are solved by going back to 0.78:
  • outline styles having no effect
  • any subitems formed from pasted text lose their Item text, usually when they/their TLI are assigned to another grid, but at other times as well
These problems only occur in 0.79a. I guess there are minor releases between 0.79a and 0.78, but 0.78 is the nearest I have.
 
The other problem I mentioned, that subitems are not imported when using the Import > Hierarchical Data option, and the "Add all items to grid" option is checked, is still there.
 
cheers
 
DavidF.

Trying to assign items from one grid to another...

Submitted by DavidF on 2016/08/21 10:06
InfoQube and me are not getting on very well at the moment... Still working on the data that I tried in vain to import hierarchically (see here). In the end I did a straight copy and paste from the text file and went through it doing the indenting item by item. Then, I decided I wanted the whole lot to appear in another grid. So I made the new grid (a standard yes/no grid), selected all 155 items in the original grid, and in properties ticked the box for the new grid.

So OK, the new grid now has 155 items in it. But they look like this: