| |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Hello and welcome to CertForums.co.uk, here we host free active certification forums with links to the best free resources for Microsoft's MCSA MCSE MCDBA Cisco's CCNA CCDA and CCNP, and CompTIA's A+ Network+ i-NET+ and Security+ certifications in the UK. If you wish to post or use other advanced features you will need to register first. Registration is absolutely free and takes only a few minutes to complete so sign up today! If you have any problems with the registration process or your account login, please contact support |
|
|||||||
| Home | Forums | Community | Register | Search | Today's Posts | Mark Forums Read |
|
|
|
Exporting files from IBM mainframe to Excel - possible? |
  |
|
|
Thread Tools | Display Modes |
|
#1
06-Mar-2008, 04:09 PM
|
||||
|
||||
|
Exporting files from IBM mainframe to Excel - possible?
Hi,
Does anyone know if it's possible to check the times reports run in mainframe and export the data from mainframe (job name and time the job completed) to Excel? In mainframe it's fairly easy to set up a macro to check the job, but can't work out how to export it to excel. Tried using VuGen but i don't have a protocol that'll work. Not sure if it's possible to do this, and even i could find out if it's not possible that'd be good enough for me! TIA Damo
|
|
|
|
#2
06-Mar-2008, 06:31 PM
|
||||
|
||||
|
Anything is possible if you spend enough time on it.
 We would need some more details to say how to do it. You say 'IBM mainframe' - model? Model of terminal? It is networked? Harry.
|
|
#3
06-Mar-2008, 10:05 PM
|
|||||
|
|||||
|
It certainly is possible, but could take ages. I've reverse engineered files to work on different systems that they were originally incompatible with and it takes bloody ages!
Unless you can find a readily available tool I'd assume not.  
|
|
#4
07-Mar-2008, 07:32 AM
|
||||
|
||||
|
Should be easy if you're any good at coding or scripting. You just need to write a program to get the data and write it to a file which could be a csv file for excel which is very simple.
The exact approach will depend on the situation, you could make it a standalone app that just generates csv's and then use removable media or FTP etc to move the files or you could write a network aware app with sockets or web services. How you get the report data again depends, it might be in a database, or a file or might be a system call or launching a process and piping the output to a file etc. You may have little/big endian issues or file format or character encoding issues depending on the mainframe and your approach. Most things are possible in programming with enough time and effort, alternatively you could look for an EDI tool that does the job. 
|
|
#5
31-Mar-2008, 02:34 PM
|
||||
|
||||
|
Bit of an update - could get it to work partially with VuGen using the RTE option but it would only capture the data once. I couldn't repeat it as the script wouldn't record the "send to" option.
Looks like it'll have to be done using PL/1. Cheers for the advice anyways guys, D
|
Spread this thread:
|
|
|
|
||||||
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help with script to delete files | nugget | Programming & Scripting | 3 | 28-Feb-2008 02:12 PM |
| Microsoft Finds Excel Security Flaw | zimbo | News | 0 | 22-Jan-2008 09:28 PM |
| Microsoft's Windows Home Server corrupts files | Mitzs | Networking | 9 | 30-Dec-2007 11:25 PM |
| command line interface anyone? | robbo1962 | A+ | 11 | 16-Oct-2006 07:01 PM |
All times are GMT. The time now is 09:53 PM.