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
 

 

Issues in FTPing Excel to mainframe dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
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    Post subject: Issues in FTPing Excel to mainframe dataset
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: 1031
Location: Oostende, Belgium

PostPosted: Tue Oct 29, 2013 1:04 pm    Post subject:
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: 1510
Location: Chennai

PostPosted: Tue Oct 29, 2013 1:50 pm    Post subject:
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    Post subject:
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: 8132
Location: East Dubuque, Illinois, USA

PostPosted: Tue Oct 29, 2013 3:20 pm    Post subject:
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    Post subject:
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    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 Allianz Technology - Mainframe 3+ Yea... sooraj184 Mainframe Jobs 0 Mon Jul 31, 2017 2:17 pm
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm
No new posts Extra character appears in file when ... Balu5491 All Other Mainframe Topics 1 Wed Jul 26, 2017 2:39 pm
No new posts Mainframe Opening in Chennai ( 2 to 4... muralikrishnan_new Mainframe Jobs 0 Tue Jul 18, 2017 2:20 pm
No new posts Browse dataset cvnlynn CLIST & REXX 4 Tue Jul 18, 2017 3:52 am


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