cancel
Showing results for 
Search instead for 
Did you mean: 

Create and schedule job by importing excel sheet of jobs in Redwood

former_member186566
Active Participant
0 Kudos
893

I'm new to Redwood/SAP CPS, I need some clarification on below points.

Instead of creating/scheduling jobs manually in Redwood, by uploading excel sheet of jobs and by writing redwood scripts, can we create and schedule job?

or can we develop third party portal to extract jobs from excel and deploy to Redwood ? is this possible ?

Ultimately everyday i'm getting 100's of jobs to be create and schedule. I want to avoid the manual process. If i get some idea, it would be helpful .

Regards
Yokesvaran Kumarasamy

Accepted Solutions (1)

Accepted Solutions (1)

basv
Explorer
0 Kudos

Hi Yokesvaran,

In theory both options you describe are possible. But I would say the webportal method would be the most work.

You can do this with redwood script. Redwood script can create and schedule jobs.

What you can do is, create a new redwood script job definition, with a parameter field of type FILE.
Whenever you submit this job definition, you will be promted for an input file.

Then you need to write the redwood script code to read that file and process it line by line.
If your input file contains, abap name + variant for example, you can have redwood script iterate your file and create or modify jobdefinitions or schedule jobs.

But you will have to write the code for it.
If your input file is a textfile you can do with standard redwood script. If you must read excel directly, you will need an external java library (apache poi) to read excel files in java.

You also need cronacle including the scripting license.

Kind regards,

Bas Valentijn

former_member186566
Active Participant
0 Kudos

Thanks 🙂 for the clarifications B. Valentijn,

Your post seems like, we can write redwood scripts within redwood framework to extract and execute jobs from excel. is my understanding right ? or

Can we write redwood scripts with in third party portals (Say J2ee web application) by including redwood libraries ? to extract and create jobs from an Excel ?

(sry for repetitive nature of my question)

Also can you help me with Redwood script tutorials or documentations ? i tried googling, but found nothing useful.

Regards

Yokesvaran Kumarasamy

basv
Explorer
0 Kudos

The first one, Yes, you can write redwood script on the redwood system to process your excel file.

Second one, No, you can not use redwood libraries one external frameworks.

There is not a lot of info on the web about it.
You can have a look here

https://uacp2.hana.ondemand.com/doc/6f5031836c4b1014a504d193c6d75675/7.01.18/en-US/c65941fe890a44f8a...

But the best documentation is in the help of cronacle itself.
Do you have the full standalone redwood version, or the one the comes with SAP (CPS) ?

Kr,

Bas

former_member186566
Active Participant
0 Kudos

Hi B. Valentijn

I do have standalone redwood version and i'm trying to enhance this feature in redwood.

Regards
Yokesvaran Kumarasamy

Answers (0)