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
 

 

Export data into an Excel sheet from a flat file.....

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News
View previous topic :: :: View next topic  
Author Message
poshabrar

New User


Joined: 10 Jul 2006
Posts: 23

PostPosted: Sun Nov 23, 2008 5:42 pm    Post subject: Export data into an Excel sheet from a flat file.....
Reply with quote

I have data stored in a flat file with comma or semicolon as delimiter.... I want to FTP this data directly into an excel sheet on my desktop without any manual intervention.

How should I code my SYSIN ?
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Sun Nov 23, 2008 5:56 pm    Post subject:
Reply with quote

Hi,

'am not very sure that what you trying to do can be done without any manual intervention, however, You may like to have a look on this current similar topic:

http://ibmmainframes.com/viewtopic.php?t=36167&highlight=excel
Back to top
View user's profile Send private message
poshabrar

New User


Joined: 10 Jul 2006
Posts: 23

PostPosted: Sun Nov 23, 2008 6:22 pm    Post subject: Reply to: Export data into an Excel sheet from a flat file..
Reply with quote

Hi Anuj,

Thanks for your response. But as I said there should no manual intervention in creating that excel.(This means that the excel should automatically be created based on the data from the dataset and it should identify that the comma or semicolon is the delimter)


Do let me know if you have any further suggestions/comments to add....
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Sun Nov 23, 2008 6:40 pm    Post subject:
Reply with quote

Hi,

No, Excel files are not mainframe compatible, so you can not do it the way you are asking - instead You can create a comma or tab delimited text file or a HTML file, transfer that to your PC and import into Excel.
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4649
Location: Raleigh, NC, USA

PostPosted: Sun Nov 23, 2008 7:03 pm    Post subject: Reply to: Export data into an Excel sheet from a flat file..
Reply with quote

Create the data in XML. That format can be used directly by Excel.
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 456
Location: Belgium

PostPosted: Sun Nov 23, 2008 7:57 pm    Post subject:
Reply with quote

File with SLK extension ( on PC ) is another option.
Back to top
View user's profile Send private message
Itanium

Active User


Joined: 22 Jan 2006
Posts: 114
Location: India

PostPosted: Mon Apr 20, 2009 7:34 pm    Post subject: Re: Reply to: Export data into an Excel sheet from a flat fi
Reply with quote

superk wrote:
Create the data in XML. That format can be used directly by Excel.


superk,
is there any reference on how to do this ?

We have a Mainframe file that is delimited by '|', and we donwload that to PC and export to Excel.

This is a repetative process and we would need someway to automate the same. Please help.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Mon Apr 20, 2009 7:39 pm    Post subject:
Reply with quote

Quote:

We have a Mainframe file that is delimited by '|', and we donwload that to PC and export to Excel.

This is a repetative process and we would need someway to automate the same. Please help.


You can automate this process using excel VB macro.

They are very simple to learn.
Back to top
View user's profile Send private message
Itanium

Active User


Joined: 22 Jan 2006
Posts: 114
Location: India

PostPosted: Tue Apr 28, 2009 7:34 pm    Post subject:
Reply with quote

Thanks Sambhaji. I was able to automate the same.

Recorded a macro to import and format procedure for the three files, save those formatted files as excel files, saved the macro in an excel sheet and set that Macro to execute on opening this excel file.

Wrote a DOS Batch to ftp the files and automatically open this excel file.

Now i just double click the DOS Batch file, it downloads, formats the downloaded text file and saves it as excel file. This is saving more than an hour for me daily.

Thanks a lot for the hint u gave.
Back to top
View user's profile Send private message
pdighade

New User


Joined: 21 Jul 2008
Posts: 40
Location: pune

PostPosted: Fri Mar 26, 2010 12:59 pm    Post subject: Reply to: Export data into an Excel sheet from a flat file..
Reply with quote

Hello ,

Can you please let me know how you
Wrote a DOS Batch to ftp the files and automatically open this excel file.

B'cz i will have to do the same thing

Thanks in advance
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Mar 26, 2010 2:26 pm    Post subject:
Reply with quote

One place to start with: Click.
Back to top
View user's profile Send private message
Vishwamurthy

New User


Joined: 11 Mar 2008
Posts: 57
Location: India

PostPosted: Mon Aug 16, 2010 7:09 pm    Post subject: Re: Reply to: Export data into an Excel sheet from a flat fi
Reply with quote

superk wrote:
Create the data in XML. That format can be used directly by Excel.


Hi!
Can you please give additional details on how this should be done?
A step-by-step guide or a quick reference would be much appreciated..

Do we have to create an XML on mainframe? or Do we have a procedure/tool to import a flat file's data into XML file on my desktop?

Vishwa
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 -> PC Guides & IT News All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm


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