Asset Import

[crichie]

Is it possible to import Assets via CSV or txt file?

I'm working on an Asset Management project, where I'm inputting assets. I just received a new order of PCs, and I want to input 30-40 PCs and mark them as "STOCK".

This will help me in determining what is "in stock", what is "active", etc...

[Hemoco]

We do not currently provide support for importing data into Lansweeper. You will have to write your own custom database scripts or connect to the database using a tool like Microsoft Access.

[GlobeOp1]

I need to import mobile devices from a spreadsheet to LS. I believe the SQL script necessary to import simple devices is very complicated because I would need to assign unique identifiers and amend many tables.

Is there an automated method to import non-connected devices, such as phones and monitors?

To bulk update existing computer records' bar codes (asset tags), I used SQL Import/Export Wizard to import the Excel file as a new table and then updated tblAssetCustom based on serial number.

Is there a way to create 500 blank assets that I can update in a similar manner?

[Hemoco]

Please contact support@lansweeper.com for instructions on how to connect to your Lansweeper database using Access.

[crichie]

Any chance you can tell me which file and where it is located?

I may want to try on a test machine first.

Thank you.

[Hemoco]

You will have to write your own custom database scripts for this, as we do not currently provide support for this. Some of our customers connect to their Lansweeper databases using Microsoft Access to simplify data insertion.