Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 1120
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: 1619
Location: Oregon

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: 8405
Location: Dubuque, Iowa, 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 SFTP connection to Mainframe Shinoj Vijayakumar TSO/ISPF 3 Thu Nov 15, 2018 2:02 pm
No new posts Mainframe + Card domain exp. req. 5-6... capricorn Mainframe Jobs 0 Wed Oct 24, 2018 5:10 pm
No new posts Get line number where cursor is from ... satish.ms10 CLIST & REXX 3 Wed Oct 24, 2018 12:23 am
No new posts 3-6 years - Mainframe Opennings in HS... Saikat Sengupta Mainframe Jobs 0 Mon Oct 22, 2018 2:57 pm
No new posts Ideas to motivate mainframe team mc77in All Other Mainframe Topics 6 Wed Oct 10, 2018 4:59 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us