What Information You Can Import into Quantify

Quantify enables you to import information, adding products, consumables, Job Sites, Customers, etc. into your Quantify database. The table below shows what you can import and what type of file is needed to do that.

Entity	Type of File Needed	Created With	Required fields	Refer To
Customer	Tab Separated File	Either template CustomerVendorTemplate.txt or CustomerVendorTemplate.xls, found in C:\Program Files (x86)\Avontus\Quantify Client\Catalogs	Name	Importing Customers
Vendors	Tab Separated File	Either template CustomerVendorTemplate.txt or CustomerVendorTemplate.xls, found in C:\Program Files (x86)\Avontus\Quantify Client\Catalogs.	Name	Working with Vendors
Job sites	Tab Separated File	The template titled Jobsite Import.xls, found in C:\Program Files (x86)\Avontus\Quantify Client\Catalogs.	Name, Number, Customer	Importing a Job Site
Rate Profiles	Tab Separated File with five columns Part number Rent Sell Job Cost Replacement Cost	This is typically created using Excel, and then saved to tab separated .txt file.	Part Number	Importing Rates into a Quantify Rate Profile
Products	Tab Separated File	The template titled Product Import Template.xls found in C:\Program Files (x86)\Avontus\Quantify Client\Catalogs.	Part Number	Importing Products, Parts and Materials into the Product Catalog
Consumables	Tab Separated File	The template titled Product Import Template.xls found in C:\Program Files (x86)\Avontus\Quantify Client\Catalogs.	Part Number	Importing Consumables from a File
Product Catalogs	XML file	Downloaded from https://www.avontus.com/manufacturer-catalogues/		Importing a Product Catalog into the Materials Master
Designer Drawing	vsdx file, pdf file	An export file exported form Avontus Designer		Integrating with Quantify
Bill of Materials	PDF file	An exported file from the Print Preview of the Bill of Materials on Avontus Designer.		Working with the Bill of Materials