<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p><strong>In this guide we will cover:</strong></p><p><strong>- How to complete a SQL Import to import Licences and Subscriptions into Halo</strong></p><p><br></p><p><br></p><p>This guide covers SQL imports specifically for the use of importing licences and subscriptions into Halo. For a general overview of SQL imports we recommend reading our guide <a data-fr-linked="true" href="https://usehalo.com/haloitsm/guides/1567/" id="isPasted" target="_blank" rel="noopener noreferrer">SQL Imports</a>. </p><p><br></p><p id="isPasted"><strong><span style="font-size: 14pt;">How to complete a SQL Import to import Licences and Subscriptions into Halo</span></strong></p><p>To setup a SQL import head to configuration integrations > SQL Import > New. Here give the import profile a name and choose Subscriptions/Software Licences as the 'Entity'. </p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijc2MTM2MWViLThmN2QtNDA2OC04NGM1LTBjYWJiNjgzNWM3ZCJ9._OVStjwyAL-ikl4YOoucdQaXRQiuMdOlU_jDRSV0efs" class="fr-fic fr-fil fr-dib" width="518" style="width: 520px; height: 360.195px;" height="360"></p><p><strong><span style="font-size: 10pt;">Fig 1. New Import profile</span></strong></p><p><br></p><p>Now enter the connection details for your SQL connection. </p><p><br></p><p id="isPasted">Your SQL query must return the following:</p><ul><li>A third-party Software Licence or Subscription reference that is unique per row.</li><li>A column indicating whether the row is importing a Licence or Subscription. The value must be either "Licence" or "Subscription".</li><li>A customer reference, which can be configured to match either the Customer Name or the Halo Customer ID.</li><li>A name for the Software Licence or Subscription.</li></ul><p><br></p><p>Now you will need to map the key fields for the import.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImFhNzVmM2M4LTRlZDYtNDI0OC05NzBkLTUwMWI5MmQ5OWI1NiJ9.aF1miLDGHcdCMaVmAOF8O3f24OzqGHoCAzxcnVgkUu4" class="fr-fic fr-fil fr-dib" width="1408" style="width: 1410px; height: 386.686px;" height="387"></p><p><strong><span style="font-size: 10pt;">Fig 2. Key fields</span></strong></p><p><br></p><p><strong>Licence Import Type </strong>- Here enter the fieldname of the column that indicates if the row is a Software Licence or Subscription. The column must contain either 'Licence' or 'Subscription' as its value.</p><p><strong>Licence ID</strong> - Here, enter the fieldname of the column that contains the unique identifier for the software licence/subscription. </p><p><strong>Licence Name</strong> - Here, enter fieldname of the column that contains the Name for the software licence or subscription. </p><p><strong>Customer Matching Field</strong> - Here, choose if you would like to use the Halo customer ID or customer name to match this subscription/licence to a customer. </p><p><strong>Customer reference </strong>- Here, enter the fieldname of the column that contains the customer name or ID the licence/subscription is assigned to. Ensure this is in line with the customer matching field chosen. </p><p><br></p><p><strong>Site Matching Field</strong> - Only needed if you would like licences/subscriptions to be assigned to specific sites. Here, choose if you would like to use the Halo site ID or site name to match this subscription/licence to a site. </p><p><strong>Site reference </strong>- Only needed if you would like licences/subscriptions to be assigned to specific sites. Here, enter the fieldname of the column that contains the site name or ID the licence/subscription is assigned to. Ensure this is in line with the site matching field chosen. </p><p><br></p><p>If your dataset contains additional data you would like to pull into Halo, such as the licence count or end date, you will need to map these in the 'Field Mappings' table. Simply choose the Halo field you would like this data to be imported into. Then enter the fieldname of the column that contains this data for each row. </p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImY0NGE2MWJjLWNjNDMtNDFhNi05MTM0LWZkOWMzZDRjZDQ3YyJ9.feABKThbBme3CnhaGfGRiiJRZhAeu6Szd00D3U3QUJc" class="fr-fic fr-fil fr-dib" width="574" style="width: 576px; height: 260.678px;" height="261"></p><p><strong><span style="font-size: 10pt;">Fig 3. Additional Field mappings</span></strong></p><p><br></p><p><em><strong>Note: When mapping additional fields, ensure the data in the column is in the same format as the mapped Halo field. For example, when mapping to date fields the data in the column this is mapped to need to be in date format.</strong></em></p><ul><li id="isPasted">When using the Auto Renew field mapping, the mapped column must contain a value of either 1 or 0 or yes or no (where 1=yes and 0=no).</li></ul><p><br></p><p>Now when the import is run, licences/subscriptions will be created in Halo in line with the mappings you have configured. </p>
