|
View previous topic :: View next topic
|
| Author |
Message |
vicharapusrinu
Warnings : 1
New User
Joined: 04 Dec 2006
Posts: 63
Location: Hyderabad
|
|
|
|
Can some one help me please?
With the below JCL I am able to get email which is having report by name "REPORT.CSV.TXT".TXT (As an attachment )
But contents of the attached file is NOT CSV data,
It is plain data, but is suppose to be in CSV data, so that if I open in MS excel
It has to appear in correct format.
| Code: |
//TSOB EXEC PGM=IKJEFT1B
//SYSEXEC DD DSN=XXX.YYY.ZZZ,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
%XMITIP AAA.BBB@CCC.COM +
NOMSG FILE 'AAA.BBB.CCC ' +
FROM AAA.BBB@CCC.COM +
SUBJECT 'CSV TEST FILE' FORMAT TXT +
FILENAME REPORT.CSV
/* |
Where
//SYSEXEC DD DSN=XXX.YYY.ZZZ --> is CLIST library |
|
| Back to top |
|
 |
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
| OK - where are the runtime messages? Where is the (sample) input data? Where is anything useful to help those who will try and help you? |
|
| Back to top |
|
|
Dsingh29
Active User
Joined: 16 Dec 2008
Posts: 132
Location: IBM
|
|
|
|
| give FORMAT CSV instead of TXT |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Quote: |
| give FORMAT CSV instead of TXT |
might work in Your location ...
| Quote: |
| Location: Dream Land |
not anywhere else
did You care to read the XMITIP manual before posting...
the FORMAT CSV description
| Quote: |
FORMAT CSV
The input file must be in Comma Separated Value (CSV) format and will be attached as a text file attachment with a CSV suffix. |
and the example
| Quote: |
| Code: |
//TSOB EXEC PGM=IKJEFT1B
//SYSEXEC DD DISP=SHR,DSN=rexx.exec
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
%xmitip user.name@domain.com nomsg file 'hlq.weekly.csv' –
from myname@domain.com -
subject 'CSV Test File' format txt –
filename report.csv |
/*
In this example we are sending a data set called 'hlq.weekly.csv', which contains comma separated value data.
We are using the FILENAME keyword to explicitly name the file attachment as report.csv so that it will arrive with a .CSV suffix. |
XMITIP will not do any transformation of the data, it will send it ASIS
it' s the user task to provide a properly <formatted> file
the FORMAT CSV would be used only to let XMITIP know what to do if it is told to do some additional processing,
but the file has to be already in CSV format. |
|
| Back to top |
|
|
vicharapusrinu
Warnings : 1
New User
Joined: 04 Dec 2006
Posts: 63
Location: Hyderabad
|
|
|
|
Hi,
Although I have changed FORMAT CSV instead of TXT
| Code: |
//TSOB EXEC PGM=IKJEFT1B
//SYSEXEC DD DSN=XXX.YYY.ZZZ,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
%XMITIP AAA.BBB@CCC.COM +
NOMSG FILE 'AAA.BBB.CCC ' +
FROM AAA.BBB@CCC.COM +
SUBJECT 'CSV TEST FILE' FORMAT CSV +
FILENAME REPORT.CSV
/* |
I have got email with an attachment with file name as "REPORT.CVS.CSV".CSV , and in attachment all (all 3 columns of MF data set) data has been places into first column of exel BUT I need to place 1st column of MF dataset as first column of excel and
2nd column of MF dataset as 2nd column of excel…. And so on..
The below is the output messages
| Code: |
The below is the output messages
XMITIP: Subject: CSV TEST FILE
XMITIP:
XMITIP: Process Section
XMITIP:
XMITIP: > Warning: FILENAME REPORT.CVS and Format CSV are not the same.
XMITIP: > There may be a mismatch when opening on the recipients workstation.
XMITIP: > To avoid a mismatch when opening on the recipients workstation,
an extension of '.CSV' will be added
XMITIP:
XMITIP: (001) File: 'AAA.BBB.CCC’ XMITIP: (001) Attachment filename: REPORT.CVS.CSV
XMITIP: -Input Records: 5 CSV
XMITIP: as attachment name: REPORT.CVS.CSV
0 message and 37 data records sent as 18 records to BCBSALB.SMTP
Transmission occurred on 02/22/2012 at 03:03:47.
USER LOG DOES NOT EXIST FOR USER(S) SMTP AND THE BROADCAST DATA SET CANNOT BE
XMITIP:
XMITIP: Message maximum record size is: 104
XMITIP:
XMITIP: Message successfully transmitted
XMITIP: Sent 34 records as text, attachments, and control information.
XMITIP: Approximate byte count is: 700 |
IF I change below line FORMAT CSV to FORMAT TXT
| Code: |
| SUBJECT 'CSV TEST FILE' FORMAT TXT |
I have got email with an attachment with file name as "REPORT.CVS.TXT".TXT , and in attachment all 3 columns of MF data set is placed into notepad
BUT I need to placed 1st column of MF dataset as first column of excel and
2nd column of MF dataset as 2nd column of excel…. And so on..
The below is the output messages
| Code: |
XMITIP: Process Section
XMITIP:
XMITIP: > Warning: FILENAME REPORT.CVS and Format TXT are not the same.
XMITIP: > There may be a mismatch when opening on the recipients workstation.
XMITIP: > To avoid a mismatch when opening on the recipients workstation,
an extension of '.TXT' will be added
XMITIP:
XMITIP: (001) File: 'AAA.BBB.CCC’ '
XMITIP: (001) Attachment filename: REPORT.CVS.TXT
XMITIP: -Input Records: 5 TXT
XMITIP: as attachment name: REPORT.CVS.TXT
0 message and 37 data records sent as 18 records to BCBSALB.SMTP
Transmission occurred on 02/22/2012 at 03:18:25.
USER LOG DOES NOT EXIST FOR USER(S) SMTP AND THE BROADCAST DATA SET CANNOT B
XMITIP:
XMITIP: Message maximum record size is: 104
XMITIP:
XMITIP: Message successfully transmitted
XMITIP: Sent 34 records as text, attachments, and control information.
XMITIP: Approximate byte count is: 690
READY
END
*************************** |
|
|
| Back to top |
|
|
vicharapusrinu
Warnings : 1
New User
Joined: 04 Dec 2006
Posts: 63
Location: Hyderabad
|
|
|
|
| And also please let me know how I can change/open excel from .CSV file? |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
What have YOU tried in respect of this CSV / XLS problem., which is hardly mainframe is it
Have you used google. Have you asked your peers, have you bothered to accomplish the most basic research for yourself.
Somehow I doubt it  |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
did You care to read my previous reply
and to read the xmitip manual ?
is the file You want to send in csv format ?
xmitip will not take a plain file an transform it into csv format |
|
| Back to top |
|
|
elango_K
New User
Joined: 18 Aug 2011
Posts: 44
Location: India
|
|
|
|
Hi,
Can you please post the link to the manual? |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
is it that google does not work for You ? 
the first hit returned when googling for xmitip manual was the manual link |
|
| Back to top |
|
|
vicharapusrinu
Warnings : 1
New User
Joined: 04 Dec 2006
Posts: 63
Location: Hyderabad
|
|
|
|
Hi Enrico/ Expat
Thanks for your suggestion,
I am able send email with attachment as CSV file and, I am able to view in correct format.
BUT I don’t have JCL to convert normal MF data set to CSV MF data set.
Could some one provide that JCL? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
vicharapusrinu,
at first i was going to reply with one of my normal, festive responses,
but it is obvious
that you have no idea of what is going on in the world of computers,
and thus it would have been like kicking a dog on the ground.
so,
a CSV is a Comma Separated Value formatted file.
as such, you have two alternatives:- modify the file generator (program) to output the file in CSV format
- use a sort utility to 'convert' the file
depending on the product (DFSORT, SYNCSORT, CA-SORT) at your site,
you can either look (search)- the JCL forum for SYNCSORT solutions
- the DFSORT forum for DFSORT solutions (i know that there exists a few threads)
- pray that a SYNCSORT or DFSORT solution (control cards) will work with CA-SORT or whatever,
|
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
Here is your JCL
| Code: |
// your jobcard
//STEP1 EXEC PGM=your sort program
//SYSOUT DD SYSOUT=your sysout class requirements
//SORTIN DD DISP=SHR,DSN=your input dataset (the one that needs to be converted to CSV format)
//SORTOUT DD DISP=(,CATLG,CATLG),SPACE=(required space),DSN=the datasetname of the file after conversion to CSV format
//SYSIN DD *
control cards to do the conversion
/*
|
|
|
| Back to top |
|
|
|
|
