What can be imported in to Vantify CAFM using Client admin?
To save time, information can be uploaded into to Vantify CAFM using a .csv file collated in Microsoft Excel. This avoids having to manually create records one by one.
But what can be imported? This guide lists what can be imported with a line explanation on each.
NOTE – It is important to note that information MUST be in the correct format. You can only import if the data is presented correctly. Often the data can be copied and pasted in to the correct column but it is not an automatic export from a rival system and import into ours.
Imports
Go to imports and choose the type from the dropdown, this can be run as a test first to check the data is correct:
After choosing the type, download the template, and click view legend for assistance on each of the fields, mandatory ones are represented with a red star:
Site Tenant
A basic list of tenants – company, name, location, site (again, using ID).
Site Notes
Import notes in bulk for the various categories we have. This is different on every system but if there is an existing export of similar site notes it’s very likely to be a copy and paste.
Asset
Asset name, make, model, serial number, installation date, warranty info etc etc. 49 fields in total, an existing asset list will be very similar to ours. Copy and paste the data in to the correct field, regardless of whether it is 5 lines or 50,000 lines it’s the same amount of work. Can be fiddly when it comes to service providers and sites.
Meter
Meters can be imported so long as the requisite columns are already provided including supplier, meter type, supply type (water, gas etc). So a little fiddly to begin with but once the setup is complete the import is straightforward.
Task
Don’t use this, this is only useful after PPM has been imported and is used for making amendments to what already exists.
Asset User
(Identical to Asset) – ignore
Submeter
Rarely used as usually sub meters are added as a parent meter in their own right. However if sub meters are required they can be imported. It’s the same importer but with a parent ID.
Sub Asset
Use this to set up Sub Assets. The import is mainly the same as the main asset importer, but adds a parentID so it knows which asset to align it with.
Location
A simple location importer that will add locations to the sites. This can be parent and child level.
Contract
You can import contracts with values, expiry dates, chase dates etc. NOTE – You cannot import the files related to the contracts, they need to be added manually.
Meter Reading
After Meters have been created you can import meter readings with the ability to backdate with history.
Action (user)
The ability to bulk import actions
Client Admin Guides
Vantify 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 CAFM.