Inventory fields not populated after importing assets via csv ?
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
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
Answers (2)
Please log in to answer
Posted by:
GillySpy
13 years ago
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:
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:
- log in to http://yourkbox/adminui (not the ui on the url)
- open the machines (inventory->computers->find the machine)
- 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)
- log in to http://yourkbox/adminui (not the ui on the url)
- go to assets->view by [computer]
- find the record you imported
- click on it -- verify it has all the data from your spreadsheet is there
- note the URL will be different then the one in step 3 above
Posted by:
jimebong
13 years ago
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
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:
- log in to http://yourkbox/adminui (not the ui on the url)
- open the machines (inventory->computers->find the machine)
- 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)
This means that when you import you need to use a different field (or fields) as the primary key (PK)
- log in to http://yourkbox/adminui (not the ui on the url)
- go to assets->view by [computer]
- find the record you imported
- click on it -- verify it has all the data from your spreadsheet is there
- note the URL will be different then the one in step 3 above
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.