licenses information import

[pskup]

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;

[Susan_A · Accepted solution]

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.