Import jobs consolidation into a single workbook

Follow

Ganesh Saptharishi

• October 04, 2021 12:19

Hi All,

Two questions:

1. Ownership change - is it possible for the present owner of the workbook to change the ownership to a new user without admin involved? if so how?

2. Multiple workbook execution:

Nearly 50 import jobs from a folder1 is copied to folder2.  I have the read/write access for all the import jobs copied onto folder2.  I would like to execute all the import jobs at one go and consolidate the output into a single workbook.  

In the earlier scheme of things, import jobs will be executed one by one and is added to a workbook and later did a union of all the worksheets. 

Since the group access is changed i would like to do it effectively rather than execution of each import jobs and adding the same to a workbook

Appreciate your help and thanks in advance

 

0

• 

  Konsta Danyliuk

  • October 04, 2021 13:20

  Hello, Ganesh.

  1. Without admin privileges or the User can modify every file and folder bit in the Role, a user can not change artifacts ownership.
  2. Datameer has no bulk jobs triggering. Thereby, manually, one could run ImprotJobs one by one.

  • Alternatively, you could schedule these jobs to be executed automatically at a specific time. Or trigger jobs via REST API. In this case, you would need to get their configuration IDs and create a script that will generate and execute the appropriate calls. Please refer to the Start Import/ Link/ Upload page for more details.
  • To use several ImportJobs as sources for a single Workbook, you should either add these ImportJobs into a Workbooks manually via UI or build appropriate JSON payload and create/update the Workbook.
  • If all these 50 ImportJobs bring 50 datasets that have the same schema via the same Connection, perhaps it is a good idea to consolidate all the data in a single place and then use a single ImportJob to bring the data into Datameer?

   

   

  0

  Comment actions Permalink
• 

  Ganesh Saptharishi

  • October 08, 2021 06:18

  Hi Konsta,  

   

  Thanks for your inputs.  But please let me know where to type in the Curl command.  is it on the address bar of the browser?  I entered the command but it is entering the google search

  0

  Comment actions Permalink
• 

  Konsta Danyliuk

  • October 08, 2021 09:04

  Hello, Ganesh.

  Curl is a command-line tool for transferring data using various network protocols. You need to install it on your machine and use the command-line interface to type and execute commands.

  • Curl Command in Linux with Examples
  • Installing and using Curl on Windows

  0

  Comment actions Permalink

Please sign in to leave a comment.