Is it possible to edit roadmap planner macro with script or similar

Ari J Lahti

Was trying to find out but google failed.

Is it possible to edit roadmap planner macro programmatically (with script runner or similar)

What I need to do is to create calendar for sprints in scrum. I would know how many sprints I have and how long they would take, but I'd hate to create manually 26 instances on roadmap (every year)

Dominic Lagger

Hi @Ari J Lahti 

I would have a possible solution. It is not very easy and you need developer skills. I try to explain what my thought are.

When you save a Roadmap Planner page, the page could look like this: 

Now, you can check the Storage Format. The plugin would look like this:

<p>
<ac:structured-macro ac:name="roadmap" ac:schema-version="1" ac:macro-id="8ac912c4-e922-4b48-8e09-afb5a4602735">
<ac:parameter ac:name="maplinks" />
<ac:parameter ac:name="timeline">true</ac:parameter>
<ac:parameter ac:name="pagelinks" />
<ac:parameter ac:name="source">%7B%22title%22%3A%22Roadmap%20Planner%22%2C%22timeline%22%3A%7B%22startDate%22%3A%222019-06-07%2000%3A00%3A00%22%2C%22endDate%22%3A%222019-08-01%2000%3A00%3A00%22%2C%22displayOption%22%3A%22MONTH%22%7D%2C%22lanes%22%3A%5B%7B%22title%22%3A%22Team%201%20Lane%22%2C%22color%22%3A%7B%22lane%22%3A%22%23f6c342%22%2C%22bar%22%3A%22%23fadb8e%22%2C%22text%22%3A%22%23594300%22%2C%22count%22%3A1%7D%2C%22bars%22%3A%5B%7B%22title%22%3A%22Sprint%201%22%2C%22description%22%3A%22This%20is%20the%20first%20bar.%22%2C%22startDate%22%3A%222019-06-01%2000%3A00%3A00%22%2C%22duration%22%3A2%2C%22rowIndex%22%3A0%2C%22id%22%3A%22633c8e7c-3c2a-4341-a143-c5cded5b36c8%22%2C%22pageLink%22%3A%7B%7D%7D%2C%7B%22title%22%3A%22Sprint%202%22%2C%22description%22%3A%22This%20is%20the%20second%20bar.%22%2C%22startDate%22%3A%222019-08-01%2007%3A21%3A58%22%2C%22duration%22%3A1%2C%22rowIndex%22%3A1%2C%22id%22%3A%22e7734b5c-0639-44f9-9ef5-8c8c7f72bc21%22%2C%22pageLink%22%3A%7B%7D%7D%5D%7D%5D%2C%22markers%22%3A%5B%7B%22title%22%3A%22Today%22%2C%22markerDate%22%3A%222019-06-23%2006%3A39%3A12%22%7D%5D%7D</ac:parameter>
<ac:parameter ac:name="title">Roadmap%20Planner</ac:parameter>
<ac:parameter ac:name="hash">feb9ee5ea17f0034ce8ca464fa1fdedb</ac:parameter>
</ac:structured-macro>
</p> 

The important line for us is the source section. The source section is an encoded JSON. If you decode the source section, it looks like this:

{  
   "title":"Roadmap Planner",
   "timeline":{  
      "startDate":"2019-06-07 00:00:00",
      "endDate":"2019-08-01 00:00:00",
      "displayOption":"MONTH"
   },
   "lanes":[  
      {  
         "title":"Team 1 Lane",
         "color":{  
            "lane":"#f6c342",
            "bar":"#fadb8e",
            "text":"#594300",
            "count":1
         },
         "bars":[  
            {  
               "title":"Sprint 1",
               "description":"This is the first bar.",
               "startDate":"2019-06-01 00:00:00",
               "duration":2,
               "rowIndex":0,
               "id":"633c8e7c-3c2a-4341-a143-c5cded5b36c8",
               "pageLink":{  

               }
            },
            {  
               "title":"Sprint 2",
               "description":"This is the second bar.",
               "startDate":"2019-08-01 07:21:58",
               "duration":1,
               "rowIndex":1,
               "id":"e7734b5c-0639-44f9-9ef5-8c8c7f72bc21",
               "pageLink":{  

               }
            }
         ]
      }
   ],
   "markers":[  
      {  
         "title":"Today",
         "markerDate":"2019-06-23 06:39:12"
      }
   ]
}
 And now you know, how the Roadmap Planner looks in a JSON format. 

Now you could make an user macro with some javascript. Make a JSON programmatically and encoding/decoding the json and just wrap the raodmap planner macro in yours.

Hope this wasn't to much complicated. I would love to here from you, if you tried it and especially if it worked.

Regards 

Dominic