<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 data-pasted="true"><strong>In this guide we will cover:</strong></p><p data-pasted="true"><strong>- How to Import Tickets using CSV/XLS/Spreadsheet Method</strong></p><p data-pasted="true"><strong>- How to Import Actions using CSV/XLS/Spreadsheet Method</strong></p><p><strong>- Finding additional fields to Import </strong></p><p><strong>- Limiting Rows</strong></p><p><br></p><p data-pasted="true"><strong>Configuration Settings Guides:</strong></p><ul><li style="font-weight: bold;"><strong><a href="https://usehalo.com/haloitsm/guides/1341" target="_blank" rel="noopener noreferrer" style="font-weight: bold;">Tickets General Settings</a></strong></li></ul><p><br></p><p data-pasted="true"><span style="font-size: 14pt;"><strong>How to Import Tickets using CSV/XLS/Spreadsheet Method </strong></span></p><p data-pasted="true" style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;">This guide covers how to import Tickets using an XLS Template. This spreadsheet is used for creating new Tickets.</p><p style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;"><br style="box-sizing: inherit; color: rgb(0, 0, 0); font-family: sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"></p><p data-pasted="true">Navigate to Configuration > Tickets > General Setting. Head to the Imports section and click the "Import Tickets" button.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjJhNDY4NTNiLTI5MDQtNDE2MS05ZjhiLTllOTg1NzQ2Y2ZhYSJ9.H9ZF1uHZLwN0i4AKLlfaEnoVulPiPXWyO5kCXzBB3yM" class="fr-fic fr-fil fr-dib" width="728" style="width: 730px; height: 223.679px;" height="224"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 1. Import Tickets button</strong></span></p><p><br></p><p data-pasted="true">Next you will need to configure your XLS file ready to be imported. If open, close the File Explorer, and click "Download Samples" to download the XLS templates. </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjBmNzBmMjZmLWE4MGItNDIzMi04NTgzLTkyYzFmZDhkZGIwZiJ9.GUFyoaqTsYPCv03ZnnA-YbTUlqwR_90LbvSL4d_zmy0" class="fr-fic fr-fil fr-dib" width="1078" style="width: 1080px; height: 301.248px;" height="301"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 2. Download Samples option</strong></span></p><p><br></p><p data-pasted="true">This will download a folder called "importspreadsheetsweb".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjFmMGQ2ZDFhLTcxMTYtNDE5YS1iNjdhLTM0ODY2NzdmYmFhMSJ9.k0GU4_lR2lENIqhUHuYKZkypevd6C66jkKmK8Q09TDc" class="fr-fic fr-fil fr-dib" width="1078" style="width: 1080px; height: 277.908px;" height="278"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 3. Import Spreadsheets folder</strong></span></p><p><br></p><p data-pasted="true">Opening this folder will show the sub-folder "ExampleSpreadsheets" which when opened will show all available XLS templates.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijg0ZTYzMGM1LWU3MWMtNDA0Ny05YjMxLTQ1ZGVhOGVkOWVhNiJ9.DssO0J_z9YRSDL1pdFLJBHDXnno13QFhbMsGlpPJwVA" class="fr-fic fr-fil fr-dib" width="1088" style="width: 1090px; height: 244.183px;" height="244"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 4. Example Spreadsheets</strong></span></p><p><br></p><p data-pasted="true">Within this folder locate and open the XLS file titled "Tickets".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImI5NTYwYjJlLThiNDYtNDQ4Mi04MzMwLWJiZDQ4MmFmNWQ2NCJ9.f720tThPre8zHp2jIM09sxjcExnliwy2w0gzCM1mYPk" class="fr-fic fr-fil fr-dib" width="1097" style="width: 1099px; height: 557.547px;" height="558"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 5. Tickets XLS template</strong></span></p><p><br></p><p data-pasted="true">Click into the "IMPORT DATA" sheet and, without changing the blue column headings, remove the example data.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjlhYzIwOGE3LTZkZmYtNDc3My1hNzIzLTEyNmYzMDA2YWM3OCJ9.V22GtLN-n7CPLLVYSp6pJdsWECSl3UwbXazGpO0R-Yk" class="fr-fic fr-fil fr-dib" width="1099" style="width: 1101px; height: 176.229px;" height="176"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 6. Import Data sheet</strong></span></p><p><br></p><p data-pasted="true">You can now enter your Ticket data in the relevant column. </p><p><br></p><p data-pasted="true">Once you have entered all the Ticket data, save your spreadsheet with an identifiable name.</p><p><br></p><p>In Halo, return to Configuration > Tickets > General Settings, and click "Import Tickets".</p><p><br></p><p><img data-fr-image-pasted="true" src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjJhNDY4NTNiLTI5MDQtNDE2MS05ZjhiLTllOTg1NzQ2Y2ZhYSJ9.H9ZF1uHZLwN0i4AKLlfaEnoVulPiPXWyO5kCXzBB3yM" width="778" height="239" style="box-sizing: inherit; border-style: none; cursor: pointer; padding: 0px 1px; user-select: none; text-align: left; color: rgb(0, 0, 0); font-family: sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; width: 780px; height: 239.327px; max-width: none !important;" data-pasted="true" class="fr-fil fr-dib"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 7. Import Tickets button</strong></span></p><p><br></p><p data-pasted="true">If your File Explorer does not open automatically, click "Choose File".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjU0N2RlZDlkLTNlYWQtNGRiMC1hZDVjLWNlZWZkYmFiODE1MCJ9.4Cjdo_2M5ZAFQI2GxsZi63dBuqA9i4oqlSkBXfibBgA" class="fr-fic fr-fil fr-dib" width="1101" style="width: 1103px; height: 321.214px;" height="321"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 8. <span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong>Choosing a file</strong></span></strong></span></strong></span></p><p><br></p><p data-pasted="true" style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;">Once you select your file, the data will show on the import screen. Check you are happy with the data, then select the rows you would like to import using the checkboxes, or select them all using the checkbox on the top left. Then click "Start" to run the import.</p><p style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;"><br></p><p style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;"><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImY5MzYxZjg1LTc2YjctNGM3Yi1iN2U4LWYzMDRmMmM1NTk1YSJ9.G3JvCYDA-0AK_ESdkXcHyG4gRSoqvN7U6zwezEuE_DQ" class="fr-fic fr-fil fr-dib" width="1111" style="width: 1113px; height: 146.074px;" height="146"></p><p style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;"><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 9. </strong></span></strong></span><span style="font-size: 10pt;"><strong>Importing values</strong></span></p><p style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;"><br></p><p style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;">Your new Tickets will show in the relevant Tickets Area.</p><p style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;"><br></p><p style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;"><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImJjZjgyODQ3LTIwYWUtNGY4NS04ZDk2LWJkYWFhNTNjNDY1NyJ9.SK5H9XGh1TQ6fSKoEGGu_PCqrZ8qDUbm97K22ofhhks" class="fr-fic fr-fil fr-dib" width="1116" style="width: 1118px; height: 174.296px;" height="174"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 10. Imported Ticket</strong></span></p><p><br></p><p><br></p><p data-pasted="true"><span style="font-size: 14pt;"><strong>How to Import Actions using CSV/XLS/Spreadsheet Method </strong></span></p><p data-pasted="true" style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;">This guide covers how to import Actions using an XLS Template. This spreadsheet is used for importing new Actions as "Imported Notes".</p><p style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;"><br></p><p data-pasted="true">Navigate to Configuration > Tickets > General Setting. Head to the Imports section and click the "Import Actions" button.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImI5YjY1MDRhLWRlZjctNGM4MS04OTU4LWJmMDliMjEzNzQ0ZiJ9.HUO4dwQu-oZT3d94ToH2mwkMkhpYjWhaJNk-wseVbhQ" class="fr-fic fr-fil fr-dib" width="723" style="width: 725px; height: 214.019px;" height="214"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 11. Import Actions button</strong></span></p><p><br></p><p data-pasted="true">Next you will need to configure your XLS file ready to be imported. If open, close the File Exlplorer, and click "Download Samples" to download the XLS templates. </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjBmNzBmMjZmLWE4MGItNDIzMi04NTgzLTkyYzFmZDhkZGIwZiJ9.GUFyoaqTsYPCv03ZnnA-YbTUlqwR_90LbvSL4d_zmy0" width="1078" style="width: 1080px; height: 301.248px;" height="301" class="fr-fic fr-dii"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 12. Download Samples option</strong></span></p><p><br></p><p data-pasted="true">This will download a folder called "importspreadsheetsweb".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjFmMGQ2ZDFhLTcxMTYtNDE5YS1iNjdhLTM0ODY2NzdmYmFhMSJ9.k0GU4_lR2lENIqhUHuYKZkypevd6C66jkKmK8Q09TDc" width="1078" style="width: 1080px; height: 277.908px;" height="278" class="fr-fic fr-dii"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 13. </strong></span><span data-pasted="true" style="box-sizing: inherit; font-size: 10pt;"><strong style="box-sizing: inherit; font-weight: bolder;">Import Spreadsheets folder</strong></span></p><p><br></p><p data-pasted="true">Opening this folder will show the sub-folder "ExampleSpreasheets" which when opened will show all available XLS templates.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijg0ZTYzMGM1LWU3MWMtNDA0Ny05YjMxLTQ1ZGVhOGVkOWVhNiJ9.DssO0J_z9YRSDL1pdFLJBHDXnno13QFhbMsGlpPJwVA" width="1088" style="width: 1090px; height: 244.183px;" height="244" class="fr-fic fr-dii"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 14. Example Spreadsheets</strong></span></p><p><br></p><p data-pasted="true">Within this folder locate and open the XLS file titled " Actions".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImYzZDQ1MzdmLTUzMjQtNDZmOS05Y2MyLWVjNmFlYjg4OWE4NCJ9.V7YHik9VCjL5wzRKRVUFIkKwxYBB9VPU4fyVvEcm6l4" class="fr-fic fr-fil fr-dib" width="1096" style="width: 1098px; height: 189.587px;" height="190"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 15. Actions </strong></span><span data-pasted="true" style="box-sizing: inherit; font-size: 10pt;"><strong style="box-sizing: inherit; font-weight: bolder;">XLS template</strong></span></p><p><br></p><p data-pasted="true">Click into the "IMPORT DATA" sheet and, without changing the blue column headings, remove the example data.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjU2MTdkMTI0LTQ0NDItNGVhOS1iNmM3LTM0NjIwMjcwNzVkNiJ9.hvqatNI-6YUup8C-l4Gm8u9cenyMXOp8AVGiwrMtgaw" class="fr-fic fr-fil fr-dib" width="960" style="width: 962px; height: 278.092px;" height="278"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 16. Import Data sheet</strong></span></p><p><br></p><p data-pasted="true">You can now enter your Action data in the relevant column. </p><p><br></p><p><strong><em>Note: The Ticket must exist prior to running the import for the Actions to show.</em></strong></p><p><br></p><p>Once you have entered all the Action data, save your spreadsheet with an identifiable name.</p><p><br></p><p>In Halo, return to Configuration > Tickets > General Settings, and click "Import Actions". </p><p><br></p><p><img data-fr-image-pasted="true" src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImI5YjY1MDRhLWRlZjctNGM4MS04OTU4LWJmMDliMjEzNzQ0ZiJ9.HUO4dwQu-oZT3d94ToH2mwkMkhpYjWhaJNk-wseVbhQ" width="723" height="214" style="box-sizing: inherit; border-style: none; cursor: pointer; padding: 0px 1px; user-select: none; text-align: left; color: rgb(0, 0, 0); font-family: sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; width: 725px; height: 214.019px; max-width: none !important;" data-pasted="true" class="fr-fil fr-dib"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 17. </strong></span><span data-pasted="true" style="box-sizing: inherit; font-size: 10pt;"><strong style="box-sizing: inherit; font-weight: bolder;">Import Actions button</strong></span></p><p><br></p><p data-pasted="true">If your File Explorer does not open automatically, click "Choose File".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjU0N2RlZDlkLTNlYWQtNGRiMC1hZDVjLWNlZWZkYmFiODE1MCJ9.4Cjdo_2M5ZAFQI2GxsZi63dBuqA9i4oqlSkBXfibBgA" width="1101" style="width: 1103px; height: 321.214px;" height="321" class="fr-fic fr-dii"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 18. </strong></span><span style="font-size: 10pt;"><strong>Choosing a file</strong></span></p><p><br></p><p data-pasted="true" style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;">Once you select your file, the data will show on the import screen. Check you are happy with the data, then select the rows you would like to import using the checkboxes, or select them all using the checkbox on the top left. Then click "Start" to run the import.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjVkNjU2ZWE3LTU2NmMtNDRmMC1iZGM3LWZhNzNhZGY4ZDJjYSJ9.12sroPdZ94gAsqE-H01gW3ArUARt5QN-LUpvCuIRYag" class="fr-fic fr-fil fr-dib" width="1114" style="width: 1116px; height: 201.937px;" height="202"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 19.</strong><strong> </strong></span><span style="font-size: 10pt;"><strong>Importing values</strong></span></p><p><br></p><p>Your Actions will now show as imported notes against the specified Ticket.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImFkMDAzNjc2LWZhYjktNDI0YS05ZDdjLTllMmM1YjkyZjQ5NiJ9.uDoNwhE1F6SZaPwH4V46OtDXbhinFfGjkuR8tHxweYw" class="fr-fic fr-fil fr-dib" width="1091" height="908"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 20. </strong></span><span data-pasted="true" style="box-sizing: inherit; font-size: 10pt;"><strong style="box-sizing: inherit; font-weight: bolder;">Imported Actions</strong></span></p><p><br></p><p><br></p><p data-pasted="true"><span style="font-size: 14pt;"><strong>Finding additional fields to Import </strong></span></p><p data-pasted="true"><span style="font-size: 12pt;"><strong>Custom Fields</strong></span></p><p>Custom Fields can be imported via the Spreadsheet. To do this add the Custom Field name to import, prefixed with "CF" as the Column Header. For example, "CFdesktoptype" (As custom fields do not contain spaces). </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjU2NWRiZjkxLWZmMDgtNGMzMy05MWQ2LWMwODYyOTg1MTg4YiJ9.VyCbpZDaU64RPt5Kf5LxrMbqBvgpDiGS7tSsmGxZz6s" class="fr-fic fr-fil fr-dib" width="1100" style="width: 1102px; height: 80.0369px;" height="80"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 21. </strong></span><span data-pasted="true" style="box-sizing: inherit; font-size: 10pt;"><strong style="box-sizing: inherit; font-weight: bolder;">Importing Custom Fields</strong></span></p><p><br></p><p><br></p><p><span style="font-size: 12pt;"><strong>System Fields</strong></span></p><p>If there is a particular field you would like to populate upon import you can add this to the spreadsheet. To find the correct header name for this field you will need the JSON name of the field. To find this, simply append "&showfieldnames=true" on your URL. This will display your instance with the JSON field names in braces (curly brackets) above the field. </p><p><br></p><p><em><strong>Note: This method may not work for all fields. If you are unable to import to a certain field in Halo please contact Support for assistance. </strong></em></p><p><em><strong><br></strong></em></p><p><strong><em>Note: Appending this on your URL may redirect you to the main Client/Site/User Area. Simply click into a record to view the field names.</em></strong></p><p><br></p><p>In the below example I am looking to set the "Purchase Order Number" for my Ticket.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjVkOWEyZmJiLWZiMjQtNDBlMi04ZTdkLWE5YTA2NTg1ODExYiJ9.X2kVkJlPkPA5jQ_oNPq3zSzRkog7W5UiTyqdiqdQbzg" class="fr-fic fr-fil fr-dib" width="1028" style="width: 1030px; height: 642.359px;" height="642"></p><p data-pasted="true" style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;"><span data-pasted="true" style="box-sizing: inherit; font-size: 10pt;"><strong style="box-sizing: inherit; font-weight: 700;">Fig 22. JSON field name</strong></span></p><p style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;"><br></p><p data-pasted="true">Copy the value between the brackets and paste this as a column header. </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImI5NGI3MWQxLTlmMzItNGVmYi05NmRjLTI0Yjg5NmVkZWQ5NiJ9.g16q9Nys5BqIPl-3KhHm5Waby44geTSdOwuU-_eRwYU" class="fr-fic fr-fil fr-dib" width="690" style="width: 692px; height: 137.826px;" height="138"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 23. <span style="font-size: 10pt;" data-pasted="true"><strong>Adding the <span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong>Purchase Order Number</strong></span> </strong></span></strong></span></strong></span></strong></span></strong></span></strong></span></strong><strong><span style="font-size: 10pt;" data-pasted="true"><strong>field </strong></span></strong></span>to the import spreadsheet </strong></span></strong></span></p><p><br></p><p>Run the import as normal, and the field will update to the specified value.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImExODQzZDkwLTU5Y2QtNDRjNi05NGNjLWRkZTIyYzY0YTFkNCJ9.Wr2mqz3iEB0rC8i55374P_MVJ4FYVFtvzKbBVOs-6Ac" class="fr-fic fr-fil fr-dib" width="1078" height="898"></p><p data-pasted="true"><span style="font-size: 10pt;" data-pasted="true"><strong>Fig 24. Imported <span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong><span style="font-size: 10pt;" data-pasted="true"><strong>Purchase Order Number</strong></span> </strong></span></strong></span></strong></span></strong></span></strong></span></strong></span></strong></span>field</strong></span></p><p><br></p><p><br></p><p data-pasted="true"><span style="font-size: 12pt;"><strong>Alternative method for finding Fields and Field Values</strong></span></p><p>If using the JSON name does not successfully import the values to the field, or if you need to know the format for the value you are importing into a field, you can use the Developer Console to find the correct header name. First locate the field in Halo, before editing the field you will need to open the Developer Console which can be accessed by clicking function (fn) and f12. Now edit the field, setting the value to the value you would like to import, and view the changes in the Network tab of the Developer Console. </p><p><br></p><p>In the below example I am looking to set the "Impact" field on my Ticket.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImM0MGE1MDBkLTEwMTItNDJiNC05Y2IxLTlhNmJmYTcyZjBlZCJ9.UATUjfbycPmrSrPUBFTaQ_pdEq9fhXV-8jIo1Z3WsE0" class="fr-fic fr-fil fr-dib" width="1088" style="width: 1090px; height: 503.358px;" height="503"></p><p><span style="font-size: 10pt;"><strong>Fig 25. Network tab</strong></span></p><p><br></p><p>Once I have edited the field to my desired value and clicked out of the field, additional entries will show. Select the entry with the entity name, in this case "Ticket", as this is the entity being updated. Click the "Payload" tab and expand the section.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImNkMGRhMWI5LTVmOTAtNDE1NS1hZDlkLTZjYTAyYTg0ZjJlYSJ9.xHbnojUt5DQVtB54iEVyKYqg3Kk1KQyYk3tyCmKqGbI" class="fr-fic fr-fil fr-dib" width="1100" style="width: 1102px; height: 498.768px;" height="499"></p><p><span style="font-size: 10pt;"><strong>Fig 26. Payload from editing the Impact field</strong></span></p><p><br></p><p>Extract the name of the field that has changed. This will be the column header in your spreadsheet.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImM2MzcxZDU3LTg2NjYtNDhjNy05NGNlLWUzMTMwMDU0ZmMwOCJ9.V2hlosHnFQrcC9DohGUqKg3vi9b44P0w7ppMZnwj7pk" class="fr-fic fr-fil fr-dib" width="650" style="width: 652px; height: 191.615px;" height="192">Fig 27. impact in the Dev Tools</p><p><br></p><p>To work out the value you need to enter under this column, look for the value shown in the payload after the field name.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImYyMWI3OTAxLTJiMDMtNDdlYy05MzgyLWQxYzBhMDBlM2M1NyJ9.jovyMjQBQqsOKUKjTQQbvhd6FbsntzJh-IB5mwgKXIY" class="fr-fic fr-fil fr-dib" width="683" style="width: 685px; height: 201.313px;" height="201"></p><p><span style="font-size: 10pt;"><strong>Fig 28. Impact set to "Single User Affected" in the Dev Tools </strong></span></p><p><br></p><p>Add the field name as a new column header on your spreadsheet, and fill in the values accordingly.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImVkNzYzYWMzLWJjNzktNDc0Zi1iNDhhLWY2NzRjYjk2YjgwYiJ9.mPudbQzHx2k6Hjb3c4x_u6wXjbNF299XBX-N7scVZA0" class="fr-fic fr-fil fr-dib" width="998" style="width: 1000px; height: 70.6714px;" height="71"></p><p><span style="font-size: 10pt;"><strong>Fig 29. Adding the Impact field to the spreadsheet</strong></span></p><p><br></p><p>Run the import as normal, and the field will update to the specified value.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImVmMTlhMWNjLTJhOGItNDA1OC04ZTI5LTQ4NTc3NDQwMjgxYSJ9.9v6MHveaj2o_crkqrOVTv6HwXd0k1_slJk_adpXap8I" class="fr-fic fr-fil fr-dib" width="993" style="width: 995px; height: 741.275px;" height="741"></p><p><span style="font-size: 10pt;"><strong>Fig 30. Imported Impact</strong></span></p><p><br></p><p><br></p><p><span style="font-size: 14pt;"><strong>Limiting Rows</strong></span></p><p>The "Maximum number of XLS rows" number of rows to import can be determined in Configuration > Advanced Settings. This will be set to "0" by default, which sets no limit. </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjdiOTQ2Mjc3LTgyYjAtNDAwYy05YWU2LWY1ODhkNDhiMGRjZCJ9.drIC5h8AcUfwaNzMg-MsEFeqEKHSqrLks3V-LWIq6zY" class="fr-fic fr-fil fr-dib" width="498" height="217"></p><p data-pasted="true"><span style="font-size: 10pt;"><strong>Fig 31. Limiting row numbers</strong></span></p><p><br></p><p>The value set here will be the total number of rows available to import at one time. For example, setting this to 1 will only import 1 row. When trying to import more than that, only the allowed amount will be imported as below.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjFlNjkyMzVjLTNiZGQtNGM5My1iMTlhLTRkNjkxNDljNjE5MCJ9.em2AvzFpg5eKZq_U_Ix3QNmQWYRIkf07_LmwGFF5120" class="fr-fic fr-fil fr-dib" width="1106" style="width: 1108px; height: 164.842px;" height="165"></p><p data-pasted="true"><span style="font-size: 10pt;"><strong>Fig 32. Importing only one row out of two</strong></span></p><p><br></p>
