Knowledge Base

Client admin imports

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

CAF-N-342

CAF-N-343

CAF-N-344

CAF-N-346

CAF-N-347

CAF-N-348

CAF-N-349

CAF-N-350



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.