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
 

 

Formatting data from Excel to mainframe

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
kishpra

New User


Joined: 24 May 2010
Posts: 86
Location: Pune

PostPosted: Fri Feb 19, 2016 7:12 pm    Post subject: Formatting data from Excel to mainframe
Reply with quote

I have a requirement to transfer excel (.xls) data to Mainframe. I understand that we can use SFT to transfer the data to Mainframe. But want to understand how the column data in excel will be imported to mainframe i.e.e any specific seperator we can put like comma or semi-clon in the mainframe sequential file to separately identify the Excel column data.
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


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

PostPosted: Fri Feb 19, 2016 7:31 pm    Post subject:
Reply with quote

In Excel, save the worksheet as a comma-delimited (CSV) file. You can then transfer that file to the mainframe as text. You may need to repeat the process if there is more than one worksheet in the spreadsheet.

If you want to transfer the Excel .XLS or .XLSX file to the mainframe and be able to use it at all, you either need to have a package on site (or have your site buy one), or write an application to convert the data yourself (the Microsoft file format document, the last time I looked, was over 1000 pages and growing with every release).
Back to top
View user's profile Send private message
kishpra

New User


Joined: 24 May 2010
Posts: 86
Location: Pune

PostPosted: Fri Feb 19, 2016 7:36 pm    Post subject: Reply to: Formatting data from Excel to mainframe
Reply with quote

Thanks.

I got that in Excel, save the worksheet as a comma-delimited (CSV) file. And then transfer that file to the mainframe as text.

But I need to udnerstand how the Column data from excel will be separated in mainframe sequential file.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Fri Feb 19, 2016 8:08 pm    Post subject:
Reply with quote

Well that depends on what you do in Excel. If you tell it to use commas as delimiters you will get a mainframe sequential data set with commas in it.

Rather than asking on a forum, if you had generated a file and sent it to the mainframe, you could have your answer a while ago.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1445
Location: Azeroth

PostPosted: Sat Feb 20, 2016 1:48 am    Post subject:
Reply with quote

Save the Excel file as CSV, then open it in Notepad, that's how it would look.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Feb 22, 2016 9:03 pm    Post subject:
Reply with quote

the COBOL Statement UNSTRING will be helpful.
the description, use and examples are found here
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Unwrap the data based on delimiter X'25' bhavana yalavarthi DFSORT/ICETOOL 1 Fri Dec 09, 2016 10:25 am
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
This topic is locked: you cannot edit posts or make replies. How to move a long alphanumeric data ... lind sh COBOL Programming 8 Mon Dec 05, 2016 7:51 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 ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm


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