Import Data: Parts, Units, Customers, and Vendors
Parts, units, customers, and vendors can be imported
into your FleetSquared system using Excel spreadsheets. Using our downloadable templates, you can
insert existing data from other repair systems into FleetSquared. Each of the import screens has similar
functionality. You need to download an Excel spreadsheet template file,
enter your records in the template file, then upload the file.
Note: Any
template column headings marked in bold text are required fields. All other
fields are optional and can be left blank.
Part Master Imports
The following import tabs are available on the Part Master screen (Menu path:
Parts → Part Master):
- Import Parts (list of part numbers)
- Import Parts On Hands (quantity of parts in
inventory)
- Import Parts Location Details (part warehouse
storage location)
Unit Master Imports
From the Unit
Master (Fleet → Unit Master):
- Import Equipment Units
Administration Imports (Customers and Vendors)
From Administration:
- Import Customers (Administration → Customer)
- Import Vendors (Administration → Vendors)
Import Parts Example
As mentioned above, the import process is nearly the same
for each import. We'll demonstrate a
part master import as an example.
- Open the Parts menu and select Part
Master.
- Open the Import
Parts tab.
- Click on Download
Template.
- Your web browser will download or prompt you to
download the template file. In Google
Chrome, for example, the download file is displayed in a download bar at the
bottom of the browser.
- If you use a Windows 10 computer, the file will
typically be saved to the Downloads folder under Quick Access in Windows
Explorer.
- Open the template file using Microsoft Excel and
click on Enable Editing.
- Columns with bold headings are required to add new
records.
- Enter your data into the file and save.
- Back on the Import Parts screen, click Choose File.
- Browse to the folder when your import file is
located, select it, and click Open.
- Click Import next to the file name.
- A pop-up window will advise you that the import
process has begun. Click OK.
The import status is displayed on the screen. Click Refresh to re-check the status. Large files may
take several minutes to complete. The summary will also show you the number of records
imported and the number of records with errors.
If you experience import errors, detailed error
messages will be displayed in the bottom pane under Import Data Errors and Import
File Errors.
Common causes
of import errors include:
Required fields left blank (the error message
will contain the phrase "cannot insert NULL into. . . "). To resolve
this error, fill in all required fields and re-upload.
Invalid special characters. FleetSquared can
only import data containing alphanumeric characters and English language
standard keyboard characters. For example, an ampersand (&) can be
entered in the part description field, but the degree symbol (°) will cause an
import error.
Invalid data (i.e. alphabetic characters entered
in a part price field or an incorrect date format).
Value too large for column. Some values, such as
a product group code, have a maximum length of 12 characters, for
example. Look in the error message for the maximum size:
"ORA-12899: value too large for column
"PERFIT"."CD_CONVERSION_ITEM_MASTERS"."PROGRO_CODE"
(actual: 13, maximum: 12)"
Related Articles
Add Customers
In FleetSquared, units need to be tied to customers in your system. If you do work for outside customers, your first step would be to add a customer to your system. To add customers, open the Administration menu and select Customer. Your own ...
Add Vendor (Parts Supplier)
This article explains how to add part vendors (aka part suppliers) to your FleetSquared system. Vendors are required on part purchase orders in FleetSquared. Individual parts can be linked to a preferred vendor for your part orders. To add vendors ...
Add Units
To add a unit to FleetSquared, open the Fleet menu and select Unit Master. Click on the New Unit button at the top right corner of the Unit Master screen. Search for the unit owner using the text field. Alternatively, you can add a new ...
How do I charge different part markup rates for different customers?
If you need to charge different part markup rates for different customers, this can be accomplished by creating and assigning a parts contract to a customer in FleetSquared. This article explains how to do this. Open the Administration menu and ...
Add Parts
This article provides a walkthrough of how to add parts to your FleetSquared system. Parts can be managed and added from the Part Master screen. Open the Parts menu and select Part Master. To add a new part number, click on the New Part link at the ...