[U2] FW: sudo

[Wronkiewicz, Terrie]

Hi All,

I am attempting to make sudo work for our IS users with unix level
access.  I have put myself in the sudoers file as follows:

myloginname ourtestboxname = PASSWD:ALL

However when I do:  sudo ls -al

It says:

myloginname is not in the sudoers file.  This incident will be reported.

What am I doing wrong?

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

[U2] [UD] Active select list in BASIC

[Bill Haskett]

I have a simple program that looks like:

EXECUTE \SSELECT BP\
HEADING "THIS IS A TEST 'CLT'"
LOOP
   READNEXT ID ELSE EXIT
   CRT ID
REPEAT
CRT
CRT "...Exiting program and clearing select list..."
END

When I run it in Pick mode I get the message "Enter  to
continue..." at the bottom of the 1st screen.  If I enter [Q] to quit, the
program aborts, never prints the exit message, and I'm left at TCL with the
list active (a '>' prompt).

This is not at all what I expected, and after several hours of research I
can't find anything close to a resolution.

Any help would be appreciated.

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

RE: [U2] [UD] Active select list in BASIC

[Kevin King]

It does depend on what your definition of "a resolution" might be.
Look up CLEARSELECT as to clearing the remainder of the select list.
And if you PRINT @(0): somewhere near the top of the program (and get
rid of the HEADING) you'll disable the paging that Unidata is doing on
your behalf.   Of course, then you have to handle your own page
control, but that should be no big deal. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Friday, January 13, 2006 5:48 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UD] Active select list in BASIC

I have a simple program that looks like:

EXECUTE \SSELECT BP\
HEADING "THIS IS A TEST 'CLT'"
LOOP
   READNEXT ID ELSE EXIT
   CRT ID
REPEAT
CRT
CRT "...Exiting program and clearing select list..."
END

When I run it in Pick mode I get the message "Enter  to
continue..." at the bottom of the 1st screen.  If I enter [Q] to quit,
the program aborts, never prints the exit message, and I'm left at TCL
with the list active (a '>' prompt).

This is not at all what I expected, and after several hours of
research I can't find anything close to a resolution.

Any help would be appreciated.

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

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.17/228 - Release Date:
1/12/2006
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] Active select list in BASIC

[David A. Green]

Bill,

You can turn this feature off by using an @ print command i.e. PRINT @(-1)
or if you don't want to clear the screen just do a DMY = @(-1), or issuing
BPIOCPN command.

Thanks,
David A. Green
DAG Consulting


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Friday, January 13, 2006 5:48 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UD] Active select list in BASIC

I have a simple program that looks like:

EXECUTE \SSELECT BP\
HEADING "THIS IS A TEST 'CLT'"
LOOP
   READNEXT ID ELSE EXIT
   CRT ID
REPEAT
CRT
CRT "...Exiting program and clearing select list..."
END

When I run it in Pick mode I get the message "Enter  to
continue..." at the bottom of the 1st screen.  If I enter [Q] to quit, the
program aborts, never prints the exit message, and I'm left at TCL with the
list active (a '>' prompt).

This is not at all what I expected, and after several hours of research I
can't find anything close to a resolution.

Any help would be appreciated.

Bill Haskett
---
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] Active select list in BASIC

[David A. Green]

Also if you get this message and want to finish execution you can do an "N"
to continue without prompting.

Thanks,
David A. Green
DAG Consulting


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Friday, January 13, 2006 5:48 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UD] Active select list in BASIC

I have a simple program that looks like:

EXECUTE \SSELECT BP\
HEADING "THIS IS A TEST 'CLT'"
LOOP
   READNEXT ID ELSE EXIT
   CRT ID
REPEAT
CRT
CRT "...Exiting program and clearing select list..."
END

When I run it in Pick mode I get the message "Enter  to
continue..." at the bottom of the 1st screen.  If I enter [Q] to quit, the
program aborts, never prints the exit message, and I'm left at TCL with the
list active (a '>' prompt).

This is not at all what I expected, and after several hours of research I
can't find anything close to a resolution.

Any help would be appreciated.

Bill Haskett
---
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] FW: sudo

[Robert DunnMiller]

Did you use the visudo command to put yourself in the sudoers file? If not,
the change is not recognized, and you will get the security breach
notification.

Regards,

Robert

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wronkiewicz, Terrie
Sent: Friday, January 13, 2006 06:15
To: u2-users@listserver.u2ug.org
Subject: [U2] FW: sudo

Hi All,

I am attempting to make sudo work for our IS users with unix level
access.  I have put myself in the sudoers file as follows:

myloginname ourtestboxname = PASSWD:ALL

However when I do:  sudo ls -al

It says:

myloginname is not in the sudoers file.  This incident will be reported.

What am I doing wrong?

Thanks,
Terrie
---
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] FW: sudo

[Michael Doyle]

Two questions:

Which platform are you on, and how are you editing the sudoers file? On
RHEL, you can't just edit the file, you use the command visudo which
will "file and compile" the sudoers file, so to speak.

Mike Doyle
Unix Developer / Administrator
AMO Recoveries


On Fri, 2006-01-13 at 07:14 -0500, Wronkiewicz, Terrie wrote:
> Hi All,
> 
> I am attempting to make sudo work for our IS users with unix level
> access.  I have put myself in the sudoers file as follows:
> 
> myloginname ourtestboxname = PASSWD:ALL
> 
> However when I do:  sudo ls -al
> 
> It says:
> 
> myloginname is not in the sudoers file.  This incident will be reported.
> 
> What am I doing wrong?
> 
> Thanks,
> Terrie
> ---
> 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] Active select list in BASIC

[u2]

Which feature is the problem? That ending the paging ends the program,
or that afterwards you have an active select list?

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
> Sent: Friday, January 13, 2006 5:48 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] [UD] Active select list in BASIC
> 
> I have a simple program that looks like:
> 
> EXECUTE \SSELECT BP\
> HEADING "THIS IS A TEST 'CLT'"
> LOOP
>READNEXT ID ELSE EXIT
>CRT ID
> REPEAT
> CRT
> CRT "...Exiting program and clearing select list..."
> END
> 
> When I run it in Pick mode I get the message "Enter  line> to continue..." at the bottom of the 1st screen.  If I 
> enter [Q] to quit, the program aborts, never prints the exit 
> message, and I'm left at TCL with the list active (a '>' prompt).
> 
> This is not at all what I expected, and after several hours 
> of research I can't find anything close to a resolution.
> 
> Any help would be appreciated.
> 
> Bill Haskett
> ---
> 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] FW: sudo

[karlp]

I believe the visudo command is for SELinux versions so if SELinux isn't
install on the RH box, if that's what it is, then you don't have to worry
about it. I've always just edited /etc/sudoers and added the line this
way:

mylogin name ALL=(ALL) NOPASSWD: ALL

You don't have to do it that way, you can put the line this way:

mylogin  ALL=(ALL) ALL

Or you can put specific things in, such as:

%users ALL=/sbin/mount /cdrom,/sbin/umount /cdrom

The last one allows anyone who is partof the group 'users' to mount and
unmount CDs only.

HTH.

Karl


> Two questions:
>
> Which platform are you on, and how are you editing the sudoers file? On
> RHEL, you can't just edit the file, you use the command visudo which
> will "file and compile" the sudoers file, so to speak.
>
> Mike Doyle
> Unix Developer / Administrator
> AMO Recoveries
>
>
> On Fri, 2006-01-13 at 07:14 -0500, Wronkiewicz, Terrie wrote:
>> Hi All,
>>
>> I am attempting to make sudo work for our IS users with unix level
>> access.  I have put myself in the sudoers file as follows:
>>
>> myloginname ourtestboxname = PASSWD:ALL
>>
>> However when I do:  sudo ls -al
>>
>> It says:
>>
>> myloginname is not in the sudoers file.  This incident will be reported.
>>
>> What am I doing wrong?
>>
>> Thanks,
>> Terrie
>> ---
>> 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/
>


-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\<._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UD] Active select list in BASIC

[Martin Phillips]

Why is this not what you expected? You have asked it to print a paginated
list of record ids and you have quit out with an active select list. Sounds
right to me.

Typing Q isn't going to exit the loop and hit your message. It terminates
the program entirely. If you want to catch the Q yourself, you will have to
do your own pagination control rather than using HEADING to enable automatic
pagination.


Martin Phillips
Ladybridge Systems
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/

[U2] Re: EDA Tool - Unable to save EDA map content

[Simon Lewington]

"Simon Lewington"...
> I'm trying to set up EDA using the 'EDA tool', and getting an error when
> trying to create the EDA map.
...
> Error dialog:
> Title: 'Save EDA map Content Failed'

UK support came through on this one.  For some reason my VOC did not have
the _EDAMAP_ and _EDAXMAP_ entries.  This isn't duplicate-able on another
server here, so I have created the items manually and all is working.

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

RE: [U2] [UDT] Stack following user and causing core dumps?

[Raymond DeGennaro II]

At 17:55 -0800 2006/01/12, <[EMAIL PROTECTED]> wrote:

Never had a command stack big enough to cause problems.


This is a first for us too.

Since it's being called from the Unix command line could you not 
simply clear the stack prior to running the command?


That would take some coding changes because it's actually a service 
that calls UniData.  I'll look at clearing the stack on the way out.


Or you could set the CSTACKSZ environment variable for this user so 
it won't get so big.


Unfortunately, that seems only to control the displayed stack depth. 
The problem eventually occurs even if CSTACKSZ is set to 5



We have a directory under UniData home called cmdstack and it puts all
of the stacks in there so they work across all accounts. Not exactly
sure how it was setup.


I'll have to look for that at the client site.  Maybe a simple cron 
job would to the trick.


Ray
--
.=.
| =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= |
| -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- |
|      |
|Midwest Regional Office: 815-547-0662 (voice)  815-547-0353 (Fax)|
.=.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] FW: sudo

[Jeffrey Butera]

On Friday 13 January 2006 10:19, [EMAIL PROTECTED] wrote:
> I believe the visudo command is for SELinux versions so if SELinux isn't
> install on the RH box, if that's what it is, then you don't have to worry
> about it.

Not true.  visudo has been on every box I've ever used (RedHat, Fedora, 
Solaris...) and it's the proper way to edit the sudoers file.  That's why it 
states:

# This file MUST be edited with the 'visudo' command as root.

visudo may not be found because of path issues - it's usually in /usr/sbin, 
/sbin or /usr/local/sbin.
-- 
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

"We make moral decisions everyday even if we don't know it."
Scott Simon (NPR) on the death of 20,000 coal miners annually in China.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] FW: sudo

[karlp]

> On Friday 13 January 2006 10:19, [EMAIL PROTECTED] wrote:
>> I believe the visudo command is for SELinux versions so if SELinux isn't
>> install on the RH box, if that's what it is, then you don't have to
>> worry
>> about it.
>
> Not true.  visudo has been on every box I've ever used (RedHat, Fedora,
> Solaris...) and it's the proper way to edit the sudoers file.  That's why
> it
> states:
>
> # This file MUST be edited with the 'visudo' command as root.

I've never seen that in the files I've edited. I don't edit it much and
have probably just gotten used to looking past most of the # lines. But,
learn something new every day. I've never had a problem, however, with the
manual editing of the file. It's always worked.

Karl (not a Ph.D., obviously)

>
> visudo may not be found because of path issues - it's usually in
> /usr/sbin,
> /sbin or /usr/local/sbin.
> --
> Jeff Butera, Ph.D.
> Administrative Systems
> Hampshire College
> [EMAIL PROTECTED]
> 413-559-5556
>
> "We make moral decisions everyday even if we don't know it."
> Scott Simon (NPR) on the death of 20,000 coal miners annually in China.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>


-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\<._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Callcenter screen pop

[Scott Ballinger]

John,

I have several collection agency customers that run callcenter software
(one is on their 3rd system, each time a different vendor & o/s)
Typically the client software is windows (but some systems have used
wyse terminals) and the server software runs on Solaris, Linux, or
Windows (we even had one that ran on Pick). In every case, we had the
vendor provide the code to interface from their client to mine. On the
wyse terminals we used a product called Faceterm to do windowing &
scripted screen scraping & pasting; for PC based clients we have used
both Accuterm and Procomm Plus (recently just Accuterm). Since the
vendor is providing the client application, I take the view that it is
their responsibility to provide the connectivity from their environment
to mine. So far every vendor (I have worked with 4 different ones so
far) has been able to do this without complaint. Since this always
requires changes to the vendors' application, I don't really see any
other way to get this done. Neither me nor the vendor is interested in
having me hack their source so I can make this modification (and then
have them support it?!).

As you suggested, the pick application needs to be logged on and the
appropriate program started and waiting at an input prompt. The
callcenter application changes windows from their window to the accuterm
window, then pushes the appropriate text string into my program. From
there is it pretty straight forward. When the agent is done they leave
the pick application at the input prompt and switch back to the
callcenter application window (usually via a programmed function key or
mouse click) and tell the callcenter program that they are ready for
another call.

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Hester
Sent: Monday, January 09, 2006 3:34 PM
To: U2 Users Discussion List
Subject: [U2] [UV] Callcenter screen pop

We're looking into new call center software and trying to determine to
what degree we can integrate incoming call handling with our UV order
entry software.  Assuming that we've captured either a phone # via
caller ID or a customer account number by having them key it in, does
anyone know of a way to push this information into a green-screen UV
application?  The call center software packages we've looked into a
Windows based, and we use Accuterm to run our UV applications.  The only
way I can see this working is if the customer service agent is sitting
at the appropriate order entry prompt in the UV application prior to
answering the phone (which is acceptable), and the data is then sent to
Accuterm (or some other terminal emulator).  Has anyone done anything
like this?

TIA,
John
--
John Hester
System & Network Administrator
Momentum Group Inc.
(949) 833-8886 x623
http://memosamples.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] FW: sudo

[Jeffrey Butera]

On Friday 13 January 2006 12:21, [EMAIL PROTECTED] wrote:
> >
> > # This file MUST be edited with the 'visudo' command as root.
>
> I've never seen that in the files I've edited. I don't edit it much and
> have probably just gotten used to looking past most of the # lines. But,
> learn something new every day. I've never had a problem, however, with the
> manual editing of the file. It's always worked.

Karl:

I think it's simply a method that visudo uses to lock the file so that if 
someone tries a command while you're editing the file, the command should 
fail.  (But I've been wrong before.)

-- 
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

"We make moral decisions everyday even if we don't know it."
Scott Simon (NPR) on the death of 20,000 coal miners annually in China.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] making a .csv file into an .xls file?

[George Gallen]

Our UV system creates an ASCII .csv file for another
  system to import on a daily basis. The 3rd party software
  after a recent upgrade now only imports .xls files.

Is there an easy way to "automate" Excel to load the .csv,
  then save as .xls?

Or how much more difficult is it to create the .xls instead of
   a .csv?

I thought about getting one of those programs that records
mouse clicks, and create a macro of the conversion (since the
filename is the same each day), but wonder if there was
something we could do in a batch file and run every day under
the Windows scheduler.

George

George Gallen
Senior Programmer/Analyst
Accounting/Data Division
[EMAIL PROTECTED]
ph:856.848.1000 Ext 220

SLACK Incorporated - Delivering the best in health care information and
education worldwide.
http://www.slackinc.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] making a .csv file into an .xls file?

[Ray Wurlod]

The BAT file could open the CSV file in Excel then save as XLS and quit.
Or you could have a startup macro in Excel that did the save and quit if the 
CSV file is on the command line; anyone else can open the XLS.  You may need to 
rename/delete the existing XLS file first.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] making a .csv file into an .xls file?

[Scott Ballinger]

I think Accuterm can create a legit .xls file on a windows client with
the FT utility. This is easily scripted from the UV side.

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of George Gallen
Sent: Friday, January 13, 2006 11:46 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] making a .csv file into an .xls file?

Our UV system creates an ASCII .csv file for another
  system to import on a daily basis. The 3rd party software
  after a recent upgrade now only imports .xls files.

Is there an easy way to "automate" Excel to load the .csv,
  then save as .xls?

Or how much more difficult is it to create the .xls instead of
   a .csv?

I thought about getting one of those programs that records mouse clicks,
and create a macro of the conversion (since the filename is the same
each day), but wonder if there was something we could do in a batch file
and run every day under the Windows scheduler.

George

George Gallen
Senior Programmer/Analyst
Accounting/Data Division
[EMAIL PROTECTED]
ph:856.848.1000 Ext 220

SLACK Incorporated - Delivering the best in health care information and
education worldwide.
http://www.slackinc.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] making a .csv file into an .xls file?

[Tony Gravagno]

George Gallen wrote:
> Is there an easy way to "automate" Excel to load the .csv,
>   then save as .xls?
> Or how much more difficult is it to create the .xls
>instead of a .csv?

This can be done with VBA scripting or with some code and Visual Studio
Tools for Office.  VSTO has a benefit that it allows Office apps to be used
effectively as servers, without worrying about UI issues.  That has always
been a serious concern because some dialog could popup from an automated
process and wait for a user response - not good for an unattended or
background process.  So it's much easier now to develop utilities as you
describe that manipulate Word or Excel documents from a command line or in
a Windows Service than it used to be.

As to how to do this... There are thousands of web resources available for
this sort of thing, code samples, HowTo's, and products of various cost and
complexity.  I can write a Windows Service that will watch a directory and
convert any csv written there into an xls.  If you need it done, this is
the sort of code I write for a living.

Tony
TG@ removethisNebula-Rnd.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UV: Other ways of replicating?

[Scott Ballinger]

Could you use UV replication for the hashed files, and rsync for the
type 1 & 19 files? Depending on your use of those directory type
"files", this might accommodate your needs (as long as the hashed files
and directory "files" are not linked together with transaction
bracketing, etc, and your application could handle them being out of
sync a little.

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Doyle
Sent: Wednesday, January 11, 2006 6:58 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UV: Other ways of replicating?

UniVerse users,


Recently, we've been looking at ways of developing a high availability
cluster for our production UniVerse environment. Thanks to
www.linux-ha.org we've been able to install two machines at different
locations (cities twenty miles apart) and if the primary machine drops,
users can log into the same IP address within a few seconds. The problem
we have run into is replicating our data across the two nodes.

The best way would be database replication. Unfortunately, UniVerse
can't replicate the type 1 and type 19 files, which we use extensively.
Further, we cannot use ALTER.TABLE or CLEAR.FILE on replicated files.
(These from the Administrators manual.)

The second option we've looked at is some sort of disk replication. IBM
recommends DRBD for use with DB2. Unfortunately, it seems that this
would not provide referential integrity.

The third option we looked at was a complicated mix of transaction logs
and NFS mounts. Our standby box would be constantly updating itself off
of the transaction logs of the primary. In the event of an outage, the
standby comes up more or less updated and the dead primary can refresh
itself off of the standby's logs when it comes back up.

Does anyone have any experience getting around the shortcomings of
UniVerse's replication?

Thanks,

Mike Doyle
Unix Developer / Administrator
---
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] making a .csv file into an .xls file?

[Gordon J Glorfield]

Gordon J. Glorfield
Sr. Applications Developer
MAMSI (A UnitedHealth Company)
301-360-8839

[EMAIL PROTECTED] wrote on 01/13/2006 02:45:46 PM:

> Our UV system creates an ASCII .csv file for another
> system to import on a daily basis. The 3rd party software
> after a recent upgrade now only imports .xls files.

How particular is the 3rd party software?  Excel is happy to load a csv 
file that has had it's extension changed from .csv to .xls.  Would that 
work for your needs?
 
> Is there an easy way to "automate" Excel to load the .csv,
> then save as .xls?

Yes you can.  Create a macro in an Excel spreadsheet that does the 
conversion.  Have the Workbook_Open subroutine run the macro.  Set the 
windows scheduler to open the spreadsheet at the desired time and viola!

> 
> Or how much more difficult is it to create the .xls instead of
> a .csv?
> 
> I thought about getting one of those programs that records
> mouse clicks, and create a macro of the conversion (since the
> filename is the same each day), but wonder if there was
> something we could do in a batch file and run every day under
> the Windows scheduler.

Excel has that capture keystrokes in a macro capability built right in.

> George

[snip]


This e-mail, including attachments, may include confidential and/or 
proprietary information, and may be used only by the person or entity to 
which it is addressed. If the reader of this e-mail is not the intended 
recipient or his or her authorized agent, the reader is hereby notified 
that any dissemination, distribution or copying of this e-mail is 
prohibited. If you have received this e-mail in error, please notify the 
sender by replying to this message and delete this e-mail immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] making a .csv file into an .xls file?

[Michael Doyle]

On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and
Text::CSV modules. My csv2xls.pl script is only about 47 lines long.

The Spreadsheet::WriteExcel module was utter garbage a few years ago,
but thanks to the efforts of OpenOffice.org and the obvious benefits of
open source software, the module has improved by leaps and bounds.

On Windows, I can only presume that Visual Basic can generate Excel
spreadsheets.

Mike Doyle
Unix Developer / Administrator
AMO Recoveries


On Fri, 2006-01-13 at 14:45 -0500, George Gallen wrote:
> Our UV system creates an ASCII .csv file for another
>   system to import on a daily basis. The 3rd party software
>   after a recent upgrade now only imports .xls files.
> 
> Is there an easy way to "automate" Excel to load the .csv,
>   then save as .xls?
> 
> Or how much more difficult is it to create the .xls instead of
>a .csv?
> 
> I thought about getting one of those programs that records
> mouse clicks, and create a macro of the conversion (since the
> filename is the same each day), but wonder if there was
> something we could do in a batch file and run every day under
> the Windows scheduler.
> 
> George
> 
> George Gallen
> Senior Programmer/Analyst
> Accounting/Data Division
> [EMAIL PROTECTED]
> ph:856.848.1000 Ext 220
> 
> SLACK Incorporated - Delivering the best in health care information and
> education worldwide.
> http://www.slackinc.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] [UD] Active select list in BASIC

[Bill Haskett]

David, Kevin and Ed:

Thanks for the tip.  My question was the select list remaining active,
rather than the page message or the program aborting.  Although the program
aborting sucks, it has always occurred in pick-like systems.

In all Pick systems I've ever used, Microdata, Adds, GA, R83, R91, D3, and
UV, when a file is selected then listed, within BASIC, quiting the display
doesn't leave the select list active.  How can I turn off this unexpected
feature?

Thanks again, 

Bill

P.S. It looks fortunate that I only have a couple of programs that do this,
like the list-files program.  :-)
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> David A. Green
> Sent: Friday, January 13, 2006 6:00 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] [UD] Active select list in BASIC
> 
> Bill,
> 
> You can turn this feature off by using an @ print command 
> i.e. PRINT @(-1) or if you don't want to clear the screen 
> just do a DMY = @(-1), or issuing BPIOCPN command.
> 
> Thanks,
> David A. Green
> DAG Consulting
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
> Sent: Friday, January 13, 2006 5:48 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] [UD] Active select list in BASIC
> 
> I have a simple program that looks like:
> 
> EXECUTE \SSELECT BP\
> HEADING "THIS IS A TEST 'CLT'"
> LOOP
>READNEXT ID ELSE EXIT
>CRT ID
> REPEAT
> CRT
> CRT "...Exiting program and clearing select list..."
> END
> 
> When I run it in Pick mode I get the message "Enter  line> to continue..." at the bottom of the 1st screen.  If I 
> enter [Q] to quit, the program aborts, never prints the exit 
> message, and I'm left at TCL with the list active (a '>' prompt).
> 
> This is not at all what I expected, and after several hours 
> of research I can't find anything close to a resolution.
> 
> Any help would be appreciated.
> 
> Bill Haskett
> ---
> 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] making a .csv file into an .xls file?

[Don Verhagen]

Or you can use a PERL script to take a File that is delimited by @AM (rows) and 
@VM (columns) and create an XLS binary file. I currently do this on an HPUX 
11.x running Unidata 6.X. Did I mention it was free?

Email me offline if you would like details.

Thanks,


* Please NOTE NEW ADDRESS AND TELELPHONE Numbers * 
--
Donald Verhagen 
Application Development Manager
[EMAIL PROTECTED]
Tandem Staffing Solutions, Inc.
5901 Broken Sound Parkway NW, Suite 450
Boca Raton, FL 33487 USA
Voice Phone: 561.226.8261 Fax Phone: 561.226.8115

>>> [EMAIL PROTECTED] 2:45 pm 01/13/2006 >>>
Our UV system creates an ASCII .csv file for another
  system to import on a daily basis. The 3rd party software
  after a recent upgrade now only imports .xls files.

Is there an easy way to "automate" Excel to load the .csv,
  then save as .xls?

Or how much more difficult is it to create the .xls instead of
   a .csv?

I thought about getting one of those programs that records
mouse clicks, and create a macro of the conversion (since the
filename is the same each day), but wonder if there was
something we could do in a batch file and run every day under
the Windows scheduler.

George

George Gallen
Senior Programmer/Analyst
Accounting/Data Division
[EMAIL PROTECTED] 
ph:856.848.1000 Ext 220

SLACK Incorporated - Delivering the best in health care information and
education worldwide.
http://www.slackinc.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: Other ways of replicating?

[John Hester]

Michael Doyle wrote:

Recently, we've been looking at ways of developing a high availability
cluster for our production UniVerse environment. Thanks to
www.linux-ha.org we've been able to install two machines at different
locations (cities twenty miles apart) and if the primary machine drops,
users can log into the same IP address within a few seconds. The problem
we have run into is replicating our data across the two nodes.


We're replicating UV at the OS level on RH linux with Steeleye's 
LifeKeeper software:


http://www.steeleye.com

The backup machine keeps an entire external raid set synched at the 
block level.  Should the primary machine fail or stop responding over 
the network, the backup machine shuts off power to the primary machine, 
assumes its IP address, mounts the filesystems on the raid set, and 
starts all necessary services (one of which is UV).  We experienced some 
crashes due to a kernel bug early on, so we've tested this setup in a 
production environment.  We never experienced any UV file corruption 
after a failover.


Our machines are in the same datacenter though, with a gigabit ethernet 
connection between them - not 20 miles apart like yours.  I don't know 
if you could do this over a WAN connection.  The people at Steeleye 
should be able to tell you though.


-John
--
John Hester
System & Network Administrator
Momentum Group Inc.
(949) 833-8886 x623
http://memosamples.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] making a .csv file into an .xls file?

[Eric Armstrong]

You can use the wizard in Excel to create a macro to change the file type
and then call the macro whenever Excel is started up. Or you can use
Automation to change the file type whenever Excel (or any Automation-aware
application) is started.

Eric Armstrong
Programmer/Analyst
Lobel Financial
714.816.1207


-Original Message-
From: George Gallen [mailto:[EMAIL PROTECTED]
Sent: Friday, January 13, 2006 11:46 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] making a .csv file into an .xls file?


Our UV system creates an ASCII .csv file for another
  system to import on a daily basis. The 3rd party software
  after a recent upgrade now only imports .xls files.

Is there an easy way to "automate" Excel to load the .csv,
  then save as .xls?

Or how much more difficult is it to create the .xls instead of
   a .csv?

I thought about getting one of those programs that records
mouse clicks, and create a macro of the conversion (since the
filename is the same each day), but wonder if there was
something we could do in a batch file and run every day under
the Windows scheduler.

George

George Gallen
Senior Programmer/Analyst
Accounting/Data Division
[EMAIL PROTECTED]
ph:856.848.1000 Ext 220

SLACK Incorporated - Delivering the best in health care information and
education worldwide.
http://www.slackinc.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] making a .csv file into an .xls file?

[Dave S]

I don't think Unisplat can create an xls from csv.

Gordon J Glorfield <[EMAIL PROTECTED]> wrote:  Gordon J. Glorfield
Sr. Applications Developer
MAMSI (A UnitedHealth Company)
301-360-8839

[EMAIL PROTECTED] wrote on 01/13/2006 02:45:46 PM:

> Our UV system creates an ASCII .csv file for another
> system to import on a daily basis. The 3rd party software
> after a recent upgrade now only imports .xls files.

How particular is the 3rd party software? Excel is happy to load a csv 
file that has had it's extension changed from .csv to .xls. Would that 
work for your needs?

> Is there an easy way to "automate" Excel to load the .csv,
> then save as .xls?

Yes you can. Create a macro in an Excel spreadsheet that does the 
conversion. Have the Workbook_Open subroutine run the macro. Set the 
windows scheduler to open the spreadsheet at the desired time and viola!

> 
> Or how much more difficult is it to create the .xls instead of
> a .csv?
> 
> I thought about getting one of those programs that records
> mouse clicks, and create a macro of the conversion (since the
> filename is the same each day), but wonder if there was
> something we could do in a batch file and run every day under
> the Windows scheduler.

Excel has that capture keystrokes in a macro capability built right in.

> George

[snip]


This e-mail, including attachments, may include confidential and/or 
proprietary information, and may be used only by the person or entity to 
which it is addressed. If the reader of this e-mail is not the intended 
recipient or his or her authorized agent, the reader is hereby notified 
that any dissemination, distribution or copying of this e-mail is 
prohibited. If you have received this e-mail in error, please notify the 
sender by replying to this message and delete this e-mail immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/




-
Yahoo! Photos
 Ring in the New Year with Photo Calendars. Add photos, events, holidays, 
whatever.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] making a .csv file into an .xls file?

[Kent Walker]

George,

Mike is right - a Perl script can make the conversion easy and highly 
automated.  However, I like to use TAB-delimited output to avoid the 
occasional messy situation when valid data contains commas or 
quotes.  Write the program or paragraph such that it generates a text 
file and then shells to the Perl program to do the conversion.


ActiveState's Perl for Windows does have the 
"Spreadsheet::WriteExcel" and "Text::CSV" modules available.


Let me know if you want some samples to hack.

Kent

At 01:02 PM 1/13/2006, Michael Doyle wrote:


On UNIX, use Perl. Specifically, use the Spreadsheet::WriteExcel and
Text::CSV modules. My csv2xls.pl script is only about 47 lines long.

The Spreadsheet::WriteExcel module was utter garbage a few years ago,
but thanks to the efforts of OpenOffice.org and the obvious benefits of
open source software, the module has improved by leaps and bounds.

On Windows, I can only presume that Visual Basic can generate Excel
spreadsheets.

Mike Doyle
Unix Developer / Administrator
AMO Recoveries


On Fri, 2006-01-13 at 14:45 -0500, George Gallen wrote:
> Our UV system creates an ASCII .csv file for another
>   system to import on a daily basis. The 3rd party software
>   after a recent upgrade now only imports .xls files.
>
> Is there an easy way to "automate" Excel to load the .csv,
>   then save as .xls?
>
> Or how much more difficult is it to create the .xls instead of
>a .csv?
>
> I thought about getting one of those programs that records
> mouse clicks, and create a macro of the conversion (since the
> filename is the same each day), but wonder if there was
> something we could do in a batch file and run every day under
> the Windows scheduler.
>
> George
>
> George Gallen
> Senior Programmer/Analyst
> Accounting/Data Division
> [EMAIL PROTECTED]
> ph:856.848.1000 Ext 220
>
> SLACK Incorporated - Delivering the best in health care information and
> education worldwide.
> http://www.slackinc.com
> ---


---
Kent Walker - Datatel Analyst
Information Technology - U.C. Hastings College of the Law
415-565-4635
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] making a .csv file into an .xls file?

[Barry Brevik]

>Is there an easy way to "automate" Excel to load the .csv,
>  then save as .xls?

Or, your universe program can output an XML file which you then name to have
an .xls extension. Excel will open that natively.

In Excel, you can do a FILE | SAVE AS as an XML file to see what Excel is
looking for in an XML format. With XML you can do all kinds of Excel things
like embedding formulas, specifying fonts, colors, multi-rows within single
cells, freezing rows/columns, etc.

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

RE: [U2] [UD] Active select list in BASIC

[David A. Green]

Bill,

This is the way a Select list works.  The IDs that have already been used
via the READNEXT will be gone.

If you'd like you can select to one of the non-active list like 1.

PERFORM "SELECT MYFILE TO 1"
...
LOOP
   READNEXT ID FROM 1 ELSE EXIT
   ...
REPEAT

Thanks,
David A. Green
DAG Consulting


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Friday, January 13, 2006 2:12 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Active select list in BASIC

David, Kevin and Ed:

Thanks for the tip.  My question was the select list remaining active,
rather than the page message or the program aborting.  Although the program
aborting sucks, it has always occurred in pick-like systems.

In all Pick systems I've ever used, Microdata, Adds, GA, R83, R91, D3, and
UV, when a file is selected then listed, within BASIC, quiting the display
doesn't leave the select list active.  How can I turn off this unexpected
feature?

Thanks again, 

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

RE: [U2] making a .csv file into an .xls file?

[Keith Johnson]

Cedarville university has a program called DOWNLOAD that can do both
file types and others that works perfectly with UNIDATA...  (It has
never error-ed on me in 5 yrs.)
It is free for higher ED institutions.  I am not sure about the rest of
the world...  I bet it would work well for you.  It can make DB2 and all
kinds of file types...  

-Keith


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of George Gallen
Sent: Friday, January 13, 2006 11:46 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] making a .csv file into an .xls file?

Our UV system creates an ASCII .csv file for another
  system to import on a daily basis. The 3rd party software
  after a recent upgrade now only imports .xls files.

Is there an easy way to "automate" Excel to load the .csv,
  then save as .xls?

Or how much more difficult is it to create the .xls instead of
   a .csv?

I thought about getting one of those programs that records
mouse clicks, and create a macro of the conversion (since the
filename is the same each day), but wonder if there was
something we could do in a batch file and run every day under
the Windows scheduler.

George

George Gallen
Senior Programmer/Analyst
Accounting/Data Division
[EMAIL PROTECTED]
ph:856.848.1000 Ext 220

SLACK Incorporated - Delivering the best in health care information and
education worldwide.
http://www.slackinc.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] [UD] Active select list in BASIC

[u2]

It never made any sense to me why unidata did this, and I never found a
setting that would change it. I got around it by always putting select
lists into variables. i.e:

EXECUTE \SSELECT BP\
SELECT TO BPLIST
HEADING "THIS IS A TEST 'CLT'"
LOOP
   READNEXT ID FROM BPLIST ELSE EXIT
   CRT ID
REPEAT
CRT
CRT "...Exiting program and clearing select list..."
END

Which seemed to work (not sure if the above example works as is--I don't
have a unidata system to test it on. I seem to recall that maybe there
had to be a file open, or the BPLIST variable needed to be assigned
ahead of time for it to work)
In ADDS, it was possible to prevent a user from exiting out of a paged
list like that--I think you have to have break off or something like
that.
Universe can be made to return an active select list to TCL. One of the
options in the VOC catalog entry for the program controls that (I think
it's K) but I don't think it returns a default list that has been
partially used. The numbered select lists 1-10 (not 0) are persistent
like that though.

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
> Sent: Friday, January 13, 2006 4:12 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] [UD] Active select list in BASIC
> 
> 
> David, Kevin and Ed:
> 
> Thanks for the tip.  My question was the select list 
> remaining active, rather than the page message or the program 
> aborting.  Although the program aborting sucks, it has always 
> occurred in pick-like systems.
> 
> In all Pick systems I've ever used, Microdata, Adds, GA, R83, 
> R91, D3, and UV, when a file is selected then listed, within 
> BASIC, quiting the display doesn't leave the select list 
> active.  How can I turn off this unexpected feature?
> 
> Thanks again, 
> 
> Bill
> 
> P.S. It looks fortunate that I only have a couple of programs 
> that do this, like the list-files program.  :-)
>  
> 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of 
> > David A. Green
> > Sent: Friday, January 13, 2006 6:00 AM
> > To: u2-users@listserver.u2ug.org
> > Subject: RE: [U2] [UD] Active select list in BASIC
> > 
> > Bill,
> > 
> > You can turn this feature off by using an @ print command
> > i.e. PRINT @(-1) or if you don't want to clear the screen 
> > just do a DMY = @(-1), or issuing BPIOCPN command.
> > 
> > Thanks,
> > David A. Green
> > DAG Consulting
> > 
> > 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of 
> Bill Haskett
> > Sent: Friday, January 13, 2006 5:48 AM
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] [UD] Active select list in BASIC
> > 
> > I have a simple program that looks like:
> > 
> > EXECUTE \SSELECT BP\
> > HEADING "THIS IS A TEST 'CLT'"
> > LOOP
> >READNEXT ID ELSE EXIT
> >CRT ID
> > REPEAT
> > CRT
> > CRT "...Exiting program and clearing select list..."
> > END
> > 
> > When I run it in Pick mode I get the message "Enter  > line> to continue..." at the bottom of the 1st screen.  If I
> > enter [Q] to quit, the program aborts, never prints the exit
> > message, and I'm left at TCL with the list active (a '>' prompt).
> > 
> > This is not at all what I expected, and after several hours
> > of research I can't find anything close to a resolution.
> > 
> > Any help would be appreciated.
> > 
> > Bill Haskett
> > ---
> > 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] making a .csv file into an .xls file?

[Kim Colwell]

Keith Johnson wrote:

> Cedarville university has a program called DOWNLOAD that can do both
> file types and others that works perfectly with UNIDATA...  (It has
> never error-ed on me in 5 yrs.)
> It is free for higher ED institutions.  I am not sure about the rest of
> the world...  I bet it would work well for you.  It can make DB2 and all
> kinds of file types...
>
> -Keith

Keith,

I would like to examine this package & it's uses ... how do I get a copy ???

Kim Colwell
Director of Administrative Data Systems
Danville Area Community College
2000 E. Main Street
Danville, IL 61832
[EMAIL PROTECTED]
127 443-8769
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UO.NET registry exception in method dealing with performance counters

[Glenn Batson]

I had a question a couple of weeks back regarding the subject line.  As
part of that message I stated I had lost the exception that UO.NET was
throwing.  Well I finally got it replicated again on a new server.
Below is the exception.  As was mentioned in the earlier email,
assigning Local System to the Application Pool identity for IIS, fixed
the exception and then I could set it back to Network Services.  So I'm
real certain this has to do with IIS not having enough permissions to do
the registry update.  Does anyone have ideas on how to accomplish this,
without changing the Application Pool identity?

Glenn Batson

Server Error in '/' Application.



Security Exception 
Description: The application attempted to perform an operation not
allowed by the security policy. To grant this application the required
permission please contact your system administrator or change the
application's trust level in the configuration file. 

Exception Details: System.Security.SecurityException: Requested registry
access is not allowed.

Source Error: 

An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.  

Stack Trace: 


[SecurityException: Requested registry access is not allowed.]
   Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable)
+473
   System.Diagnostics.PerformanceCounterLib.CreateRegistryEntry(String
machineName, String categoryName, CounterCreationDataCollection
creationData, Boolean& iniRegistered) +184
   System.Diagnostics.PerformanceCounterLib.RegisterCategory(String
machineName, String categoryName, String categoryHelp,
CounterCreationDataCollection creationData) +43
   System.Diagnostics.PerformanceCounterCategory.Create(String
categoryName, String categoryHelp, CounterCreationDataCollection
counterData, String machineName, String localizedIniFilePath) +923
   System.Diagnostics.PerformanceCounterCategory.Create(String
categoryName, String categoryHelp, CounterCreationDataCollection
counterData) +17
   IBMU2.UODOTNET.UniPerfCounter..ctor() +782
   IBMU2.UODOTNET.UniObjects.set_UOPooling(Boolean value) +90
   Jenkon.Web.BusinessObjects.WBO..cctor() in
C:\Inetpub\wwwroot\Branches\2.3.0-IH4\WebBusinessObjects\WBO.cs:77

 




Version Information: Microsoft .NET Framework Version:1.1.4322.2300;
ASP.NET Version:1.1.4322.2300
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] Active select list in BASIC

[Bill Haskett]

David & Ed:

Thank you.  The "SELECT TO BPLIST" (I couldn't get the SELECT TO 1 then the
READNEXT FROM 1 to compile) works fine as long as I assign BPLIST a value
before using it (another quirk with UniData).  :-)

I wish the "quirky things that don't work like PICK" would be listed
somewhere.  It'd sure save me a lot of time.  :-)

Thanks again,

Bill
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> [EMAIL PROTECTED]
> Sent: Friday, January 13, 2006 3:32 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] [UD] Active select list in BASIC
> 
> It never made any sense to me why unidata did this, and I 
> never found a setting that would change it. I got around it 
> by always putting select lists into variables. i.e:
> 
> EXECUTE \SSELECT BP\
> SELECT TO BPLIST
> HEADING "THIS IS A TEST 'CLT'"
> LOOP
>READNEXT ID FROM BPLIST ELSE EXIT
>CRT ID
> REPEAT
> CRT
> CRT "...Exiting program and clearing select list..."
> END
> 
> Which seemed to work (not sure if the above example works as 
> is--I don't have a unidata system to test it on. I seem to 
> recall that maybe there had to be a file open, or the BPLIST 
> variable needed to be assigned ahead of time for it to work) 
> In ADDS, it was possible to prevent a user from exiting out 
> of a paged list like that--I think you have to have break off 
> or something like that.
> Universe can be made to return an active select list to TCL. 
> One of the options in the VOC catalog entry for the program 
> controls that (I think it's K) but I don't think it returns a 
> default list that has been partially used. The numbered 
> select lists 1-10 (not 0) are persistent like that though.
> 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of 
> Bill Haskett
> > Sent: Friday, January 13, 2006 4:12 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: RE: [U2] [UD] Active select list in BASIC
> > 
> > 
> > David, Kevin and Ed:
> > 
> > Thanks for the tip.  My question was the select list 
> remaining active, 
> > rather than the page message or the program aborting.  Although the 
> > program aborting sucks, it has always occurred in pick-like systems.
> > 
> > In all Pick systems I've ever used, Microdata, Adds, GA, 
> R83, R91, D3, 
> > and UV, when a file is selected then listed, within BASIC, 
> quiting the 
> > display doesn't leave the select list active.  How can I 
> turn off this 
> > unexpected feature?
> > 
> > Thanks again,
> > 
> > Bill
> > 
> > P.S. It looks fortunate that I only have a couple of 
> programs that do 
> > this, like the list-files program.  :-)
> >  
> > 
> > > -Original Message-
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED] On Behalf Of David A. 
> > > Green
> > > Sent: Friday, January 13, 2006 6:00 AM
> > > To: u2-users@listserver.u2ug.org
> > > Subject: RE: [U2] [UD] Active select list in BASIC
> > > 
> > > Bill,
> > > 
> > > You can turn this feature off by using an @ print command 
> i.e. PRINT 
> > > @(-1) or if you don't want to clear the screen just do a DMY = 
> > > @(-1), or issuing BPIOCPN command.
> > > 
> > > Thanks,
> > > David A. Green
> > > DAG Consulting
> > > 
> > > 
> > > -Original Message-
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED] On Behalf Of
> > Bill Haskett
> > > Sent: Friday, January 13, 2006 5:48 AM
> > > To: u2-users@listserver.u2ug.org
> > > Subject: [U2] [UD] Active select list in BASIC
> > > 
> > > I have a simple program that looks like:
> > > 
> > > EXECUTE \SSELECT BP\
> > > HEADING "THIS IS A TEST 'CLT'"
> > > LOOP
> > >READNEXT ID ELSE EXIT
> > >CRT ID
> > > REPEAT
> > > CRT
> > > CRT "...Exiting program and clearing select list..."
> > > END
> > > 
> > > When I run it in Pick mode I get the message "Enter  > > line> to continue..." at the bottom of the 1st screen.  If I
> > > enter [Q] to quit, the program aborts, never prints the exit 
> > > message, and I'm left at TCL with the list active (a '>' prompt).
> > > 
> > > This is not at all what I expected, and after several hours of 
> > > research I can't find anything close to a resolution.
> > > 
> > > Any help would be appreciated.
> > > 
> > > Bill Haskett
> > > ---
> > > 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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/