Re: Converting Text to XLS

[Fran Hensler]

Richard -

I often send CSV files with a .txt extension.  I use a TAB X'05' as a
delimiter which is the default for for .txt files.

The files are sent to user's network drive.  They start Excel, OPEN
the file and Excel recognizes the TAB delimiters and automatically
pulls the file into the spreadsheet.  Only one thing for the user to
do:  Select all, click Format -> Column -> Autofit selection.

I get no complaint from user about having to do this format.

/Fran Hensler at Slippery Rock University of Pennsylvania USA for 46 years
mailto:f...@zvm.sru.edu  http://zvm.sru.edu/~fjh  +1.724.738.2153
  "Yes, Virginia, there is a Slippery Rock"
--

Re: Converting Text to XLS

[Dave Wade]

Why Excel then? What about HTML, Postscript or PDF?
Or to be really devious send them a REXX Script that runs in Regina, creates
a spread sheet and then loads data in using OLE/COM/Active X. Kind of like
using Windows as a batch processor 
 
Dave
G4UGM
Illegitimi Non Carborundum

-Original Message-
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: 20 April 2010 22:27
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS


I want them to have a consistent view when it is received. I don't give a
damn what they do with it afterward.
 

Regards, 
Richard Schuh 

 

 


  _  

From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Frank M. Ramaekers
Sent: Tuesday, April 20, 2010 12:28 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS



.and you don't want to have to "futz" with Excel macros or scripts?

 

 


Frank M. Ramaekers Jr.

 

 


  _  


From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: Tuesday, April 20, 2010 1:19 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

 

Right now, I am creating a csv file using tab (x'05', which is also the
default field separator in Pipelines) characters as a separator. Since I do
not have control of the width of cells, I need to be able to selectively
specify whether to align right or left and top or bottom in the cells of a
column. I suppose I could use a multiple pass process where I get the max
size of a cell in each column and create fixed size cells and align things
myself. Then, there are such things as table and column headings and
anything else needed to make it print friendly.  Even then, the output would
still be a text file. not xls.

 

The short of it is, I am trying to make it so that the recipient does not
have to futz with formats or headings when the file is opened by Excel. I
have seen some really strange formats when looking at files that people (in
ISO, but I will give them the benefit of the doubt) have messed up.

Regards, 
Richard Schuh 

 

 

 


  _  


From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Wandschneider, Scott
Sent: Tuesday, April 20, 2010 10:40 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

I create several text files on CMS where I use the > or < character as a
delimiter and surround special text with ".

 

Thank you,

 

Scott

 

From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: Tuesday, April 20, 2010 12:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS

 

Does anyone know of a program to create an XLS file from a text file on CMS?
The file can be sent as a CSV file attached to an e-mail; however, opening
the CSV file with Excel or other spreadsheet programs exposes a few
formatting problems/inconsistencies that must be fixed by manual
manipulation.

 

Regards, 
Richard Schuh 

 

 

 

Confidentiality Note: This e-mail, including any attachment to it, may
contain material that is confidential, proprietary, privileged and/or
"Protected Health Information," within the meaning of the regulations under
the Health Insurance Portability & Accountability Act as amended. If it is
not clear that you are the intended recipient, you are hereby notified that
you have received this transmittal in error, and any review, dissemination,
distribution or copying of this e-mail, including any attachment to it, is
strictly prohibited. If you have received this e-mail in error, please
immediately return it to the sender and delete it from your system. Thank
you. 

_ This message contains
information which is privileged and confidential and is solely for the use
of the intended recipient. If you are not the intended recipient, be aware
that any review, disclosure, copying, distribution, or use of the contents
of this message is strictly prohibited. If you have received this in error,
please destroy it immediately and notify us at privacy...@ailife.com. 

Re: z/VM not seeing storage from SAN

[Raymond Higgs]

Daniel,

It's much easier to get info about an FCP channel with lszfcp.  You don't 
have to remember those damn sysfs paths that seem to change with each new 
kernel :)

To figure out a subchannel's wwpn do something like this:

r...@m12-205:lszfcp -a -b 0.0.7800
0.0.7800 host64
Bus = "ccw"
availability= "good"
card_version= "0x0006"
cmb_enable  = "0"
cutype  = "1731/03"
devtype = "1732/03"
failed  = "0"
hardware_version= "0x"
in_recovery = "0"
lic_version = "0xbd23"
modalias= "ccw:t1731m03dt1732dm03"
online  = "1"
peer_d_id   = "0x00"
peer_wwnn   = "0x"
peer_wwpn   = "0x"
status  = "0x542a"
uevent  = "DRIVER=zfcp"
Class = "fc_host"
maxframe_size   = "2112 bytes"
node_name   = "0x5005076400c0b742"
permanent_port_name = "0x500507601d80074f" << 
Sent by: The IBM z/VM Operating System 
04/20/2010 02:14 PM
Please respond to
The IBM z/VM Operating System 


To
IBMVM@LISTSERV.UARK.EDU
cc

Subject
Re: z/VM not seeing storage from SAN






No such file exists.. this is the structure of that directory

[root] zvmtestd:/sys/bus/ccw/devices/0.0.5000# ls
availability  devtype   host37   online port_remove  
uevent
card_version  driverin_recovery  peer_d_id  port_rescan
cmb_enablefailedlic_version  peer_wwnn  status
cutypehardware_version  modalias peer_wwpn  subsystem


On Tue, Apr 20, 2010 at 11:24 AM, Richard Troth  
wrote:
I am a little confused about what WWPN goes where in your case. 

Based on prior email, C05076FAE3000400 is the WWPN of your virtual FCP 
adapter (because NPIV is in place).  It starts with a "C".  But 
50060E80042CC20C looks to me more like a storage side WWPN.  What is the 
"real WWPN" of your FCP adapter 5000?  Might start with "5005", though a 
"5006" prefix is certainly also possible.  (Someone who knows FCP better 
than I might know vendor prefixes and things like that.) 

When you had Linux up (instead of CMS), what did you find in these pseudo 
files? 

/sys/bus/ccw/devices/0.0.5000/physical_wwpn 
/sys/bus/ccw/devices/0.0.5000/wwpn 

The latter should be 0xc05076fae3000400.  What is the other? 
(If you did not have NPIV in effect, then the two would match or one be 
zeros.) 

Since you said that you have it working on one or two other systems, how 
to they look by comparison? 

For zoning and masking and all that, it is not clear to me that you need 
to specify the real WWPN (of the HBA, of the FCP adapter) when NPIV is in 
play.  Eric?  What do you say about that?  You certainly DO need to zone 
and mask the storage and the fabric to the virtual WWPN (the one with the 
"C050" prefix). 

-- Rick;   <><






On Tue, Apr 20, 2010 at 09:13, Daniel Tate  wrote:
To answer someone's earlier question, yes, we've seen every redbook 
imaginable related to this, tried to do a direct zfcp attach, set edev.   
I can't give too much info away about our organization but we are using 
cisco san switches, if that makes a difference.  Both the perm and the 
virtual WWPNs are in our zone.  Port security has been toggled off then 
on, the entire CHPID has been toggled as well.   NPIV is on everywhere, 
NPV is off.  Another earlier question was were we doing a lot of 
attaches/detaches, and the answer is yes.  unfortunately its not easy to 
read this debug information - at times i've had to go to the source code 
of the zfcp driver to make an educated guess at what the "perr" and "ferr" 
codes were with codes 0x0d and 0x05 (thanks to the person who clarified 
those).

This is the output from SCSIDISC DEBUG.  We are currently trying to find 
out what THINOP()=-62 and GETLUN()=-112 indicate.

EXCEPTION::Logfile SCSIDISC LOG A already exists. Delete?  (Y/N):
y
INFO::START @ 20 Apr 2010 07:00:58
INFO::No of attached FCP Channels found=1
PLEASE CHOOSE A NO CORRESPONDING TO A FCP DEVICE OR 'QUIT'
 0) All DEVs 1) 5000
0
INFO::Choosen FCP Sub-Channel Device(s)=ALL DEVICES
INFO::FCP SUB-CHANNEL 5000 Initialized
INFO::For Sub Channel 5000 No of WWPNs found=2
FOR FCP SUBCHANNEL 5000
PLEASE CHOOSE A NO CORRESPONDING TO A WWPN OR 'QUIT'
 0) All WWPNs1) C05076FAE3000400
 2) 50060E80042CC20C
0
INFO::For 5000 Choosen WWPN(s)=ALL WWPNs
INFO::FCP SUB-CHANNEL 5000 Re-Initialized
WARNING::WWPN C05076FAE3000400 Could Not be Opened
DEBUG::ERROR RC:C05076FAE3000400 THINOP()=-62
DEBUG::ERROR Open FCP port has failed
WARNING::WWPN C05076FAE3000400 ignored
DEBUG::ERROR RC:C05076FAE3000400 GETLUN()=-112
INFO::FCP SUB-CHANNEL 5000 Re-Initialized
WARNING::WWPN 50060E80042CC20C Could Not be Opened
DEBUG::ERROR RC:50060E80042CC20C THINOP()=-62
DEBUG::ERROR Open FCP port has failed
WARN

Re: Converting Text to XLS

[Schuh, Richard]

Thanks to all who have been responding. I should have enough the keep me busy, 
er, busier.  I will post when I have the solution or if I don't find one among 
the many suggestions.


Regards,
Richard Schuh






From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Lionel Dyck
Sent: Tuesday, April 20, 2010 2:38 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS


I've done some work with text to csv for z/os and never found a way to get the 
csv to open in a decent view in excel as a csv is the lowest common format.

I did find that you can create an html table that can be opened in excel - take 
a look at www.lbdsoftware.com for the txt2html file - that code is in rexx but 
I've not taken the time to make it work under z/vm (feel free). It has the 
ability to do what you want to a degree.

Good luck

Lionel

Lionel B. Dyck <><
z/Linux Specialist
IBM Corporation
Global Technology Services - Kaiser Account
Work: 925-926-5332
Cell: 925-348-0237
E-Mail: ld...@us.ibm.com
AIM: lbdyck | Yahoo IM: lbdyck | GTalk: lbdyck  


[cid:1__=07BBFD98DFE510FF8f9e8a93df938@us.ibm.com]"Schuh, Richard" 
---04/20/2010 02:28:40 PM---I want them to have a consistent view when it is 
received. I don't give a damn what they do with it

From: "Schuh, Richard" 
To: IBMVM@LISTSERV.UARK.EDU
Date: 04/20/2010 02:28 PM
Subject: Re: Converting Text to XLS
Sent by: The IBM z/VM Operating System 




I want them to have a consistent view when it is received. I don't give a damn 
what they do with it afterward.

Regards,
Richard Schuh



From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Frank M. Ramaekers
Sent: Tuesday, April 20, 2010 12:28 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

...and you don't want to have to "futz" with Excel macros or scripts?


Frank M. Ramaekers Jr.

From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Schuh, Richard
Sent: Tuesday, April 20, 2010 1:19 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

Right now, I am creating a csv file using tab (x'05', which is also the default 
field separator in Pipelines) characters as a separator. Since I do not have 
control of the width of cells, I need to be able to selectively specify whether 
to align right or left and top or bottom in the cells of a column. I suppose I 
could use a multiple pass process where I get the max size of a cell in each 
column and create fixed size cells and align things myself. Then, there are 
such things as table and column headings and anything else needed to make it 
print friendly. Even then, the output would still be a text file. not xls.

The short of it is, I am trying to make it so that the recipient does not have 
to futz with formats or headings when the file is opened by Excel. I have seen 
some really strange formats when looking at files that people (in ISO, but I 
will give them the benefit of the doubt) have messed up.

Regards,
Richard Schuh



From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Wandschneider, Scott
Sent: Tuesday, April 20, 2010 10:40 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
I create several text files on CMS where I use the > or < character as a 
delimiter and surround special text with ".

Thank you,

Scott

From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Schuh, Richard
Sent: Tuesday, April 20, 2010 12:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS

Does anyone know of a program to create an XLS file from a text file on CMS? 
The file can be sent as a CSV file attached to an e-mail; however, opening the 
CSV file with Excel or other spreadsheet programs exposes a few formatting 
problems/inconsistencies that must be fixed by manual manipulation.

Regards,
Richard Schuh



Confidentiality Note: This e-mail, including any attachment to it, may contain 
material that is confidential, proprietary, privileged and/or "Protected Health 
Information," within the meaning of the regulations under the Health Insurance 
Portability & Accountability Act as amended. If it is not clear that you are 
the intended recipient, you are hereby notified that you have received this 
transmittal in error, and any review, dissemination, distribution or copying of 
this e-mail, including any attachment to it, is strictly prohibited. If you 
have received this e-mail in error, please immediately return it to the sender 
and delete it from your system. Thank you.

_ This message contains 
information which is privileged and confidential and is solely for the use of 
the intended recipient. If you are not th

Re: Converting Text to XLS

[Schuh, Richard]

I have had so many things other than this going on and so many interruptions 
that I haven't had time to check out all the suggestions


Regards,
Richard Schuh






From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Edward M Martin
Sent: Tuesday, April 20, 2010 2:35 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

Hello Richard,

 You are sending a email with attached CSV file correct?
Was the example I sent you not what was needed or am I missing something (very 
normal thing)?

Ed Martin
Aultman Health Foundation
330-363-5050
ext 35050
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Schuh, Richard
Sent: Tuesday, April 20, 2010 5:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

I want them to have a consistent view when it is received. I don't give a damn 
what they do with it afterward.


Regards,
Richard Schuh





From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Frank M. Ramaekers
Sent: Tuesday, April 20, 2010 12:28 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
...and you don't want to have to "futz" with Excel macros or scripts?



Frank M. Ramaekers Jr.






From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Schuh, Richard
Sent: Tuesday, April 20, 2010 1:19 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

Right now, I am creating a csv file using tab (x'05', which is also the default 
field separator in Pipelines) characters as a separator. Since I do not have 
control of the width of cells, I need to be able to selectively specify whether 
to align right or left and top or bottom in the cells of a column. I suppose I 
could use a multiple pass process where I get the max size of a cell in each 
column and create fixed size cells and align things myself. Then, there are 
such things as table and column headings and anything else needed to make it 
print friendly.  Even then, the output would still be a text file. not xls.

The short of it is, I am trying to make it so that the recipient does not have 
to futz with formats or headings when the file is opened by Excel. I have seen 
some really strange formats when looking at files that people (in ISO, but I 
will give them the benefit of the doubt) have messed up.

Regards,
Richard Schuh





From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Wandschneider, Scott
Sent: Tuesday, April 20, 2010 10:40 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
I create several text files on CMS where I use the > or < character as a 
delimiter and surround special text with ".

Thank you,

Scott

From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Schuh, Richard
Sent: Tuesday, April 20, 2010 12:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS

Does anyone know of a program to create an XLS file from a text file on CMS? 
The file can be sent as a CSV file attached to an e-mail; however, opening the 
CSV file with Excel or other spreadsheet programs exposes a few formatting 
problems/inconsistencies that must be fixed by manual manipulation.

Regards,
Richard Schuh




Confidentiality Note: This e-mail, including any attachment to it, may contain 
material that is confidential, proprietary, privileged and/or "Protected Health 
Information," within the meaning of the regulations under the Health Insurance 
Portability & Accountability Act as amended. If it is not clear that you are 
the intended recipient, you are hereby notified that you have received this 
transmittal in error, and any review, dissemination, distribution or copying of 
this e-mail, including any attachment to it, is strictly prohibited. If you 
have received this e-mail in error, please immediately return it to the sender 
and delete it from your system. Thank you.
_ This message contains 
information which is privileged and confidential and is solely for the use of 
the intended recipient. If you are not the intended recipient, be aware that 
any review, disclosure, copying, distribution, or use of the contents of this 
message is strictly prohibited. If you have received this in error, please 
destroy it immediately and notify us at privacy...@ailife.com.

Re: Converting Text to XLS

[Lionel Dyck]

I've done some work with text to csv for z/os and never found a way to get
the csv to open in a decent view in excel as a csv is the lowest common
format.

I did find that you can create an html table that can be opened in excel -
take a look at www.lbdsoftware.com for the txt2html file - that code is in
rexx but I've not taken the time to make it work under z/vm (feel free).
It has the ability to do what you want to a degree.

Good luck

Lionel

  
 Lionel B. Dyck <>< 
  
 z/Linux Specialist 
  
 IBM Corporation
  
 Global Technology Services - Kaiser Account
  
 Work: 925-926-5332 
  
 Cell: 925-348-0237 
  
 E-Mail: ld...@us.ibm.com   
  
 AIM: lbdyck | Yahoo IM: lbdyck | GTalk:
  
 lbdyck 
  

  






From:   "Schuh, Richard" 
To: IBMVM@LISTSERV.UARK.EDU
Date:   04/20/2010 02:28 PM
Subject:Re: Converting Text to XLS
Sent by:The IBM z/VM Operating System 



I want them to have a consistent view when it is received. I don't give a
damn what they do with it afterward.



Regards,
Richard Schuh







 From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
 Behalf Of Frank M. Ramaekers
 Sent: Tuesday, April 20, 2010 12:28 PM
 To: IBMVM@LISTSERV.UARK.EDU
 Subject: Re: Converting Text to XLS

 …and you don’t want to have to “futz” with Excel macros or scripts?






 Frank M. Ramaekers Jr. 







 From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
 Behalf Of Schuh, Richard
 Sent: Tuesday, April 20, 2010 1:19 PM
 To: IBMVM@LISTSERV.UARK.EDU
 Subject: Re: Converting Text to XLS

 Right now, I am creating a csv file using tab (x'05', which is also the
 default field separator in Pipelines) characters as a separator. Since I
 do not have control of the width of cells, I need to be able to
 selectively specify whether to align right or left and top or bottom in
 the cells of a column. I suppose I could use a multiple pass process where
 I get the max size of a cell in each column and create fixed size cells
 and align things myself. Then, there are such things as table and column
 headings and anything else needed to make it print friendly.  Even then,
 the output would still be a text file. not xls.

 The short of it is, I am trying to make it so that the recipient does not
 have to futz with formats or headings when the file is opened by Excel. I
 have seen some really strange formats when looking at files that people
 (in ISO, but I will give them the benefit of the doubt) have messed up.


 Regards,
 Richard Schuh






 From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
 Behalf Of Wandschneider, Scott
 Sent: Tuesday, April 20, 2010 10:40 AM
 To: IBMVM@LISTSERV.UARK.EDU
 Subject: Re: Converting Text to XLS
 I create several text files on CMS where I use the > or < character as a
 delimiter and surround special text with “.

 Thank you,

 Scott

 From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
 Behalf Of Schuh, Richard
 Sent: Tuesday, April 20, 2010 12:27 PM
 To: IBMVM@LISTSERV.UARK.EDU
 Subject: Converting Text to XLS

 Does anyone know of a program to create an XLS file from a text file on
 CMS? The file can be sent as a CSV file attached to an e-mail; however,
 opening the CSV file with Excel or other spreadsheet programs exposes a
 few formatting problems/inconsistencies that must be fixed by manual
 manipulation.

 Regards,
 Richard Schuh





 Confidentiality Note: This e-mail, including any attachment to it, may
 contain material that is confidential, proprietary, privileged and/or
 "Protected Health Information," within the meaning of the regulations
 under the Health Insurance Portability & Accountability Act as amended. If
 it is not clear that you are the intended recipient, you are hereby
 notified that you have received this transmittal in error, and any review,
 dissemination, distribution or copying of this e-mail, including any
 attachment to it, is strictly prohibited. If you have rece

Re: Converting Text to XLS

[Edward M Martin]

Hello Richard,

 

 You are sending a email with attached CSV file correct?  

Was the example I sent you not what was needed or am I missing something
(very normal thing)?

 

Ed Martin

Aultman Health Foundation

330-363-5050

ext 35050

From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: Tuesday, April 20, 2010 5:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

 

I want them to have a consistent view when it is received. I don't give
a damn what they do with it afterward.

 

Regards, 
Richard Schuh 

 

 

 



From: The IBM z/VM Operating System
[mailto:ib...@listserv.uark.edu] On Behalf Of Frank M. Ramaekers
Sent: Tuesday, April 20, 2010 12:28 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

...and you don't want to have to "futz" with Excel macros or
scripts?

 

 

Frank M. Ramaekers Jr.

 

 



From: The IBM z/VM Operating System
[mailto:ib...@listserv.uark.edu] On Behalf Of Schuh, Richard
Sent: Tuesday, April 20, 2010 1:19 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

 

Right now, I am creating a csv file using tab (x'05', which is
also the default field separator in Pipelines) characters as a
separator. Since I do not have control of the width of cells, I need to
be able to selectively specify whether to align right or left and top or
bottom in the cells of a column. I suppose I could use a multiple pass
process where I get the max size of a cell in each column and create
fixed size cells and align things myself. Then, there are such things as
table and column headings and anything else needed to make it print
friendly.  Even then, the output would still be a text file. not xls.

 

The short of it is, I am trying to make it so that the recipient
does not have to futz with formats or headings when the file is opened
by Excel. I have seen some really strange formats when looking at files
that people (in ISO, but I will give them the benefit of the doubt) have
messed up.

Regards, 
Richard Schuh 

 

 

 



From: The IBM z/VM Operating System
[mailto:ib...@listserv.uark.edu] On Behalf Of Wandschneider, Scott
Sent: Tuesday, April 20, 2010 10:40 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

I create several text files on CMS where I use the > or
< character as a delimiter and surround special text with ".

 

Thank you,

 

Scott

 

From: The IBM z/VM Operating System
[mailto:ib...@listserv.uark.edu] On Behalf Of Schuh, Richard
Sent: Tuesday, April 20, 2010 12:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS

 

Does anyone know of a program to create an XLS file from
a text file on CMS? The file can be sent as a CSV file attached to an
e-mail; however, opening the CSV file with Excel or other spreadsheet
programs exposes a few formatting problems/inconsistencies that must be
fixed by manual manipulation.

 

Regards, 
Richard Schuh 

 

 

 

Confidentiality Note: This e-mail, including any
attachment to it, may contain material that is confidential,
proprietary, privileged and/or "Protected Health Information," within
the meaning of the regulations under the Health Insurance Portability &
Accountability Act as amended. If it is not clear that you are the
intended recipient, you are hereby notified that you have received this
transmittal in error, and any review, dissemination, distribution or
copying of this e-mail, including any attachment to it, is strictly
prohibited. If you have received this e-mail in error, please
immediately return it to the sender and delete it from your system.
Thank you. 

_ This
message contains information which is privileged and confidential and is
solely for the use of the intended recipient. If you are not the
intended recipient, be aware that any review, disclosure, copying,
distribution, or use of the contents of this message is strictly
prohibited. If you have received this in error, please destroy it
immediately and notify us at privacy...@ailife.com. 

Re: Converting Text to XLS

[A. Harry Williams]

On Tue, 20 Apr 2010 10:27:09 -0700 Schuh, Richard said:
>Does anyone know of a program to create an XLS file from a text file on CMS?
>The
>file can be sent as a CSV file attached to an e-mail; however, opening the CSV
>file with Excel or other spreadsheet programs exposes a few formatting
>problems/inconsistencies that must be fixed by manual manipulation.

I have a Q&D Rexx exec that was work I did to create an XML file for use in
Excel.  It opens just fine in Excel 2007 & higher, and I think in 2003 with
the the 2007 compatibility patch.  This is not a clean program, no doc
and some options are coded as variables rather than options, so they were real
work in progress.  There are 2 versions, a less developed turn a fixed length
file into XML, and a version you pass a DB2 select statement, and it
turns the resulting output into an XML file.  eg


DB2XML SELECT * from mytable

will turn the table mytable into an XML file.

The DB2 version is much more flushed out, but probably has Marist specific
things in it.  They both are very much early works in progress.

If you are interested, I can send you either or both of them.

>Regards,
>Richard Schuh

/ahw

Re: Converting Text to XLS

[Schuh, Richard]

I want them to have a consistent view when it is received. I don't give a damn 
what they do with it afterward.


Regards,
Richard Schuh






From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Frank M. Ramaekers
Sent: Tuesday, April 20, 2010 12:28 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

...and you don't want to have to "futz" with Excel macros or scripts?



Frank M. Ramaekers Jr.






From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Schuh, Richard
Sent: Tuesday, April 20, 2010 1:19 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

Right now, I am creating a csv file using tab (x'05', which is also the default 
field separator in Pipelines) characters as a separator. Since I do not have 
control of the width of cells, I need to be able to selectively specify whether 
to align right or left and top or bottom in the cells of a column. I suppose I 
could use a multiple pass process where I get the max size of a cell in each 
column and create fixed size cells and align things myself. Then, there are 
such things as table and column headings and anything else needed to make it 
print friendly.  Even then, the output would still be a text file. not xls.

The short of it is, I am trying to make it so that the recipient does not have 
to futz with formats or headings when the file is opened by Excel. I have seen 
some really strange formats when looking at files that people (in ISO, but I 
will give them the benefit of the doubt) have messed up.

Regards,
Richard Schuh





From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Wandschneider, Scott
Sent: Tuesday, April 20, 2010 10:40 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
I create several text files on CMS where I use the > or < character as a 
delimiter and surround special text with ".

Thank you,

Scott

From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Schuh, Richard
Sent: Tuesday, April 20, 2010 12:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS

Does anyone know of a program to create an XLS file from a text file on CMS? 
The file can be sent as a CSV file attached to an e-mail; however, opening the 
CSV file with Excel or other spreadsheet programs exposes a few formatting 
problems/inconsistencies that must be fixed by manual manipulation.

Regards,
Richard Schuh




Confidentiality Note: This e-mail, including any attachment to it, may contain 
material that is confidential, proprietary, privileged and/or "Protected Health 
Information," within the meaning of the regulations under the Health Insurance 
Portability & Accountability Act as amended. If it is not clear that you are 
the intended recipient, you are hereby notified that you have received this 
transmittal in error, and any review, dissemination, distribution or copying of 
this e-mail, including any attachment to it, is strictly prohibited. If you 
have received this e-mail in error, please immediately return it to the sender 
and delete it from your system. Thank you.

_ This message contains 
information which is privileged and confidential and is solely for the use of 
the intended recipient. If you are not the intended recipient, be aware that 
any review, disclosure, copying, distribution, or use of the contents of this 
message is strictly prohibited. If you have received this in error, please 
destroy it immediately and notify us at privacy...@ailife.com.

Re: Converting Text to XLS

[Frank M. Ramaekers]

...and you don't want to have to "futz" with Excel macros or scripts?

 

 

Frank M. Ramaekers Jr.

 

 



From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: Tuesday, April 20, 2010 1:19 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

 

Right now, I am creating a csv file using tab (x'05', which is also the
default field separator in Pipelines) characters as a separator. Since I
do not have control of the width of cells, I need to be able to
selectively specify whether to align right or left and top or bottom in
the cells of a column. I suppose I could use a multiple pass process
where I get the max size of a cell in each column and create fixed size
cells and align things myself. Then, there are such things as table and
column headings and anything else needed to make it print friendly.
Even then, the output would still be a text file. not xls.

 

The short of it is, I am trying to make it so that the recipient does
not have to futz with formats or headings when the file is opened by
Excel. I have seen some really strange formats when looking at files
that people (in ISO, but I will give them the benefit of the doubt) have
messed up.

Regards, 
Richard Schuh 

 

 

 





From: The IBM z/VM Operating System
[mailto:ib...@listserv.uark.edu] On Behalf Of Wandschneider, Scott
Sent: Tuesday, April 20, 2010 10:40 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

I create several text files on CMS where I use the > or <
character as a delimiter and surround special text with ".

 

Thank you,

 

Scott

 

From: The IBM z/VM Operating System
[mailto:ib...@listserv.uark.edu] On Behalf Of Schuh, Richard
Sent: Tuesday, April 20, 2010 12:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS

 

Does anyone know of a program to create an XLS file from a text
file on CMS? The file can be sent as a CSV file attached to an e-mail;
however, opening the CSV file with Excel or other spreadsheet programs
exposes a few formatting problems/inconsistencies that must be fixed by
manual manipulation.

 

Regards, 
Richard Schuh 

 

 

 

Confidentiality Note: This e-mail, including any attachment to
it, may contain material that is confidential, proprietary, privileged
and/or "Protected Health Information," within the meaning of the
regulations under the Health Insurance Portability & Accountability Act
as amended. If it is not clear that you are the intended recipient, you
are hereby notified that you have received this transmittal in error,
and any review, dissemination, distribution or copying of this e-mail,
including any attachment to it, is strictly prohibited. If you have
received this e-mail in error, please immediately return it to the
sender and delete it from your system. Thank you. 


_
This message contains information which is privileged and confidential and is 
solely for the use of the
intended recipient. If you are not the intended recipient, be aware that any 
review, disclosure,
copying, distribution, or use of the contents of this message is strictly 
prohibited. If you have
received this in error, please destroy it immediately and notify us at 
privacy...@ailife.com.

Re: Converting Text to XLS

[Les Koehler]

You could use OORexx and its support for OLE to 
automatically fix the inconsistencies.


Les

Schuh, Richard wrote:

Does anyone know of a program to create an XLS file from a text file on CMS? 
The file can be sent as a CSV file attached to an e-mail; however, opening the 
CSV file with Excel or other spreadsheet programs exposes a few formatting 
problems/inconsistencies that must be fixed by manual manipulation.


Regards,
Richard Schuh

Re: Converting Text to XLS

[Peter . Webb]

Well if you have money to spend on this, Focus from Information Builders
runs on CMS and can save output as HTML, HTMTABLE, PDF, PS, ALPHA, WP,
DIF, EXCEL, EXL97, EXL2K, LOTUS, SYLK, TAB, TABT, COMMA, COM, COMT, DB2,
FUSION, SQL, SQLORA, SQLDBC formats. I have tried a couple of these, and
they do work.

 

Peter

 

-Original Message-
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: April 20, 2010 14:22
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

 

Are there programs to do that conversion in CMS? I am not familiar with
the SYLK format.

 

Regards, 
Richard Schuh 

 

 

 





From: The IBM z/VM Operating System
[mailto:ib...@listserv.uark.edu] On Behalf Of Stace Cameron
Sent: Tuesday, April 20, 2010 10:57 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

Another possibility is the symbolic link  format file (SYLK). 


 


. 





The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material.  Any 
review retransmission dissemination or other use of or taking any action in 
reliance upon this information by persons or entities other than the intended 
recipient or delegate is strictly prohibited.  If you received this in error 
please contact the sender and delete the material from any computer.  The 
integrity and security of this message cannot be guaranteed on the Internet.  
The sender accepts no liability for the content of this e-mail or for the 
consequences of any actions taken on the basis of information provided.  The 
recipient should check this e-mail and any attachments for the presence of 
viruses.  The sender accepts no liability for any damage caused by any virus 
transmitted by this e-mail.  This disclaimer is property of the TTC and must 
not be altered or circumvented in any manner.

Re: Converting Text to XLS

[Schuh, Richard]

I certainly do not have Java on CMS :-) I do have Rexx, Pipelines and HLASM.


Regards,
Richard Schuh






From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of McKown, John
Sent: Tuesday, April 20, 2010 11:31 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

What languages do you have available? If you have a current Java, then I'd 
suggest looking at Apache:POI

http://poi.apache.org/

John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)

9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john.mck...@healthmarkets.com * www.HealthMarkets.com

Confidentiality Notice: This e-mail message may contain confidential or 
proprietary information. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the original message. 
HealthMarkets(r) is the brand name for products underwritten and issued by the 
insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance 
Company(r), Mid-West National Life Insurance Company of TennesseeSM and The 
MEGA Life and Health Insurance Company.SM



From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Schuh, Richard
Sent: Tuesday, April 20, 2010 1:19 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

Right now, I am creating a csv file using tab (x'05', which is also the default 
field separator in Pipelines) characters as a separator. Since I do not have 
control of the width of cells, I need to be able to selectively specify whether 
to align right or left and top or bottom in the cells of a column. I suppose I 
could use a multiple pass process where I get the max size of a cell in each 
column and create fixed size cells and align things myself. Then, there are 
such things as table and column headings and anything else needed to make it 
print friendly.  Even then, the output would still be a text file. not xls.

The short of it is, I am trying to make it so that the recipient does not have 
to futz with formats or headings when the file is opened by Excel. I have seen 
some really strange formats when looking at files that people (in ISO, but I 
will give them the benefit of the doubt) have messed up.

Regards,
Richard Schuh






From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Wandschneider, Scott
Sent: Tuesday, April 20, 2010 10:40 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

I create several text files on CMS where I use the > or < character as a 
delimiter and surround special text with ".

Thank you,

Scott

From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Schuh, Richard
Sent: Tuesday, April 20, 2010 12:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS

Does anyone know of a program to create an XLS file from a text file on CMS? 
The file can be sent as a CSV file attached to an e-mail; however, opening the 
CSV file with Excel or other spreadsheet programs exposes a few formatting 
problems/inconsistencies that must be fixed by manual manipulation.

Regards,
Richard Schuh




Confidentiality Note: This e-mail, including any attachment to it, may contain 
material that is confidential, proprietary, privileged and/or "Protected Health 
Information," within the meaning of the regulations under the Health Insurance 
Portability & Accountability Act as amended. If it is not clear that you are 
the intended recipient, you are hereby notified that you have received this 
transmittal in error, and any review, dissemination, distribution or copying of 
this e-mail, including any attachment to it, is strictly prohibited. If you 
have received this e-mail in error, please immediately return it to the sender 
and delete it from your system. Thank you.

Re: Converting Text to XLS

[Schuh, Richard]

You would have to ask the ISO folks. That is what they specified. I suspect 
they want to play with it using secret macros.

Regards, 
Richard Schuh 

 

> -Original Message-
> From: The IBM z/VM Operating System 
> [mailto:ib...@listserv.uark.edu] On Behalf Of Ron Schmiedge
> Sent: Tuesday, April 20, 2010 11:27 AM
> To: IBMVM@LISTSERV.UARK.EDU
> Subject: Re: Converting Text to XLS
> 
> Richard,
> 
> I've a dumb question to ask - why does the CMS file have to 
> be opened by a spreadsheet program?
> 
> 
> 
> On Tue, Apr 20, 2010 at 12:19 PM, Schuh, Richard 
>  wrote:
> > Right now, I am creating a csv file using tab (x'05', which is also 
> > the default field separator in Pipelines) characters as a 
> separator. 
> > Since I do not have control of the width of cells, I need 
> to be able 
> > to selectively specify whether to align right or left and top or 
> > bottom in the cells of a column. I suppose I could use a 
> multiple pass 
> > process where I get the max size of a cell in each column 
> and create 
> > fixed size cells and align things myself. Then, there are 
> such things 
> > as table and column headings and anything else needed to 
> make it print 
> > friendly.  Even then, the output would still be a text 
> file. not xls.
> >
> > The short of it is, I am trying to make it so that the 
> recipient does 
> > not have to futz with formats or headings when the file is 
> opened by 
> > Excel. I have seen some really strange formats when looking 
> at files 
> > that people (in ISO, but I will give them the benefit of 
> the doubt) have messed up.
> >
> > Regards,
> > Richard Schuh
> >
> >
> >
> >
> >
> > 
> > From: The IBM z/VM Operating System 
> [mailto:ib...@listserv.uark.edu] 
> > On Behalf Of Wandschneider, Scott
> > Sent: Tuesday, April 20, 2010 10:40 AM
> > To: IBMVM@LISTSERV.UARK.EDU
> > Subject: Re: Converting Text to XLS
> >
> > I create several text files on CMS where I use the > or < 
> character as 
> > a delimiter and surround special text with ".
> >
> >
> >
> > Thank you,
> >
> >
> >
> > Scott
> >
> >
> >
> > From: The IBM z/VM Operating System 
> [mailto:ib...@listserv.uark.edu] 
> > On Behalf Of Schuh, Richard
> > Sent: Tuesday, April 20, 2010 12:27 PM
> >
> > To: IBMVM@LISTSERV.UARK.EDU
> > Subject: Converting Text to XLS
> >
> >
> >
> > Does anyone know of a program to create an XLS file from a 
> text file on CMS?
> > The file can be sent as a CSV file attached to an e-mail; however, 
> > opening the CSV file with Excel or other spreadsheet 
> programs exposes 
> > a few formatting problems/inconsistencies that must be 
> fixed by manual 
> > manipulation.
> >
> >
> >
> > Regards,
> > Richard Schuh
> >
> >
> >
> >
> 

Re: Converting Text to XLS

[Schuh, Richard]

Are there programs to do that conversion in CMS? I am not familiar with the 
SYLK format.


Regards,
Richard Schuh






From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Stace Cameron
Sent: Tuesday, April 20, 2010 10:57 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

Another possibility is the symbolic link  format file (SYLK).

.

Re: Converting Text to XLS

[McKown, John]

What languages do you have available? If you have a current Java, then I'd 
suggest looking at Apache:POI

http://poi.apache.org/

John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)

9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john.mck...@healthmarkets.com * www.HealthMarkets.com

Confidentiality Notice: This e-mail message may contain confidential or 
proprietary information. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the original message. 
HealthMarkets(r) is the brand name for products underwritten and issued by the 
insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance 
Company(r), Mid-West National Life Insurance Company of TennesseeSM and The 
MEGA Life and Health Insurance Company.SM



From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Schuh, Richard
Sent: Tuesday, April 20, 2010 1:19 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

Right now, I am creating a csv file using tab (x'05', which is also the default 
field separator in Pipelines) characters as a separator. Since I do not have 
control of the width of cells, I need to be able to selectively specify whether 
to align right or left and top or bottom in the cells of a column. I suppose I 
could use a multiple pass process where I get the max size of a cell in each 
column and create fixed size cells and align things myself. Then, there are 
such things as table and column headings and anything else needed to make it 
print friendly.  Even then, the output would still be a text file. not xls.

The short of it is, I am trying to make it so that the recipient does not have 
to futz with formats or headings when the file is opened by Excel. I have seen 
some really strange formats when looking at files that people (in ISO, but I 
will give them the benefit of the doubt) have messed up.

Regards,
Richard Schuh






From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Wandschneider, Scott
Sent: Tuesday, April 20, 2010 10:40 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

I create several text files on CMS where I use the > or < character as a 
delimiter and surround special text with ".

Thank you,

Scott

From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Schuh, Richard
Sent: Tuesday, April 20, 2010 12:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS

Does anyone know of a program to create an XLS file from a text file on CMS? 
The file can be sent as a CSV file attached to an e-mail; however, opening the 
CSV file with Excel or other spreadsheet programs exposes a few formatting 
problems/inconsistencies that must be fixed by manual manipulation.

Regards,
Richard Schuh




Confidentiality Note: This e-mail, including any attachment to it, may contain 
material that is confidential, proprietary, privileged and/or "Protected Health 
Information," within the meaning of the regulations under the Health Insurance 
Portability & Accountability Act as amended. If it is not clear that you are 
the intended recipient, you are hereby notified that you have received this 
transmittal in error, and any review, dissemination, distribution or copying of 
this e-mail, including any attachment to it, is strictly prohibited. If you 
have received this e-mail in error, please immediately return it to the sender 
and delete it from your system. Thank you.

Re: Converting Text to XLS

[Ron Schmiedge]

Richard,

I've a dumb question to ask - why does the CMS file have to be opened
by a spreadsheet program?



On Tue, Apr 20, 2010 at 12:19 PM, Schuh, Richard  wrote:
> Right now, I am creating a csv file using tab (x'05', which is also the
> default field separator in Pipelines) characters as a separator. Since I do
> not have control of the width of cells, I need to be able to selectively
> specify whether to align right or left and top or bottom in the cells of a
> column. I suppose I could use a multiple pass process where I get the max
> size of a cell in each column and create fixed size cells and align things
> myself. Then, there are such things as table and column headings and
> anything else needed to make it print friendly.  Even then, the output would
> still be a text file. not xls.
>
> The short of it is, I am trying to make it so that the recipient does not
> have to futz with formats or headings when the file is opened by Excel. I
> have seen some really strange formats when looking at files that people (in
> ISO, but I will give them the benefit of the doubt) have messed up.
>
> Regards,
> Richard Schuh
>
>
>
>
>
> 
> From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
> Behalf Of Wandschneider, Scott
> Sent: Tuesday, April 20, 2010 10:40 AM
> To: IBMVM@LISTSERV.UARK.EDU
> Subject: Re: Converting Text to XLS
>
> I create several text files on CMS where I use the > or < character as a
> delimiter and surround special text with “.
>
>
>
> Thank you,
>
>
>
> Scott
>
>
>
> From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
> Behalf Of Schuh, Richard
> Sent: Tuesday, April 20, 2010 12:27 PM
>
> To: IBMVM@LISTSERV.UARK.EDU
> Subject: Converting Text to XLS
>
>
>
> Does anyone know of a program to create an XLS file from a text file on CMS?
> The file can be sent as a CSV file attached to an e-mail; however, opening
> the CSV file with Excel or other spreadsheet programs exposes a few
> formatting problems/inconsistencies that must be fixed by manual
> manipulation.
>
>
>
> Regards,
> Richard Schuh
>
>
>
>

Re: Converting Text to XLS

[Schuh, Richard]

Right now, I am creating a csv file using tab (x'05', which is also the default 
field separator in Pipelines) characters as a separator. Since I do not have 
control of the width of cells, I need to be able to selectively specify whether 
to align right or left and top or bottom in the cells of a column. I suppose I 
could use a multiple pass process where I get the max size of a cell in each 
column and create fixed size cells and align things myself. Then, there are 
such things as table and column headings and anything else needed to make it 
print friendly.  Even then, the output would still be a text file. not xls.

The short of it is, I am trying to make it so that the recipient does not have 
to futz with formats or headings when the file is opened by Excel. I have seen 
some really strange formats when looking at files that people (in ISO, but I 
will give them the benefit of the doubt) have messed up.

Regards,
Richard Schuh






From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Wandschneider, Scott
Sent: Tuesday, April 20, 2010 10:40 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS

I create several text files on CMS where I use the > or < character as a 
delimiter and surround special text with ".

Thank you,

Scott

From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Schuh, Richard
Sent: Tuesday, April 20, 2010 12:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS

Does anyone know of a program to create an XLS file from a text file on CMS? 
The file can be sent as a CSV file attached to an e-mail; however, opening the 
CSV file with Excel or other spreadsheet programs exposes a few formatting 
problems/inconsistencies that must be fixed by manual manipulation.

Regards,
Richard Schuh




Confidentiality Note: This e-mail, including any attachment to it, may contain 
material that is confidential, proprietary, privileged and/or "Protected Health 
Information," within the meaning of the regulations under the Health Insurance 
Portability & Accountability Act as amended. If it is not clear that you are 
the intended recipient, you are hereby notified that you have received this 
transmittal in error, and any review, dissemination, distribution or copying of 
this e-mail, including any attachment to it, is strictly prohibited. If you 
have received this e-mail in error, please immediately return it to the sender 
and delete it from your system. Thank you.

Re: Converting Text to XLS

[Edward M Martin]

Hello Richard Schuh,

 

We have quite a few CSV files that are sent via email as attachments
being opened by Excel without problems other that the making the cell
large enough for the number to readable.  xx versus 123456, and
double click on the column expands it.

 

The files are comma delimited with text inside double quotes.

 

"ARX_MR_ACCT","ARX_ENT_CD","ARX_POST_DT","ARX_BTCH_NBR","ARX_AMT","ARX_C
DM_CD","ARX_ICO_CD","ARX_ICC","ARX_COINS","ARX_DEDUCT",

99,"AH","04/19/10",1114,0.00,71121008,"067",225,0.00,0.00,"",0,"
",0.00,"J","K"  

99,"AH","04/19/10",2219,0.00,756213,"BHP",220,0.00,0.00,"1",4028
1,"",0.00,"2","I"   

 

 

Ed Martin

Aultman Health Foundation

330-363-5050

ext 35050

From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: Tuesday, April 20, 2010 1:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS

 

Does anyone know of a program to create an XLS file from a text file on
CMS? The file can be sent as a CSV file attached to an e-mail; however,
opening the CSV file with Excel or other spreadsheet programs exposes a
few formatting problems/inconsistencies that must be fixed by manual
manipulation.

 

Regards, 
Richard Schuh 

 

 

 

Re: z/VM not seeing storage from SAN

[Daniel Tate]

No such file exists.. this is the structure of that directory

[root] zvmtestd:/sys/bus/ccw/devices/0.0.5000# ls
availability  devtype   host37   online port_remove  uevent
card_version  driverin_recovery  peer_d_id  port_rescan
cmb_enablefailedlic_version  peer_wwnn  status
cutypehardware_version  modalias peer_wwpn  subsystem


On Tue, Apr 20, 2010 at 11:24 AM, Richard Troth  wrote:

> I am a little confused about what WWPN goes where in your case.
>
> Based on prior email, C05076FAE3000400 is the WWPN of your virtual FCP
> adapter (because NPIV is in place).  It starts with a "C".  But
> 50060E80042CC20C looks to me more like a storage side WWPN.  What is the
> "real WWPN" of your FCP adapter 5000?  Might start with "5005", though a
> "5006" prefix is certainly also possible.  (Someone who knows FCP better
> than I might know vendor prefixes and things like that.)
>
> When you had Linux up (instead of CMS), what did you find in these pseudo
> files?
>
> /sys/bus/ccw/devices/0.0.5000/physical_wwpn
> /sys/bus/ccw/devices/0.0.5000/wwpn
>
> The latter should be 0xc05076fae3000400.  What is the other?
> (If you did not have NPIV in effect, then the two would match or one be
> zeros.)
>
> Since you said that you have it working on one or two other systems, how to
> they look by comparison?
>
> For zoning and masking and all that, it is not clear to me that you need to
> specify the real WWPN (of the HBA, of the FCP adapter) when NPIV is in
> play.  Eric?  What do you say about that?  You certainly DO need to zone and
> mask the storage and the fabric to the virtual WWPN (the one with the "C050"
> prefix).
>
> -- Rick;   <><
>
>
>
>
>
>
> On Tue, Apr 20, 2010 at 09:13, Daniel Tate  wrote:
>
>> To answer someone's earlier question, yes, we've seen every redbook
>> imaginable related to this, tried to do a direct zfcp attach, set edev.   I
>> can't give too much info away about our organization but we are using cisco
>> san switches, if that makes a difference.  Both the perm and the virtual
>> WWPNs are in our zone.  Port security has been toggled off then on, the
>> entire CHPID has been toggled as well.   NPIV is on everywhere, NPV is off.
>> Another earlier question was were we doing a lot of attaches/detaches, and
>> the answer is yes.  unfortunately its not easy to read this debug
>> information - at times i've had to go to the source code of the zfcp driver
>> to make an educated guess at what the "perr" and "ferr" codes were with
>> codes 0x0d and 0x05 (thanks to the person who clarified those).
>>
>> This is the output from SCSIDISC DEBUG.  We are currently trying to find
>> out what THINOP()=-62 and GETLUN()=-112 indicate.
>>
>> EXCEPTION::Logfile SCSIDISC LOG A already exists. Delete?  (Y/N):
>> y
>> INFO::START @ 20 Apr 2010 07:00:58
>> INFO::No of attached FCP Channels found=1
>> PLEASE CHOOSE A NO CORRESPONDING TO A FCP DEVICE OR 'QUIT'
>>  0) All DEVs 1) 5000
>> 0
>> INFO::Choosen FCP Sub-Channel Device(s)=ALL DEVICES
>> INFO::FCP SUB-CHANNEL 5000 Initialized
>> INFO::For Sub Channel 5000 No of WWPNs found=2
>> FOR FCP SUBCHANNEL 5000
>> PLEASE CHOOSE A NO CORRESPONDING TO A WWPN OR 'QUIT'
>>  0) All WWPNs1) C05076FAE3000400
>>  2) 50060E80042CC20C
>> 0
>> INFO::For 5000 Choosen WWPN(s)=ALL WWPNs
>> INFO::FCP SUB-CHANNEL 5000 Re-Initialized
>> WARNING::WWPN C05076FAE3000400 Could Not be Opened
>> DEBUG::ERROR RC:C05076FAE3000400 THINOP()=-62
>> DEBUG::ERROR Open FCP port has failed
>> WARNING::WWPN C05076FAE3000400 ignored
>> DEBUG::ERROR RC:C05076FAE3000400 GETLUN()=-112
>> INFO::FCP SUB-CHANNEL 5000 Re-Initialized
>> WARNING::WWPN 50060E80042CC20C Could Not be Opened
>> DEBUG::ERROR RC:50060E80042CC20C THINOP()=-62
>> DEBUG::ERROR Open FCP port has failed
>> WARNING::WWPN 50060E80042CC20C ignored
>> DEBUG::ERROR RC:50060E80042CC20C GETLUN()=-112
>> INFO::FCP SUB-CHANNEL 5000 RESET RC=0
>> INFO::END @ 20 Apr 2010 07:01:11
>> PROGRAM EXIT
>> Ready; T=6.10/6.11 07:01:11
>>
>>
>>
>> On Fri, Apr 16, 2010 at 5:00 AM, Eric R Farman  wrote:
>>
>>> Daniel,
>>>
>>> SCSIDISC retrieves all registered WWPNs from the switch connected to the
>>> selected FCP subchannel(s).  If it only reports the one you had attached, it
>>> doesn't sound like the switch zones are setup properly to let the LPAR see
>>> the DASD subsystems.  Has the SAN admin registered the physical WWPN of the
>>> card with the switch zone, or the NPIV WWPNs (displayed on Q FCP output)?
>>>  The latter is necessary in NPIV environment.
>>>
>>> Regards,
>>>Eric
>>>
>>> Eric Farman
>>> z/VM I/O Development
>>> IBM Endicott, NY
>>>
>>>
>>>
>>>  From:
>>> Daniel Tate 
>>> To: IBMVM@LISTSERV.UARK.EDU Date: 04/15/2010 10:50 AM Subject: Re: z/VM
>>> not seeing storage from SAN Sent by: The IBM z/VM Operating System <
>>> IBMVM@LISTSERV.UARK.EDU>
>>> --
>>>
>

Re: Converting Text to XLS

[Stace Cameron]

Another possibility is the symbolic link  format file (SYLK).



.

Re: Converting Text to XLS

[Wandschneider, Scott]

I create several text files on CMS where I use the > or < character as a
delimiter and surround special text with ".

 

Thank you,

 

Scott

 

From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: Tuesday, April 20, 2010 12:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS

 

Does anyone know of a program to create an XLS file from a text file on
CMS? The file can be sent as a CSV file attached to an e-mail; however,
opening the CSV file with Excel or other spreadsheet programs exposes a
few formatting problems/inconsistencies that must be fixed by manual
manipulation.

 

Regards, 
Richard Schuh 

 

 

 



Confidentiality Note: This e-mail, including any attachment to it, may contain 
material that is confidential, proprietary, privileged and/or "Protected Health 
Information," within the meaning of the regulations under the Health Insurance 
Portability & Accountability Act as amended.  If it is not clear that you are 
the intended recipient, you are hereby notified that you have received this 
transmittal in error, and any review, dissemination, distribution or copying of 
this e-mail, including any attachment to it, is strictly prohibited. If you 
have received this e-mail in error, please immediately return it to the sender 
and delete it from your system. Thank you.

Converting Text to XLS

[Schuh, Richard]

Does anyone know of a program to create an XLS file from a text file on CMS? 
The file can be sent as a CSV file attached to an e-mail; however, opening the 
CSV file with Excel or other spreadsheet programs exposes a few formatting 
problems/inconsistencies that must be fixed by manual manipulation.


Regards,
Richard Schuh

Re: z/VM not seeing storage from SAN

[Marcy Cortes]

It looks like you are not getting logged into the fabric (which you should be 
able to check from the SE Fabric Login Status page)
(see page 19 http://www.redbooks.ibm.com/redpapers/pdfs/redp4125.pdf ) 
If you aren't, switch log reviews may be the next step.
 
FWIW, i have the exact same messages after weekend fabric work here and we are 
failing to login.
VM Support has said the -62 is outside of vm.
 
The last time we struggled here it was the domain in the switch.We have the 
added wrinkle of having channel extension equip in the middle now.


Marcy 


"This message may contain confidential and/or privileged information. If you 
are not the addressee or authorized to receive this for the addressee, you must 
not use, copy, disclose, or take any action based on this message or any 
information herein. If you have received this message in error, please advise 
the sender immediately by reply e-mail and delete this message. Thank you for 
your cooperation."

 



From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf 
Of Richard Troth
Sent: Tuesday, April 20, 2010 9:25 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: [IBMVM] z/VM not seeing storage from SAN


I am a little confused about what WWPN goes where in your case. 

Based on prior email, C05076FAE3000400 is the WWPN of your virtual FCP adapter 
(because NPIV is in place).  It starts with a "C".  But 50060E80042CC20C looks 
to me more like a storage side WWPN.  What is the "real WWPN" of your FCP 
adapter 5000?  Might start with "5005", though a "5006" prefix is certainly 
also possible.  (Someone who knows FCP better than I might know vendor prefixes 
and things like that.) 

When you had Linux up (instead of CMS), what did you find in these pseudo 
files? 

/sys/bus/ccw/devices/0.0.5000/physical_wwpn 
/sys/bus/ccw/devices/0.0.5000/wwpn 

The latter should be 0xc05076fae3000400.  What is the other? 
(If you did not have NPIV in effect, then the two would match or one be zeros.) 

Since you said that you have it working on one or two other systems, how to 
they look by comparison? 

For zoning and masking and all that, it is not clear to me that you need to 
specify the real WWPN (of the HBA, of the FCP adapter) when NPIV is in play.  
Eric?  What do you say about that?  You certainly DO need to zone and mask the 
storage and the fabric to the virtual WWPN (the one with the "C050" prefix). 

-- Rick;   <><






On Tue, Apr 20, 2010 at 09:13, Daniel Tate  wrote:


To answer someone's earlier question, yes, we've seen every redbook 
imaginable related to this, tried to do a direct zfcp attach, set edev.   I 
can't give too much info away about our organization but we are using cisco san 
switches, if that makes a difference.  Both the perm and the virtual WWPNs are 
in our zone.  Port security has been toggled off then on, the entire CHPID has 
been toggled as well.   NPIV is on everywhere, NPV is off.  Another earlier 
question was were we doing a lot of attaches/detaches, and the answer is yes.  
unfortunately its not easy to read this debug information - at times i've had 
to go to the source code of the zfcp driver to make an educated guess at what 
the "perr" and "ferr" codes were with codes 0x0d and 0x05 (thanks to the person 
who clarified those).

This is the output from SCSIDISC DEBUG.  We are currently trying to 
find out what THINOP()=-62 and GETLUN()=-112 indicate.

EXCEPTION::Logfile SCSIDISC LOG A already exists. Delete?  (Y/N):
y
INFO::START @ 20 Apr 2010 07:00:58
INFO::No of attached FCP Channels found=1
PLEASE CHOOSE A NO CORRESPONDING TO A FCP DEVICE OR 'QUIT'
 0) All DEVs 1) 5000
0
INFO::Choosen FCP Sub-Channel Device(s)=ALL DEVICES
INFO::FCP SUB-CHANNEL 5000 Initialized
INFO::For Sub Channel 5000 No of WWPNs found=2
FOR FCP SUBCHANNEL 5000
PLEASE CHOOSE A NO CORRESPONDING TO A WWPN OR 'QUIT'
 0) All WWPNs1) C05076FAE3000400
 2) 50060E80042CC20C
0
INFO::For 5000 Choosen WWPN(s)=ALL WWPNs
INFO::FCP SUB-CHANNEL 5000 Re-Initialized
WARNING::WWPN C05076FAE3000400 Could Not be Opened
DEBUG::ERROR RC:C05076FAE3000400 THINOP()=-62
DEBUG::ERROR Open FCP port has failed
WARNING::WWPN C05076FAE3000400 ignored
DEBUG::ERROR RC:C05076FAE3000400 GETLUN()=-112
INFO::FCP SUB-CHANNEL 5000 Re-Initialized
WARNING::WWPN 50060E80042CC20C Could Not be Opened
DEBUG::ERROR RC:50060E80042CC20C THINOP()=-62
DEBUG::ERROR Open FCP port has failed
WARNING::WWPN 50060E80042CC20C ignored
DEBUG::ERROR RC:50060E80042CC20C GETLUN()=-112
INFO::FCP SUB-CHANNEL 5000 RESET RC=0
INFO::END @ 20 Apr 2010 07:01:11
PROGRAM EXIT
Ready; T=6.

Re: z/VM not seeing storage from SAN

[Richard Troth]

I am a little confused about what WWPN goes where in your case.

Based on prior email, C05076FAE3000400 is the WWPN of your virtual FCP
adapter (because NPIV is in place).  It starts with a "C".  But
50060E80042CC20C looks to me more like a storage side WWPN.  What is the
"real WWPN" of your FCP adapter 5000?  Might start with "5005", though a
"5006" prefix is certainly also possible.  (Someone who knows FCP better
than I might know vendor prefixes and things like that.)

When you had Linux up (instead of CMS), what did you find in these pseudo
files?

/sys/bus/ccw/devices/0.0.5000/physical_wwpn
/sys/bus/ccw/devices/0.0.5000/wwpn

The latter should be 0xc05076fae3000400.  What is the other?
(If you did not have NPIV in effect, then the two would match or one be
zeros.)

Since you said that you have it working on one or two other systems, how to
they look by comparison?

For zoning and masking and all that, it is not clear to me that you need to
specify the real WWPN (of the HBA, of the FCP adapter) when NPIV is in
play.  Eric?  What do you say about that?  You certainly DO need to zone and
mask the storage and the fabric to the virtual WWPN (the one with the "C050"
prefix).

-- Rick;   <><





On Tue, Apr 20, 2010 at 09:13, Daniel Tate  wrote:

> To answer someone's earlier question, yes, we've seen every redbook
> imaginable related to this, tried to do a direct zfcp attach, set edev.   I
> can't give too much info away about our organization but we are using cisco
> san switches, if that makes a difference.  Both the perm and the virtual
> WWPNs are in our zone.  Port security has been toggled off then on, the
> entire CHPID has been toggled as well.   NPIV is on everywhere, NPV is off.
> Another earlier question was were we doing a lot of attaches/detaches, and
> the answer is yes.  unfortunately its not easy to read this debug
> information - at times i've had to go to the source code of the zfcp driver
> to make an educated guess at what the "perr" and "ferr" codes were with
> codes 0x0d and 0x05 (thanks to the person who clarified those).
>
> This is the output from SCSIDISC DEBUG.  We are currently trying to find
> out what THINOP()=-62 and GETLUN()=-112 indicate.
>
> EXCEPTION::Logfile SCSIDISC LOG A already exists. Delete?  (Y/N):
> y
> INFO::START @ 20 Apr 2010 07:00:58
> INFO::No of attached FCP Channels found=1
> PLEASE CHOOSE A NO CORRESPONDING TO A FCP DEVICE OR 'QUIT'
>  0) All DEVs 1) 5000
> 0
> INFO::Choosen FCP Sub-Channel Device(s)=ALL DEVICES
> INFO::FCP SUB-CHANNEL 5000 Initialized
> INFO::For Sub Channel 5000 No of WWPNs found=2
> FOR FCP SUBCHANNEL 5000
> PLEASE CHOOSE A NO CORRESPONDING TO A WWPN OR 'QUIT'
>  0) All WWPNs1) C05076FAE3000400
>  2) 50060E80042CC20C
> 0
> INFO::For 5000 Choosen WWPN(s)=ALL WWPNs
> INFO::FCP SUB-CHANNEL 5000 Re-Initialized
> WARNING::WWPN C05076FAE3000400 Could Not be Opened
> DEBUG::ERROR RC:C05076FAE3000400 THINOP()=-62
> DEBUG::ERROR Open FCP port has failed
> WARNING::WWPN C05076FAE3000400 ignored
> DEBUG::ERROR RC:C05076FAE3000400 GETLUN()=-112
> INFO::FCP SUB-CHANNEL 5000 Re-Initialized
> WARNING::WWPN 50060E80042CC20C Could Not be Opened
> DEBUG::ERROR RC:50060E80042CC20C THINOP()=-62
> DEBUG::ERROR Open FCP port has failed
> WARNING::WWPN 50060E80042CC20C ignored
> DEBUG::ERROR RC:50060E80042CC20C GETLUN()=-112
> INFO::FCP SUB-CHANNEL 5000 RESET RC=0
> INFO::END @ 20 Apr 2010 07:01:11
> PROGRAM EXIT
> Ready; T=6.10/6.11 07:01:11
>
>
>
> On Fri, Apr 16, 2010 at 5:00 AM, Eric R Farman  wrote:
>
>> Daniel,
>>
>> SCSIDISC retrieves all registered WWPNs from the switch connected to the
>> selected FCP subchannel(s).  If it only reports the one you had attached, it
>> doesn't sound like the switch zones are setup properly to let the LPAR see
>> the DASD subsystems.  Has the SAN admin registered the physical WWPN of the
>> card with the switch zone, or the NPIV WWPNs (displayed on Q FCP output)?
>>  The latter is necessary in NPIV environment.
>>
>> Regards,
>>Eric
>>
>> Eric Farman
>> z/VM I/O Development
>> IBM Endicott, NY
>>
>>
>>
>>  From:
>> Daniel Tate 
>> To: IBMVM@LISTSERV.UARK.EDU Date: 04/15/2010 10:50 AM Subject: Re: z/VM
>> not seeing storage from SAN Sent by: The IBM z/VM Operating System <
>> IBMVM@LISTSERV.UARK.EDU>
>> --
>>
>>
>>
>> scsidisc only reports those i've attached.  That particular output was
>> from a different device (i.e. 5001).. my terminology is a little off.
>> Our SAN admin swears it's configured correctly on the switch.
>>
>>
>>
>> On Thu, Apr 15, 2010 at 9:38 AM, Eric R Farman 
>> <*far...@us.ibm.com*>
>> wrote:
>> Hi Daniel,
>>
>> The WWPN listed in your Q FCP outputs and that from the SCSIDISC tool are
>> similar enough that I suspect they are different subchannels on the same FCP
>> card, and not of your target DASD subsystem.  Are there other WWPNs listed
>> in the SCSIDISC 

Re: z/VM not seeing storage from SAN

[Chip Davis]

On 4/20/10 13:13 Daniel Tate said:

This is the output from SCSIDISC DEBUG.

INFO::Choosen FCP Sub-Channel Device(s)=ALL DEVICES


... from all the available chooses ... :-)


INFO::For 5000 Choosen WWPN(s)=ALL WWPNs


At least it's consistent... :-/

-Chip-

Re: z/VM not seeing storage from SAN

[Daniel Tate]

To answer someone's earlier question, yes, we've seen every redbook
imaginable related to this, tried to do a direct zfcp attach, set edev.   I
can't give too much info away about our organization but we are using cisco
san switches, if that makes a difference.  Both the perm and the virtual
WWPNs are in our zone.  Port security has been toggled off then on, the
entire CHPID has been toggled as well.   NPIV is on everywhere, NPV is off.
Another earlier question was were we doing a lot of attaches/detaches, and
the answer is yes.  unfortunately its not easy to read this debug
information - at times i've had to go to the source code of the zfcp driver
to make an educated guess at what the "perr" and "ferr" codes were with
codes 0x0d and 0x05 (thanks to the person who clarified those).

This is the output from SCSIDISC DEBUG.  We are currently trying to find out
what THINOP()=-62 and GETLUN()=-112 indicate.

EXCEPTION::Logfile SCSIDISC LOG A already exists. Delete?  (Y/N):
y
INFO::START @ 20 Apr 2010 07:00:58
INFO::No of attached FCP Channels found=1
PLEASE CHOOSE A NO CORRESPONDING TO A FCP DEVICE OR 'QUIT'
 0) All DEVs 1) 5000
0
INFO::Choosen FCP Sub-Channel Device(s)=ALL DEVICES
INFO::FCP SUB-CHANNEL 5000 Initialized
INFO::For Sub Channel 5000 No of WWPNs found=2
FOR FCP SUBCHANNEL 5000
PLEASE CHOOSE A NO CORRESPONDING TO A WWPN OR 'QUIT'
 0) All WWPNs1) C05076FAE3000400
 2) 50060E80042CC20C
0
INFO::For 5000 Choosen WWPN(s)=ALL WWPNs
INFO::FCP SUB-CHANNEL 5000 Re-Initialized
WARNING::WWPN C05076FAE3000400 Could Not be Opened
DEBUG::ERROR RC:C05076FAE3000400 THINOP()=-62
DEBUG::ERROR Open FCP port has failed
WARNING::WWPN C05076FAE3000400 ignored
DEBUG::ERROR RC:C05076FAE3000400 GETLUN()=-112
INFO::FCP SUB-CHANNEL 5000 Re-Initialized
WARNING::WWPN 50060E80042CC20C Could Not be Opened
DEBUG::ERROR RC:50060E80042CC20C THINOP()=-62
DEBUG::ERROR Open FCP port has failed
WARNING::WWPN 50060E80042CC20C ignored
DEBUG::ERROR RC:50060E80042CC20C GETLUN()=-112
INFO::FCP SUB-CHANNEL 5000 RESET RC=0
INFO::END @ 20 Apr 2010 07:01:11
PROGRAM EXIT
Ready; T=6.10/6.11 07:01:11


On Fri, Apr 16, 2010 at 5:00 AM, Eric R Farman  wrote:

> Daniel,
>
> SCSIDISC retrieves all registered WWPNs from the switch connected to the
> selected FCP subchannel(s).  If it only reports the one you had attached, it
> doesn't sound like the switch zones are setup properly to let the LPAR see
> the DASD subsystems.  Has the SAN admin registered the physical WWPN of the
> card with the switch zone, or the NPIV WWPNs (displayed on Q FCP output)?
>  The latter is necessary in NPIV environment.
>
> Regards,
>Eric
>
> Eric Farman
> z/VM I/O Development
> IBM Endicott, NY
>
>
>
>  From:
> Daniel Tate 
> To: IBMVM@LISTSERV.UARK.EDU Date: 04/15/2010 10:50 AM Subject: Re: z/VM
> not seeing storage from SAN Sent by: The IBM z/VM Operating System <
> IBMVM@LISTSERV.UARK.EDU>
> --
>
>
>
> scsidisc only reports those i've attached.  That particular output was from
> a different device (i.e. 5001).. my terminology is a little off. Our SAN
> admin swears it's configured correctly on the switch.
>
>
>
> On Thu, Apr 15, 2010 at 9:38 AM, Eric R Farman 
> <*far...@us.ibm.com*>
> wrote:
> Hi Daniel,
>
> The WWPN listed in your Q FCP outputs and that from the SCSIDISC tool are
> similar enough that I suspect they are different subchannels on the same FCP
> card, and not of your target DASD subsystem.  Are there other WWPNs listed
> in the SCSIDISC output beyond what you have sent?  If so, what does SCSIDISC
> see with them?  If not, has the switch been told about the NPIV WWPNs that
> the VM LPAR will be using (that is, those listed in Q FCP)?  What specific
> messages do you get when varying on the EDEV?
>
> One other thing...  the FCP subchannel (5000 in your example below)
> shouldn't be attached to a particular user if it is going to be used as part
> of an EDEV.  It should be free so that VM can attach it to the SYSTEM itself
> at the time the EDEV is varied online.  (The FCP can be used for multiple
> paths/LUNs at once, so in reality the FCP should be either free or attached
> to SYSTEM.)  The ATTACH 5000 TO * command would be used for a guest to use,
> such as for SCSIDISC or Linux itself configuring SCSI.
>
> Regards,
>Eric
>
> Eric Farman
> z/VM I/O Development
> IBM Endicott, NY
>
>
>   From: Daniel Tate <*daniel.t...@gmail.com* >  To:
> *ib...@listserv.uark.edu*   Date: 04/14/2010
> 02:40 PM  Subject: z/VM not seeing storage from SAN  Sent by: The IBM z/VM
> Operating System <*ib...@listserv.uark.edu* >
>
>  --
>
>
>
>
> Disclaimer: I am a UNIX admin, working with z/VM for the first time.
> I only know basic commands and concepts, but really need to get this
> working.
>
> Our san is connected, and other LPARs can see the storage.   the CHPID
> is online.   I can attach the storage (ATTAC