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

Active Member


Joined: 07 Feb 2009
Posts: 982
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: 1445
Location: Azeroth

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: 7908
Location: Bellevue, IA

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
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
No new posts FTP - JCL failed while passing FTP co... Suneetha1612 JCL & VSAM 12 Wed Nov 16, 2016 7:33 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Developer requirement in Ku... capricorn Mainframe Jobs 0 Sun Oct 23, 2016 3:49 pm
No new posts To trim spaces in a pipe delimited da... Nish84 COBOL Programming 16 Mon Oct 10, 2016 1:54 pm


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