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