Notification

Icon
Error

Updating asset custom fields from Excel

Posted: Tuesday, January 28, 2020 2:11:23 PM(UTC)
alfiet

alfiet

Member Original PosterPosts: 13
0
Like
Hi,

We want to move some of the data we're currently storing against assets in an Excel spreadsheet to custom fields in Lansweeper. I know I can use the Edit\Mass Edit feature to manually do this but i was hoping there is a way to do this more efficiently.

The asset name exists in both sheets so i was hoping i could do something like run a SQL Update script for each asset, but I don't know if this is possible. I can only find this post , but the answer doesn't specifically explain how to do this in Lansweeper


Thanks
steveb
#1steveb Member Posts: 14  
posted: 1/28/2020 7:16:52 PM(UTC)
Originally Posted by: alfiet Go to Quoted Post
Hi,

We want to move some of the data we're currently storing against assets in an Excel spreadsheet to custom fields in Lansweeper. I know I can use the Edit\Mass Edit feature to manually do this but i was hoping there is a way to do this more efficiently.

The asset name exists in both sheets so i was hoping i could do something like run a SQL Update script for each asset, but I don't know if this is possible. I can only find this post , but the answer doesn't specifically explain how to do this in Lansweeper


Thanks


Try this. https://www.lansweeper.com/knowledgebase/importing-assets/
alfiet
#2alfiet Member Original PosterPosts: 13  
posted: 2/3/2020 1:57:46 PM(UTC)
Originally Posted by: steveb Go to Quoted Post


That link won't work for me as I want to update existing assets, not import brand new ones. We have 300 assets that we want to update with around 10 fields each, and we don't want to manually enter 3000 records.

Active Discussions

Lansweeper Report on clients with no LSAgent
by  RobertB   Go to last post Go to first unread
Last post: Yesterday at 6:55:32 PM(UTC)
Lansweeper Lansweeper report to match computer name
by  RC62N   Go to last post Go to first unread
Last post: 2/19/2020 5:02:27 PM(UTC)
Lansweeper Distinct user logins per PC
by  Bruce Garoutte   Go to last post Go to first unread
Last post: 2/17/2020 6:36:29 PM(UTC)
Lansweeper Software version report issue
by  RC62N  
Go to last post Go to first unread
Last post: 2/17/2020 4:07:20 PM(UTC)
Lansweeper Patch Tuesday - Exclude Win 2008 & Win7
by  doone128   Go to last post Go to first unread
Last post: 2/17/2020 1:34:36 PM(UTC)
Lansweeper Performance statistics combined into one report
by  djs1789  
Go to last post Go to first unread
Last post: 2/15/2020 1:50:32 AM(UTC)