|
View previous topic :: View next topic
|
| Author |
Message |
sachin.mandaliya
New User
Joined: 17 Jan 2007
Posts: 24
Location: India
|
|
|
|
| Can we transfer mainframe sequential file to directly to Excel Sheet and vice versa? |
|
| Back to top |
|
 |
himanshu7
Active User
Joined: 28 Aug 2007
Posts: 131
Location: At Desk
|
|
|
|
| Yes we can transfer the file.. |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales
|
|
|
|
| himanshu7 wrote: |
| Yes we can transfer the file.. |
But can we transfer it exactly as requested ? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
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 |
|
|
himanshu7
Active User
Joined: 28 Aug 2007
Posts: 131
Location: At Desk
|
|
|
|
| Yes the format would not be the same.. |
|
| Back to top |
|
|
sachin.mandaliya
New User
Joined: 17 Jan 2007
Posts: 24
Location: India
|
|
|
|
| How can we do that ? |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales
|
|
|
|
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 |
|
|
sachin.mandaliya
New User
Joined: 17 Jan 2007
Posts: 24
Location: India
|
|
|
|
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 |
|
|
anandinmainframe
Active User
Joined: 31 May 2007
Posts: 171
Location: India
|
|
|
|
Hi sachin.mandaliya,
yes thats possible |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales
|
|
|
|
| Reverse process, save the Excell as a csv, upload to the mainframe, |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
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 |
|
|
mtaylor
Active User
Joined: 20 Feb 2009
Posts: 108
Location: Kansas City
|
|
|
|
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 |
|
|
genesis786
Active User
Joined: 28 Sep 2005
Posts: 210
Location: St Katherine's Dock London
|
|
|
|
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 |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| 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 |
|
|
|
|
