<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;
}
</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;
}
</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;
}
</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;
}
</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;
}
</style><p><span class="fr-video fr-fvc fr-dvb fr-draggable fr-active haloitsmvideo" contenteditable="false" draggable="true" style="display:none;"><iframe width="640" height="360" src="https://www.youtube.com/embed/qj9TIR0Wa60?wmode=opaque" frameborder="0" allowfullscreen="" class="fr-draggable"><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span></iframe> </span></p><p><span class="fr-video fr-fvc fr-dvb fr-draggable haloservicedeskvideo" contenteditable="false" draggable="true" style="display:none;"><iframe width="640" height="360" src="https://www.youtube.com/embed/Y3sAmQEu3QM?wmode=opaque" frameborder="0" allowfullscreen="" class="fr-draggable"><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span></iframe> </span></p><p><span class="fr-video fr-fvc fr-dvb fr-draggable halopsavideo" contenteditable="false" draggable="true" style="display:none;"><iframe width="640" height="360" src="https://www.youtube.com/embed/Wmov5AaJu2Q?wmode=opaque" frameborder="0" allowfullscreen="" class="fr-draggable"><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span><span class="fr-mk" style="display: none;"> </span></iframe> </span></p><p><strong>In this guide we will cover:</strong></p><p id="isPasted"><strong>- Spreadsheet templates for imports</strong></p><p><strong>- How to complete an import</strong></p><p><strong>- Importing Data to Specific Fields</strong></p><p><strong>- Limiting Rows </strong></p><p><strong>- Troubleshooting Problems and Errors</strong></p><p><br></p><p><strong>Related Guides:</strong></p><ul><li><a href="https://www.usehalo.com/guides/2850" target="_blank" rel="noopener noreferrer"><strong>Client, Sites & Users Import - CSV/XLS/Spreadsheet Method </strong></a></li><li style="font-weight: bold;"><a href="https://www.usehalo.com/guides/1281" target="_blank" rel="noopener noreferrer"><strong>Asset Type & Asset Import - CSV/XLS/Spreadsheet Method</strong></a></li><li style="font-weight: bold;"><a href="https://www.usehalo.com/guides/2854" target="_blank" rel="noopener noreferrer"><strong>Ticket/Action Import - CSV/XLS/Spreadsheet Method</strong></a></li><li style="font-weight: bold;"><a href="https://www.usehalo.com/guides/2863" target="_blank" rel="noopener noreferrer"><strong>Supplier Import - CSV/XLS/Spreadsheet Method</strong></a></li><li style="font-weight: bold;"><a href="https://www.usehalo.com/guides/2865" target="_blank" rel="noopener noreferrer"><strong>Services Import - CSV/XLS/Spreadsheet Method</strong></a></li></ul><p><br></p><p><strong><span style="font-size: 14pt;">Spreadsheet templates for imports</span></strong></p><p>Importing data via a spreadsheet allows you to create entities in your Halo instance by entering the details on a spreadsheet, then importing this spreadsheet into your instance. Imports can also be used to update the data against existing entities. </p><p><br></p><p>Before completing any imports, you should download the template spreadsheet to gauge the information needed. </p><p><br></p><p>You can download our example import spreadsheets from <a target="_blank" rel="noopener noreferrer" data-fr-linked="true" href="https://haloservicedesk.com/importspreadsheets">https://haloservicedesk.com/importspreadsheets</a>.</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.eyJpZCI6Ijg0YWI1MGE1LTQzYWMtNGI5MS05MDY4LTlmNGFlNWUxMjZjYiJ9.JfAR8Il0VBVTXNsQFgyJRHnClj-kUQLzV5Uz2JFHUgA" class="fr-fic fr-fil fr-dib" width="1011" style="width: 1013px; height: 260.667px;" height="261"></p><p><span style="font-size: 10pt;"><strong>Fig 1. Import Spreadsheets folder</strong></span></p><p><br></p><p>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.eyJpZCI6ImRhY2VlNGJhLTJmNWMtNDgxOC1iZTE5LWIwYzA2YmU4ZjFhNCJ9.trqmPFql4HxIBP-mKBfgRIMV0K7AViAYvB_B5OjDazc" class="fr-fic fr-fil fr-dib" width="1010" style="width: 1012px; height: 226.476px;" height="226"></p><p><span style="font-size: 10pt;"><strong>Fig 2. Example Spreadsheets</strong></span></p><p><br></p><p>Once you open the relevant XLS file you will see the instructions for importing to the chosen area of halo on a separate tab of the spreadsheet.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjMyY2E2NWJiLTY0NzYtNDYxZi1hMTgzLWE3MmJkNjYxZWYzZCJ9.zvh-h-ds99pRhpku8C82nPp1bTYkLTffI9bVjcPrLds" class="fr-fic fr-dii" width="963" height="102"></p><p><strong><span style="font-size: 10pt;">Fig 3. Instructions for importing on spreadsheet</span></strong></p><p><br></p><p>Switch to the "Import Data" Sheet/tab to add the data to import.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjdkMTJiYmUwLTUwOWItNGNlOC04OThjLTY3YmFiNzU4MmNmMyJ9.nx4NCEojl42jfQDgZFQiE1Wekv3fm325ZbaJ_SqiobU" class="fr-fic fr-fil fr-dib" width="969" style="width: 971px; height: 162.919px;" height="163"></p><p data-pasted="true"><span style="font-size: 10pt;"><strong>Fig 4. Import Data sheet</strong></span></p><p><br></p><p>Generally, always leave the headings in blue as they are. If you don't have this information, just leave the column name the same and the rows blank, rather than removing the column.</p><p><br></p><p>You can also add Custom Fields by field name at the end of the spreadsheet and these will be imported too - it's important that the Custom Field has been created beforehand. The column header will be the name of your Custom Field with the prefix "CF" i.e cfname. </p><p><br></p><p>An example entry from a ticket import spreadsheet is shown below, where you can see the default columns filled in appropriately.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijg1ZDI0ZjUxLWNjZTEtNDMzNS1iMTM4LTE3YzdhYTNiMzBlYSJ9.CjEmrG3cAEIIKSbDXx_oXa0AdQOXO6hQPxjBV_SGJGw" class="fr-fic fr-dii" width="1714" height="84"></p><p data-pasted="true"><strong><span style="font-size: 10pt;">Fig 5. Example entry for ticket import spreadsheet</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">How to complete an import</span></strong></p><p>To import your chosen entity you will need to head to the relevant area of Configuration. </p><p><br></p><ul><li><strong>Actions: </strong>Configuration > Tickets > General Settings > *scroll to nearly the bottom* > Import Actions</li><li><strong>Assets:</strong> Configuration > Asset Management > General Settings > *scroll to the bottom* > Import Assets</li><li><strong>Asset Types: </strong>Configuration > Asset Management > General Settings > *scroll to the bottom* > Import Asset Types</li><li><strong>Clients and Sites: </strong>Configuration > Users > General Settings > *scroll to the bottom* > Import Clients & Sites</li><li><strong>Client Contracts: </strong>Configuration > Contracts > *scroll to the bottom* > Import Client Contracts</li><li><strong>Items: </strong>Configuration > Items and Stock Control > Import Items<ul><li>The default for billing period for recurring items can be imported using the column header "item_default_billing_period_string".</li></ul></li><li><strong>Stock: </strong>Configuration > Items and Stock Control > Import Stock</li><li><strong>Knowledge Base Articles: </strong>Configuration > Knowledge Base > *scroll to the bottom* > Import Articles</li><li><strong>Appointments: </strong>Configuration > Calendars and Appointments > General Settings > *Scroll to the bottom*</li><li><strong>Supplier Contracts: </strong>Configuration > Contracts > *scroll to the bottom* > Import Supplier Contracts</li><li><strong>Suppliers:</strong> Configuration > Suppliers > Import Suppliers</li><li><strong>Tickets: </strong>Configuration > Tickets > General Settings > *scroll to nearly the bottom* > Import Tickets</li><li><strong>Services: </strong>Configuration > Services > *scroll to the bottom* > Import Services</li><li><strong>Holidays: </strong>Configuration > Service Level Agreements > Workdays > "Holiday Tab" > Import Holidays <strong>Or </strong>Configuration > Teams & Agents > Workdays "Holiday Tab" > Import Holidays</li><li><strong>Users: </strong>Configuration > Users > General Settings > *scroll to the bottom* > Import Users</li><li><strong>Addresses</strong><strong>:</strong> Configuration > Users > General Settings > *scroll to the bottom* > Import Addresses</li></ul><p><br></p><p><strong><em>Note: All imports other than Tickets, Actions, Client & Supplier Contracts and Knowledge Base Articles can also be used to update existing information - you just need to set a unique identifier in the Import set-up to ensure the existing records are matched. </em></strong></p><p><br></p><p>When you click the Import button you will have the option to choose a file to import. 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.eyJpZCI6ImYyZjQ0NmJmLTdhMjItNGM1OC04ZmUzLWFlNDJlYzY4OTRkOSJ9.mxB6n5-yQnqJWFH4re5ZdzR7dIErLpYSqtAH_kc-jQw" class="fr-fic fr-fil fr-dib" width="1244" style="width: 1246px; height: 355.81px;" height="356"></p><p data-pasted="true"><strong><span style="font-size: 10pt;">Fig 6. Choosing your spreadsheet </span></strong></p><p><br></p><p>Once you select your spreadsheet it will show on this screen.</p><p><br></p><p data-pasted="true">You have the option to select/deselect which rows you'd like to import using the checkboxes on the left. Clicking on the first checkbox beside the "Result" column, will select all of the rows to be imported, and unselecting it will unselect all rows that are to be imported. Once happy, you can click "Start" in the top-right corner. </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjEyMTE4M2FkLTMzMzYtNDc3OS1iZjY4LTM5NzQ4YmU5YzM4ZSJ9.x-atpUAc0ZQ65toyuBJRtEF2RELTHhr2eSFAvTXYXz0" class="fr-fic fr-fil fr-dib" width="1243" style="width: 1245px; height: 307.432px;" height="307"></p><p data-pasted="true"><strong><span style="font-size: 10pt;">Fig 7. Importing rows</span></strong></p><p><br></p><p>The 'Result' column will then update with whether the import of each item has been successful or has failed. If you encounter any failures and are unsure why, press "Fn + F12" on your keyboard to see the message in the 'Console' tab of the development tools on your browser, if you have further troubles, please contact Halo support.</p><p><br></p><p><strong><span style="font-size: 14pt;">Importing Data to Specific Fields</span></strong></p><p><span style="font-size: 11pt;">Halo has the ability to show the field names given to all areas of the application (Navigation Areas and Configuration Modules). To achieve this you can append any URL in Halo with "&showfieldnames=true". Some of the fields may not work for pulling through data, you can check the console for errors if the data is not importing, the error logs in the API are explained near the end of this guide.</span></p><p><br></p><p><span style="font-size: 11pt;">The field name will be shown in braces (curly brackets) above each field. To import to this field, extract this value and insert it as a new column header in your spreadsheet. </span></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImQ0MmI5ZjY5LWIxYzEtNGI5NC05YTY1LTgyODRkZGIzNDZjYSJ9.Mc0S4kpOLfz7KKE_nKZlMnK1iECu1ufuck5uEyVauHE" class="fr-fic fr-fil fr-dib" width="1318" style="width: 1320px; height: 487.946px;" height="488"></p><p><strong><span style="font-size: 10pt;">Fig 8. Append URL with showfieldnames=true</span></strong></p><p><br></p><p>To import data to custom fields on Halo, the column name will be that of the custom field, meaning that if you have a custom field for example of the location of an office, and it appears as CFLocation on the custom field list, you would also give the column on the import the same name. You may notice that the custom fields will be displaying differently when using the showfieldnames URI parameter, this is because the unique id is stored and not the custom field name, when importing custom fields, use the name i.e. CFagentonsite</p><p><br></p><p><span style="font-size: 14pt;"><strong>Limiting Rows</strong></span></p><p data-pasted="true">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.eyJpZCI6ImJlMWRiMjczLWMxMGUtNGQ3Ni04OGQ2LWZjMGIxMWJlYzI5MiJ9.Kkx4r7ZgArv8paCKPu1nFBmXXrUH5Gi8EKwi0kXm-AE" class="fr-fic fr-fil fr-dib" width="498" height="217"></p><p data-pasted="true"><span style="font-size: 10pt;"><strong>Fig 9. 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.eyJpZCI6IjM1NGU1NWRkLWU0NzgtNDI1Ni04NTBhLTc4ZmM2YmQ1ZWQ1MCJ9.8CmtWb87vKWkJ6pzmWXSqeKA7mRl3MKlF8ll319sGRo" class="fr-fic fr-fil fr-dib" width="1076" style="width: 1078px; height: 160.288px;" height="160"></p><p><span style="font-size: 10pt;"><strong>Fig 10. Importing only one row out of two</strong></span></p><p><br></p><p><span style="font-size: 14pt;" data-pasted="true"><strong>Troubleshooting Problems and Errors</strong></span></p><p><strong><span style="font-size: 12pt;">Dates not importing correctly</span></strong></p><p>Often when dates of imported into fields they will not be correctly formatted resulting in the incorrect date showing in Halo. When you enter a date into your spreadsheet ensure it is formatted as "yyyy-MM-dd". When imported the system will identify your instance's date formatting and apply to the date imported.</p><p><br></p><p><strong><span style="font-size: 12pt;">Duplicate Records </span></strong><span style="font-size: 12pt;"><br></span></p><p>If you can see duplicate records after running an import this is likely due to the Unique Identifier not being matched. When importing any entity which has a Unique Identifier, this must be included in the spreadsheet in order for existing records to be matched. Furthermore the value provided for the Unique Identifier must be a perfect match. For example if my Unique Identified for Clients is "Name", and I have an existing Client in my instance called "Batley Refreshments", importing using the Client name "Batley Refreshments LTD" will result in a new record being created. </p><p>Duplicate records can also be created by Integrations when the Unique Identifier used by the Integration cannot match on an existing record.</p><p><br></p><p><span style="font-size: 12pt;"><strong>Records not being created</strong></span></p><p>If the import fails to successfully import the entity it is likely due to a missing mandatory field.<span style="font-size: 12pt;"><strong> </strong></span>For example, when I try to import a Client without having provided the Client name the error message "Failed - Name must be completed" shows.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjVkZTkxOTY2LTg1OTEtNGUwYy04MWZmLWM0NmZjN2M5YjZmMSJ9.lMSA1IZCMCUL3LSmEQv69GX_wjaujb4GIDSf1l2EUS4" class="fr-fic fr-fil fr-dib" width="1105" style="width: 1107px; height: 152.995px;" height="153"></p><p data-pasted="true"><span style="font-size: 10pt;"><strong>Fig 11. Failed - Name must be completed</strong></span></p>
