View previous topic :: View next topic
|
Author |
Message |
venkatprasana
New User
Joined: 21 Oct 2013 Posts: 5 Location: india
|
|
|
|
I am trying to FTP an excel file to mainframe dataset using batch process through sysin.
Ex of sysin:
server link
username
pasword
directory
get file.xlsx 'mainframe.file.name' (replace
quit
Using the above sysin if i FTP a text file the data is transferred correctly but if i ftp an excel file i am getting junk values. Should i need to convert the xls file to any other format. Can that conversion be done in mainframe itself. Or should i need to include any commands in the above mentioned sysin for transferring the excel file. |
|
Back to top |
|
|
prino
Senior Member
Joined: 07 Feb 2009 Posts: 1306 Location: Vilnius, Lithuania
|
|
|
|
The XLSX format is an ISO "standard". Just get a copy of ISO 29500 and implement it on z/OS. |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
venkatprasana,
Quote: |
Can that conversion be done in mainframe itself. |
I don't think you could do it with FTP & vanilla Z/Os.
You could save the Excel file as CSV file or Space delimited or tab delimited on Windows(if the Excel file has single sheet)
Transfer the CSV file or Space delimited or tab delimited file to mainframe the same way you FTP'ed the text file. |
|
Back to top |
|
|
venkatprasana
New User
Joined: 21 Oct 2013 Posts: 5 Location: india
|
|
|
|
vasanthz wrote: |
venkatprasana,
Quote: |
Can that conversion be done in mainframe itself. |
I don't think you could do it with FTP & vanilla Z/Os.
You could save the Excel file as CSV file or Space delimited or tab delimited on Windows(if the Excel file has single sheet)
Transfer the CSV file or Space delimited or tab delimited file to mainframe the same way you FTP'ed the text file. |
I have tried it and it is working fine after converting the excel into CSV or PRN format. But wanted to check if those conversions can be done in mainframe itself. Thansk Vasanth. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
I've seen at least one program that claims to be able to handle Excel data on the mainframe. If I get a chance, I'll find the company again and post it here. However, be aware that such software will cost tens of thousands (or hundreds of thousands) of US dollars for your site (mainframe software is not cheap), so you will have to convince your management that spending the money provides enough benefits. |
|
Back to top |
|
|
Ed Goodman
Active Member
Joined: 08 Jun 2011 Posts: 556 Location: USA
|
|
|
|
Wait...what 'conversion' do you want to happen? Just to get the cell data into a flat file? |
|
Back to top |
|
|
|