<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><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><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><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><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><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;
}
</style><style>
p {
margin: 0; font-family: "Poppins", sans-serif, "Roboto";
}
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;
}
.styled-table thead tr th:first-child {
width: 28em; min-width: 28em; max-width: 28em; word-break: break-word;
}
.styled-table thead tr th:nth-child(2) {
width: 8em; min-width: 8em; max-width: 8em; word-break: break-word;
}
.styled-table thead tr th:nth-child(3) {
width: 8em; min-width: 8em; max-width: 8em; word-break: break-word;
}
.styled-table thead tr th:nth-child(4) {
width: 8em; min-width: 8em; max-width: 8em; word-break: break-word;
}
.styled-table thead tr th:nth-child(5) {
width: 8em; min-width: 8em; max-width: 8em; word-break: break-word;
}
.styled-table {
border-radius: 5px;border-collapse: collapse; margin: 25px 0; font-size: 1rem; font-family: "Poppins", sans-serif, "Roboto"; width: 100%; box-shadow: 0 0 20px rgba(0, 0, 0, 0.15);
}
.styled-table thead tr {
text-align: left;border-radius: 5px;
}
.styled-table th {
border-radius: 5px; padding: 12px 15px;
}
.styled-table td {
padding: 12px 15px;
}
.styled-table tbody tr {
border-bottom: 1px solid #dddddd;
}
.styled-table tbody tr:nth-of-type(even) {
background-color: #fafafa;
}
.styled-table tbody tr:last-of-type {
border-bottom: 2px solid $orcolor;
}
</style><p><span style="font-size: 14pt;"><strong>Client & Site XLS template fields</strong></span></p><table class="styled-table grid" style="width: 100%; height: 621px;"><colgroup><col style="width: 26.9729%;"><col style="width: 35.5874%;"><col style="width: 37.4397%;"></colgroup><tbody><tr style="height: 51px;"><td style="text-align: left; background-color: rgb(0, 204, 248);"><strong><span style="color: rgb(255, 255, 255); font-size: 12pt;">Column Header</span></strong><br></td><td style="text-align: left; background-color: rgb(0, 204, 248);"><strong><span style="color: rgb(255, 255, 255); font-size: 12pt;">Halo Field name</span></strong></td><td style="text-align: center; background-color: rgb(0, 204, 248);"><strong><span style="color: rgb(255, 255, 255); font-size: 12pt;">Location in Halo</span></strong></td></tr><tr style="height: 47px;"><td id="name">TopLevel<br></td><td>Top Level</td><td style="text-align: left;">Details tab of a Client. When Top-Levels are enabled this field will show. This determines the overarching categorisation/grouping level for a Client.</td></tr><tr style="height: 47px;"><td>CustomerName<br></td><td>Client Name/Customer Name</td><td style="text-align: left;"><strong>Mandatory field.</strong> Details tab of a Client. This is the name of the Client.<br></td></tr><tr style="height: 47px;"><td>AccountsID</td><td><p data-pasted="true">Customer ID for Accounting Integration</p></td><td style="text-align: left;">Billing tab of a Client. This is the ID used for to identify this Client in Accounting Integrations. </td></tr><tr style="height: 47px;"><td>SiteName</td><td>Site Name</td><td style="text-align: left;">Details tab of a Site. This is the name of the Site.</td></tr><tr style="height: 47px;"><td>AddressLine1<br></td><td>Address Line 1<br></td><td style="text-align: left;">Details tab of a Site. 1st Line of Site's address. </td></tr><tr style="height: 47px;"><td>AddressLine2<br></td><td>Address Line 2<br></td><td style="text-align: left;">Details tab of a Site. 2nd Line of Site's address. <br></td></tr><tr style="height: 47px;"><td>AddressLine3<br></td><td>Address Line 3<br></td><td style="text-align: left;">Details tab of a Site. 3rd Line of Site's address. <br></td></tr><tr style="height: 47px;"><td>AddressLine4<br></td><td>Address Line 4<br></td><td style="text-align: left;">Details tab of a Site. 4th Line of Site's address. <br></td></tr><tr style="height: 47px;"><td>PostCode<br></td><td>Post/Zip Code<br></td><td style="text-align: left;">Details tab of a Site. The Site's Postcode/Zip Code. <br></td></tr><tr style="height: 47px;"><td>SitePhoneNumber<br></td><td><p data-pasted="true">Phone Number</p></td><td style="text-align: left;">Details tab of a Site. The Site's phone number. <br></td></tr><tr style="height: 47px;"><td>SiteEmailDomain<br></td><td><p data-pasted="true">Domain Name(s)</p></td><td style="text-align: left;">Settings tab of a Site. The Domain of emails from this Site. This is used for Domain matching to assign Tickets to the correct Site even when no User is matched. </td></tr><tr style="height: 47px;"><td>SiteMemo<br></td><td>Notes</td><td style="text-align: left;">Details tab of a Site. Notes about the Site.</td></tr></tbody></table><p><br></p><p data-pasted="true"><br></p><p><br></p><p><span style="font-size: 14pt;"><strong>Importing Sites which belong to Multiple Clients</strong></span></p><p>If you have set your "Customer-Site-User Relationship" in Halo, such that a site can belong to multiple customers (option shown in Figure 1). Site imports via csv can be used to create and update a site with multiple Clients. </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImY1OTcwNmU3LWI4ZWYtNGIxZi1iYWJmLTZiMmRhMTU4MDI5YSJ9.VlKJnBvFh4BPvG4Aph61NZIS5ApZyLTFylOw8_41EnQ" class="fr-fic fr-fil fr-dib" width="1006" style="width: 1008px; height: 226.129px;" height="226"></p><p><span style="font-size: 10pt;"><strong>Fig 1. Customer-Site-User-Relationship</strong></span></p><p><br></p><p>To do this you will need to structure your import template such that there is a row for each of your sites. For each site there must be a column containing the site name, a column containing the default organisation (customer) for the site as well as another column containing all the Clients the site comes under. </p><p><br></p><p>These columns must be called "SiteName" (or Siteid), "CustomerName" and "siteclient" (respectively). </p><p><br></p><p><strong><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjUzZDFmNzVmLTIyYzktNDIyZi1iYjU0LWE3NzY4YWM0NjY2OSJ9.r3gWtDkzlSLbl97aDHMebakn7loAWVk4FjsvvHquMAg" class="fr-fic fr-fil fr-dib" width="976" style="width: 978px; height: 156.915px;" height="157"></strong></p><p><span style="font-size: 10pt;"><strong>Fig 2. Example csv to import a site belonging to multiple clients</strong></span></p><p><br></p><p><strong>SiteName</strong> - Enter the name you would like the site to have. </p><p><strong>CustomerName</strong> - Enter the name of the default customer you would like this site to belong to. If this customer does not already exist in your instance, a customer with this name will be created. If the customer already exists enter the name of the customer here. The client added here will be added to the site by default, they do not need to be added in the "Siteclient" column too. </p><p><strong>siteclient</strong> - Here you will need to add some nested JSON to determine the clients (customers) the site will be added to.</p><p><br></p><p><strong><span style="font-size: 12pt;">JSON for siteclient</span></strong></p><p>The JSON entered in the column here must follow the following format:</p><p><br></p><p>[{"id":13, "name":"Tony's Tyre Emporium"}, {"id":17,"name":"Acorn Construction"}]</p><p><br></p><p>In which "id" is the ID of the client you would like to add this site to and "name" is the name of this client. </p><p><br></p><p>When the import is run the site will be created with the specified clients. </p><p><br></p>
