SAP Knowledge Base Article - Public

2326654 - RoambiScript: How do I create a folder in the SAP Roambi Library and add local xls/csv files?

Symptom

In this article we will cover the steps needed to leverage RoambiScript to create a folder in the SAP Roambi Library and add a local xls file to this newly-created folder.

Environment

  • SAP Roambi Cloud

Resolution

  1. Prerequisites:

    1. Create a Roambi API client
    2. Download RoambiScript
    3. Install Java
    4. Create Properties File

    Now that all the pieces are in place, let's get started.

    1. Download the following attachments:
      • mkdir_upload.cmd
      • mkdir_upload.csv

    2. Let's open up mkdir_upload.csv and evaluate the fields.

      mkdir_upload_args.png

      1. PROP_PATH this is the location and filename for the properties file that is created using the "configure" option.

      2. FOLDER: as the title implies, this is the name of the new folder you will be adding to the SAP Roambi Library.

      3. FILE: name of the file (in this case there is no path as the file is in the same folder as my RoambiScript jar file) which you will be pushing to the new folder in the SAP Roambi Library.

      4. USER_NAME: this is optional but you can designate who has rights to this file you are uploading.

      Note: If you have more than one file to upload, simply add more rows to this csv.

    3. Now let's open up mkdir_upload.cmd to see what's going to happen when it comes time to run this program.

      newcmd.png

      1. RoambiScript command to create a folder called, "folder" with permissions granted to username@email.com.

      2. FOR loop that points the program to "mkdir_upload.csv" for the following parameters:
         - PROP_PATH: path to the properties file
         - FOLDER: name of the destination folder
         - FILE: name of the local file to be pushed to the Roambi Library folder called, "folder"
         - USER_NAME: name of the Roambi user who will have access  (OPTIONAL)

      3. Setting variables for the columns in the csv file.

      4. Roambiscript command to upload the local file to the Roambi Library using the arguments from the csv file.

      5. Roambiscript command to grant folder permissions to username@email.com

      Note: Step #5 is critical as the persons credentials that are attached to the properties file need to have access to source xls/csv files in the Library as well as the folders.

    4. Open the command prompt and navigate to the folder that contains "mkdir_upload.cmd"
    5. Enter mkdir_upload.cmd

      Image3.png
    6. Hit Enter and the program will begin by creating the folder and then transferring the appropriate files into the Roambi Library.

     

    NOTE: If you have spaces in your folder or file name, make sure to wrap that portion of the command in double quotes.  Example:   "My File Name.xls".

Keywords

KBA , BI-ROM-CLD-PUB-BI , Roambi Cloud publishing clients – BI, Cognos & SSR , Problem

Product

SAP Roambi Cloud all versions

Attachments

mkdir_upload.csv
mkdir_upload.cmd