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
 

 

Mainframe sequential/VSAM file to Excel Sheet transfer

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
sachin.mandaliya

New User


Joined: 17 Jan 2007
Posts: 24
Location: India

PostPosted: Fri Mar 13, 2009 4:29 pm    Post subject: Mainframe sequential/VSAM file to Excel Sheet transfer
Reply with quote

Can we transfer mainframe sequential file to directly to Excel Sheet and vice versa?
Back to top
View user's profile Send private message

himanshu7

Active User


Joined: 28 Aug 2007
Posts: 131
Location: At Desk

PostPosted: Fri Mar 13, 2009 4:34 pm    Post subject:
Reply with quote

Yes we can transfer the file..
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Mar 13, 2009 5:12 pm    Post subject:
Reply with quote

himanshu7 wrote:
Yes we can transfer the file..


But can we transfer it exactly as requested ?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Mar 14, 2009 12:32 am    Post subject:
Reply with quote

Hello,

Quote:
Yes we can transfer the file..
No, not directly. . .

One way to transfer data between the mainframe and microsoft applications is to create and transfer delimited data.
Back to top
View user's profile Send private message
himanshu7

Active User


Joined: 28 Aug 2007
Posts: 131
Location: At Desk

PostPosted: Mon Mar 16, 2009 9:27 am    Post subject:
Reply with quote

Yes the format would not be the same..
Back to top
View user's profile Send private message
sachin.mandaliya

New User


Joined: 17 Jan 2007
Posts: 24
Location: India

PostPosted: Mon Mar 16, 2009 3:58 pm    Post subject: Reply to: Mainframe sequential/VSAM file to Excel Sheet tran
Reply with quote

How can we do that ?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon Mar 16, 2009 5:21 pm    Post subject:
Reply with quote

Translate your data into a delimited file, such as a comma to delimit each field.

Transfer to the PC.

And on the PC, open Excell and import the data.
Back to top
View user's profile Send private message
sachin.mandaliya

New User


Joined: 17 Jan 2007
Posts: 24
Location: India

PostPosted: Tue Mar 17, 2009 2:40 pm    Post subject: Reply to: Mainframe sequential/VSAM file to Excel Sheet tran
Reply with quote

Thanks expat,

This will work fine, but is vice versa possible, I mean to transfer Excel sheet data to mainfare file directly ?
Back to top
View user's profile Send private message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India

PostPosted: Tue Mar 17, 2009 3:59 pm    Post subject: Reply to: Mainframe sequential/VSAM file to Excel Sheet tran
Reply with quote

Hi sachin.mandaliya,
yes thats possible
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Mar 17, 2009 5:14 pm    Post subject:
Reply with quote

Reverse process, save the Excell as a csv, upload to the mainframe,
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Mar 17, 2009 7:14 pm    Post subject:
Reply with quote

Hello,

Quote:
I mean to transfer Excel sheet data to mainfare file directly
If you mean send the .xls file directly - no. You might accomplish the transfer, but will have major difficulty using the data.

You should do as suggested and save the file on the pc as a delimited text file and then upload that delimited text file to the mainframe.
Back to top
View user's profile Send private message
mtaylor

Active User


Joined: 20 Feb 2009
Posts: 108
Location: Kansas City

PostPosted: Wed Mar 18, 2009 5:52 pm    Post subject:
Reply with quote

When saving an Excel file to a csv (comma separate, can use tabs or specify the character also). Specifically the problems you run into when placing this type of file on the mainframe are:


    you must turn off formatting in Excel before exporting
    numeric values will may not have enough digits (989 instead of 000989 for PIC 9(6) example)
    String values will not have enough spaces ('John Doe' inplace of 'John Doe ') for a PIC X(12) field


I wrote a tool for a previous employer that parsed a Cobol copybook and did this formatting on the PC before uploading a few years ago. Unfortunately the rights remain with that company.
Back to top
View user's profile Send private message
genesis786

Active User


Joined: 28 Sep 2005
Posts: 210
Location: St Katherine's Dock London

PostPosted: Wed Mar 18, 2009 6:16 pm    Post subject:
Reply with quote

also..

using csv might be a problem while transfering from m/f to xls -- if ur data contains commas in it.. e.g. addresses, or names etc..
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Wed Mar 18, 2009 6:23 pm    Post subject:
Reply with quote

genesis786 wrote:
also..

using csv might be a problem while transfering from m/f to xls -- if ur data contains commas in it.. e.g. addresses, or names etc..


Use a tab delimited rather than comma delimited dataset.
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 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 CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm


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