big import, big file

Submitted by jimspoon on 2022/12/07 12:38

I imported a big CSV file into a new IQ database and ended up with 157,000 items, and the file size is 277MB!  Working OK.  IQ did seem to hang at the conclusion of the import, after the confirmation message that tells me that the items have been imported and I need to refresh the grid.  I finally killed and restarted IQ, but all the imported data seems to be OK.

 

IQ interprets pasted line as an equation, nothing gets pasted?

Submitted by jimspoon on 2022/08/01 21:44

With a new item highlighted in the Item field, I tried pasting the following in a grid:

You may use a capturing group in your regex to make REGEXEXTRACT return just that captured part:
=REGEXEXTRACT(D1;"end\s*(\w+)")
If you need to return 1, 2 or 3 whitespace-separated words after end, use
=REGEXEXTRACT(D1;"end\s*(\w+(?:\s+\w+){0,2})")
See the online demo (Golang regex also uses RE2).

Refresh issue

Submitted by WayneK on 2022/07/27 16:10

Set up:

  • 1) Left pane = main view of Grid-1
  • 2) Right pane = view pane of same Grid-1 (right-click>copy view>paste view)

1) Select subitem

2) Refresh grid

3) Outline collapses to one level; current item selection is lost and moves to the top item in the grid.

This has happened many times but not all the time.  In one grid set up it happens 100% of the time but in another grid with a similar set up it doesn't happen.

Can't figure out what could be triggering it.

Copy special settings

Submitted by WayneK on 2022/07/26 20:27

Shouldn't the copy settings for copy-special (ctrl-shift-c) always default to the last used settings.?

I always use option "6", but it keeps defaulting to option 3, making me change the selection every time.   I'm pretty sure this was working as I envision just a while ago.

I couldn't find an option setting to control it.

Wayne

Win10, 120Pre24

Didn't there used to be an option to set the selection as the default?

IQ outline as a writing tool

Submitted by jimspoon on 2022/07/17 11:30

When I'm writing anything, I'm constantly rearranging my sentences or lines.  In Word or a text editor, this means cutting and pasting.  But if I put each sentence or line in an IQ item in an IQ outline, this rearranging becomes very easy.  An IQ item can become a whole document in its own right, consisting of its hierarchy of subitems.  Under that Level 1 "document" item, the Level 2 items could be headings, Level 3 items could be paragraphs, Level 4 items could be sentences.  And then at some point, this item could be printed or exported to a non-IQ format, with the IQ hierarchy being cor

parent-child vs tags vs fields - item ordering capability

Submitted by jimspoon on 2022/07/17 11:12

IQ gives us many ways to group related items together, including parent-child links, tags, fields.  I had a thought about how the parent-child link might have an advantage over using tags or fields.  If you group (Level 2) related items under a (Level 1) parent item, you can arrange them in any order, and that order of subitems under that parent will be retained.  And an item may have multiple parents, each with its own ordering of its subitems.  An item may appear in one place under one parent and a different place under another parent.  I don't think you can do this with tags or fields, t

opml / oml / xml import tip

Submitted by jimspoon on 2022/07/15 17:06

IQ supports OPML import and also OML import.  OPML makes heavy use of "attributes" enclosed in quotes, while other XML-type files may have lots of data enclosed in <> "elements" or "sub-elements".  I found some a page on how to convert from "sub-elements" to "attributes", which could make it easier to get the data into IQ via OPML import:

https://stackoverflow.com/questions/655411/converting-xml-elements-to-x…

 

slight weirdness in Manage Fields dialog

Submitted by jimspoon on 2022/07/06 22:13

I'm trying to add a few new fields in the Manage Fields dialog.

1.  Clicked the New button.

2.  Typed a field name in the Name text box in the upper right corner of the dialog.

3.  Selected Text as the field type.

4.  Clicked the Save button.

Nothing appeared in the field list, until I clicked in the field list.  Then the fields I tried to add finally appeared in the list - twice as shown below.  Should the field appear in the list immediately on clicking the save button (or before), and only once, without needing to click on the list?