topic Re: Uploading data to four different table in Application Development and Automation Discussions

Uploading data to four different table

fhfarooqui1913 — Thu, 01 Nov 2007 21:50:11 GMT

hello..

I have a question. I have to write an interface that is suppose to read data from four different flat files and then upload the data using GUI_UPLOAD in four appropriate tables. The tables are:

ZERC_PRISM Custom general compensation information

ZERC_PRISM_LOC Custom geographic information

ZERC_PRISM_SAL Custom salary by location information

ZERC_JOB_KEY_CODE Custom job code to job key translation

The flat files are P_FILE1 for PRSIM TABLE, P_FILE2 for PRISM_LOC, P_FILE3 for PRISM_SAL and P_FILE4 for JOB_KEY_CODE tables . Once the data is read from the flat files than it has to be downloaded in the appropriate table. The data is all coma delimited.

Can you help, please.

Thanks

Re: Uploading data to four different table

Former Member — Thu, 01 Nov 2007 21:55:34 GMT

try calling the upload function in loop.

loop

upload

endloop

and set a counter to increase itself till 4 then exit.

loop.

call func 'upload'.

counter = counter + 1.

check counter le 4.

endloop.

Re: Uploading data to four different table

fhfarooqui1913 — Fri, 02 Nov 2007 13:29:58 GMT

Thanks Samir for the help. I am wondering if you have a similar program that I can look at. I understand it better by actually looking at a program.

Re: Uploading data to four different table

Former Member — Fri, 02 Nov 2007 13:33:44 GMT

So you want someone to code it for you???

Why don't you try and when you are stuck at someplace you ask a question.

And I would also say that people who help you in this way are even worse since they are getting duped into creating a program for you.

- Nishant

And you don't even know that GUI_UPLOAD is not used for uploading data in TABLES !

Message was edited by:

Nishant Rustagi

Re: Uploading data to four different table

fhfarooqui1913 — Fri, 02 Nov 2007 17:18:20 GMT

GUI_UPLOAD is for uploading into internal table not for custom tables...you smart ass....

Re: Uploading data to four different table

Former Member — Fri, 02 Nov 2007 19:43:15 GMT

hey hey hey guys....hold ur horses !! we are all proffessionals here not college kids ! lets mind our language plz.

Farhan

I think Nishant meant internal tables and not custom tables , thats understandable.

And what he has said , maybe the language was a little rude but believe me ites for ur good.

and Nishant we are not coding for him , we are just giving hime coding guidelines,he has to do the job himself eventually.

I dont have a sample program but you can upload in loop (see my earlier thread) into internal tables. and from those itabs you can use update modify or insert to populate your custom tables.

a. U have to make sure that ur internal tables have the exact same structure as ur custom table.

eg. data begin of itab1 occurs 100

include structure ztable

data end of itab1.

IIarly define itab2 itab3 and itab4.

then

loop

c = c + 1.

case c

when 1

assign itab1 to <fs>

when 2

assign itab2 to <fs>.....

when '5'.

exit.

call function gui_upload

tables

DATA_TAB = <fs>

endloop

this way u wud have all itabs uploaded.

Then

loop at itab.

move-corresponding itab1 to ztable.

modify ztable.

commit work.

endloop.

Simillarly you can modify all ur ztables.

Disclaimer

Of course there are many ways of doing this, and it soes not take into

consideration the business complexities at ur end.

Hope it helps.

Peace !!

Re: Uploading data to four different table

fhfarooqui1913 — Fri, 02 Nov 2007 22:47:27 GMT

Thank you Samir. This time I understand, and I never meant you to write the code for me. I don't know where Nishant came from. What he doesn'tunderstand is who is going to test the program for us if I have you write the code for me and who will do the knowledge transfer. You are right, Nishant is RUDE.

Thanks again Samir.