automation for data entry

mundul333 · New User Joined: 28 Nov 2005 Posts: 9 Location: mumbai

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.

dick scherrer · Posted: Mon May 12, 2008 8:50 pm

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).

superk · Posted: Mon May 12, 2008 8:56 pm

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.

mundul333 · New User Joined: 28 Nov 2005 Posts: 9 Location: mumbai

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

dick scherrer · Posted: Fri May 16, 2008 7:03 pm

Hello,

Not that i'm aware of.

Additionally, many organizations do not permit online access to PS files.

superk · Posted: Fri May 16, 2008 7:09 pm

mundul333 · New User Joined: 28 Nov 2005 Posts: 9 Location: mumbai

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 .