We were running JET until our latest UniVerse upgrade earlier this year.
We used it all over and the users actually resisted when we told them it
had to go.  Go figure.  After a few days testing with our own code they
saw the light.

- Josh

On 2/7/12 12:46 PM, "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.
-----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.
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!

 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

2-Users mailing list

2-Users mailing list

U2-Users mailing list

U2-Users mailing list

Reply via email to