job scheduling

[Former Member]

i wanna upload data from excel to database table through function module gui_upload by scheduling a job.

please help me with possible code.

if wanna schedule a job can i upload data in intervals?

for instance if i have 100 records at specific time suppose at 12:00 i wanna send 20 records likewise every 5 mins i wanna send 20 records each.

is this possible by job scheduling.

please help me with code.

Thanks in advance.

[Former Member]

i wanna upload data from excel to database table through function module gui_upload by scheduling a job.

please help me with possible code.

if wanna schedule a job can i upload data in intervals?

for instance if i have 100 records at specific time suppose at 12:00 i wanna send 20 records likewise every 5 mins i wanna send 20 records each.

is this possible by job scheduling.

please help me with code.

Thanks in advance.

[Former Member]

Hi,

You cant upload data using GUI_UPLOAD in a background job.

Instead place the file on application server using transaction CG3Z & use OPEN Dataset to open the file.

Best regards,

Prashant

[Former Member]

Hi,

Another way is to use an LSMW recording to udpate the data from the xls/txt file into the tables...(Check if a BAPI is available for updation or do a BDC recording)

Reward if useful

Regards

Shiva

[JoffyJohn]

report with function gui_upload cannot be background schedule.

Write a program to store the data in Application server location using Open data set

and background schedule that program

[Former Member]

In background mode the UPLOAD download functionalities doesn't work.........

There is other options how to run GUI_UP.. GUI_DOw in background mode that is complex..do have to change some file settings iin the PC...

So waht u generally do in background mode is read from application server

[Former Member]

You can use

WAIT UPTO 300 SECONDS.

Send 20 records.

then wait.

Do that in a loop.

And schedule that in background