What Information you can Import into Quantify
  • 30 Aug 2023
  • 1 Minute to read
  • Contributors
  • Dark
    Light

What Information you can Import into Quantify

  • Dark
    Light

Article Summary

Quantify enables you to import information, adding products, consumables, Job Sites, Customers, etc. to 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
Customers

Tab Separated File

Either template CustomerVendorTemplate.txt  or CustomerVendorTemplate.xls, found in C:\Program Files (x86)\Avontus\Quantify Client\Catalogs.

NameImporting Customers
VendorsTab Separated FileEither template CustomerVendorTemplate.txt  or CustomerVendorTemplate.xls, found in C:\Program Files (x86)\Avontus\Quantify Client\Catalogs.NameWorking with Vendors
Job SitesTab Separated File

The template titled Jobsite Import.xls, found in C:\Program Files (x86)\Avontus\Quantify Client\Catalogs.

Name, Number, CustomerImporting 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

ProductsTab Separated File

The template titled Product Import Template.xls  found in C:\Program Files (x86)\Avontus\Quantify Client\Catalogs.

Part NumberImporting Products, Parts and Materials into the Product Catalog
ConsumablesTab Separated FileThe template titled Product Import Template.xls  found in C:\Program Files (x86)\Avontus\Quantify Client\Catalogs.Part NumberImporting Consumables from a File
Product Catalogs

XML file

Downloaded from https://www.avontus.com/manufacturer-catalogues/
Importing a Product Catalog into the Materials Master

Was this article helpful?