Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Doubt on XMITIP

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
vicharapusrinu
Warnings : 1

New User


Joined: 04 Dec 2006
Posts: 63
Location: Hyderabad

PostPosted: Wed Feb 22, 2012 7:58 pm    Post subject: Doubt on XMITIP
Reply with quote

Hi,

Can some one help me out?

I am using XMITIP, to email CSV file as an attachment, to xxx.yyy@zzz.com

Everything is working fine, is but header is not coming properly, i.e header should be bit bold and in red colour
What changes I need to made for my below control card?


Code:
%XMITIP xxx.yyy@zzz.com
        NOMSG FILE 'AAA.BBB.CCC'       
        FROM xxx.yyy@zzz.com
        SUBJECT 'CSV TEST FILE' FORMAT CSV       
        FILENAME REPORT.CSV                     
        FORMAT CSV/W-BLUE//4///Y       


In XMITIP manual the below line has been mentioned

Quote:
FORMAT type/option
FORMAT HTML/color/suffix/font-size/banner/table/header/wrap/semicolon
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Feb 26, 2012 4:34 am    Post subject:
Reply with quote

Hello,

Is this header within the csv file?

I am not aware of a way to specify colors within a simple csv file. . .

Possibly i misunderstand,
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Sun Feb 26, 2012 4:52 am    Post subject: Reply to: Doubt on XMITIP
Reply with quote

if instead of inventing Your own parameter/keyword combination
You had followed the manual advice You might have gotbetter results
for what effing reason, since You noticed it, instead of using FORMAT CSV/W-BLUE//4///Y
You did not follow the manual' s advice to use something along the lines of
Quote:
FORMAT HTML/color/suffix/font-size/banner/table/header/wrap/semicolon


if You will take some more time to meditate agian on XMITIP manual
You will easily find the explanation of the parameters needed to convert a CSV file into an HTML table

Quote:
Table may be Yes or No (or null) and indicates that the input file is a CSV file that should be converted to an HTML table.

at http://www.lbdsoftware.com/XMITIP-Guide.pdf

but refusing as You have done until now to try to understand the manual
You will just keep on wasting people time
Back to top
View user's profile Send private message
vicharapusrinu
Warnings : 1

New User


Joined: 04 Dec 2006
Posts: 63
Location: Hyderabad

PostPosted: Mon Mar 05, 2012 8:04 pm    Post subject: Reply to: Doubt on XMITIP
Reply with quote

Hi Dick scherrer,


Sorry for late reply,

YES, header also is in CSV format,
it is OK, if color will not come in excel,
I am happy, at least, if font in excel in “Courier New” font.

Please accept my apologies, if I am troubling you.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8117
Location: East Dubuque, Illinois, USA

PostPosted: Mon Mar 05, 2012 8:19 pm    Post subject:
Reply with quote

From Microsoft, you can find Excel formatting and features that are not transferred to other file formats
Quote:
CSV (Comma delimited)

This file format (.csv) saves only the text and values as they are displayed in cells of the active worksheet. All rows and all characters in each cell are saved. Columns of data are separated by commas, and each row of data ends in a carriage return. If a cell contains a comma, the cell contents are enclosed in double quotation marks.

If cells display formulas instead of formula values, the formulas are converted as text. All formatting, graphics, objects, and other worksheet contents are lost. The euro symbol will be converted to a question mark.

Note If your workbook contains special font characters such as a copyright symbol (©), and you will be using the converted text file on a computer with a different operating system, save the workbook in the text file format that is appropriate for that system. For example, if you are using Windows and want to use the text file on a Macintosh computer, save the file in the CSV (Macintosh) format. If you are using a Macintosh computer and want to use the text file on a system running Windows or Windows NT, save the file in the CSV (Windows) format.
Since .CSV saves text and values, and ONLY text and values, you cannot specify a font.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm
No new posts Doubt in MFS abdulrafi IMS DB/DC 2 Fri Oct 21, 2016 3:09 pm
No new posts Doubt on GETMAIN, FREEMAIN behaviour Arunkumar Chandrasekaran CICS 3 Sun Aug 30, 2015 9:22 pm
No new posts XMITIP, sending the mainframe data in... dharmaraok TSO/ISPF 7 Fri Aug 21, 2015 4:29 pm
No new posts JCL -> Rexx -> XMITIP : Doesnt ... enrico-sorichetti CLIST & REXX 2 Thu Aug 06, 2015 11:09 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us