IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Issues in FTPing Excel to mainframe dataset


 
IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: :: View next topic  
Author Message
venkatprasana

New User


Joined: 21 Oct 2013
Posts: 5
Location: india

PostPosted: Tue Oct 29, 2013 11:08 am
Reply with quote

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
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1230
Location: Vilnius, Lithuania

PostPosted: Tue Oct 29, 2013 1:04 pm
Reply with quote

The XLSX format is an ISO "standard". Just get a copy of ISO 29500 and implement it on z/OS.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1689
Location: Tiruppur, India

PostPosted: Tue Oct 29, 2013 1:50 pm
Reply with quote

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
View user's profile Send private message
venkatprasana

New User


Joined: 21 Oct 2013
Posts: 5
Location: india

PostPosted: Tue Oct 29, 2013 2:47 pm
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8566
Location: Dubuque, Iowa, USA

PostPosted: Tue Oct 29, 2013 3:20 pm
Reply with quote

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
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Tue Oct 29, 2013 8:50 pm
Reply with quote

Wait...what 'conversion' do you want to happen? Just to get the cell data into a flat file?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Proc print in Mainframe All Other Mainframe Topics 4
No new posts Need opinion on mainframe to cloud mi... General Talk & Fun Stuff 4
No new posts Looking for Mainframe Project Manager Mainframe Jobs 0
No new posts Mainframe jcl job with href links not... All Other Mainframe Topics 3
No new posts A very ingenious mainframe automation... CA Products 1

Back to Top