Re: [U2] stop
State Trooper Out P1$$ing On 05-09-2014 10:56 AM, Allen Egerton wrote: Slight Tap On Pedal Je ne comprends pas. (Allen - Sent from my paperweight) On May 9, 2014, at 11:52 AM, Jerry Neff jerry.n...@scccd.edu wrote: stop Jerry L Neff, Programmer/Analyst - IS State Center Community College District Phone (559) 244-5952 Fax (559) 222-9954 jerry.n...@scccd.edumailto:jerry.n...@scccd.edu ___ 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
Re: [U2] Exiting, it's been fun
I wish you the very best in your retirement! Charlie Noah On 05-09-2014 11:11 AM, Jerry Neff wrote: After an absolutely wonderful 32 years working primarily in the Pick e.g. unidata/universe world I am retiring. My wife and I are picking up stakes, Fresno, CA, moving to South Lake Tahoe, NV to enjoy the cooler climate and beautiful terrain. I can't imagine Dick Pick would have even thought his db would span the timeframe it has and it's still going... During my career I survived three db conversions only to move on to yet another pick environment/shop. I've programmed, administered, managed, consulted and returned to programming to end my career... I can honestly say the Pick world has been very good to me... Even though I did not post frequently I read 99% of what was happening and enjoyed every minute while working feverishly away at my current job. There are still several Pick icons, very knowledgeable and seasoned people, on the post so everyone with questions are in good hands. Thank you for all your posts and best of luck to you all. Jerry L Neff, jnef...@excite.commailto:jerry.n...@scccd.edu ___ 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
Re: [U2] Rgarding ED editor
Aw, George, Doug is always pushing his product. :-) Remember, if all you have is a hammer, everything looks like a nail. I'm not disparaging Doug's product - I've never even seen it - but in 35 years, I've never needed it. BTW, I agree with you 100%. I use the line editor when it's the best tool, and a full screen editor when it's best. Charlie On 04-17-2014 9:16 AM, George Gallen wrote: Doug, I totally disagree! Yes, once you get used to a GUI editor, ED/AE can be tough, but it has it's merits too. One, it's quick - it's ALWAYS available. Would you honestly invoke a GUI editor to make a quick change to a VOC entry? It's a tool of the trade - it needs to be a required learn George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: Thursday, April 17, 2014 9:18 AM To: U2 Users List Subject: Re: [U2] Rgarding ED editor If you are trying to use ED or AE in Universe or Unidata these are line by line editors. If someone is new to U2 then this is a bad move to try and teach them something so archaic. Regards, Doug www.u2logic.com/tools.html The only Eclipse editor with continuous compile technology ___ 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
Re: [U2] [OT] Need Lexmark 6150 Multifunction Printer Software
That worked. Thanks, Scott! Where did you find this link? I looked all over and never ran across it. I did have to use XP compatibility, rather than Vista, as the instructions said. Thanks, Charlie On 03-29-2014 8:39 PM, Scott Richardson wrote: Try this? http://www.justanswer.com/printers/4jmo2-recently-installed-windows-lexmark-x6150-will.html Regards, Scott Richardson Marlborough, MA 01752 ** CheetahFTL Best way to contact is email http://www.linkedin.com/in/cheetahftl ** On 3/29/2014 7:07 PM, Charlie Noah wrote: Hey folks, I have another somewhat OT need. My wife and I both have Lexmark 6150 multifunction printers. We use both the printing and scanning functions. Copying is internal to the printer, so that still works, and we don't need the fax capability (we have an internet solution for that so long as we can scan documents). I don't even remember what the 5th function is, so we probably don't need it. The problem is that I have moved to Win7 32 bit, and my wife will very soon. Our printers aren't supported by Win7 and there are no drivers available. Mine will print fairly well, but the print jobs won't close. The multifunction software which came with the printers and is needed for the scanner will not work on Win7. These printers work fine, and we hate to just dispose of them, because of the environmental impact (even recycling -it's good to be green), and because we just can't afford to buy new printers. To get the functions we need will cost somewhere between $60-$150 each. $60 is very low-end. We are both disabled and have very minimal income. Does anyone out there know of any software to enable the scanning function, and/or a driver that will make the printer work better? Thanks, Charlie ___ 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
[U2] [OT] Need Lexmark 6150 Multifunction Printer Software
Hey folks, I have another somewhat OT need. My wife and I both have Lexmark 6150 multifunction printers. We use both the printing and scanning functions. Copying is internal to the printer, so that still works, and we don't need the fax capability (we have an internet solution for that so long as we can scan documents). I don't even remember what the 5th function is, so we probably don't need it. The problem is that I have moved to Win7 32 bit, and my wife will very soon. Our printers aren't supported by Win7 and there are no drivers available. Mine will print fairly well, but the print jobs won't close. The multifunction software which came with the printers and is needed for the scanner will not work on Win7. These printers work fine, and we hate to just dispose of them, because of the environmental impact (even recycling -it's good to be green), and because we just can't afford to buy new printers. To get the functions we need will cost somewhere between $60-$150 each. $60 is very low-end. We are both disabled and have very minimal income. Does anyone out there know of any software to enable the scanning function, and/or a driver that will make the printer work better? Thanks, Charlie ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dump truck backup
Very possible if you're using a terminal emulator that will pass through mouse codes and an input routine that can be taught to interpret them. The biggest problem I had with that was that old-school users wanted to Enter from field to field, and Windows users wanted to Tab from field to field, and Enter to submit the page. I just told them to get out the boxing gloves and whoever won would get their way. :-) IMHO, the assistant director is very short-sighted and will move on to something else when it all hits the fan. Good luck! Charlie Noah Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 03-10-2014 5:54 PM, dale kelley wrote: While I know that mouseable screens provide no improvement in functionality I would try to keep it at least as good as it is. Old users could still use the keyboard but them winders people could click their way. Is that possible? On 03/10/2014 05:09 PM, Allen Elwood RR wrote: imho, mousing up just leads to disability claims about mouse shoulder... a tax preparation service who shall go unnamed has a hideous package that *cannot change fields* unless you use the mouse, which means every time you type you have to reach over and grab the damn thing to go to the next field i cannot tell you how many times i had to rub my wife's shoulder with bengay before she finally quit - took five years for the lump in the middle of her shoulder blade to heal On 3/10/2014 2:11 PM, Dale Kelley wrote: This is mostly for you folks who are contractors but I'd be happy to hear from anyone. I have a customer, Nashville Metropolitan Government, for whom I have provided flea market reservation/registration and buiding event rental software. (UniVerse.) I am a 1 man shop. I look both ways before I cross the street and so far its worked out. But the issue of continuation of development and support has come up for a second time; along with it the nature of my character based software and some reactions to UviVerse as a product. This is an email from the assistant director of the Nashville fairgrounds: Subject: ITS Help Selecting New Software Importance: High Our Flea Market and Corporate Sales components have been utilizing proprietary software that is ancient, and without documentation for many years. It has not been supported by ITS, and there is only one known person in the Tennessee area that can serviced this software. With the upgrade to Windows 7, it will not operate. Obviously, we need to purchase a package that will provide the functionality we need and that can be supported by ITS. I am requesting a meeting, with the appropriate ITS staff at the earliest possible time; to identify our needs and possible software packages that can be installed. He is incorrect in most of his conclusions, but this is his perception. I have left behind a number of great systems that are now defunct because management viewed them as ancient. Does anyone else meet this attitude? My customer defended the system with the following email. Ken Who said our software was ancient? It is not, it aids in insuring the revenue stream for both Flea Market and Facility Rental, you are correct that the software is serviced by one individual since he wrote the program, his name is Dale Kelley and he has other members on his team that know the software in the event something happens to him. As far as the upgrade to Windows 7 who said that it will not operate? This is certainly not the case, the software can be updated to run with minimal effort. You can contact Dale Kelley if you like, I have copied him on this e-mail. Thank you for your time Deborah Deborah's defense included a small lie about the members of my team; I'm it. This system is written entirely in BASIC; no procs, no scripts. I always have the source code on the system; it's theirs to use as they wish. I would be happy to provide it for review. My question: is there anyone who would have any interest in taking over this and another government customer if I should become defunct or inoperable? I know there are some great people in Tennessee, but these guys could be supported from anywhere. I would also appreciate any advice on products and time required to mouse up the screens and present non-ancient images. I intend to arrenge a meeting with the Assistant Director to attempt to address his concerns and see if I can sell some services. Dale -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Dump-truck-backup-tp42827.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ 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
Re: [U2] UniVerse Dictionary question
Well, I'll be a son of a biscuit eater! I never knew that. I've done it the same way Martin does for 35 years. I just checked it in Jbase and it works. You learn something new every day. Of course, I consider a day a total waste if I don't either learn something new or catch hell about something. As you can guess, I don't have many wasted days. Thanks, Dan! Charlie Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 02-05-2014 6:15 PM, Daniel McGrath wrote: A tip my original mentor taught me on the first day was that in ED/AE, the back tick (`) gets treated as an empty line so you can keep going in insert mode and not need to worry about it. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: Wednesday, February 05, 2014 5:07 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question The dots were just there to keep the numbered list going, The same I use dots in the Editor to enter blank lines. Later I go to the top and do R/.//50 to remove the dot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 04, 2014 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Dictionary question What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ 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 ___ 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
Re: [U2] Logging program execution in Unidata?
Ian, You said you didn't have a wrapper program. How do your programs get executed? Charlie On 01-06-2014 7:23 PM, Baakkonen, Rodney A (Rod) 46K wrote: What we did was have a cron run every 10 minutes that executed a Unidata program. The Unidata program did a PCPERFORM sbcsprogs to capture everything that was running out of the global catalog. It parses up the output of sbcsprogs and builds a Unidata file. This file has the program name as the key and the following attributes: DR DoctoR (Display Record) File: CBH.PROGRAM.TRACKING ATB ATB Name Conv Value Item: CLM101 1 Last Update D2/01/06/14 2 First RecordedD2/11/16/00 3 No of Times Captured 4254 End of Defined Attributes If something consistently runs and finshes within 10 minutes, it will never be recorded. You could have the threshold set to whatever you want. But we thought 10 minutes was good enough for our usage. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, January 06, 2014 7:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Logging program execution in Unidata? I believe there is something wrong with this suggestions. IIRC you don't get the time and date it was last RUN, only the date it was last Accessed. I suspect this is the touch date, which could mean that just looking at it in a directory scan, touches it. Along with a host of other things that don't actually *run* the code. So it wouldn't answer the Q as to whether it's actively executed. You also get the number of times is has run since being catalogued, which always seemed to be an odd choice for me. It may have been run a thousand times, but not run at all in the past ten years. But if I ruled the world, things would be different. Not better just different. Anyway, let us know how it works for your purpose. -Original Message- From: McGowan, Ian james.mcgo...@bankofthewest.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Jan 6, 2014 4:55 pm Subject: Re: [U2] Logging program execution in Unidata? Larry/Wol, thanks for this. Trying it now on a dev server. Not sure how I've missed this all these years, but glad to learn something new! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of lar...@wcs-corp.com Sent: Monday, January 06, 2014 4:44 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? MAKE.MAP.FILE We catalog all our programs - locally (so they end up in CTLG in the current account) for programs specific to a particular account, as well as globally (so there is a pointer in CTLGTB) for generic programs. Unfortunately, unidata seems to have _MAP_ file in $UDTHOME/sys/_MAP_ (as well as a MAP command) but at least for us it's not populated. Thanks for the suggestion, Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Monday, January 06, 2014 4:13 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? Ian, In universe the map file contains the most recent execution date for cataloged programs. Programs that are just RUN I don't know of any way. Dale On 01/06/2014 06:08 PM, McGowan, Ian wrote: We're looking into a major conversion late this year, which will involve checking out several thousand programs (mostly opens, reads or writes). Some programs are run many times a day, whereas some were throwaway and haven't been touched in years. It would be great to get some sense of which ones are active. We unfortunately don't have a wrapper program, wondering if anyone has run into this before - is it possible to somehow log when a program is executed in Unidata? Any magic triggers, directory flags or other audit flags that can get turned on? Any ideas gratefully received, Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ 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 ___ U2-Users
Re: [U2] [Very OT] XP File Dialog Box
It may be basic troubleshooting, but it was a good catch. I hadn't considered that when I posted. This has gone on through 3 mice, though, 1 Logitech and 2 different Microsoft. I really doubt that's the problem. One never knows, though. I've seen stranger things. Troubleshooting is a rare skill, and you obviously have it, Milt. Thanks, Charlie On 12-13-2013 6:55 PM, Milt Sommers wrote: Charlie, This is a rather basic troubleshooting question, but I'll post it anyway: have you tried a different mouse? From: rfrai...@utahmed.com To: u2-users@listserver.u2ug.org Date: Fri, 13 Dec 2013 04:27:30 -0700 Subject: Re: [U2] [Very OT] XP File Dialog Box Well I'm in australia this week installing a windows server 2012, exchange 2013 network with windows 8 workstaions, scripts piles of patches and a secure vpn tunnel to Utah for Unidata accessto their database. Every thing is upside down Robert - Original Message - From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Friday, December 13, 2013 3:09 AM Subject: Re: [U2] [Very OT] XP File Dialog Box Windows 8 is great. You don't have to have the tiles, just use desktop mode, tis the same as windows 7 but better. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 12 December 2013 20:17 To: U2 Users List Subject: Re: [U2] [Very OT] XP File Dialog Box Windows 8 suks Anyone give any good points that makes Windows 8 worthwhile? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, December 12, 2013 3:13 PM To: U2 Users List Subject: Re: [U2] [Very OT] XP File Dialog Box If you plan to go to Windows 7, you better move fast. Microsoft announced that the company discontinued the distribution of retail copies of Windows 7 at the end of October 2013. Microsoft had previously listed that date as October 31, 2014, but changed that information. http://www.foxnews.com/tech/2013/12/10/microsoft-ends-windows-7-retail-sales -directs-consumers-to-windows-8/ JRI ___ 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 ___ 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] [Very OT] XP File Dialog Box
I realize this is an unusual place to post this request, but it's driving me crazy and I'm hoping someone here can help. Just about every time I use the XP file dialog box to open or save a file, it scrolls multiple times when I click in the horizontal scroll bar. Has anyone seen this behavior and know what to do about it? Thanks, Charlie Noah Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Very OT] XP File Dialog Box
Pretty much anything I do in Win XP, in a browser and any other program which uses the file dialog box. On 12-12-2013 1:43 PM, George Gallen wrote: Do you mean when you browse for a file from HTML using Windows XP? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, December 12, 2013 2:39 PM To: U2 Users List Subject: [U2] [Very OT] XP File Dialog Box I realize this is an unusual place to post this request, but it's driving me crazy and I'm hoping someone here can help. Just about every time I use the XP file dialog box to open or save a file, it scrolls multiple times when I click in the horizontal scroll bar. Has anyone seen this behavior and know what to do about it? Thanks, Charlie Noah Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ 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
Re: [U2] [Very OT] XP File Dialog Box
I use Firefox, but it happens in all browsers. It also happens in programs like Adobe PDF reader, Foxit PDF reader, Open Office, Notepad, Notepad++, etc. None of these have anything to do with a browser, so I'm pretty sure it isn't browser related. I also know that XP is very outdated, but I won't be moving to Win7 until next year. Thanks, Charlie On 12-12-2013 1:57 PM, George Gallen wrote: Does it happen in all browsers? Or just IE and which version of IE are you using? If your using IE10 or IE11, have you tried to run it in compatibility mode? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, December 12, 2013 2:50 PM To: U2 Users List Subject: Re: [U2] [Very OT] XP File Dialog Box Pretty much anything I do in Win XP, in a browser and any other program which uses the file dialog box. On 12-12-2013 1:43 PM, George Gallen wrote: Do you mean when you browse for a file from HTML using Windows XP? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, December 12, 2013 2:39 PM To: U2 Users List Subject: [U2] [Very OT] XP File Dialog Box I realize this is an unusual place to post this request, but it's driving me crazy and I'm hoping someone here can help. Just about every time I use the XP file dialog box to open or save a file, it scrolls multiple times when I click in the horizontal scroll bar. Has anyone seen this behavior and know what to do about it? Thanks, Charlie Noah Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ 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 ___ 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
Re: [U2] [Very OT] XP File Dialog Box
+1 On 12-12-2013 2:17 PM, George Gallen wrote: Windows 8 suks Anyone give any good points that makes Windows 8 worthwhile? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, December 12, 2013 3:13 PM To: U2 Users List Subject: Re: [U2] [Very OT] XP File Dialog Box If you plan to go to Windows 7, you better move fast. Microsoft announced that the company discontinued the distribution of retail copies of Windows 7 at the end of October 2013. Microsoft had previously listed that date as October 31, 2014, but changed that information. http://www.foxnews.com/tech/2013/12/10/microsoft-ends-windows-7-retail-sales-directs-consumers-to-windows-8/ JRI ___ 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
Re: [U2] [Very OT] XP File Dialog Box
I'm clicking on the white portion of the bar to the right of the pointer. It happens when I click the arrow on the far right, too. It shouldn't skip columns if I click only once, should it? There are usually quite a few files. I haven't tested with about 3 screens worth. Maybe that will give me some clues. On 12-12-2013 2:16 PM, George Gallen wrote: Are you actually clicking on the scroll bar itself, or in the white area to left or right of it? If you have a lot of files in the directory, and you say click in the white to right of the scroll bar, It should display the bottom of the directory, and top of the directory for the left side. Maybe this is just the box skipping columns until it can display the last column? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, December 12, 2013 3:09 PM To: U2 Users List Subject: Re: [U2] [Very OT] XP File Dialog Box I use Firefox, but it happens in all browsers. It also happens in programs like Adobe PDF reader, Foxit PDF reader, Open Office, Notepad, Notepad++, etc. None of these have anything to do with a browser, so I'm pretty sure it isn't browser related. I also know that XP is very outdated, but I won't be moving to Win7 until next year. Thanks, Charlie On 12-12-2013 1:57 PM, George Gallen wrote: Does it happen in all browsers? Or just IE and which version of IE are you using? If your using IE10 or IE11, have you tried to run it in compatibility mode? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, December 12, 2013 2:50 PM To: U2 Users List Subject: Re: [U2] [Very OT] XP File Dialog Box Pretty much anything I do in Win XP, in a browser and any other program which uses the file dialog box. On 12-12-2013 1:43 PM, George Gallen wrote: Do you mean when you browse for a file from HTML using Windows XP? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, December 12, 2013 2:39 PM To: U2 Users List Subject: [U2] [Very OT] XP File Dialog Box I realize this is an unusual place to post this request, but it's driving me crazy and I'm hoping someone here can help. Just about every time I use the XP file dialog box to open or save a file, it scrolls multiple times when I click in the horizontal scroll bar. Has anyone seen this behavior and know what to do about it? Thanks, Charlie Noah Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ 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 ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Support Ticket Software
Thanks for the link, Larry. It appears that's the right company. Their sales people couldn't answer my question and referred me to tech support. After going through their telephone hell I sat on hold about 45 minutes and gave up. From their forums it appears that the originator of a ticket can be given permissions to view or edit tickets, but doesn't have to be. I don't know if I can persuade BC to do it, though. Charlie On 10-23-2013 12:19 PM, Larry Hiscock wrote: http://www.salesforce.com/remedyforce/features/ Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Wednesday, October 23, 2013 8:47 AM To: U2 Users List Subject: Re: [U2] [OT] Support Ticket Software Hi Symeon, I had looked at salesforce and it wasn't really intuitive that they had a support ticket system. I think they are the one, though. The reason I was curious is that BigCommerce said that under the new system they sprung on us unannounced over the weekend, we could enter support tickets, but not look up or view tickets we'd submitted. I thought that was rather strange. I've never used a system before where I couldn't view my tickets. The old system they used allowed viewing of tickets, and responding either via email or online. It's just one more capability BC has taken away - and to think I moved away from Intuit for doing that very same thing... Thanks, Charlie On 10-23-2013 2:14 AM, Symeon Breen wrote: The secure server at force.com , e.g. secure.force.com ? which would be salesforce - and they do have ticketing software -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: 23 October 2013 03:55 To: U2 Users List Subject: [U2] [OT] Support Ticket Software My online store platform has switched to a new support ticket system called secure.force, but I can't find any info on the company that markets it, and of course, my provider won't tell me anything about it. Has anyone seen or know anything about it? Thanks, Charlie Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ 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 ___ 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
Re: [U2] [OT] Support Ticket Software
Hi Symeon, I had looked at salesforce and it wasn't really intuitive that they had a support ticket system. I think they are the one, though. The reason I was curious is that BigCommerce said that under the new system they sprung on us unannounced over the weekend, we could enter support tickets, but not look up or view tickets we'd submitted. I thought that was rather strange. I've never used a system before where I couldn't view my tickets. The old system they used allowed viewing of tickets, and responding either via email or online. It's just one more capability BC has taken away - and to think I moved away from Intuit for doing that very same thing... Thanks, Charlie On 10-23-2013 2:14 AM, Symeon Breen wrote: The secure server at force.com , e.g. secure.force.com ? which would be salesforce - and they do have ticketing software -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: 23 October 2013 03:55 To: U2 Users List Subject: [U2] [OT] Support Ticket Software My online store platform has switched to a new support ticket system called secure.force, but I can't find any info on the company that markets it, and of course, my provider won't tell me anything about it. Has anyone seen or know anything about it? Thanks, Charlie Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ 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
[U2] [OT] Support Ticket Software
My online store platform has switched to a new support ticket system called secure.force, but I can't find any info on the company that markets it, and of course, my provider won't tell me anything about it. Has anyone seen or know anything about it? Thanks, Charlie Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Interview Questions
One thing I learned the hard way - if an applicant takes a scheduled phone interview while shopping at Walmart, don't hire that person! His or her attitude toward you and your company becomes evident. Charlie On 10-08-2013 6:29 AM, Doug Chanco wrote: Sorty kevin I misread your question and missed the technical qyestions aside part ... My favorite non technical questions were: Why should we hire you in 5 sentences or less Explain to me a strength you bring and why you think its a strength Whats a weakness you have and how do you plan to address it Tell me about a typical day at work(current or previous job) Why do you want this job Describe to me your previous or current boss Tell me 3 things you like to do for fun and why Do you dislike working extra hours and why Pretend your me (interviewer) give and answer 3 questions you would ask in helping you fill the position Dougc Sent via the Samsung Galaxy Mega™, an ATT 4G LTE smartphone Original message From: Doug Chanco d...@chancofamily.com Date:10/08/2013 00:28 (GMT-05:00) To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] [OT] Interview Questions Questions I have been asked (and my favorites) Tell me a solution to get the last day of a given month (pick) Now give me the same solution in another language Whats an object and give me an example Whats your favorite shell and why? Whats a netmask and default gateway Whats one tech you do not know but would like to learn and why? Why use stored procedures? What does oconv mcp do? Favorite version of unix and why? Cannot access server x (network) walk me through what steps you would do to figure out the issue What are some commands you use in the pick debugger Favorite version of pick and why? What are sone ways for non pick programs to communicate with a pick system (Follow up) Which one do you prefer and why? I know sone of these are not pick related but they are my favorite questions asked me in various interviews and (in my humble opinion) the days of just a pick programmer are slowly going away companies (again IMHO) are looking for more than just knowing pick basic Anyway here is my contribution feel free to use all/none or any combination in between and good luck in your hiring Dougc Sent via the Samsung Galaxy Mega™, an ATT 4G LTE smartphone Original message From: Kevin King ke...@precisonline.com Date:10/07/2013 22:35 (GMT-05:00) To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] [OT] Interview Questions This is not specifically a job posting, but I do have ads up on Monster and LinkedIn looking for talent. At the risk of confessing too much, I have historically been far too easy in the interview process. As a result, I have had some less-than-excellent hires and spent far too much time and money trying to rescue underperforming and/or recalcitrant staff. Therefore, I'm planning to be much more discriminating this time around, and am building a series of technical questions to help quickly identify those that have the right skills, abilities, and attitude for our team compared to those who may not. That being said, I have a question for the group: Technical questions aside, what are the best interview questions you've asked, been asked, or otherwise heard about that help differentiate between the candidates worthy of additional consideration vs. those that are not? Each company is different of course, but that aside I'm hoping to get some ideas to cut to the heart of the matter as quickly and efficiently as possible, both for the sake of the interviewer and the interviewee. (My technical interview is bordering on 200 questions and growing at an alarming pace.) If there were a half dozen questions to open with that could help set the stage for what may be to come, that could be very beneficial for everyone in this mix. Also, in an effort to keep the OT to a minimum, please don't ask me questions about the positions here. If you have questions, email me directly or through LinkedIn. I'd prefer to keep this topic on point of your recommended interview questions. ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Interview Questions
Hi Marc, I don't suppose you have a copy of that program you'd be willing to share? Charlie On 10-08-2013 10:10 AM, Rutherford, Marc wrote: My all-time best interview was 20 years ago at FigiGraphics in San Diego. I was given a (Basic) program I was told had 12 known bugs in it. I was given twenty minutes to find and fix them. Some were trivial, but annoying to debug none the less. Others were more subtle, and several involved mutual interactions. The group of them did provide enough coverage so as to demonstrate if you had a broad Basic knowledge plus debug/code skills. Also I was seated at work station with a keyboard that had a bad key. Part of the test was to see how long I would go before I complained. Of course the lost time came out of my twenty minute allotment :-) I am surprised that in my entire career this was the only time I had ever been given a hands-on 'performance test' by a hiring company. And how many times have I been assigned by my company to an interview panel where we would pick someone who 'interviewed well' - only for them to go down in flames later on... Marc Rutherford Principal Programmer/Analyst Advanced Bionics LLC 661 362-1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 07, 2013 7:36 PM To: U2 Users List Subject: [U2] [OT] Interview Questions This is not specifically a job posting, but I do have ads up on Monster and LinkedIn looking for talent. At the risk of confessing too much, I have historically been far too easy in the interview process. As a result, I have had some less-than-excellent hires and spent far too much time and money trying to rescue underperforming and/or recalcitrant staff. Therefore, I'm planning to be much more discriminating this time around, and am building a series of technical questions to help quickly identify those that have the right skills, abilities, and attitude for our team compared to those who may not. That being said, I have a question for the group: Technical questions aside, what are the best interview questions you've asked, been asked, or otherwise heard about that help differentiate between the candidates worthy of additional consideration vs. those that are not? Each company is different of course, but that aside I'm hoping to get some ideas to cut to the heart of the matter as quickly and efficiently as possible, both for the sake of the interviewer and the interviewee. (My technical interview is bordering on 200 questions and growing at an alarming pace.) If there were a half dozen questions to open with that could help set the stage for what may be to come, that could be very beneficial for everyone in this mix. Also, in an effort to keep the OT to a minimum, please don't ask me questions about the positions here. If you have questions, email me directly or through LinkedIn. I'd prefer to keep this topic on point of your recommended interview questions. ___ 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
Re: [U2] [UD] BASIC Code Failing
Tony, I think Bob may have a good troubleshooting technique here. It would be simple to eliminate causes. Line 107 has a couple of potential problems: 0107: SUPREC = INSERT(SUPREC,2,1,0,POLREC6) I have seen these 3 situations in more than 1 MV implementation/flavor - 1. If POLREC6 is null, an empty value won't be inserted, throwing associated values out of sync. Fix by prefixing or suffixing POLREC6 with a character that won't be in the data, then converting it out later. 2. INSERT sometimes doesn't like delimited source. Fix by moving POLREC6 to a variable and inserting that. 3. If POLREC6 has multivalues itself, that presents a whole different problem. Check it first. All these things can be checked in a little test program in just a few minutes, and a safer coding technique used. Charlie If this occasional problem is consistently the same lines then just validate the insert afterwards: 0106.1 MV.CNT = DCOUNT(SUPREC2,@VM) 0107: SUPREC = INSERT(SUPREC,2,1,0,POLREC6) 0107.1 IF SUPREC2,1 NE POLREC6 THEN 0107.2MV.CNT2 = DCOUNT(SUPREC2,@VM) 0107.3IF MV.CNT = MV.CNT2 THEN GOSUB REPORT.ERROR 0107.4 END With this logic, you're verifying the value and that a new value is, in fact, being created in the attribute. You may want to tweak the logic a bit to match your exact specifics, like if POLREC6 is a non-null value, but this should give you an idea. Tiny Bear's Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 07-26-2013 12:13 PM, Tony Gravagno wrote: From: Woodward, Bob If this occasional problem is consistently the same lines then just validate the insert afterwards... Dale, don't accept that solution. (Sorry Bob) Note, we're still not really Sure yet that this is a good definition of the problem, just a working theory... Overall, the problem seems to be that some statements can't be trusted to be executed - not specific statements or functions, but random lines of code in different systems. The problem might not be something wrong with the statements themselves but just where they happen to be in the program. The issues might be fixed with some extra code, or by putting the few lines in question into an internal subroutine just to move the bytecode to a different location. But a solution like that is random and subject to just moving the problem to an as yet unknown and perhaps more critical location. When you can't trust a line of code to be executed in a linear series of statements the reliability of everything we do comes into question. If this is indeed the problem, fixing it by writing work around code isn't good for anyone here. It's tough to call in Support when the problem is so vaguely defined but having sat in the chair as a QA Manager and Product Manager for a related product, I can tell you the resolution starts with finding sites that seem to have this issue, assigning someone to the task of gathering data and scheduling tests on the target systems, getting engineers to verify the issue, and establishing a pattern from which a problem can be diagnosed. I don't know who has to initiate that with Rocket Software but I'd assume it starts with paying clients filing formal requests with Support and committing to follow-through toward a resolution. And while re-compilation might indeed be the correct fix, don't accept a tier-1 techie solution intended to just get you off the phone! HTH 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
Re: [U2] Unbelievable or Believable you decide [ad]
Doug, It might be more believable if you checked your spelling, grammar and sentence structure before posting. Just saying... Charlie Noah On 07-12-2013 10:02 AM, Doug Averch wrote: Our competitor, who shall be nameless in this post, has only changed their version number in last 9 months. We have added features and more features in the last two week than we ever thought we could. 1. XLr8Dictionary Editor - Ability to create indexes - Ability to delete indexes - Ability to build indexes - Ability to save your dictionary file to a tab delimited file which then you can print in Excel - You can added edit dictionaries that begin with CON. 2. XLr8Editor - Content Assist (Control-space) is loaded with UniBasic commands for Unidata only. (Universe in a few weeks) - The outline of variables and subroutines can be sorted alphabetically either ascending or decending Thanks again to our team who keep pushing the boundaries of what can be done in weeks that use to take us months. Regards, Doug www.u2logic.com XLr8 tools for Universe and Unidata ___ 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
Re: [U2] Who was Infinitivity?
Back in the old days, wasn't Sierra Bravo, or at least Luke, involved in MV development? They don't seem so have any MV involvement at all these days. Charlie On 06-17-2013 1:32 PM, Wjhonson wrote: Oh excellent, here we go http://nerdery.com/mentions/35 I had written an article on Luke, so maybe I should revisit that and include this blurb as well. -Original Message- From: Bob Little b...@marketamerica.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Jun 17, 2013 6:53 am Subject: Re: [U2] Who was Infinitivity? I don't know about Infinitivity but I've heard of Infinetivity which was previously named Southwest Data Systems. bob little independent contractor market america, inc. 1302 pleasant ridge rd. greensboro, nc 27409 Phone: 336-698-4367 Cell: 248-675-5515 Skype: boblittle904 From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Wjhonson [wjhon...@aol.com] Sent: Thursday, June 13, 2013 12:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] Who was Infinitivity? Seeing in another thread the name BlueFinity reminded me of an old unresolved question. Many years ago (ten? eight?) I got a brochure from an outfit called Infinitivity, and they were hocking a web-to-Pick connection tool. When I try to find details today about that outfit I can't. Anyone have a bit of history about this company ? ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Record Sampling for File Sizing Diagnostics
Hi Perry, Does UV support SAMPLED? If so, use: SELECT file SAMPLE 300 SAMPLED where is the number of records to skip between sample IDs picked up. If it doesn't, you're probably going to have to write a little program. Regards, Charlie Tiny Bear's Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 06-11-2013 11:01 AM, Perry Taylor wrote: I have several *very* large files on which I need to perform some file sizing diagnostics. Rather than repeatedly running HASH.AID against these files is there a good way to sample say 2-3 million records to copy into a test file? SAMPLE will only grab the first n records in hash order and I'm thinking that would not necessarily be a good representative sample of the file's contents. Am I up in the night thinking this is the case? Is there a better way to get a good sample of records for this purpose? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ 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
Re: [U2] [UV] Record Sampling for File Sizing Diagnostics
I probably hit Send within milliseconds of you. :-) Charlie On 06-11-2013 11:15 AM, Charles Stevenson wrote: SAMPLED keyword with a D on the end will go thru the entire file. SAMPLED 1000 will get every thousandth record as it reads through the file. SAMPLED 1000 SAMPLE 2000 will do the same, but then stop after it builds a list of 2000. That is, after it's read thru the 1st 2 million keys. On Tue, Jun 11, 2013 at 11:01 AM, Perry Taylor perry.tay...@zirmed.comwrote: I have several *very* large files on which I need to perform some file sizing diagnostics. Rather than repeatedly running HASH.AID against these files is there a good way to sample say 2-3 million records to copy into a test file? SAMPLE will only grab the first n records in hash order and I'm thinking that would not necessarily be a good representative sample of the file's contents. Am I up in the night thinking this is the case? Is there a better way to get a good sample of records for this purpose? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ 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
Re: [U2] Signature Capture and use
Hi Robert, Try this: http://nebula-rnd.com/blog/tech/2009/09/signatures01.html . I found it with a simple search for signature on Tony's site. Regards, Charlie On 06-06-2013 4:52 PM, Robert Frailey wrote: Link doesnt work http://nebula-rnd.com/blog/2009/09/signatures01.html - Original Message - From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Sent: Thursday, June 06, 2013 2:52 PM Subject: Re: [U2] Signature Capture and use Harold, I created a general-purpose solution for this a few years ago, documented on my blog. I'd be very happy to discuss it with you next week. (out of the office this week) http://nebula-rnd.com/blog/2009/09/signatures01.html Harold.Oaks wrote: I'm sure some of you are implementing signature pad capture to a Universe system. What are you using and doing? I'd like to look into adding that feature to our jail system. -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. ___ 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
Re: [U2] UniData PreStore to change the KEY of a record?
Another excellent suggestion, Mecki, especially if one isn't familiar with paragraphs. I tend to use them a lot for one-offs because I've used them a lot over the years, and am very comfortable with them, but a Basic program would be just as easy. More than once I've built a paragraph to do a job for a user, only to have them scope creep me into writing a program anyway. Charlie On 05-29-2013 2:25 AM, Mecki Foerthmann wrote: To stay with the picture of not using a hammer to drive in a screw, I would just write a Basic program to do this. Use the right tool for the job! Open the file Execute GET-LIST Then a loop that generates the new Ids including checking that it doesn't already exist, READU record from old Id, WRITE record to new ID, DELETE old record. A few lines of code written in less than a minute. Compile, generate list, run program, job done! On 28/05/2013 21:59, Charlie Noah wrote: Dang, David, you beat me to it. ;^) I was just going to suggest the same thing. Just because the OP wanted to use ED (a hammer) to drive in a screw doesn't mean that it is the best tool ( a screwdriver). Good answer. Charlie Noah On 05-28-2013 3:42 PM, David A. Green wrote: I would take my saved list and copy it to a text editor then using copy commands and a quick macro convert the list into a bunch of COPY FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and then execute it. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, May 28, 2013 10:48 AM To: 'U2 Users List' Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ 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 ___ 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
Re: [U2] UniData PreStore to change the KEY of a record?
Dang, David, you beat me to it. ;^) I was just going to suggest the same thing. Just because the OP wanted to use ED (a hammer) to drive in a screw doesn't mean that it is the best tool ( a screwdriver). Good answer. Charlie Noah On 05-28-2013 3:42 PM, David A. Green wrote: I would take my saved list and copy it to a text editor then using copy commands and a quick macro convert the list into a bunch of COPY FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and then execute it. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, May 28, 2013 10:48 AM To: 'U2 Users List' Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ 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
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
NUM() will validate '' (null string) as numeric, and I believe some implementations would validate '.' (decimal point) as numeric, although the version of Jbase I'm on, running Universe emulation, does not. Charlie On 05-08-2013 8:39 AM, George Gallen wrote: The only thing I could think of is it could validate it as being a number, but then So would NUM(). George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Wednesday, May 08, 2013 9:37 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. George, After sending it I thought, Well,... that OCONV acomplishes nothing! Dale On 05/08/2013 08:32 AM, George Gallen wrote: What purpose will the OCONV(var,MD0) serve? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Wjhonsonwjhonsonat aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
VAR 0 rounds to a whole number just as OCONV(VAR, 'MD0') does. If you want to drive the next programmer who comes along absolutely nuts, you could use that. ;) Charlie On 05-08-2013 8:45 AM, George Gallen wrote: Yes, it would do that. Have to keep that one in mind, instead of the old INT(#+.5) if going to a whole number -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Wednesday, May 08, 2013 9:40 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. It doesn't do nothing - it rounds - if the input value is 55.5 you get 56 as output. It only does nothing if your input is a whole number.; -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Wednesday, May 08, 2013 9:37 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. George, After sending it I thought, Well,... that OCONV acomplishes nothing! Dale On 05/08/2013 08:32 AM, George Gallen wrote: What purpose will the OCONV(var,MD0) serve? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale ___ 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
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
I normally use VAR MATCHES '1N0N]1N0N.1N0N' where ] is a value mark. Different strokes, I guess. There are many ways to skin a cat, but no matter which one you use, the cat ain't gonna like it. Charlie On 05-08-2013 9:38 AM, George Gallen wrote: I Usually use NUM(xx) and xx# to combat that one. Never really thought about . - I would think that would be treated as 0.0 in any calculations? Guess I'll have to test that one out... George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Wednesday, May 08, 2013 10:34 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. NUM() will validate '' (null string) as numeric, and I believe some implementations would validate '.' (decimal point) as numeric, although the version of Jbase I'm on, running Universe emulation, does not. Charlie On 05-08-2013 8:39 AM, George Gallen wrote: The only thing I could think of is it could validate it as being a number, but then So would NUM(). George ___ 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
Re: [U2] FYI off topic
Hi Robert, Are you talking about LCD monitors or LCD/plasma TVs? Charlie On 05-07-2013 4:05 PM, Robert Frailey wrote: Dont throw away those flat screens when they die. I fixed one today, 30 minutes and 5 capacitors on the output power supply. They seem to be made with under rated caps. So far since last year i've fixed 9 flat screen monitors, all capacitors in the output power supply. I've change the caps but up'd the rated voltage on each so if it 470uf 10v, i put in a 470uf at 25v. Easier than fixing tube monitors, takes about 30 minutes. Nice side job in the future, everyone will have a couple. Robert ___ 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
Re: [U2] Date conversion..
Hi Tony, It looks like development on NebulaXLite only goes to 2009. Does it work with Jbase 3.4 on XP (32 bit)? I looked on your site and in the FAQ, but it didn't really tell me. Thanks, Charlie On 03-22-2013 11:15 AM, Tony Gravagno wrote: From: Sathya Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. The problem isn't with MV. When you say spreadsheet people here imply Excel, and I'm guessing that's what you mean too. What most people do is they generate a CSV file with no formatting and then expect Excel to format it in specific ways. The simple answer is, if you just want text in Excel, put a single quote before the value: 123, abc, '3/22/2013 You can also force it to text like this using a formula: =3/22 The immediate response might be but I want a Date column. OK, but you're not doing anything to tell Excel that the column itself should use date formatting. [AD] This is exactly the reason why I created NebulaXLite. It gives you any kind of real Excel formatting of your choice for any cell, column, or row. With nothing but BASIC, you can: - use set fonts, colors, text rotation, and borders, - set column widths and row heights - merge cells, use hyperlinks, add comments to cells - set document properties, add multiple worksheets in a workbook - and documents open in Google Docs and OpenOffice Compare all of that (and yes, much more) to plain old delimited text. Lots of companies here use NebulaXLite. It's free for developers and only a one-time purchase price of $200 for production end-user systems. Support and enhancements are free. http://Nebula-RnD.com/products/xlite.htm [/AD] HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ 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
Re: [U2] Date conversion..
Also with less problems with double quotes. Charlie On 03-22-2013 11:26 AM, Israel, John R. wrote: I would suggest tab-delimited instead of csv, then give the file an xls extension. This usually pulls up the fat with much fewer mouse clicks. John Israel Sent from my iPhone On Mar 22, 2013, at 12:17 PM, Tony Gravagno 3xk547...@sneakemail.com wrote: From: Sathya Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. The problem isn't with MV. When you say spreadsheet people here imply Excel, and I'm guessing that's what you mean too. What most people do is they generate a CSV file with no formatting and then expect Excel to format it in specific ways. The simple answer is, if you just want text in Excel, put a single quote before the value: 123, abc, '3/22/2013 You can also force it to text like this using a formula: =3/22 The immediate response might be but I want a Date column. OK, but you're not doing anything to tell Excel that the column itself should use date formatting. [AD] This is exactly the reason why I created NebulaXLite. It gives you any kind of real Excel formatting of your choice for any cell, column, or row. With nothing but BASIC, you can: - use set fonts, colors, text rotation, and borders, - set column widths and row heights - merge cells, use hyperlinks, add comments to cells - set document properties, add multiple worksheets in a workbook - and documents open in Google Docs and OpenOffice Compare all of that (and yes, much more) to plain old delimited text. Lots of companies here use NebulaXLite. It's free for developers and only a one-time purchase price of $200 for production end-user systems. Support and enhancements are free. http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyDBdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjX3T3f09HAyNzI0oIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkql9QlJ9SmlxSrF-Rk1mSqpdRkssAAQDL-yocZ [/AD] HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyDBdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjX3T3f09HAyNzI0oIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkqp-Uk5_OAAEAelMkgAZ Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ 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
Re: [U2] Social Networks for MV
I don't want to offend my friend Tony, but I have to agree with Bob. I don't trust anything I see on Facebook, and I won't even look at Twitter. The only reason I'm on Facebook at all is to keep in touch with family and friends, and to promote my store a little. I don't do as much of that as people think I should, but I simply don't have the time or inclination to become a Facebook junkie. Sorry, Tony. Charlie Tiny Bear's Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 03-15-2013 8:33 PM, Bob Wyatt wrote: Tony, I read the blog, but remain unmoved. I think that embracing social media weakens/dilutes/reduces the focus of the brand. If the purpose is to promote Bob Wyatt or Tony Gravagno, use social media to the fullest extent you desire. If the purpose of your web presence is to promote the brand (Nebula Research or Ashwood Computer, Inc. (my employer)), there should be as few web locations as possible. Whomever is doing the searching is interested in authoritative/reliable information - finding the information on facebook, twitter, and the like, I hope, will never ever be regarded as authoritative or reliable (in my opinion). If I want to know what Nebula Research can do for me, facebook and twitter are not on by radar as possible destinations to find out. I'm not inclined to go there even for references - I would get references from Nebula Research, not what followers of Tony (or Nebula Research) had to say on facebook or twitter. I even find the technical questions being asked (and answered) on LinkedIn as being in bad form. That isn't what LinkedIn is for. It is a narrow view, and I realize that it may not be a popular one. I'm in front of a computer more than 10 hours a day, and when I need information, I need authoritative/reliable information. And, of course, Twitter and facebook can be a huge time-vacuum - lots of time and little reward. All of the above is my personal opinion, and does not necessarily reflect the opinion of my employer... Bob Wyatt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, March 15, 2013 6:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Social Networks for MV I'm on a mini campaign to make more MV colleagues aware of the benefits of using Twitter and other social media. Everyone is welcome to visit my blog on the topic and to comment here or there. http://Nebula-RnD.com/blog/tech/mv/2013/03/socialmv1.html Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ 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
Re: [U2] [UV] User Exits was: ISO Date Format
Can do on Jbase as well. Everybody else - catch up! :-) Charlie On 03-11-2013 11:30 AM, Charles Stevenson wrote: You can do user exits on UniVerse. I thought User-defined processor codes were standard on MV platforms. For UV they are defined in the UniVerse Guide for Pick Users, Appendix A, User Exit Codes. In the past I've used the technique to create my own uparrow i-conv, o-conv code that mimicks ED's up-arrow mode. I do wish they were a bit more versitile. If I remember my pick assembler user exit coding -- which I don't! -- I think we're shy 4 hex digits of parameters that ought to be able to be passed. Or something like that. cds On 3/11/2013 10:55 AM, Tony Gravagno wrote: It's things like this that make me wish more MV platforms had user-defined processor codes. U2 excels in the versatility here. I can't use wonderful codes like this because most of my code needs to work across platforms. Wah. :'( T From: Charles Stevenson OCONV( 16507 , DYMD[4'',2'',2] ) -- 20130311 ICONV( 20130311, DYMD[4'',2'',2] ) -- 16507 From Brian and Robert: D-YMD[4,2,2] ___ 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
Re: [U2] Record locks (Unidata 7.2)
Perhaps we should apply a little Systems Analysis 101 here - ask some questions. I'm not convinced that the original request completely described the need. What is the logical scenario (batch update, transaction entry, file maintenance, etc.)? Once a lock is removed, do you want your copy of the record to be written regardless of why it was locked in the first place, possibly overwriting someone else's changes? Why do you want to do it this way? I'm sure there are other questions, but these will do for a start. If, as Will suggested, this is a job application test, the OP should answer that more information is needed. Technically, what was described is completely doable, but is it the correct thing to do? Regards, Charlie Noah Tiny Bear's Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 02-07-2013 2:26 AM, Mecki Foerthmann wrote: The READU statement has a LOCKED clause that is true if a record is locked. You can put all your locking ha logic in there. READU record FROM filevariable,itemID THEN code if record exists and isn't locked (optional) LOCKED code to handle locked record condition (optional) END ELSE code if record doesn't exist (required) END Now if you put that into a loop you can display a message and give the user the option to try again or abort. And if you put the code into a subroutine you can use that in all your programs with a single line like this. CALL SR.READU(record,filevariable,ItemID,Option,Err) On 06/02/2013 21:52, Jon Wells wrote: Hi all, I have not looked at the world of record locks since my R83 Pick days. I'm hoping to add the ability for the program I'm working on to: * Check if a record is locked * Wait until the lock is removed * Once the lock is removed, or if the record is not locked: * Lock the record * Perform the WRITE statement I'm hoping someone can share an example of how to accomplish this in UniBasic. Thank you, Jon Wells Campbell University ___ 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
Re: [U2] U2 Test Tools for system/unit regression testing
Come to think of it - I used to get IS, but haven't received one in a long time. I wonder if my subscription got lost. Charlie On 02-05-2013 5:33 AM, Brian Leach wrote: Oh and - If anyone here is subscribed to International Spectrum magazine (and if not, why not?) I'm writing a series on automated testing with the first instalment to appear in the March/April edition. So I'd be interested to hear any user stories ... Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: 05 February 2013 11:14 To: 'U2 Users List' Subject: Re: [U2] U2 Test Tools for system/unit regression testing w/integration with HP QualityCenter Hi David I've recently released a testing product called (predictably!) mvTest. This supports automated testing of U2 applications using a dedicated scripting language modelled after UniBasic for familiarity but with a number of key extensions to handle data validation, test data handling, UI scripting and assertions. You can use this to create unit tests, UI tests (currently TELNET and U2-compatible secure TELNET/SSL but with SSH to follow shortly), regression and volume tests. Here's a quick overview of how it works - - You create unit or UI tests using the scripting language. These can be run through either of a Windows client or through a server-side script runner e.g. if you want to perform CI testing through a phantom. There's a nice Windows based editor to create, organize and test these. - The tests return pass or fail information based on assertions, so you can see at a glance if anything has broken. You can save the information and run various reports against it. - The tests can run direct against the database through a UO.NET connection (e.g. for testing subroutine calls and parameters) or through a terminal-style UI. It embeds a complete terminal emulator with all the necessary functions, and this allows you to drive screens, perform spot checks, branch on different results (e.g. handling error messages raised from your screens), handle send/expect style scripting and more complex conditions (such as wait until the cursor is at this location and this message has appeared here). - It keeps a separate shared server connection open while the UI tests run so you can, for example, script an entry screen via the terminal UI that ends up saving some data like a sales order, and then immediately check what has been written to the database through the underlying connection as part of the same script. - Unit tests can be organized into batches in which the tests run in order, so you can set up sequences that match business operations. - Batches can be organized into runs, so you can test whole suites of your application. Each run can be customized, so you can feed in per-site or per-system information. Runs can optionally randomize the order in which batches are executed, and you can set up different run scenarios and iteration patterns. - You can feed in and randomize test data and from the client side runner, access local features as well as the database operations. - Volume testing can take place using the Windows client. This is a multithreaded client supporting multiple concurrent UI sessions - I've tested up to 250 concurrent connections from a single PC running against an SB+ system for one customer last year who needed to stress test their system performance coming up to the New Year sales. This first release is targeting U2 with other MVDBMS to follow. I'm also adding support for GUI testing using the Microsoft Automation APIs and WebUI testing going forward. Anyone interested can contact me for an evaluation version, or download the user guide from www.brianleach.co.uk. Regards Brian ___ 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
Re: [U2] Another job ad written by people who have no clue
If it's multi-line, the compiler doesn't know, and keeps adding code to the ELSE section. DAMHIKT :-) Amen to your last statement! Charlie On 12-09-2012 11:38 AM, Wjhonson wrote: For a single line. I don't understand how an IF would know, for multiple lines, where it's supposed to end. With a semi colon? Horrible. Computer languages should be written for humans to read, not machines. -Original Message- From: u2ug simpson-u...@gerzio.ca To: louiebergsagel louiebergsa...@gmail.com; U2 Users List u2-users@listserver.u2ug.org Sent: Sun, Dec 9, 2012 9:32 am Subject: Re: [U2] Another job ad written by people who have no clue mv basic doesn't require an END to an IF either -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Louie Bergsagel Sent: Sunday, December 09, 2012 3:21 AM To: U2 Users List Subject: Re: [U2] Another job ad written by people who have no clue I'm in my current job because I was willing to learn Python at work and on my own dime. I took a beginner's course in Python at the University of Washington because I didn't know much besides Prime Information, Henco's Info, Structure/4, UniVerse, UniData and MITS. It was fun to learn Python as the syntax was so similar to Pick basic. Program controls is through indentation, which we usually use anyway. They even go Pick one better: an IF statement doesn't need an END. They all require one, right, so why not assume it? I love that thinking. Learn some Python. You'll be glad you did. ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Client question
I need one of those, too, Bob. They are out there, but I don't know what the quality is, and the layout usually isn't what I like (large backward L Enter key, backslash/ bar key on the top row). Can't have everything, I guess. :-) Charlie Tiny Bear's Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 12-07-2012 5:15 PM, Woodward, Bob wrote: Ya know, someone needs to come up with a fat keyboard for those of us with fat fingers. smile -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, December 07, 2012 3:09 PM To: U2 Users List Subject: Re: [U2] SB Client question The problem is only for the session that I mistakenly entered the insert key. I can open another session - which I often do - and continue on with my tasks. I was just hoping that there was a keystroke that I could use to reset the default value to the insert key. I try to be careful but sometimes my fat finger will co-hit the backspace and insert key and then the fun begins again. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, December 07, 2012 3:01 PM To: U2 Users List Subject: Re: [U2] SB Client question I would not expect changing terminal type to fix the problem once you've got the problem. Do you have some specific coding or other requirements for the Wyse60? Does the same thing happen if you start a clean session using Wyse50 or Wyse120? I know I'm not helping discover what to do to fix your problem but without a bunch of time and the ability to duplicate the problem the best I can really help with is to try and avoid the problem in the first place. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, December 07, 2012 2:50 PM To: U2 Users List Subject: Re: [U2] SB Client question The terminal emulation is Wyse60. I don't use the insert key when at TCL because I just enter 'I' at the command prompt when I am in the editor and there is never a reason for insert key to be pressed otherwise. I am not sure how to reassign the key but I don't think that I want to do that because I do use the insert key when I am in the full-screen editor or SB+ screen. I went to the Setup tab and changed the terminal type to VT220 and the editor worked like it should but when I changed it back to Wyse60 it had the same old problem. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, December 07, 2012 2:40 PM To: U2 Users List Subject: Re: [U2] SB Client question I've never had this problem but I'd look at the terminal emulation you're using. You might try using a different terminal type then see if you can replicate the problem. I would imagine you don't use the insert key since it seems to mess you up (only at TCL???) so maybe redefine just that key? Good luck. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, December 07, 2012 2:26 PM To: u2-users@listserver.u2ug.org Subject: [U2] SB Client question Hi All, This is a question that has been puzzling me for years and I am finally going to ask if there is help for me. :-) What happens is I will be typing at real TCL (on HP9000 Unix running SB+ 5.2) and I will accidentally hit the 'Insert' key that it just to the right of the 'Backspace' key. Well, after I do this my backspace will no longer work. What I see on the screen when I enter the backspace key is the letters to the left are displayed to the right of the cursor preceded by a space. I can enter the replacement character(s) and they will work but when I look at the line to check it the line will always have: '*--:' appended to the end of the line. It does not matter what I do after this to try to get back to what was working before. (I do plenty of backspacing so this is not a small problem.) The only thing that works is to logoff and then log back on. This will reset the editor to work correctly again. I have tried hitting the 'Insert' key again, thinking that it would switch back to the original mode, to no avail. Has this happened to anyone else? Or am I the only lucky one with this problem? If it has happened to you, do you have another fix besides logging off the system? Thanks in advance, Bruce Lunt ___ 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
Re: [U2] Things you shouldn't do.....
devnull (aka bit bucket)? I can clear the error log in Jbase, both on AIX and Windows, and it still puts new messages in it after I've written the empty record back. No clue why UV would do that. Perhaps it tried to open it and found it locked? SWAG, I know. Charlie On 11-30-2012 10:13 AM, George Gallen wrote: Here's one of those things that I didn't think would be a problem.but alas I was wrong! I have a phantom running, which writes any output to the PH file. I opened the PH record to view if there were any problems, and then deleted all the lines in the file, and 'FI'ed it back. Now I have no clue where the output of the phantom is being written to??? It's still running fine, and I KNOW it's still creating output But it's not going to the PH record anymore, since I mucked with it. Obviously, killing and restarting the phantom will right my wrongs, but I wouldn't have thought gutting the output PH file Would stop it from future writes?? UV 10.0.2 / linux George ___ 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
Re: [U2] Another job ad written by people who have no clue
I do pretty well with a QWERTY keyboard, since I've been using one all my life, starting with an old Underwood typewriter. I don't think I want to try to learn the Dvorak keyboard at this point. I have enough frustrations in my life. :-) Thanks for the tip, though. Actually I did start playing the guitar again after my stroke. I did OK and can strum a little with my right hand, but I certainly won't win any awards. Can you play a guitar with just one hand? Thanks, Charlie On 11-03-2012 5:36 AM, Wols Lists wrote: On 02/11/12 16:31, Charlie Noah wrote: Left handed only, when I used to be right handed? Try and get a left-handed-dvorjak keyboard layout. If you're on windows you should be able to find a key mapping somewhere. It'll then take some getting used to :-) but it should make life easier. I swear by trackballs and ergonomic keyboards, then other people curse when they use my workstation (at one job, I had my ergonomic and an ordinary keyboard plugged in, for people borrowing my desk. I don't think I went as far as trackball plus mouse, though). Another tip, learn to play piano or classical guitar - it'll improve your typing :-) There are a few pieces specially written for left hand (a famous pianist lost his right hand in the Great War). I'm actually right-handed, left-eyed, which means I'm forced to be partially ambidextrous. Cheers, Wol On 11-02-2012 10:54 AM, Wjhonson wrote: Mavis Beacon Teaches Typing Took me from 42 wpm to 78 wpm in two weeks. I'm not kidding ___ 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
Re: [U2] Another Job Ad
Thanks, Bill! I'll check them out. Charlie On 11-05-2012 9:11 AM, Bill Brutzman wrote: Check out www.YouRockGuitar.com. It is a digital guitar with an electronic fretboard (having no strings there). Among other features, It is intended to be played by righties with just the left hand on the fretboard... called shredding. I have a YouRock and I like it but so far... Carnegie Hall has not called me to schedule a performance. --Bill ___ 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
Re: [U2] Another job ad written by people who have no clue
I'm with you, Bill. My phone makes and receives calls - period. I think you might be able to text on it (remember having to press 3 numbers to get 1 letter?) - but I don't use it. The best part - it costs me $99/year! And no, I don't talk on it while driving. Charlie Tiny Bear's Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 11-01-2012 9:49 PM, Bill Haskett wrote: Kind of reminds me of my phone. It's gotten so many functions, that barely work, now I can't even make a simple phone call. So I ditched my Android and went to a pay-as-you-go simple phone. Now I can receive and make calls without any problems. Who'd have thought? :-) Bill P.S. Now I'm waiting for the new Thinkpad X1 to get a better docking station and offload my business email to the cloud, where I can securely store and access 10Gb of archived email. Then I'll just walk around with a phone that works and an ultra-thin ultra-fast workstation I can open up and access the internet in a few seconds, to get whatever I need (and be able to read it and interface by typing 70 wpm). Ahhh... - Original Message - *From:* 3xk547...@sneakemail.com *To:* u2-users@listserver.u2ug.org *Date:* 11/1/2012 4:25 PM *Subject:* Re: [U2] Another job ad written by people who have no clue In the mainstream, it's generally understood that one must be in a constant learning cycle, or skills get outdated in a matter of 6-18 months. So .NET people need to understand the difference between WebForms and MVC, and adapt to generics, lambdas, and dynamic types. Java people need to adjust to changes in frameworks, networking, security, and XML parsing. PHP people need to understand competing frameworks as well as balance their server-side skills with JavaScript and related client frameworks. Any browser developer needs to shift with browser changes, now HTML5, CSS3, etc. And some of us need to do all of the above and then some. But what changes in the Pick world? Not much. And how do a lot of Pick people respond to that? By not feeling a need to do anything but R83-compatible BASIC. There are a lot of jobs out there for developers of new UI's for existing MV apps, but few people available who can satisfy the demand. And yet Pick people have had nearly two decades to improve their skills. Every developer here should be qualified for the job associated with this thread, because that ad looks pretty much like any other ad in this industry these days. I'm not trying to paint every Pickie as a dinosaur or a laggard - far from it. I'm just saying there are too many people who still only know BASIC while there have been any number of opportunities to move beyond that. And there are any number of examples of people in the mainstream who are in a constant mode of adaptation to prove that this is not only possible but the established norm. We are where we are in the Pick industry because Pick people generally become complacent in the belief that they are already using the best database in the world, so they don't need to learn anything else. That's just wrong at so many levels. That cripples the industry, making it more difficult for VARs to sell their software and for the DBMS providers to continue investing in this niche market. And let's face it, the additional problem that many here face is that the developer base is now aging, and it's difficult to start from scratch and jump on Mr Toad's Wild Technology Ride. We just can't do that anymore - myself included. What this means is that many people need to recognize their own limitations, and transition their approach to finding employment and consulting gigs. Position as a manager rather than as a programmer. Profile your skills as a problem solver who can get qualified people to write code, rather than competing with a million people who can write code but can't solve real world business problems. Sell your understanding of business rules, because this is an area where you excel compared to all of those people who can write code but have no idea what to write. T From: John Lorentz David Jordan wrote: you have to change the way you get the job interview. Only works if there are jobs available. In Portland, the long list of what people are looking for in skills when hiring does not include Pick (or other varieties). And years of experience in the field plus knowledge of xxx (say, PHP) does not equal five years of experience in PHP specifically using tools x and y in their equation, and you don't get past the initial screening. So I scramble to get what I can. Right now, I'm working QA on a contract and haven't had a chance for a permanent job for seven years now. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another job ad written by people who have no clue
Just old fashioned, I guess, Mecki. My phone has 12 buttons: 1-0, * and #, and the necessary Send, End, Menu and cursor arrows. That's enough buttons for me. I know what you mean about the eyes not being what they used to be. I've been looking for an easier to read keyboard, maybe with black letters on white or yellow keys. I've tried lighted keys and they never worked very well. The painted (or inked) letters rub off so fast, and I've never mastered touch typing. Having only one hand to type with doesn't help, either. And speaking of being old fashioned, do you know it's almost impossible to get a keyboard with the big, L shaped Enter key and the \ on the top row next to the Backspace key? Getting older by the second, Charlie On 11-02-2012 7:52 AM, Mecki Foerthmann wrote: Come on Charlie, texting is cool and it is easy. If I want to talk to my son in France for instance, I send him a text to switch on his PC so we can use Skype to actually talk and vice versa. The workshop sending me a text that my bike is ready to be collected - now how cool is that? You're an American and you guys had letters on your phone keys for ages. OK if you would have to remember that B is hitting 2 twice and S is hitting 7 four times I could see your point, but it's really not that difficult when the letters are actually displayed on the keys and you soon get the hang of it. I bought a phone with especially big keys so I can see the letters because my eyes are not what they used to be. ;-) And no, it's not one of those so called smart phones - it cost me just 15£ including bluetooth and camera - and no contract. On 02/11/2012 12:07, Charlie Noah wrote: I'm with you, Bill. My phone makes and receives calls - period. I think you might be able to text on it (remember having to press 3 numbers to get 1 letter?) - but I don't use it. The best part - it costs me $99/year! And no, I don't talk on it while driving. Charlie Tiny Bear's Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ 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
Re: [U2] Another job ad written by people who have no clue
Left handed only, when I used to be right handed? On 11-02-2012 10:54 AM, Wjhonson wrote: Mavis Beacon Teaches Typing Took me from 42 wpm to 78 wpm in two weeks. I'm not kidding -Original Message- From: Charlie Noah cwn...@comcast.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Nov 2, 2012 6:07 am Subject: Re: [U2] Another job ad written by people who have no clue Just old fashioned, I guess, Mecki. My phone has 12 buttons: 1-0, * and #, and the necessary Send, End, Menu and cursor arrows. That's enough buttons for me. I know what you mean about the eyes not being what they used to be. I've been looking for an easier to read keyboard, maybe with black letters on white or yellow keys. I've tried lighted keys and they never worked very well. The painted (or inked) letters rub off so fast, and I've never mastered touch typing. Having only one hand to type with doesn't help, either. And speaking of being old fashioned, do you know it's almost impossible to get a keyboard with the big, L shaped Enter key and the \ on the top row next to the Backspace key? Getting older by the second, Charlie On 11-02-2012 7:52 AM, Mecki Foerthmann wrote: Come on Charlie, texting is cool and it is easy. If I want to talk to my son in France for instance, I send him a text to switch on his PC so we can use Skype to actually talk and vice versa. The workshop sending me a text that my bike is ready to be collected - now how cool is that? You're an American and you guys had letters on your phone keys for ages. OK if you would have to remember that B is hitting 2 twice and S is hitting 7 four times I could see your point, but it's really not that difficult when the letters are actually displayed on the keys and you soon get the hang of it. I bought a phone with especially big keys so I can see the letters because my eyes are not what they used to be. ;-) And no, it's not one of those so called smart phones - it cost me just 15£ including bluetooth and camera - and no contract. On 02/11/2012 12:07, Charlie Noah wrote: I'm with you, Bill. My phone makes and receives calls - period. I think you might be able to text on it (remember having to press 3 numbers to get 1 letter?) - but I don't use it. The best part - it costs me $99/year! And no, I don't talk on it while driving. Charlie Tiny Bear's Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another job ad written by people who have no clue
I have experience with Universe, Unidata, D3, Jbase, Revelation and RPL (which was Microdata's very proc-like language). Actually, I have a few more, too. Gonna call me a liar, Will? :-) Charlie Tiny Bear's Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 11-01-2012 10:46 AM, Wjhonson wrote: http://simply.engcen.com/JobAdCareerJet.asp?JobID=1253361 Really don't these people get actual... you know... specs? What did they do skip some words? Show me a single person in the world who has all of : Universe, Unidata, D3, Jbase, Revelation AND RPL and I will show you a liar Clearly they meant something like either/or ___ 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
Re: [U2] Variable Interpolation
ROTFLMAO! Charlie On 09-18-2012 6:48 AM, Wols Lists wrote: On 17/09/12 23:31, Dawn Wolthuis wrote: Maybe you were accepted after 10 days? --dawn The computer is an idiot, It knows not how or when. In fact, the only thing it knows Is one plus one is ten! Cheers, Wol Typed on a mobile keyboard On Sep 17, 2012, at 9:52 AM, George Gallenggal...@wyanokegroup.com wrote: I remember when I applied to a college back in the early 80's. Under the question , which language do you Most fluently speak, I put in binary (how geekish could you get!). Funny thing, I was accepted to their Computer science program within 2 days. (guess it wasn't so silly after all). George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jjuser ud2 Sent: Monday, September 17, 2012 10:49 AM To: U2 Users List Subject: Re: [U2] Variable Interpolation Aa okay. That makes more sense :) If language is a place, then I've multiple citizenship! On Mon, Sep 17, 2012 at 7:15 AM, George Gallenggal...@wyanokegroup.com wrote: I Imagine, that by language, they were referring to the programming kind vs The communicative kind! However, in the Pick world, English, could be taken as either! George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jjuser ud2 Sent: Monday, September 17, 2012 9:51 AM To: U2 Users List Subject: Re: [U2] Variable Interpolation No -- English is my native language. I can't imagine what was in my question that would have made you think otherwise... I would imagine that the original poster comes from another language like some previous folks have said. ___ 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] Multivalue Work In South Dakota
I saw a TV news piece this morning saying that South Dakota was in dire need of employees in many fields, including IT. I started searching, and haven't been able to find any multivalue companies in SD, much less jobs. Am I looking in the wrong places? Thanks, Charlie Tiny Bear's Wild Bird Store Everything For The Backyard Bird Enthusiast, Except For The Birds http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multivalue Work In South Dakota
Thanks, Dawn. I will research that. Charlie On 09-12-2012 9:06 AM, Dawn Wolthuis wrote: I do not know the circumstances and did not read anything but I am minutes away from SD. I do know that all state colleges are under the board of regents running Ellucian software -- MultiValue for student systems (formerly known as Datatel) --dawn Typed on a mobile keyboard On Sep 12, 2012, at 8:38 AM, Charlie Noahcwn...@comcast.net wrote: I saw a TV news piece this morning saying that South Dakota was in dire need of employees in many fields, including IT. I started searching, and haven't been able to find any multivalue companies in SD, much less jobs. Am I looking in the wrong places? Thanks, Charlie Tiny Bear's Wild Bird Store Everything For The Backyard Bird Enthusiast, Except For The Birds http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ 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
Re: [U2] Multivalue Work In South Dakota
Thanks, Jeff. On 09-12-2012 8:52 AM, Jeff Schasny wrote: They may be referring to the Williston Basin oil boom, in which case they do need many people, just not IT types: http://www.epmag.com/item/Williston-Basin-Oil-Boom-Gains-Momentum_95509 Charlie Noah wrote: I saw a TV news piece this morning saying that South Dakota was in dire need of employees in many fields, including IT. I started searching, and haven't been able to find any multivalue companies in SD, much less jobs. Am I looking in the wrong places? Thanks, Charlie Tiny Bear's Wild Bird Store Everything For The Backyard Bird Enthusiast, Except For The Birds http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ 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
Re: [U2] Etymology of Q-Pointer
I agree, Tony. The only time I use the statement is if I need to start a locate at something other than element 1 (to step through each matching element) or to locate multiple elements with the located value. Here's an example: * * Method of using LOCATE to find multiple occurrences of value delimited data * using Reality form of LOCATE to use starting position parameter * START.PTR = 1 FOUND.PTR = 0 LOCATE.DONE = FALSE * LOOP LOCATE valuetofind IN ITEM(attr)1, START.PTR SETTING FOUND.PTR THEN whatever you want to do END ELSE LOCATE.DONE = TRUE END UNTIL LOCATE.DONE DO START.PTR = FOUND.PTR + 1 REPEAT If someone knows how to do the same with the function I'd like to know. I still get nailed once in a while by the comma and semicolon, but not often. Charlie Tiny Bear's Wild Bird Store Everything For The Backyard Bird Enthusiast, Except For The Birds http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 09-07-2012 4:53 PM, Tony Gravagno wrote: I do the exact opposite for exactly the same reasons. :) I use the Locate function rather than statement because I find it easier to read and 99% consistent across all platforms. T From: John Lorentz I fully believe that I've never used the function ever since they introduced it as an alternative to the function on Reality sometime in the late 70s. While there are some small differences between Pick platforms on the layout of the LOCATE statement (having to do with searching values, subvalues, etc.), it's so much easier to read than using the function. But then, I've only been programming in Pick since 1978... ___ 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
Re: [U2] [ud] Sub-second delay?
Yes, Dennis, it did. There are long technical explanations of how it worked, but it was indeed a clever, 'techie-appealing' concept. Back in the old Microdata days (yes, I'm that old), you could get in big trouble with the timeslice approach, though. If your timeslice was 50 ms, after that time everything you were doing got saved and the next process in line got the juice. There were certain things that released your timeslice, too, such as IO operations, etc. If you were doing disk access, and what you were working with got paged out of memory, you had to go get it again when your turn came around again. If that took too long, you went through the same thing again, and you might actually sit there all day and get nothing done. No wonder we worried about frame faulting. Ah, those were the days... Thanks for the trip down memory lane! Charlie Tiny Bear's Wild Bird Store Everything For The Backyard Bird Enthusiast, Except For The Birds http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 08-28-2012 9:19 PM, dennis bartlett wrote: Who on earth is going to understand what 'release quantum' (RQM) means? Still, it worked.. and such a clever, 'techie-appealing' concept - tho I don't know that it ever did what I was told it did, it sure sounded good! On 28 August 2012 02:51, Wjhonsonwjhon...@aol.com wrote: How interesting. RQM isn't even in the online help for Universe 10, but it does compile. -Original Message- From: David L. Wasylenkod...@pickpro.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Mon, Aug 27, 2012 9:41 am Subject: Re: [U2] [ud] Sub-second delay? Universe only supports an integer for the SLEEP command... Try this in unidata: 001 CRT TIMEDATE() 002 FOR I=1 TO 5 003 SLEEP 0.5 004 NEXT I 005 CRT TIMEDATE() I've no idea if it's supported... but it's worth a shot to test. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of lar...@wcs-corp.com Sent: Monday, August 27, 2012 11:30 AM To: U2 Users List Subject: Re: [U2] [ud] Sub-second delay? RQM is still supported by UniData, but it's now merely a synonym for SLEEP. NAP is a UV thing, with millisecond granularity. SLEEP, in both UV and UD, like the *nix sleep command, only counts in whole seconds. Larry Hiscock Western Computer Services RQM was supposed to be merely a command to release quantuum which means to pause until I come back up in the time-slicing round-robin. At some point I wonder if they didn't just replace this with a Sleep 1 but that's not really what it was *supposed* to be. ___ 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 ___ 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
Re: [U2] CSV to Array
I have double quotes in my product descriptions, and yes, they are a pain! I also prepare Google Shopping data feeds for clients who don't want to fight it themselves. This is why I prefer tab delimited with no surround character. Unless you have tabs in your actual data, no problems. Technically, it's not csv anymore, but who cares? Charlie Noah Tiny Bear's Wild Bird Store Everything For The Backyard Bird Enthusiast, Except For The Birds http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 08-16-2012 2:25 AM, Mecki Foerthmann wrote: The moment you start working in the engineering or manufacturing industry where it is not uncommon to have double quotes embedded in a field (i.e 5 1/4 Steel Bar) your code will bite you. On 15/08/2012 23:24, David Wolverton wrote: I've done this in the past by doing this: SWAP DQUOTE WITH @AM Now, in theory, every EVEN attribute is a 'quoted' string - don't touch the commas Every ODD attribute is a 'non-quoted' string... Double check me here in case I've lost it... but this should work ... seems this would be faster as well on larger records. Only thing you'd have to test for -- if the first character is a doublequote, we will have a blank first attribute and should not -- but that could be tested in the END ELSE section (IF XXX = 1 THEN IF DATASTRING[1,1] = 1 THEN CONTINUE) DATASTRING = 'A,B,C,D,E,F,G,H,I,J,K,L NEWSTRING = SWAP '' WITH @AM IN DATASTRING AMCNT = DCOUNT(DATASTRING,@AM) FOR XXX = 1 TO AMCNT IF MOD(AMCNT,2) = 0 THEN NEWSTRING := @AM: DATASTRINGXXX END ELSE DATAROW = NEWSTRINGXXX SWAP ',' WITH @AM IN DATAROW NEWSTRING := @AM:DATAROW NEWSTRING-1 = DATAROW END NEXT XXX -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, August 15, 2012 4:11 PM To: u2-users@listserver.u2ug.org Subject: [U2] CSV to Array Rex Gozar uploaded this code, and someone (perhaps him) corrected it, but there's a redundancy here. I'm trying to fix it, in my own version, mostly perhaps I *hate* the CONTINUE, but the logic is a bit convoluted eh? Anyone spot the redundancy ? EQU COMMA TO ',' EQU DQ TO '' BUFFER = TEXT BUFPTR = 0 CPTR = 0 QUOTESW = @FALSE LOOP CPTR += 1 C = BUFFER[CPTR,1] WHILE (C NE ) DO IF (DQ EQ C) THEN IF (QUOTESW) AND (DQ:DQ EQ BUFFER[CPTR,2]) THEN CPTR += 1 END ELSE QUOTESW = NOT(QUOTESW) CONTINUE END END IF (COMMA EQ C) AND NOT(QUOTESW) THEN C = @FM END BUFPTR += 1 BUFFER[BUFPTR,1] = C REPEAT RECORD = BUFFER[1,BUFPTR] RETURN END ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Array Types
Hi John, I had to jump in here, if for no other reason than to let people know I'm still alive and kicking. :-) When you said One thing you CAN'T do is insert a value. I hope you meant attribute. You can insert (and delete) values and subvalues all day long. If you are working with an item where a specific attribute position has meaning, and hopefully a dictionary item that defines it, you would not want to insert attributes anyway. That would lead to hair-pulling, gnashing of teeth and other bad things. If you're working on a variable length item such as a list of IDs, report, etc., a dynamic array is definitely the way to go. Just use whichever best fits the needs of the situation. Neither is inherently good or bad - it's all context driven. Regards, Charlie Noah Tiny Bear's Wild Bird Store Everything For The Backyard Bird Enthusiast, Except For The Birds http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 07-27-2012 11:27 AM, Israel, John R. wrote: SPEED! Other than the extra time spent to build it, it is MUCH faster to access VAR(1000) than to access VAR1000. If I know my variables are going to be small or I am doing reads, yeah, I use dynamic arrays. If I am building some big arrays in a program, I usually use dim arrays. One thing you CAN'T do is insert a value. If I have a real ugly array in a pgm that needs 1 more level of delimiting beyond @SVM, I will use a DIM array as my first level. Yeah, I know @TMs exist, but the functions do not know how to use them. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, July 27, 2012 11:16 AM To: U2 Users List Subject: [U2] Array Types I am surprised that anyone uses dimensioned arrays. I use dynamic arrays for everything. If there are any advantages that dimension arrays have over dynamic... please let me know... without getting sentimental. --Bill ___ 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
Re: [U2] Regarding: use of I - Descriptor
Hi Ross, Could you elaborate on how John Drumheller showed Information was supposedly faster than classic Pick? I Googled it several different ways and found tons of stuff, but not what I was looking for (so what else is new?). Thanks, Charlie Noah On 06-27-2012 2:51 AM, Ross Ferris wrote: John, Your cool idea is (was?) actually known as the Drumheller Trick, and along with some smoke mirrors was used to great advantage in years gone by John Drumheller (to show how much faster Information was than classic Pick :-) The actual way you would typically work would be more like SELECT FILE WITHinsert conditions SAVING DO.TASK That way your routine only gets fired when needed based on selection criteria Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, 26 June 2012 3:24 AM To: 'U2 Users List' Subject: Re: [U2] Regarding: use of I - Descriptor Satya, Roughly speaking, and I-Desc is a way to manipulate the data so that you can select or display data in other ways. You can get data from another file, perform some math on multiple fields, concatenate data, call a basic subroutine, or any combination of these. You can have multiple commands within an I-Desc with each piece separated by a semi-colon, and then take action based on each piece of the code. You can even put alternate indexes on I-Desc, though this can lead to serious problems if you are indexing a translate. You generally cannot do updates with an I-Desc, though if the I-Desc called a subroutine, you COULD do anything but I have never seen this done (and with very good reason). On a wild tangent to what I just said, I have always thought how easy (in a purest way) that you COULD perform some task like month end by having a file with special record and an I-Desc that DOES run update subroutines (yeah I know, I just said not to do that, but the idea is cool). If set up correctly, you COULD simply run your month end by sorting the special file with the I-Desc. For example: SORT MONTH.END.CTL DO.TASK Where DO.TASK is an I-Desc that calls a subroutine that knows what to do based on the key of each record. Again, NOT a good idea, but the capability is there. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: Monday, June 25, 2012 12:10 PM To: U2 Users List Subject: [U2] Regarding: use of I - Descriptor Hi, Could any one of you explain What is I - Descriptor and What is the use of it. Thank you, Satya ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regarding: Unidata dictionaries
Hi Dan, I just read your tips and hints and saw something I never knew: UniQuery and the single quote UniQuery simply cannot handle quote marks in a search string. It takes one look at them and jumps overboard screaming. In most situations this wouldn't be an issue, but in the times where it is it can be downright annoying. How irritating that would be, especially if you didn't know about it! I had to go and check Jbase to make sure that wasn't happening. Fortunately it wasn't. Learn something new every day. :-) When there's nothing new left to learn, just start shoveling in the dirt. Regards, Charlie On 06-20-2012 2:24 PM, Daniel McGrath wrote: Satya, I have a small write up I did a while ago that might help you: http://u2tech.wordpress.com/tips-hints/dictionary-tips-hints/ Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: Wednesday, June 20, 2012 10:18 AM To: U2 Users List Subject: [U2] Regarding: Unidata dictionaries Hi, Could you let,me know what is the difference between PH- type records, D-type records,V-type records,X-type records Thank you, Satya ___ 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
Re: [U2] Runoff ?
Bizarre - I wonder how many other emails are bouncing. I put you in my address book. Would you try to send it again? Thanks, Charlie On 06-18-2012 9:36 AM, Brian Leach wrote: For Charlie Noah You contacted me off-list about this post, but my reply to you bounced. I'm not ignoring you. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: 18 June 2012 08:39 To: 'U2 Users List' Subject: Re: [U2] Runoff ? Z is a free full screen editor for UniVerse you can download from my website. And I'm just about to release version 2 of mvDeveloper (also free) into beta. (Why both? 'cos sometimes it's easier to just jump into an editor at TCL, depending on what I'm doing). Can't find my old Runoff clone though - it seems to have gone the way of all flesh. Did also do a runoff to nroff converter at one time, but that's also gone missing. Sorry. Brian ___ 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
Re: [U2] Regarding : Usage of the SEL.CMD
Hi Paul, I know you're angry, and perhaps justifiably so, but do you realize this comment will live forever in cyberspace, and probably come back to haunt you? Regards, Charlie Noah On 06-11-2012 7:07 PM, Paul Wilson wrote: Go Yourself Dennis !! Paul Wilson | Senior Analyst Avalanche Information Solutions, Inc PO Box 251 Girard PA 16417 Office 814.431.4873 EMail: avalancheinfosols...@yahoo.com | Website: www.avalanchepa.com From: dennis bartlettdqbartl...@gmail.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Monday, June 11, 2012 7:05 PM Subject: Re: [U2] Regarding : Usage of the SEL.CMD The biggest problem we have experienced as Pickies has been that no-one has ever heard of it. Now, when there is evidence that someone is learning it, the likes of @PaulWilson shout, scream, and throw their toys out the cot... go figure! Whereas Java is an 'open' language with zillions of sites telling one EXACTLY how to code, Pick is as closed as it comes. Info is extremely difficult to come by unless you reach a group like this... and who tells a newbie that UniVerse is Pick? Or jBase or D3 or Revelation or... Yes, I know it is annoying for some having to be reminded we all started somewhere. Yeah, I'm all for helping people know about this thing called Pick.. I've been doing it for over 30 years, like some other folk around here, but I'm still not going to get around to every site to fix their code. It'll be nice to know there's a growing fraternity of newcomers to it.. it might give reason for companies to invest in it, and not see the lack of Pickies as reason to think there is no long term investment value... If you think that another 2000 pick-ites will put you out of a job, you need to lift your eyes to the horizon. There are at least 4400 installed sites of Globus / T24, a banking app this is growing new programmers... and even you will not be able to service the workload... dennis On 9 June 2012 05:48, u2ugsimpson-u...@gerzio.ca wrote: ... and then you should be all set to put everyone on this list out of a job ... ___ 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
Re: [U2] READU vs READ and CRT
Hi Laura and Dawn, This reminds me of a program I wrote about 20 years ago for a multilevel marketing company. Its job was to audit a seller's downline, which in many cases ran into thousands or tens of thousands of transactions. For some larger sellers it ran for several minutes. The users insisted on seeing what progress it was making, and settled on a whirly-gig. I explained that it would only slow the process down, but they didn't care. They were quite willing to sacrifice speed for a stupid little character twirling around. Go figure... Regards, Charlie Noah On 05-01-2012 6:41 PM, Dawn Wolthuis wrote: Good story, Laura! We are figuring out where we need animated gifs in a web app to indicate something is happening. They seem mostly unnecessary (with test data, which, granted, might be the reason they seem unnecessary at this point), so we are erring on the side of keeping them out, rather than putting them in. --dawn On Tue, May 1, 2012 at 6:17 PM, Laura Hirshla...@lhirsh.org wrote: Just an interesting piece of history that folks might find amusing. Back in the day, Ultimate had a development project to speed up the basic compiler. Everyone was really anticipating the performance improvements. However, when the new compiler was timed and tested, it didn't produce the expected speed improvements and the developers couldn't find the cause. At the time, Ultimate displayed one asterisk as each line of code was compiled. After much investigation, one of the developers thought to remove the display of the *, and the compiler flew! It was truly amazing - so much so that we didn't think the program compiled at all. The new compiler was finally released as one * for each 10 lines of code. :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 01, 2012 6:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] READU vs READ Computers keep getting faster, and databases keep getting larger. So as a refinement you could say, display something if a second or more has passed, and don't display anything if it hasn't. We used to use MOD 100, which was fine 20 years ago. Now it spins by so fast you cant read it. -Original Message- From: dennis bartlettdqbartl...@gmail.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 3:16 pm Subject: Re: [U2] READU vs READ I think you complicating things ... Troy has it right: Sure files could be resized, and code re-engineered, and all these good hing do help, but I reduced a process scanning 20 million records from 12 ays to 2 days just taking out the CRT to screen informing the user of rogress (or lack of progress.) on such a large number I'd set the interval to around 2, so that the ode as below sits at n,count += 1 f rem(count,2) then CRT n.count:' / ' : tot.count nd On 1 May 2012 11:03, Buss, Troy (Contractor, Logitek Systems) roy.b...@nordsonasymtek.com wrote: Good point... For progress indications, I tend to do the following on the mass updates: N.COUNT += 1 IF REM(COUNT, 1000) ELSE CRT +: __ 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
Re: [U2] Backspace sends break signal in UV
Hi John, I used to run on Jbase/AIX and used xterm. Of course I had to fix the AIX terminfo definition because it was in such sad shape. Regards, Charlie Noah On 04-30-2012 9:26 AM, John Thompson wrote: I don't think I'm fully understanding your problem, but, I did notice this piece in your post... There's nothing in the LOGIN paragraph that appears to be altering the settings. I'm using KDE Konsole as the emulator which sends a term type of xterm. I have never had luck with xterm emulation for any MV system (be it QM, Universe, etc.) You are probably better off setting your KDE konsole session to vt100 and sorting it out from there. Don't quote me on this, but, I don't believe most MV systems have a proper term definition for xterm. Just a thought, as I have had similar pains in the past... On Mon, Apr 30, 2012 at 7:11 AM, Bob Littleb...@marketamerica.com wrote: Thanks for the replies everyone. Yup. I know I can set my tty settings via PTERM. I really should have worded my question differently: What causes my system to switch tty settings simply by logging from the UV account to my development account? I'm old enough to remember that break is a condition not an actual character. Uhhh... just *barely* old enough. :) I actually wrote a Wyse 50 emulator and modem dialer a long time ago. Did it in x86 assembly language too for some reason. (Grandpa - what's a modem? ) Anyway - Here's a screen dump of the settings and the change. It starts by changing to my development account, showing the settings, logto the UV account and show the settings, then doing LOGTO back to my dev account and showing the settings there. There's nothing in the LOGIN paragraph that appears to be altering the settings. I'm using KDE Konsole as the emulator which sends a term type of xterm. rlittle@mustang:/usr/uvuser$ uv UniVerse Command Language 11.1 Copyright Rocket Software, Inc. 1985-2011. All rights reserved. uvuser logged on: Mon Apr 30 06:15:34 2012 :PTERM DISPLAY MODEEMULATE CC INTR= ^C QUIT= ^\ SUSP= OFF DSUSP = OFF SWITCH = OFF ERASE = DEL WERASE = OFF KILL= ^U LNEXT = OFF REPRINT = OFF EOF = ^D EOL = ^@ EOL2= ^@ FLUSH = OFF START = ^Q STOP= ^S LCONT = ^_ FMC = ^^ VMC = ^] SMC = ^\ TMC = ^T SQLNULL = ^N INPUTCTLON CARRIER RECEIVE -HANGUP -LOCAL CASE-UCIN -UCOUT -XCASE -INVERT CRMODE -INLCR -IGNCR ICRNL ONLCR -OCRNL -ONOCR -ONLRET -CRONLY DELAY BS0 CR0 FF0 LF0 VT0 TAB0 -FILL ECHOECHO ERASE=BSB KILL=LF CTRL -LF HANDSHAKE XON -ANY TANDEM -DTR OUTPUT POST -TILDE -BG CS -EXPAND PROTOCOLLINE=0 BAUD=38400 DATA=8 STOP=1 NONE DISABLE -STRIP SIGNALS ENABLE FLUSH BREAK=NULL :SH rlittle@mustang:/usr/uvuser$ stty -a speed 38400 baud; rows 38; columns 109; line = 0; intr = ^C; quit = ^\; erase = ^?; kill = ^U; eof = ^D; eol =undef; eol2 =undef; swtch =undef; start = ^Q; stop = ^S; susp = ^Z; rprnt = ^R; werase = ^W; lnext = ^V; flush = ^O; min = 1; time = 0; -parenb -parodd cs8 -hupcl -cstopb cread -clocal -crtscts -ignbrk -brkint -ignpar -parmrk -inpck -istrip -inlcr -igncr icrnl ixon ixoff -iuclc -ixany -imaxbel -iutf8 opost -olcuc -ocrnl onlcr -onocr -onlret -ofill -ofdel nl0 cr0 tab0 bs0 vt0 ff0 isig icanon iexten echo echoe echok -echonl -noflsh -xcase -tostop -echoprt echoctl echoke rlittle@mustang:/usr/uvuser$ exit :LOGTO UV UniVerse System Administration PackageAccounts Recovery Spoolersh Mem Import Devices :PTERM DISPLAY MODEEMULATE CC INTR= ^C QUIT= ^\ SUSP= OFF DSUSP = OFF SWITCH = OFF ERASE = DEL WERASE = OFF KILL= ^U LNEXT = OFF REPRINT = OFF EOF = ^D EOL = ^@ EOL2= ^@ FLUSH = OFF START = ^Q STOP= ^S LCONT = ^_ FMC = ^^ VMC = ^] SMC = ^\ TMC = ^T SQLNULL = ^N INPUTCTLON CARRIER RECEIVE -HANGUP -LOCAL CASE-UCIN -UCOUT -XCASE -INVERT CRMODE -INLCR -IGNCR ICRNL ONLCR -OCRNL -ONOCR -ONLRET -CRONLY DELAY BS0 CR0 FF0 LF0 VT0 TAB0 -FILL ECHOECHO ERASE=BSB KILL=LF CTRL -LF HANDSHAKE XON -ANY TANDEM -DTR OUTPUT POST -TILDE -BG CS -EXPAND PROTOCOLLINE=0 BAUD=38400 DATA=8 STOP=1 NONE DISABLE -STRIP SIGNALS ENABLE FLUSH BREAK=NULL :SH rlittle@mustang:/usr/uv$ stty -a speed 38400 baud; rows 38; columns 109; line = 0; intr = ^C; quit = ^\; erase = ^?; kill = ^U; eof = ^D; eol =undef; eol2 =undef; swtch =undef; start = ^Q; stop = ^S; susp = ^Z; rprnt = ^R; werase = ^W; lnext = ^V; flush = ^O; min = 1; time = 0; -parenb -parodd cs8 -hupcl -cstopb cread -clocal -crtscts -ignbrk -brkint -ignpar -parmrk -inpck -istrip -inlcr -igncr icrnl ixon ixoff -iuclc -ixany -imaxbel -iutf8 opost -olcuc -ocrnl
Re: [U2] YYMMDD easy way?
Hi Bill, You'll still need to make sure the month and day are zero padded to get YYMMDD. Could you explain this: /Counting SLoCs is meaningless. Also... functional programming is out there now... multiple threads... running on multiple cores. I am starting to treat variables as though they were carbohydrates. / I'm not sure what you're trying to say (brain in molasses mode today). Charlie On 04-26-2012 9:34 AM, Bill Brutzman wrote: Fleshing it out makes it easier to read and maintain. thisYear = oconv(today, 'DY2') thisMonth = oconv(today, 'DM') thisDate = oconv(today, 'DD') yyMMdd = thisYear : thisMonth : thisDate Counting SLoCs is meaningless. Also... functional programming is out there now... multiple threads... running on multiple cores. I am starting to treat variables as though they were carbohydrates. --Bill -Original Message- From: u2-users-bounces On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 7:52 PM YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ 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
Re: [U2] YYMMDD easy way?
Hi Chuck, I've never seen this to fail on any implementation or flavor: OCONV(TODAY,'DY2')'R%2': OCONV(TODAY,'DM')'R%2': OCONV(TODAY,'DD')'R%2' If anyone has, please let me know and I'll rethink. The code assumes (yeah, I know) that TODAY is in ICONV form. I've always used D2Y (I don't remember why) but it's interesting to note that DY2 works as well. Charlie On 04-25-2012 9:30 AM, Charles Stevenson wrote: me: Win 2003 Perry? 10.2? 10.3? Redhat? I'd sure like to know what makes the difference. I'd hate to get bit - again! - in a migration or upgrade. The worst fall-out I ever had in an upgrade was when they changed an obscure FMT code without telling anyone. On 4/25/2012 9:07 AM, Rick Nuckolls wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
On Jbase with different values to TODAY: OCONV(TODAY, 'D2-') = 04-24-12 OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD')= 12424 no OCONV(DATE(),D2YMD:@VM:MCN) = 12 no OCONV(TODAY,'DYMD') = 2012 no OCONV(TODAY, 'DYMD[4,2,2]') = 2012 no CONVERT( , , OCONV(TODAY, DYMD2)) = 2012 no OCONV(TODAY,'DY2')'R%2':OCONV(TODAY,'DM')'R%2':OCONV(TODAY,'DD')'R%2' = 120424 yes OCONV(TODAY, 'D2-') = 01-01-12 OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD')= 1211 no OCONV(DATE(),D2YMD:@VM:MCN) = 12 no OCONV(TODAY,'DYMD') = 2012 no OCONV(TODAY, 'DYMD[4,2,2]') = 2012 no CONVERT( , , OCONV(TODAY, DYMD2)) = 2012 no OCONV(TODAY,'DY2')'R%2':OCONV(TODAY,'DM')'R%2':OCONV(TODAY,'DD')'R%2' = 120101 yes OCONV(TODAY, 'D2-') = 12-12-12 OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD')= 121212 yes OCONV(DATE(),D2YMD:@VM:MCN) = 12 no OCONV(TODAY,'DYMD') = 2012 no OCONV(TODAY, 'DYMD[4,2,2]') = 2012 no CONVERT( , , OCONV(TODAY, DYMD2)) = 2012 no OCONV(TODAY,'DY2')'R%2':OCONV(TODAY,'DM')'R%2':OCONV(TODAY,'DD')'R%2' = 121212 yes I don't know about other implementation, but I think OCONV(TODAY,'DY2')'R%2':OCONV(TODAY,'DM')'R%2':OCONV(TODAY,'DD')'R%2' would work anywhere. 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 04-24-2012 7:01 PM, David A. Green wrote: I use: YYMMDD = CONVERT( , , OCONV(TODAY, DYMD2)) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ 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
Re: [U2] Case Statement with only two cases
A little different, but this reminds me of a program I saw once with nested IFs so deep they actually indented completely off an 80x24 screen with 3 space indents. I still shudder. The CASE construct was far more readable. Charlie Noah On 04-20-2012 4:50 AM, Brian Leach wrote: Many years ago, MV developers were taught not to use CASE as on the old PICK machines they evaluated much (much) slower than the equivalent IFs - probably a bad compiler job. So you ended up with hideous nested IF statements that became practically unreadable. My personal preference has always been to use CASE as it's much clearer, especially when you start getting complex logic in-between. The only thing I generally change is the traditional use of CASE 1 as the fall through option, by equating OTHER to @TRUE so I can use Case OTHER. And multi-line Ifs that are easier to follow in the debugger, especially if you want to place a break point on either branch. And in Will's example, it's all the same to the compiler. As an extreme example, I once picked up some third party code written on a McD machine. Every routine was written so it could fit on a single page of an 80x24 terminal, including (which McD allowed) having labels in the middle of a physical line (semi-colon delimited statements). And having to debug that. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 20 April 2012 09:45 To: 'U2 Users List' Subject: Re: [U2] Case Statement with only two cases Or perhaps there were more cases in there, and over the years they have been deleted. The last programmer to have done a deletion probably should have turned it into an if - but I don't think it really matters, any professional programmer can figure out what it means in less than a second ;) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: 19 April 2012 20:57 To: U2 Users List Subject: Re: [U2] Case Statement with only two cases Logically they are clearly the same. It just depends on what the programmer had in mind for the future of 'A'. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 19, 2012 3:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Case Statement with only two cases Is there a point in code like this BEGIN CASE CASE A = TEST; GOSUB DO.SOMETHING CASE 1; GOSUB DO.SOMETHING.ELSE END CASE versus this IF A = TEST THEN GOSUB DO.SOMETHING ELSE GOSUB DO.SOMETHING.ELSE Personally I see no advantage in making this a CASE Does the rest of the *Universe* agree with me? ___ 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 - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2411/4946 - Release Date: 04/19/12 ___ 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
Re: [U2] Pick jobs
I may be getting long in the tooth, but I ain't dead yet! ;^) Charlie Noah On 03-19-2012 1:21 PM, charles_shaf...@ntn-bower.com wrote: WJohnson What's with the sudden explosion of advertisements for Pick jobs ? There are currently eight open slots in the US alone ? Is this the leading wave ? I hope this doesn't mean that Pick analysts are dying off?! Sorry. Couldn't resist. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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
Re: [U2] Building an Excel File
Hi Wol, Yes, many people have written their own routines, and the ones on Pickwiki do most of the things mine do. Different strokes... Regards, Charlie On 02-11-2012 5:22 AM, Wols Lists wrote: On 09/02/12 16:55, Charlie Noah wrote: Hi Josh, I'd be happy to share my routines with you, if they would be of any use. I have a program I use to load a csv file, and a subroutine which converts back and forth between csv, dynamic and fixed width, either a line at a time or an entire flat file. Charlie Aren't there programs to do this on Pickwiki? Cheers, Wol ___ 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
Re: [U2] Building an Excel File
Yes, parsing csv is a pain. So far it may just be easier to default format the column, at least until I can get my distributor to fix the spreadsheet. I save as tab delimited, and as long as I remember to format first, everything is OK. Thanks, Charlie On 02-11-2012 5:27 AM, Wols Lists wrote: On 09/02/12 16:47, Charlie Noah wrote: I'm exporting from Excel and importing into jBASE. DCOUNTing on the header line is an excellent idea. I'll give that a try. Since I'm using a convert routine, if that fixes the problem, it will be fixed for any spreadsheet I import. It may very well be someone hitting Enter when typing, because some links in the descriptions don't cause this problem. If I could just detect it in the spreadsheet itself, I could let my distributor know what's causing it and which rows need fixing on their end. They are usually pretty good about fixing things, if they know what to do. I'm sure I've hit this problem ... ime, these fields are quoted. So if you parse the file properly line-by-line you will run out of data in the middle of a quoted field. You then just have to recover by getting the next line. A pain, I know. It makes parsing a pain in the neck. Then add the problem that the csv format doesn't actually have a proper definition, just because Excel does it one way, doesn't mean other programs will do the same. csv is a de-facto, not a formal, standard, and you need to be careful... Cheers, Wol ___ 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
Re: [U2] Building an Excel File
While everyone is thinking about CSV and Excel, maybe I can get a solution to a problem that's been plaguing me for a long time. First, let me say that it's been my experience that Excel (and Open Office, which emulates Excel /so /well) has a problem with saving spreadsheets with double quotes as CSV. The typical result is 2 double quotes where there was one in the original cell. Saving as tab delimited seems to solve the problem, and appears to be more reliable. That is what I do pretty much all the time. This is my problem: I get a weekly product spreadsheet for my online store, which contains a detailed description. I have found that if the description cell contains a URL link, usually to a YouTube video about the product, that row gets split into 2 CSV lines. I have changed tabs to bars and broken all the lines displayed below into 80 column lines for clarity. Here is an example: Copy and paste of Excel cell: Handi Stand|HANDI1|Handi Stand Bird Feeder Stand (Black)|A new innovat ive way to feed the birds. This adjustable Handi-Stand will bring your bird feeder to waist height with the lift of a handle. No need for la dders, stools, buckets, etc to fill your feeder. Adjustable from 5 fee t to 8 feet. Three adjustable heights. Total height of item is 92 inch es and the shortest setting is 59 inches with a middle setting of 70 i nches. The 54 inch measurement is the length of the item when it is bo xed for shipping. Wheel chair accessible. Powder coated steel frame. Although it was all in one cell, when I copied and pasted, it split into 2 lines. This is the second line: Click here to view product video.|689466277531|23.50|2.50|4.00|54.00|2 .50|4.00|92.00|0.00|65.80|131.60||0||HANDI1|HANDI1.jpg|1|1|287|2010-11 -18 00:00:00|171|171|196|194USA URL link referenced in the Excel cell: http://www.youtube.com/watch?v=Sn2JFhAfiPU Tab delimited Save As from Excel file shown in a line editor: 3041: Handi Stand|HANDI1|Handi Stand Bird Feeder Stand (Black)|A new i nnovative way to feed the birds. This adjustable Handi-Stand will brin g your bird feeder to waist height with the lift of a handle. No need for ladders, stools, buckets, etc to fill your feeder. Adjustable from 5 feet to 8 feet. Three adjustable heights. Total height of item is 9 2 inches and the shortest setting is 59 inches with a middle setting o f 70 inches. The 54 inch measurement is the length of the item when i t is boxed for shipping. Wheel chair accessible. Powder coated steel f rame. 3042: Click here to view product video.|689466277531|23.50|2.50|4.00|5 4.00|2.50|4.00|92.00|0.00|65.80|131.60||0||HANDI1|HANDI1.jpg|1|1|287|2 010-11-18 00:00:00|171|171|196|194USA Comma delimited Save As from Excel file shown in a line editor: 3041: Handi Stand,HANDI1,Handi Stand Bird Feeder Stand (Black), A new innovative way to feed the birds. This adjustable Handi-Stand wi ll bring your bird feeder to waist height with the lift of a handle. N o need for ladders, stools, buckets, etc to fill your feeder. Adjustab le from 5 feet to 8 feet. Three adjustable heights. Total height of it em is 92 inches and the shortest setting is 59 inches with a middle se tting of 70 inches. The 54 inch measurement is the length of the item when it is boxed for shipping. Wheel chair accessible. Powder coated s teel frame. 3042: Click here to view product video.,689466277531,23.50,2.50 ,4.00,54.00,2.50,4.00,92.00,0.00,65.80,131.60,,0,,H ANDI1,HANDI1.jpg,1,1,287,2010-11-18 00:00:00,171,171,1 96,194USA I've been working around it by highlighting all the cells in the description column and applying default formatting. That seems to remove the URL link and then everything is fine. Does anyone know of a better way to deal with this? I've asked my distributor to remove the links, but so far they have not. Thanks, 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 6:06 PM, Holt, Jake wrote: From what I have seen Excel2010 (I think 2007 did it as well) will often strip off the first occurrence of the double quote in the field and leave the ending quote, but still get the columns right. For instance: test,he said, Watch out below.,test2 Will show up as Col1 test Col2 he said, Watch out below. Col3 test2 You have to escape them with an additional double quote to get it right This: test,he said, Watch out below.,test2 Works as expected. So the moral is, replace your double quotes with 2 double quotes before you write surround it with double quotes and write it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Monday, February 06, 2012 5:45 PM To: U2 Users List Subject: Re: [U2] Building an Excel File It's been my
Re: [U2] Building an Excel File
Thanks George. I changed the tabs to pipes just to display them here. Normally I save as tab delimited with no surrounding character. Since the cell contents copies and pastes as 2 lines, I'm not sure whether these suggestions would solve my problem. Thanks again, Charlie On 02-09-2012 8:54 AM, George Gallen wrote: Not sure if this helps... I noticed that you were showing pipe delimited lines... If you rename your file from .csv to .txt Then from excel, you use the Open option, and then you can set the delimiter to | And also change the column types before it imports it, or have it skip a column as well. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 9:46 AM To: U2 Users List Subject: Re: [U2] Building an Excel File While everyone is thinking about CSV and Excel, maybe I can get a solution to a problem that's been plaguing me for a long time. ___ 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
Re: [U2] Building an Excel File
Hi Symeon, I had forgotten that. Fortunately my convert routine hadn't. ;^) My real problem, though, is URLs splitting lines, which George correctly surmised was a separate situation. Thanks, Charlie On 02-09-2012 9:54 AM, Symeon Breen wrote: This is standard and documented behaviour of a csv - if you have a cell with a in it, it is 'escaped' as Anything that then reads a csv must unescape such characters. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: 09 February 2012 14:46 To: U2 Users List Subject: Re: [U2] Building an Excel File While everyone is thinking about CSV and Excel, maybe I can get a solution to a problem that's been plaguing me for a long time. First, let me say that it's been my experience that Excel (and Open Office, which emulates Excel /so /well) has a problem with saving spreadsheets with double quotes as CSV. The typical result is 2 double quotes where there was one in the original cell. Saving as tab delimited seems to solve the problem, and appears to be more reliable. That is what I do pretty much all the time. This is my problem: I get a weekly product spreadsheet for my online store, which contains a detailed description. I have found that if the description cell contains a URL link, usually to a YouTube video about the product, that row gets split into 2 CSV lines. I have changed tabs to bars and broken all the lines displayed below into 80 column lines for clarity. Here is an example: Copy and paste of Excel cell: Handi Stand|HANDI1|Handi Stand Bird Feeder Stand (Black)|A new innovat ive way to feed the birds. This adjustable Handi-Stand will bring your bird feeder to waist height with the lift of a handle. No need for la dders, stools, buckets, etc to fill your feeder. Adjustable from 5 fee t to 8 feet. Three adjustable heights. Total height of item is 92 inch es and the shortest setting is 59 inches with a middle setting of 70 i nches. The 54 inch measurement is the length of the item when it is bo xed for shipping. Wheel chair accessible. Powder coated steel frame. Although it was all in one cell, when I copied and pasted, it split into 2 lines. This is the second line: Click here to view product video.|689466277531|23.50|2.50|4.00|54.00|2 .50|4.00|92.00|0.00|65.80|131.60||0||HANDI1|HANDI1.jpg|1|1|287|2010-11 -18 00:00:00|171|171|196|194USA URL link referenced in the Excel cell: http://www.youtube.com/watch?v=Sn2JFhAfiPU Tab delimited Save As from Excel file shown in a line editor: 3041: Handi Stand|HANDI1|Handi Stand Bird Feeder Stand (Black)|A new i nnovative way to feed the birds. This adjustable Handi-Stand will brin g your bird feeder to waist height with the lift of a handle. No need for ladders, stools, buckets, etc to fill your feeder. Adjustable from 5 feet to 8 feet. Three adjustable heights. Total height of item is 9 2 inches and the shortest setting is 59 inches with a middle setting o f 70 inches. The 54 inch measurement is the length of the item when i t is boxed for shipping. Wheel chair accessible. Powder coated steel f rame. 3042: Click here to view product video.|689466277531|23.50|2.50|4.00|5 4.00|2.50|4.00|92.00|0.00|65.80|131.60||0||HANDI1|HANDI1.jpg|1|1|287|2 010-11-18 00:00:00|171|171|196|194USA Comma delimited Save As from Excel file shown in a line editor: 3041: Handi Stand,HANDI1,Handi Stand Bird Feeder Stand (Black), A new innovative way to feed the birds. This adjustable Handi-Stand wi ll bring your bird feeder to waist height with the lift of a handle. N o need for ladders, stools, buckets, etc to fill your feeder. Adjustab le from 5 feet to 8 feet. Three adjustable heights. Total height of it em is 92 inches and the shortest setting is 59 inches with a middle se tting of 70 inches. The 54 inch measurement is the length of the item when it is boxed for shipping. Wheel chair accessible. Powder coated s teel frame. 3042: Click here to view product video.,689466277531,23.50,2.50 ,4.00,54.00,2.50,4.00,92.00,0.00,65.80,131.60,,0,,H ANDI1,HANDI1.jpg,1,1,287,2010-11-18 00:00:00,171,171,1 96,194USA I've been working around it by highlighting all the cells in the description column and applying default formatting. That seems to remove the URL link and then everything is fine. Does anyone know of a better way to deal with this? I've asked my distributor to remove the links, but so far they have not. Thanks, 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 6:06 PM, Holt, Jake wrote: From what I have seen Excel2010 (I think 2007 did it as well) will often strip off the first occurrence of the double quote in the field and leave the ending quote, but still get the columns right
Re: [U2] Building an Excel File
It's certainly possible, although I can't detect it. Do you know how I would see it in the spreadsheet itself? Charlie On 02-09-2012 10:11 AM, George Gallen wrote: Is it possible that the URL has an embedded lf at the end from entry on the source side? I've created csv files comma/quoted that contained URLs and were quite long and didn't have any issues importing Them into excel as a .csv , at least not as breaking into two lines. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 11:06 AM To: U2 Users List Subject: Re: [U2] Building an Excel File Thanks George. I changed the tabs to pipes just to display them here. Normally I save as tab delimited with no surrounding character. Since the cell contents copies and pastes as 2 lines, I'm not sure whether these suggestions would solve my problem. Thanks again, Charlie On 02-09-2012 8:54 AM, George Gallen wrote: Not sure if this helps... I noticed that you were showing pipe delimited lines... If you rename your file from .csv to .txt Then from excel, you use the Open option, and then you can set the delimiter to | And also change the column types before it imports it, or have it skip a column as well. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 9:46 AM To: U2 Users List Subject: Re: [U2] Building an Excel File While everyone is thinking about CSV and Excel, maybe I can get a solution to a problem that's been plaguing me for a long time. ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building an Excel File
I'm exporting from Excel and importing into jBASE. DCOUNTing on the header line is an excellent idea. I'll give that a try. Since I'm using a convert routine, if that fixes the problem, it will be fixed for any spreadsheet I import. It may very well be someone hitting Enter when typing, because some links in the descriptions don't cause this problem. If I could just detect it in the spreadsheet itself, I could let my distributor know what's causing it and which rows need fixing on their end. They are usually pretty good about fixing things, if they know what to do. Charlie On 02-09-2012 10:26 AM, George Gallen wrote: Are you have trouble importing into UV, or importing it into Excel? If UV, what I do is while looping through the data to be imported, do a dcount on the fields If the dcount is not the same as the dcount on the header line, then concatenate the following to it And skip the following line. You could go the route of keep checking the dcount until it's equal just In case you find a cell or cells that have more than one embedded cr on that row. The problem is in UV, there is no way to distinguish the embedded cr (sorry not lf) from an @AM, however, Usually, excel sees it usually fine, if it's still in the .xls format, but when it exports it to .csv That embedded cr causes it to break it to new line, so you wind up getting the beginning on one line And the end of the row on the next line. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 11:22 AM To: U2 Users List Subject: Re: [U2] Building an Excel File It's certainly possible, although I can't detect it. Do you know how I would see it in the spreadsheet itself? Charlie On 02-09-2012 10:11 AM, George Gallen wrote: Is it possible that the URL has an embedded lf at the end from entry on the source side? I've created csv files comma/quoted that contained URLs and were quite long and didn't have any issues importing Them into excel as a .csv , at least not as breaking into two lines. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 11:06 AM To: U2 Users List Subject: Re: [U2] Building an Excel File Thanks George. I changed the tabs to pipes just to display them here. Normally I save as tab delimited with no surrounding character. Since the cell contents copies and pastes as 2 lines, I'm not sure whether these suggestions would solve my problem. Thanks again, Charlie On 02-09-2012 8:54 AM, George Gallen wrote: Not sure if this helps... I noticed that you were showing pipe delimited lines... If you rename your file from .csv to .txt Then from excel, you use the Open option, and then you can set the delimiter to | And also change the column types before it imports it, or have it skip a column as well. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 9:46 AM To: U2 Users List Subject: Re: [U2] Building an Excel File While everyone is thinking about CSV and Excel, maybe I can get a solution to a problem that's been plaguing me for a long time. ___ 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 ___ 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
Re: [U2] Building an Excel File
Hi Josh, I'd be happy to share my routines with you, if they would be of any use. I have a program I use to load a csv file, and a subroutine which converts back and forth between csv, dynamic and fixed width, either a line at a time or an entire flat file. Charlie On 02-09-2012 10:44 AM, Joshua Gallant wrote: I was going to ask the same question about embedded line feeds. I've been dealing with a lot of outside companies the last few months transferring data and found a lot have embedded line feeds all over. - Josh On 2/9/12 11:11 AM, George Gallenggal...@wyanokegroup.com wrote: Is it possible that the URL has an embedded lf at the end from entry on the source side? I've created csv files comma/quoted that contained URLs and were quite long and didn't have any issues importing Them into excel as a .csv , at least not as breaking into two lines. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 11:06 AM To: U2 Users List Subject: Re: [U2] Building an Excel File Thanks George. I changed the tabs to pipes just to display them here. Normally I save as tab delimited with no surrounding character. Since the cell contents copies and pastes as 2 lines, I'm not sure whether these suggestions would solve my problem. Thanks again, Charlie On 02-09-2012 8:54 AM, George Gallen wrote: Not sure if this helps... I noticed that you were showing pipe delimited lines... If you rename your file from .csv to .txt Then from excel, you use the Open option, and then you can set the delimiter to | And also change the column types before it imports it, or have it skip a column as well. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 9:46 AM To: U2 Users List Subject: Re: [U2] Building an Excel File While everyone is thinking about CSV and Excel, maybe I can get a solution to a problem that's been plaguing me for a long time. ___ 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 ___ 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
Re: [U2] Building an Excel File
The problem occurs before it ever gets to UV (or in my case jBASE). The csv flat file already has the cell split into 2 lines. On 02-09-2012 10:53 AM, Symeon Breen wrote: It is entitrely possible and ok to have new lines inside a cell in excel and inside a cell in a csv The following col1,2,col3 and New line,col4 Is ok because the new line is inside the quotes of col3 The trick when parsing in u2 is to not do it line by line, but byte by byte -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 09 February 2012 16:31 To: U2 Users List Subject: Re: [U2] Building an Excel File BTW, this occurs usually, when a textbox is used for data entry, someone pastes a URL, then hits the ENTER key And then types some more data. To the original database/excel file it's one cell (.xls file), but when that Source file is exported to the .csv (you know, that warning that some formatting features will be lost?!?) What would solve the problem would be if the .csv standard also included escaping of cr and lf characters so That the export didn't get broken I get those frequently from clients, when they have address fields where the client types the first line, Then hits enter and enters the second line, instead of having two address line fields. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 11:22 AM To: U2 Users List Subject: Re: [U2] Building an Excel File It's certainly possible, although I can't detect it. Do you know how I would see it in the spreadsheet itself? Charlie On 02-09-2012 10:11 AM, George Gallen wrote: Is it possible that the URL has an embedded lf at the end from entry on the source side? I've created csv files comma/quoted that contained URLs and were quite long and didn't have any issues importing Them into excel as a .csv , at least not as breaking into two lines. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 11:06 AM To: U2 Users List Subject: Re: [U2] Building an Excel File Thanks George. I changed the tabs to pipes just to display them here. Normally I save as tab delimited with no surrounding character. Since the cell contents copies and pastes as 2 lines, I'm not sure whether these suggestions would solve my problem. Thanks again, Charlie On 02-09-2012 8:54 AM, George Gallen wrote: Not sure if this helps... I noticed that you were showing pipe delimited lines... If you rename your file from .csv to .txt Then from excel, you use the Open option, and then you can set the delimiter to | And also change the column types before it imports it, or have it skip a column as well. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 9:46 AM To: U2 Users List Subject: Re: [U2] Building an Excel File While everyone is thinking about CSV and Excel, maybe I can get a solution to a problem that's been plaguing me for a long time. ___ 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 ___ 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 - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2112/4797 - Release Date: 02/08/12 ___ 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
Re: [U2] Building an Excel File
Hmmm... getting a bit complicated now. I think George's suggestion to DCOUNT the header line and concat if the number of columns are less might be simpler. I really appreciate all the ideas, though. They give me something to think about. Charlie Make things as simple as possible, but not simpler. - Albert Einstein On 02-09-2012 11:16 AM, Robert Houben wrote: The trick is to NOT read up to a CR or LF, first, and process that as a line. You have to read the file as a stream, literally byte-by-byte, and recognize when you are processing quotes and handle that with different logic. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: February-09-12 9:04 AM To: U2 Users List Subject: Re: [U2] Building an Excel File What Symeon suggests should still work, since the break is inside the quotes (assuming your using Quoted csv and not tabs), so if you go byte by byte, if you encounter a cr that is inside quotes Escape it and keep reading, if you encounter a cr that is between quotes, consider that the end of the row. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 11:57 AM To: U2 Users List Subject: Re: [U2] Building an Excel File The problem occurs before it ever gets to UV (or in my case jBASE). The csv flat file already has the cell split into 2 lines. On 02-09-2012 10:53 AM, Symeon Breen wrote: It is entitrely possible and ok to have new lines inside a cell in excel and inside a cell in a csv The following col1,2,col3 and New line,col4 Is ok because the new line is inside the quotes of col3 The trick when parsing in u2 is to not do it line by line, but byte by byte ___ 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
Re: [U2] Building an Excel File
Yikes! I've seen that, too. On 02-09-2012 11:29 AM, Robert Houben wrote: Until someone decides to skip trailing, empty columns... :o YMMV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: February-09-12 9:25 AM To: U2 Users List Subject: Re: [U2] Building an Excel File Hmmm... getting a bit complicated now. I think George's suggestion to DCOUNT the header line and concat if the number of columns are less might be simpler. I really appreciate all the ideas, though. They give me something to think about. Charlie Make things as simple as possible, but not simpler. - Albert Einstein On 02-09-2012 11:16 AM, Robert Houben wrote: The trick is to NOT read up to a CR or LF, first, and process that as a line. You have to read the file as a stream, literally byte-by-byte, and recognize when you are processing quotes and handle that with different logic. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: February-09-12 9:04 AM To: U2 Users List Subject: Re: [U2] Building an Excel File What Symeon suggests should still work, since the break is inside the quotes (assuming your using Quoted csv and not tabs), so if you go byte by byte, if you encounter a cr that is inside quotes Escape it and keep reading, if you encounter a cr that is between quotes, consider that the end of the row. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 11:57 AM To: U2 Users List Subject: Re: [U2] Building an Excel File The problem occurs before it ever gets to UV (or in my case jBASE). The csv flat file already has the cell split into 2 lines. On 02-09-2012 10:53 AM, Symeon Breen wrote: It is entitrely possible and ok to have new lines inside a cell in excel and inside a cell in a csv The following col1,2,col3 and New line,col4 Is ok because the new line is inside the quotes of col3 The trick when parsing in u2 is to not do it line by line, but byte by byte ___ 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 ___ 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
Re: [U2] Building an Excel File
No, it was Stetson University in Deland. On 02-08-2012 4:47 PM, Keith Johnson [DATACOM] wrote: I'm curious; was the university in Florida Barry University? Someone I worked with years ago went there as a Pick programmer. The following code might be helpful subroutine ucsv(result,source,status,is.oconv) * * Public Domain program for OpenQM by Keith Johnson 2012 * * OCONV Converts from attribute and value marks to .CSV format *Attribute marks are converted to CR:LF * ICONV Converts from .CSV to delimited form *If there are no CR:LF sequences, it uses LF *If there are no LF characters, it uses attribute marks * * Usage: To convert ABC to a .CSV format, use code like * *NEWABC = OCONV(ABC,'UUCSV') * * result = '' status = 0 crlf = char(13):char(10) test = index(source,crlf,1) * begin case * * this is OK case source = '' null * * OCONV not OK if there are already CR:LF sequences case is.oconv and test status = 1 * * The normal case when generating .CSV data case is.oconv atts = dcount(source,@am) for attr = 1 to atts line = sourceattr CRT 'line = ':line vals = dcount(line,@vm) part = '' for valu = 1 to vals bite = line1,valu if part ne '' then part := ',' good = @true if index(bite,'',1) then good = @false if index(bite,' ',1) then good = @false if index(bite,',',1) then good = @false if index(bite,char(10),1) then good = @false if index(bite,char(13),1) then good = @false if not(good) then bite = change(bite,'','') bite = '':bite:'' end part := bite next valu CRT 'part = ':part if result eq '' then result = part else result := crlf:part next attr * * Cannot have both of these in ICONV file - the rows will change case index(source,@am,1) and index(source,char(10),1) status = 2 * * converting from standard .CSV file case test flag = @false mine = change(source,crlf,@am) atts = dcount(mine,@am) for attr = 1 to atts line = mineattr span = len(line) part = '' for posn = 1 to span that = line[posn,2] this = that[1,1] begin case case that eq '' and flag part := '' posn += 1 case this eq '' flag = not(flag) case this eq ',' and not(flag) part := @vm case 1 part := this end case next posn result-1 = part next attr * * converting from LF only (or possibly @am) row delimited file case 1 mark = char(10) if not(index(source,mark,1)) then mark = @am if not(index(source,mark,1)) then status = 3 return end end * flag = @false atts = dcount(source,mark) part = '' for attr = 1 to atts line = field(source,mark,attr) span = len(line) for posn = 1 to span that = line[posn,2] this = that[1,1] begin case case that eq '' and flag part := '' posn += 1 case this eq '' and flag flag = @false case this eq ',' and not(flag) part := @vm case 1 part := this end case next posn * * It is possible to have a linefeed within a field if not(flag) then result-1 = part:char(10) part = '' end else * * But not an attribute mark when it is the delimiter * Assume they forgot the last double quote and be nice if mark eq @am then result-1 = part part = '' flag = @false end end next attr end case * return ___ 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
Re: [U2] Building an Excel File
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 Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ 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
Re: [U2] Building an Excel File
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 Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building an Excel File
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 Have fun!. Dang, now I'm telling my age! EasyCalc ran on Reality as well. Of course, it went the way of many of the other dinosaurs. Now EasyCalc Googles to a scientific calculator on SourceForge. I acquired the source code and rights to redistribute, but that never went anywhere. If memory serves, Compusheet used a lot of abs frames for speed. EC was all Data/Basic. It was a bit slow recalculating a series of 600+ spreadsheets from the bottom up. The others in IT (then called Data Processing) didn't think I would be able to get it to work at all, but it did. The sheets drilled all the way down to class enrollment and paperclip counts, and rolled it all up to a top level , which they used to feed their GL. I probably should have taken this [OT], but I didn't know what effect changing 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Import XML data [not-secure]
Hi Jake, Are these subroutines you could share? Thanks, Charlie Noah On 01-27-2012 3:47 PM, Holt, Jake wrote: I just created a set of subroutines I copy and paste into anything that uses reads or writes XML. Most interfaces don't handle much beyond reading and extracting the element, value and attribute pairs anyway. That is all very easy to achieve without an 'interface' beyond OPEN (or OPENSEQ). Jake -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Friday, January 27, 2012 2:55 PM To: U2 Users List Subject: Re: [U2] UniVerse Import XML data [not-secure] Hi Tony I partly agree with you. But I should be able to process xml data in UniVerse far simpler than at the moment. I should not have to read xml in one application, convert it to a dynamic string and then send it to universe/unidata, I should just be able to do it one step. This is a failing of Rocket to provide suitable interfaces to unibasic. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Saturday, 28 January 2012 4:40 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Import XML data [not-secure] From: John Thompson This is where I think languages like php get it right. Their simple XML stuff makes it simple to parse even the junk you may get from somewhere else. I've commented here and blogged on this topic a number of times. I shake my head at the pain people continually subject themselves to when trying to force the square peg of XML into the round hole of Pick BASIC just because that's the comfort zone. There are any number of other tools out there specifically designed to work with XML. If you go to many other forums, developers aren't focused on the XML processing. They deftly convert to/from XML (and JSON) without a problem, and their questions are largely focused on what to do with the data. MV professionals need to shift focus from doing everything within the MVDBMS to making the best use of all tools available and integrating the MVDBMS with whatever utility does the job that's required. At the core of it, even when using external tools we convert XML to something and that something ultimately needs to be saved in an MV structure. (Similarly for outbound XML.) But if you're focused on namespaces and attributes then the tools you're using aren't providing adequate abstraction from the XML, and you might want to consider tools that convert XML to something else which is easier for you to use. The reality is, that there are a lot of sites and places out there that will send you all kinds of xml, and I found that since I was not proficient at massaging those non-standard feeds into what the U2 xml tools wanted, I just found it easier to do it another way. Whoe - stop right there. I tend to angle away from DBMS-oriented tools for processing XML, but in all fairness we can't expect any tool to behave properly if the data doesn't conform to standards. No, I haven't seen a lot of sites sending all kinds of XML that is non-standard. If you have a trading partner that doesn't produce or consume industry-standard documents, you need to talk with their IT people, and escallate to management on both sides if you're not getting cooperation. Respectfully, I'm guessing you're just not familiar with some of the details of XML, and when the U2 tools don't seem to address one of those details I'm guessing you're considering the document to be non-standard rather than the U2 tools. Again, in all fairness to the U2 team, I'm guessing this is a documentation issue or some lack of understanding along the way rather than any entity being non-standard. If indeed the U2 tools aren't providing standard functionality, well, see paragraph 1 above. :) Good luck. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno NEW! http://groups.google.com/group/mvdbms/about ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Passing by Value
Hi Mecki, I remember those 32K limits. I found a way to cheat a bit, though. I would split a source program into pieces and INCLUDE the subsequent pieces into the first. As long as the object didn't exceed 32K, it worked. Ah, those were the days! :-) Regards, Charlie Noah On 01-26-2012 2:54 PM, Mecki Foerthmann wrote: No, you are completely wrong if you think that is only your world. Who in our game has the luxury working only with their own code? I have been doing what you describe for over 25 years now and probably most of the contributors here do the same thing for a living too and not just since yesterday. And I may have made that silly mistake once or twice as a junior but since then it has become second nature. And in those days we didn't have the luxury of 8000 line programs because the limit for any item was 32K and you were forced to use very short variable names and couldn't even indent your code because spaces are characters too. In one shop I worked we used X, Y, Z etc. in 'primary' code and in internal subroutines XX, YY, ZZ and so on for loop counters. I personally prefer more meaningful names but can't do that always because I try to follow the naming conventions of the code I'm working on. Even the editor you use is irrelevant since I haven't seen one yet that doesn't have a search function. Just go to the top of the program and search for the variable name you intend to use. If your search comes up negative you're safe to use it. Simple! And OTOH how can you make 'rapid changes' to code if you don't understand what it is supposed to do and where the varibles come from? On 26/01/2012 20:16, Wjhonson wrote: Completely wrong :) You apparently have the luxury of only working on programs written by yourself. In my world, we are called upon to make rapid changes in programs written by twenty programmers over twenty years. You haven't specified *how* you ensure that your counters are unique, and by the way, the issue is not just counters, but any variable. -Original Message- From: Mecki Foerthmannmec...@gmx.net To: u2-usersu2-users@listserver.u2ug.org Sent: Thu, Jan 26, 2012 12:13 pm Subject: Re: [U2] Passing by Value What has the length of the program to do with it? always abide to the rule that a for next counter in any internal ubroutine has to be unique. hat way even if the sub is called from within a for next loop the ounters never conflict. o it doesn't make any difference whatsoever if a program is 80 or 8000 ines long. BTW a program with 8000 lines is usually a sign of poor design. On 26/01/2012 19:02, Wjhonson wrote: You've never worked on programs that are 8000 lines long I take it :) -Original Message- From: John Hesterjhes...@momtex.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Thu, Jan 26, 2012 10:49 am Subject: Re: [U2] Passing by Value I like to use increasing roman numerals: FOR I = 1 TO COUNTER GOSUB PROCESS EXT I PROCESS: OR II = 1 TO COUNTER2 FOR III = 1 TO COUNTER3 FOR IV = 1 TO COUNTER4 NEXT IV NEXT III EXT II ETURN -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Thursday, January 26, 2012 10:09 AM o: u2-users@listserver.u2ug.org ubject: Re: [U2] Passing by Value n a related note, any clever ideas to localize a variable to a local ubroutine? For I = 1 to 10 GOSUB PROCESS ext I top 3000 Lines of code later PROCESS: OR I = 1 TO 20 RINT I EXT I ETURN __ 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 __ 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
Re: [U2] Passing by Value
I've had to do it before and it a royal PITA! On 01-26-2012 2:58 PM, Wjhonson wrote: Mecki you're not paying attention. You have an 8000 line program that uses a variable A You didn't write it. You need to find where that variable is assigned. You search for A ? That's not going to work. -Original Message- From: Mecki Foerthmannmec...@gmx.net To: u2-usersu2-users@listserver.u2ug.org Sent: Thu, Jan 26, 2012 12:55 pm Subject: Re: [U2] Passing by Value No, you are completely wrong if you think that is only your world. ho in our game has the luxury working only with their own code? have been doing what you describe for over 25 years now and probably ost of the contributors here do the same thing for a living too and not ust since yesterday. nd I may have made that silly mistake once or twice as a junior but ince then it has become second nature. nd in those days we didn't have the luxury of 8000 line programs ecause the limit for any item was 32K and you were forced to use very hort variable names and couldn't even indent your code because spaces re characters too. n one shop I worked we used X, Y, Z etc. in 'primary' code and in nternal subroutines XX, YY, ZZ and so on for loop counters. personally prefer more meaningful names but can't do that always ecause I try to follow the naming conventions of the code I'm working on. Even the editor you use is irrelevant since I haven't seen one yet that oesn't have a search function. ust go to the top of the program and search for the variable name you ntend to use. f your search comes up negative you're safe to use it. imple! And OTOH how can you make 'rapid changes' to code if you don't nderstand what it is supposed to do and where the varibles come from? On 26/01/2012 20:16, Wjhonson wrote: Completely wrong :) You apparently have the luxury of only working on programs written by ourself. In my world, we are called upon to make rapid changes in programs written by wenty programmers over twenty years. You haven't specified *how* you ensure that your counters are unique, and by he way, the issue is not just counters, but any variable. -Original Message- From: Mecki Foerthmannmec...@gmx.net To: u2-usersu2-users@listserver.u2ug.org Sent: Thu, Jan 26, 2012 12:13 pm Subject: Re: [U2] Passing by Value What has the length of the program to do with it? always abide to the rule that a for next counter in any internal ubroutine has to be unique. hat way even if the sub is called from within a for next loop the ounters never conflict. o it doesn't make any difference whatsoever if a program is 80 or 8000 ines long. BTW a program with 8000 lines is usually a sign of poor design. On 26/01/2012 19:02, Wjhonson wrote: You've never worked on programs that are 8000 lines long I take it :) -Original Message- From: John Hesterjhes...@momtex.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Thu, Jan 26, 2012 10:49 am Subject: Re: [U2] Passing by Value I like to use increasing roman numerals: FOR I = 1 TO COUNTER GOSUB PROCESS EXT I PROCESS: OR II = 1 TO COUNTER2 FOR III = 1 TO COUNTER3 FOR IV = 1 TO COUNTER4 NEXT IV NEXT III EXT II ETURN -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Thursday, January 26, 2012 10:09 AM o: u2-users@listserver.u2ug.org ubject: Re: [U2] Passing by Value n a related note, any clever ideas to localize a variable to a local ubroutine? For I = 1 to 10 GOSUB PROCESS ext I top 3000 Lines of code later PROCESS: OR I = 1 TO 20 RINT I EXT I ETURN __ 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 __ 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 __ 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
Re: [U2] Brilliant? or not?
Thanks for those kind words, Jerry. Charlie On 01-16-2012 10:16 PM, Jerry wrote: I can vouch for Charlies code because I still work on some that he wrote over 13 years ago. Universe is much more forgiving on 'nix systems. On Windows, not so much. Of course that may be because 'nix systems are more forgiving than Windows. When I come across code such as the one that started this thread, I usually figure it was done by someone that knew they wouldn't have to work on the code again. It's good to learn new and better ways to program but wisdom should tell you whether or not it should be used. Most of us, on this list, have been programming for several decades and know what we had to go through to get to this point. If we want new programmers to jump on board we need to remember what it took and give them a break. It's nice to show off but does it do your company or clients any good if others have to take days, even minutes, to figure out what you did. Jerry On 1/16/2012 6:17 PM, Charlie Noah wrote: Hi George, Are there any implementations now that don't support X += 1? Not that I have a problem with X = X + 1 - works just fine and is very clear. I usually try to code to the common denominator, within reason, of course. Over my 34 years in the biz I've been through a lot of conversions of one MV to another. The most dreaded part was finding and fixing things that worked on the old system but not on the new. Universe is famous for being very forgiving and figuring out what you really meant. Jbase not so much. We spent a lot of time on issues like that. Regards, Charlie Noah On 01-16-2012 12:53 PM, George Gallen wrote: This is one of the reasons why I continue to x=x+1 instead of x++ Not all languages support the ++, but they all support x=x+1 George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, January 16, 2012 1:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Brilliant? or not? From: Charles_Shaffer Aside from it not being readable, compacting C code like that can reduce portability. Different compilers may evaluate complex, compacted code differently. Same thing has actually happened with BASIC code that's ported from one platform to another. Rule of thumb: Don't get cute. Spell out the code so that any dumb compiler or programmer can read it. On-topic: that makes my response to this thread, not. One of our colleagues from the mid 80's wrote code that was so clean I liked to say we could eat off of it. I think he still reads this forum: So to Mark Vander Veen, here we are over 20 years later and I Still appreciate your code. Now THAT is Brilliant. 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 ___ 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
Re: [U2] brillant or not
I can name that tune in... On 01-17-2012 6:49 PM, jay rappaport wrote: this discussion brings back memories from long long time ago, far far away when the shortest working program we could come up with as a challenge in school was input = output : f(end) one line of code that actually did something now if only i could remember what language this was in! jay ___ 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
Re: [U2] Brilliant? or not?
Hi Tony, That is high praise indeed! I don't know Mark, but he sounds like someone I would enjoy working with very much. Hopefully he will get to read this. I would like to make his acquaintance. I have always worked hard to write clean, orderly code. That way the poor sap (sometimes me) who has to work on it months or years later will have a much easier time of it. I've caught some grief over the years for spending a few timeslices in making my code clear, readable and self-documenting, but I still do it. Regards, Charlie Noah On 01-16-2012 12:50 PM, Tony Gravagno wrote: From: Charles_Shaffer Aside from it not being readable, compacting C code like that can reduce portability. Different compilers may evaluate complex, compacted code differently. Same thing has actually happened with BASIC code that's ported from one platform to another. Rule of thumb: Don't get cute. Spell out the code so that any dumb compiler or programmer can read it. On-topic: that makes my response to this thread, not. One of our colleagues from the mid 80's wrote code that was so clean I liked to say we could eat off of it. I think he still reads this forum: So to Mark Vander Veen, here we are over 20 years later and I Still appreciate your code. Now THAT is Brilliant. 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
Re: [U2] Brilliant? or not?
Hi George, Are there any implementations now that don't support X += 1? Not that I have a problem with X = X + 1 - works just fine and is very clear. I usually try to code to the common denominator, within reason, of course. Over my 34 years in the biz I've been through a lot of conversions of one MV to another. The most dreaded part was finding and fixing things that worked on the old system but not on the new. Universe is famous for being very forgiving and figuring out what you really meant. Jbase not so much. We spent a lot of time on issues like that. Regards, Charlie Noah On 01-16-2012 12:53 PM, George Gallen wrote: This is one of the reasons why I continue to x=x+1 instead of x++ Not all languages support the ++, but they all support x=x+1 George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, January 16, 2012 1:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Brilliant? or not? From: Charles_Shaffer Aside from it not being readable, compacting C code like that can reduce portability. Different compilers may evaluate complex, compacted code differently. Same thing has actually happened with BASIC code that's ported from one platform to another. Rule of thumb: Don't get cute. Spell out the code so that any dumb compiler or programmer can read it. On-topic: that makes my response to this thread, not. One of our colleagues from the mid 80's wrote code that was so clean I liked to say we could eat off of it. I think he still reads this forum: So to Mark Vander Veen, here we are over 20 years later and I Still appreciate your code. Now THAT is Brilliant. 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Brilliant? or not?
I understand - and I agree with you 100%. You have it even tougher working cross-language. I don't envy you. Back in the 80s a programmer told me I would starve if I didn't learn C. Then in the 90s another told me I'd starve if I didn't get into Java. I've been very fortunate that I'm still fighting the weight, though. ;^) Charlie On 01-16-2012 6:58 PM, George Gallen wrote: I wasn't just referring to flavors/implementations of PICK, but I also do a lot of cross language pick, perl, javascript, php, vb, java, etc I hate having to remember whether I can use a ++ or ++= or =++ or whatever. It's funny, I'll use x=x+1 because it always works, and almost always, someone will say, you knowyou could use instead - sometimes its easier to keep it simple that works on all areas, than to have to remember each variation. It's bad enough the subtle differences between perl, php, javascript and java. George Gallen Senior Programmer/Analyst Accounting/Data Division ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah [cwn...@comcast.net] Sent: Monday, January 16, 2012 7:17 PM To: U2 Users List Subject: Re: [U2] Brilliant? or not? Hi George, Are there any implementations now that don't support X += 1? Not that I have a problem with X = X + 1 - works just fine and is very clear. I usually try to code to the common denominator, within reason, of course. Over my 34 years in the biz I've been through a lot of conversions of one MV to another. The most dreaded part was finding and fixing things that worked on the old system but not on the new. Universe is famous for being very forgiving and figuring out what you really meant. Jbase not so much. We spent a lot of time on issues like that. Regards, Charlie Noah On 01-16-2012 12:53 PM, George Gallen wrote: This is one of the reasons why I continue to x=x+1 instead of x++ Not all languages support the ++, but they all support x=x+1 George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, January 16, 2012 1:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Brilliant? or not? From: Charles_Shaffer Aside from it not being readable, compacting C code like that can reduce portability. Different compilers may evaluate complex, compacted code differently. Same thing has actually happened with BASIC code that's ported from one platform to another. Rule of thumb: Don't get cute. Spell out the code so that any dumb compiler or programmer can read it. On-topic: that makes my response to this thread, not. One of our colleagues from the mid 80's wrote code that was so clean I liked to say we could eat off of it. I think he still reads this forum: So to Mark Vander Veen, here we are over 20 years later and I Still appreciate your code. Now THAT is Brilliant. 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 ___ 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
Re: [U2] Extracting XML attributes
Hi Bobby, If the data isn't corrupted in some way and the process is still this fragile, you may need to think of a whole new approach. If it takes logging in as root, you'll probably end up doing the job yourself - not an ideal choice (Do my job for me once and I thank you, do it twice and it's yours). I'm not sure what that approach might be, since logical XML data groups can be quite large and variable. XML seems to sacrifice size for function, as some other things we all know and love do. Whatever you end up with needs to be robust and very scalable. Sorry I can't offer any ideas at the moment. Regards, Charlie Noah On 01-12-2012 11:02 AM, Bobby Worley wrote: I suppose sequential reads is one approach I may need to consider, especially if I develop this as a tool for our end-users (doing the XML import). I was able to process the large file - It took some jumping through hoops, but I got the file imported. 20,669 records. I set ulimit -d to unlimited , but in order to do so, I had to login as root, set ulimit, then go into UV. Then the program completed. This is on a back up UV server with no other users. - Bob Worley Coburn Supply Co -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Thursday, January 12, 2012 10:30 AM To: U2 Users List Subject: Re: [U2] Extracting XML attributes When working with large XML files in the past I've always run into issues like this but I use a combination of xmapopen, xmapreadnext, and xmapclose. I couldn't ever come up with a great way to use the UV tools for parsing a large file at once so I open as a sequential file and parse the file until I have a full record. I then process that one record with the xml functions. There might be 15 other ways but this has always served its purpose. - Josh On 1/12/12 11:10 AM, Bobby Worleybwor...@coburns.com wrote: Does anybody have an experience reading in very large XML files into Universe on AIX using PrepareXML() function? We received a 176Mb XML file, and I'm running out of memory. I've maxed out ulimit -d and it still blows up with this error: ERROR MESSAGE A DOM error occured during parsing. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Wednesday, November 16, 2011 7:34 AM To: U2 Users List Subject: Re: [U2] Extracting XML attributes Turns out it is a memory issue. My XML file is 16Mb. Setting ulimit -d 75 resolved the issue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, November 11, 2011 10:42 AM To: U2 Users List Subject: Re: [U2] Extracting XML attributes My latest challenge: PREPARE.XML FEED.XML MYXML Prepare the XMLDOM failed. XMLParser error message: A DOM error occured during parsing. UNIVERSE RELLEVEL 001 X 002 11.1.0 003 PICK 004 PICK.FORMAT 005 11.1.0 Aix Version 5.3.0.0 FEED.XML is 16mb. It prepares just fine on UV 10.1.17. Unfortunately it wont list on UV 10.1 because UV 10.1 is not aware of namespaces. This is making my pull my hair out... I don't need this on a Friday. Bob Worley Coburn Supply ___ 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
Re: [U2] DesignBais Website
Hi Harold, I just tried it with Firefox and was able to get the site up - perhaps they just had a momentary glitch. I couldn't find a phone number anywhere, though, just a support contact form. Regards, Charlie Noah On 01-12-2012 1:38 PM, Oaks, Harold wrote: I am interested in showing my boss DesignBais and would like to download the trial copy. Unfortunately, when trying to open the website www.designbais.com I see nothing at all, except the message Done, but with errors on the page in a bottom bar. I don't even have a phone# to call because the webpage is blank. Can anyone help me out? At least to inform DesignBais that their web page has a problem. Thanks- Harold Oaks Clark County, WA, USA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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
Re: [U2] Graph DataBase
Hi Laura, I agree 100%. I think many have lost sight of the fact that customers don't care what their software runs on, or what it's written in, just whether it solves their business problems. Have a wonderful Christmas! Charlie Noah Charles W. Noah Associates cwn...@comcast.net http://www.linkedin.com/in/charlienoah The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 12-17-2011 12:09 PM, Laura Hirsh wrote: Comments below... -Original Message- From: DavidJMurray (mvdbs.com) [nab...@mvdbs.com] Date: 12/16/2011 09:37 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Graph DataBase I also, to some extent, agree with Dawn. The mv, NF**2, post relational, PICK, or whatever the correct model name is, it is not a relational database. There are very strict definitions to a relational database, namely, but not complete, normalisation, SQL, joins etc. parts snipped From the horse's mouth - IE, Codd and Date themselves, relational is a MODEL. There are not STRICT definitions. The current and widespread interpretation is different from the intentions set out way back when by those designing the model. CD also acknowledged that the relational model was not (and is not) perfect. And I quote... Pick is the best implementation of what the relational model tried to accomplish - Dr. Nathan Goodman, VP Codd and Date International. And yes, I have met with Codd, Date and Goodman on this very issue. This argument reminds me of those interpreting an artist's paintings... this was painted during so-n-so's blue period... he was distraught and depressed... you can tell this from his choice of colors. Well, maybe the artist just ran out of red paint... or perhaps, the artist took advantage of a fire sale at the corner DIY art supply store. In the Pick/U2/MV model, we're mainly dealing with business applications. As such, the more relevant questions shouldn't revolve around relational, but instead does x model allow an application to perform well, adjust easily to a company's changing needs, provide a robust, performant, and easy to maintain environment, etc. Most importantly, does i model allow a company to focus on, and increase the bottom line of their business. It really shouldn't be about one technology vs another. -Laura ___ 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
Re: [U2] Extract first and last name from free-form name
Hi Mecki, I absolutely agree. Of course, it's hard enough to get a trained (hopefully) data entry person to get it right, just imagine all those web customers filling out online order forms. The best you can hope for is to get most right, and enough time to look over the rest for errors. Then there's the problem of capitalization. There are probably as many exceptions as there are rules. Oh well, that's why they pay us the big bucks, right? ;^) Regards, Charlie 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 On 12-14-2011 2:22 AM, Mecki Foerthmann wrote: And the list goes on and on and... That's why free form names are an absolute pain and should be avoided. It's so much easier to have Title, First Name(s), Last Name(s) fields in the input screen and keep them as separate attributes. You never get it 100% right. In your list take Dean or Prince for instance - they could be first names and not titles at all. A colleague of mine tried a last name upper to lower case conversion including Irish and Scottish names and out of Machine Co it made MacHine Co. And don't even ask what happened to last names starting with O.:-) On 14/12/2011 01:02, Charlie Noah wrote: Great start, but here is a longer list, although still nowhere near complete: Prefixes Code Description 1st Lt First Lieutenant Adm Admiral Atty Attorney Brother Brother (religious) Capt Captain ChiefChief Cmdr Commander Col Colonel Dean University Dean (includes Assistant and Associate) Dr Doctor (Medical or Educator) ElderElder (religious) Father Father (religious) Gen General Gov Governor Hon Honorable (Cabinet Officer, Commissioner, Congressman, Judge, etc.) Lt Col Lieutenant Colonel Maj Major MSgt Major/Master Sergeant Mr Mister Mrs Married Woman Ms Single or Married Woman Prince Prince Prof Professor (includes Assistant and Associate RabbiRabbi (religious) Rev Reverend (religious) Sister Sister (religious) Suffixes Code Description II The Second III The Third IV The Fourth VThe Fifth CPA Certified Public Accountant DDS Doctor of Dental Medicine Esq Esquire JD Jurist Doctor Jr Junior Jnr Junior (British) LLD Doctor of Laws MD Doctor of Medicine PhD Doctorate Ret Retired from Armed Forces RN Registered Nurse RPh Registered Pharmacist Sr Senior Snr Senior (British) DO Doctor of Osteopathy Perhaps others can add more to the list. 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 On 12-13-2011 5:12 PM, Wjhonson wrote: 0044: SUFFIXES = ,JR,SR,MD,III, 0045: S.NAME = DCOUNT(UM.NAME,' ') 0046: LAST.WORD.IN.NAME = FIELD(UM.NAME,' ',S.NAME) 0047: IF INDEX(SUFFIXES,,:LAST.WORD.IN.NAME:,,1) THEN 0048: LAST.NAME = FIELD(UM.NAME,' ',S.NAME-1) 0049: END ELSE 0050: LAST.NAME = LAST.WORD.IN.NAME 0051: END 0052: PREFIXES = ',DR,MR,MS,MISS,MRS,' 0053: FIRST.WORD.IN.NAME = FIELD(UM.NAME,' ',1) 0054: IF INDEX(PREFIXES,,:FIRST.WORD.IN.NAME:,,1) THEN 0055: FIRST.NAME = FIELD(UM.NAME,' ',2) 0056: END ELSE 0057: FIRST.NAME = FIRST.WORD.IN.NAME 0058: END ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Extract first and last name from free-form name
And how about Count Darling IV? Count is actually his first name. I haven't heard anything about him in years. Charlie On 12-14-2011 7:47 AM, Wjhonson wrote: Or in our system we have entries like Dean Suarez Smith In actuality the customer states that Suarez Smith is a double last name, not a middle name and last name And Dean is their title... or no it's their first name... Actually Doctor can be a first name as well. It's a mess -Original Message- From: Mecki Foerthmannmec...@gmx.net To: u2-usersu2-users@listserver.u2ug.org Sent: Wed, Dec 14, 2011 5:09 am Subject: Re: [U2] Extract first and last name from free-form name Just face it - it can't be done! So what if Dean has 2 first names and is a plumber? On 14/12/2011 09:57, Symeon Breen wrote: You need to do a proper lexical analysis in order to work these out For example Input : Dean Foster Lex: title word Input: Dean Reginald McGraw Lex: title word word Then set rules to say a lex of title word is probable worked out as forename surname and a lex of title word word is probably title forename surname you can assign probabilities against these and build some self learning in. It is a whole massive topic. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 14 December 2011 08:22 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Extract first and last name from free-form name And the list goes on and on and... That's why free form names are an absolute pain and should be avoided. It's so much easier to have Title, First Name(s), Last Name(s) fields in the input screen and keep them as separate attributes. You never get it 100% right. In your list take Dean or Prince for instance - they could be first names and not titles at all. A colleague of mine tried a last name upper to lower case conversion including Irish and Scottish names and out of Machine Co it made MacHine Co. And don't even ask what happened to last names starting with O.:-) On 14/12/2011 01:02, Charlie Noah wrote: Great start, but here is a longer list, although still nowhere near complete: Prefixes Code Description 1st Lt First Lieutenant Adm Admiral Atty Attorney Brother Brother (religious) Capt Captain ChiefChief Cmdr Commander Col Colonel Dean University Dean (includes Assistant and Associate) Dr Doctor (Medical or Educator) ElderElder (religious) Father Father (religious) Gen General Gov Governor Hon Honorable (Cabinet Officer, Commissioner, Congressman, Judge, etc.) Lt Col Lieutenant Colonel Maj Major MSgt Major/Master Sergeant Mr Mister Mrs Married Woman Ms Single or Married Woman Prince Prince Prof Professor (includes Assistant and Associate RabbiRabbi (religious) Rev Reverend (religious) Sister Sister (religious) Suffixes Code Description II The Second III The Third IV The Fourth VThe Fifth CPA Certified Public Accountant DDS Doctor of Dental Medicine Esq Esquire JD Jurist Doctor Jr Junior Jnr Junior (British) LLD Doctor of Laws MD Doctor of Medicine PhD Doctorate Ret Retired from Armed Forces RN Registered Nurse RPh Registered Pharmacist Sr Senior Snr Senior (British) DO Doctor of Osteopathy Perhaps others can add more to the list. 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 On 12-13-2011 5:12 PM, Wjhonson wrote: 0044: SUFFIXES = ,JR,SR,MD,III, 0045: S.NAME = DCOUNT(UM.NAME,' ') 0046: LAST.WORD.IN.NAME = FIELD(UM.NAME,' ',S.NAME) 0047: IF INDEX(SUFFIXES,,:LAST.WORD.IN.NAME:,,1) THEN 0048: LAST.NAME = FIELD(UM.NAME,' ',S.NAME-1) 0049: END ELSE 0050: LAST.NAME = LAST.WORD.IN.NAME 0051: END 0052: PREFIXES = ',DR,MR,MS,MISS,MRS,' 0053: FIRST.WORD.IN.NAME = FIELD(UM.NAME,' ',1) 0054: IF INDEX(PREFIXES,,:FIRST.WORD.IN.NAME:,,1) THEN 0055: FIRST.NAME = FIELD(UM.NAME,' ',2) 0056: END ELSE 0057: FIRST.NAME = FIRST.WORD.IN.NAME 0058: END ___ 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 - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1415 / Virus Database: 2102/4079 - Release
Re: [U2] Extract first and last name from free-form name
Great start, but here is a longer list, although still nowhere near complete: Prefixes Code Description 1st Lt First Lieutenant Adm Admiral Atty Attorney Brother Brother (religious) Capt Captain ChiefChief Cmdr Commander Col Colonel Dean University Dean (includes Assistant and Associate) Dr Doctor (Medical or Educator) ElderElder (religious) Father Father (religious) Gen General Gov Governor Hon Honorable (Cabinet Officer, Commissioner, Congressman, Judge, etc.) Lt Col Lieutenant Colonel Maj Major MSgt Major/Master Sergeant Mr Mister Mrs Married Woman Ms Single or Married Woman Prince Prince Prof Professor (includes Assistant and Associate RabbiRabbi (religious) Rev Reverend (religious) Sister Sister (religious) Suffixes Code Description II The Second III The Third IV The Fourth VThe Fifth CPA Certified Public Accountant DDS Doctor of Dental Medicine Esq Esquire JD Jurist Doctor Jr Junior Jnr Junior (British) LLD Doctor of Laws MD Doctor of Medicine PhD Doctorate Ret Retired from Armed Forces RN Registered Nurse RPh Registered Pharmacist Sr Senior Snr Senior (British) DO Doctor of Osteopathy Perhaps others can add more to the list. 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 On 12-13-2011 5:12 PM, Wjhonson wrote: 0044: SUFFIXES = ,JR,SR,MD,III, 0045: S.NAME = DCOUNT(UM.NAME,' ') 0046: LAST.WORD.IN.NAME = FIELD(UM.NAME,' ',S.NAME) 0047: IF INDEX(SUFFIXES,,:LAST.WORD.IN.NAME:,,1) THEN 0048: LAST.NAME = FIELD(UM.NAME,' ',S.NAME-1) 0049: END ELSE 0050: LAST.NAME = LAST.WORD.IN.NAME 0051: END 0052: PREFIXES = ',DR,MR,MS,MISS,MRS,' 0053: FIRST.WORD.IN.NAME = FIELD(UM.NAME,' ',1) 0054: IF INDEX(PREFIXES,,:FIRST.WORD.IN.NAME:,,1) THEN 0055: FIRST.NAME = FIELD(UM.NAME,' ',2) 0056: END ELSE 0057: FIRST.NAME = FIRST.WORD.IN.NAME 0058: END ___ 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
Re: [U2] SB print output question
At last! Someone who agrees with me. Comma delimited data has caused me a lot of problems over the years, especially when spreadsheets are involved. Tab delimited is far more rugged. Regards, Charlie Noah On 12-12-2011 2:25 PM, Wjhonson wrote: Nasty! Comma delimiting is going to cause the downfall of Western Civilization! I wonder if you can optionally tell it to tab delimit -Original Message- From: Colin Alfkealfke...@hotmail.com To: 'U2 Users List'u2-users@listserver.u2ug.org Sent: Mon, Dec 12, 2011 12:21 pm Subject: Re: [U2] SB print output question Taken from the help output: This outputs the report in DIFF format (comma delimited) in the xWORK file. Item ids are 'SBDIF.':port:'.':page and are used to ransfer SB+ database records into DOS speadsheet programs. It's built into the SB+ Report writer. It's the Data Interchange Format. hth olin Original Message- rom: Wjhonson hat is a Diff ? hat sort of output is that? ___ 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
Re: [U2] End of Month date routine
I vote for the method (already posted) which will work every time on any MV system, any flavor, any emulation: find the first day of the next month and subtract 1. Messing around with adding 31, 32, etc. will bite you sooner or later (well, it worked at my last job). Regards, Charlie Noah Charles W. Noah Associates cwn...@comcast.net http://www.linkedin.com/in/charlienoah The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 12-05-2011 3:12 PM, Rick Nuckolls wrote: I think that with a slight modification, adding 31 works reasonably well. Just use the “DYM” conversion consistently through the program: To be concise, in Universe, for any internal date, “D”, the internal form of the last day of the month is: lastdayofmonth = iconv(oconv(iconv(oconv( D, 'DMY'), 'DMY') +31 ,'DMY'),'DMY') -1 “DYM” would work as well. Rick Nuckolls Lynden Inc Doesn't work on my system Anthony. The This month o gives the month and year ok but the attempt to iconv that sets it to zero, it doesn't pad the 01 into it or something so i just get 31 at that point. I think you were expecting that it would take 12 2011 and make it into 12 01 2011 or whatever but it's not working -Original Message- From: George Gallenggal...@wyanokegroup.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Mon, Dec 5, 2011 12:10 pm Subject: Re: [U2] End of Month date routine Haven't checked it, but what happens on 01/31 by adding 31, it should take you arch, backing up Will give you 02/xx (28 or 29)? George -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wols Lists ent: Monday, December 05, 2011 3:05 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] End of Month date routine On 05/12/11 19:03, Wjhonson wrote: Does someone have a routine that, no matter what day you run it, returns the nd of Month Date ? (Assume the end of month date, is the calendar end of month date not some crewy business date) Hmmm... no-one seems to have done my approach ... TODAY = @DATE HIS.MONTH.O = OCONV (TODAY, DMY) ;* strip day off EXT.MONTH.I = ICONV( THIS.MONTH.O, D) + 31 ;* random day next month EXT.MONTH.O = OCONV( NEXT.MONTH.I, DMY) ;* strip day off AST.DAY.I = ICONV( NEXT.MONTH.O, D) - 1 ;* subract one day If you don't have a day in your i/oconv it defaults to 1, so the logic orks. Unfortunately you can't combine the first three lines because here's no number you can pick that will guarantee to land you in next onth whatever today's date :-( Cheers, ol __ 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
Re: [U2] Simple SB screen display question
Oops, replied to wrong message, sorry. Charlie Noah Charles W. Noah Associates cwn...@comcast.net http://www.linkedin.com/in/charlienoah The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 11-30-2011 3:39 PM, Charlie Noah wrote: Hi Bob, It's just my opinion, but I just don't trust the cloud that much, no matter what the contract says. Regards, Charlie Noah Charles W. Noah Associates cwn...@comcast.net http://www.linkedin.com/in/charlienoah The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 11-30-2011 2:30 PM, Woodward, Bob wrote: Hi folks, I sent this to the SB-Solutions list first but I think something is messed up with my registration there. Anyway, I have a simple need, I think. I have a screen that has a MV field that I want to display the first two values when I leave the field. The user may enter a number of values and in the process after I'm going to a basic program where I'm doing some data manipulation. When I'm done, I have everything in RECORD14,1 and14,2 with the rest of the values cleared. On the screen, the last two values, which are now empty, is what's displayed. How can I re-display the now updated contents of RECORD14 (and VALUE)? I thought REFRESH = 2 would do it but no joy. Thanks. BobW ___ 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
Re: [U2] Cloud Legal Question - and a request for Contact Info - IT Legal Issues
Hi John, It's just my opinion, but I just don't trust the cloud that much, no matter what the contract says. Regards, Charlie Noah Charles W. Noah Associates cwn...@comcast.net View Charlie Noah's profile on LinkedIn http://www.linkedin.com/in/charlienoah The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 11-30-2011 3:25 PM, John Thompson wrote: The company I work for is looking at a product that stores a bunch of our sales data in the cloud Our internal legal person had a look at the contract that the company is proposing and apparently it has a little clause in their that they are not liable if the data gets stolen. Is this standard with cloud products? Also, I remember some folks at Spectrum talking about this, and I still have the business cards, but, I am not in the office, AND I foolishly forgot to store them in my contacts. Susan J., I think you probably talked about this? Maybe I can have my legal person fill out a contact form on your site? (sj+ dot com) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ot] A/P Dos 5.2.7 install on Windows 7?
A free D3 developer license? I recently tried to get one and the only thing TL would let me have was a 10 user developer copy for $500. I'm glad someone else paid for it. Charlie Noah On 11-21-2011 5:27 PM, Tony Gravagno wrote: George Gallen wrote: I just came across my old AP DOS diskettes , and wondered if they would still load on Windows 7? Thought it might be interesting to try to load it up. There is logic to the idea that it might be easier to find AP people in a U2 forum than anywhere else. :) However I believe it would be prudent to check in CDP and the TL forum as well. That said, the real issue might not be in getting the environment to boot, but to get it to run without a key. Those systems were licensed and non-transferable, and TL doesn't issue keys for them anymore. I believe TL now provides free D3 developer licenses without requiring a reseller relationship. So while it seems kewl n geeky to run AP, it would be much easier to just restore to a modern D3 system where answers are much easier to come by than for AP. HTH Tony Gravagno Former D3 DBMS Product Manager ___ 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
Re: [U2] Simplify, or why mathematicians make better programmers
Actually, it needs more than simplification - the result it returns is close, but not exactly right. I use COL = INT((79 - LEN(SITE.NAME)) / 2), which, if LEN(SITE.NAME) = 10, is 34. The exact position would be 34.5, but that half a column is tough to do (hence the INT). The original code snippet returned 30. Charlie On 11-14-2011 1:19 PM, George Gallen wrote: I'm guessing it started out simpler, and extra steps were added to make alignment corrections, And nobody bothered to simplify. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, November 14, 2011 1:59 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Simplify, or why mathematicians make better programmers COL = (79-LEN(SITE.NAME)*2+1)/2 Is it just me, or are there people out there who really don't get math ? ___ 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