Recent Posts

151

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by PPLandry on October 06, 2008, 01:41 PM »

@superboyac,

Can you give a screenshot of your settings? Like Tomos said, it works fine...

152

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by PPLandry on October 06, 2008, 06:21 AM »

I'm curious: Is the new portable version taking the place of the regular installed version? I see that 0.9.23.7i is the latest version but it is only available as a portable version, while 0.9.23.6 is the latest version available with an installer package. Are there new improvements, features, bug fixes, etc. available ONLY in the portable version? Are you abandoning the installer version?

-J-Mac (October 06, 2008, 12:47 AM)

Technically, there is only 1 version. One is distributed as a zip of all files (portable), the second is through an installer. The 2 are identical with 1 distinction: the portable does not (yet) associate the .sndb extension with SQLNotes.

The 2 distributions will be maintained. Lack of time is the only reason why I've neglected the installer. I'll fix it this week.

153

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by PPLandry on October 05, 2008, 08:18 PM »

The usercode (now called VBScript editor) is now divided into 3 sections:
1- system code  : supplied with the software
2- user code      : your code, common to all databases
3- database code: code specific to a given database

The priority is: 3 superceeds 2 which superceeds 1 (that is, if you have the same function name in user code and database code, the database code will run)

As your transcript grid is part of the sample database, I've also put it in System code (1) for now. When release time comes, it will most likely be moved to database code, where IMO it belongs really.

BTW, I'm now full-time on the calendar, a subject that you know quite a bit about... IYO is CalendarScope still the goal?

154

Developer's Corner / Google App Engine...

« Last post by PPLandry on October 01, 2008, 01:48 PM »

It has been 6 months since the release of the Google App engine... has anyone used it? Is the SDK nice? Are limitations significant? What kind of apps can one build with it? Examples?

Basically, is it worth taking time to checkout this beast?

155

Living Room / Re: Search Google's index as it was in January 2001!

« Last post by PPLandry on October 01, 2008, 10:36 AM »

I think this is a great idea. In fact, I would very much like Google to provide access to all yearly indexes. This combined with the provided web.archive.org links makes it possible to get vanished info (OK, not all web pages were archived by it, but surprisingly many were).

The web "cloud" contains information, some of which can disappear at any moment. As a consequence, many users feel the urge to grap copies of web pages (hence the use of apps like Evernote, surfulator, etc even my own SQLNotes aka InfoQube). If there was some solid searchable web archive, there would be no such need.

Just my 2 cents

156

General Software Discussion / Re: What do you use to bookmark and annotate your .chm files?

« Last post by PPLandry on September 30, 2008, 09:10 AM »

CHM Editor is free today on GAOTD. The editor seems OK, but lacks table editing tools (you can edit the HTML source). I have not tried it much though. It does decompile on "file open" and recompile on "file save", which can be a long process. I also got an access violations in the 5 min. I used it

[edit]I can't seem to be able to add content. Just edit existing content[/edit]

157

General Software Discussion / Re: Reading Administrator account files from USB

« Last post by PPLandry on September 24, 2008, 11:01 PM »

I was able to take ownership of some other account files and this without ever being asked a password... what kind of security is that? What is the point of setting access priviledges to files, if anybody can simply bypass this and simple take ownership?

I'm happy to have been able to do it, but at the very least, I expected to be required to enter the original account credentials (account name, password), otherwise NTFS security is just a joke...

158

The Getting Organized Experiment of 2007 / Re: New Getting Organized Experiment?

« Last post by PPLandry on September 24, 2008, 09:08 AM »

I'm in too 

159

General Software Discussion / Re: Reading Administrator account files from USB

« Last post by PPLandry on September 22, 2008, 10:18 PM »

Thanks! 

160

General Software Discussion / Reading Administrator account files from USB

« Last post by PPLandry on September 22, 2008, 08:44 PM »

My notebook HD started to freak out 2 months ago and decided to change it before it was too late. I backup up stuff from my usual Windows account (not the Administrator account) to an external drive, swapped the old drive for a new one and reinstalled everything. It is working just fine now.

I also put the old HD into an enclosure as it is still functional. My question is:

- I had some file in the Administrator account. When I connect the USB drive, those file are not visible. In fact, the whole Documents and Settings\Administrator folder structure is read protected (Access is denied). How can I access those files, other than putting that HD back into the notebook? Can I be prompted to enter an account/password to access the files? Can I take ownership of those files?

Nothing that critical there, just some old files I had before creating my usual Windows account, mostly in very old backups I could dig up, but just to be sure that I have all backups, I'd like to actually see what was there...


Thanks

161

Living Room / Re: What Sports Do You Participate In?

« Last post by PPLandry on September 22, 2008, 06:17 PM »

I ride unicycles, been doing this for about 5 years now, my 10yr old daughter has been riding since she was 6 as well.
Great fun, VERY ADDICTIVE, great for building peoples self-confidence and keeps you really fit and healthy.
We have LOTS of members at our weekly club, many new members arrive each week through word-of-mouth and on weekends we go out for Muni rides (Mountain Unicycling) - try searching YouTube for "muni unicycle" and you'll see plenty of video clips

-Fedorov (September 22, 2008, 05:10 PM)

Have you heard of the guy that crossed North America on a unicycle, even carrying his own gears? Approx 100km/day.

Myself I cycle alot. Home and on trips to Europe (hence my avatar on top of Mont-Ventoux France). France, Corsica, Italy, Deutschland, Spain, Switzerland, plus here at home (Québec, Canada)

162

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by PPLandry on September 18, 2008, 11:00 AM »

OK got it. Either remove the Evernote check for the item that has EverNote checked OR enable Full Hierarchy (grid>hierarchy>Full hierarchy). This behaviour is normal and I can explain if desired.

[edit]If you want all items in the Evernote grid to have Evernote checked, enable Inheritance for the EverNote field. Not necessarly required, but if you want, this is the way to do it [/edit]

163

General Software Discussion / Re: Do you keep two computers synchronized? i.e. work + home. If so, how?

« Last post by PPLandry on September 17, 2008, 04:29 PM »

I'm always surprised at how few people are aware of Live Mesh (mesh.com). I don't like Dropbox at all, the 2GB limit and the requirement for everything to be under the dropbox folder is too limiting.

Live Mesh keeps my documents, music and other data in sync across 3 pc's and also keeps a copy online so I can access it from anywhere. And it has remote desktop to any pc as well. I think its a fantastic product.

-MrCrispy (September 17, 2008, 03:40 PM)

I tried live mesh and it was a very bad experience (XP SP3). Files were not being synced or very slowly (not like DropBox instant sync) and when I tried to uninstall it, I had major problems. Now it is partly installed with remnants here and there and a second virtual screen called "Live Mesh Remote Desktop Curtain Driver" and no idea on how to remove it

164

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by PPLandry on September 17, 2008, 04:20 PM »

It keeps hiding those items whenever I restart SN.  Why?  It's not doing it for other items.

-superboyac (September 17, 2008, 04:04 PM)

Perhaps Grid > Save Item State is not checked...

165

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by PPLandry on September 17, 2008, 03:02 PM »

I seem to have deleted the Journal grid (I tend to do that for the grids I don't use, I know, bad habit from the old days).

-superboyac (September 16, 2008, 04:06 PM)

You probably dont have it cause your file is old - mine doesnt, it was introduced since I created my file

-tomos (September 17, 2008, 02:50 AM)

The Journal grid is nothing but a simple grid with no source (=(All items)) or filter. The DateFilter toolbar is active and using the ItemCreated (and/or ItemModified) field.

[edit] This grid will show all items created over a given period of time (day, week, month, user-defined nb days). Any date fields can be used, so you can use it to show due dates, items modified, whatever [/edit]

166

General Software Discussion / Re: Do you keep two computers synchronized? i.e. work + home. If so, how?

« Last post by PPLandry on September 17, 2008, 02:50 PM »

Why is it so freaking difficult/risky to sync two pst files?

-Darwin (September 17, 2008, 12:07 PM)

This is one situation where using some other email client (one which saves emails as .eml files), would be better.

167

General Software Discussion / Re: Outlook 2007 isn't so bad

« Last post by PPLandry on September 16, 2008, 07:11 PM »

Our division here likes to send a lot of emails to everyone in the division, about 100 people, and all the addresses show in the email, and it looks ridiculous.

-superboyac (September 16, 2008, 07:07 PM)

And it is a important confidentiality problem (disclosing email adresses), so individual email is the way to go. It takes a bit more time to set it up the first time, but after that, it is no longer than sending a regular email

168

General Software Discussion / Re: Outlook 2007 isn't so bad

« Last post by PPLandry on September 16, 2008, 07:09 PM »

There is no other way that I know. Why not send it to yourself or a no-reply address and BCC the list? That's what a lot of lists do it anyway.

-Carol Haynes (September 16, 2008, 04:26 PM)

but BCCs are often filtered as spam. Email merge is the way to go.

-PPLandry (September 16, 2008, 05:29 PM)

What is email merge?

-superboyac (September 16, 2008, 07:02 PM)

Email-merge is the same as mail-merge but generating 1 email for each contact item. It can be personalized (but need not be). It is the best (only?) way to get lots of emails delivered, guaranteed. MSWord can do it with a number of email lists (Outlook, Excel, others I'm sure

Our favorite software   can also do it... Select multiple items > HTML export > Template > email-merge

169

General Software Discussion / Re: Outlook 2007 isn't so bad

« Last post by PPLandry on September 16, 2008, 05:29 PM »

There is no other way that I know. Why not send it to yourself or a no-reply address and BCC the list? That's what a lot of lists do it anyway.

-Carol Haynes (September 16, 2008, 04:26 PM)

but BCCs are often filtered as spam. Email merge is the way to go.

170

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by PPLandry on September 16, 2008, 05:26 PM »

It is difficult for me to know, but are you sure that it isn't because the parent was simply closed? If you have an image of how it was, it could help

171

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by PPLandry on September 16, 2008, 04:11 PM »

OK we're progressing...

So you see the parent in the grid? And in the properties pane, the 81 children are shown?

But when you expand the parent, the children are not shown?

If all this is true, you probably enabled Grid > Filter criteria applies to sub-items

Alternatively, you can right-click the parent and select "Show All sub-items"

172

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by PPLandry on September 16, 2008, 03:55 PM »

So how can I recover my lost items?  There are a lot of them.  If possible, I need to search and find all items that are NOT shown in any grids, and then assign the Evernote grid to them all.  Repair didn't work.

-superboyac (September 16, 2008, 03:54 PM)

Do you see them in live-search? If yes, select a few and report the filled fields, along with the grid settings

The journal can also be used

173

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by PPLandry on September 16, 2008, 03:38 PM »

Perhaps you can try a repair?

Otherwise, can you find one such item and report which fields are filled, along with the grid parameters (source, filter, etc) ?

174

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by PPLandry on September 16, 2008, 01:52 PM »

Really?  Is that the best way for that feature to function?  Shouldn't it tell me what grid it's in regardless of the filter?  Wouldn't that be more useful?  That way, when I go to a grid and see something missing, I can search for it and double-check to see if it was really in that grid or not.

-superboyac (September 16, 2008, 01:49 PM)

Remember grids don't contain items, they display them, and if it does not display it, then it isn't there.

I've fixed the properties pane issue. Users may download it

175

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by PPLandry on September 16, 2008, 12:20 PM »

I searched for one of the items and in the properties it says that it is shown in 0 grids.  So I don't think it's shown in any grid regardless of the filter.
I just installed the portable version and it shuts down (crashes) every time I try to open the properties pane.

-superboyac (September 16, 2008, 12:18 PM)

I'll check it immediately as another user was having this problem...