cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
pskup
Engaged Sweeper III
Hello community,
is it possible to import licenses information via excel or csv?

We want to use exel to manage our licenses. The lansweeper module is not complex enough. But we want to keep track of the licenses in lansweeper to.

The easiest way would be making a special import table in Excel (getting the needed information from the original table). And then import this at a monthly basis.

So we don't need to edit the information twice. In excel and lansweeper.

The "Database Scripts" menu allow to run sql code. For assets there are excel templates available. Is there something similar for licenses?

Then I can run something like this (example from Stack Overflow forum)


CREATE TEMP TABLE tmp_x (id int, apple text, banana text);

COPY tmp_x FROM '/absolute/path/to/file' (FORMAT csv);

UPDATE tbl
SET banana = tmp_x.banana
FROM tmp_x
WHERE tbl.id = tmp_x.id;

DROP TABLE tmp_x;
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
FYI for everyone: you can use scripts to add license details directly to the relevant database tables (tblLicenses, tblSublicenses etc.), but this is not something we provide instructions or support for. Modifying the database structure is not supported either and could lead to update or other issues.

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
FYI for everyone: you can use scripts to add license details directly to the relevant database tables (tblLicenses, tblSublicenses etc.), but this is not something we provide instructions or support for. Modifying the database structure is not supported either and could lead to update or other issues.