foreign [Music] hi there my name is Lawrence Tyndall here at Glide fast Consulting and in today's servicenow tutorial I'm going to show you how to import Hardware assets into service now using an Excel spreadsheet so maybe you're just implementing Hardware Asset Management in servicenow or you have a spreadsheet of assets that you've got from another system or tool and you'd like to load them into the system importing Hardware assets into service now is a fairly simple process and can be done in a matter of minutes in today's demo I'm going to import 10 Apple MacBook Pro laptops into the system and walk you through the process step by step for the first step I've gone ahead and populated an Excel spreadsheet with the Apple MacBook Pros that we're going to be importing into the system as you can see I've populated the model category model asset tag serial number location assigned to State and cost columns with values one good thing to know is when you're importing values into a reference field the column values in the spreadsheet need to contain the same values that exist in the system or they won't get populated and an error will be shown in this spreadsheet for example you can see that the model category model location and assign two columns all relate to reference fields in the system so all of these columns need to contain values that exactly match those already in the system for example the model category computer already exists in the system so when we perform this import it'll match against this value and populate the model category field on the hardware asset form you'll also notice that I haven't included all of the hard reset fields in this spreadsheet for demo purposes I've just included the most common fields now to begin importing these Hardware assets open up servicenow and in the navigation filter type in load data click on the load data module located underneath the system import sets application you'll now be navigated to this load data UI page for the first step of the import we have to create something called an import set table to do this we're going to keep the create table option selected since this is the first time we're importing Hardware asset records and in the label field I'm going to enter Hardware asset import for the source of the import I'm going to select file and then click on the choose file button and select the spreadsheet we previously reviewed and for the sheet number and header row Fields I'm going to keep them both as one since the sheet number is 1 and the header is located on Row 1 within my Excel spreadsheet now click on the submit button you'll now be presented with this progress page that shows that the import is complete and was successful now to load this data into the hardware asset table we need to create a transform map to transform the data to do this click on the create transform map hyperlink you'll now be navigated to this blank transform map form in the first field name I'm going to enter Hardware asset import and for the Target table field I'm going to select the Alm Hardware table since that's the table for Hardware assets now right click on the farm header and click save now that we've created the transform map the next step is to create our field mapping that maps The Columns from our Excel spreadsheet to the fields in the hardware asset table to do this we need to click on the mapping assist hyperlink located underneath the related links section of the form you'll now be taken to this mapping assist UI page where you can select fields from the import set on the left and match them to the fields within the hardware asset table on the right I'm going to select model category model asset tag serial number location assigned to State and cost and match these fields to their corresponding fields in the hardware asset table now that we've matched all of the fields click on the save button click on the transform related link to begin transforming the data from the import set to the hardware asset table from this slush bucket page ensure that the correct transform map is selected in the Box on the right hand side now click on the transform button the system will begin processing the transform and you'll be navigated to this progress page where you can see that the transform was successful now if we head over to the hardware assets module you can see that the 10 computers we just imported are now available in the system and it's as easy as that importing Hardware assets into service now via an Excel spreadsheet is a fairly simple task and can be achieved in a matter of minutes and that is all for this week's servicenow tutorial on how to import Hardware assets into service now