IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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: 1306
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: 1742
Location: Tirupur, 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: 8696
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Mainframe openings in Techmahnidra fo... Mainframe Jobs 0
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Allocated cylinders of a dataset DB2 12
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
Search our Forums:

Back to Top