Export multiple layers to powerpoint slides

#1

So I have a legacy dashboard that is set up to act like a slide deck when viewed in a browser. I did not develop this, but am trying to make use of it. It is one dashboard with multiple layers and button navigation to advance the “slides”
I now have a user who wants to have the functionality to export to powerpoint to make it a slide deck.
If I’m understanding correctly, the only way to do this would be by script since the share -> export to powerpoint option only exports what is viewable.
Does anyone have advice on how to build that or even an example script that would capture the slide, change layers, capture the slide etc and export into one powerpoint file? I’m not very good a scripting in Dundas, and I can’t find anything in the script library addressing multi-page exports.

I do realize that this should have built this as a slideshow or some other way, but the current dashboard is 30+ slides/layers and I don’t really want to rebuild it so hoping for a way to export it efficiently.

Thanks!

#2

Hi Molly

I do have a script that can go through all the layers and export each one to a PPT. Problem is that the PPT export will only do one PPT slide per export. There is no way to export a PPT with multiple slides in the one file.
I did look into this for one of our clients, and I even managed to get all the PPT files into one zip file, but was not successful in getting all the exports into the one PPT file.
After the export, I can get hold of all the individual single slide PPT files, but could not find an online library to enable me to stitch them all together.

I would be delighted to hear about any way to do this that anyone else has come up with.

Thanks

#3

David, would you mind sharing the script or pseudoscript of that? It at least gets me half way there to be able to export all the layers to PPT.
I would also be happy to hear about others’ solutions to this issue, or how to best build a slide deck that’s exportable to PPT for the future. I haven’t worked with Dundas Slideshows much, but they don’t appear to have that functionality either.

#4

@molly.loughran, The actual script I’m using is long and specific to the dashboard, as changing layers on this dashboard also needs to do a lot of other layout and filter things.

I’m using the export script from the script library to do the actual export. I’ve put it inside a loop which changes the layer, then calls the export script, then when it’s done changes the layer again and calls the export script etc.