[U2] Time zone issues?

2008-02-13 Thread Dennis Bartlett
This has probably already been dealt with before, but I'm getting the mail all out of sync... time zones! ie mail sent in reply to a mail are being sorted before the original mail. Is there any way to beat this? The point in question here Re: [U2] SLEEP 60 slept... sent by Louie

RE: [U2] Excel downloads

2008-02-13 Thread Dennis Bartlett
Laure Then it sounds like you could do the option described in these posts For those who are lazy to write fancy routines to create CSV files, I've created two dict items, namely COMMA and QUOTE, as follows: COMMA 001: I 002: , 003: 004: , 005: 1T QUOTE 001: I 002: '' 003: 004: 005:

RE: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is

2008-02-13 Thread Stevenson, Charles
Maybe a sys admin changed the system time during the run. Or maybe the system automatically synced to a timeserver. I'll check on that, but I think the synch is automatic and frequent enough to not be off by 7 seconds. Maybe not, since this isn't a production system yet. --- u2-users

Re: [U2] Excel downloads

2008-02-13 Thread [EMAIL PROTECTED]
Laure, You can also use a PERL interface to create/read excel spreadsheets on the SERVER without the need to have any Microsoft Excel components installs. This is a nice cross platform solution. Of course, you must have Perl installed on the server, but, this is trival in most cases. I

RE: [U2] Time zone issues?

2008-02-13 Thread Symeon Breen
I get this all the time. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 13 February 2008 08:50 To: u2-users@listserver.u2ug.org Subject: [U2] Time zone issues? This has probably already been dealt with before, but I'm getting the

Re: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is

2008-02-13 Thread Kevin King
You might check the system logs; if there was a time server sync there should be a note in there. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Excel downloads

2008-02-13 Thread MAJ Programming
On this topic, I have a request for a solution. In New Jersey, all the zip codes start with '0'. Add product codes like 012345 and order numbers like 000123 etc and you'll see the leading zeros. When creating and exporting a CSV to eventually be used by Excel, those columns lose their leading

RE: [U2] Excel downloads

2008-02-13 Thread Craig McDonald
Also, believe it or not, this works with HTML as well - even the formulas. This gives one great flexibility as one can do shading, font manipulations, borders, column-widths, etc. What I did is create a subroutine CSV.TO.HTML with options for titles, sub-titles, headings and footings. For the

RE: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is wrong

2008-02-13 Thread Mark Eastwood
I had a similar experience several years ago (10.0.?/Windows). What I suspect (but never proved) was happening was when I ran PORT.STATUS, it touched the sleeping phantom process and woke it up. It was of little significance to me, and never encounter on other boxes, so I never pursued. You should

[U2][UV] Type 18 File Hashing Algorithm

2008-02-13 Thread Perry Taylor
I need to come up with an equivalent in BASIC to UniVerse's type 18 file hashing algorithm. I understand that IBM treats this as proprietary but I was hoping someone could shed some light on how I might pull this off in BASIC. The following code works fine until the length of the ID exceeds

RE: [U2] Excel downloads

2008-02-13 Thread Dave Davis
What if the data fields contain quotes or double-quotes themselves? Does this handle that situation? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Wednesday, February 13, 2008 4:00 AM To: u2-users@listserver.u2ug.org Subject: RE:

[U2] Thanks to everyone for replies to Excel download post

2008-02-13 Thread IT-Laure Hansen
I have quite a few options to look into. Thanks again to everyone. Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- u2-users mailing list

RE: [U2] Excel downloads

2008-02-13 Thread Symeon Breen
Instead of 07748,012345,000123 have =07748,=012345,=000123?? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: 13 February 2008 14:05 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Excel downloads On this topic, I have a

RE: [U2] UD what user is a phantom using

2008-02-13 Thread Colin Alfke
Bill; Normally our phantoms here return a user = system. We haven't tried firing phantoms from phantoms or starting UniData as another user. I have seen some strange security related things with phantoms - it's like the user isn't quite logged in. You can try looking at @LOGNAME in UniData and

RE: [U2] Excel downloads

2008-02-13 Thread Brenda Price
Yes, =002536 will stay as 002536 when opening the csv file with Excel instead of importing it. -Original Message- From: MAJ Programming [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 8:05 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Excel downloads On this topic,

RE: [U2] Excel downloads

2008-02-13 Thread Bessel, Karen
I have had similar problems with Excel in the past. Have you tried importing the column as text? Sometimes that works sometimes it doesn't. Excel is a very peculiar animal indeed. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent:

RE: [U2] Excel downloads

2008-02-13 Thread Marvin R. Fisher
Try this: =CONCATENATE(,01234) For any values with leading zeroes. Marv Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is

RE: [U2] Excel downloads

2008-02-13 Thread IT-Laure Hansen
Comma delimited fields are always a bit of an issue in this case. The correct way to program CSVs is to place quotes around the fields, to account for just this - but then: what if you have quotes in your fields? Tab is usually a safer delimiter for the simple reason that it is rarely stored as

RE: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is wrong

2008-02-13 Thread Stevenson, Charles
-Original Message- From: Mark Eastwood I had a similar experience several years ago (10.0.?/Windows). What I suspect (but never proved) was happening was when I ran PORT.STATUS, it touched the sleeping phantom process and woke it up. It was of little significance to me, and never

RE: [U2] Excel downloads

2008-02-13 Thread Dave Davis
If you have quotes in the data you prefix them with a quote - for example, the field value: In your free time Becomes In your free time The easiest way to see what the CSV should look like is to type some data in an excel spreadsheet and output it to a CSV file. Our current approach is to

RE: [U2][UV] Type 18 File Hashing Algorithm

2008-02-13 Thread Richard Sammartino
Perry, in Unidata there is the RECORD command which will return the group number to which a record will hash. Unidata does not support type 18 files so I don't know what you will have access to in Universe. If the command exists, you could create and empty file with the appropriate modulo and then

RE: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is

2008-02-13 Thread Stevenson, Charles
You might check the system logs; if there was a time server sync there should be a note in there. We synch every 10 minutes at 0,10,20,30,40,50 minute mark. That doesn't cover 15:05 where my 7 second glitch happened. I ran a mess of tests overnight. About 200,000 iterations of

Re: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is wrong

2008-02-13 Thread Louie Bergsagel
If you had a continue or exit in the code above line 439, it would speed up the interval by skipping the sleep on line 439, and depending on what that code was doing, it could take a coincidental 53 seconds. But you said there was none, and there are no double top loop lines, so that situation is

RE: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is wrong

2008-02-13 Thread Stevenson, Charles
I see what you're saying. yeah, moot. I was hoping someone would jump in and say they'd seen this before the simple fix is... oh well. thx, cds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Wednesday, February 13, 2008 11:53

RE: [U2] UD what user is a phantom using

2008-02-13 Thread Bill Haskett
Colin: Thanks for the thoughts. I wrote a cron processor in BASIC. It worked perfectly in D3, as I could start it automatically in the user-coldstart process when D3 started. Unfortunately UD doesn't have any startup capabilities like this, although I found a kludge from IBM at their tech

[U2] Looking for Ian Renfrew

2008-02-13 Thread Tony G
I can't get in touch with Ian via email. Can someone send me current contact info, or just ask him to drop me a note? Ian wrote JS4U2: http://www3.sympatico.ca/ian_renfrew/JS4U2/docframe.html Is anyone using this for projects? Ian ported my open source MyTimeKeeper project from its character

RE: [U2] Excel downloads [ad responding to specific points]

2008-02-13 Thread Tony G
David wrote: Getting info into MS-Excel has always been an issue - careful use of the XML in U2 and MS-Excel may hold the key... Mmmm, worthy of an article... Karen wrote: Have you tried importing the column as text? Sometimes that works sometimes it doesn't. Excel is a very peculiar

Re: [U2][UV] Type 18 File Hashing Algorithm

2008-02-13 Thread Martin Phillips
Hi Perry, You have got it about right. Although the details of the algorithms are considered as confidential, the Basic equivalent of some of them was published in the UniVerse internals course. Some simple experimentation shows that the published version of the type 18 algorithm is actually

RE: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is wrong

2008-02-13 Thread John Jenkins
There were some changes to do with PHANTOMS being woken from a SLEEP when the parent process terminated. It would be interesting to check your UniVerse release against the Product Availability Matrix: 10.1.14 7659If one UniVerse process was executing a SELECT statement against a file,

RE: [U2] Looking for Ian Renfrew

2008-02-13 Thread John Jenkins
Thinking back - a vague bell rings. I don't think it's directly related but the resolution was a combination of TWO settings: 1. NOTIFY in the PHANTOM's parent 2. Breaking up a LONG sleep to more manageable smaller chunks in a loop. Have you tried varying the NOTIFY setting in the process that

RE: [U2] [UV] Named commons

2008-02-13 Thread Boydell, Stuart
You can create a VOC entry to run from an execute within a transaction. Put an 'H' code in att4 to allow it to be called during a transaction... SBTESTCT VOC UUIDGEN UUIDGEN 0001 Verb to call aix uuid generator 0002 /etc/ncs/uuid_gen 0003 U 0004 CGHIM -Original Message- I need to

Re: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is

2008-02-13 Thread Kevin King
That seems to support the theory that something else is triggering that wait() to go away, like what someone else had mentioned. I know that's about useless information, but I'm in a uselessly opinionated mood. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit

RE: [U2] [UV] Named commons

2008-02-13 Thread Hona, David S
Ah, that's a good idea...but I guess by-passing this restriction (which must be in place for a good reason), should not be taken lightly (especially in an mission critical environment). I guess you could also write some UV BASIC code based on RFC4122 if you want to be fully compliant. See the C

RE: [U2] Excel downloads

2008-02-13 Thread Hona, David S
Hmmm, a miracle tool for little or no money too? ;-) I do not know, if this meets your specific requirements, but... Have you looked at DOWNLOAD from http://www.cedarville.edu/departments/compserv/ftp.htm ? It's been around for a long, long time...no need to roll your own, when it's been done

RE: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is wrong

2008-02-13 Thread Stevenson, Charles
This is on 10.2.6, released Aug 2007. Issue 7659 was fixed in 10.1.14, released Aug 2005. You'd think the fix would be in 10.2.6, too, but maybe it has reared its ugly head again. My description is not quite the same, but I am on HP. No select involved. Executing a PORT.STATUS from another