Re: [U2] Building an Excel File

2012-02-07 Thread Charlie Noah
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

Re: [U2] Building an Excel File

2012-02-07 Thread Israel, John R.
You said this was written for Revelation. Isn't Revelation a Windows based version of PICK, and thus the .bat file it builds will be running Excel which must be loaded on the server? I have a UNIX box which will not have Excel, thus this solution does not appear like it will work for me. If

Re: [U2] Building an Excel File

2012-02-07 Thread Richard A. Wilson
Rev G2b was released in 1986 so it is truely Dos based once Unidata has written the .TXT or .CSV file I assume you'll start up some command shell that would be provided by accuterm or whatever I have used the same type of program for both of the U2's in a windows server environment Rich

Re: [U2] Building an Excel File

2012-02-07 Thread Israel, John R.
This looks VERY promising! Thanks John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Monday, February 06, 2012 7:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Building an Excel File

Re: [U2] Building an Excel File

2012-02-07 Thread David A. Green
I have to say amen to Tony's comments. Why try and reinvent the wheel when there is a utility already written? Or throw out some kludgy solution when a native one can be found? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Building an Excel File

2012-02-07 Thread Dianne Ackerman
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

Re: [U2] Building an Excel File

2012-02-07 Thread Charlie Noah
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

Re: [U2] Building an Excel File

2012-02-07 Thread Bob Rasmussen
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? CrowFlite is long out of date, both in support of

Re: [U2] Building an Excel File

2012-02-07 Thread Dianne Ackerman
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:

Re: [U2] Building an Excel File

2012-02-07 Thread Charlie Noah
Amen! I don't think I would want to go back to 9600 baud serial communications, though. My first Reality job was contract programming for a local service bureau, using an ADDS Viewpoint terminal and 300 baud acoustical coupler. They handed me the terminal, modem and a set of manuals and said

Re: [U2] Building an Excel File

2012-02-07 Thread Brian Leach
IIRC didn't VMARK buy CompuSheet, at around the same time they bought JET? It's probably lying around on and old QIC somewhere.. I'd just written a JET and Ultiword emulator for UniVerse when they popped up with JET. Grr.. but a long time ago. And back to topic I second the use Tony's tools

Re: [U2] Building an Excel File

2012-02-07 Thread Wjhonson
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

Re: [U2] Building an Excel File

2012-02-07 Thread Brian Leach
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

Re: [U2] Building an Excel File

2012-02-07 Thread Allen E. Elwood
why when i was writing interfaces we did it with rocks and sticks, AND we had to walk through the snow to do it. barefooted AND WE LOVED IT! ;-) actually i'm kinda surprised no one mentioned using TAB as a delimiter. since it's never in text fields, you always get the data across with no

Re: [U2] Building an Excel File

2012-02-07 Thread George Gallen
Why back in our day, the bits traveled at 110 baud, and simplex too. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Tuesday, February 07, 2012 12:57 PM To: 'U2 Users List' Subject: Re: [U2]

Re: [U2] Building an Excel File

2012-02-07 Thread Brian Leach
Bet you had ones AND zeros .. We couldn't afford the ones ... Brian Sent from my iPad On 7 Feb 2012, at 18:08, George Gallen ggal...@wyanokegroup.com wrote: Why back in our day, the bits traveled at 110 baud, and simplex too. -Original Message- From:

Re: [U2] Building an Excel File

2012-02-07 Thread Wjhonson
When I was a kid we had to carry the bits from one computer to the other by hand! In a tray! And if you dropped that tray you spend the next week putting all the bits back in order! -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List

Re: [U2] Building an Excel File

2012-02-07 Thread Israel, John R.
Before we had monitors, WE used to have to write code with magnets! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 07, 2012 1:19 PM To: u2-users@listserver.u2ug.org Subject: Re:

Re: [U2] Building an Excel File

2012-02-07 Thread Dianne Ackerman
Ick, that reminds me of a time I was carrying punch cards and dropped them all out of order : On 2/7/2012 1:19 PM, Wjhonson wrote: When I was a kid we had to carry the bits from one computer to the other by hand! In a tray! And if you dropped that tray you spend the next week putting all

Re: [U2] Building an Excel File

2012-02-07 Thread Wjhonson
Just think if you had dropped them IN order you could now be in the Data Processing Hall of Fame ! -Original Message- From: Dianne Ackerman dia...@aptron.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 7, 2012 10:32 am Subject: Re: [U2] Building an Excel File Ick,

Re: [U2] Building an Excel File

2012-02-07 Thread Bobby Worley
I just did something very similar last week. 'CSV' is a VM delimited dynarray to be converted: VCNT=DCOUNT(CSV,@VM) FOR VPTR=1 TO VCNT CSVCELL=CSV1,VPTR IF INDEX(CSVCELL,',',1) OR INDEX(CSVCELL,'',1) THEN CSVCELL=CHANGE(CSVCELL,'','')

Re: [U2] Building an Excel File

2012-02-07 Thread Joshua Gallant
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:

Re: [U2] Building an Excel File

2012-02-07 Thread Mecki Foerthmann
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 Wjhonsonwjhon...@aol.com wrote: Dig it up and market it because Universe is

Re: [U2] Building an Excel File

2012-02-07 Thread Wjhonson
So what are they using in place of JET? Did you ever use JET-EDIT to edit your programs? -Original Message- From: Joshua Gallant jgall...@cbd.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 7, 2012 12:41 pm Subject: Re: [U2] Building an Excel File We were running

[U2] Building an Excel File

2012-02-07 Thread Thompson, Beau
John, I hope you have received some useful ideas by now. We use UniVerse on a Windows Platform. After MS Office 2003, the use of xls/xlsx files have been a little more structured. What we do is generally use tab delimited files when the end user will only accept a data file. What we prefer

Re: [U2] Building an Excel File

2012-02-07 Thread Tony Gravagno
From: Bob Rasmussen It would be conceivable, though not necessarily profitable, to have an Excel add-in that would pull data out of Pick via a network-based object call. Conceivable? How about Done. Phil Gerber has referred people to NebulaXChange as the replacement for CrowFlite.

Re: [U2] Building an Excel File

2012-02-07 Thread David Wolverton
Can you license this logic to Rocket? Seems like getting the 'check box' for the database would serve them well, and would be a drop in the bucket for them to throw dollars at you that would be FAR more than you would likely get licensing it one-off yourself. Just a thought. Rocket should be

Re: [U2] Building an Excel File

2012-02-07 Thread Bob Rasmussen
Sorry, Tony, I should have been aware of your offerings. Maybe you need to charge A LOT for your product, and then people would be interested :-) On Tue, 7 Feb 2012, Tony Gravagno wrote: From: Bob Rasmussen It would be conceivable, though not necessarily profitable, to have an Excel

[U2] Including Code - A Best Practice?

2012-02-07 Thread Baker Hughes
A friendly discussion arose recently among some U2/MV Developers about whether to include code. If any of you have opinions about the positive aspects or negative aspects of this practice, please respond. Should it be adopted as a best practice, or rejected as special situation use only?

Re: [U2] Including Code - A Best Practice?

2012-02-07 Thread Kevin King
An include is fine for declarations, but not for executable code due to the fact that individual lines in the include cannot be debugged (on Unidata). Declarations like EQUates and common blocks are best uses for includes. The need to break apart big routines due to some arbitrary limit (i.e.

Re: [U2] Including Code - A Best Practice?

2012-02-07 Thread Wols Lists
On 07/02/12 23:46, Kevin King wrote: An include is fine for declarations, but not for executable code due to the fact that individual lines in the include cannot be debugged (on Unidata). Declarations like EQUates and common blocks are best uses for includes. The need to break apart big

Re: [U2] Including Code - A Best Practice?

2012-02-07 Thread Kevin King
I agree with Wols; a subroutine takes more memory and is slower to launch but is so much easier to work with in any sized system. It's funny, our subroutines are oddly similar to how Microsoft implemented DLL wrecknology for Windows, but we've never had the kind of hell that Windows programmers

Re: [U2] Building an Excel File

2012-02-07 Thread Don
Amen Tony. I don't know how many times I get a call from a user saying for some reason my XLS/XLSX parser doesn't work with the Excel file they have. What the user really has is a CSV/TSV file with a XLS file extension that some programmer decided to name the file. This is because EXCEL doesn't

Re: [U2] Building an Excel File

2012-02-07 Thread Wjhonson
I think somewhere this jumped the track. No one is saying that CSV is Excel Rather the OP wanted a way to read an Excel file on the Iphone. Can the Iphone natively read Excel files? I know that it can natively read csv files, because we're doing it. It puts the csv file into a neat table with a

Re: [U2] Including Code - A Best Practice?

2012-02-07 Thread Ross Ferris
There are plenty of reasons to include code, and issues like variable assignment should be able to be addressed with minimal care as to scope of the variables -- if you use I in a for/next loop and include or execute some code in the loop that also uses I, U will get what you deserve. As per

Re: [U2] Including Code - A Best Practice?

2012-02-07 Thread Tony Gravagno
From: Kevin King It's funny, our subroutines are oddly similar to how Microsoft implemented DLL wrecknology for Windows, but we've never had the kind of hell that Windows programmers experience. Funny how that works... :) I completely disagree. Have you never been working on code in a

Re: [U2] Building an Excel File

2012-02-07 Thread Tony Gravagno
Wil, while the OP asked about reading Excel on an iPhone, the title of the thread is Building an Excel File. That prompted suggestions for how to create Excel, including use CSV. Yes, all spreadsheet clients including Excel will open a CSV file. But that led to my assertion that CSV is not

Re: [U2] Building an Excel File

2012-02-07 Thread Allen Elwood RR
sounds awesome tony, really. rocket shouldn't launch without it :-) On 2/7/2012 7:14 PM, Tony Gravagno wrote: Wil, while the OP asked about reading Excel on an iPhone, the title of the thread is Building an Excel File. That prompted suggestions for how to create Excel, including use CSV.

Re: [U2] Building an Excel File

2012-02-07 Thread Wjhonson
My comment that csv files can be read on the Iphone without any effort and they look nice only addresses the issue of reading tables on the iphone. Period. That's it. That's essentially what the OP wanted, unless of course some cells are actually calculated values. The information that we

Re: [U2] Building an Excel File

2012-02-07 Thread Tony Gravagno
Wil, you didn't say 'I', so you're not saying it 'again'. I responded to what you said. You're doing that troll thing again. So again, I say - Just stop it man. From: Wjhonson And again I never said csv was Excel. From: Wjhonson No one is saying that CSV is Excel