Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 16, 2017 at 11:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded