Submitted by DavidF on 2021/03/26 17:08

I was going to post this as a bug, but it only seems to affect one of my databases, so there's maybe something database-specific going on... In this one database, any text you enter in the Notes field vanishes, if you press F5.

Is Notes just a regular text field? It looks like it is, but it is one of the built-in fields, and it seems "different" in that you can't check on what items have values for it, as you can for other fields. Also, you can't use it as a source for a grid.

-- David F.

Comments

Hi David,

Notes is a system field and should be ID=49 (but otherwise, you can do anything with it that you can do with a non-system field)

If your IQBase is old, it may be another ID. The upgrade process should have re-assigned it to 49, but there may be cases where this was not possible. Report back the ID and contact us, we'll be able to fix it

Pierre_Admin

49 = Scheduling yes/no

Earlier, all five files had 19 for Notes.  Now, three out of five do (other two are now showing the correct 49).

Don't know how it could have changed but also doubt that I could have gotten 2 out of the 5 wrong when I checked earlier.

Wayne

No, I don't see a pattern.

Of the four files currently showing 19 for notes, three had no Ecco Pro import.  One did.

Of the two showing the correct 49 ID, neither had Ecco Pro imports.

I think I've done only one import, just to test it out.  I generally use copy/paste to move material from Ecco Pro.

Wayne

To all that have Notes as field as ID different from 49, please provide (here or privately) the list of all system fields (ID<200):

  1. Open Manage Fields
  2. Sort by ID
  3. I'll add an export field list command, but for now, simply provide a screenshot as this example

fields

Hi Pierre,

Back in April 2020 I made notes of the field ID numbers for my fields and what they ought to be.  Mine are the same as David's.  Specifically according to my notes:

Field 19 is "Notes"; Field ID 19 should be assigned to "FileTextSize" field;
Field 49 is "Scheduling"; should be "Notes".
field 61 is "Address", 63 is "Tel", 64 is "Cell", 65 is "Email", 66 is "BirthDate", 67 is "anniversary", Fields IDs 61-69 should not be assigned to a field.
field 90 is TaskStart; should be "TaskActStart"
field 91 is TaskEnd; should be "TaskActEnd"
field 110 is "Projects", field 111 is Project; fields IDs 102-119 should not be assigned.
 

Can't figure out how to upload pdf.  There's supposed to be an upload link below the editing window.  Don't see one.

Was hoping image handling would be easier in the new set up.  Would be ideal if we could just copy/paste screen caps but obviously that must be difficult to implement.

Wayne

 

Hi Wayne,

Currently only the first post can include attachments, I'll see if this can be changed

Image handling is better than before but I've seen Drupal installation that support straight "paste", so it's on the list (so is highlighting, emoticons, ...)

Pierre

In the old forum, I could simply copy/paste screen caps directly into the edit window.  Can't get any easier than that.  I know you weren't supposed to do that but it worked most of the time.

This is what I have to do now:

1) Open screen cap software

2) Go to settings

3) Change capture setting from "to clipboard" to "to file"

4) Do screen cap

5) Return to post edit window

6) Upload image (Navigate to image location)

7) Open screencap software a second time

8) Open screencap options, and change setting back to "to clipboard"

The 2nd easiest way, for me, is to paste the screencaps into a pdf file and upload that.

Wayne

Wayne wrote:

In the old forum, I could simply copy/paste screen caps directly into the edit window

Yes, it wasn't supported as you said, and only worked with FF. It gave a large content with embedded base64 encoded image. Yikes !

Give me a little extra time to implement it properly

Also, you could just as well:

  1. Press Shift+Win+S: Select area to clip
  2. Click on the notification
  3. Save
  4. Click on the insert image button
  5. Select file

Pierre

In v119Pre9:

  • Fixed: Some older IQBases had the Notes field as ID=19. On opening these, Notes is now ID=49 (and field ID=19 is now FileTextSize, a system field). Grids and forms should not be affected

> To those that have this issue, has pre9 fixed it ?

#19 is now FileTextSize    ✓
#49 is now Notes             ✓

Field #49 was Scheduling (a Yes/No field) -- this field has disappeared. I dont think I ever used it FWIW, but still doesnt seem correct?

Here's what I see in my database -

Field 19, formerly assigned to "Notes", is now IQ system field "FileTextSize"

Field 49, formerly assigned to Ecco field "Scheduling", is now IQ system field "Notes"

The following fields from Ecco still have Field IDs that are reserved for IQ System Fields: Address (61), Tel (63), Email (65), Birthdate (66), Anniversary (67), Projects (110), Project (111).

Field 90 is TaskStart, should be TaskActStart.

Field 91 is TaskEnd, should be TaskActEnd.

@Tom:

Most likely, these fields were at one time included in one of the system supplied IQBases.

@jimspoon:

This is as expected. In this first step, I wanted to fix the fields 19 and 49 only, as they are essential.

The other fields are not currently used. Regarding fields 90 and 91, you can rename these if you wish.

@DavidF:

Is the issue fixed in your problematic IQBase ? 

Pierre_Admin
IQ Designer

General Discussion