Error on Import: The following fields have been ignored, because they don't exist on the destination table: Model, Model category, Quantity

[Shawn Horley]

I am trying to import a batch of new laptops to our Asset Management.

The template I am using is pulled straight from the Hardware Assets module...

I don't understand why this error happens. The fields are present...

How do I fix this?

Any suggestions are appreciated.

Cheers

A.

[Shawn Horley · Accepted solution]

Apparently I need to Load Data, because the quick import fails... and has been doing for quite some time.

Annoying

So for anyone else that encounters this issue with manually importing assets:

Go to: System Import Sets, Choose: Load Data

If you don't already have one created, create an import set table. If you have one already created then choose it from the dropdown list

Then choose the File as your source of import (assuming you are importing a flatfile (xlsx, etc) ) and Submit

Once submitted  the import will run.

After the import has run you will need to transform the data. If you have not yet created a Transform Map then you will need to do so now, in which case click the Create Transform map link on the progress page.

If you have already created a Transform Map then you can click the Run Transform link instead.

After successful transformation you will be able to see the data imported in your table of choice.

[Ankita28]

Hi Shawn,

I'm getting the same error.I imported a notification from another instance.

Though record is getting created but it is empty.

Also I followed the above process suggested by you but that;s not working.Still I'm getti ng thr empty record.