Hello,

I've imported asset records via csv for around 40 computers, all the machines in one of my departments. I've created logical asset types for Location, Department and Unit and populated them.

Mapped Inventory Field: BIOS Serial Number
Matching asset field: Name

My spreadsheet/csv contains the following column headers:
Name
Model
Location
Department
Unit
Owner
Warranty Start
Warranty End

When I import the csv and preview all the data is present, and when I view the assets by dept all the data is there...but when I go to the inventory and select one of the machines none of the fields have been populated.

Wondering if I did something wrong, or did I misunderstand how this was to work...

Any ideas or suggestions?

Thanks in advance.

Jim
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
The only fields that would be viewable in inventory are the ones that you imported -- nothing on the client is going to automatically update those fields. I think you understand that but i'm sayin git for clarification I suppose.

My guess is that you are trying to import a data set that is too large or that you now have more than one record for each machine -- the one they are mapped to and the one that you imported.

To test if the data set is too large try to limit the csv to one row and try again.

To test if there are multiple records then when you do the following you'll see two different records when you do this:
  1. log in to http://yourkbox/adminui (not the ui on the url)
  2. open the machines (inventory->computers->find the machine)
  3. go to the asset section in the inventory and click on "edit the asset". Note the URL that you have now ( e.g. http://yourkbox/adminui/asset.php?ID=12)

  1. log in to http://yourkbox/adminui (not the ui on the url)
  2. go to assets->view by [computer]
  3. find the record you imported
  4. click on it -- verify it has all the data from your spreadsheet is there
  5. note the URL will be different then the one in step 3 above
This means that when you import you need to use a different field (or fields) as the primary key (PK)
Answered 02/07/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Right, I'd anticipated that the computer asset fields I'd defined would have been populated with the data I imported from csv.

And you were correct in regard to the duplication. I'd done 2-3 imports due to things not appearing as I expected so I had to perform some cleanup.

Thanks for the info!

Jim


ORIGINAL: GillySpy

The only fields that would be viewable in inventory are the ones that you imported -- nothing on the client is going to automatically update those fields.  I think you understand that but i'm sayin git for clarification I suppose.

My guess is that you are trying to import a data set that is too large or that you now have more than one record for each machine -- the one they are mapped to and the one that you imported.

To test if the data set is too large try to limit the csv to one row and try again.

To test if there are multiple records then when you do the following you'll see two different records when you do this:
  1. log in to http://yourkbox/adminui  (not the ui on the url)
  2. open the machines (inventory->computers->find the machine)
  3. go to the asset section in the inventory and click on "edit the asset".  Note the URL that you have now ( e.g. http://yourkbox/adminui/asset.php?ID=12)

  1. log in to http://yourkbox/adminui  (not the ui on the url)
  2. go to assets->view by [computer]
  3. find the record you imported
  4. click on it -- verify it has all the data from your spreadsheet is there
  5. note the URL will be different then the one in step 3 above
This means that when you import you need to use a different field (or fields) as the primary key (PK)


Answered 02/08/2011 by: jimebong
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity