How to match imported asset fields

How to match imported asset fields

When importing assets, the system automatically matches imported column headers to the corresponding system fields. The Match Imported Fields step allows you to manually match any fields that were not automatically matched.

My School > System  >  Assets > Manage:  Match Imported Fields

  • The system matches both English and Afrikaans field names, provided the spelling is correct. If an automatic match did not occur, compare the spelling of the field in your Asset Import File with the system field names.

  • If a field is not automatically matched, its value does not currently exist in the system and must be matched manually.

  • If a large number of assets has been imported, the match pages may take a long time to load or appear unresponsive. This is normal — do not refresh the browser. If technical difficulties persist, contact the Support Desk.

  • The matching steps can be done in any order, and you can complete some matches and return later to finish the rest.

How do I match imported fields?

  1. On each match screen, unmatched imported values are shown on the left. Select the correct corresponding system value from the drop-down list for each item.

  2. Once all items are matched, a confirmation message will indicate that all fields have been matched successfully.

  3. Complete the matching process for each of the following categories: Owners, Supervisors, Locations, Conditions, Measurement, Categories, Funding Sources, and Suppliers.

Frequently asked questions

Why did some fields not automatically match?

Automatic matching requires the spelling in your import file to exactly match the system field name (in either English or Afrikaans). If a field did not match, verify the spelling and correct it in the import file for future imports, or match it manually this time.

Do I need to complete all match categories in one session?

No. You can complete some categories and return later to match the remaining ones. The process will pick up where you left off.

Last updated: March 2026  |  Version 2.0

© Copyright d6 group (Pty) Ltd.
    • Related Articles

    • How to set up and manage the Assets register

      The Assets module enables schools to set up and manage a complete asset register, covering categories, locations, suppliers, importing and reporting. My School > System: Assets What are the sections of the Assets register? System Lookup: Asset ...
    • How to manage imported assets

      The Manage Imported Assets function allows you to edit or delete individual asset items. Lists can be exported to Excel if the user has the relevant export rights configured. My School > System > Assets > Manage: Manage Imported Assets How do I view ...
    • Generate an imported assets report

      This article explains how to generate a report of imported assets in d6+. You can filter by grouping, owner, location, status, and date range to view specific asset records. My School > System > Assets > Reports > Imported Assets How do I generate an ...
    • How to import assets in bulk

      Assets can be entered in bulk on an Excel template and then imported into the d6+ Asset list, where they display per item. My School > System > Assets > Manage: Import Assets Important: If you need to add additional items after a previous import, ...
    • How to add Asset Suppliers

      The Suppliers function allows you to maintain a list of asset suppliers that can be selected on the asset allocation screen. My School > System > Assets > Setup: Suppliers How do I add an asset supplier? Click Add New. Enter the name of the supplier. ...