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
 

 

automation for data entry

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

New User


Joined: 28 Nov 2005
Posts: 9
Location: mumbai

PostPosted: Mon May 12, 2008 8:36 pm    Post subject: automation for data entry
Reply with quote

I have my input file as a spreadsheet file. From these files I need to manually see the file and then do the data entry in the CICS screen or focus screen.

Now what I want is that I want to automate this manual process of doing it myself data entry.

Is there some way so that I can do it automatically, i.e. maybe some tool to be used so that it picks up the data from the spreadsheet file and puts it in the online screen.

I know that this can be done by QTP but since QTP is very costly this option is not valid for me.
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: Mon May 12, 2008 8:50 pm    Post subject:
Reply with quote

Hello,

You might consider creating a delimited file from the spreadsheet and uploading that data to the mainframe. There would be no "data entry" in cics and/or focus if you worked from an uploaded file.

If you need to stay "online", you can copy/paste individual fields, but otherwise you will probably need to invest in some product (like QTP).
Back to top
View user's profile Send private message
superk

Moderator Team Head


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

PostPosted: Mon May 12, 2008 8:56 pm    Post subject: Reply to: automation for data entry
Reply with quote

There MIGHT be a possibility that this could be done through a 3270-emulation program that provides a scripting facility. However, discussions on such topics are considered Off-Topic for these forums.
Back to top
View user's profile Send private message
mundul333

New User


Joined: 28 Nov 2005
Posts: 9
Location: mumbai

PostPosted: Fri May 16, 2008 2:14 pm    Post subject:
Reply with quote

is it possible to read a PS file thru rexx code and then pass the data to the CICS or FOCUS online screen?
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: Fri May 16, 2008 7:03 pm    Post subject:
Reply with quote

Hello,

Not that i'm aware of.

Additionally, many organizations do not permit online access to PS files.
Back to top
View user's profile Send private message
superk

Moderator Team Head


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

PostPosted: Fri May 16, 2008 7:09 pm    Post subject:
Reply with quote

mundul333 wrote:
is it possible to read a PS file thru rexx code and then pass the data to the CICS or FOCUS online screen?


Yes. Our shop uses a product from BMC called Open Systems Protocol Interface (OSPI) that we use to do just such tasks.
Back to top
View user's profile Send private message
mundul333

New User


Joined: 28 Nov 2005
Posts: 9
Location: mumbai

PostPosted: Sat May 17, 2008 8:16 pm    Post subject:
Reply with quote

Thanks for all ure suggestion and help. Kevin is it possible that u can give me the OSPI tool so that i can test it. If possible plz tell me also how to use it.

Today i was trying to automate this thru the Macro option available in our Mainframe Emulator . I have IBM perosnal comm as my mainframe emulator thru which i connect to mainframe.
I started the start marco and then i did some data entry manually in the CICS screen. After doing the data entry i stopped the marco and then after that i played the macro once again. Now this macro does exactly what i had done in the screen when i started the marco and ended the macro. But now the problem is that when i run the macro it writes the same data which i had copied from the excel and pasted in the screen.

Now i want to customize this macro in such a way that it reads eitther a file in mainframe and puts the record from the file when i start the macro or it reads a excel file present in my hard disk and then puts the data on my CICS screen when the marco is played.

IF u can help me to customize this macro ,, it would really greatful .
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 Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 0 Mon Jan 02, 2017 11:16 am
No new posts JES2 JEC: Use UNIX Pipes to Pass Data... Virendra Shambharkar JCL & VSAM 21 Tue Dec 20, 2016 6:55 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am


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