Importing data to dbo.tblAssetCustom

[mjphelan]

Hi Folks,

We have a large number of assets, historically speaking purchasing data has not been entered when new assets are discovered, so I have over 1600 assets which need to have their internal Order number and supplier order number updated.

We do have a spreadsheet (or access database table) containing the 3 columns that need work, (Service Tag, Order Number, Supplier Order Number) and plan to use the field Custom1 to store the Supplier order number

We used to connect to the DB in Access and create a query to do this, however that is no longer possible due to the number of index's in the dbo.tblAssetCustom table

I would really rather avoid having to manually key in data to over 1600 assets, even with the bulk update feature this will take quite some time.

Can anyone suggest a not so time intensive method of achieving this goal that could be achieved by someone who is not an SQL database expert?

Many thanks

Mark Phelan

[Daniel_B · Accepted solution]

We recommend that you install SQL Server Management Studio and connect to your Lansweeper database (you can use the same username and password which is written in your Lansweeper service config file in the connection string). This will allow you to run scripts in order to mass update these fields in your database. We can't offer step-by-step instructions as we don't provide support in case you break your database. However, updating custom fields in tblAssetCustom based on the asset's serialnumber is more easy and you should be able to use a similar procedure as you already used in Access.