Thread: sql-ledger: drop down item list

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Is there an easy way, or how would I go about changing/creating the Invoice
page to include a drop down list of all items? (instead of looking up the
number for an item and typing it in)

Thanks

On Wed, 2002-02-13 at 13:16, Ro0tSiEgE wrote:
> Is there an easy way, or how would I go about changing/creating the Invoice
> page to include a drop down list of all items? (instead of looking up the
> number for an item and typing it in)
> 
> Thanks

ill second that notion at moment its kinda unintuitive..i'll help if
need be just point me

also any futher ideas about why i can't load sql-ledger in opera
5?..opera5 has background printing which should help me with my
background not printing in netscape .....in opera5 all I get is 'unknown
terminal'

thx
lee

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <title></title>
</head>
<body>
lee johnson wrote:<br>
<blockquote type="cite" cite="mid:1013634958.4765.10.camel@imyourhandiman">
  <pre wrap="">On Wed, 2002-02-13 at 13:16, Ro0tSiEgE wrote:<br></pre>
  <blockquote type="cite">
    <pre wrap="">Is there an easy way, or how would I go about changing/creating the Invoice<br>page to include a drop down list of all items? (instead of looking up the<br>number for an item and typing it in)<br><br>Thanks<br></pre>
    </blockquote>
    <pre wrap=""><!----><br>ill second that notion at moment its kinda unintuitive..i'll help if<br>need be just point me<br><br>also any futher ideas about why i can't load sql-ledger in opera<br>5?..opera5 has background printing which should help me with my<br>background not printing in netscape .....in opera5 all I get is 'unknown<br>terminal'<br><br>thx<br>lee<br><br><br><br></pre>
    </blockquote>
For a quick fix, go to your Opera network preferences and change "Browser
Identification" to indentify as Opera as Mozilla or MSIE.<br>
    <br>
-- Luke Kale Myers<br>
    <br>
    </body>
    </html>

On Wed, 13 Feb 2002, Luke Myers wrote:

> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
>   <title></title>
> </head>
> <body>
> lee johnson wrote:<br>
> <blockquote type="cite" cite="mid:1013634958.4765.10.camel@imyourhandiman">
>   <pre wrap="">On Wed, 2002-02-13 at 13:16, Ro0tSiEgE wrote:<br></pre>

Please avoid HTML emails - or at least provide a text version as well.

The above is quite difficult to read in text-based mail programs.

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

>> Is there an easy way, or how would I go about changing/creating the
Invoicepage to include a drop down list of >> all items? (instead of looking
up thenumber for an item and typing it in)Thanks

>> ill second that notion at moment its kinda unintuitive.

Hi I understand that it can be a pain, but I've seen big problems with a
setup like this, and the whole 'dropdown' contents can open a whole can of
worms.

As an undergraduate I did some summerwork doing dataentry. The company (a
major uk retailer) had some overgrown homebrew effort. Everybody who was
permanent staff loved it, and yes it had a dropdown of EVERY item that they
sold. Unsurprisingly *each* it took in excess of five minuites to load a new
record. There were other problems with the program (it taught me many things
about UI why many things are needed in programming!) but they are not
currently relevent.

A quick fix to all of this is to print out a crib sheet (if no printer :
another browser window to alt tab to)

One other thing is if you are to load a list of items, do you subdivide the
list and if so how do you choose categories : tree climbing can be just as
annoying to users when done on a repetitive basis if too deep. With the
final list: do you cache it somewhere and if you do how do you handle
updates to the list (cannot assume that it will be static), is the list
dropped serverside, or calculated clientside.

Oh and one little joyful one I came accross recently: I was doing a data
based program, where the servers were busy with the large number of slim
clients. I decided to use XML (DOM), my back-of-envelope sums led me to
believe that by dropping a treelike structure and populating it on an as
needed basis would be the most efficient, safest and plausible. Until I
descovered that XML DOM can sap up to 10x the data required with handling
the internal tree for the data.

All in all, I suggest the easiest way is the 'crib sheet' with judicious use
of the numeric keypad. :) It does save a helluvalot of time. ;)

Regards
James

On Thu, Feb 14, 2002 at 07:15:16PM -0000, James Tryand wrote:
> All in all, I suggest the easiest way is the 'crib sheet' with judicious use
> of the numeric keypad. :) It does save a helluvalot of time. ;)

The deployment I did for this place, the crib sheet was direct link
into the "Search Parts" functionality, with pre-set defaults. 

I also added a barcode field. Unfortauntely, it's not very useful
until we get the most commonly sold items matched up against it's UPC
code... if it has one. But we label things with the partnumber and a
barcode-representation of the partnumber on each incoming item, so it
would actually be useful if the motherboard powersupply on the retail
computer has enough juice to keep the scanner on...

-- 
-Qaexl-

Thread: sql-ledger: drop down item list

sql-ledger-users