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
 

 

FTP excel file to mainframe dataset

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
kunal jain

New User


Joined: 19 May 2011
Posts: 59
Location: India

PostPosted: Sun Apr 12, 2015 2:25 am    Post subject: FTP excel file to mainframe dataset
Reply with quote

Hi

I need to import excel file to ZOS mainframe. When I FTP excel file to mainframe dataset using 3.6 option, data in mainframe dataset is coming as junk-value or not readable.

Is there a way to import Excel file to mainframe dataset properly. Thanks for your help in advance !
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7234

PostPosted: Sun Apr 12, 2015 3:06 am    Post subject: Reply to: FTP excel file to mainframe dataset
Reply with quote

Depends what you mean by an Excel file. If you mean a "CSV" or "TXT" file, then yes, just make sure you tell it to do ASCII to EBCDIC conversion.

If you mean a speadsheet itself, it depends what you want to do with it.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Sun Apr 12, 2015 3:16 am    Post subject:
Reply with quote

If you want to transfer an Excel file to the mainframe, there are several things to consider:

1. If the spreadsheet has a single tab, using .TXT or .CSV format will transfer the data.

2. If the spreadsheet has multiple tabs, convert each to a .TXT or .CSV format and transfer them separately.

3. If you want to transfer the Excel file directly and use it, you could convince your company to spend the $100,000 (or more) required to buy one of the software products that can handle Excel files on the mainframe. If your site already has such a product, then use it.

4. Or you could get a copy of the Excel file specification (well over 1,000 pages the last time I looked), and use that to write a mainframe program to directly read and process the data yourself -- this probably won't take more than a year or so (with enough people on the project).
Back to top
View user's profile Send private message
kunal jain

New User


Joined: 19 May 2011
Posts: 59
Location: India

PostPosted: Sun Apr 12, 2015 5:49 am    Post subject:
Reply with quote

Thank Robert for your response.

Can you please tell me how do i convert excel spreadsheet(.xls) into .csv format.

Thanks
Back to top
View user's profile Send private message
steve-myers

Active User


Joined: 30 Nov 2013
Posts: 461
Location: The Universe

PostPosted: Sun Apr 12, 2015 10:37 am    Post subject:
Reply with quote

The Excel program will do it.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Sun Apr 12, 2015 5:51 pm    Post subject:
Reply with quote

In Excel, File -> Save As and select the appropriate format.
Back to top
View user's profile Send private message
Radhika Nambiar

New User


Joined: 30 Mar 2016
Posts: 7
Location: INDIA

PostPosted: Wed Mar 30, 2016 5:20 pm    Post subject:
Reply with quote

Hi All. I have a excel in CSV format. Now I need to load it into a dataset so that it can be read from a program. This can be done by a JCL rite?
Back to top
View user's profile Send private message
prino

Active Member


Joined: 07 Feb 2009
Posts: 984
Location: Oostende, Belgium

PostPosted: Wed Mar 30, 2016 5:39 pm    Post subject:
Reply with quote

Don't attach new postings to old threads!

What is a "JCL rite".

Most of us probably know about "last rites", but I'm sure all of us are curious about "JCL rites".
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Wed Mar 30, 2016 6:09 pm    Post subject:
Reply with quote

Quote:
This can be done by a JCL rite?
First, this a forum for professional programmers -- if you meant "right" by "rite", then you saved one letter typing and caused a lot of questions to people reading your post. As a professional, you are expected to use proper English in your posts and using "rite" for "right" is not proper English. If you actually meant "rite", you'll have to explain that to us since it makes no sense to me.

Second, if the .CSV file is on a server then yes you can use a JCL to FTP the .CSV file to a mainframe data set. Will the JCL work? Well, that depends upon a number of factors -- such as whether or not the server has FTP listening, if your mainframe user id has access to the directory and file, and so forth.

If the .CSV file is on your PC (laptop or desktop doesn't matter) you have two choices: move it to a server you can use JCL to FTP from, or use FTP on your PC to FTP the file to the mainframe. Note that in this case there will not, under ANY circumstances, be JCL involved so the answer to your question would be no, this cannot be done by JCL.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Wed Mar 30, 2016 6:25 pm    Post subject:
Reply with quote

Robert Sample wrote:
First, this a forum for professional programmers -- if you meant "right" by "rite", then you saved one letter typing and caused a lot of questions to people reading your post. As a professional, you are expected to use proper English in your posts and using "rite" for "right" is not proper English. If you actually meant "rite", you'll have to explain that to us since it makes no sense to me.

A JCL rite probably involves robes, chanting, incense, and sacrificing chickens, like setting up a SCSI chain.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Wed Mar 30, 2016 6:36 pm    Post subject:
Reply with quote

Quote:
A JCL rite probably involves robes, chanting, incense, and sacrificing chickens, like setting up a SCSI chain.
Not again! I just got the chicken blood off the box from the LAST time! icon_biggrin.gif
Back to top
View user's profile Send private message
Radhika Nambiar

New User


Joined: 30 Mar 2016
Posts: 7
Location: INDIA

PostPosted: Wed Mar 30, 2016 7:02 pm    Post subject:
Reply with quote

Sorry about the unprofessional language used by me.

Thank you all for your time.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Wed Mar 30, 2016 10:03 pm    Post subject:
Reply with quote

locking as the question is in the beginner's forum.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    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 Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
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 File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts FTP - JCL failed while passing FTP co... Suneetha1612 JCL & VSAM 12 Wed Nov 16, 2016 7:33 pm


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