IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Mainframe sequential/VSAM file to Excel Sheet transfer


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
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
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
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: 8797
Location: Welsh Wales

PostPosted: Fri Mar 13, 2009 5:12 pm
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

Moderator Emeritus


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

PostPosted: Sat Mar 14, 2009 12:32 am
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
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
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: 8797
Location: Welsh Wales

PostPosted: Mon Mar 16, 2009 5:21 pm
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
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
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: 8797
Location: Welsh Wales

PostPosted: Tue Mar 17, 2009 5:14 pm
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

Moderator Emeritus


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

PostPosted: Tue Mar 17, 2009 7:14 pm
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Mainframe openings in Techmahnidra fo... Mainframe Jobs 0
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top