Main Area and Open Discussion > General Software Discussion
SQLNotes...what is it exactly?
PPLandry:
I use it daily too (of course) ;)
>Is there anything I can do before exiting the program that sort of ensures me that the changes are being saved?
You could click the save button, change item and come back to it
>I still think it's important to have a more sophisticated backup settings
True, but if the content is never saved, a backup will not help you. We must track this down first.
A QuickSearch does not find the missing info? [Edit]I see that it did[/Edit]
>and I don't see some of the items I added yesterday.
Use the journal grid (or a similar one with the DateFilter) to see items added yesterday. I don't recall ever loosing items...
>But in the properties, they appear in no grids, which is weird because I obviously entered them in a grid
You mean that they have no fields filled (other than the Item field)? There is a bug in the current version, where if the grid source field contains a space in the name, it isn't auto-assigned, hence would not show in the grid. This is now fixed. Updated version will be out today.
>Now, how do I add the lost items back into the proper grid? Do I have to move it manually, or can I restore it somehow?
Simply assign fields to those items such that the grid will show it. It could be as simple as checking a yes/no field, or more complex. It all depends on the grid (source, filter, AlphaFilter, DateFilter). Show a screenshot if you're having problems.
Armando:
Hi superboyac,
Like you I use the software daily, and apart from the transient html problem I've never lost a thing.
the reason why items might disappear from a grid are (usually) only because of filter/source related problem (ie : your items characteristics/properties don't match the source/filter).
Don't forget that grids don't "contain" items. They're just displaying items depending on the relation between : the grid's source/filters (open the source bar to see these : alt-s) and the items' properties (shown in the properties pane : filled fields).
To "move back" (or, rather, "have your grid display") your items in a grid or another : just change the grid's source and filters accordingly, or make sure that your items match the source by filling the right field (with the right data...).
There might be situations where items are pasted in a grid (XML mode), and maybe a few other situations (I'd have to check), where items do not automatically get assigned the right field values to match the grid's source. You should also make sure that, if your grids have complex source, you have automated whatever needs to be automated for the items to match the source (see the "manage grid" window --> Data -> autoassign the following fields... Note that items get automatically the right values to meet the grid in grids with simple sources)
Pierre : maybe could the "autoassign the following fields" option always be filled with the default value (ie : what's automatically added in the case of simple sources), so one knows what's going to happen to new items...
[edit : Pierre was first... went fo check my coffee, and there he was... I was too slow :-[ ]
superboyac:
Thanks Pierre, Armando. I got the lost items back using the check boxes.
Armando, as far as your explanation goes, it makes sense. However, I rarely play around with the source and filter settings. I just add an item to the grid and input text into the fields and/or html pane. So nothing should disappear between sessions because I'm not really messing with anything. I still think it has something to do with the fact that I deleted some items from the grid, and that caused something to happend.
Pierre, it's true, I don't think I've ever completely lost items, so that's always reassuring. Ok, back to work, right?
Armando:
I still think it has something to do with the fact that I deleted some items from the grid, and that caused something to happend.
-superboyac (July 31, 2008, 11:26 AM)
--- End quote ---
Deleting some items, if they are parents of other items, cans sometimes have that effect.
Let's pick an example happening in the "Inbox" grid (if you still have it in your setting).
1- the grid's source corresponds to the "Inbox" field (ie : the Inbox field needs to be check for any item to appear in the Inbox grid, as it's originally set). Note that this field doesn't have the "value-->sub-item" option checked (in fields properties). It means that only the parents will have the "Inbox field" checked, not the children -- unless you decide otherwise on a case to case basis.
So : for an item to be displayed in the Inbox grid there can be 2 options : 1) the "inbox" field is checked, 2) or the item is to be the children/sub-item of a parent/top-level item already matching the grid's source (this is the case in SQLNotes default configuration).
2- in the "Inbox" grid, if you you delete some parents, their sub-items won't have parents anymore, and because they didn't necessarily have the "inbox" field checked (sub-items now don't meet the source as top-level items - unless you manually checked the "inbox" field or added the the items through the "add item" window ctrl-alt-n), will disappear from the grid too and will end up in... "no grids land".... They will still be in the database, just invisible.
[EDIT : This is coherent with the "folder metaphor" : remove a parent and the chidren disappear to. Unless you move them elsewhere before you do so.]
It seems complicated, and it is a bit... That's why I usually work with the "value-->sub-items" option turned on for most of my simple sources. It prevents these things from happening : If I delete parents from the grids, the children/sub-items still meet the source. If I turn the "flat view" option on : I see all items, even the sub-items. Etc.
There are a couple small drawbacks in using inheritance (value-->subitems) -- a bit more CPU intensive maybe, and a couple hierarchy display bug -- but not many. I've made the decision to stick to it. Much more coherent with the "add item" window which will automatically assign a specific field to new items, and allows one to have a true flat view of all items displayed in a grid -- essential to me. [EDIT : the "value-->subitems" option can also more easily make some items appear in grids where you don't want them, if you're not careful; but this can be fixed "manually", as everything else!]
Armando:
Edited my previous post.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version