Knowledge Base

Reformatting the PPM export

Reformatting the PPM export


If you’ve ever wondered if there’s a way to export your ppm planner you’re in luck, you can. The format however is… functional. This is because Vantify CAFM exports in CSV removing any formatting that we would ideally like.


Luckily with a few short tweaks you can get it looking great.


Exporting the PPMs


Go to Tasks > View Planner, or Generate planner, and filter to the PPM you would like to export. Note that you can filter by year as well so use the filters at the top and when ready click export:


When ready, open in Excel.



Out of the box

When you open your planner, you will notice there are a few sections of interest. There are a number of useful columns showing the task name, service provider and asset info as well as a few other pieces of handy information.



Then there’s the main calendar section which lists each week across the top, with the dates populated below.




Select all columns (H onwards) from week 1 to week 52:




This is where the format needs tweaking as it shows what the frequency is along with the status, and it is the statuses we don’t need.


For Example 1M OD, the OD is not required. (incidentally, this is telling us that it is overdue)


1W App


1M FutApp



Luckily we can easily get rid of them by clicking Ctrl+H which brings up the find and replace tool:



We will find the likes of “1M FutApp” and replace it with “1M”, but to make it quicker to cover more than just the 1Ms we’ll simply search for “FutApp” and replace with blank. This will clear where there are 6M FutApp, 12M FutApp etc.


This will remove the status of the frequency. Type in FutApp in Find What, leave Replace with blank, and click Replace All






We now need to do this for all the statuses in the excel, here are a few to show you as an example. Keep moving around the planner trying to identify any stragglers until they’re all covered.


NOTE – every so often you’ll see (*) leave these, as this is showing you it’s set as statutory which is useful information to see.


Eventually you’ll capture them all and it’ll look a bit like this:




IMPORTANT!


There’s one very important final find and replace needed, as every single cell, both populated and not has a space in it. So we need to search for space, and replace with blank:



It’ll replace thousands!




Now to make it look nice


Now we’ve formatted the cells we can add some colour, and we do this by using find and replace. With the cells still selected, we’ll search for a frequency, and replace it with the same frequency but with a colour:


Click Format


And in fill, select a colour (note, at this point you can choose whatever colour, effect etc that you fancy!)


Press OK and then replace all:



It’ll look like this:



Now change 1M to 3M and repeat:



And continue to replace 6M, 12M, 1W, 2W etc. until all the frequencies have colours:



You can now resize the 52 columns and add borders to make it look even better:



Much more usable!



Final Step – IMPORTANT!


When you come to save, ensure you save it as a .xls file, else it’ll save as a CSV and you’ll lose all of your formatting again!




Related Guides

ELOGCAFM-N-115

ELOGCAFM-N-80

ELOGCAFM-N-98



Vantify CAFM Support

For further assistance on anything covered in this guide or others, please contact the Vantify admin team on 01480 499740 or helpdesk.cafm@vantify.com.

This guide was created by Vantify's Product Team and reflects the latest updates as of the specified date. Please note that the information provided may evolve with future system updates or changes. Additionally, some details may vary based on your specific user permissions and account settings within Vantify.