[U2] Time zone issues?

[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 Bergsagel  at 2:05AM
[U2] SLEEP 60 slept...  original question was sent at 8.00

Timeserver sync
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Excel downloads

[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:1T


To create a CSV file of _ANY_ file data, these dict items either need to be
in the DICT of every file, OR once off in the DICT.DICT (I think - correct
me anyone?) 



>> csv imports don't mind excessive spaces...

LIST DFQ COMMA DFQ.ID COMMA ACCOUNT COMMA DATEOP COMMA 21:47:38  07-02-08 

DFQUOTE.FILE.  ,  QUOTE NO.  ,  ACCOUNT...  ,  DATEOP  ,
208-015646-01  ,  208-015646-01  ,  208-015646  ,  04/05/2007  ,
205-011887-AH  ,  205-011887-AH  ,  205-011887  ,  10/11/2000  ,
202-012637-AH  ,  202-012637-AH  ,  202-012637  ,  16/02/2005  ,




>> to handle numeric fields simply quote them

LIST DFQ COMMA QUOTE DFQ.ID QUOTE COMMA QUOTE ACCOUNT QUOTE 21:50:36  07-02

DFQUOTE.FILE. ,'QUOTE NO.','ACCOUNT...  '  
'208-015646-01,'208-015646-01','208-015646  '
'205-011887-AH,'205-011887-AH','205-011887  '
'202-012637-AH,'202-012637-AH','202-012637  '
'202-014954-01,'202-014954-01','202-014954  '




And here is where I used it

0001: PA
0002: DISPLAY Saving output as AAQ
0003: SP-ASSIGN HS
0004: SETPTR 0,300,,0,0,3,BRIEF,NFMT, BANNER AAQ
0005: SORT DFQ _
0006:  WITH INVOICE <> "" _
0007:  BY ACCOUNT _
0008:  BY DATEOP _
0009:  COMMA DFQ.ID _
0010:  COMMA ACCOUNT _
0011:  COMMA DATEOP _
0012:  COMMA _
0013:  COMMA DFQ.HPHONE _
0014:  COMMA HPM.HOMEPHONE _
0015:  COMMA _
0016:  COMMA DFQ.WPHONE _
0017:  COMMA HPM.WORKPHONE _
0018:  COMMA _
0019:  COMMA DFQ.CELL _
0020:  COMMA HPM.CELLPHONE _
0021:  COMMA _
0022:  COMMA DFQ.SPWORKNO _
0023:  COMMA HPM.SPWORKPHONE _
0024:  COMMA _
0025:  COMMA DFQ.SPCELL _
0026:  COMMA HPM.SPCELLPHONE _
0027:  LPTR NOPAGE HDR.SUP ID.SUP



And subsequently modified by Kevin

For what it's worth,

I do something similar, but I use TAB.  My Dict item looks like:

0001: I

0002: " "

0003:

0004: TAB

0005: 1L

0006: S


Line two is actually "^009", but it shows " ".

Excel handles tab delimited well and I never worry about whether the field
is numeric.

My output line would be:

VAL1 TAB VAL2 TAB VAL3 TAB VAL4

Works well for me.

--Kevin
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Excel downloads

[[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 developed some Unidata (Basic) 
code that interfaces with a Perl Script at the old company that I worked for.  
Email me offline for more details.

[sidenote][ad]Currently looking for full time employment in the South Florida, 
East Coast, area. Contracting work will be considered[ad][sidenote].

Don Verhagen




- Original Message - 
From: "IT-Laure Hansen" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, February 12, 2008 12:10 PM
Subject: [U2] Excel downloads


> Hello,
> 
> We are looking for a simple way to drop aggregate totals type reports
> out of Universe into Excel. Our users are using AccuTerm and we also
> have MITS Reports installed. But, neither one does the trick for
> summarized reports that use the DET-SUP option. Having the detail and
> forcing the users to do their own grouping/sub-totals in Excel is simply
> not an acceptable option here.
> 
> UV 10.2.3 on Win2003 server; AccuTerm 2K2 re. 5.1. We also would be
> happy to develop a "simple" (key word...) VB.Net executable that works
> smoothly regardless of the version of Excel, as our users work on
> anything from Office 2000 and above.
> 
> Any suggestions welcome.
> 
> TIA,
> 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] 
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Time zone issues?

[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 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 Bergsagel  at 2:05AM
[U2] SLEEP 60 slept...  original question was sent at 8.00

Timeserver sync
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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

[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 zeros as Excel thinks they are numeric.

I know that the users can  and choose Custom etc.

I've converted the same CSV into a HTML boxed record and the zeros remain as
expected.

I've tried prepending the values with an astrophe (single quote) to no
avail.

The true data (as viewed in Notepad) is exactly as I sent it:
"07748","012345","000123"

So, any tricks in having Excel leave the zeros alone when clicking on the
CSV in WIndows Explorer. Meaning, that the person opening the CSV in excel
doesn't have to convert anything.

Thanks in advance
Mark Johnson
- Original Message -
From: "David Murray" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, February 12, 2008 4:40 PM
Subject: RE: [U2] Excel downloads


> Laurie,
>
> For simple totals, it is possible to add an EXCEL formula into a cell by
> starting the cell/formula with an '=' sign. This also works with CSV
> structured files, which EXCEL will load and convert on the fly.
>
> Create a virtual/correlative field which will simply output the formula as
> text and add it to the CSV file e.g. "=SUM(An)".
>
> Cheers,
>
> David Murray
>
>
> .learn and do
> .excel and share
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen
> Sent: Tuesday, February 12, 2008 12:10 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Excel downloads
>
> Hello,
>
> We are looking for a simple way to drop aggregate totals type reports
> out of Universe into Excel. Our users are using AccuTerm and we also
> have MITS Reports installed. But, neither one does the trick for
> summarized reports that use the DET-SUP option. Having the detail and
> forcing the users to do their own grouping/sub-totals in Excel is simply
> not an acceptable option here.
>
> UV 10.2.3 on Win2003 server; AccuTerm 2K2 re. 5.1. We also would be
> happy to develop a "simple" (key word...) VB.Net executable that works
> smoothly regardless of the version of Excel, as our users work on
> anything from Office 2000 and above.
>
> Any suggestions welcome.
>
> TIA,
> 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] 
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Excel downloads

[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 titles
and subtitles it merges and centers cells using "col-span"...

 

Craig McDonald

Gensco

 

 

-Original Message-

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Murray

Sent: Tuesday, February 12, 2008 1:40 PM

To: u2-users@listserver.u2ug.org

Subject: RE: [U2] Excel downloads

 

Laurie,

 

For simple totals, it is possible to add an EXCEL formula into a cell by
starting the cell/formula with an '=' sign. This also works with CSV
structured files, which EXCEL will load and convert on the fly.

 

Create a virtual/correlative field which will simply output the formula as
text and add it to the CSV file e.g. "=SUM(An)".

 

Cheers,

 

David Murray

 

 

.learn and do

.excel and share
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 be able to test easy enough.

Mark

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stevenson,
Charles
Sent: Tuesday, February 12, 2008 4:17 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is
wrong

I've never seen this before.  Can anyone explain it?
I'm testing UV 10.2.6 on HPUX 11.23, Itanium & found this while
debugging a program that runs as a phantom.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2][UV] Type 18 File Hashing Algorithm

[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 eight characters 


GROUP = 0
LEN.ID = LEN(ID)

FOR NC = 1 TO LEN.ID

GROUP = GROUP * 10 + SEQ(ID[NC, 1])

NEXT NC

IF GROUP THEN GROUP = MOD(GROUP, FILE.MODULUS) + 1


Thanks.

Perry Taylor
Zirmed, Inc.

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
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Excel downloads

[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] Excel downloads

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:1T


To create a CSV file of _ANY_ file data, these dict items either need to
be in the DICT of every file, OR once off in the DICT.DICT (I think -
correct me anyone?) 



>> csv imports don't mind excessive spaces...

LIST DFQ COMMA DFQ.ID COMMA ACCOUNT COMMA DATEOP COMMA 21:47:38
07-02-08 

DFQUOTE.FILE.  ,  QUOTE NO.  ,  ACCOUNT...  ,  DATEOP  ,
208-015646-01  ,  208-015646-01  ,  208-015646  ,  04/05/2007  ,
205-011887-AH  ,  205-011887-AH  ,  205-011887  ,  10/11/2000  ,
202-012637-AH  ,  202-012637-AH  ,  202-012637  ,  16/02/2005  ,




>> to handle numeric fields simply quote them

LIST DFQ COMMA QUOTE DFQ.ID QUOTE COMMA QUOTE ACCOUNT QUOTE 21:50:36
07-02

DFQUOTE.FILE. ,'QUOTE NO.','ACCOUNT...
'  
'208-015646-01,'208-015646-01','208-015646
'
'205-011887-AH,'205-011887-AH','205-011887
'
'202-012637-AH,'202-012637-AH','202-012637
'
'202-014954-01,'202-014954-01','202-014954
'




And here is where I used it

0001: PA
0002: DISPLAY Saving output as AAQ
0003: SP-ASSIGN HS
0004: SETPTR 0,300,,0,0,3,BRIEF,NFMT, BANNER AAQ
0005: SORT DFQ _
0006:  WITH INVOICE <> "" _
0007:  BY ACCOUNT _
0008:  BY DATEOP _
0009:  COMMA DFQ.ID _
0010:  COMMA ACCOUNT _
0011:  COMMA DATEOP _
0012:  COMMA _
0013:  COMMA DFQ.HPHONE _
0014:  COMMA HPM.HOMEPHONE _
0015:  COMMA _
0016:  COMMA DFQ.WPHONE _
0017:  COMMA HPM.WORKPHONE _
0018:  COMMA _
0019:  COMMA DFQ.CELL _
0020:  COMMA HPM.CELLPHONE _
0021:  COMMA _
0022:  COMMA DFQ.SPWORKNO _
0023:  COMMA HPM.SPWORKPHONE _
0024:  COMMA _
0025:  COMMA DFQ.SPCELL _
0026:  COMMA HPM.SPCELLPHONE _
0027:  LPTR NOPAGE HDR.SUP ID.SUP



And subsequently modified by Kevin

For what it's worth,

I do something similar, but I use TAB.  My Dict item looks like:

0001: I

0002: " "

0003:

0004: TAB

0005: 1L

0006: S


Line two is actually "^009", but it shows " ".

Excel handles tab delimited well and I never worry about whether the
field is numeric.

My output line would be:

VAL1 TAB VAL2 TAB VAL3 TAB VAL4

Works well for me.

--Kevin
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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] 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Excel downloads

[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 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 zeros as Excel thinks they are numeric.

I know that the users can  and choose Custom etc.

I've converted the same CSV into a HTML boxed record and the zeros remain as
expected.

I've tried prepending the values with an astrophe (single quote) to no
avail.

The true data (as viewed in Notepad) is exactly as I sent it:
"07748","012345","000123"

So, any tricks in having Excel leave the zeros alone when clicking on the
CSV in WIndows Explorer. Meaning, that the person opening the CSV in excel
doesn't have to convert anything.

Thanks in advance
Mark Johnson
- Original Message -
From: "David Murray" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, February 12, 2008 4:40 PM
Subject: RE: [U2] Excel downloads


> Laurie,
>
> For simple totals, it is possible to add an EXCEL formula into a cell by
> starting the cell/formula with an '=' sign. This also works with CSV
> structured files, which EXCEL will load and convert on the fly.
>
> Create a virtual/correlative field which will simply output the formula as
> text and add it to the CSV file e.g. "=SUM(An)".
>
> Cheers,
>
> David Murray
>
>
> .learn and do
> .excel and share
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen
> Sent: Tuesday, February 12, 2008 12:10 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Excel downloads
>
> Hello,
>
> We are looking for a simple way to drop aggregate totals type reports
> out of Universe into Excel. Our users are using AccuTerm and we also
> have MITS Reports installed. But, neither one does the trick for
> summarized reports that use the DET-SUP option. Having the detail and
> forcing the users to do their own grouping/sub-totals in Excel is simply
> not an acceptable option here.
>
> UV 10.2.3 on Win2003 server; AccuTerm 2K2 re. 5.1. We also would be
> happy to develop a "simple" (key word...) VB.Net executable that works
> smoothly regardless of the version of Excel, as our users work on
> anything from Office 2000 and above.
>
> Any suggestions welcome.
>
> TIA,
> 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] 
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 see what it reports (I think
there is another one for group or administrator) or setting up a .bat file
in windows to run that does an echo %USERNAME% and capturing the output or
redirecting it to a file.

hth
Colin Alfke
Calgary, Canada 

-Original Message-
From: Bill Haskett

As a follow up (remember we're on Windows 2K3)...

If I login to the Windows server as administrator "A" then run a 3rd party
"sftpc"
command in a DOS window, it works.  If I login to UniData as the same
administrator "A" and run the same "sftpc" command, from ECL, it works fine.
However, if I login to UniData as administrator "B" then run the same
"sftpc" command from ECL (!sftpc -profile=... -cmdFile=...), it fails.  Now,
if I login to the Windows server as administrator "B" then run the "sftpc"
command in a DOS window, it works; and if I rerun the command in UniData,
while still logged in as administrator "B", it works.
However, when I log off UniData and log back in as administrator "A" the
"sftpc"
command fails.  In order to make this work for administrator "A" I need to
login to the Windows server, as admministrator "A", and execute the "sftpc"
command from a DOS prompt.  However, once done for administrator "A",
administrator "B" can't run this command successfully from UniData.  And
around we go.

This seems to imply that O/S commands from UniData execute in a different
security context than on the Windows server, in a DOS window (using the same
Windows user).

Does the UniData Database service need to start under something other than
the "Local System account"?  What Windows security changes from within UD vs
from within a DOS window?

Thanks,

Bill

>-Original Message-
>From: Bill Haskett
>
>I've been trying to set up a script to sftp a file to someone else on 
>the internet
on
>a regular, unattended, basis.  They're using Windows and WinSSHD.  I'm 
>using Windows
>2K3 with Tunnelier and UD v7.1.9.  I'm having some problems figuring 
>out the
security
>context of the phantomed job that runs an O/S command.
> 
>If I start a phantom process, that phantoms other processes when the 
>time is right, what user does the phantom'd phantom use when processing O/S
commands?
> 
>Thanks,
>
>Bill Haskett
>Advantos Systems, Inc.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Excel downloads

[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, 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 zeros as Excel thinks they are numeric.

I know that the users can  and choose Custom etc.

I've converted the same CSV into a HTML boxed record and the zeros
remain as
expected.

I've tried prepending the values with an astrophe (single quote) to no
avail.

The true data (as viewed in Notepad) is exactly as I sent it:
"07748","012345","000123"

So, any tricks in having Excel leave the zeros alone when clicking on
the
CSV in WIndows Explorer. Meaning, that the person opening the CSV in
excel
doesn't have to convert anything.

Thanks in advance
Mark Johnson
- Original Message -
From: "David Murray" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, February 12, 2008 4:40 PM
Subject: RE: [U2] Excel downloads


> Laurie,
>
> For simple totals, it is possible to add an EXCEL formula into a cell
by
> starting the cell/formula with an '=' sign. This also works with CSV
> structured files, which EXCEL will load and convert on the fly.
>
> Create a virtual/correlative field which will simply output the
formula as
> text and add it to the CSV file e.g. "=SUM(An)".
>
> Cheers,
>
> David Murray
>
>
> .learn and do
> .excel and share
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure
Hansen
> Sent: Tuesday, February 12, 2008 12:10 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Excel downloads
>
> Hello,
>
> We are looking for a simple way to drop aggregate totals type reports
> out of Universe into Excel. Our users are using AccuTerm and we also
> have MITS Reports installed. But, neither one does the trick for
> summarized reports that use the DET-SUP option. Having the detail and
> forcing the users to do their own grouping/sub-totals in Excel is
simply
> not an acceptable option here.
>
> UV 10.2.3 on Win2003 server; AccuTerm 2K2 re. 5.1. We also would be
> happy to develop a "simple" (key word...) VB.Net executable that works
> smoothly regardless of the version of Excel, as our users work on
> anything from Office 2000 and above.
>
> Any suggestions welcome.
>
> TIA,
> 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] 
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Excel downloads

[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: Wednesday, February 13, 2008 8:05 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Excel downloads

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 zeros as Excel thinks they are numeric.

I know that the users can  and choose Custom etc.

I've converted the same CSV into a HTML boxed record and the zeros
remain as
expected.

I've tried prepending the values with an astrophe (single quote) to no
avail.

The true data (as viewed in Notepad) is exactly as I sent it:
"07748","012345","000123"

So, any tricks in having Excel leave the zeros alone when clicking on
the
CSV in WIndows Explorer. Meaning, that the person opening the CSV in
excel
doesn't have to convert anything.

Thanks in advance
Mark Johnson
- Original Message -
From: "David Murray" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, February 12, 2008 4:40 PM
Subject: RE: [U2] Excel downloads


> Laurie,
>
> For simple totals, it is possible to add an EXCEL formula into a cell
by
> starting the cell/formula with an '=' sign. This also works with CSV
> structured files, which EXCEL will load and convert on the fly.
>
> Create a virtual/correlative field which will simply output the
formula as
> text and add it to the CSV file e.g. "=SUM(An)".
>
> Cheers,
>
> David Murray
>
>
> .learn and do
> .excel and share
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure
Hansen
> Sent: Tuesday, February 12, 2008 12:10 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Excel downloads
>
> Hello,
>
> We are looking for a simple way to drop aggregate totals type reports
> out of Universe into Excel. Our users are using AccuTerm and we also
> have MITS Reports installed. But, neither one does the trick for
> summarized reports that use the DET-SUP option. Having the detail and
> forcing the users to do their own grouping/sub-totals in Excel is
simply
> not an acceptable option here.
>
> UV 10.2.3 on Win2003 server; AccuTerm 2K2 re. 5.1. We also would be
> happy to develop a "simple" (key word...) VB.Net executable that works
> smoothly regardless of the version of Excel, as our users work on
> anything from Office 2000 and above.
>
> Any suggestions welcome.
>
> TIA,
> 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] 
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Excel downloads

[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 confidential and may be 
legally privileged. The contents contained within, including any attached 
files, are intended solely for the addressee(s). Access by anyone other than 
the addressee(s) is unauthorized. If you are not the intended recipient, any 
disclosure, copying, distribution or any action, taken or not taken, in 
reliance on it, is prohibited and may be unlawful. If you believe that you have 
received this email message in error, please contact the sender. Any views 
expressed within are those of the individual sender, except where the sender 
specifies and with authority, states them to be the views of Pipeline-Software, 
Inc., Santa Ana, CA.

(The contents of this email message have been scanned for the presence of 
computer viruses.)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming
Sent: Wednesday, February 13, 2008 6:05 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Excel downloads

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 zeros as Excel thinks they are numeric.

I know that the users can  and choose Custom etc.

I've converted the same CSV into a HTML boxed record and the zeros remain as
expected.

I've tried prepending the values with an astrophe (single quote) to no
avail.

The true data (as viewed in Notepad) is exactly as I sent it:
"07748","012345","000123"

So, any tricks in having Excel leave the zeros alone when clicking on the
CSV in WIndows Explorer. Meaning, that the person opening the CSV in excel
doesn't have to convert anything.

Thanks in advance
Mark Johnson
- Original Message -
From: "David Murray" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, February 12, 2008 4:40 PM
Subject: RE: [U2] Excel downloads


> Laurie,
>
> For simple totals, it is possible to add an EXCEL formula into a cell by
> starting the cell/formula with an '=' sign. This also works with CSV
> structured files, which EXCEL will load and convert on the fly.
>
> Create a virtual/correlative field which will simply output the formula as
> text and add it to the CSV file e.g. "=SUM(An)".
>
> Cheers,
>
> David Murray
>
>
> .learn and do
> .excel and share
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen
> Sent: Tuesday, February 12, 2008 12:10 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Excel downloads
>
> Hello,
>
> We are looking for a simple way to drop aggregate totals type reports
> out of Universe into Excel. Our users are using AccuTerm and we also
> have MITS Reports installed. But, neither one does the trick for
> summarized reports that use the DET-SUP option. Having the detail and
> forcing the users to do their own grouping/sub-totals in Excel is simply
> not an acceptable option here.
>
> UV 10.2.3 on Win2003 server; AccuTerm 2K2 re. 5.1. We also would be
> happy to develop a "simple" (key word...) VB.Net executable that works
> smoothly regardless of the version of Excel, as our users work on
> anything from Office 2000 and above.
>
> Any suggestions welcome.
>
> TIA,
> 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] 
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Excel downloads

[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 such in data files, but Excel does not handle a
tab-delimited file quite as well as a CSV file. You can of course use
I-descriptors that convert quotes to blanks first, or any other
transformation.

Thus my original question asking for help and tricks: I know what it
takes to get me to where I want to be, but I am looking for the miracle
tool that will work for all types of data extractions with minimal data
massaging and scripting from me.

Thanks,

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]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis
Sent: Wednesday, February 13, 2008 7:36 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Excel downloads

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] Excel downloads

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:1T


To create a CSV file of _ANY_ file data, these dict items either need to
be in the DICT of every file, OR once off in the DICT.DICT (I think -
correct me anyone?) 



>> csv imports don't mind excessive spaces...

LIST DFQ COMMA DFQ.ID COMMA ACCOUNT COMMA DATEOP COMMA 21:47:38
07-02-08 

DFQUOTE.FILE.  ,  QUOTE NO.  ,  ACCOUNT...  ,  DATEOP  ,
208-015646-01  ,  208-015646-01  ,  208-015646  ,  04/05/2007  ,
205-011887-AH  ,  205-011887-AH  ,  205-011887  ,  10/11/2000  ,
202-012637-AH  ,  202-012637-AH  ,  202-012637  ,  16/02/2005  ,




>> to handle numeric fields simply quote them

LIST DFQ COMMA QUOTE DFQ.ID QUOTE COMMA QUOTE ACCOUNT QUOTE 21:50:36
07-02

DFQUOTE.FILE. ,'QUOTE NO.','ACCOUNT...
'  
'208-015646-01,'208-015646-01','208-015646
'
'205-011887-AH,'205-011887-AH','205-011887
'
'202-012637-AH,'202-012637-AH','202-012637
'
'202-014954-01,'202-014954-01','202-014954
'




And here is where I used it

0001: PA
0002: DISPLAY Saving output as AAQ
0003: SP-ASSIGN HS
0004: SETPTR 0,300,,0,0,3,BRIEF,NFMT, BANNER AAQ
0005: SORT DFQ _
0006:  WITH INVOICE <> "" _
0007:  BY ACCOUNT _
0008:  BY DATEOP _
0009:  COMMA DFQ.ID _
0010:  COMMA ACCOUNT _
0011:  COMMA DATEOP _
0012:  COMMA _
0013:  COMMA DFQ.HPHONE _
0014:  COMMA HPM.HOMEPHONE _
0015:  COMMA _
0016:  COMMA DFQ.WPHONE _
0017:  COMMA HPM.WORKPHONE _
0018:  COMMA _
0019:  COMMA DFQ.CELL _
0020:  COMMA HPM.CELLPHONE _
0021:  COMMA _
0022:  COMMA DFQ.SPWORKNO _
0023:  COMMA HPM.SPWORKPHONE _
0024:  COMMA _
0025:  COMMA DFQ.SPCELL _
0026:  COMMA HPM.SPCELLPHONE _
0027:  LPTR NOPAGE HDR.SUP ID.SUP



And subsequently modified by Kevin

For what it's worth,

I do something similar, but I use TAB.  My Dict item looks like:

0001: I

0002: " "

0003:

0004: TAB

0005: 1L

0006: S


Line two is actually "^009", but it shows " ".

Excel handles tab delimited well and I never worry about whether the
field is numeric.

My output line would be:

VAL1 TAB VAL2 TAB VAL3 TAB VAL4

Works well for me.

--Kevin
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 encounter on other
boxes,
> so I never pursued. You should be able to test easy enough.

To test, I had a phantom doing (roughly):
   loop
  crt timedate()
  sleep 60
   repeat
On a 2nd session I repeatedly did
   PORT.STATUS PID [phantom's id]

That caused the phantom to write out the time every 61 or 62 seconds,
but never wake up prematurely.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Excel downloads

[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 create a CSV file, a headings-only Excel
spreadsheet with the columns typed correctly, and macros to import the
CSV file (which uses a .txt extension instead of .csv in our case),
auto-size the columns, and anything else.

Would be interested in hearing about any different/better approaches. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen
Sent: Wednesday, February 13, 2008 12:01 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Excel downloads

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 such in data files, but Excel does not handle a
tab-delimited file quite as well as a CSV file. You can of course use
I-descriptors that convert quotes to blanks first, or any other
transformation.

Thus my original question asking for help and tricks: I know what it
takes to get me to where I want to be, but I am looking for the miracle
tool that will work for all types of data extractions with minimal data
massaging and scripting from me.

Thanks,

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]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis
Sent: Wednesday, February 13, 2008 7:36 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Excel downloads

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] Excel downloads

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:1T


To create a CSV file of _ANY_ file data, these dict items either need to
be in the DICT of every file, OR once off in the DICT.DICT (I think -
correct me anyone?) 



>> csv imports don't mind excessive spaces...

LIST DFQ COMMA DFQ.ID COMMA ACCOUNT COMMA DATEOP COMMA 21:47:38
07-02-08 

DFQUOTE.FILE.  ,  QUOTE NO.  ,  ACCOUNT...  ,  DATEOP  ,
208-015646-01  ,  208-015646-01  ,  208-015646  ,  04/05/2007  ,
205-011887-AH  ,  205-011887-AH  ,  205-011887  ,  10/11/2000  ,
202-012637-AH  ,  202-012637-AH  ,  202-012637  ,  16/02/2005  ,




>> to handle numeric fields simply quote them

LIST DFQ COMMA QUOTE DFQ.ID QUOTE COMMA QUOTE ACCOUNT QUOTE 21:50:36
07-02

DFQUOTE.FILE. ,'QUOTE NO.','ACCOUNT...
'  
'208-015646-01,'208-015646-01','208-015646
'
'205-011887-AH,'205-011887-AH','205-011887
'
'202-012637-AH,'202-012637-AH','202-012637
'
'202-014954-01,'202-014954-01','202-014954
'




And here is where I used it

0001: PA
0002: DISPLAY Saving output as AAQ
0003: SP-ASSIGN HS
0004: SETPTR 0,300,,0,0,3,BRIEF,NFMT, BANNER AAQ
0005: SORT DFQ _
0006:  WITH INVOICE <> "" _
0007:  BY ACCOUNT _
0008:  BY DATEOP _
0009:  COMMA DFQ.ID _
0010:  COMMA ACCOUNT _
0011:  COMMA DATEOP _
0012:  COMMA _
0013:  COMMA DFQ.HPHONE _
0014:  COMMA HPM.HOMEPHONE _
0015:  COMMA _
0016:  COMMA DFQ.WPHONE _
0017:  COMMA HPM.WORKPHONE _
0018:  COMMA _
0019:  COMMA DFQ.CELL _
0020:  COMMA HPM.CELLPHONE _
0021:  COMMA _
0022:  COMMA DFQ.SPWORKNO _
0023:  COMMA HPM.SPWORKPHONE _
0024:  COMMA _
0025:  COMMA DFQ.SPCELL _
0026:  COMMA HPM.SPCELLPHONE _
0027:  LPTR NOPAGE HDR.SUP ID.SUP



And subsequently modified by Kevin

For what it's worth,

I do something similar, but I use TAB.  My Dict item looks like:

0001: I

0002: " "

0003:

0004: TAB

0005: 1L

0006: S


Line two is actually "^009", but it shows " ".

Excel handles tab delimited well and I never worry about whether the
field is numeric.

My output line would be:

VAL1 TAB VAL2 TAB VAL3 TAB VAL4

Works well for me.

--Kevin
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver

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

[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
execute the RECORD command against this file with whatever aid you choose to
use. I can't speak for the overhead in executing this command repeatedly.

Rich Sammartino
 
Richard Sammartino
Systems Analyst
School District of Philadelphia
440 N Broad Street
Philadelphia,  Pa 19130
Phone: (215) 400-5086
Fax:   (215) 400-4411 


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor
Sent: Wednesday, February 13, 2008 9:00 AM
To: u2-users@listserver.u2ug.org
Subject: [U2][UV] Type 18 File Hashing Algorithm

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 eight characters 


GROUP = 0
LEN.ID = LEN(ID)

FOR NC = 1 TO LEN.ID

GROUP = GROUP * 10 + SEQ(ID[NC, 1])

NEXT NC

IF GROUP THEN GROUP = MOD(GROUP, FILE.MODULUS) + 1


Thanks.

Perry Taylor
Zirmed, Inc.

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
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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
[time/sleep/time] in all.  I read the results this morning
programmatically.
There were some 1-second anomalies (my smallest measurable granularity).
All except 2 spanned a timeserver resynch.

Those other 2 each occurred slightly before 01:49:41, in parallel jobs.
That's a half minute shy of a time resynch.  Each woke up in 9 seconds,
not 10.
There were 29 other parallel jobs doing exactly the same thing at 1:49 &
they all behaved appropriately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[Richard Nuckolls]

Try taking the mod of the calculation against 2**31 or 2**32.  I have  
not tested this, but most of the other algorithms just toss any  
overflow of a 32 bit accumulator.


Rick Nuckolls
Lynden Inc.

ie:
EQU TWO32 TO 4294967296
...

GROUP = MOD(GROUP*10 + SEQ(ID[NC, 1]), TWO32)


On Feb 13, 2008, at 5:59 AM, Perry Taylor wrote:


FOR NC = 1 TO LEN.ID

GROUP = GROUP * 10 + SEQ(ID[NC, 1])

NEXT NC

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 moot.

-- Louie

On Feb 12, 2008 6:05 PM, Stevenson, Charles <[EMAIL PROTECTED]>
wrote:

> > Silly question perhaps, but are there any CONTINUE or EXIT statements
> > in the parts you left out?
>
> No, but think about it: even if there were, it could only SLOW DOWN not
> SPEED UP the interval between executions of CRT TIMEDATE().
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is
wrong

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 moot.

-- Louie

On Feb 12, 2008 6:05 PM, Stevenson, Charles
<[EMAIL PROTECTED]>
wrote:

> > Silly question perhaps, but are there any CONTINUE or EXIT 
> > statements in the parts you left out?
>
> No, but think about it: even if there were, it could only SLOW DOWN 
> not SPEED UP the interval between executions of CRT TIMEDATE().
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 site ("How to run a Phantom via the 
Windows
Scheduler and suppress the display of a DOS Shell Window and Taskbar entry").  I
guess I could place this scriipt in the "Startup" folder and assume UD has 
already
started.
 
Anyway, presently I start up this BASIC program by hand whenever I restart UD 
via:
 
:PHANTOM RUN DTABP DTA.SERVICE
 
I do this logged in with my user (an administrator).  This service was similar 
to the
background-processing stuff D3 had; however, it uses a "cron" format.  What 
happens
is this service wakes up every minute, on the minute, reads a services record 
then
"phantom"s off the defined command.  When I set up a sftp process, I write a 
BASIC
program that defines the appropriate account, the sftp O/S command, the 
parameters to
be used by the sftp O/S command, etc.  Then the service creates a command like:
 
TclCmd = "LOGTO E:\UDAccounts\MyAccount"
TclCmd<-1> = "PHANTOM SFTP.RUN"
 
...then executes this.  The problem I run into here is there seems to be some 
kind of
issue with the Windows "sftpc" software where the keys are stored in the 
registry
under some user name (or maybe not - I can't quite get the software developers 
to
work out this scenario without they getting offended I would suggest there's a
problem) and the phantom'd phantom doesn't quite seem to be operating in the 
proper
security context because the sftp fails with an improper key.  It even fails 
from
UD's ECL prompt.  It does, however, work properly from a DOS window.
 
Currently I'm logging every command executed by this originally phantomed 
service,
and the log says the user (@LOGNAME) is me, even on the phantom'd phantom.  So
something is amiss (or could use some further explanation).
 
Thanks again,
 
Bill


  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Colin Alfke
Sent: Wednesday, February 13, 2008 7:57 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD what user is a phantom using



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 see what it reports (I think
there is another one for group or administrator) or setting up a .bat file
in windows to run that does an echo %USERNAME% and capturing the output or
redirecting it to a file.

hth
Colin Alfke
Calgary, Canada

-Original Message-
From: Bill Haskett

As a follow up (remember we're on Windows 2K3)...

If I login to the Windows server as administrator "A" then run a 3rd party 
"sftpc"
command in a DOS window, it works.  If I login to UniData as the same
administrator "A" and run the same "sftpc" command, from ECL, it works fine.
However, if I login to UniData as administrator "B" then run the same
"sftpc" command from ECL (!sftpc -profile=... -cmdFile=...), it fails.  Now,
if I login to the Windows server as administrator "B" then run the "sftpc"
command in a DOS window, it works; and if I rerun the command in UniData,
while still logged in as administrator "B", it works.
However, when I log off UniData and log back in as administrator "A" the "sftpc"
command fails.  In order to make this work for administrator "A" I need to
login to the Windows server, as admministrator "A", and execute the "sftpc"
command from a DOS prompt.  However, once done for administrator "A",
administrator "B" can't run this command successfully from UniData.  And
around we go.

This seems to imply that O/S commands from UniData execute in a different
security context than on the Windows server, in a DOS window (using the same
Windows user).

Does the UniData Database service need to start under something other than
the "Local System account"?  What Windows security changes from within UD vs
from within a DOS window?

Thanks,

Bill

>-Original Message-
>From: Bill Haskett
>
>I've been trying to set up a script to sftp a file to someone else on the 
>internet
on
>a regular, unattended, basis.  They're using Windows and WinSSHD.  I'm using 
>Windows
>2K3 with Tunnelier and UD v7.1.9.  I'm having some problems figuring out the
security
>context of the phantomed job that runs an O/S command.
>
>If I start a phantom process, that phantoms other processes when the time is
>right, what user does the phantom'd phantom use when processing O/S commands?
>
>Thanks,
>
>Bill Haskett
>Advantos Systems, Inc.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe ple

[U2] Looking for Ian Renfrew

[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 interface to a browser interface and I'd like to
continue that effort as well as looking into others.

Thanks.

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 animal indeed.


Folks, this is exactly why I created NebulaXLite.  This new product allows
developers to create real spreadsheets for Excel, Google, and OpenOffice,
with full formatting, and without bothering with XML in Excel or U2 at all.
NebulaXLite handles all of the XML complexities, so now getting info into
MS-Excel is no longer the issue it has always been.

Let's start by pulling CSV off the table.  Ask your users what they do with
the CSV files you give them, and how much time they spend formatting them
afterward.  If your users are just using the data to import into other
sheets for pivot tables and charts, etc, then stick to the CSV files,
they're easy and that's the proper solution for data-only requirements.  If
not, I invite you to download NebulaXLite and just look at the
documentation and samples without even using it.  Just know what's
possible.  NebulaXLite is completely free for non-production use and only
$200 for an end-user server.  How tough is that?

To respond to the questions about zip codes: All you need to do is use
Excel formatting with the code "0".  You can also treat the data as a
string using a single quote.  CSV may have a problem with this but
NebulaXLite doesn't because you can format numeric data as being text.
Excel does provide a friendly warning in the form of a cell comment when it
finds a number that is being treated like text.  The user can simply select
'Ignore Warning' to eliminate this.  The next build of NebulaXLite will
have a small enhancement to avoid the warning when the developer does this.

I hope that helps to clarify that what used to be difficult is no longer
difficult.  It pains me to see so many people still going through these
issues with CSV when it's no longer necessary, and still talking about how
difficult this can all be.

Kind regards,

Tony Gravagno
Nebula Research and Development
remove.pleaseNebula-RnD.com/products/xlite.htm
remove.pleaseNebula-RnD.com/forum
TG@ we.really.don't.like.spamNebula-RnD.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 not 
quite right and a corrected version is shown below.


hashvalue = 0
bytes = len(@id)
for i = 1 to bytes
  ch = @id[i,1]
  hashvalue += hashvalue * 10 + seq(ch)
next i
group = mod(hashvalue, modulo) - 1

Your 8 character limit problem is almost certainly because in the real 
implementation, the line that accumulates the hash value needs to ignore 
overflow of the 32 bit integer that it works with. You could achieve this 
with a BITAND() operation.


I actually have a copy of the real algorithms which we legally obtained as 
part of a project that we undertook with full support from VMark in the 
early 1990s but given that IBM now consider these confidential, I don't 
think I can publish them. (Can you really retrospectively make something 
secret?). I can, however, verify that the algorithm above, which is fairly 
easy to deduce by experiment, is essentially correct.



Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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, and a different UniVerse process was
executing the PORT.STATUS command, the process selecting
the file may have received an error message similar to
the following:

"nanosleep: Interrupted system call"

This problem was unique to the HP platform and has been fixed.


This might be of help - does it match?

Regtards

JayJay


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood
Sent: 13 February 2008 15:10
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is
wrong

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 be able to test easy enough.

Mark

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stevenson,
Charles
Sent: Tuesday, February 12, 2008 4:17 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is
wrong

I've never seen this before.  Can anyone explain it?
I'm testing UV 10.2.6 on HPUX 11.23, Itanium & found this while
debugging a program that runs as a phantom.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Looking for Ian Renfrew

[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 launched the
PHANTOM?

Regards

JayJay

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony G
Sent: 13 February 2008 20:44
To: u2-users@listserver.u2ug.org
Subject: [U2] Looking for Ian Renfrew

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 interface to a browser interface and I'd like to
continue that effort as well as looking into others.

Thanks.

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Named commons

[Boydell, Stuart]

You can create a VOC entry to run from an execute within a transaction.
Put an 'H' code in att<4>  to allow it to be called during a
transaction...

SBTEST>CT VOC UUIDGEN

 UUIDGEN
0001 Verb to call aix uuid generator
0002 /etc/ncs/uuid_gen
0003 U
0004 CGHIM

>-Original Message-
>I need to generate UUID's Universe doesn't have a function that does
this but Unix has
>a : uuidgen program I can execute to capture UUID's.
>
>The problem is that some of our programs run within a TRANSACTION block
and
>cannot execute Unix shell commands within a TRANSACTION block.

 
**
This email message and any files transmitted with it are confidential and 
intended solely for the use of addressed recipient(s). If you have received 
this communication in error, please reply to this e-mail to notify the sender 
of its incorrect delivery and then delete it and your reply.  It is your 
responsibility to check this email and any attachments for viruses and defects 
before opening or sending them on. Spotless collects information about you to 
provide and market our services. For information about use, disclosure and 
access, see our privacy policy at http://www.spotless.com.au 
Please consider our environment before printing this email. 
** 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 http://listserver.u2ug.org/

RE: [U2] [UV] Named commons

[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 source code supplied in
http://www.ietf.org/rfc/rfc4122.txt. Not exactly a trivia task.





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: Thursday, February 14, 2008 3:50 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Named commons

You can create a VOC entry to run from an execute within a transaction.
Put an 'H' code in att<4>  to allow it to be called during a
transaction...

SBTEST>CT VOC UUIDGEN

 UUIDGEN
0001 Verb to call aix uuid generator
0002 /etc/ncs/uuid_gen
0003 U
0004 CGHIM

>-Original Message-
>I need to generate UUID's Universe doesn't have a function that does
this but Unix has
>a : uuidgen program I can execute to capture UUID's.
>
>The problem is that some of our programs run within a TRANSACTION block
and
>cannot execute Unix shell commands within a TRANSACTION block.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Excel downloads

[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 all before...originated on Prime INFORMATION, now on U2,
complete with source code and supplied "as is" without any warranty.

Documentation is here:
ftp://ftp.cedarville.edu/download/download721/download.pdf.


Regards,
David


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen
Sent: Thursday, February 14, 2008 4:01 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Excel downloads

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 such in data files, but Excel does not handle a
tab-delimited file quite as well as a CSV file. You can of course use
I-descriptors that convert quotes to blanks first, or any other
transformation.

Thus my original question asking for help and tricks: I know what it
takes to get me to where I want to be, but I am looking for the miracle
tool that will work for all types of data extractions with minimal data
massaging and scripting from me.

Thanks,

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]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis
Sent: Wednesday, February 13, 2008 7:36 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Excel downloads

What if the data fields contain quotes or double-quotes themselves?
Does this handle that situation?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 session sounds like
something I might have donw.  I was examining that program intensely
that afternoon.

Thanks, JayJay!  I'll forward this to support.

Chuck

-Original Message-
From: 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, and a different UniVerse process was
executing the PORT.STATUS command, the process selecting
the file may have received an error message similar to
the following:

"nanosleep: Interrupted system call"

This problem was unique to the HP platform and has been fixed.


This might be of help - does it match?
-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 encounter on other boxes,
so I never pursued. You should be able to test easy enough.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/