Importing Assets
Vantify CAFM provides access to an asset register, which in turn can be linked to reactive and PPMs. This guide explains how to import assets using the import template.
Accessing the template
Navigate to the assets section from the left hand menu.
Within this page, in the top right corner you will see a section titled Asset Imports
NOTE 1 – there is a strong chance you do not have this, please contact the Vantify admin team – helpdesk.cafm@vantify.com and explain that you need the permission “Import Assets”
NOTE 2 – INTERNAL USE - Vantify Admin, there are two permissions called import assets, one in site permissions, one in service provider permissions. Apply based on which side the user sits, FM or SP.
Click through to this tab (it will show any imports you've previously run) and click import:
Then from the resulting page click download import template:
Note the handy legend which explains the data structure.
Open the Excel
You need to work your way across the screen adding any information you may have about the asset. There are a number of really useful fields, and also a bunch that you’ll likely not need.
Mandatory
Only three of these fields are mandatory:
siteID – specifically the ID of the site, to get this go to sites and export the list. In excel the first column will be ID. Copy and paste it into your import sheet.
Name – the asset name, it might be “Boiler” for example
Active – ensure they’re all set to active and in order to do this just enter 1 for every line.
Beware!
NOTE – because of the way the system imports the data, a number of these fields require IDs instead of the name, they’re listed below.
SiteID – as above
ID – this is specifically the existing asset ID. Use this for updating assets, if they do not yet exist leave this blank. IMPORTANT
assetTypeID – unlikely that you will need this, but if your client does use asset types, please contact the Vantify admin team who will provide you the relevant IDs.
ServiceProviderID – this is who will be carrying out the maintenance on this piece of equipment. By being listed against it they will also be able to edit the asset. Go to service providers in Vantify CAFM and export the list to get the ID.
jobGroupID – ignore this, it is extremely rare that job group is required on PPM
serviceRoutineIds – this is your SFG-20. You would want to enter the code such as 05-06 but Vantify CAFM requires the id of the service routine. Speak with the Vantify admin team who will provide you the list.
statutoryID – if the asset needs to be marked as statutory such as water, gas, electrical etc you would need to enter the stat type here. Again, speak with the admin team who will provide the list. NOTE – this is very rare, the task will be set as statutory, the asset doesn’t necessarily need to be so you are safe to leave this blank.
nfcID – very specific for using NFCs for asset tagging. If you know the NFC code, enter it in here
assetScoreTypeId – if you would like this asset to be rated with condition or risk, enter the id here – 1 is for condition, 2 is for risk. If you want to apply both enter “1, 2”. More on this below.
Handy fields
There are also a number of really useful fields that are worth considering:
Service Provider
Specify which service provider looks after the equipment. All SPs will be able to see it, but only the specified one will be able to edit it.
Barcode
This is used for asset tagging, enter the code from your QR code or barcode in the barcode field. When you tag the code in the app, it will instantly bring up the information of the asset linked by this code. It’s surprisingly low tech. NFC tagging is also available, enter the NFC ID in the respective column.
The code to the left is simply a digital representation of 123456 (go ahead and test it by scanning with your camera!), enter 123456 in the asset barcode field and it will automatically filter to this asset.
Service Routine
These are the SFG-20 codes that your asset is linked with, and it allows the operative to access the maintenance instructions when carrying out the job. It presents each instruction for the asset, along with the frequency of the line:
Asset scoring and replacement costs
When the engineer carries out the task they can be asked to rate the asset in terms of condition and risk (as well as other bespoke expandable options such as public imagine or pass/fail) which is then collated in the historical scores section. It is especially useful for budgeting, on a quarterly basis filter to poor quality assets and along with the replacement costs, it’ll aid in budgeting for replacing the item.
Remaining fields
The remaining fields are optional, so populate whichever are required. The assets can also be added to over time so if you don’t have all the relevant information you can add it further down the line. Having an import template full of gaps is absolutely fine.
Ready to import
When you are finished putting together the template, save it specifically as a CSV file, you can name it whatever you’d like:
Then return to the system and navigate back to the asset import area:
Choose your file
Test run – leaving yes ticked means you can import the file with an errors without risking it being added to the system. We recommend running it until you have 0 errors.
Click Create
Once you have clicked create, and after a few minutes your import will be finished and you can review any errors:
Note Total, Valid and Invalid. You’re aiming for 0 invalid.
The errors will list what you’ve done wrong. Often formatting, length, or some of the aforementioned IDs being incorrect. Correct the errors in your spreadsheet and import as a test again.
Once you have 0 errors you can progress to importing without it running as a test:
After importing it not as a test the data will be imported and your assets will be live on the system.
Using the importer to update assets
You can also use the importer to update assets. Go to the asset list of existing assets, filter as necessary and click export. This will take your asset list into excel. Make any changes – name, service providerID, add missing data etc. And when ready follow the steps to import.
The only difference to what we were doing before to now is the ID column is now populated. By this being in place it will update the existing asset as opposed to creating a new one.
Applying the asset to reactive jobs
Now the asset is created you can apply it to reactive jobs. There are a few ways to do this:
1. When logging a reactive job as normal, when getting to the asset field, choose the relevant piece of equipment from the dropdown menu:
2. Use the asset tag – scan the QR code or NFC tag and it will bring up the asset on the app. You can then click add new job from the asset page
3. The service provider can add an asset at the end of the job during completion.
Applying the asset to PPMs
When importing PPM using the spreadsheet template, simply enter the asset name and reference in the asset fields. If it finds one on the system that matches it will reuse the existing asset, otherwise it will create a new one.
If creating a task manually ensure you choose “hard” as the task type and select from the dropdown to add the asset.
Also note, when creating a new task, you can also add a new asset at the same time:
Related Guides
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.