How to Troubleshoot eQuip Asset Import Issues

How to Troubleshoot eQuip Asset Import Issues Asset imports can occasionally fail because of missing required information, incorrect formatting, duplicate values, or data that does not meet the requirements of an eQuip field. When this happens, eQuip can generate a rejection file identifying the records that require attention. Records without errors can still be imported successfully. How to import asset data in eQuip. [help.asset...rksusa.com] Use the troubleshooting steps below to identify and resolve common asset import problems. Before You Begin Asset imports are accessed through:

Tools – Data Import From the Data Import area, you can generate an Asset Import Template or select Asset Import to upload an existing template. How to Import Assets and Update Inventory [help.asset...rksusa.com]

If possible, generate a current template from eQuip instead of building the spreadsheet manually. The template provides the column structure expected by the importer. The template provides three levels of field selection:

Basic – Displays required system fields.
Advanced – Displays commonly used fields.
Expert – Provides access to all available fields, organized by tab. How to Import Assets and Update Inventory [help.asset...rksusa.com]

Important: Do not rename the column headers in an exported asset import template. The columns can be reordered, but the header names should remain unchanged. How to Import Assets and Update Inventory [help.asset...rksusa.com] Confirm the Correct Import Mode Before troubleshooting individual spreadsheet values, verify that the template was created using the appropriate import mode.

Insert – Used when adding new asset records.
Update – Exports existing asset records so their information can be changed and imported back into eQuip. How to Import Assets and Update Inventory [help.asset...rksusa.com]

Using the appropriate mode helps ensure the spreadsheet matches the intended operation. What to Do When an Import Is Rejected If eQuip identifies an error in the spreadsheet, it can create a Rejection File. The rejection file contains the asset records that were rejected. Asset records from the original file that did not contain errors can still be imported. How to import asset data in eQuip. [help.asset...rksusa.com] When you receive an import error:

Review the rejection message.
Download the rejection file.
Open the rejection file and locate the affected records or cells.
Review the indicated values against the corresponding eQuip field.
Correct the rejected data.
Save and close the spreadsheet.
Return to Tools – Data Import – Asset Import.
Select the corrected file.
Choose Import.
Review the resulting message to confirm that the corrected records imported successfully. How to Import Assets and Update Inventory [help.asset...rksusa.com]

Because the rejection file contains the failed records rather than the successfully imported records, correcting the rejection file helps avoid unnecessarily reprocessing records that already succeeded. How to import asset data in eQuip. [help.asset...rksusa.com] Common Asset Import Errors

Missing Required Fields

A record can be rejected when a required eQuip field does not contain a value. Missing required fields are specifically identified as a common asset import problem in the eQuip Knowledge Base. How to import asset data in eQuip. [help.asset...rksusa.com] Troubleshooting steps

Review the affected row in the rejection file.
Locate the field identified by the rejection information.
Enter the missing required value.
Verify other required fields in the same record before importing it again.

If you are unsure which fields are required, generating an Asset Import Template using the Basic option can help identify required system fields. How to Import Assets and Update Inventory [help.asset...rksusa.com]

Incorrect Date Formatting

Date formatting is another common cause of asset import rejection. How to import asset data in eQuip. [help.asset...rksusa.com] Troubleshooting steps

Locate the date identified in the rejection file.
Check for an incorrectly entered or unexpectedly formatted value.
Correct the value so it is consistent with the expected date data.
Pay particular attention to values that may have been automatically reformatted by the spreadsheet application.

If multiple records fail on the same date column, inspect that entire column before attempting another import.

Dollar Sign in a Price Field

Including a dollar sign in a Price value is documented as a common import error. How to import asset data in eQuip. [help.asset...rksusa.com] For example, if a price was entered with currency formatting, review the value and remove the dollar-sign character before re-importing the rejected record. When several records fail in the same price column, check whether spreadsheet currency formatting was applied to the entire column.

Field Exceeds Maximum Length

An asset record can be rejected when a cell contains more characters than the corresponding eQuip asset field allows. The eQuip importer identifies maximum field length as a common error condition. How to import asset data in eQuip. [help.asset...rksusa.com] Troubleshooting steps

Identify the affected field.
Review the value for unnecessary characters or text.
Shorten the value so that it fits within the allowed field length.
Re-import the corrected rejected record.

If many records fail on the same field, check the values in that column as a group rather than correcting each error independently.

Duplicate Barcode

A duplicate Barcode can cause an asset import problem and is specifically listed among the common errors documented for the asset importer. How to import asset data in eQuip. [help.asset...rksusa.com] If you receive a Duplicate Barcode rejection:

Review the Barcode value on the affected row.
Check whether the same Barcode appears elsewhere in the spreadsheet.
Determine whether the asset already exists in eQuip.
Correct the value or use the appropriate workflow for the existing asset before retrying the rejected record.

Avoid simply changing a Barcode to make the import succeed unless the replacement is the correct identifier for that asset. The File Upload Area Is Not Visible When selecting a completed template, the upload area may be collapsed. If this occurs, select the small triangle to expand the file upload section, then choose Select Files. How to Import Assets and Update Inventory [help.asset...rksusa.com] The Import Succeeds, but Some Assets Are Missing A successful import does not necessarily mean that every row in the original spreadsheet was accepted. eQuip can import valid assets while placing rejected assets into a rejection file. How to import asset data in eQuip. [help.asset...rksusa.com] If the number of assets in eQuip does not match what you expected:

Check whether a rejection file was generated.
Review the rejected rows.
Correct those records.
Import the corrected rejected records.
Confirm that the expected assets are now available in eQuip.

This is especially important with larger imports, where only a small number of rows may contain errors. Multiple Rows Fail on the Same Column When many rejected records identify the same field, treat this as a possible column-level issue rather than unrelated record errors. For example:

Repeated date failures can indicate inconsistent date formatting.
Repeated price failures can indicate currency formatting containing $.
Repeated field-length failures can indicate source data that is consistently longer than the eQuip field permits.
Repeated required-field failures can indicate that a required source column was not populated.
Repeated Barcode failures can indicate duplicate identifiers.

Correcting the underlying column issue before another import can reduce repeated rejection cycles. These checks correspond to the common import-error categories documented in the eQuip Knowledge Base. How to import asset data in eQuip. [help.asset...rksusa.com] Recommended Troubleshooting Workflow For the most efficient troubleshooting process:

Start with a current eQuip Asset Import Template whenever practical.
Do not rename the exported headers.
Verify Insert vs. Update based on whether you are creating new records or changing existing assets.
Import the completed spreadsheet.
Download the rejection file if errors occur.
Identify whether errors are row-specific or repeated across a column.
Correct only the rejected records.
Re-import the corrected rejection file.
Review the success message and confirm the expected assets are available in eQuip.

The current asset-import workflow, including template creation, file selection, rejection handling, and successful completion, is documented in the eQuip Knowledge Base. How to Import Assets and Update Inventory [help.asset...rksusa.com] Additional eQuip Resources For additional instructions, see the eQuip Knowledge Base. Its asset-import documentation is organized under Assets, Imports, Exports, Transfers & Disposals, including dedicated material for importing asset data. eQuip Knowledge Base [help.asset...rksusa.com], [help.asset...rksusa.com]

How to Import Assets and Update Inventory – Current step-by-step workflow for creating a template, selecting Insert or Update, importing the spreadsheet, and handling rejected records. How to Import Assets and Update Inventory [help.asset...rksusa.com]
How to import asset data in eQuip – Detailed asset-import guidance, including rejection files and common error categories. How to import asset data in eQuip. [help.asset...rksusa.com]
How to import data in eQuip – Broader Data Import instructions covering additional types of eQuip data. How to import data in eQuip. [help.asset...rksusa.com]

When to Contact Support If the import continues to fail after the rejection-file issues have been corrected, gather the following information before requesting assistance:

The import template being used
The rejection file
The exact rejection or error message
Whether the import is an Insert or Update
Whether the problem affects every row or only specific assets
The steps already taken to correct the issue

Avoid including passwords, credentials, or other information that is not required to reproduce the issue. Providing the failed template and rejection details helps support distinguish a data-formatting problem from an issue requiring further technical investigation. Summary Most eQuip asset import problems can be isolated by reviewing the rejection file and checking the affected data for missing required fields, date formatting problems, dollar signs in Price fields, values exceeding maximum field lengths, and duplicate Barcodes. How to import asset data in eQuip. [help.asset...rksusa.com] Correct the rejected records, re-import them, and verify that the expected assets are available in eQuip. If the problem remains after those corrections, the import file, rejection file, and exact error message provide the most useful starting point for further investigation.