03-24-2010 11:17 AM
Hello experts,
I am reading a local EXCEL file and processing (i.e. extending material ) and delivering a output file on the desktop ...there is no performance issue as i am reading and populating the bapi sturctres and on success committing it but its taking too long and I have loads of material to upload how can i schedule it in a background ...(Caution : remember its a local file ...!)
Need your valuable advices...! Thanks in advance
03-24-2010 11:24 AM
Well a very good advice would be that you cannot upload files from the persentation server while running the program as a background job.
03-24-2010 11:28 AM
Thanks Vikranth.Reddy
Yep I knew it but what is the solution for the same then..! or please suggest a alternate solution
03-24-2010 11:30 AM
Easy alternative would be put the file on the app server & upload the data (then again remember uploading an excel file to the app server may cause inconsistencies, try converting the excel to CSV before uploading)
You can also try FTP if you want
03-24-2010 11:34 AM
Hello,
You could upload the excel file into the application server and then read the file from the application server and run the progam in the background or you could consider the option of FTP. But it is quite a headache to do all this and it would be worth the wait as per your current way of execution.
Vikranth
03-24-2010 11:36 AM
09-23-2011 5:53 AM