R.I.P.
On 07/02/2012 17:52, Brian Leach wrote:
what a horrible thought ... some things rightly belong in the trash can of
history. Jet and Runoff are definitely in that category.
Brian
Sent from my ASUS Eee Pad
Wjhonson<wjhon...@aol.com> wrote:
Dig it up and market it because Universe is no longer offering JET.
-----Original Message-----
From: Brian Leach<br...@brianleach.co.uk>
To: 'U2 Users List'<u2-users@listserver.u2ug.org>
Sent: Tue, Feb 7, 2012 9:43 am
Subject: Re: [U2] Building an Excel File
IIRC didn't VMARK buy CompuSheet, at around the same time they bought JET?
t's probably lying around on and old QIC somewhere..
I'd just written a JET and Ultiword emulator for UniVerse when they popped
p with JET. Grr.. but a long time ago.
nd back to topic I second the "use Tony's tools" motion. Why waste time and
oney reinventing the wheel?
You make think your working time is free, but someone's paying for it!)
If you really need to call out from Excel (as opposed to building
preadsheets from the db) you can use VBA and UniObjects.
Brian
-----Original Message-----
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
ent: 07 February 2012 16:13
o: U2 Users List
ubject: Re: [U2] Building an Excel File
Amen! I don't think I would want to go back to 9600 baud serial
ommunications, though. My first Reality "job" was contract programming
or a local service bureau, using an ADDS Viewpoint terminal and 300
aud acoustical coupler. They handed me the terminal, modem and a set of
anuals and said "Have fun!". Dang, now I'm telling my age!
EasyCalc ran on Reality as well. Of course, it went the way of many of
he other dinosaurs. Now EasyCalc Googles to a scientific calculator on
ourceForge. I acquired the source code and rights to redistribute, but
hat never went anywhere.
If memory serves, Compusheet used a lot of abs frames for speed. EC was
ll Data/Basic. It was a bit slow recalculating a series of 600+
preadsheets from the bottom up. The others in IT (then called Data
rocessing) didn't think I would be able to get it to work at all, but
t did. The sheets drilled all the way down to class enrollment and
aperclip counts, and rolled it all up to a top level , which they used
o feed their GL.
I probably should have taken this [OT], but I didn't know what effect
hanging the subject would have.
Charlie
On 02-07-2012 9:52 AM, Dianne Ackerman wrote:
Hm, don't remember EasyCalc, but Compusheet was on a Reality system.
It was so much easier when we only had to know what was native in our
own systems and not be concerned with a million different things to
connect to in the outside world!
-Dianne
On 2/7/2012 10:45 AM, Charlie Noah wrote:
Hi Dianne,
You're telling your age here! ;^)
Actually, it was EasyCalc, which was probably very similar to
Compusheet.
Charlie
On 02-07-2012 9:30 AM, Dianne Ackerman wrote:
Compusheet? I remember working with that!
-Dianne
On 2/7/2012 6:50 AM, Charlie Noah wrote:
Hi Bob,
I don't suppose CrowFlite can be obtained these days, can it? It
looks like Phil has retired. If it were available, would it work
with the newer versions of Excel? What about Open Office?
In the 80s I worked for a university in Florida, where we used a
Pick-based spreadsheet modeled after Lotus 123. I built a series of
spreadsheets which reached down into every aspect of the
university's database, giving upper management an up to the minute
view of the school's financial picture. I think it ended up being
over 600 spreadsheets, but hey, fund accounting is complicated and
we did still have the 32K limit.
Fond memories. ;^)
Regards,
Charlie Noah
Tiny Bear's Wild Bird Store
"Everything For The Backyard Bird Enthusiast, Except For The Birds"
Info, Forum: http://www.TinyBearMarketing.com
Store: http://Stores.TinyBearMarketing.com
Toll Free: 1-855-TinyBear (855-846-9232)
On 02-06-2012 10:57 PM, Bob Rasmussen wrote:
Makes one long for CrowFlite, doesn't it?
For those that don't remember, CrowFlite was an add-in to Excel that
allowed it, at a per-cell level, to "reach back" into a Pick
database and
grab individual pieces of data. In other words, it was a "pull"
solution
as well as a "push".
I'm cc'ing its creator, Phil Gerber, so he can reminisce about the
past
while reveling in the sights among the mountains of Oregon :-)
On Mon, 6 Feb 2012, Tony Gravagno wrote:
Not responding to any particular quote here, just the CSV topic
in general.
Respected colleagues, CSV is not Excel. If you have an end-user
that asks for Excel and you give them a CSV you're just
perpetuating the myth that Pick is a dinosaur. They will gladly
spend tens of thousands of dollars to replace your application
with something that creates real Excel (and PDF) despite the fact
that such things can be attained at low cost or no cost right
now. Trust me, I've seen it happen.
This dove-tails with the reasons why people get 20 people to
support Oracle when they can have 3 working on Pick. The reason
is that the Oracle people say "yes", and give them pretty
reports, when their Pick guys say "no", and give them plain text
in columns and rows and call it "Excel".
Please don't let that happen to you. Be sure you are properly
responding to end-user requests. Just ask them what they do with
the documents after you generate them. If they really just want
raw data, OK. But if they go on to tell you how many days it
takes to reformat the data, assemble the multiple CSVs into a
single workbook, etc, then you have found a great deal of room
for improvement. Yeah, I've been there too.
Off the soapbox, thanks.
T
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
______________________________________________
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
______________________________________________
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
