Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Blog
  • Questions
  • Learning
    • Courses
    • Certification
      • DataMiner Operator
      • DataMiner Administrator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
    • Video Library
    • Books We Like
    • Third-party Courses
    • DevOps Enablement Services
    • Quizzes
  • RESOURCES
  • Agile
    • Agile Webspace
    • Everything Agile
      • The Agile Manifesto
      • Best Practices
      • Retro Recipes
    • Methodologies
      • The Scrum Framework
      • Kanban
      • Extreme Programming
    • Roles
      • The Product Owner
      • The Agile Coach
      • The Quality & UX Coach (QX)
  • Expert Hubs
    • DataMiner DevOps Professional Program
    • DataMiner
      • DataMiner Releases & Updates
      • System Architecture
      • Integration Studio
      • Visual Overview
      • Security
    • Technologies
      • CI/CD
      • Converged Interconnect Networks
      • DOCSIS 3.1 / DAA
      • Elasticsearch
      • Kubernetes
      • Telemetry / Flow Monitoring
      • PTP
      • SDN / ST2110 / NMOS
    • Business
      • Software Business models
      • Perpetual Use or Usage-based Services
  • Discover
    • Markets
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • Solutions
    • Use Case Library
    • DataMiner Dashboards
    • DataMiner Downloads
    • DataMiner Modules
      • Core features
      • SRM features
    • DataMiner Apps
    • Professional Services
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • Pricing
  • More
    • Feature Suggestions
    • Online DataMiner Systems
    • Leaderboard
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
    • Verify a certificate
  • >> Go to dataminer.services

Is there a way to automatically make scheduled tasks from a list in Excel?

Solved217 views7th July 2023Scheduler
1
Justien Decuypere [SLC] [DevOps Advocate]203 4th July 2023 1 Comment

Hi

For retrieving daily backups from XOS encoder devices I need 260 scheduled tasks for each XOS device.

I made an Excel with all the needed information to make the scheduled task per device.

I was wondering if anybody already automatically made scheduled tasks based on a list from Excel?

Thanks in advance!

Kind regards

Justien

Marieke Goethals [SLC] [DevOps Enabler] Selected answer as best 7th July 2023
Justien Decuypere [SLC] [DevOps Advocate] commented 7th July 2023

Hi

Thank you all for the help, it indeed seems to work fine in the following way of using one scheduled task that calls an automation script that iterates across all the devices of a CI Type that then again calls the subscript that generates the actual backups. We are going to use two scheduled tasks depending on the view because the devices are running on two different DMAs, but compared to 260 tasks in the beginning, this seems acceptable to me. 😉

3 Answers

  • Active
  • Voted
  • Newest
  • Oldest
3
Leander Druwel [SLC] [DevOps Advocate]1.68K Posted 5th July 2023 2 Comments

Also adding, it might be an option to have this completely managed by our IDP suite (Inventory, Discovery and Provisioning), as it is available on the platform and is designed to not only discover and provision the elements in an automated way, but also manage the device backups.

More information on:

Configuration tab | DataMiner Docs

Marieke Goethals [SLC] [DevOps Enabler] Selected answer as best 7th July 2023
Justien Decuypere [SLC] [DevOps Advocate] commented 5th July 2023

Hi Leander, thank you for the comment. Now, it is done via IDP. In the admin page of IDP an extra CI Type is added. In the admin configuration management tab, a backup script is added. So in the configuration tab, backups can be taken based on the selected elements. Now, we make use of daily scheduled tasks per device so indeed there’s probably a better way to do this. Do you know how you can do a daily backup for all the devices of a certain CI type in IDP?

Leander Druwel [SLC] [DevOps Advocate] commented 5th July 2023

Hey Justien, I believe that is done by adding a process to IDP, and referencing the backup activity.

https://docs.dataminer.services/user-guide/Standard_Apps/IDP/Using_DataMiner_IDP/Overview_of_the_IDP_app/IDP_Processes_tab.html

4
Ben Vandenberghe [SLC] [DevOps Enabler]6.37K Posted 4th July 2023 1 Comment

I was also wondering, what is the reason that you need 260 separate tasks, one for each individual device?  If all of them need a daily back-up, it is not fine to just create one scheduled task that then starts an automation to iterate across all devices to take a back-up?

Ben Vandenberghe [SLC] [DevOps Enabler] Edited answer 4th July 2023
Justien Decuypere [SLC] [DevOps Advocate] commented 4th July 2023

Good suggestion! We’re gonna take a look at it again in our team if we could make that work.

3
Miguel Obregon [SLC] [DevOps Enabler]8.14K Posted 4th July 2023 2 Comments

Hi Justien,

In the question below you can find an example to create a scheduled task programmatically:

automation – create schedule tasks

In your script, you will need to parse the Excel file. For each row available in the file you could create a scheduled task using the example above.

Small question, does it need to be a Excel file? If possible, try to collect this information in a CSV file. Parsing a CSV file does not require extra libraries.

Hope it helps.

Miguel Obregon [SLC] [DevOps Enabler] Posted new comment 7th July 2023
Justien Decuypere [SLC] [DevOps Advocate] commented 5th July 2023

Hi Miguel, thank you for your comment. We will consider the different options brought up. But maybe better to not use this since it’s an internal call and it is not officially supported?

Miguel Obregon [SLC] [DevOps Enabler] commented 7th July 2023

Hi Justien,
In this case, I believe the answer from Leander is the best approach for your use case. In that way you don’t need to build your own automation scripts.

Please login to be able to comment or post an answer.

My Dojo Points

0 Credits
0 Reputation

Question Tag Cloud

adl2099 (54) Alarm Console (53) alarms (70) alarm template (58) API (35) Automation (144) automation scipt (65) Automation script (95) backup (54) Cassandra (142) cloud (37) Connector (44) Correlation (42) Cube (114) Dashboard (134) Dashboards (136) database (64) DataMiner Cube (37) DIS (53) DMS (48) DOM (68) driver (48) DVE (43) Elastic (73) Elasticsearch (99) elements (49) Failover (90) GQI (51) HTTP (45) IDP (55) low code app (70) low code apps (43) MySQL (50) protocol (145) QAction (58) resources (35) security (71) SNMP (56) SRM (267) SRM resources (39) timeout (35) trending (66) upgrade (44) Visio (373) Visual Overview (290)
Privacy Policy • Terms & Conditions • Contact

© 2023 Skyline Communications. All rights reserved.

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin