Recent Posts

9876

FARR Plugins and Aliases / Re: Google Dictionary

« Last post by tomos on February 16, 2008, 12:27 PM »

hmmm,
doesnt work here -
the dictionaries (0 to 10) show
I've tried various numbers/words also default with no number, but when I press return I get no response
eg as in your example
gd 10 school

9877

Found Deals and Discounts / Re: CD Catalog Expert on Bits du Jour today for $17.97

« Last post by tomos on February 16, 2008, 11:19 AM »

that post above is for Version9, tested around March 2007

9878

Found Deals and Discounts / Re: CD Catalog Expert on Bits du Jour today for $17.97

« Last post by tomos on February 16, 2008, 11:16 AM »

actually I dug out Crush's benchmarking file (which I've never uploaded )

he says

Sehr umfangreiches Prgrammen (von den Funktionalitäten und Suchoptionen her) – Aber leider hat es total denn Sinn eines derartigen Programms verpaßt, da die Suchzeit selbst bei einer direkten Suche mit fast keinen Ergebnissen schon bei kleinen Datenmengen seeehr sehr lang braucht und bei größeren Ergebnislisten ins nahezu unermeßliche anwächst. Eine normale Suche mit dem Windows-Explorer wäre tausendfach schneller. Nach 10 Minuten und 36100 durchsuchten Datensätzen habe ich abgebrochen und das Ergebnis hochgerechnet. Vermutlich ist das noch verschönt, weil mit der Anzahl der Ergebnisse jede weitere Suche quadratisch mehr Zeit benötigt. Aber selbst so sind 60 Einträge pro Sekunde absolut unterste Kategorie. Für Kommerzielle Software heftig.

this via google with minor corrections - you get the idea I think

Very extensive Prgrammen (on the functions and search options ago) - but, unfortunately, it has  missed the total sense of such a programme because the search time even with a direct search with almost no results even for small amounts of data needs very veerrry long  and result in larger lists nearly immense grows. A normal search with the Windows Explorer would be a thousand times faster. After 10 minutes, and searched 36100 records, I stopped and the results extrapolated. It is likely that the still beautifies because with the number of search results each additional square needs more time. But even then 60 entries per second absolute lowest category. For commercial software violent.

I like that image - "violent" software -
brutal prob fits better

9879

Mini-Reviews by Members / Re: List of disc catalogers

« Last post by tomos on February 16, 2008, 09:57 AM »

Holy wowze, there has been a lot of discussion around about CD cataloggable-izerators.  So, there are a kajillion different ones, including some free ones, but if you have had your eye on CD Catalog Expert, today might be your day to snag it at Bits du Jour, http://www.bitsdujour.com/software/280/.

-jiffener (February 16, 2008, 09:33 AM)

9880

Found Deals and Discounts / Re: CD Catalog Expert on Bits du Jour today for $17.97

« Last post by tomos on February 16, 2008, 09:56 AM »

got your links all right there jiffener 
doesnt seem to be any comments around about this one though
are you familiar with it yourself?

9881

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

« Last post by tomos on February 16, 2008, 09:45 AM »

changed the screenshot in last post...
changed "checked" column to "changed" (try saying that fast!)

9882

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

« Last post by tomos on February 16, 2008, 09:14 AM »

Pierre
I changed "Done" field to new one called "FIN" cause I dont want things marked "done" in other grids going funny colours..
Added a "File" yes/no field, now source of grid
When I add things to grid this automatically selected = RED (= to be done)
can resend you the file if you want

I can't wait to see what you did tomos... 
Inspiration...

-Armando (February 16, 2008, 12:00 AM)

eh  dont think I'd go that far Amando!
I've never been one for using search or filters much and I guess I'm very visual, so,
with lots of files being worked on, I can see progress at a glance (colourwise) and sort by column heading to see what has to be done/checked etc
With files taken from my screenshots folder:



SQLnotes09.png  just added,  (File box gets automatically ticked*) = Red = To be done!
SQLnotes08.png  finished,  FIN = Blue = sent on for approval/return
SQLnotes07.png  ChangeRequest ticked = Yellow + DateRequest (date added automatically)
SQLnotes06.png  Changed ticked (changes implemented) = Purple + DateChanged (date added automatically)
SQLnotes05.png  as #06 but Approved ticked = Dark Blue
SQLnotes04.png  Approved (without any changes requested)

again:-
if a box is unticked it goes back to logical previous colour, except for
Approved - this goes back to Blue when unticked

* I've hidden this column/field, just show it here for clarity (I hope)
[edit] changed the screenshot: "Checked" box now called called Changed, (changes implemented)

9883

Living Room / Re: about to switch to a Widescreen LCD.

« Last post by tomos on February 16, 2008, 07:53 AM »

Now I seem to recall a grid type program discussed on here that let you chop up regions of the screen. i will have to search that out. :Thmbsup

-PaladinMJ (February 16, 2008, 04:52 AM)

GridMove
http://jgpaiva.dcmem...rs.com/gridmove.html

9884

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

« Last post by tomos on February 15, 2008, 02:03 PM »

Isn't it great tomos?

-Armando (February 15, 2008, 01:47 PM)

tell me about it !!
I've been struggling for years trying to organise this stuff and finally I can see the light

9885

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

« Last post by tomos on February 15, 2008, 02:02 PM »

thanks for the tips Pierre
you say -

>I'd rename the grid and change the source to enable many projects shown in the grid.

I'm unsure of the best approach
This grid actually started off within the Billing grid which has a yes/no "Projects" field as the source
Now theres naturally going to be an overlap with projects here, but I dont fully understand how to approach that

Maybe if I had a yes/no "Drawings" field, I could include "projects" and exclude any NON-drawings thereby include various other projects too
That would be done in the filter presumably?
Speaking of which I cant seem to filter yes/no fields atall -
for "Checked" I get nothing
for "Checked is null" I get everything

Checkboxes are a little different than you might expect (unless you know SQL). For example, for the Checkbox field Followup you would use Followup if you want to search for checked or Followup is null if you want to search for unchecked.

-from the wiki

9886

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

« Last post by tomos on February 15, 2008, 01:34 PM »

Got it thanks! Very very interesting ! Some advanced stuff in there... you're progessing well!  :Thmbsup

-PPLandry (February 15, 2008, 01:16 PM)

thanks
it's a joy to get off the ground a bit,
especially now I'm going back to this job with hundreds of drawings after a long break (and I thought I left it in an organised state but I didnt have anything like this programme then..)

Re the grid I sent -
I forgot to add notes describing what happens when field clicked or whatever
[edit] I mean in the Manage Fields box

9887

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

« Last post by tomos on February 15, 2008, 01:34 PM »

but going back to the colour thing is there a way to say:

change the colour when ticked IF "Approved" is NOT selected

-tomos (February 15, 2008, 01:28 PM)

Sure, but you need to use user-code for that! 

-PPLandry (February 15, 2008, 01:30 PM)

oh-oh

9888

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

« Last post by tomos on February 15, 2008, 01:28 PM »

but going back to the colour thing is there a way to say:

change the colour when ticked IF "Approved" is NOT selected

9889

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

« Last post by tomos on February 15, 2008, 01:14 PM »

how it looks here



The presumed sequence is:

Done = Blue
ChangeRequest = Yellow + DateRequest
Checked (changes implemented) = Purple + DateChanged
Approved = Custom colour (dark blue)
[Working left to right]

if a box is unticked it goes back to logical previous colour, except for
Approved - this goes back to Blue when unticked

[edit] think some colour advise is required to make pretty! [/edit]

9890

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

« Last post by tomos on February 15, 2008, 01:11 PM »

No rush.

You can make a copy and delete most (or all) items

-PPLandry (February 15, 2008, 11:20 AM)

sent it to Support@ - before I make it unintelligible !!
you'll have to extract it from the database -is that difficult to do?
-
I made a temp database to experiment and was surprised by some of the goodies in there
I wouldnt mind getting some stuff from it to my current database if not too difficult

9891

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

« Last post by tomos on February 15, 2008, 12:01 PM »

only thing is I'm running out of colours

Blue is DONE
Yellow in Change Requested
Purple is changes made (still has to be approved)

Red could be in Progress or To be Done.. or maybe no colour for that
Then a separate Tick box for Approved/Finalised I guess (Hows about a green colour for that ?)

I guess when an item has a colour it can only have one..
what I mean/thinking is:
it's not usually a problem but if you tick something by mistake that changes the colour*
and you then untick it -
it would be nice if it automatically went back to previous colour - is there an equation for that in the “Auto-assign rules”

(just added 85 files ..wooHoo.. )

[edit] this can happen for example, something is approved and they then decide to change something else
gotta deselect approved, but then I guess it goes back to change rrequested colour. Ahh, logical as usual (I think) [/edit]

9892

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

« Last post by tomos on February 15, 2008, 11:27 AM »

3- You can drag-drop as many files as you wish. Try it on a scrap item first (or better still in a temp database)

-PPLandry (February 15, 2008, 10:12 AM)

second time today:
whooHoo!!!

works a treat, each is gets it's own item

9893

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

« Last post by tomos on February 15, 2008, 11:18 AM »

Great! If you think that this solution can help other, do not hesitate to send it to me, I'll put it in the download area.

-PPLandry (February 15, 2008, 10:12 AM)

seems like this could be useful to others
How would I send it to you? (not the whole database )
I'll probably make a few changes to it over the next week as it gets more used

9894

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

« Last post by tomos on February 15, 2008, 10:07 AM »

Now I have this setup

I add files as I start working on them
When ticked Done they go blue
When Change Requested is ticked they go Yellow and the date gets added to notes field
When I tick Checked (i.e. changes made) they go Purple and the date gets added to date field

which I'm quite happy with

some queries

when filtering do I use the Actual name of field or the column heading?

In the “Auto-assign rules” how do I change the date to just date as opposed to date/time?

Is it possible to add many files at once ? Say select 20 in filemanager, drag n drop to grid -
I'm afraid to try that in case it really screws things up

9895

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

« Last post by tomos on February 15, 2008, 10:01 AM »

It is a Feature. (multi-row display of headers)

-PPLandry (February 15, 2008, 09:42 AM)

I cant figure out how it's activated?

9896

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

« Last post by tomos on February 15, 2008, 09:41 AM »

dont know is this a bug or a feature

9897

Living Room / Re: Love - You have 4 minutes to choose your perfect mate

« Last post by tomos on February 15, 2008, 09:11 AM »

there you go YouTube trailer
http://www.youtube.c.../watch?v=xEFjZKf0dF8
it's probably quite entertaining even without a word of german

9898

Living Room / Re: Love - You have 4 minutes to choose your perfect mate

« Last post by tomos on February 15, 2008, 09:08 AM »

Found this reference to Shoppen - a German movie on speed dating (2007)

-Darwin (February 15, 2008, 09:04 AM)

hah, they couldnt find the link for it either

9899

Living Room / Re: Love - You have 4 minutes to choose your perfect mate

« Last post by tomos on February 15, 2008, 08:39 AM »

saw a good (german) film here last year called
Shopping - I've done a google search but not a chance with a title like that 

all about a session with about 10 couples and they move down the line to the next person when the bell goes..
quite funny at times

9900

Found Deals and Discounts / Re: spring cleaning

« Last post by tomos on February 15, 2008, 06:51 AM »

I'm just after ordering two KMP ink-packs for my Canon iP6600D
I get an extra ink in the pack that I cant use

It's a replacement cartridge for the Canon PGI-5BK I dont know what printer it's for - not mine at any rate. It's pigmented ink KMP makes a very high quality replacement for Canon inks You have to use the chip from the original Canon cartridge, but, once you've done this once it's made very easy to transfer this to next (KMP) cartridge

So,
as of next week I will have 4 of these (2 lying around already) and,
will be willing to post them free of cost to anyone in Europe (only!)

send me a PM is easiest I guess