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 spreads
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
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"
ava
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...@list
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
Se
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
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...@lists
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
>problem
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 2
...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
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
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 w
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.
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
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@
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-6
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 sep
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
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 deli
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_versio
Another possibility is the symbolic link format file (SYLK).
.
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@LISTSER
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 manipulatio
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 a
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 ad
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-
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
27 matches
Mail list logo