Re: [OT] Re: GUI from Mv code Re: Crystal Reports

2004-04-21 Thread CWNoah2
Nah, rented it. I drive a 12 year old truck. Even it has the stupid windows 
with a mind of their own, though.

Charlie

[EMAIL PROTECTED] writes:
And it was YOU that bought it!

m coffee... need more..

Les :-)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 19 April 2004 11:12
To: [EMAIL PROTECTED]
Subject: [OT] Re: GUI from Mv code Re: Crystal Reports


Well, let's see...  the new car automatically unlocks all the doors when I 
get in (my wife thinks the carjackers'll love that one), I have to stand on the 
brake pedal to get it to start, the window decides for itself to go all the 
way down when I just want it down a crack, and the turning radius sucks. But, 
hey, that's progress. It's new and improved.

Anyway, ignore this as the grumblings of an old codger whose coffee hasn't 
overcome the arthritis yet this morning.  ;^)

Regards,
Charlie Noah
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-19 Thread astarte00
Which is precisely why I ALWAYS do a project with both ends of the sprectrum being in 
on the decision process (Management & IT).  What good is a system that you bring in 
house only to have it a technical OR Business Solution misfit?  

BTW...although sometime the shoe fits...but why is management ALWAYS made out to be 
technical morons?  Why is IT ALWAYS painted out to have the one and only solution that 
will sustain the company into the years ahead?

Face it...sometimes IT is left in the dark concerning 5-10 year plans so the 
technology can accomodate it, and guess what...IT becomes simply a service function 
when it cannot deliver insightful solutions while taking progress and yes, whimsical 
desires sometimes, into consideration. You become the cog in the wheel who simply 
balks at change, (and funny to find when complaining how clerical staff can't stand 
anything new) the immovable hulk with nary a fresh idea. You have to be able to play 
together in order have the the type of smooth interaction and discussion.  The moment 
either IT or Management takes sides...and refuses to budge..it's dead - and THAT is 
usually when they bring in the dreaded outside IT Director who knows squat and tries 
to replicate where he came from (and with bringing along anyone from the old company 
they can)

Management works for the Board, you work for Management..find a solution where all the 
people in the sandbox are happy..



--
Debster
> In a message dated 4/19/2004 12:51:50 AM Eastern Daylight Time, 
> [EMAIL PROTECTED] writes:
> 
> > In truth I have found the fear to be more in the hearts of the IT
> > person who has tweaked the system over the past 15+ years and is insulted
> > that their masterpiece is being considered a dinosaur ready for replacement.
> > How dare they! You don't think that way when you replace your car now do
> > you?  You generally move into a newer improved model that outperforms the
> > car you left behind.  It may react a little differently, 
> > but overall the
> > performance is better.
> 
> But Deb I fear your alternative is a pretty lemon.
> I don't want to trade up my Jeep with cruise control, automatic headlights and 
> anti-lock brakes for a porsche with a stick shift do I?
> 
> IT needs to be on-board with any management decisions and then at the meetings 
> they can ask pertinent questions like "Can you show us where the Audit logs are 
> kept and can we modify that process to our needs?"  "Can you show us how easy it 
> is for a user to customize one of these reports you have?"  "If I have a 
> customer who wants 100 units allocation to them on a continuous basis, how do we 
> set that up in your inventory system?"
> 
> If IT is relegated to a service function, not a decision function or worse, if a 
> "new" IT manager who "didn't do it that way where I came from" appears than 
> you're screwed.  Excuse my French.
> Will
> -- 
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-19 Thread FFT2001
In a message dated 4/19/2004 12:51:50 AM Eastern Daylight Time, [EMAIL PROTECTED] 
writes:

> In truth I have found the fear to be more in the hearts of the IT
> person who has tweaked the system over the past 15+ years and is insulted
> that their masterpiece is being considered a dinosaur ready for replacement.
> How dare they! You don't think that way when you replace your car now do
> you?  You generally move into a newer improved model that outperforms the
> car you left behind.  It may react a little differently, 
> but overall the
> performance is better.

But Deb I fear your alternative is a pretty lemon.
I don't want to trade up my Jeep with cruise control, automatic headlights and 
anti-lock brakes for a porsche with a stick shift do I?

IT needs to be on-board with any management decisions and then at the meetings they 
can ask pertinent questions like "Can you show us where the Audit logs are kept and 
can we modify that process to our needs?"  "Can you show us how easy it is for a user 
to customize one of these reports you have?"  "If I have a customer who wants 100 
units allocation to them on a continuous basis, how do we set that up in your 
inventory system?"

If IT is relegated to a service function, not a decision function or worse, if a "new" 
IT manager who "didn't do it that way where I came from" appears than you're screwed.  
Excuse my French.
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-19 Thread FFT2001
In a message dated 4/19/2004 12:31:56 AM Eastern Daylight Time, [EMAIL PROTECTED] 
writes:

> The reason why you need that special view (20L vs 12L) is because you are 
> constrained by your 132 column printer (or 240 cols).
> 
> As a cube uses the screen as it's canvas, which has a scroll bar, you can just 
> SCROLL across  or simply "shrink" the column display width (just like in Excel)
> 
> This also avoids having dictionaries "cluttered" with (what 
> I would call) redundant definitions
> 
> Ross Ferris
> Stamina Software
> Visage â an Evolution in Software Development

My green screen doesn't have a scroll bar!
And my Accuterm screen seems to want either 80 or 132 display mode 
Also I just can't get my customers used to scrolling right and left, they want to see 
things on one screen.  And since they pay the bills.
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-19 Thread Results
Brian,
   As a graphical programmer, I couldn't agree with you more. As an MV 
programmer, I couldn't agree with you more. GUI has its place, 
especially with infrequent users. Green screen has its place, especially 
with heads-down users.
--

Sincerely,
 Charles Barouch
 www.KeyAlly.com
 [EMAIL PROTECTED]
Brian Leach wrote:

When we advise clients on GUI, we always advise a divide and conquer
approach.
It is amazing just how small a percentage of a system actually needs to be
GUItized, once you have partitioned out the business rules, report and
(strange) user menus, admin facilities etc.
Desiging an effective GUI is a skill that takes time to learn - like any
other computing skill.
Brian
 



--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: [OT] Re: GUI from Mv code Re: Crystal Reports

2004-04-19 Thread Anthony Youngman
And the mirror is designed to detach safely to avoid damage - except putting it back 
after it's detached itself is one of the easiest ways to break it ...

Been there, done that, £30 repair bill coming up to fix my wife's mirror that I walked 
into by mistake ...

And my daughter's car had that fault when we bought it - another £30 repair bill 
coming up :-(

Cheers,
Wol 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: 19 April 2004 11:12
To: [EMAIL PROTECTED]
Subject: [OT] Re: GUI from Mv code Re: Crystal Reports

Well, let's see...  the new car automatically unlocks all the doors when I get in (my 
wife thinks the carjackers'll love that one), I have to stand on the 
brake pedal to get it to start, the window decides for itself to go all the way down 
when I just want it down a crack, and the turning radius sucks. But, 
hey, that's progress. It's new and improved.

Anyway, ignore this as the grumblings of an old codger whose coffee hasn't overcome 
the arthritis yet this morning.  ;^)

Regards,
Charlie Noah

[EMAIL PROTECTED] writes:
Change to the process flow is many times the impetus to replace a module or
application in the first place.  Change is not always terrible, although
feared. In truth I have found the fear to be more in the hearts of the IT
person who has tweaked the system over the past 15+ years and is insulted
that their masterpiece is being considered a dinosaur ready for replacement.
How dare they! You don't think that way when you replace your car now do
you?  You generally move into a newer improved model that outperforms the
car you left behind.  It may react a little differently, but overall the
performance is better.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users






This transmission is intended for the named recipient only. It may contain private and 
confidential information. If this has come to you in error you must not act on 
anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, 
or show it to anyone. Please e-mail the sender to inform us of the transmission error 
or telephone ECA International immediately and delete the e-mail from your information 
system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong 
Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.



--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: [OT] Re: GUI from Mv code Re: Crystal Reports

2004-04-19 Thread Les Hewkin
And it was YOU that bought it!

m coffee... need more..

Les :-)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 19 April 2004 11:12
To: [EMAIL PROTECTED]
Subject: [OT] Re: GUI from Mv code Re: Crystal Reports


Well, let's see...  the new car automatically unlocks all the doors when I get in (my 
wife thinks the carjackers'll love that one), I have to stand on the 
brake pedal to get it to start, the window decides for itself to go all the way down 
when I just want it down a crack, and the turning radius sucks. But, 
hey, that's progress. It's new and improved.

Anyway, ignore this as the grumblings of an old codger whose coffee hasn't overcome 
the arthritis yet this morning.  ;^)

Regards,
Charlie Noah

[EMAIL PROTECTED] writes:
Change to the process flow is many times the impetus to replace a module or
application in the first place.  Change is not always terrible, although
feared. In truth I have found the fear to be more in the hearts of the IT
person who has tweaked the system over the past 15+ years and is insulted
that their masterpiece is being considered a dinosaur ready for replacement.
How dare they! You don't think that way when you replace your car now do
you?  You generally move into a newer improved model that outperforms the
car you left behind.  It may react a little differently, but overall the
performance is better.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


This e-mail and any attachments are confidential and intended solely for the use of 
the addressee only. If you have received this message in error, you must not copy, 
distribute or disclose the contents; please notify the sender immediately and delete 
the message.
This message is attributed to the sender and may not necessarily reflect the view of 
Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis 
Perkins may not be concluded by means of e-mail communication.
E-mail transmissions are not secure and Travis Perkins accepts no responsibility for 
changes made to this message after it was sent. Whilst steps have been taken to ensure 
that this message is virus free, Travis Perkins accepts no liability for infection and 
recommends that you scan this e-mail and any attachments.
Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone 
Road, Northampton, NN5 7UG.

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


[OT] Re: GUI from Mv code Re: Crystal Reports

2004-04-19 Thread CWNoah2
Well, let's see...  the new car automatically unlocks all the doors when I 
get in (my wife thinks the carjackers'll love that one), I have to stand on the 
brake pedal to get it to start, the window decides for itself to go all the 
way down when I just want it down a crack, and the turning radius sucks. But, 
hey, that's progress. It's new and improved.

Anyway, ignore this as the grumblings of an old codger whose coffee hasn't 
overcome the arthritis yet this morning.  ;^)

Regards,
Charlie Noah

[EMAIL PROTECTED] writes:
Change to the process flow is many times the impetus to replace a module or
application in the first place.  Change is not always terrible, although
feared. In truth I have found the fear to be more in the hearts of the IT
person who has tweaked the system over the past 15+ years and is insulted
that their masterpiece is being considered a dinosaur ready for replacement.
How dare they! You don't think that way when you replace your car now do
you?  You generally move into a newer improved model that outperforms the
car you left behind.  It may react a little differently, but overall the
performance is better.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-19 Thread Brian Leach
 
When we advise clients on GUI, we always advise a divide and conquer
approach.

It is amazing just how small a percentage of a system actually needs to be
GUItized, once you have partitioned out the business rules, report and
(strange) user menus, admin facilities etc.

Use a regular report designer [AD - mvQuery] to handle the reporting.
Keep the admin stuff on the green screen.
Turn business rules into subroutines and test then from the green screen
first.

Then look at what is left, and employ someone who understands GUI to create
the new front end. You might be surprised how little is left to be reworked,
if you use the right tools. We use uvCase, but we don't sell that outside
the UK so that won't help you! But there are plenty tools around that can.


 Sticking a few text and combo boxes on a screen is not a GUI. It's a form
with a few text/combo boxes.
 Desiging an effective GUI is a skill that takes time to learn - like any
other computing skill.
 Do employ someone to help you do it.


Some lateral thinking can help too:

One of my favourite demos for mvQuery involves running a Command Before to
capture an existing BASIC print job. I have a simple 300 line BASIC program
that executes a print job to &HOLD&, uses a definition record to strip data
from the job by locating recognized headings/subheadings and stripping text
out at relative x and y offsets, and uses that data to write a number of
records into a work file. I can then use mvQuery to select the work file and
design e.g. a modern looking PDF or an export. None of that is rocket
science, and I can use that technique to redesign a quite number of existing
reports in a matter of minutes - without having to analyze how the original
report was created!

You can do similar things with other tools: it's just takes a little bit of
thinking around the issue.

Brian



This email was checked on leaving Microgen for viruses, similar
malicious code and inappropriate content by MessageLabs SkyScan.

DISCLAIMER

This email and any attachments are confidential and may also be
privileged.

If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to any other
person, use it for any purpose, or store or copy the information.

In the event of any technical difficulty with this email, please
contact the sender or [EMAIL PROTECTED]

Microgen Information Management Solutions
http://www.microgen.co.uk
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Clif Oliver
Yeah. Then I'd be accused of shooting the baby with a wet silver bullet.

Seriously folks, this is a good discussion, but it getting a bit off 
topic at times. I would suggest doing what Ross did a few posts ago. 
Rather than go into a long discussion about "is a star schema a cube or 
a representation of an n-dimensional super-duper-hyper-pterodactyl 
cube," post some links to areas where those interested in the 
not-necessarily-U2 topic can find further info.

And to ALL the vendors, please remember that if you mention your 
product in the post, you really ought to put [AD] in the subject line.

Now, would anyone care to post any experiences on performance of 
implementing a star schema in a set of normalized U2 files and doing 
drill down and roll up strictly with LIST, SORT, and its options?  Post 
numbers, not guesses.

--

Regards,

Clif

On Apr 18, 2004, at 21:52, Ross Ferris wrote:

You are right - there are no silver bullets, you don't throw the baby 
out with the bath water [I will not go into the sordid history of this 
one], and some degree of effort is required to embrace anything that 
is new

[and I'll exit the thread there before I get spanked by Clif :-]
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Ross Ferris
You are right - there are no silver bullets, you don't throw the baby out with the 
bath water [I will not go into the sordid history of this one], and some degree of 
effort is required to embrace anything that is new

[and I'll exit the thread there before I get spanked by Clif :-]

Ross Ferris
Stamina Software
Visage – an Evolution in Software Development


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of [EMAIL PROTECTED]
>Sent: Monday, 19 April 2004 1:57 PM
>To: U2 Users Discussion List
>Subject: Re: GUI from Mv code Re: Crystal Reports
>
>In a message dated 4/18/2004 9:46:12 PM Eastern Daylight Time,
>[EMAIL PROTECTED] writes:
>
>> So YOU, as a developer, would construct a cube with the 6 "key" fields
>that the user is interested in. You also get to do things like define an
>"opening" view of the information - AND also the query that is used to
>generate the cube (BTW, did
>> I mention that Visage has a drag'n'drop query facility :-)
>
>I don't think you understood me.  There isn't "the user" and there isn't "6
>key fields".  There are 500 reports, some have three fields, some have
>twelve fields.  The entire data set of reports in total utilizes 50
>different numeric or date fields.
>
>So no I wouldn't create a cube with 6 fields.  I would create a cube with
>50 fields and create 500 views into it.. or your software would have to
>allow users to easily create and save their own views.
>
>The point being that it's not a magic bullet.  I or they STILL have to
>create those 500 views ...
>Will
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
 
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Debster
When a decision is made to replace a module, or an entire application I have
found it IMPOSSIBLE to get a Green Screen Ap even through the door for a
demo.  Business Rules are extremely important, but the wealth of GUI or GUI
like applications on the market make it easy to find one that fits the bill,
or very close to it.  Forget about just plain GUI, browser based is more
often on the hit list. Oftentimes management and users have become so
ingrained in their thinking as to how the business process flow must be,
that they are blind to see an alternate route to the same end result.  How
often have you heard that an application is to be replaced, but they want
the same exact reports that they have been receiving for the past 10 years?
Change to the process flow is many times the impetus to replace a module or
application in the first place.  Change is not always terrible, although
feared. In truth I have found the fear to be more in the hearts of the IT
person who has tweaked the system over the past 15+ years and is insulted
that their masterpiece is being considered a dinosaur ready for replacement.
How dare they! You don't think that way when you replace your car now do
you?  You generally move into a newer improved model that outperforms the
car you left behind.  It may react a little differently, but overall the
performance is better.

The one thing about GUI that management often overlooks is speed entry and
the need for many areas of repetitious to be designed for speed and
utilizing keyboard rather than mouse entry.  Clerical staff on the other
hand accustomed to green screen entry are often afraid that GUI MUST be
slower.  It all depends on the design.

You can hit the bottom line by making it efficient, making it fast,
eliminate keystrokes, and address the  business issues.  It's up to a
creative techie to find the warm and fuzzy comfortable spot with whatever
tools, not be afraid to spread their wings a bit to learn something new, and
expand the horizons of a company by taking them to another level.

Afterall, management may move ahead without the programmer who insists that
green screen is where a system should stay...

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Tony Gravagno
Sent: Saturday, April 17, 2004 7:15 PM
To: 'U2 Users Discussion List'
Subject: RE: GUI from Mv code Re: Crystal Reports


Tough to find a good place for these comments.  There are some interesting
observations to make on the mentality of IT people, business management,
etc..

First, on the concept of "if we're going to add a GUI we might as well get
an entirely new app":  The business rules and UI should be considered as
entirely separate entities.  Getting a new app with a GUI does not imply
that you're going to get equal or better business rules.  This concept is
exemplified by Mark's GP client and dozens more like them.  Management must
be educated to separate the idea of the UI from the business rules.

Second, I wince in pain at the concept of IT people looking at a Character
UI and deciding it's deficient, based solely on the asthetic value.  How can
someone decide by the UI whether an app suits business needs?  How does the
simple fact that an app has a Graphical UI make it any more functional than
a Character UI?  What is the trigger in the mind of IT people that leads
from "I see a GUI" to "it must be capable of running our business" or "all
we need to do is add a couple business rules to this GUI and it will work
for us"?  I really think this GUI mentality comes in part from the video
game generation where graphical games are perceived as better than the old
Pong, StarTrek, Zork, Wumpus, and Adventure games ("plugh" or "xyzzy" ring
any bells here?)  In all of the rhetoric about separating the UI from the
business rules, somewhere in the minds of IT people is the idea that a
Graphical UI implies better business rules - and graphical database
management tools somehow imply a more sophisticated database.  So while
people sing the praises of Object Orientation and n-tier architectures, in
the big picture they still don't really "get it".

Third, and all of this is really related, what confuses me about all of
these failed migrations is that intelligent professionals keep missing
obvious factors of migration, like feature comparisions, business needs
assessments, training, and documentation.  And why do we seldom see basic
auditing to identify problems and keep a project on track - or to put a halt
to migration when critical (and I really mean critical) issues are
identified?  In every one of these failed migrations there is one or more
persons in management pushing forward with some underlying business agenda,
no one wants to openly state that the plans aren't sound, the systems aren't
ready, or that the whole idea is foolhardy - and somehow hundred

RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Ross Ferris

>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Mark Johnson
>Sent: Monday, 19 April 2004 2:07 PM
>To: U2 Users Discussion List
>Subject: Re: GUI from Mv code Re: Crystal Reports
>
>Thanks Dawn! You have enlightened me in quite a few ways.
>

>
>BTW, the most extreme example of a multi-part primary key that I've ever
>seen was for a security monitoring client. It looked like this:
>
>ACCOUNT-RECEIVER-DATE-TIME-ZONE-SIGNAL-INCIDENTNUMBER
>

This key then corresponds to 7 dimensions, and the overall approach is classified as 
"ROLAP" (see 
http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci214582,00.html)

The "fun" starts with ROLAP when you need a query that was, say, 
ACCOUNT-RECEIVER-ZONE-DATE-TIME-SIGNAL-INCIDENTNUMBER or 
DATE-TIME-ZONE-SIGNAL-INCIDENTNUMBER-ACCOUNT-RECEIVER, as these would correspond to 
different key structures.

If my math memory serves me correctly, for you to be able to keep EVERY possible 
combination you need to have 2^7 = 128 'summary' records for each source transaction.

Increase your dimensions to 14, and you end up with 16,384 - you had better have lots 
of storage & time on your hands. Short of reducing the number of dimensions to a 
subset of pre-defined views, one solution to this problem is MOLAP 
(http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci882493,00.html)  but 
I fear I'm getting WAY to far OT here

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
 
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Ross Ferris
The reason why you need that special view (20L vs 12L) is because you are constrained 
by your 132 column printer (or 240 cols).

As a cube uses the screen as it's canvas, which has a scroll bar, you can just SCROLL 
across  or simply "shrink" the column display width (just like in Excel)

This also avoids having dictionaries "cluttered" with (what I would call) redundant 
definitions

Ross Ferris
Stamina Software
Visage – an Evolution in Software Development


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of [EMAIL PROTECTED]
>Sent: Monday, 19 April 2004 2:00 PM
>To: U2 Users Discussion List
>Subject: Re: GUI from Mv code Re: Crystal Reports
>
>In a message dated 4/18/2004 9:46:12 PM Eastern Daylight Time,
>[EMAIL PROTECTED] writes:
>
>> Neither you, nor the user, need to worry about "format" statements, as
>this information will come directly from your dictionary (though there is
>an API that you can use if your database does "naughty" [with the benefit
>of historical
>> hindsight] things).
>
>Ross c'mon :)
>Do you really believe that a mature application uses one field in exactly
>ONE format?  I have report sets that use a single field with five different
>formats.  So being an old-school kind of person, I create five different
>DICT items.  Nowadays people might use FORMAT statements on the command
>line but hey different strokes.
>
>The point being that a single cube cannot know every possible format that a
>single piece of data needs.  Unless you want to sit down and reformat a
>report that is utilizing every possible character on a 132 char wide
>printout so it can use the 20L justification instead of the 13L "short
>description" field I had to create... then no.
>
>I Still have to create a special view.
>Will
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
 
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread LeRoi Keiller
What you could do is create a 7-sided cube... No, hang on, cubes have 4
sides.  Well, you could make a cube with 3 points per side and 1 base and...
hang on, no ...that's a pyramid.  Okay, then you could create a circle and
generate a curve inside it, with two spots and smaller circle.  No, that's
not right; that's a smiley face. :o) Oh, I don't know.  ...I'll just delete
this email by clicking the ...whoops... sorry, that'd be the Send button.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, 19 April 2004 13:57
To: [EMAIL PROTECTED]
Subject: Re: GUI from Mv code Re: Crystal Reports


In a message dated 4/18/2004 9:46:12 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:

> So YOU, as a developer, would construct a cube with the 6 "key" fields
that the user is interested in. You also get to do things like define an
"opening" view of the information - AND also the query that is used to
generate the cube (BTW, did 
> I mention that Visage has a drag'n'drop query facility :-)

I don't think you understood me.  There isn't "the user" and there isn't "6
key fields".  There are 500 reports, some have three fields, some have
twelve fields.  The entire data set of reports in total utilizes 50
different numeric or date fields.

So no I wouldn't create a cube with 6 fields.  I would create a cube with 50
fields and create 500 views into it.. or your software would have to allow
users to easily create and save their own views.

The point being that it's not a magic bullet.  I or they STILL have to
create those 500 views ...
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Disclaimer Notice
This message contains privileged and confidential information intended only
for the use of the addressee named above. If you are not the intended
recipient of this message you are hereby notified that you must not
disseminate, copy or take any action or place any reliance on it. If you
have received this message in error please notify Ultradata immediately on
+61 3 9291 1600. Any views expressed in this message are those of the
individual sender, except where the sender specifically states them to be
the views of Ultradata Australia Pty. Ltd.

 To unsubscribe from receiving commercial electronic messages from Ultradata
Australia please email [EMAIL PROTECTED] with the subject heading
"Unsubscribe".
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Mark Johnson
Thanks Dawn! You have enlightened me in quite a few ways.

First, If this Cube concept is today's latest buzz word, then I'm gonna run
with it for my GP client I'e been whining about on this forum. As I was
singing the praises of the Results system, It contains 4-5 sales history
files that exactly match your definition of a cube.

One of these files, called CUST-PROD sales is a 108 field multiple year file
representing month by month sales, ext price, budgets and gross margin. This
single file is the basis of over 90% of the customized sales reports I've
added in the last 6 years.

I've always liked this file and duplicated it on other MV clients that
didn't have it. Given the perpetual collection of transactions in an
INVOICE-HISTORY file and the significant fields in each record (CUSTNO,
PRODUCTS, SHIPTOS, SALESMAN, PRODUCT families, DATES etc) these CUST-PROD
and other sales accumulations (cubes) make for quick reports and inquiries.
Also, they don't take away from the lessor fields being attacked with the
transaction file.

BTW, the most extreme example of a multi-part primary key that I've ever
seen was for a security monitoring client. It looked like this:

ACCOUNT-RECEIVER-DATE-TIME-ZONE-SIGNAL-INCIDENTNUMBER

and oddly enough, this file contained no data fields. Just the primary key.

thanks.


- Original Message -
From: "Dawn M. Wolthuis" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Sunday, April 18, 2004 4:49 PM
Subject: RE: GUI from Mv code Re: Crystal Reports


Cube summary: In an MV implementation, a cube might be a file with a
multipart key and each part of the key being a foreign key to another file.
Additionally, instead of virtual fields for summing such numbers as
total-sales-per-salesperson-per-quarter, the cube might actually store these
sums just in case someone wants to see them then they do their online
analytical processing (OLAP), for example.

The most important aspects of a cube are the FACT table (that's the one with
the multipart key), the DIMENSION tables (the ones the foreign keys point
to) and the MEASURES (the values to be summed, counted, etc when slicing and
dicing the data).

RDBMS users often rehost their data in a data mart or warehouse using a
"star schema" (the name for a fact and dimension table design) so they can
report against the data.  [And as an aside, PICK folks sometimes also port
their data to a relational database so they can then make stars and put in
an OLAP cube so they can then report against it as if it were multivalued
data.  We end up doing that due to a lack of standard reporting solutions
other than the character-based MV query tools.  That's why I promote such
tools as Informer at www.entrinsik.com -- we could bypass a lot of steps if
we don't buy into the relational mistakes -- couldn't resist the soapbox
opportunity, sorry].

--dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mark Johnson
Sent: Sunday, April 18, 2004 2:49 PM
To: U2 Users Discussion List
Subject: Re: GUI from Mv code Re: Crystal Reports

Not to be out of touch, but what is a Sales Cube. I saw Swordfish and I hope
that itn't it.

Thanks.

- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Sunday, April 18, 2004 3:20 PM
Subject: Re: GUI from Mv code Re: Crystal Reports


> In a message dated 4/18/2004 10:18:11 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
>
> > For example, aligning this back to the original post, rather than
attempting to use CR for reporting, I'd simply create a Viságe.BIT cube to
give the users free-form enquiry and data exploration facilities into their
UV database. In our case we have replaced >300 sales analysis reports
currently provided in our R5 system with a single Sales Cube -   and this is
one of the facilities that makes Viságe "better" than
> > AccuTerm !
>
> Warning! Salesman quote!
> C'mon Ross :) A dataset that includes 50 fields and I only want to see 6
on my report.  So you replace that report with a cube where I (the user)
have to figure out exactly what I want to see, build the proper query
statement, format statement, display statement etc and then figure out how
to tell the system to remember my statement so next time I don't have to
THAT all again.
>
> You replaced the 300 reports, with one huge cube where you STILL have
users recreating (or trying to) their original 300 reports...
>Users don't want to see 50 fields, they want to see the 6 fields
they've been analyzing for the past 3 years ...
> Will
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.

Re: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread FFT2001
In a message dated 4/18/2004 9:46:12 PM Eastern Daylight Time, [EMAIL PROTECTED] 
writes:

> Neither you, nor the user, need to worry about "format" statements, as this 
> information will come directly from your dictionary (though there is an API that you 
> can use if your database does "naughty" [with the benefit of historical 
> hindsight] things).

Ross c'mon :)
Do you really believe that a mature application uses one field in exactly ONE format?  
I have report sets that use a single field with five different formats.  So being an 
old-school kind of person, I create five different DICT items.  Nowadays people might 
use FORMAT statements on the command line but hey different strokes.

The point being that a single cube cannot know every possible format that a single 
piece of data needs.  Unless you want to sit down and reformat a report that is 
utilizing every possible character on a 132 char wide printout so it can use the 20L 
justification instead of the 13L "short description" field I had to create... then no.

I Still have to create a special view.
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread FFT2001
In a message dated 4/18/2004 9:46:12 PM Eastern Daylight Time, [EMAIL PROTECTED] 
writes:

> So YOU, as a developer, would construct a cube with the 6 "key" fields that the user 
> is interested in. You also get to do things like define an "opening" view of the 
> information - AND also the query that is used to generate the cube (BTW, did 
> I mention that Visage has a drag'n'drop query facility :-)

I don't think you understood me.  There isn't "the user" and there isn't "6 key 
fields".  There are 500 reports, some have three fields, some have twelve fields.  The 
entire data set of reports in total utilizes 50 different numeric or date fields.

So no I wouldn't create a cube with 6 fields.  I would create a cube with 50 fields 
and create 500 views into it.. or your software would have to allow users to easily 
create and save their own views.

The point being that it's not a magic bullet.  I or they STILL have to create those 
500 views ...
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread FFT2001
In a message dated 4/18/2004 6:08:53 PM Eastern Daylight Time, [EMAIL PROTECTED] 
writes:

> Sorry, I'm not going to publish the code here :-)  suffice to say that 
> BECAUSE we have had the luxury of time to develop Viságe, we have overcome MANY 
> problems that face this type of technology - and this isn't even the most difficult 
> !

There's a big difference between "publish the code" and "explain how you do this".
So are you also not willing to explain how you do this?
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Ross Ferris
Note quite ! I still believe that there are 10 types of people in the world - users 
and developers !

So YOU, as a developer, would construct a cube with the 6 "key" fields that the user 
is interested in. You also get to do things like define an "opening" view of the 
information - AND also the query that is used to generate the cube (BTW, did I mention 
that Visage has a drag'n'drop query facility :-)

A single cube design can be used with multiple queries - you save each of these as a 
combination, which REALLY defines the cube - so you don't have to "remember" your 
queries.

Neither you, nor the user, need to worry about "format" statements, as this 
information will come directly from your dictionary (though there is an API that you 
can use if your database does "naughty" [with the benefit of historical hindsight] 
things).

Just as each of your existing reports was stored as a "program" which you only wrote 
once (and modified/enhanced many times!), so with a data warehouse product (any/all of 
them) you only have to define these things once, and you can make enhancements as 
needed

Obviously YMMV, and OLAP/DW/BI cubes will not solve EVERY problem - but our experience 
has been that they can certainly greatly enhance the user experience with what happens 
next !

(If you are interested, point your browser @ 
http://www.stamina.com.au/Products/Visage/Visage_BIT.htm, download the whitepaper & 
then "play" with the live demo. Left click on the "Department" at the top of the cube 
and drag it to the right of "Expense" - you now have expenses by department. Left 
click on "Department" again and drop on the left of "Expense" [near the margin] - you 
now have a departmental expense analysis, and not a "query" in sight. It is this 
"interactive" nature of a "cube" that adds value to the equation)

Ross Ferris
Stamina Software
Visage - an Evolution in Software Development

>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of [EMAIL PROTECTED]
>Sent: Monday, 19 April 2004 5:20 AM
>To: U2 Users Discussion List
>Subject: Re: GUI from Mv code Re: Crystal Reports
>
>In a message dated 4/18/2004 10:18:11 AM Eastern Daylight Time,
>[EMAIL PROTECTED] writes:
>
>> For example, aligning this back to the original post, rather than
>attempting to use CR for reporting, I'd simply create a Viságe.BIT cube to
>give the users free-form enquiry and data exploration facilities into their
>UV database. In our case we have replaced >300 sales analysis reports
>currently provided in our R5 system with a single Sales Cube -   and this
>is one of the facilities that makes Viságe "better" than
>> AccuTerm !
>
>Warning! Salesman quote!
>C'mon Ross :) A dataset that includes 50 fields and I only want to see 6 on
>my report.  So you replace that report with a cube where I (the user) have
>to figure out exactly what I want to see, build the proper query statement,
>format statement, display statement etc and then figure out how to tell the
>system to remember my statement so next time I don't have to THAT all
>again.
>
>You replaced the 300 reports, with one huge cube where you STILL have users
>recreating (or trying to) their original 300 reports...
>   Users don't want to see 50 fields, they want to see the 6 fields they've
>been analyzing for the past 3 years ...
>Will
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
 
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Ross Ferris
Will,

Yes, we DO persist record locks, so a Visage application can happily co-exist with its 
green screen cohorts.

I know that "everyone" says that this is impossible with a non-persistent application 
 they are wrong !

Sorry, I'm not going to publish the code here :-)  suffice to say that BECAUSE 
we have had the luxury of time to develop Viságe, we have overcome MANY problems that 
face this type of technology - and this isn't even the most difficult !

Many of our "competitors" have inherent problems with their approaches that I don't 
think even THEY know they have yet (sorry, I'm not going to give THEM a heads up 
either :-). One day they will go SPLAT, and find that they are going to have to take 
more than a few steps backwards (been there, done that), if not a TOTAL system re-tool 
 'tis the nature of the beast.

As our "sales spiel" goes, one of the biggest advantages you get with Viságe is all of 
the mistakes we have made along the way. You are left with a "distillate" that is very 
"pure", efficient, and potent :-)

Ross Ferris
Stamina Software
Visage - an Evolution in Software Development


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of [EMAIL PROTECTED]
>Sent: Monday, 19 April 2004 5:22 AM
>To: U2 Users Discussion List
>Subject: Re: GUI from Mv code Re: Crystal Reports
>
>In a message dated 4/18/2004 11:23:25 AM Eastern Daylight Time,
>[EMAIL PROTECTED] writes:
>
>> That would certainly be the case, especially when you also take into
>account the REDUCTION of DB licences required to support your user
>population ! (or for existing sites the ability to increase the effective
>user population, without a corresponding increase in DB licences).
>>
>> This is because Viságe uses web technology for data transport, and
>operates with a non-persistent connection model, so you are only
>"connected" to the backend database to do things
>> like reading records, and executing server code.
>
>Hold on here amigo.
>Are you saying you do not persist record locks?
>You know what I mean.
>Explain how you do this.
>Will
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
 
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Ross Ferris
A data warehouse of sales information, presented as a multiple-dimensional cube 
structure - there is a related viewer component (part of the standard Viságe.Designer) 
that enables you to interact with this cube.

In our case we have 14 "dimensions", or things we are interested in relating to a sale 
- these things include "dimensions" for Salesman, Region, Customer & 8 levels of 
Product Categorization, as well as a dimension for "time".

These dimensions can then be arranged (with a simple drag & drop operation) into ANY 
arbitrary order (some products require that you pre-define specific views of you cube, 
to minimise the resource requirement - but as soon as you want something "outside the 
square", you go SPLAT!

Ross Ferris
Stamina Software
Visage - an Evolution in Software Development


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Mark Johnson
>Sent: Monday, 19 April 2004 5:49 AM
>To: U2 Users Discussion List
>Subject: Re: GUI from Mv code Re: Crystal Reports
>
>Not to be out of touch, but what is a Sales Cube. I saw Swordfish and I
>hope
>that itn't it.
>
>Thanks.
>
>- Original Message -
>From: <[EMAIL PROTECTED]>
>To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
>Sent: Sunday, April 18, 2004 3:20 PM
>Subject: Re: GUI from Mv code Re: Crystal Reports
>
>
>> In a message dated 4/18/2004 10:18:11 AM Eastern Daylight Time,
>[EMAIL PROTECTED] writes:
>>
>> > For example, aligning this back to the original post, rather than
>attempting to use CR for reporting, I'd simply create a Viságe.BIT cube to
>give the users free-form enquiry and data exploration facilities into their
>UV database. In our case we have replaced >300 sales analysis reports
>currently provided in our R5 system with a single Sales Cube -   and this
>is
>one of the facilities that makes Viságe "better" than
>> > AccuTerm !
>>
>> Warning! Salesman quote!
>> C'mon Ross :) A dataset that includes 50 fields and I only want to see 6
>on my report.  So you replace that report with a cube where I (the user)
>have to figure out exactly what I want to see, build the proper query
>statement, format statement, display statement etc and then figure out how
>to tell the system to remember my statement so next time I don't have to
>THAT all again.
>>
>> You replaced the 300 reports, with one huge cube where you STILL have
>users recreating (or trying to) their original 300 reports...
>>Users don't want to see 50 fields, they want to see the 6 fields
>they've been analyzing for the past 3 years ...
>> Will
>> --
>> u2-users mailing list
>> [EMAIL PROTECTED]
>> http://www.oliver.com/mailman/listinfo/u2-users
>
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
 
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Tony Gravagno
[hacked quotes from Ross]
>Viságe is NOT a terminal emulator on steroids - it is a 
>complete application development framework,

That is a fundamental point which most people miss.  AccuTerm is not an
application development environment along the lines of Viságe, and I will
include Nucleus and DesignBAIS in this class.  This is EXTREMELY important.
- If you already have an app (and you wouldn't be in this forum unless you
do), and you'd like to add a consistent overall look and feel, then these
tools are great.  Existing apps like this require the modularization that
we've been discussing here, but much more than that, a RAD (Rapid
Application Development) tool will require consistency to be applied to
modules across the program set.
- Other tools like Coyote, FlashCONNECT, or the ATGUI are more tactical than
strategic.  In other words, they allow you to GUItize specific parts of your
application, and it's up to you to provide the look and feel.  A more
wholistic approach requires a consistency in design and/or a RAD to help.

Comparing AccuTerm to a RAD is apples to oranges - there are few valid
comparisons.  But every one of these tools requires code modularization as
we've been discussing in this sub-thread.

There is one product which is enjoying a Phoenix-like rebirth: Symbion is a
RAD built on the AT GUI.  Like some other products, building a GUI in
Symbion also builds a CUI with zero additional effort, which is highly
valuable - because as we all know, the GUI sells the app but real work is
done with the CUI.  :)  I was _very_ impressed with the data entry and
inquiry screens, and reports generated in this environment.  I don't know if
there is a U2 port yet.  Contact Gary Huffer [EMAIL PROTECTED] for info, tell
him Tony sent ya.  :)

>However, if you are looking at doing something MORE than just 
>firing off a windows EXE, like "enriching" the user experience 
>when interacting with your multi-valued data (read GUI)...

I think AccuTerm should be given more credit.  I have to admit that I didn't
think the ATGUI was very full featured when it first came out, but I've
re-evaluated that early impression and I think others should too.  ATGUI
allows an MV developer to build a rich VB-looking GUI with no VB code in a
reasonable amount of time - and with no firing off of a Windows EXE.  Seeing
Symbion in action was proof to me that ATGUI can build everything an
end-user needs.

>For example, aligning this back to the original post, rather 
>than attempting to use CR for reporting, I'd simply create a 
>Viságe.BIT cube to give the users free-form enquiry and data 
>exploration facilities into their UV database. In our case we 
>have replaced >300 sales analysis reports currently provided 
>in our R5 system with a single Sales Cube -  and this is one 
>of the facilities that makes Viságe "better" than AccuTerm !

Ross, tone it down a little bud, the salesman in you is inhibiting an
objective technical assessment.
- First, as stated above, AccuTerm isn't designed for doing these functions,
so claiming to be "better" isn't a valid comptetive analysis.
- Second, Viságe and Viságe.BIT are two different products geared at
different audiences.  Please don't confuse them as one product to give the
impression that Viságe does it all.
- Third, the pricing for a Viságe package compared to AccuTerm is vastly
different.  For US$100 we can get a single-user seat of AT with ATGUI to do
what it does, or for a few thousand dollars we can get Viságe products to do
much more expanded functions.  Viságe no doubt provides value in what it
does, with a good ROI for sites that can use the functions, etc.  But
eagerness to seize a marketing opportunity in forum threads should be
tempered with some perspective of what it is that you're trying to compete
against and what the market is willing to pay for those features.
- Fourth, please, you may have created a data cube to provide data to 300
reports, but the functional reports themselves still need definition and
formatting.  So you still have to work with 300 reports, there's no magic
there, and it's not valid to imply otherwise, especially when AccuTerm isn't
designed to be a report generation environment.  I'm impressed with
Viságe.BIT and I'm a fan of MITS as well, but neither product provides the
formatting which is the specialty of CR.  Again, apples to apples and horses
for courses are in order.

Always interested in your comments, always aware of the fluff.  :)
Tony


--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Dawn M. Wolthuis
Cube summary: In an MV implementation, a cube might be a file with a
multipart key and each part of the key being a foreign key to another file.
Additionally, instead of virtual fields for summing such numbers as
total-sales-per-salesperson-per-quarter, the cube might actually store these
sums just in case someone wants to see them then they do their online
analytical processing (OLAP), for example.

The most important aspects of a cube are the FACT table (that's the one with
the multipart key), the DIMENSION tables (the ones the foreign keys point
to) and the MEASURES (the values to be summed, counted, etc when slicing and
dicing the data).

RDBMS users often rehost their data in a data mart or warehouse using a
"star schema" (the name for a fact and dimension table design) so they can
report against the data.  [And as an aside, PICK folks sometimes also port
their data to a relational database so they can then make stars and put in
an OLAP cube so they can then report against it as if it were multivalued
data.  We end up doing that due to a lack of standard reporting solutions
other than the character-based MV query tools.  That's why I promote such
tools as Informer at www.entrinsik.com -- we could bypass a lot of steps if
we don't buy into the relational mistakes -- couldn't resist the soapbox
opportunity, sorry].

--dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mark Johnson
Sent: Sunday, April 18, 2004 2:49 PM
To: U2 Users Discussion List
Subject: Re: GUI from Mv code Re: Crystal Reports

Not to be out of touch, but what is a Sales Cube. I saw Swordfish and I hope
that itn't it.

Thanks.

- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Sunday, April 18, 2004 3:20 PM
Subject: Re: GUI from Mv code Re: Crystal Reports


> In a message dated 4/18/2004 10:18:11 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
>
> > For example, aligning this back to the original post, rather than
attempting to use CR for reporting, I'd simply create a Viságe.BIT cube to
give the users free-form enquiry and data exploration facilities into their
UV database. In our case we have replaced >300 sales analysis reports
currently provided in our R5 system with a single Sales Cube -   and this is
one of the facilities that makes Viságe "better" than
> > AccuTerm !
>
> Warning! Salesman quote!
> C'mon Ross :) A dataset that includes 50 fields and I only want to see 6
on my report.  So you replace that report with a cube where I (the user)
have to figure out exactly what I want to see, build the proper query
statement, format statement, display statement etc and then figure out how
to tell the system to remember my statement so next time I don't have to
THAT all again.
>
> You replaced the 300 reports, with one huge cube where you STILL have
users recreating (or trying to) their original 300 reports...
>Users don't want to see 50 fields, they want to see the 6 fields
they've been analyzing for the past 3 years ...
> Will
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Tony Gravagno
[I went on and on and then said]
>>As an aside, pardon me for being so bold, but it's amazing that the 
>>providers of these GUI products aren't jumping to pay people 
>like me to 
>>help developers become viable candidates for their products.  There's 
>>no guarantee that any given site will adopt any given GUI product, if 
>>any, but unless there are prospects there can be no new 
>customers.  It 
>>seems to me it's worth it to "someone" to foster redevelopment like 
>>this.  Well, that's the MV market for ya...
>>
>>Tony
>[Ross Ferris] 
>??
>Please refer to your email of March 23rd - If things have 
>changed I'll get the guys from ACTi to give you a call :-)

My above quote doesn't mean that I necessarily want to do this sort of work.
There are lots of talented people in our market who could use work and it
seems a natural fit to tool providers to contract with third-parties to
facilitate app migration for a host of applications.  Personally, I prefer
to write communications tools and do other high-end tech stuff for MV - if I
never see another line of application code I'll be happy.  However, there is
something cool and rewarding about modularizing old code that will become
the back-end to a GUI thick client, web client, Web Service or Smart Phone.

I'll consider opportunities for myself and other Nebula R&D associates as
they present themselves, but I'm not going to "gear up" to provide
modularization services if the MV market isn't interested.  "Fostering
redevelopment" means someone must fund projects like this, if not the VAD
then perhaps tool developers who have something to gain from the efforts of
the VAD.

(Really OT here, more for CDP than this forum, sorry.)

Tony

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Results
Mark,
   Cubes are a way of displaying data. All those "1NF is the only way" 
people discovered that flat data makes doesn't server whole categories 
of users. So they invented cross-linked (usually browser viewable)  
report format where for example:

  
SALES  OVERHEAD
   01/01/04 $1,000,000$657,823

Would be displayed and you can click on the dollar amounts to 'drill 
down' into the details. On that page, you should be able to drill down 
through a detail like 'expenses' to see the details of that value, and 
so on.

   - Charles "CB3" Barouch

Mark Johnson wrote:

Not to be out of touch, but what is a Sales Cube. I saw Swordfish and I hope
that itn't it.
Thanks.

- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Sunday, April 18, 2004 3:20 PM
Subject: Re: GUI from Mv code Re: Crystal Reports
 

In a message dated 4/18/2004 10:18:11 AM Eastern Daylight Time,
   

[EMAIL PROTECTED] writes:
 

For example, aligning this back to the original post, rather than
 

attempting to use CR for reporting, I'd simply create a Viságe.BIT cube to
give the users free-form enquiry and data exploration facilities into their
UV database. In our case we have replaced >300 sales analysis reports
currently provided in our R5 system with a single Sales Cube -   and this is
one of the facilities that makes Viságe "better" than
 

AccuTerm !
 

Warning! Salesman quote!
C'mon Ross :) A dataset that includes 50 fields and I only want to see 6
   

on my report.  So you replace that report with a cube where I (the user)
have to figure out exactly what I want to see, build the proper query
statement, format statement, display statement etc and then figure out how
to tell the system to remember my statement so next time I don't have to
THAT all again.
 

You replaced the 300 reports, with one huge cube where you STILL have
   

users recreating (or trying to) their original 300 reports...
 

  Users don't want to see 50 fields, they want to see the 6 fields
   

they've been analyzing for the past 3 years ...
 

Will
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
   

 

--
Sincerely,
 Charles Barouch
 www.KeyAlly.com
 [EMAIL PROTECTED]
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Mark Johnson
Not to be out of touch, but what is a Sales Cube. I saw Swordfish and I hope
that itn't it.

Thanks.

- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Sunday, April 18, 2004 3:20 PM
Subject: Re: GUI from Mv code Re: Crystal Reports


> In a message dated 4/18/2004 10:18:11 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
>
> > For example, aligning this back to the original post, rather than
attempting to use CR for reporting, I'd simply create a Viságe.BIT cube to
give the users free-form enquiry and data exploration facilities into their
UV database. In our case we have replaced >300 sales analysis reports
currently provided in our R5 system with a single Sales Cube -   and this is
one of the facilities that makes Viságe "better" than
> > AccuTerm !
>
> Warning! Salesman quote!
> C'mon Ross :) A dataset that includes 50 fields and I only want to see 6
on my report.  So you replace that report with a cube where I (the user)
have to figure out exactly what I want to see, build the proper query
statement, format statement, display statement etc and then figure out how
to tell the system to remember my statement so next time I don't have to
THAT all again.
>
> You replaced the 300 reports, with one huge cube where you STILL have
users recreating (or trying to) their original 300 reports...
>Users don't want to see 50 fields, they want to see the 6 fields
they've been analyzing for the past 3 years ...
> Will
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread FFT2001
In a message dated 4/18/2004 11:23:25 AM Eastern Daylight Time, [EMAIL PROTECTED] 
writes:

> That would certainly be the case, especially when you also take into account the 
> REDUCTION of DB licences required to support your user population ! (or for existing 
> sites the ability to increase the effective user population, without a corresponding 
> increase in DB licences).
> 
> This is because Viságe uses web technology for data transport, and operates with a 
> non-persistent connection model, so you are only "connected" to the backend database 
> to do things 
> like reading records, and executing server code.

Hold on here amigo.
Are you saying you do not persist record locks?
You know what I mean.
Explain how you do this.
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread FFT2001
In a message dated 4/18/2004 10:18:11 AM Eastern Daylight Time, [EMAIL PROTECTED] 
writes:

> For example, aligning this back to the original post, rather than attempting to use 
> CR for reporting, I'd simply create a Viságe.BIT cube to give the users free-form 
> enquiry and data exploration facilities into their UV database. In our case we have 
> replaced >300 sales analysis reports currently provided in our R5 system with a 
> single Sales Cube -   and this is one of the facilities that makes Viságe "better" 
> than 
> AccuTerm !

Warning! Salesman quote!
C'mon Ross :) A dataset that includes 50 fields and I only want to see 6 on my report. 
 So you replace that report with a cube where I (the user) have to figure out exactly 
what I want to see, build the proper query statement, format statement, display 
statement etc and then figure out how to tell the system to remember my statement so 
next time I don't have to THAT all again.

You replaced the 300 reports, with one huge cube where you STILL have users recreating 
(or trying to) their original 300 reports...
   Users don't want to see 50 fields, they want to see the 6 fields they've been 
analyzing for the past 3 years ...
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Ross Ferris


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Tony Gravagno
>Sent: Sunday, 18 April 2004 2:45 PM
>To: 'U2 Users Discussion List'
>Subject: RE: GUI from Mv code Re: Crystal Reports
>
>As an aside, pardon me for being so bold, but it's amazing that the
>providers of these GUI products aren't jumping to pay people like me to
>help
>developers become viable candidates for their products.  There's no
>guarantee that any given site will adopt any given GUI product, if any, but
>unless there are prospects there can be no new customers.  It seems to me
>it's worth it to "someone" to foster redevelopment like this.  Well, that's
>the MV market for ya...
>
>Tony
[Ross Ferris] 
??
Please refer to your email of March 23rd - If things have changed I'll get the guys 
from ACTi to give you a call :-)

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
 
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Ross Ferris


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of [EMAIL PROTECTED]
>Sent: Sunday, 18 April 2004 10:18 AM
>To: [EMAIL PROTECTED]
>Subject: Re: GUI from Mv code Re: Crystal Reports
>
>  Then some of the validation (two field
>interactions) should be relegated to the On.SUBMIT part of the program,
>etc.

FWIW you do NOT want to wait until SUBMIT ! In Visage, as soon as you have "all of the 
parts" of a multi-part key validation (2 or more) the validation is performed - and of 
course you don't have to write ANY code for this to happen (all part of our active 
code reduction technology :-)

Likewise if you have cascading relationships like :

Pick a Country & the State Box re-populates
Pick a state and the Town Box re-populates
Change the country & the State & Town boxes clear

Are achieved without code . did I mention that we "extended" the dictionary 
structure, so that this sort of relationship is "visible" ?

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
 
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Ross Ferris
Embedded responses to (hopefully) add contextual reference


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Bruce Nichol
>Sent: Sunday, 18 April 2004 3:20 PM
>To: U2 Users Discussion List
>Subject: Re: GUI from Mv code Re: Crystal Reports
>
>Goo'day,
>
>At 10:17 18/04/04, Will replied to:
>
>>In a message dated 4/17/2004 4:16:06 PM Pacific Daylight Time,
>>[EMAIL PROTECTED] writes:
>>
>>
>> > A key factor that makes CUI non-portable
>> > to GUI is the embedded Input and Print statements in the code.
>>
>>I respectfully disagree that this is key.
>
>Aren't we forgetting what Ross (and others) offer in Visage (and
>whatever)?   AFIK, "Visage" offers users a GUI in a TOTAL WINDOWS LOOK AND
>FEEL/BROWSER environment, without having to do a "total rewrite", but a
>"rewrite" none the less, re-using some portions, perhaps, of existing
>code.   "Visage" seems to be more than a user interface.   It's also
>supposedly (sorry, Ross, I've got no experience in "Visage") a much less
>involved NEW development environment

[Ross Ferris] 
Coming FROM an mv environment, with an existing DB design and application code, I 
think you are right in saying that Viságe is "less involved", and simpler than people 
expect.

As you would expect (hope?), it is ALL of the things that you DON'T HAVE TO DO that 
make developing in Viságe "fun", and easy - whole swags of code that you don't have to 
write (or copy) to extract information from related files, or to correctly update all 
of the multi-valued items in an association (including the new dict item you added 5 
minutes ago) ... they not only add up, they MULTIPLY the benefits!

>
>Other MV so-called "GUI" approaches, (AccuTerm and wIntegrate scripts, for
>example) are offering the user a GUI with an almost-modern Windows look and
>feel, but without the bells and whistles, and are offering a GUI by
>applying Band-Aids to existing code.   I really don't think that's a
>"development environment".I don't think "new development" is covered by
>this approach.
>
>If we were all developing "new" applications, and we could afford it, I
>reckon we would all jump at "Visage"... Or some such.
>

[Ross Ferris] 
Please line up & take a number :-)
The key here may be can you afford NOT to use a tool like Visage ! We try & spin EVERY 
new development request into Viságe these days from our green screen client base - 1 
less program we need to convert later, we end up with a nicer "look", and the customer 
likes what he sees so much, he is willing to fund conversion of existing screens, so 
the exercise is not only self funding, but profitable !

 
>I'd hazard a guess that the cost of "new" development in "Visage", together
>with the cost of "Visage", would come out less (Ross??) than the cost of
>the same level of development to the same level of "total" user interface
>in our known MV Terminal Emulation environs.   The per-user outgoing cost
>of a MV TE capable of supporting the TE scripts (as opposed to the cost of
>IE6!!) is, IMHO, the crippling factor, here.   Especially in the larger
>sites where everybody would be forced into using the "GUI-able" TE instead
>of the lower-cost/freebie ones.


[Ross Ferris] 
That would certainly be the case, especially when you also take into account the 
REDUCTION of DB licences required to support your user population ! (or for existing 
sites the ability to increase the effective user population, without a corresponding 
increase in DB licences).

This is because Viságe uses web technology for data transport, and operates with a 
non-persistent connection model, so you are only "connected" to the backend database 
to do things like reading records, and executing server code.

Our active dictionary & code reduction techniques mean that you can churn out programs 
in record time. Most people have their first GUI screens operating in under an hour 
(that includes product installation - most of this time is spent setting up 
dictionaries!)

>
>What we're all (all of us software developers, that is) trying to do is
>maintain a "public acceptance" for our EXISTING software.   Sales = Public
>Acceptance.Ross is out in front with "Visage", right up there with
>"Windows products", because he's been able to absorb the costs of
>development over a period of time, developing "Visage" and
>developing/redeveloping his applications using it as he goes.   OK,  he's
>paid more for his version of "Visage" bu

RE: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread Ross Ferris
Will,

You are right ! With a product like AccuTerm you can run ANY windows command (within 
your security constraints), fire off & control any OLE/ActiveX application/control, 
and on this level Viságe is on a par with AccuTerm et al.

If you are ONLY looking at being able to fire off Windows applications, then the 
reality is that there is little to differentiate the products ... as you point out, 
they all have a scripting language with automation capabilities, and so could be seen 
as "equal".

However, if you are looking at doing something MORE than just firing off a windows 
EXE, like "enriching" the user experience when interacting with your multi-valued data 
(read GUI), actively reducing the amount of code required to perform a specific task, 
or even something as basic as tidying up your dictionaries, the divergence becomes 
more marked.

Viságe is NOT a terminal emulator on steroids - it is a complete application 
development framework, designed specifically for multi-value databases. Rather than 
recoiling from the mv data model, we embrace it wholeheartedly and have done our best 
to enhance it.

Viságe can radically reduce your development times for any new developments, and can 
leverage your existing assets (Basic Code, Database Designs, Queries etc) to 
re-invigorate (and add an appealing new face to) your existing applications in a 
startlingly short period of time - and it has a feature set that simply isn't provided 
by any other tool in this market place.

For example, aligning this back to the original post, rather than attempting to use CR 
for reporting, I'd simply create a Viságe.BIT cube to give the users free-form enquiry 
and data exploration facilities into their UV database. In our case we have replaced 
>300 sales analysis reports currently provided in our R5 system with a single Sales 
Cube -  and this is one of the facilities that makes Viságe "better" than AccuTerm !



Ross Ferris
Stamina Software
Visage - an Evolution in Software Development

(Footnote: Viságe started life as a "smart" Terminal Emulator MANY moons ago, and we 
still use & promote AccuTerm with our R5 application suite.

>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of [EMAIL PROTECTED]
>Sent: Sunday, 18 April 2004 3:58 PM
>To: [EMAIL PROTECTED]
>Subject: Re: GUI from Mv code Re: Crystal Reports
>
>In a message dated 4/17/2004 10:21:26 PM Pacific Daylight Time,
>[EMAIL PROTECTED] writes:
>
>
>> AFIK, "Visage" offers users a GUI in a TOTAL WINDOWS LOOK AND
>> FEEL/BROWSER environment, without having to do a "total rewrite", but a
>> "rewrite" none the less, re-using some portions, perhaps, of existing
>> code.   "Visage" seems to be more than a user interface.   It's also
>> supposedly (sorry, Ross, I've got no experience in "Visage") a much less
>> involved NEW development environment
>>
>> Other MV so-called "GUI" approaches, (AccuTerm and wIntegrate scripts,
>for
>> example) are offering the user a GUI with an almost-modern Windows look
>and
>> feel, but without the bells and whistles, and are offering a GUI by
>> applying Band-Aids to existing code.   I really don't think that's a
>> "development environment".I don't think "new development" is covered
>by
>> this approach.
>
>What?  How exactly do you get this?
>A script is not an "almost modern Windows look and feel"... it is the look
>and feel.
>The script calls windows exectuables underneath it, thats how it works.
>If a programmer chooses not to utilize all the various objects and methods
>etc that Accuterm reveals, thats their own choice, not the fault of the
>product.
>
>I'm not sure exactly how Visage is that much better than Accuterm in that
>regard.
>Are you?
>Will
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004
 
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-17 Thread FFT2001
In a message dated 4/17/2004 10:21:26 PM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> AFIK, "Visage" offers users a GUI in a TOTAL WINDOWS LOOK AND 
> FEEL/BROWSER environment, without having to do a "total rewrite", but a 
> "rewrite" none the less, re-using some portions, perhaps, of existing 
> code.   "Visage" seems to be more than a user interface.   It's also 
> supposedly (sorry, Ross, I've got no experience in "Visage") a much less 
> involved NEW development environment
> 
> Other MV so-called "GUI" approaches, (AccuTerm and wIntegrate scripts, for 
> example) are offering the user a GUI with an almost-modern Windows look and 
> feel, but without the bells and whistles, and are offering a GUI by 
> applying Band-Aids to existing code.   I really don't think that's a 
> "development environment".I don't think "new development" is covered by 
> this approach.

What?  How exactly do you get this?
A script is not an "almost modern Windows look and feel"... it is the look 
and feel.
The script calls windows exectuables underneath it, thats how it works.
If a programmer chooses not to utilize all the various objects and methods 
etc that Accuterm reveals, thats their own choice, not the fault of the product.

I'm not sure exactly how Visage is that much better than Accuterm in that 
regard.
Are you?
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-17 Thread Bruce Nichol
Goo'day,

At 10:17 18/04/04, Will replied to:

In a message dated 4/17/2004 4:16:06 PM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
> A key factor that makes CUI non-portable
> to GUI is the embedded Input and Print statements in the code.
I respectfully disagree that this is key.
Aren't we forgetting what Ross (and others) offer in Visage (and 
whatever)?   AFIK, "Visage" offers users a GUI in a TOTAL WINDOWS LOOK AND 
FEEL/BROWSER environment, without having to do a "total rewrite", but a 
"rewrite" none the less, re-using some portions, perhaps, of existing 
code.   "Visage" seems to be more than a user interface.   It's also 
supposedly (sorry, Ross, I've got no experience in "Visage") a much less 
involved NEW development environment

Other MV so-called "GUI" approaches, (AccuTerm and wIntegrate scripts, for 
example) are offering the user a GUI with an almost-modern Windows look and 
feel, but without the bells and whistles, and are offering a GUI by 
applying Band-Aids to existing code.   I really don't think that's a 
"development environment".I don't think "new development" is covered by 
this approach.

If we were all developing "new" applications, and we could afford it, I 
reckon we would all jump at "Visage"... Or some such.

I'd hazard a guess that the cost of "new" development in "Visage", together 
with the cost of "Visage", would come out less (Ross??) than the cost of 
the same level of development to the same level of "total" user interface 
in our known MV Terminal Emulation environs.   The per-user outgoing cost 
of a MV TE capable of supporting the TE scripts (as opposed to the cost of 
IE6!!) is, IMHO, the crippling factor, here.   Especially in the larger 
sites where everybody would be forced into using the "GUI-able" TE instead 
of the lower-cost/freebie ones.

What we're all (all of us software developers, that is) trying to do is 
maintain a "public acceptance" for our EXISTING software.   Sales = Public 
Acceptance.Ross is out in front with "Visage", right up there with 
"Windows products", because he's been able to absorb the costs of 
development over a period of time, developing "Visage" and 
developing/redeveloping his applications using it as he goes.   OK,  he's 
paid more for his version of "Visage" but he got his version earlier than 
the rest of us; he and his people have far more experience with it than the 
rest of us; it was written for their express requirements; they know what 
its' capabilities are; they know its' shortcomings; they know what's 
planned for its' future, and he's selling licences to it to help in 
recovering his outlay.   Most of the rest of us are looking at it, at its 
cost, at the cost of "redeveloping" using it, and going with it, or hoping 
that the lower initial outlay of providing TE scripts will suffice, or ..

At our level of the market, a Windows-driven "shareware" TE such as NetTerm 
- which offers "mouse awareness"and "hot-spots" (a "constant mouse 
position" for "Y" or "N" outside the TE "screen", etc) amongst other 
useable things, coupled with a "lightly-rewritten" development (basically 
now offering "lists" of acceptable input for user acceptance, where 
applicable - reducing the "guess work") of our existing applications to 
provide a "mouse aware"  "shrink-wrapped" version in direct competition to 
the MYOBs,"Business Manager", Quicken's, etc, (5 to 20 users) at those sort 
of costs, is where we perceive our future.We don't want to sell 
millions of seats, but, rather,  provide a "quality" "easy to use" "easy to 
understand" product that we can support from wherever we choose to be - and 
make a quid!   OK, we don't have the banks clamouring to provide or accept 
detail in our "native" file format, but they *do* provide and accept .csv 
and .txt formats, and we have OPENSEQ with READSEQ/WRITESEQ in our quiver, 
so we're competitive

Our biggest problem in the market is the discipline we insist on at 
input. Not the sequence of input, mind you, but not allowing users to 
"short cut", or ignore proper "audit" procedures. After all, we're 
throwing ourselves squarely at the "Mums and Dads" "I only want to 
do.." commercial marketIf we can just convince a few of them 
that they can use the mouse to "point at" a  selection, or use "arrow" keys 
to transverse a list of options, or even, at worst, use a keyboard to enter 
something (remapping  as  has helped!!), and that there is some 
discipline involved ...

With the ..SEQs we also offer the ability to import/export data to/from the 
MV database.   So, any "office product", for example, Excel or Word or, God 
forbid, MS Access can be used as a front/back end.  (I appreciate the 
subject is/was "Crystal Reports" but, frankly, I've never been asked for 
anything other than Excel, Word or MS Access interaction, except, years 
ago, Lotus).   Is it a major problem to write to a file and get your 
"office product" to pick up and conve

RE: GUI from Mv code Re: Crystal Reports

2004-04-17 Thread Tony Gravagno
Will wrote:
>> A key factor that makes CUI non-portable
>> to GUI is the embedded Input and Print statements in the code.
>
>I respectfully disagree that this is key.
>After all event oriented apps also have input statements
>I think you mean the key factor is that the programs are not 
>event oriented.

Mike Randall said:
>I think the point Tony was making was the splitting of the 
>program logic from the actual screen formatting. 
> ...
>You do bring up a valid point regarding event driven apps with 
>the concept of submitting an entire form.


You're both right.  Note that my quote was "_A_ key factor", not "_The_ key
factor".  In my mind I assume that event orientation is possible once code
is modularized, Input statements are replaced with passed-in values, and
Print statements are replaced with returned messages and status data.  You
can have event oriented code with Print/Input statements, which isn't
desirable, at least in MV code destined for a GUI.  You can also have
monolithic procedural code without the Print/Input statements, which could
be the case with screen-at-a-time (3270 style) code.

The bottom line is that a fundamental shift needs to be made in most MV code
before it can be moved to GUI.  Contrary to popular belief this shift
doesn't need to be made all at once.  I have a VAR/client with a 20 year old
app that is being refitted over time to be more modular.  They started their
conscious shift about a year ago and they're now finding all sorts of
benefits to modularization.  They're now at a point where they can start
looking at various GUI-enablement products in our market space.

As an aside, pardon me for being so bold, but it's amazing that the
providers of these GUI products aren't jumping to pay people like me to help
developers become viable candidates for their products.  There's no
guarantee that any given site will adopt any given GUI product, if any, but
unless there are prospects there can be no new customers.  It seems to me
it's worth it to "someone" to foster redevelopment like this.  Well, that's
the MV market for ya...

Tony

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-17 Thread Mike Randall
I think the point Tony was making was the splitting of the program logic
from the actual screen formatting.   One of the most arduous tasks in
converting to a GUI is the splitting of the screen layout (print statements)
from the business logic in programs.  If your programs have the somewhat
typical [EMAIL PROTECTED] SOMETHING WITH INPUT format, the PRINT@ part has to
be removed as it will be replaced by the GUI.  Applications that have some
type of screen processor are way ahead of the game.  In that scenario, your
code is mostly logic and much easier to link a GUI.   

You do bring up a valid point regarding event driven apps with the concept
of submitting an entire form.  IMO, that depends on the platform and design
choices made by the developer.   For example, using Redback with ASP or ASP.
Net, you can pretty much mimic the field by field validations and processing
of CUI programs (one of the greatest features of .Net is the auto postback).
Of course there are performance considerations/penalties for doing it but
you can do it.   On the flip side, you could also take all the input and
submit it to a server process once.   More efficient but trade-offs in
functionality.

Mike R.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Saturday, April 17, 2004 8:18 PM
To: [EMAIL PROTECTED]
Subject: Re: GUI from Mv code Re: Crystal Reports

In a message dated 4/17/2004 4:16:06 PM Pacific Daylight Time,
[EMAIL PROTECTED] writes:


> A key factor that makes CUI non-portable
> to GUI is the embedded Input and Print statements in the code.

I respectfully disagree that this is key.
After all event oriented apps also have input statements
I think you mean the key factor is that the programs are not event oriented.

That is, on a typical GUI form I can click and fill in any field in any 
order, and then I submit the entire form.  In a typical mv app, most
programmers 
would write it so the inputs happen in a definite order and there is no way
to 
change that order, on the fly.

If programs were rewriten so that the inputs were all seperated from each 
other logically, and could be entered in any order.  (Tab forward, tab back 
between fields, or point and click since mouse clicks are captured by
accuterm and 
wintegrate among others).  Then some of the validation (two field 
interactions) should be relegated to the On.SUBMIT part of the program, etc.

If we could code in this fashion, then any app can be GUIized with less 
effort.
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: GUI from Mv code Re: Crystal Reports

2004-04-17 Thread FFT2001
In a message dated 4/17/2004 4:16:06 PM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> A key factor that makes CUI non-portable
> to GUI is the embedded Input and Print statements in the code.

I respectfully disagree that this is key.
After all event oriented apps also have input statements
I think you mean the key factor is that the programs are not event oriented.  
That is, on a typical GUI form I can click and fill in any field in any 
order, and then I submit the entire form.  In a typical mv app, most programmers 
would write it so the inputs happen in a definite order and there is no way to 
change that order, on the fly.

If programs were rewriten so that the inputs were all seperated from each 
other logically, and could be entered in any order.  (Tab forward, tab back 
between fields, or point and click since mouse clicks are captured by accuterm and 
wintegrate among others).  Then some of the validation (two field 
interactions) should be relegated to the On.SUBMIT part of the program, etc.

If we could code in this fashion, then any app can be GUIized with less 
effort.
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


RE: GUI from Mv code Re: Crystal Reports

2004-04-17 Thread Tony Gravagno
Tough to find a good place for these comments.  There are some interesting
observations to make on the mentality of IT people, business management,
etc..

First, on the concept of "if we're going to add a GUI we might as well get
an entirely new app":  The business rules and UI should be considered as
entirely separate entities.  Getting a new app with a GUI does not imply
that you're going to get equal or better business rules.  This concept is
exemplified by Mark's GP client and dozens more like them.  Management must
be educated to separate the idea of the UI from the business rules.

Second, I wince in pain at the concept of IT people looking at a Character
UI and deciding it's deficient, based solely on the asthetic value.  How can
someone decide by the UI whether an app suits business needs?  How does the
simple fact that an app has a Graphical UI make it any more functional than
a Character UI?  What is the trigger in the mind of IT people that leads
from "I see a GUI" to "it must be capable of running our business" or "all
we need to do is add a couple business rules to this GUI and it will work
for us"?  I really think this GUI mentality comes in part from the video
game generation where graphical games are perceived as better than the old
Pong, StarTrek, Zork, Wumpus, and Adventure games ("plugh" or "xyzzy" ring
any bells here?)  In all of the rhetoric about separating the UI from the
business rules, somewhere in the minds of IT people is the idea that a
Graphical UI implies better business rules - and graphical database
management tools somehow imply a more sophisticated database.  So while
people sing the praises of Object Orientation and n-tier architectures, in
the big picture they still don't really "get it".

Third, and all of this is really related, what confuses me about all of
these failed migrations is that intelligent professionals keep missing
obvious factors of migration, like feature comparisions, business needs
assessments, training, and documentation.  And why do we seldom see basic
auditing to identify problems and keep a project on track - or to put a halt
to migration when critical (and I really mean critical) issues are
identified?  In every one of these failed migrations there is one or more
persons in management pushing forward with some underlying business agenda,
no one wants to openly state that the plans aren't sound, the systems aren't
ready, or that the whole idea is foolhardy - and somehow hundreds of
thousands of dollars get thrown into projects like this with no one in IT to
pull in the reins and say "enough is enough, this is FUBAR".

There are answers:
- Upper management should openly listen, if not directly or immediately
heed, the advice of everyone affected by a migration, from end-users to IT
to trading partners and perhaps even stockholders.
- Upper management must insist on detailed advance planning from IT, and get
everyone to try to poke holes in the plan.  Hire a consultant to poke holes
in the plan (similar to hiring a hacker to test your network security).  If
the plan doesn't work, at least everyone had their input.  This is far
better than post-failure finger pointing and "I coulda told them it was a
stupid plan" comments.  (Yes, that will happen anyway if people ignore the
opportunity to speak up.  Small people love to bask in the failure of
others.)
- Someone needs to be accountable.  It seems the people who drive projects
like this into the ground have the least to lose and many people under them
to blame.

Finally, and back to the topic, about Results and the magic silver bullet
which will lead from CUI to GUI:  It seems we have years to add
functionality to these CUI applications, but no time to prepare them for the
almost inevitable GUI challenge.  A key factor that makes CUI non-portable
to GUI is the embedded Input and Print statements in the code.  Don't wait
for tools to go GUI, prepare your app properly and you'll find many tools
that can then be used to add the GUI.  If developers would take some time to
modularize their code, then migration to GUI using any number of tools can
be a relatively simple, painless, and inexpensive process, compared to
migration from linear/procedural/non-event-oriented "spaghetti" code.
Pre-emptive modularization may eliminate the need for migration, saving
months to years of aggravation and tens to hundreds of thousands of dollars
in non-recoverable expenses.  And IF migration is to occur, modularization
now can facilitate the process later, allowing a company a smoother exit
strategy rather than a cold-turkey cutoff.  Unfortunately these concepts
have been well known for over a decade but we continue to hear stories where
the code can't be GUItized so management decides to toss the app.

Getting management to buy-in on the time/cost of modularizing an app is
tough.  The value is only perceived when the expense of a GUI or migration
is considered, and that's usually too late.  I think it's important for IT
pe

RE: GUI from Mv code Re: Crystal Reports

2004-04-17 Thread FFT2001
In a message dated 4/17/2004 9:10:12 AM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> The tools are there to produce applications on par with anything on the
> market.  Web interfaces via tools like Redback. UOJ, .Net PDP, or the java
> interfaces are all there to produce great solutions for U2. 

And I would like to mention Accuterm.  I have built several scripts in 
Accuterm that do Gui like functions, and are launced from inside the mv Code.  
Accuterm has the ability to watch for a command that is directed at it and then 
take actions in Windoze.

So for example, one client, has an application where they have to pull up a 
record in an mv screen and then listen to a person speaking (off a MP3 file) 
and then process the record based on that speech.  So my solution was to write 
an accuterm script that launches Windows Media Player to the location specified 
from the mv code.

Another script launches web requests from inside mv code, scraps the 
contents, and presents partial information within an mv application.  All in basically 
a green-screen format, inside an Accuterm window.  But I digress.

My main point was, that the tools are here.  Are you ready to learn how to 
use them?  That's the sticking point.

Will Johnson
Fast Forward Technologies
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users