Import excel file into Lansweeper

[winggear]

We have a Excel file with hundred records in follwoing format (4 fields)

hostname , FA_No, invoice_date, Remark

Hosts are already existing in our database, how can we import excel file into Lansweeper custom fields base on the Hostname?

FA_no >>> custom01
Invoice_date >> custom02
Remark >>> Custom03

Thanks.

[Hemoco]

There is currently no built-in functionality for this. You will have to write a custom script and execute it in the Lansweeper configuration console under Lansweeper\Database Scripts to import this information.

An example script can be seen below.

UPDATE tblCompCustom
SET Custom1 = 'YourNo',
Custom2 = 'YourDate',
Custom3 = 'YourRemark'
FROM tblCompCustom INNER JOIN
tblComputers ON tblCompCustom.Computername = tblComputers.Computername
WHERE (tblComputers.Computer LIKE 'YourComputer')