Asset Integration Field Mappings

Asset Integration Field Mappings Example

Asset Name Column from Source Database	Select the asset name column in the SQL database that contains the data to be synchronized.
Attempt Asset Type Mapping	Select On to specify the asset type column in the source database for mapping to the iSupport asset type column. If a value in the source database does not match the corresponding value a predefined type, a new type will be assigned. Select Off to assign the predefined iSupport asset type in the Default Asset Type field to all synchronized records.
Asset Type Column from Source Database	If On was selected in the Attempt Asset Type Mapping field, select the column to be used for mapping the asset type in the source database.
Default Asset Type	If Off was selected in the Attempt Asset Type Mapping field, select the predefined iSupport asset type to assign to all synchronized asset records.
Attempt Asset Owner Mapping	Select On to specify the names of the asset owner First Name, Last Name, and Email columns in the source database and search for a matching asset owner in iSupport Customer Profiles. If a value in the source database does not match, a new Customer Profile record will be created if Yes is selected in the Create New Customer Profile if Mapping Fails field. If No is selected in that field, the customer in the Default Owner field will be assigned. Select Off to assign the customer in the Default Owner field as the asset owner of all synchronized records.
Owner First Name Column from Source Database	If On was selected in the Attempt Asset Owner Mapping field, select the owner first name column in the source database to be used in the search for a matching asset owner in iSupport Customer Profiles.
Owner Last Name Column from Source Database	If On was selected in the Attempt Asset Owner Mapping field, select the owner last name column in the source database to be used in the search for a matching asset owner in iSupport Customer Profiles.
Owner Email Column from Source Database	If On was selected in the Attempt Asset Owner Mapping field, select the owner email column in the source database to be used in the search for a matching asset owner in iSupport Customer Profiles.
Create New Customer Profile if Mapping Fails	Select On to create a new Customer Profile record if a value in the source database does not match. Select Off to assign the customer in the Default Owner field as the asset owner of all imported records.
Default Owner	If no owner mapping was attempted or Off was selected in the Create New Customer Profile if Mapping Fails field, select the customer to assign as the asset owner for all imported records.

When you make an entry in the Connection String and SQL Query fields on the Basics tab and click the Test Query button or Refresh Columns link, the SQL Columns section will be populated with the names of the columns in the source database. The iSupport Columns field contains the columns in the iSupport ’s Asset database. Do the following:

To map a field, select a field in the SQL Columns field and the corresponding field in the iSupport Columns field. Then click the button. The associated fields display under Mapping.
To remove an entry from the Mapping section, select the entry and click the button.
Use the Custom Fields tab to map fields in the source database to the custom fields set up for both asset types and the Asset entry screen. Click Save to save your selections. The synchronization will occur when the Sync button is clicked and/or on the interval set in the Asset Synchronization Interval field on the Basics tab.