Using Template PowerPoint file and output PowerPoint depending on different projects

Hello,

I'm looking to output a PowerPoint using a PowerPoint template depending on different projects.

Only a few fields will be updated in the PowerPoint slides based on upstream data.

I thought about using a reporting tools, but it seems like I cannot input a PowerPoint as a template input file, so modifying XML file would be a better choice in Alteryx.

There was a similar conversation in the Alteryx community forum: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Auto-populate-powerpoint-template-with-Alteryx/td-p/52999

If I'm understanding it correctly, this approach is to:

1. extract the PowerPoint to xml first

2. modify the xml file in Alteryx using the upstream data

3. Alteryx will produce the modified XML file, not PowerPoint

4. use the modified XML for different projects

I tried to follow what they've done using the XML input file, so I used a 7zip to extract the PowerPoint and it produced many xml files. However, I was not sure which XML file was the one that contained actual content in the slide deck to modify. Does anyone know which one to use? Also, if there is a better way to accomplish this, I appreciate any inputs!

Sincerely,

knozawa

Workflow

Tips and Tricks

Server

Best Practices

Accepted answers

kelly_gilbert

That was a great idea to test rezipping the file without modifying it! That tells us the problem is with the zip and not the XML. Are you possibly zipping the outer folder?

Make sure that you're just zippng the _rels, ppt, etc. folders, and the [Content_Types].xml file, and not the folder that contains them.

ppt zip.gif

All comments

kelly_gilbert

Hi, @knozawa - the XML files you want to edit are in the ppt --> slides folder. Inside \ppt\slides, you'll find a separate XML file for each slide in your presentation (slide1.xml, slide2.xml, etc.)

I use this method myself, and it works well. I'll be interested to see if there are other ideas for accomplishing this!

The general method is:

Create a PowerPoint template with placeholders for each value you want to replace (e.g. if your fieldname is open_roles, then insert {{open_roles}} in the appropriate place in the PowerPoint slide.
Unzip the template pptx file
Read in the XML file (for example, if you want to edit slide #3, then input ppt\slides\slide3.xml)
Modify the slide XML by replacing your placeholder text with the field value
Output the updated slide XML (for example, if you are modifying slide #3, then output ppt\slides\slide3.xml -- you are replacing the original slide3.xml with the modified version)
Re-zip the files and save the zip file with a .pptx extension

knozawa

@kelly_gilbert ,

Thank you for your detailed reply!

I followed your instruction and have questions:

Q1. When you replaced the value, did you replace whole thing {{open_roles}} to sales for example (meaning the {{}} will be removed in the modified xml file)?

Q2. At the last step, did you re-zip the whole folder that contained all the xml files using 7zip or just compressed (zipped) folder from the file explorer directly? I tried both ways and changed the .zip to .pptx. When I tried to open the PowerPoint, it showed an error message:"PowerPoint found unreadable content in ...There was an error accessing...".

kelly_gilbert

Q1 - Correct - replace the whole thing, including the brackets, like replace([your_xml_field], "{{sales}}", tostring([your_sales_field]))

The curly brackets are there to identify the placeholders in your template vs. other text in your template. For example, the word "sales" could occur in the title of your slide, so you don't want to replace that. We only want to replace sales when it is surrounded by curly brackets.

Q2 - correct, zip all of the files (including [Content Types].xml) into a new zip file, and make sure that the folder structure (_rels, customXml, etc.) is present in your zip file.

I haven't tried using 7zip to create the zip file, but I don't see any reason why that wouldn't work. I'm using Python zipfile to create my zip file, but I have also done it manually from the File Explorer, which also works.

One other issue that could cause that error is when the replacement text has certain characters in it (XML predefined entities, such as & " ' < >). You will need to replace those with their name (e.g. "&" for ampersand or "<" for <).

For example, say you have the placeholder {{department_name}}, and the actual department_name is Planning & Analytics. Inserting Planning & Analytics in the XML will cause an error due to the ampersand (&). You can fix it by replacing the & with the character name, "&"
Example: replace([your_xml_field], "&", "&")

It will appear as "Planning & Analytics" in the raw XML, but it will appear as "Planning & Analytics" in PowerPoint.

kelly_gilbert

Two other things to check:

Make sure that your output file has the exact same name and location as the original. For example, if you are editing ppt\slides\slide2.xml, make sure that your output tool is outputting to the exact same folder/file name.
Make sure that your Output Data tool is not outputting any additional characters that would make the XML invalid. Make sure that First Row Contains Field Names is NOT checked, and make sure that the delimiter is something that won't occur in your XML file ("\0" is a good delimiter to use).
Make sure that the Code Page on your output is UTF-8

If you're still having issues, please share an example of your workflow with some fake data, as well as your .pptx template, so we can take a look at what might be happening!

knozawa

@kelly_gilbert

Thank you for your help! I still have issue opening the corrupted PowerPoint.

I wanted to attach the PowerPoint and Zip folder, but it seems like there is a restriction on uploading those file types in the Alteryx Community forum.

Here is the screenshot:
1. original PowerPoint ("DELETE.pptx")
Screen Shot 2021-08-17 at 9.06.10 AM.png

2. {{delete}} was updated to DELETEDELETE in slide1.xml

Screen Shot 2021-08-17 at 9.06.59 AM.png

3. The DELETE zipped folder's extension was updated to .pptx ("DELETE (2).pptx")

Screen Shot 2021-08-17 at 9.07.42 AM.png

knozawa

@kelly_gilbert

I also tested without modifying the slide1.xml file and re-zipped the DELETE folder and renamed .zip to .pptx.
Same error occurred.

kelly_gilbert

ppt zip.gif

knozawa

@kelly_gilbert

Thank you very much! I was creating zip file using the DELETE folder instead of zippng the _rels, ppt, etc. folders, and the [Content_Types].xml file.

If you have any tips on your process, could you please tell me:
1. When there are multiple projects to update the PowerPoint using the template, do you manually create the unzipped folder?
2. Do you embed the python code into the python tool in the alteryx workflow to zip the files and rename it to .pptx?

knozawa

@kelly_gilbert

I created another question Unzip and zip files in Python tool because the topic is different.
If you can give me some suggestions, that would be really helpful.

Sincerely,

knozawa

Paridhi_Agrawal

Hi kelly_gilbert

I am following this thread, and I am facing an issue.

I write the values to be replaced as {{Presenter_name}}, but when I checked in xml file. It is not coming as expected. PFA.

Can you suggest something over here as without brackets, alteryx is not recognizing the value to be replaced.

Thanks

Paridhi

image.png

TimPowers

@kelly_gilbert thanks for responding so quickly - I did realize soon enough that 'zipfile' is standard (I had to reset the tool icon).

And calling 'pptx' did work in the administrator-opened app, but no such luck again after re-opening without those rights (which is unusual whenever I've had to install new modules) - I'll have to figure that out.

Nonetheless, thanks for the discussion thread on this topic - I had learnt to update a .ppt template differently (calling the .xml converted file directly and concatenating the entire file string), however it hasn't been working so I hope accessing the file on a slide-per-slide basis corrects the issue. Thanks!

vizay_jadhav

@kelly_gilbert in our case we followed all steps you mentioned in your article above and we are able to generate Powerpoint deck however the charts are still showing old data and are not getting refreshed with updated embedded Excel file data.

We need to click all the chart one by one and select PowerPoint Edit Data option to refresh the charts. Could you please guide why charts are not getting auto update with latest file.

mp123

Can someone help in converting the updated xml back to pptx format?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703