Is it possible to make import option in SAP Sourcing/CLM automate ?

[gopalarao_p]

Hi Team,

We have a situation, where we need to automate the IMPORT/EXPORT option in CLM so system can load the masterdata file (excel or .CSV) from the FTP folder to CLM and has to update to data through schedule job.

Is there any option to automate the IMPORT /EXPORT option under system admin tab .

Thanks & regards,

Gopal.P

[Former Member · Accepted solution]

Gopal,

SAP Sourcing/CLM provides a Schedule Task of type Data Import Monitor. You may configure this task to be run at an interval of 1 min. You may also configure directories under Data Import Task Configuration. This would automate the Import process.

In a similar way, you can us the Schedule Task of type Report Execution Task to automate the Export process. Please make sure you provide proper read/write permissions to the FTP directories when you configure this setup.

muralidharankm

[gopalarao_p]

Thanks muralidharan , it works i have used data import monitor.

i tried with another option but it didn't succeed.

I have used explicitly called script to schedule a job to call the file into FTP folder and for loading into CLM system a script has been created where i have given the user access details which system will loads successfully into CLM system.