<?xml version="1.0" encoding="UTF-8" standalone="no"?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><rss xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd" version="2.0"><channel><title>SURPOINT</title><description>sharepoint &amp;amp; project server</description><managingEditor>noreply@blogger.com (jpussacq)</managingEditor><pubDate>Sun, 12 Apr 2026 08:35:04 -0300</pubDate><generator>Blogger http://www.blogger.com</generator><openSearch:totalResults xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/">704</openSearch:totalResults><openSearch:startIndex xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/">1</openSearch:startIndex><openSearch:itemsPerPage xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/">25</openSearch:itemsPerPage><link>http://surpoint.blogspot.com/</link><language>en-us</language><itunes:explicit>no</itunes:explicit><itunes:subtitle>sharepoint &amp;amp; project server</itunes:subtitle><itunes:owner><itunes:email>noreply@blogger.com</itunes:email></itunes:owner><item><title>¿Cómo agregar un agrupamiento a la vista predeterminada en SharePoint 2010 con c#?</title><link>http://surpoint.blogspot.com/2019/04/como-agregar-un-agrupamiento-la-vista.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Tue, 16 Apr 2019 16:27:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-7677224283310274747</guid><description>&lt;div dir="ltr"&gt;&lt;div dir="ltr"&gt;&lt;div dir="ltr"&gt;&lt;div class="gmail_default" style="font-size:small"&gt;&lt;div class="gmail_default"&gt;&lt;font color="#ff0000" face="monospace, monospace"&gt;SPList listaSBNueva = oWebsite.Lists[&amp;quot;Subfrentes&amp;quot;];&lt;/font&gt;&lt;/div&gt;&lt;div class="gmail_default"&gt;&lt;font color="#ff0000" face="monospace, monospace"&gt;SPView vistaSB = listaSBNueva.DefaultView;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div class="gmail_default"&gt;&lt;font color="#ff0000" face="monospace, monospace"&gt;vistaSB.Query = &amp;quot;&lt;b&gt;&amp;lt;GroupBy Collapse=\&amp;quot;FALSE\&amp;quot; GroupLimit=\&amp;quot;100\&amp;quot;&amp;gt;&amp;lt;FieldRef Name=\&amp;quot;Frente\&amp;quot; Ascending=\&amp;quot;TRUE\&amp;quot; /&amp;gt;&amp;lt;/GroupBy&amp;gt;&lt;/b&gt;&amp;lt;OrderBy&amp;gt;&amp;lt;FieldRef Name=\&amp;quot;Frente\&amp;quot; Ascending=\&amp;quot;TRUE\&amp;quot;/&amp;gt;&amp;lt;/OrderBy&amp;gt;&amp;quot;; ;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div class="gmail_default"&gt;&lt;font color="#ff0000" face="monospace, monospace"&gt;vistaSB.Update();&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;El resultado:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhftgxLC2ZN860yYhtyrmIt2wS-5ghurWFt65Z9PSyyI26iOxnCwpkKPIa_kVFJwDX_E8fYD9c70y7aKggNc4QIas6XnzmQ-NLJJHL3z1XBv5F1O0ueCMqz098aPrFAFWhiLI2nBsamXzAS/s1600/image-734399.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhftgxLC2ZN860yYhtyrmIt2wS-5ghurWFt65Z9PSyyI26iOxnCwpkKPIa_kVFJwDX_E8fYD9c70y7aKggNc4QIas6XnzmQ-NLJJHL3z1XBv5F1O0ueCMqz098aPrFAFWhiLI2nBsamXzAS/s320/image-734399.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6680576105637645538" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;  </description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhftgxLC2ZN860yYhtyrmIt2wS-5ghurWFt65Z9PSyyI26iOxnCwpkKPIa_kVFJwDX_E8fYD9c70y7aKggNc4QIas6XnzmQ-NLJJHL3z1XBv5F1O0ueCMqz098aPrFAFWhiLI2nBsamXzAS/s72-c/image-734399.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">33</thr:total></item><item><title>Al menos uno de los tipos de campo no se ha instalado correctamente. Vaya a la página de configuración de la lista para eliminar estos campos</title><link>http://surpoint.blogspot.com/2019/03/al-menos-uno-de-los-tipos-de-campo-no.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Mon, 25 Mar 2019 10:15:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-8969183300421818764</guid><description>&lt;div dir="ltr"&gt;&lt;div dir="ltr"&gt;&lt;div dir="ltr"&gt;&lt;div dir="ltr"&gt;&lt;div dir="ltr"&gt;&lt;div class="gmail_default" style="font-size:small"&gt;El siguiente error es bastante común cuando estamos programando usando c# en SharePoint:&lt;/div&gt;&lt;br&gt;&lt;font color="#ff0000"&gt;Al menos uno de los tipos de campo no se ha instalado correctamente. Vaya a la página de configuración de la lista para eliminar estos campos.&lt;br&gt;&lt;/font&gt;&lt;br&gt;En inglés:&lt;br&gt;&lt;br&gt;&lt;font color="#ff0000"&gt;One or more field types are not installed properly&lt;span class="gmail_default" style="font-size:small"&gt;...&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div dir="ltr"&gt;&lt;span class="gmail_default" style="font-size:small"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class="gmail_default" style="font-size:small"&gt;La mayoría de las veces el problema es que no estamos usando el&lt;b&gt; nombre interno del campo&lt;/b&gt;. O estamos usando el que nosotros creemos que es el nombre interno del campo, pero en realidad SharePoint lo cambió por otro. Esto se debe a que:&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;ol&gt;&lt;li&gt;&lt;span class="gmail_default" style="font-size:small"&gt;Ya existe un campo con ese nombre&lt;/span&gt;&lt;/li&gt;&lt;li&gt;&lt;span class="gmail_default" style="font-size:small"&gt;El campo es muy largo y se trunca&lt;/span&gt;&lt;/li&gt;&lt;li&gt;&lt;span class="gmail_default" style="font-size:small"&gt;O se reemplazan caracteres especiales&lt;/span&gt;&lt;/li&gt;&lt;/ol&gt;&lt;span class="gmail_default" style="font-size:small"&gt;Sin embargo, existe una situación un poco más compleja de detectar.&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class="gmail_default" style="font-size:small"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class="gmail_default" style="font-size:small"&gt;Supongamos que estamos modificando un sólo campo desde C#:&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class="gmail_default" style="font-size:small"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class="gmail_default" style="font-size:small"&gt;Ejemplo:&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span class="gmail_default" style="font-size:small"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;font color="#0000ff"&gt;itemHito[&amp;quot;Flag_Pantalla_Medida&amp;quot;] = &amp;quot;SI&amp;quot;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font color="#0000ff"&gt;itemHito.Update();&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;div class="gmail_default" style="font-size:small"&gt;Obtenemos el error, pero estamos seguros que el nombre del campo es correcto.&lt;/div&gt;&lt;div class="gmail_default" style="font-size:small"&gt;Lo que puede suceder es que exista un evento que haga referencia a otro campo que no estamos proporcionando, por ejemplo:&lt;/div&gt;&lt;div class="gmail_default" style="font-size:small"&gt;&lt;br&gt;&lt;/div&gt;&lt;div class="gmail_default"&gt;&lt;div class="gmail_default" style="font-size:small"&gt;&lt;font color="#0000ff"&gt;public override void ItemUpdating(SPItemEventProperties properties)&lt;/font&gt;&lt;/div&gt;&lt;div style="font-size:small"&gt;&lt;br&gt;&lt;/div&gt;&lt;div style="font-size:small"&gt;(...)&lt;/div&gt;&lt;div style="font-size:small"&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;font color="#0000ff"&gt;nuevo = properties.AfterProperties[&amp;quot;Estado_Cumplimiento&amp;quot;];&lt;/font&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Esa línea de código produce el error. Para resolverlo, se debe agregar el campo &amp;quot;Estado_Cumplimiento&amp;quot; al momento de hacer el update.&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Hasta la próxima!&lt;/div&gt;&lt;/div&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;  </description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Contrátame</title><link>http://surpoint.blogspot.com/2017/09/contratame.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Tue, 19 Sep 2017 15:07:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-1677523747362650119</guid><description>&lt;div dir="ltr"&gt;Amigos lectores. &lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Si necesitan contratarme para una consulta, proyecto o trabajo por hora, pueden hacerlo desde cualquier parte del punto a través de Workana.&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Este es mi perfil: &lt;a href="https://www.workana.com/freelancer/juan-pablo-pussacq-laborde"&gt;https://www.workana.com/freelancer/juan-pablo-pussacq-laborde&lt;/a&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Saludos!&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5yJbv6AnXdXlFhHHfC0NDLLpFziljyS6wN2TEkT8a5pg9VOpQvTkfEORBG10zZ4lnKCMzf0_rwCYaF-mvzLXdr9_7B1fmIiH8rqgTHFG930Og5W66qLEmrXnhhocbkg7fKfs2jiFt-vyb/s1600/image-752285.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5yJbv6AnXdXlFhHHfC0NDLLpFziljyS6wN2TEkT8a5pg9VOpQvTkfEORBG10zZ4lnKCMzf0_rwCYaF-mvzLXdr9_7B1fmIiH8rqgTHFG930Og5W66qLEmrXnhhocbkg7fKfs2jiFt-vyb/s320/image-752285.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6467552676833664626" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;  </description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5yJbv6AnXdXlFhHHfC0NDLLpFziljyS6wN2TEkT8a5pg9VOpQvTkfEORBG10zZ4lnKCMzf0_rwCYaF-mvzLXdr9_7B1fmIiH8rqgTHFG930Og5W66qLEmrXnhhocbkg7fKfs2jiFt-vyb/s72-c/image-752285.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>MVP año 7 2017-2018</title><link>http://surpoint.blogspot.com/2017/07/mvp-ano-7-2017-2018.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Tue, 11 Jul 2017 17:09:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-4172261001895290567</guid><description>&lt;div dir="ltr"&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdVOICVOfj00vwyuM7xATgQH9xuntYABOosxH-rZHyQWolTE25PAK6tCn7Bn_SCqzgGOVsR79ja7VM_kDNyOZug4BabHDX8oFIttya_AtPQebVfugb3ZiZ63f72GmL7_Sn3rc1mtMvBtdd/s1600/mvp-782781.PNG"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdVOICVOfj00vwyuM7xATgQH9xuntYABOosxH-rZHyQWolTE25PAK6tCn7Bn_SCqzgGOVsR79ja7VM_kDNyOZug4BabHDX8oFIttya_AtPQebVfugb3ZiZ63f72GmL7_Sn3rc1mtMvBtdd/s320/mvp-782781.PNG"  border="0" alt="" id="BLOGGER_PHOTO_ID_6441608202414772978" /&gt;&lt;/a&gt;&lt;br&gt;​&lt;br&gt;&lt;/div&gt;  </description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdVOICVOfj00vwyuM7xATgQH9xuntYABOosxH-rZHyQWolTE25PAK6tCn7Bn_SCqzgGOVsR79ja7VM_kDNyOZug4BabHDX8oFIttya_AtPQebVfugb3ZiZ63f72GmL7_Sn3rc1mtMvBtdd/s72-c/mvp-782781.PNG" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Impedir caracteres especiales con una validación de columna</title><link>http://surpoint.blogspot.com/2017/07/impedir-caracteres-especiales-con-una.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Tue, 4 Jul 2017 08:47:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-1203251373493900332</guid><description>&lt;div dir="ltr"&gt;Les paso este interesante código que se puede agregar en una validación de columna para impedir el ingreso de caracteres especiales:&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;pre class="gmail-default gmail-prettyprint gmail-prettyprinted" style="margin-top:0px;margin-bottom:1em;padding:5px;border:0px;font-variant-numeric:inherit;font-stretch:inherit;font-size:13px;line-height:inherit;font-family:Consolas,Menlo,Monaco,&amp;quot;Lucida Console&amp;quot;,&amp;quot;Liberation Mono&amp;quot;,&amp;quot;DejaVu Sans Mono&amp;quot;,&amp;quot;Bitstream Vera Sans Mono&amp;quot;,&amp;quot;Courier New&amp;quot;,monospace,sans-serif;vertical-align:baseline;width:auto;max-height:600px;overflow:auto;background-color:rgb(239,240,241);color:rgb(57,51,24);word-wrap:normal"&gt;&lt;code style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:Consolas,Menlo,Monaco,&amp;quot;Lucida Console&amp;quot;,&amp;quot;Liberation Mono&amp;quot;,&amp;quot;DejaVu Sans Mono&amp;quot;,&amp;quot;Bitstream Vera Sans Mono&amp;quot;,&amp;quot;Courier New&amp;quot;,monospace,sans-serif;vertical-align:baseline;white-space:inherit"&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;=&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;AND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;,&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;&amp;amp;&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;!&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;@&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;~&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;#&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;$&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;%&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;*&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;(&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;)&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;-&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;+&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;:&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;;&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;[&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;]&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;.&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;/&amp;quot;&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;,&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;  &lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;[&lt;/span&gt;&lt;span class="gmail-typ" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(43,145,175)"&gt;ColumnName&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;])),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;TRUE&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;),&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;IF&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;ISERROR&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;FIND&lt;/span&gt;&lt;span class="gmail-pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)"&gt;(&lt;/span&gt;&lt;span class="gmail-str" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(125,39,39)"&gt;&amp;quot;\&amp;quot;,  [ColumnName])),TRUE))&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Fuente: &lt;a href="http://fairulshahrizat.blogspot.com.ar/2012/12/how-to-validate-special-character-on.html"&gt;http://fairulshahrizat.blogspot.com.ar/2012/12/how-to-validate-special-character-on.html&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;  </description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Vista BY MY GROUPS (lista TASKS)</title><link>http://surpoint.blogspot.com/2017/06/vista-by-my-groups-lista-tasks.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Wed, 28 Jun 2017 13:20:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-8108633434440233954</guid><description>&lt;div dir="ltr"&gt;Hace poco hicieron una pregunta en &lt;a href="https://sharepoint.stackexchange.com/questions/219108/show-all-tasks-assigned-to-me-including-those-assigned-to-me-and-multiple-users/219212#219212"&gt;https://sharepoint.stackexchange.com/questions/219108/show-all-tasks-assigned-to-me-including-those-assigned-to-me-and-multiple-users/219212#219212&lt;/a&gt; y me pareció un buen momento para recordar que la hay una vista prearmada en la lista de tareas que permite filtrar:&lt;div&gt;&lt;ul&gt;&lt;li&gt;Por las tareas asignadas a mi&lt;/li&gt;&lt;li&gt;Por las tareas asignadas a los grupos a los que pertenezco&lt;/li&gt;&lt;/ul&gt;&lt;div&gt;Se llama &amp;quot;Por mis grupos&amp;quot; y pueden verla en esta imagen:&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgR9F5qEIcKtKFrOr05ByKZLp4g4qe2zdxApydAYXGD8-UgyF39v8-oyqpfjVjl12rdYNMdNGtBsbLELfh9QieKvguL9_Ub9_PZH15s1uPChTtcbF0IjXT2iHIpoya5ZrA0AxLCWS4qsI5o/s1600/image-730283.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgR9F5qEIcKtKFrOr05ByKZLp4g4qe2zdxApydAYXGD8-UgyF39v8-oyqpfjVjl12rdYNMdNGtBsbLELfh9QieKvguL9_Ub9_PZH15s1uPChTtcbF0IjXT2iHIpoya5ZrA0AxLCWS4qsI5o/s320/image-730283.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6436725024288557234" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;  </description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgR9F5qEIcKtKFrOr05ByKZLp4g4qe2zdxApydAYXGD8-UgyF39v8-oyqpfjVjl12rdYNMdNGtBsbLELfh9QieKvguL9_Ub9_PZH15s1uPChTtcbF0IjXT2iHIpoya5ZrA0AxLCWS4qsI5o/s72-c/image-730283.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Validar que un campo fecha se encuentre entre hoy 4 meses futuros</title><link>http://surpoint.blogspot.com/2017/06/validar-que-un-campo-fecha-se-encuentre.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Thu, 15 Jun 2017 14:23:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-4344483865588288679</guid><description>&lt;div dir="ltr"&gt;Simplemente creamos una validación de columna como esta:&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;font color="#351c75"&gt;=AND(date1&amp;gt;&lt;b&gt;TODAY()&lt;/b&gt;;date1&amp;lt;(TODAY()+120))&lt;/font&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYGJRTDR4nG3nmcV5M0qV8CcnbX9y7eNfEdE1TFi4212vlJqBnYX4eHq9HhE1N0Bmu6kGHBnruwfvR1BhIGtvqLFqgsU4wkEwdFf1jhjWiwMubL00h2fcjHtdDZ4IGzQvfbt2Vkur-jQwx/s1600/image-729940.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYGJRTDR4nG3nmcV5M0qV8CcnbX9y7eNfEdE1TFi4212vlJqBnYX4eHq9HhE1N0Bmu6kGHBnruwfvR1BhIGtvqLFqgsU4wkEwdFf1jhjWiwMubL00h2fcjHtdDZ4IGzQvfbt2Vkur-jQwx/s320/image-729940.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6431917236303773106" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;  </description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYGJRTDR4nG3nmcV5M0qV8CcnbX9y7eNfEdE1TFi4212vlJqBnYX4eHq9HhE1N0Bmu6kGHBnruwfvR1BhIGtvqLFqgsU4wkEwdFf1jhjWiwMubL00h2fcjHtdDZ4IGzQvfbt2Vkur-jQwx/s72-c/image-729940.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Método simple para hacer un campo obligatorio sólo en la edición - Alternativa 2</title><link>http://surpoint.blogspot.com/2017/06/metodo-simple-para-hacer-un-campo_12.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Mon, 12 Jun 2017 16:24:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-2911856392134312886</guid><description>&lt;div dir="ltr"&gt;En un artículo anterior mostré cómo resolver este tema con una &lt;b&gt;validación de lista&lt;/b&gt;. &lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="http://surpoint.blogspot.com.ar/2017/06/metodo-simple-para-hacer-un-campo.html"&gt;http://surpoint.blogspot.com.ar/2017/06/metodo-simple-para-hacer-un-campo.html&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Otra opción es hacerlo con &lt;b&gt;JSLink&lt;/b&gt;. El resultado es:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzjNH-9LkfhedhHJl9Z0b_1HLQH7yLJ3kCfoKGuOdmfe01krq_eZjePm9rIfL0KWDzwHQHVnppyD7vPKxzTyoa6CkIb5DKqfAid4PL8TchvlZAoQaUoatRTQXpui_Yn9gT854I4CUlG9-P/s1600/image-782597.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzjNH-9LkfhedhHJl9Z0b_1HLQH7yLJ3kCfoKGuOdmfe01krq_eZjePm9rIfL0KWDzwHQHVnppyD7vPKxzTyoa6CkIb5DKqfAid4PL8TchvlZAoQaUoatRTQXpui_Yn9gT854I4CUlG9-P/s320/image-782597.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6430835128663434306" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Les dejo el código:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;(function () {&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;var overrideTest2Ctx = {};&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;overrideTest2Ctx.Templates = {};&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;overrideTest2Ctx.Templates.Fields = {&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&amp;#39;test_x0020_2&amp;#39;: { &amp;#39;EditForm&amp;#39;: hacerRequerido }&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;};&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;SPClientTemplates.TemplateManager.RegisterTemplateOverrides(overrideTest2Ctx);&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;})();&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;function hacerRequerido(ctx) {&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;    var formCtx = SPClientTemplates.Utility.GetFormContextForCurrentField(ctx);&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;span class="gmail-Apple-tab-span" style="white-space:pre"&gt;	&lt;/span&gt;var validators = new SPClientForms.ClientValidation.ValidatorSet();&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;span class="gmail-Apple-tab-span" style="white-space:pre"&gt;	&lt;/span&gt;validators.RegisterValidator(new SPClientForms.ClientValidation.RequiredValidator());&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;span class="gmail-Apple-tab-span" style="white-space:pre"&gt;	&lt;/span&gt;formCtx.registerClientValidator(formCtx.fieldName, validators);&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;span class="gmail-Apple-tab-span" style="white-space:pre"&gt;	&lt;/span&gt;return SPFieldText_Edit(ctx);&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;}&lt;/font&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;Más información en:&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blog.vgrem.com/2014/03/14/introduction-to-client-forms-validation-in-sharepoint-2013/"&gt;https://blog.vgrem.com/2014/03/14/introduction-to-client-forms-validation-in-sharepoint-2013/&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://www.martinhatch.com/2013/08/jslink-and-display-templates-part-1-overview-url-tokens-and-applying-jslink-to-objects.html"&gt;https://www.martinhatch.com/2013/08/jslink-and-display-templates-part-1-overview-url-tokens-and-applying-jslink-to-objects.html&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="http://julieturner.net/2015/08/jslink-validation-from-basic-to-advanced/"&gt;http://julieturner.net/2015/08/jslink-validation-from-basic-to-advanced/&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;  </description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzjNH-9LkfhedhHJl9Z0b_1HLQH7yLJ3kCfoKGuOdmfe01krq_eZjePm9rIfL0KWDzwHQHVnppyD7vPKxzTyoa6CkIb5DKqfAid4PL8TchvlZAoQaUoatRTQXpui_Yn9gT854I4CUlG9-P/s72-c/image-782597.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>JSLink Ejemplo simple en un Formulario</title><link>http://surpoint.blogspot.com/2017/06/jslink-ejemplo-simple-en-un-formulario.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Fri, 9 Jun 2017 18:55:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-3579562095180555121</guid><description>&lt;div dir="ltr"&gt;&lt;span style="color:rgb(85,85,85);font-family:Arial,Helvetica,sans-serif;font-size:12px"&gt;Supongamos que queremos simplemente que una columna utilice color rojo tal como se ve en esta imagen:&lt;/span&gt;&lt;br&gt;&lt;div&gt;&lt;span style="color:rgb(85,85,85);font-family:Arial,Helvetica,sans-serif;font-size:12px"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style="color:rgb(85,85,85);font-family:Arial,Helvetica,sans-serif;font-size:12px"&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPCH_s-bLWjnoX8AUlskC2pmeYk9TXh3lpx6CKivV8g0hm0_Q2j5XTnEWHAplQ1GJTt0gg2k3EUOV9CjQByiYnvBFTDZF2O-3EAiYx2rBWzTy6pj4XxQw0GxhhX4BUfqw0f6Re5R1ZLRjQ/s1600/image-741013.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPCH_s-bLWjnoX8AUlskC2pmeYk9TXh3lpx6CKivV8g0hm0_Q2j5XTnEWHAplQ1GJTt0gg2k3EUOV9CjQByiYnvBFTDZF2O-3EAiYx2rBWzTy6pj4XxQw0GxhhX4BUfqw0f6Re5R1ZLRjQ/s320/image-741013.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6429760781367723730" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style="color:rgb(85,85,85);font-family:Arial,Helvetica,sans-serif;font-size:12px"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style="color:rgb(85,85,85);font-family:Arial,Helvetica,sans-serif;font-size:12px"&gt;Simplemente creamos el siguiente script JSLINK (haciendo especial hincapié en lo que resalté en negrita):&lt;/span&gt;&lt;span style="color:rgb(85,85,85);font-family:Arial,Helvetica,sans-serif;font-size:12px"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style="color:rgb(85,85,85);font-family:Arial,Helvetica,sans-serif;font-size:12px"&gt;&lt;br&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;(function () {&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;var overrideCtx = {};&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;overrideCtx.Templates = {};&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;overrideCtx.Templates.Fields = {&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;&amp;#39;&lt;b&gt;test_x0020_1&lt;/b&gt;&amp;#39;: { &amp;#39;&lt;b&gt;DisplayForm&lt;/b&gt;&amp;#39;: &lt;b&gt;pintarDeRojo &lt;/b&gt;}&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;};&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;SPClientTemplates.TemplateManager.RegisterTemplateOverrides(overrideCtx);&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;})();&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;&lt;br&gt;&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;function &lt;b&gt;pintarDeRojo&lt;/b&gt;(ctx) {&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;&lt;br&gt;&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;    var fieldVal = ctx.CurrentItem[&lt;a href="http://ctx.CurrentFieldSchema.Name"&gt;ctx.CurrentFieldSchema.Name&lt;/a&gt;];&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;    var test1 = fieldVal.toString();&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;&lt;br&gt;&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;   &lt;b&gt; var html = &amp;quot;&amp;lt;div style=&amp;#39;color: red;&amp;#39;&amp;gt;&amp;quot; + test1 + &amp;quot;&amp;lt;/div&amp;gt;&amp;quot;;&lt;/b&gt;&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;&lt;br&gt;&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;    return html;&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#3d85c6"&gt;&lt;span style="font-size:12px"&gt;}&lt;/span&gt;&lt;/font&gt;&lt;/div&gt;&lt;div style="color:rgb(85,85,85);font-family:Arial,Helvetica,sans-serif;font-size:12px"&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;  </description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPCH_s-bLWjnoX8AUlskC2pmeYk9TXh3lpx6CKivV8g0hm0_Q2j5XTnEWHAplQ1GJTt0gg2k3EUOV9CjQByiYnvBFTDZF2O-3EAiYx2rBWzTy6pj4XxQw0GxhhX4BUfqw0f6Re5R1ZLRjQ/s72-c/image-741013.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>JSLink Ejemplo simple en una Vista</title><link>http://surpoint.blogspot.com/2017/06/jslink-ejemplo-simple-en-una-vista.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Fri, 9 Jun 2017 18:31:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-1806636907767179475</guid><description>&lt;div dir="ltr"&gt;
Supongamos que queremos simplemente que una columna utilice color rojo tal como se ve en esta imagen:&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHJOFTUZ7iV2D1h8D81t4ETGof0YYojEyFVTDEKsSS1pqB2nQ4Upi6i5hlUNKDq-dTa-6kv0ACfkSQ1FQ6JaJekgD2M4-OHK9Wt-ykzdvRO_ysdjds2cPsKqshWy9fBDg0UKwjiGtr2R0h/s1600/image-768412.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6429754459460019938" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHJOFTUZ7iV2D1h8D81t4ETGof0YYojEyFVTDEKsSS1pqB2nQ4Upi6i5hlUNKDq-dTa-6kv0ACfkSQ1FQ6JaJekgD2M4-OHK9Wt-ykzdvRO_ysdjds2cPsKqshWy9fBDg0UKwjiGtr2R0h/s320/image-768412.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Simplemente creamos el siguiente script (haciendo especial hincapié en lo que resalté en negrita):&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;(function () {&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;var overrideCtx = {};&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;overrideCtx.Templates = {};&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;overrideCtx.Templates.Fields = {&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;'&lt;b&gt;test_x0020_1&lt;/b&gt;': { '&lt;b&gt;View&lt;/b&gt;': &lt;b&gt;pintarDeRojo &lt;/b&gt;}&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;};&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;SPClientTemplates.TemplateManager.RegisterTemplateOverrides(overrideCtx);&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;})();&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;function &lt;b&gt;pintarDeRojo&lt;/b&gt;(ctx) {&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;&amp;nbsp; &amp;nbsp; var fieldVal = ctx.CurrentItem[&lt;a href="http://ctx.currentfieldschema.name/"&gt;ctx.CurrentFieldSchema.Name&lt;/a&gt;];&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;&amp;nbsp; &amp;nbsp; var test1 = fieldVal.toString();&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;&amp;nbsp; &amp;nbsp;&lt;b&gt; var html = "&amp;lt;div style='color: red;'&amp;gt;" + test1 + "&amp;lt;/div&amp;gt;";&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;&amp;nbsp; &amp;nbsp; return html;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #3d85c6; font-family: monospace , monospace;"&gt;}&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Luego subimos el script en una librería:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKAJw6Y0LET5Tk5nyPCwUKc-QTgsWEvo127842R-nwKi68q_rGdzbauQk5rzGapP778x6uQ-EpEnGpmimxB2vWS-v2fUwE2fK-CAStxPS26wkkNZwm8ucBeiSHskF2xLGgrVuaul6DFNyD/s1600/image-770073.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6429754464879628338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKAJw6Y0LET5Tk5nyPCwUKc-QTgsWEvo127842R-nwKi68q_rGdzbauQk5rzGapP778x6uQ-EpEnGpmimxB2vWS-v2fUwE2fK-CAStxPS26wkkNZwm8ucBeiSHskF2xLGgrVuaul6DFNyD/s320/image-770073.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Y finalmente editamos la webpart de la vista para que haga referencia al script:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgA-GsG0EUCh_4Q8cF5byLHPI0jx3H5xbAwFiS1ExPuoRVTEY3SXHxX6ei1wA6-Ssy2zZMuSwkZHmrGwF8oRNMrkhoLo1VuhdeD1asWEsxJvp-vnu-ruJ36S6Pv9mzVHZxC1546TsyCojSv/s1600/image-770898.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6429754470286719650" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgA-GsG0EUCh_4Q8cF5byLHPI0jx3H5xbAwFiS1ExPuoRVTEY3SXHxX6ei1wA6-Ssy2zZMuSwkZHmrGwF8oRNMrkhoLo1VuhdeD1asWEsxJvp-vnu-ruJ36S6Pv9mzVHZxC1546TsyCojSv/s320/image-770898.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;
</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHJOFTUZ7iV2D1h8D81t4ETGof0YYojEyFVTDEKsSS1pqB2nQ4Upi6i5hlUNKDq-dTa-6kv0ACfkSQ1FQ6JaJekgD2M4-OHK9Wt-ykzdvRO_ysdjds2cPsKqshWy9fBDg0UKwjiGtr2R0h/s72-c/image-768412.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Método simple para hacer un campo obligatorio sólo en la edición</title><link>http://surpoint.blogspot.com/2017/06/metodo-simple-para-hacer-un-campo.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Fri, 9 Jun 2017 17:42:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-1583541738717039900</guid><description>&lt;div dir="ltr"&gt;Creamos una validación de lista que sólo se ejecute en la edición, no en el alta del ítem. Para ello comparamos la fecha de creación con la de modificación. Si son iguales, es el alta, sino la modificación:&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Fórmula:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;=OR(Creado=Modificado;AND(Creado&amp;lt;&amp;gt;Modificado;NOT(ISBLANK([test 1]))))&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;El ítem se crea sin valor en &amp;quot;Test 1&amp;quot;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYAlEfNisiIyuyI7oY6B_UNE8JrExdx2xplSktVvzhEwEvjYx8tME0vWg6r_jftxM7eqjsBtNgzSt-ZYOgs2wgza-PW0GaxGG-IPP8R-WO2NwZzsTXxDuY-v-HyQtpHWt5ro38SyXhhMUy/s1600/image-770526.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYAlEfNisiIyuyI7oY6B_UNE8JrExdx2xplSktVvzhEwEvjYx8tME0vWg6r_jftxM7eqjsBtNgzSt-ZYOgs2wgza-PW0GaxGG-IPP8R-WO2NwZzsTXxDuY-v-HyQtpHWt5ro38SyXhhMUy/s320/image-770526.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6429742008038265618" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Resultado:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgudHcJuC4FMOw_Kt_uYhm_tPXNtP0A1oZ7t1KnNJaRYBoRw-SFaLwruXRIZNxOPhG56Uilsx-JB3gcYP0Z01QHvVCtczWyxU55lDlhyphenhyphenp-x3nmgBspcGUyDonXIbqZ1Y1sWdD5GFoCsZvzY/s1600/image-772179.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgudHcJuC4FMOw_Kt_uYhm_tPXNtP0A1oZ7t1KnNJaRYBoRw-SFaLwruXRIZNxOPhG56Uilsx-JB3gcYP0Z01QHvVCtczWyxU55lDlhyphenhyphenp-x3nmgBspcGUyDonXIbqZ1Y1sWdD5GFoCsZvzY/s320/image-772179.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6429742017407521938" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Cuando intento modificarlo:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZle7GN7g7N8OT7gAwgX4kYIyx5OCYPNRpUV_zxvtKS1Y5xTFYNfmEX8wIS4ueQcTnOgPThFWy40TiXTbq3t-WX65H2OmOuuJiXFlx8JYInTg0gp9xBVEajZMmD66i_188Kgf5Iu8Imq2U/s1600/image-773292.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZle7GN7g7N8OT7gAwgX4kYIyx5OCYPNRpUV_zxvtKS1Y5xTFYNfmEX8wIS4ueQcTnOgPThFWy40TiXTbq3t-WX65H2OmOuuJiXFlx8JYInTg0gp9xBVEajZMmD66i_188Kgf5Iu8Imq2U/s320/image-773292.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6429742023108140306" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;  </description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYAlEfNisiIyuyI7oY6B_UNE8JrExdx2xplSktVvzhEwEvjYx8tME0vWg6r_jftxM7eqjsBtNgzSt-ZYOgs2wgza-PW0GaxGG-IPP8R-WO2NwZzsTXxDuY-v-HyQtpHWt5ro38SyXhhMUy/s72-c/image-770526.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>¿Cómo cambiar permisos a una lista en SharePoint 2010 en C#?</title><link>http://surpoint.blogspot.com/2017/04/como-cambiar-permisos-una-lista-en.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Mon, 3 Apr 2017 17:45:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-3052696710886438811</guid><description>&lt;div dir="ltr"&gt;Supongamos que necesitamos realizar lo siguiente en una lista:&lt;div&gt;&lt;ol&gt;&lt;li&gt;Quebrar la herencia&lt;br&gt;&lt;/li&gt;&lt;li&gt;Borrar los permisos&lt;br&gt;&lt;/li&gt;&lt;li&gt;Asignar al grupo &amp;quot;propietarios del sitio&amp;quot; con permisos de colaboración&lt;br&gt;&lt;/li&gt;&lt;li&gt;Borrar al usuario actual que se asignó en el paso 2 (para esto debemos asegurarnos de que sea administrador de la colección de sitios o esté dentro del grupo de propietarios)&lt;br&gt;&lt;/li&gt;&lt;/ol&gt;&lt;div&gt;Esta es una posible forma de hacerlo:&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;SPList listaE = oWebsite.Lists.TryGetList(&amp;quot;Entregables&amp;quot;);&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace"&gt;&lt;font color="#0000ff"&gt;listaE.BreakRoleInheritance(&lt;/font&gt;&lt;b&gt;&lt;font color="#ff0000"&gt;false&lt;/font&gt;&lt;/b&gt;&lt;font color="#0000ff"&gt;);&lt;/font&gt;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace"&gt;&lt;font color="#0000ff"&gt;SPGroup groupAdmin = listaE.ParentWeb.&lt;/font&gt;&lt;b&gt;&lt;font color="#ff0000"&gt;AssociatedOwnerGroup&lt;/font&gt;&lt;/b&gt;&lt;font color="#0000ff"&gt;;&lt;/font&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;if (groupAdmin != null)&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;  {&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;  SPRoleAssignment roleAssignment = new SPRoleAssignment(groupAdmin);&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace"&gt;&lt;font color="#0000ff"&gt;  SPRoleDefinition roleDefinition = listaE.ParentWeb.RoleDefinitions.GetByType(SPRoleType.&lt;/font&gt;&lt;b&gt;&lt;font color="#ff0000"&gt;Contributor&lt;/font&gt;&lt;/b&gt;&lt;font color="#0000ff"&gt;);&lt;/font&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;  roleAssignment.RoleDefinitionBindings.Add(roleDefinition);&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace"&gt;&lt;font color="#0000ff"&gt;  listaE.RoleAssignments.&lt;/font&gt;&lt;b&gt;&lt;font color="#ff0000"&gt;Add&lt;/font&gt;&lt;/b&gt;&lt;font color="#0000ff"&gt;(roleAssignment);&lt;/font&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace"&gt;&lt;font color="#0000ff"&gt;  listaE.RoleAssignments.&lt;/font&gt;&lt;b&gt;&lt;font color="#ff0000"&gt;RemoveById&lt;/font&gt;&lt;/b&gt;&lt;font color="#0000ff"&gt;(&lt;a href="http://listaE.ParentWeb.CurrentUser.ID"&gt;listaE.ParentWeb.CurrentUser.ID&lt;/a&gt;);&lt;/font&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;  listaE.Update();&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;  }&lt;/font&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;  </description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>MVP Año 6 - Abriendo la caja ;-)</title><link>http://surpoint.blogspot.com/2016/10/mvp-ano-6-abriendo-la-caja.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Thu, 13 Oct 2016 16:52:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-6891259765315869999</guid><description>&lt;div dir="ltr"&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtO5sYR64KTevFAe_z0_kuxV1dBPsIpS8Vpnr6hfikh_McNS4jNWIi8zd8sVce0peLvlBJG9H15k03bbB9Sph3BXbx4h48PSCt29MBefRtEEAv1o2oJWpPR_ONVuUYDA-Y9T1RW3mks6AT/s1600/image-753811.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtO5sYR64KTevFAe_z0_kuxV1dBPsIpS8Vpnr6hfikh_McNS4jNWIi8zd8sVce0peLvlBJG9H15k03bbB9Sph3BXbx4h48PSCt29MBefRtEEAv1o2oJWpPR_ONVuUYDA-Y9T1RW3mks6AT/s320/image-753811.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6341039698412633810" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;  </description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtO5sYR64KTevFAe_z0_kuxV1dBPsIpS8Vpnr6hfikh_McNS4jNWIi8zd8sVce0peLvlBJG9H15k03bbB9Sph3BXbx4h48PSCt29MBefRtEEAv1o2oJWpPR_ONVuUYDA-Y9T1RW3mks6AT/s72-c/image-753811.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Sexto año como MVP :-)</title><link>http://surpoint.blogspot.com/2016/10/sexto-ano-como-mvp.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Mon, 3 Oct 2016 09:30:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-4179128135855882660</guid><description>&lt;div dir="ltr"&gt;&lt;div&gt;&lt;a href="https://mvp.microsoft.com/es-es/PublicProfile/4034951"&gt;https://mvp.microsoft.com/es-es/PublicProfile/4034951&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWD-B1CkwCL6SGZaFy_9bzTsa6UoZV6uLX-FyfM9cp_iBa89HNtSyNT-vdZSwkEd8FcYn6aKG9FtyZLWj6WuvAty138ydNAJTVyBbr4C5QqPypHDSsDZtFClxxuEuqisTFIRWdwms7R_bN/s1600/image-750513.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWD-B1CkwCL6SGZaFy_9bzTsa6UoZV6uLX-FyfM9cp_iBa89HNtSyNT-vdZSwkEd8FcYn6aKG9FtyZLWj6WuvAty138ydNAJTVyBbr4C5QqPypHDSsDZtFClxxuEuqisTFIRWdwms7R_bN/s320/image-750513.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6337215016662584114" /&gt;&lt;/a&gt; :-)&lt;/div&gt;  </description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWD-B1CkwCL6SGZaFy_9bzTsa6UoZV6uLX-FyfM9cp_iBa89HNtSyNT-vdZSwkEd8FcYn6aKG9FtyZLWj6WuvAty138ydNAJTVyBbr4C5QqPypHDSsDZtFClxxuEuqisTFIRWdwms7R_bN/s72-c/image-750513.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Project Server 2016</title><link>http://surpoint.blogspot.com/2016/09/project-server-2016.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Tue, 27 Sep 2016 09:17:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-8837546119174136896</guid><description>&lt;div dir="ltr"&gt;
Hola, este es un muy breve resumen de las novedades que nos trae Project Server 2016:&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;Lo que quedó obsoleto&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
Pueden encontrar el detalle en: &amp;nbsp;&lt;a href="https://technet.microsoft.com/en-us/library/mt422816(v=office.16).aspx"&gt;https://technet.microsoft.com/en-us/library/mt422816(v=office.16).aspx&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;ul&gt;
&lt;li&gt;Planes &amp;nbsp;de recurso&lt;/li&gt;
&lt;li&gt;Mis tareas (sincronización con Exchange incluida)&lt;/li&gt;
&lt;li&gt;PSI. Para nuevos desarrollos usar Project cliente Side Object Model. Tenemos adaptaciones para C#, Silverlight, Windows Phone, JavaScript y Rest.&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
Transcribo un ejemplo de CSOM en C# desde&amp;nbsp;&lt;a href="https://msdn.microsoft.com/library/office/microsoft.projectserver.client_di_pj14mref.aspx"&gt;https://msdn.microsoft.com/library/office/microsoft.projectserver.client_di_pj14mref.aspx&lt;/a&gt; que nos ayudará a entender esta API:&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;pre style="color: rgb(0 , 0 , 0); font-family: &amp;quot;consolas&amp;quot; , &amp;quot;courier&amp;quot; , monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto; padding: 5px; word-wrap: normal;"&gt;&lt;b style="color: #222222; font-family: arial,sans-serif; font-size: small; white-space: normal;"&gt;
&lt;/b&gt;&lt;/pre&gt;
&lt;pre style="color: rgb(0 , 0 , 0); font-family: &amp;quot;consolas&amp;quot; , &amp;quot;courier&amp;quot; , monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto; padding: 5px; word-wrap: normal;"&gt;&lt;b style="color: #222222; font-family: arial,sans-serif; font-size: small; white-space: normal;"&gt;&lt;pre style="color: black; font-family: Consolas, Courier, monospace !important; font-size: 14px; font-weight: normal; overflow: auto; padding: 5px; word-wrap: normal;"&gt;&lt;span style="color: blue;"&gt;using&lt;/span&gt; System;
&lt;span style="color: blue;"&gt;using&lt;/span&gt; System.Collections.Generic;
&lt;span style="color: blue;"&gt;using&lt;/span&gt; System.Linq;
&lt;span style="color: blue;"&gt;using&lt;/span&gt; System.Text;
&lt;span style="color: blue;"&gt;using&lt;/span&gt; Microsoft.ProjectServer.Client;

&lt;span style="color: blue;"&gt;namespace&lt;/span&gt; ReadProjectList
{
    &lt;span style="color: blue;"&gt;class&lt;/span&gt; Program
    {
        &lt;span style="color: blue;"&gt;private&lt;/span&gt; &lt;span style="color: blue;"&gt;const&lt;/span&gt; &lt;span style="color: blue;"&gt;string&lt;/span&gt; pwaPath = &lt;span style="color: #a31515;"&gt;"http://ServerName/PwaName/"&lt;/span&gt;;    &lt;span style="color: green;"&gt;// Change the path for Project Web App.&lt;/span&gt;
        
        &lt;span style="color: green;"&gt;// Set the context for the Project Server CSOM.&lt;/span&gt;
        &lt;span style="color: blue;"&gt;private&lt;/span&gt; &lt;span style="color: blue;"&gt;static&lt;/span&gt; ProjectContext projContext;

        &lt;span style="color: blue;"&gt;static&lt;/span&gt; &lt;span style="color: blue;"&gt;void&lt;/span&gt; Main(&lt;span style="color: blue;"&gt;string&lt;/span&gt;[] args)
        {
            projContext = &lt;span style="color: blue;"&gt;new&lt;/span&gt; ProjectContext(pwaPath); 

            &lt;span style="color: green;"&gt;// Get the list of published projects in Project Web App.&lt;/span&gt;
            projContext.Load(projContext.Projects);
            projContext.ExecuteQuery();

            Console.WriteLine(&lt;span style="color: #a31515;"&gt;"\nProject ID : Project name : Created date"&lt;/span&gt;);

            &lt;span style="color: blue;"&gt;foreach&lt;/span&gt; (PublishedProject pubProj &lt;span style="color: blue;"&gt;in&lt;/span&gt; projContext.Projects)
            {
                Console.WriteLine(&lt;span style="color: #a31515;"&gt;"\n\t{0}\n\t{1} : {2}"&lt;/span&gt;, pubProj.Id.ToString(), pubProj.Name, 
                    pubProj.CreatedDate.ToString());
            }

            Console.Write(&lt;span style="color: #a31515;"&gt;"\nPress any key to exit: "&lt;/span&gt;);
            Console.ReadKey(&lt;span style="color: blue;"&gt;false&lt;/span&gt;);
        }
    }
}&lt;/pre&gt;
&lt;/b&gt;&lt;/pre&gt;
&lt;pre style="color: rgb(0 , 0 , 0); font-family: &amp;quot;consolas&amp;quot; , &amp;quot;courier&amp;quot; , monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto; padding: 5px; word-wrap: normal;"&gt;&lt;b style="color: #222222; font-family: arial,sans-serif; font-size: small; white-space: normal;"&gt;
&lt;/b&gt;&lt;/pre&gt;
&lt;pre style="color: rgb(0 , 0 , 0); font-family: &amp;quot;consolas&amp;quot; , &amp;quot;courier&amp;quot; , monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto; padding: 5px; word-wrap: normal;"&gt;&lt;b style="color: #222222; font-family: arial,sans-serif; font-size: small; white-space: normal;"&gt;Lo nuevo en Project 2016 Cliente&lt;/b&gt;&lt;/pre&gt;
&lt;pre style="margin-bottom: 0px; margin-top: 0px; overflow: auto; padding: 5px; word-wrap: normal;"&gt;&lt;span style="color: rgb(34 , 34 , 34); font-family: &amp;quot;arial&amp;quot; , sans-serif; font-size: small; white-space: normal;"&gt;Esto lo pueden consultar en&amp;nbsp;&lt;/span&gt;&lt;span style="font-family: arial, sans-serif;"&gt;&lt;span style="white-space: normal;"&gt;&lt;a href="https://blogs.office.com/2015/09/30/whats-new-in-project-2016/"&gt;https://blogs.office.com/2015/09/30/whats-new-in-project-2016/&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;&lt;/pre&gt;
&lt;pre style="color: rgb(0 , 0 , 0); font-family: &amp;quot;consolas&amp;quot; , &amp;quot;courier&amp;quot; , monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto; padding: 5px; word-wrap: normal;"&gt;
&lt;/pre&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;pre style="color: rgb(0 , 0 , 0); font-family: &amp;quot;consolas&amp;quot; , &amp;quot;courier&amp;quot; , monospace; font-size: 14px; margin-bottom: 0px; margin-top: 0px; overflow: auto; padding: 5px; word-wrap: normal;"&gt;&lt;b style="color: #222222; font-family: arial,sans-serif; font-size: small; white-space: normal;"&gt;Lo nuevo en Project 2016 Server&lt;/b&gt;&lt;/pre&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: rgb(34 , 34 , 34); font-family: &amp;quot;arial&amp;quot; , sans-serif; font-size: small; white-space: normal;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: rgb(34 , 34 , 34); font-family: &amp;quot;arial&amp;quot; , sans-serif; font-size: small; white-space: normal;"&gt;Pueden consultar en&amp;nbsp;&lt;/span&gt;&lt;a href="https://technet.microsoft.com/en-us/library/ff631142(v=office.16).aspx"&gt;https://technet.microsoft.com/en-us/library/ff631142(v=office.16).aspx&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
A continuación un breve resumen:&lt;/div&gt;
&lt;div&gt;
&lt;ul&gt;
&lt;li&gt;Compromiso de recursos (novedad también deProject Client 2016)&lt;/li&gt;
&lt;li&gt;Instalación unificada con SharePoint. Ahora Project Server es un servicio. Requiere la versión enterprise de SharePoint&lt;/li&gt;
&lt;li&gt;De alguna forma se unifican con SharePoint los requerimientos de hardware&lt;/li&gt;
&lt;li&gt;Compatibilidad con Cliente 2013 y 2016&lt;/li&gt;
&lt;li&gt;Ya no se requieren múltiples bases de datos cuando tenemos varias instancias de Project Server&lt;/li&gt;
&lt;li&gt;Límites en campos personalizados (450)&lt;/li&gt;
&lt;li&gt;Varios cambios en la vista de línea de tiempo, por ejemplo la posibilidad de tener varias&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
Pueden encontrar más información sobre Project Server en&amp;nbsp;&lt;a href="https://products.office.com/es/project/enterprise-project-server"&gt;https://products.office.com/es/project/enterprise-project-server&lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1hZ3OgvrNmJdt1WG0l47g5T1qUxP_2F5Ef0VageZVop0yhrPjrcQC7BwON8j1qp4XEYGtLEQf1pW2HJw_mnQeuYDH5bNbThCYze2TvRst8DQ236ZpQ-CnXP5pYN7OTx9_lY6cUGZsSdlY/s1600/image-724811.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6334984958392837922" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1hZ3OgvrNmJdt1WG0l47g5T1qUxP_2F5Ef0VageZVop0yhrPjrcQC7BwON8j1qp4XEYGtLEQf1pW2HJw_mnQeuYDH5bNbThCYze2TvRst8DQ236ZpQ-CnXP5pYN7OTx9_lY6cUGZsSdlY/s320/image-724811.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1hZ3OgvrNmJdt1WG0l47g5T1qUxP_2F5Ef0VageZVop0yhrPjrcQC7BwON8j1qp4XEYGtLEQf1pW2HJw_mnQeuYDH5bNbThCYze2TvRst8DQ236ZpQ-CnXP5pYN7OTx9_lY6cUGZsSdlY/s72-c/image-724811.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>¿Cómo eliminar columnas de una lista en SharePoint con C#?</title><link>http://surpoint.blogspot.com/2016/08/como-eliminar-columnas-de-una-lista-en.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Mon, 22 Aug 2016 10:42:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-2293412528261553229</guid><description>&lt;div dir="ltr"&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;// Eliminación de columnas&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;if (listaProyectos.Fields.ContainsField(&amp;quot;Peso Budget&amp;quot;))&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;{&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    listaProyectos.Fields[&amp;quot;Peso Budget&amp;quot;].Delete();&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    listaProyectos.Fields[&amp;quot;Peso Issues&amp;quot;].Delete();&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    listaProyectos.Fields[&amp;quot;Peso Riesgos&amp;quot;].Delete();&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    contenido.InnerHtml += &amp;quot;&amp;lt;span style=&amp;#39;color: green&amp;#39;&amp;gt;Columnas de pesos eliminadas&amp;lt;/span&amp;gt;&amp;lt;br&amp;gt;&amp;quot;;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;}&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;else&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    contenido.InnerHtml += &amp;quot;&amp;lt;span style=&amp;#39;color: blue&amp;#39;&amp;gt;Columnas de pesos ya habìan sido eliminadas&amp;lt;/span&amp;gt;&amp;lt;br&amp;gt;&amp;quot;;&lt;/font&gt;&lt;/div&gt;&lt;/div&gt;  </description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>¿Cómo agregar validación de MIN y MAX en una columna en SharePoint con C#?</title><link>http://surpoint.blogspot.com/2016/08/como-agregar-validacion-de-min-y-max-en.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Mon, 22 Aug 2016 10:31:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-4543124098865692125</guid><description>&lt;div dir="ltr"&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;// Seteo de MIN y MAX&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;SPFieldNumber columnaPesoProyecto = (SPFieldNumber)listaProyectos.Fields[&amp;quot;Peso Crono&amp;quot;];&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;if (columnaPesoProyecto.MaximumValue != 0.5)&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;{&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    columnaPesoProyecto.MinimumValue = 0;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    columnaPesoProyecto.MaximumValue = 0.5;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    columnaPesoProyecto.Update();&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    contenido.InnerHtml += &amp;quot;&amp;lt;span style=&amp;#39;color: green&amp;#39;&amp;gt;Min y Max de Peso Proyecto modificados&amp;lt;/span&amp;gt;&amp;lt;br&amp;gt;&amp;quot;;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;}&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;else&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    contenido.InnerHtml += &amp;quot;&amp;lt;span style=&amp;#39;color: blue&amp;#39;&amp;gt;Min y Max de Peso Proyecto ya estaban modificados&amp;lt;/span&amp;gt;&amp;lt;br&amp;gt;&amp;quot;;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaGCrnwX-oIpMcVtnJ0V1BFLeY1ODhoFdCJuhp9DbO6hPCBJJu98LEv9-U0HjKyi4brQZQT4SDq5o4sf7Bb-2YbG1xz_x_YNM-udDJ5Ab99CaXp9JBNOyyxLXDvv_yHtHgyb4Fr5Iq57lL/s1600/image-798158.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaGCrnwX-oIpMcVtnJ0V1BFLeY1ODhoFdCJuhp9DbO6hPCBJJu98LEv9-U0HjKyi4brQZQT4SDq5o4sf7Bb-2YbG1xz_x_YNM-udDJ5Ab99CaXp9JBNOyyxLXDvv_yHtHgyb4Fr5Iq57lL/s320/image-798158.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6321645107037307810" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;/div&gt;  </description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaGCrnwX-oIpMcVtnJ0V1BFLeY1ODhoFdCJuhp9DbO6hPCBJJu98LEv9-U0HjKyi4brQZQT4SDq5o4sf7Bb-2YbG1xz_x_YNM-udDJ5Ab99CaXp9JBNOyyxLXDvv_yHtHgyb4Fr5Iq57lL/s72-c/image-798158.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>¿Cómo eliminar una validación de lista en SharePoint con C#?</title><link>http://surpoint.blogspot.com/2016/08/como-eliminar-una-validacion-de-lista.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Mon, 22 Aug 2016 10:10:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-8573690062377237504</guid><description>&lt;div dir="ltr"&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;// Eliminar validación de lista&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;SPList listaProyectos = oSiteCollection.RootWeb.Lists[&amp;quot;Proyectos&amp;quot;];&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;if (listaProyectos.ValidationFormula != &amp;quot;&amp;quot;)&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;{&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    listaProyectos.ValidationFormula = &amp;quot;&amp;quot;;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    listaProyectos.ValidationMessage = &amp;quot;&amp;quot;;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    listaProyectos.Update();&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    contenido.InnerHtml += &amp;quot;&amp;lt;span style=&amp;#39;color: green&amp;#39;&amp;gt;Fórmula de semáforo de proyecto eliminada&amp;lt;/span&amp;gt;&amp;lt;br&amp;gt;&amp;quot;;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;}&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;else&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0b5394"&gt;    contenido.InnerHtml += &amp;quot;&amp;lt;span style=&amp;#39;color: blue&amp;#39;&amp;gt;Fórmula de semáforo de proyecto ya estaba eliminada&amp;lt;/span&amp;gt;&amp;lt;br&amp;gt;&amp;quot;;&lt;/font&gt;&lt;/div&gt;&lt;/div&gt;  </description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>¿Cómo incluir fuentes de Google localmente en un proyecto de SharePoint con Visual Studio?</title><link>http://surpoint.blogspot.com/2016/04/como-incluir-fuentes-de-google.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Sun, 17 Apr 2016 07:52:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-3606936895061888072</guid><description>&lt;div dir="ltr"&gt;
&lt;div&gt;
Muchos proyectos web utilizan &lt;b&gt;Google Fonts&lt;/b&gt;. En este breve artículo veremos cómo incorporarlas en SharePoint, asumiendo que nuestro proyecto no tiene acceso a Internet y que es necesario descargar las fuente en forma local.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTz1a_pbf4Zxtyzv5i3rD4dER_xIR1FZAWDdL9NRNFsgqSgMufo4JVZL0ItxTAD9d1CKZhHHWfRjHWP_792ZVs411WHxDKt1utRaAFHfCbQ3Hnezpzujou5pgHi0DYY97TrOwNkg7MNqEc/s1600/image-723304.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6274476163817599266" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTz1a_pbf4Zxtyzv5i3rD4dER_xIR1FZAWDdL9NRNFsgqSgMufo4JVZL0ItxTAD9d1CKZhHHWfRjHWP_792ZVs411WHxDKt1utRaAFHfCbQ3Hnezpzujou5pgHi0DYY97TrOwNkg7MNqEc/s320/image-723304.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;b&gt;&lt;/b&gt;&lt;br /&gt;
&lt;div&gt;
&lt;b&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/b&gt;&lt;/div&gt;
&lt;b&gt;Paso 1 - Descargar las fuentes&lt;/b&gt;&lt;br /&gt;
&lt;div&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
Acceder a&amp;nbsp;&lt;a href="https://google-webfonts-helper.herokuapp.com/"&gt;https://google-webfonts-helper.herokuapp.com/&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Seleccionamos la fuente&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhSNfmkFbSBHSVtdYAZ2eO_h4tY2eKjY7Vl0BSr5L7XyXrgA9xa8qBkeu1pkRNR43FBCjkgYxYuMTHUFy9SnIkC2s_mkaJNRfUTHzeegpviQNlzylW8UUd2IPKEmdbhtheZa5F7-3mZ8M3/s1600/image-724967.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6274476171851439426" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhSNfmkFbSBHSVtdYAZ2eO_h4tY2eKjY7Vl0BSr5L7XyXrgA9xa8qBkeu1pkRNR43FBCjkgYxYuMTHUFy9SnIkC2s_mkaJNRfUTHzeegpviQNlzylW8UUd2IPKEmdbhtheZa5F7-3mZ8M3/s320/image-724967.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Estilo y chartset&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtrQMKHcxb3thVZXmy36XlRmEWIrrmTegmnYh-_79pXOxWAoF8YWGUPldjhAyI4NBu3TAFeYg483Xf5ydv0i0CrDBhofK_BPvffYww0qSkX8Q-ysM-o7hiCF2vfX2dPD5qoD0MEaaz4ITN/s1600/image-726185.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6274476176823549346" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtrQMKHcxb3thVZXmy36XlRmEWIrrmTegmnYh-_79pXOxWAoF8YWGUPldjhAyI4NBu3TAFeYg483Xf5ydv0i0CrDBhofK_BPvffYww0qSkX8Q-ysM-o7hiCF2vfX2dPD5qoD0MEaaz4ITN/s320/image-726185.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
CSS&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcafocHKvjB21POIn2pj96DxuvAtbXgwDgF6IWq1T1QBcNWQnMfP0VPywbg1TBBRrKWhD-3SRacxXOr_0hgn_rvKel-eCjzA0sazX0Q4XpkIyL7nFBv2NqxGTRNIVj8Oze6Nr2KbQxFQRh/s1600/image-727889.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6274476184959543746" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcafocHKvjB21POIn2pj96DxuvAtbXgwDgF6IWq1T1QBcNWQnMfP0VPywbg1TBBRrKWhD-3SRacxXOr_0hgn_rvKel-eCjzA0sazX0Q4XpkIyL7nFBv2NqxGTRNIVj8Oze6Nr2KbQxFQRh/s320/image-727889.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiw9ERB-O3cHbCXZ06QD6LPfufSTe_RQuGEMBbjf4rxQWyCuTHKKoCuXpywLOjv4YHyctox_sGKdkJfplEBdBFGsXD9sM6JBYU5fwEv7K2aQaS9mCQtKCqxwMrKQpjL996gEc4Fbkp0v6uq/s1600/image-729355.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6274476187484001618" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiw9ERB-O3cHbCXZ06QD6LPfufSTe_RQuGEMBbjf4rxQWyCuTHKKoCuXpywLOjv4YHyctox_sGKdkJfplEBdBFGsXD9sM6JBYU5fwEv7K2aQaS9mCQtKCqxwMrKQpjL996gEc4Fbkp0v6uq/s320/image-729355.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Y finalmente descargamos los archivos de las fuentes:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiy6YQmBI0utk6gQRObIfDrhLdx9YM1f3I2y9SiFTeu8agVbwVjGLRmG7xlCPG48E00KT0gIwERLjjWkDsKzJhyGaF3VmdxwpicIX1cPFZwnsQE3Er19eMuE23M4Mq6z1Ui4dOQuwv6Amlb/s1600/image-730443.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6274476190941147314" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiy6YQmBI0utk6gQRObIfDrhLdx9YM1f3I2y9SiFTeu8agVbwVjGLRmG7xlCPG48E00KT0gIwERLjjWkDsKzJhyGaF3VmdxwpicIX1cPFZwnsQE3Er19eMuE23M4Mq6z1Ui4dOQuwv6Amlb/s320/image-730443.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;Paso 2: agregarlas en SharePoint&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
En nuestro proyecto en Visual Studio agregar las fuentes y la CSS:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn7HSEz1FIiT6Bpbcyc1GME6Lkh4hVg19K7_V81z5vy9DJfptyDCBSF4jAyyZopaM-J9cCddHKI6HBaSxkKqRTO3URIE5dasQO4LWOUQjiTmxyeiVJBNFaEfweml9xZhfGj_5_bUpZY-wL/s1600/image-731796.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6274476200292699282" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn7HSEz1FIiT6Bpbcyc1GME6Lkh4hVg19K7_V81z5vy9DJfptyDCBSF4jAyyZopaM-J9cCddHKI6HBaSxkKqRTO3URIE5dasQO4LWOUQjiTmxyeiVJBNFaEfweml9xZhfGj_5_bUpZY-wL/s320/image-731796.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Agregamos el link a la CSS en las páginas en donde las utilizaremos o en la página maestra:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;lt;link href="branding.css" type="text/css" rel="stylesheet" id="stylesheet" /&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Usamos las fuentes en nuestro código:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;body{&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;font-family: 'Source Sans Pro', sans-serif;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;Paso 3: MIME&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
Es posible que para versiones viejas de IE requieras agregar el MIME "woff" en IIS.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiB3eqZ-mAW21ehCUHF3qGDZQdvFb23N7ZGxD9zt-jV6dGByYhNkREbJsjL_GvblBmMJk6p7wRbrMT3SVrZxUQraDhNDAFC1MZADr7lyfgdaIMb2fuz7tTv6jBHXyPT9Rkmi2xEdcxZ8Nor/s1600/image-733213.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6274476203385995266" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiB3eqZ-mAW21ehCUHF3qGDZQdvFb23N7ZGxD9zt-jV6dGByYhNkREbJsjL_GvblBmMJk6p7wRbrMT3SVrZxUQraDhNDAFC1MZADr7lyfgdaIMb2fuz7tTv6jBHXyPT9Rkmi2xEdcxZ8Nor/s320/image-733213.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;Paso 4: listo&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
El resultado:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoaO65sfWFJgL4fbsDeMZR28ZFsfOcDYuZqx0cZplmeVHqGGzQuAsdBphsWW57Fo9D52pP-ku7f5gzb7ObTu3Es98DYW4ukI2DZrJwOalC41qorx8GGSvFJRN5rxz810MUdLFtcuzS-FIc/s1600/image-734940.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6274476213761829538" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoaO65sfWFJgL4fbsDeMZR28ZFsfOcDYuZqx0cZplmeVHqGGzQuAsdBphsWW57Fo9D52pP-ku7f5gzb7ObTu3Es98DYW4ukI2DZrJwOalC41qorx8GGSvFJRN5rxz810MUdLFtcuzS-FIc/s320/image-734940.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;
</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTz1a_pbf4Zxtyzv5i3rD4dER_xIR1FZAWDdL9NRNFsgqSgMufo4JVZL0ItxTAD9d1CKZhHHWfRjHWP_792ZVs411WHxDKt1utRaAFHfCbQ3Hnezpzujou5pgHi0DYY97TrOwNkg7MNqEc/s72-c/image-723304.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>¿Cómo configurar una página de aplicación como página de inicio de nuestro sitio?</title><link>http://surpoint.blogspot.com/2016/04/como-configurar-una-pagina-de.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Tue, 12 Apr 2016 11:21:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-1593804322356515902</guid><description>&lt;div dir="ltr"&gt;
&lt;b&gt;Introducción&lt;/b&gt;&lt;br /&gt;
&lt;div&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
Supongamos un escenario en donde necesitemos una &lt;b&gt;página de aplicación&lt;/b&gt; como home page de nuestro sitio con código C#.&lt;/div&gt;
&lt;div&gt;
El problema es que estas páginas no están soportadas, con lo cual debemos optar por un método de redireccionamiento.&lt;/div&gt;
&lt;div&gt;
En este breve artículo mostraremos este método completo desde Visual Studio sin utilizar la infraestructura de publicación de SharePoint (que ya dispone de un método de redireccionamiento a través de configuración y que pueden consultar en este &lt;a href="http://sharepoint.stackexchange.com/questions/89160/how-to-set-an-application-page-as-a-default-landing-page-in-sharepoint-2013-web"&gt;enlace&lt;/a&gt;)&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;Paso 1&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
Vamos a crear una página HTML que maneja la redirección.&lt;/div&gt;
&lt;div&gt;
Y un módulo para desplegar esa página.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
El módulo:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEBiNvqNT8EVcab2gZHLSeQKQXGZNjmowcHe6vS5pxLFtfEH16tknh2cC6-AfMZQYySmG5SWh09g_Up6Am4IIVQ9xCWdRfepjxy8DzQwRcj5k2KfVIlTyBwE-AAMK4Nr-H5A1LvGHCXbr6/s1600/image-771739.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6272674633458027186" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEBiNvqNT8EVcab2gZHLSeQKQXGZNjmowcHe6vS5pxLFtfEH16tknh2cC6-AfMZQYySmG5SWh09g_Up6Am4IIVQ9xCWdRfepjxy8DzQwRcj5k2KfVIlTyBwE-AAMK4Nr-H5A1LvGHCXbr6/s320/image-771739.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Reemplazamos sample.txt por nuestra página aspx:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjALJ-1mgmynJKODknF0O0Wlk5r7Gk6fPBHsdEE0xEIhuVXIZBX4jg7Qnh_lQ-AqZmTSDrRSNqJtJMYYpzQWPCcwq_IniqPRMYuc3JWIPeVLNFcA7MvHjWZEoMjgEKeemkGw53RQosDoOOK/s1600/image-773486.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6272674640411414498" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjALJ-1mgmynJKODknF0O0Wlk5r7Gk6fPBHsdEE0xEIhuVXIZBX4jg7Qnh_lQ-AqZmTSDrRSNqJtJMYYpzQWPCcwq_IniqPRMYuc3JWIPeVLNFcA7MvHjWZEoMjgEKeemkGw53RQosDoOOK/s320/image-773486.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
El código de nuestra página HTML será:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;&amp;lt;html&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;&amp;lt;head&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;&amp;lt;META http-equiv="refresh" content="0;URL=./_layouts/EMP_Procesos/HomePageSitioProyecto.aspx"&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;&amp;lt;/head&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;&amp;lt;/html&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Donde&amp;nbsp;&lt;span style="font-family: monospace , monospace;"&gt;HomePageSitioProyecto&amp;nbsp;&lt;/span&gt;es nuestra página de aplicación que desplegamos en LAYOUTS.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Así quedará el contenido de Elements.XML&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;&amp;lt;?xml version="1.0" encoding="utf-8"?&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;&amp;lt;Elements xmlns="&lt;a href="http://schemas.microsoft.com/sharepoint/"&gt;http://schemas.microsoft.com/sharepoint/&lt;/a&gt;"&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;lt;Module Name="ModuleLayoutPageRedirect"&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;lt;File Path="ModuleLayoutPageRedirect\LayoutPageRedirect.&lt;/span&gt;&lt;span style="font-family: monospace , monospace;"&gt;aspx&lt;/span&gt;&lt;span style="font-family: monospace, monospace;"&gt;" Url="LayoutPageRedirect.&lt;/span&gt;&lt;span style="font-family: monospace , monospace;"&gt;aspx&lt;/span&gt;&lt;span style="font-family: monospace, monospace;"&gt;" /&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;lt;/Module&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;&amp;lt;/Elements&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;Paso 2&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
A través de una feature y un evento, cambiamos la welcome page de nuestro sitio de esta forma:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;SPFolder rootFolder = currentWeb.RootFolder;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;string home = "&lt;/span&gt;&lt;span style="font-family: monospace , monospace;"&gt;LayoutPageRedirect.&lt;/span&gt;&lt;span style="font-family: monospace , monospace;"&gt;aspx&lt;/span&gt;&lt;span style="font-family: monospace , monospace;"&gt;";&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace , monospace;"&gt;rootFolder.WelcomePage = home;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-family: monospace, monospace;"&gt;rootFolder.Update();&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;Paso 3&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
Activamos la feature y vamos a la home page del sitio:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;http://server/plantilla_proyecto/plantilla_proyecto&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Veremos que pasa por la página (casi imperceptiblemente):&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;http://server/plantilla_proyecto/LayoutPageRedirect.aspx&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Y luego nos redirecciona a:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;http://server/plantilla_proyecto/_layouts/EMP_Procesos/HomePageSitioProyecto.aspx&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEBiNvqNT8EVcab2gZHLSeQKQXGZNjmowcHe6vS5pxLFtfEH16tknh2cC6-AfMZQYySmG5SWh09g_Up6Am4IIVQ9xCWdRfepjxy8DzQwRcj5k2KfVIlTyBwE-AAMK4Nr-H5A1LvGHCXbr6/s72-c/image-771739.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Cómo activar una feature en SharePoint desde C#</title><link>http://surpoint.blogspot.com/2016/04/como-activar-una-feature-en-sharepoint.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Mon, 11 Apr 2016 17:21:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-2577083212460433046</guid><description>&lt;div dir="ltr"&gt;&lt;div&gt;&lt;div&gt;&lt;font face="monospace, monospace"&gt;Guid featureGuid = new Guid(&amp;quot;{tuid}&amp;quot;);&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace"&gt;SPFeature feature = web.Features.SingleOrDefault(sf =&amp;gt; sf.DefinitionId == featureGuid);&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace"&gt;if(feature==null) web.Features.Add(featureGuid);&lt;/font&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;  </description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>Crear una Master Page en SharePoint 2010 utilizando Visual Studio y C#</title><link>http://surpoint.blogspot.com/2016/04/crear-una-master-page-en-sharepoint.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Mon, 11 Apr 2016 11:29:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-5264592111684334554</guid><description>&lt;div dir="ltr"&gt;&lt;b&gt;Introducción&lt;/b&gt;&lt;div&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;En este breve artículo veremos cómo trabajar con&lt;b&gt; páginas maestras de SharePoint 2010 utilizando Visual Studio&lt;/b&gt;. En este caso no le daremos participación a SharePoint Designer, ya que se trata de un proyecto desarrollado completamente en Visual Studio y desplegado mediante paquetes WSP.&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Nota: para una opción con SharePoint Designer, consultar este link &lt;a href="http://surpoint.blogspot.com.ar/2013/08/diseno-grafico-en-sharepoint-foundation.html"&gt;http://surpoint.blogspot.com.ar/2013/08/diseno-grafico-en-sharepoint-foundation.html&lt;/a&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;Paso 1 - Página maestra base&lt;/b&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;El primer paso será tomar una página maestra base. Podemos trabajar por ejemplo con la minimal.master de catálogo de páginas maestras u optar por una opción de codeplex en: &lt;a href="http://startermasterpages.codeplex.com/"&gt;http://startermasterpages.codeplex.com/&lt;/a&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;En este caso usaremos la v4.aster. Vamos a la galería y la descargamos.&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhEXt5k38Gxu7zvYEmfTOA8DTWajnZEs1Gf05lkGJQXhzLQ921rR4dOR0JKZmYMyd7ieHVWEYFXtv7pLcB33KZf_IUvJRNH36YIWYu-jLa0g5__SkEV9vmOUWIdlm7cxgQTl3JUssjPpnZ/s1600/image-756265.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhEXt5k38Gxu7zvYEmfTOA8DTWajnZEs1Gf05lkGJQXhzLQ921rR4dOR0JKZmYMyd7ieHVWEYFXtv7pLcB33KZf_IUvJRNH36YIWYu-jLa0g5__SkEV9vmOUWIdlm7cxgQTl3JUssjPpnZ/s320/image-756265.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6272305634627072354" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;Paso 2 - Creación del módulo&lt;/b&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;Dentro de Visual Studio agregamos un nuevo ítem al proyecto, en este caso un módulo:&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLjZ6hpKSxG9SzLJ0j8xhexFiF0B8InZU5IezMJsv1VHvcpjdSfY3GGXNgPoFQl8sOteqNvR4WhzOKAG4_goqzygX_16Uh3t1T8fqOjhSIJXWWAh0TxBE49dizNZU4j1lzYLRASs0GR8mB/s1600/image-760209.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLjZ6hpKSxG9SzLJ0j8xhexFiF0B8InZU5IezMJsv1VHvcpjdSfY3GGXNgPoFQl8sOteqNvR4WhzOKAG4_goqzygX_16Uh3t1T8fqOjhSIJXWWAh0TxBE49dizNZU4j1lzYLRASs0GR8mB/s320/image-760209.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6272305647438464578" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Luego eliminamos sample.txt&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1w3uD5vS4429QEllZ9mZGmJzzqqaAG4S5Kf8VLbRhhBPQ0amXytUe1xA4J3qGdZ-sPdaCcAQ86z9kRLtJIkR0YlbVCJVULSTHf9wTJr6qCEvk_s2GWnjp1pJB1ni2b-A7y0divZzNM-ma/s1600/image-764835.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1w3uD5vS4429QEllZ9mZGmJzzqqaAG4S5Kf8VLbRhhBPQ0amXytUe1xA4J3qGdZ-sPdaCcAQ86z9kRLtJIkR0YlbVCJVULSTHf9wTJr6qCEvk_s2GWnjp1pJB1ni2b-A7y0divZzNM-ma/s320/image-764835.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6272305667064159522" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Y subimos nuestra página maestra (la del paso 1)&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi96C2tcAis_AvG2_6e1XwXxmYRjifY2XDWKMjBIc1JlCPFnKYJLuXOcI89r3MBYpGUfl6NbZhr77c-J7WbKgHXHTQO267MYsKvkECLLq01YFwqDYzB6WhvHF5SPYk1Tw1e4kqasf2jalJS/s1600/image-769526.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi96C2tcAis_AvG2_6e1XwXxmYRjifY2XDWKMjBIc1JlCPFnKYJLuXOcI89r3MBYpGUfl6NbZhr77c-J7WbKgHXHTQO267MYsKvkECLLq01YFwqDYzB6WhvHF5SPYk1Tw1e4kqasf2jalJS/s320/image-769526.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6272305688660421698" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Elements.xml quedará así:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbntMl0J3W6oT29i7IwhMOYvoKV_KUJzd5nUSo87QR-Yhw0ygFpZ3Y0pDnYI2RgeJ66oQSqn1ejekB_72LTTetNDsp_gIq7f4yjLsTZpeN2RbByaM9jb5R7D28NTeKUEbUu00nVdURRlU3/s1600/image-773498.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbntMl0J3W6oT29i7IwhMOYvoKV_KUJzd5nUSo87QR-Yhw0ygFpZ3Y0pDnYI2RgeJ66oQSqn1ejekB_72LTTetNDsp_gIq7f4yjLsTZpeN2RbByaM9jb5R7D28NTeKUEbUu00nVdURRlU3/s320/image-773498.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6272305708320716210" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Modificamos Elements.xml como muestra la imagen para aseguramos que quedé en el cache.&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSG7FYoAm7465ckuPmwNT3b0zZaOi_L8__Bmtf7hjCyfl1IDFtcK4IgxPHyejgNZuRhsAazaSIX-dqM7IHNiaaZcSEeMD42yc6CVwbw7lVZKfMdLBI40ezcYYaCUubRkTn6BV6owWJtvM_/s1600/image-777260.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSG7FYoAm7465ckuPmwNT3b0zZaOi_L8__Bmtf7hjCyfl1IDFtcK4IgxPHyejgNZuRhsAazaSIX-dqM7IHNiaaZcSEeMD42yc6CVwbw7lVZKfMdLBI40ezcYYaCUubRkTn6BV6owWJtvM_/s320/image-777260.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6272305721211611794" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Código final:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;utf-8&amp;quot;?&amp;gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&amp;lt;Elements xmlns=&amp;quot;&lt;a href="http://schemas.microsoft.com/sharepoint/"&gt;http://schemas.microsoft.com/sharepoint/&lt;/a&gt;&amp;quot;&amp;gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;  &amp;lt;Module Name=&amp;quot;ModuleMasterPageSitioProyecto&amp;quot; List=&amp;quot;116&amp;quot; Url=&amp;quot;_catalogs/masterpage&amp;quot;&amp;gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;  &amp;lt;File Path=&amp;quot;ModuleMasterPageSitioProyecto\PaginaMaestraSitioProyecto.master&amp;quot; Url=&amp;quot;PaginaMaestraSitioProyecto.master&amp;quot; Type=&amp;quot;GhostableInLibrary&amp;quot;/&amp;gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&amp;lt;/Module&amp;gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&amp;lt;/Elements&amp;gt;&lt;/font&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;Paso 3 - Feature&lt;/b&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;En el tercer paso creamos una feature se Scope Web y le incorporamos el módulo creado en el paso anterior.&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRJD54Amv8ts1pVZPJ-Owo_yrnOC140BCSEi93Y-dPqNyjBKw3beGBvPiYo54AgByEF9JQG6cri8WaF3-SHhPwpSUXDPw8v_caj6YYVFDDedHGS5MjOpggv9sEc303ZtwtzlAdcBZVuKOv/s1600/image-781031.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRJD54Amv8ts1pVZPJ-Owo_yrnOC140BCSEi93Y-dPqNyjBKw3beGBvPiYo54AgByEF9JQG6cri8WaF3-SHhPwpSUXDPw8v_caj6YYVFDDedHGS5MjOpggv9sEc303ZtwtzlAdcBZVuKOv/s320/image-781031.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6272305737999810898" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Veremos que se incorporará automáticamente a nuestro paquete de despliegue:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9wUc4Nh0tAYLcgytUKXjobet4Kg78za9-2M4FNV_0UjG4iO2ivzlQ4Ep_Q18xinf5hswoSVbYJqS_jCGlZiSNsk90HYj1kNOklmNBOknVcslsbgSqaLU00Nx_4LuSOI50Xw_0APcUbww3/s1600/image-784979.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9wUc4Nh0tAYLcgytUKXjobet4Kg78za9-2M4FNV_0UjG4iO2ivzlQ4Ep_Q18xinf5hswoSVbYJqS_jCGlZiSNsk90HYj1kNOklmNBOknVcslsbgSqaLU00Nx_4LuSOI50Xw_0APcUbww3/s320/image-784979.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6272305756430620194" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;Paso 4 - Evento de la feature&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;Agregamos el evento para activar y desactivar la feature y de esta forma asignar la página maestra:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixb-BRNr8LVW9SHVS1kVlw2JztOIrtH23It6ppn12cOqTj5_1mXsfjl2A7oVuHAkY8AFIjK2dnW1g4ufJOZUqR7R-aOMIWtfx4kblrAtIQAyKR-BNrvFRIJpDRzEDtmpiJTGREZJ2jbEex/s1600/image-787716.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixb-BRNr8LVW9SHVS1kVlw2JztOIrtH23It6ppn12cOqTj5_1mXsfjl2A7oVuHAkY8AFIjK2dnW1g4ufJOZUqR7R-aOMIWtfx4kblrAtIQAyKR-BNrvFRIJpDRzEDtmpiJTGREZJ2jbEex/s320/image-787716.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6272305763043903106" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Así queda el código:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;namespace EMP_Procesos.Features.EMP_Pagina_Maestra_Sitio_Proyecto&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;{&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;    [Guid(&amp;quot;blabla&amp;quot;)]&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;    public class EMP_Pagina_Maestra_Sitio_ProyectoEventReceiver : SPFeatureReceiver&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;    {&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;        public override void FeatureActivated(SPFeatureReceiverProperties properties)&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;        {&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;            SPWeb currentWeb = (SPWeb)properties.Feature.Parent;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;            currentWeb.MasterUrl = &amp;quot;/_catalogs/masterpage/PaginaMaestraSitioProyecto.master&amp;quot;;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;            currentWeb.CustomMasterUrl = &amp;quot;/_catalogs/masterpage/PaginaMaestraSitioProyecto.master&amp;quot;;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;            currentWeb.Update();&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;        }&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;&lt;br&gt;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;        public override void FeatureDeactivating(SPFeatureReceiverProperties properties)&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;        {&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;            SPWeb currentWeb = (SPWeb)properties.Feature.Parent;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;            currentWeb.MasterUrl = &amp;quot;/_catalogs/masterpage/v4.master&amp;quot;;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;            currentWeb.CustomMasterUrl = &amp;quot;/_catalogs/masterpage/v4.master&amp;quot;;&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;            currentWeb.Update();&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;        }&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;    }&lt;/font&gt;&lt;/div&gt;&lt;div&gt;&lt;font face="monospace, monospace" color="#0000ff"&gt;}&lt;/font&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;b&gt;Paso 5 - Verificación de despliegue&lt;/b&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;En el catálogo de páginas maestras, debe aparecer:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGhY-sZKx4Lf7gEuRpZCyVwtHLzGoBAZGXhmfWRophB-Z_MFY3hz90T-Um-m0jSCw2wVpFbaTpgXEyPHcxPn1TbqLIRfkL4dyBmYVZxAKlXWD8VMZTkXpZqf4bn7dcEhDaxjTC4rdm1nvh/s1600/image-791351.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGhY-sZKx4Lf7gEuRpZCyVwtHLzGoBAZGXhmfWRophB-Z_MFY3hz90T-Um-m0jSCw2wVpFbaTpgXEyPHcxPn1TbqLIRfkL4dyBmYVZxAKlXWD8VMZTkXpZqf4bn7dcEhDaxjTC4rdm1nvh/s320/image-791351.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6272305782583601698" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;También debe aparecer la característica:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOBhstofNPB7WZHyZlYMYzMuKviROO6vK7VrhiVnR9f7ltgJvA9gWJoanqgPBXSV4dDBUBKsFe6Icg_JuzaaWeKBvcuRAWCwcrSfeNyg1YjCYPe9F4vvBtQfve5OJhb-z3Z9tQ4xV_sYwp/s1600/image-794444.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOBhstofNPB7WZHyZlYMYzMuKviROO6vK7VrhiVnR9f7ltgJvA9gWJoanqgPBXSV4dDBUBKsFe6Icg_JuzaaWeKBvcuRAWCwcrSfeNyg1YjCYPe9F4vvBtQfve5OJhb-z3Z9tQ4xV_sYwp/s320/image-794444.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6272305796533428306" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;Para este ejemplo, hicimos un cambio menor en la página maestra para verificar el funcionamiento:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&amp;lt;SharePoint:DeveloperDashboard runat=&amp;quot;server&amp;quot; /&amp;gt;&lt;/div&gt;&lt;div&gt;            &lt;b&gt;&amp;lt;div id=&amp;quot;sitio_footer&amp;quot;&amp;gt;Pie de ejemplo&amp;lt;/div&amp;gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;span class="" style="white-space:pre"&gt;		&lt;/span&gt;&amp;lt;/div&amp;gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;El resultado es:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6OAR7K2FZOS6Z8UAJ1GBWa2HnjLOTFfuKn5N7A_nBsRgiJ0C47DkSWL23ZhvXfeDb8jsSm01gz-mKIzOdwd8aeE1z7ikkG3tJrzMMPrrmtJ-gTMZPvkELN9xgQcSvJpBlxyHoeF5Id-bQ/s1600/image-797033.png"&gt;&lt;img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6OAR7K2FZOS6Z8UAJ1GBWa2HnjLOTFfuKn5N7A_nBsRgiJ0C47DkSWL23ZhvXfeDb8jsSm01gz-mKIzOdwd8aeE1z7ikkG3tJrzMMPrrmtJ-gTMZPvkELN9xgQcSvJpBlxyHoeF5Id-bQ/s320/image-797033.png"  border="0" alt="" id="BLOGGER_PHOTO_ID_6272305808156971026" /&gt;&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;Bibliografía&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://rburgundy.wordpress.com/2010/03/10/sharepoint-2010-custom-masterpage-with-code-behind-file-%E2%80%93-part-1/"&gt;https://rburgundy.wordpress.com/2010/03/10/sharepoint-2010-custom-masterpage-with-code-behind-file-%E2%80%93-part-1/&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="http://stackoverflow.com/questions/24397217/creating-a-masterpage-in-sharepoint-2013-with-visual-studio-2013"&gt;http://stackoverflow.com/questions/24397217/creating-a-masterpage-in-sharepoint-2013-with-visual-studio-2013&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="https://msdn.microsoft.com/en-us/library/ms441170(office.14).aspx"&gt;https://msdn.microsoft.com/en-us/library/ms441170(office.14).aspx&lt;/a&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;  </description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhEXt5k38Gxu7zvYEmfTOA8DTWajnZEs1Gf05lkGJQXhzLQ921rR4dOR0JKZmYMyd7ieHVWEYFXtv7pLcB33KZf_IUvJRNH36YIWYu-jLa0g5__SkEV9vmOUWIdlm7cxgQTl3JUssjPpnZ/s72-c/image-756265.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>¿Cómo crear una columna que se auto incremente en SharePoint?</title><link>http://surpoint.blogspot.com/2016/04/como-crear-una-columna-que-se-auto.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Fri, 1 Apr 2016 09:59:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-5235313658688354648</guid><description>&lt;div dir="ltr"&gt;Recientemente realizaron esta pregunta típica en un foro.&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="http://sharepoint.stackexchange.com/questions/175496/sp07-auto-increment-column/175524#175524"&gt;SP07 - Auto_Increment Column&lt;/a&gt;&lt;br&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Transcribo la respuesta con mis recomendaciones:&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;b&gt;Alternativas&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;1) Usar ID&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Es la mejor opción porque SharePoint garantiza su unicidad. Pero no se puedes aplicar lógica de negocio. Comienza en 1 y se incrementa en 1. Tendrás huecos cuando se eliminen registros.&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;2) Manejador de eventos&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Crear un receptor de eventos para generar el incremento de acuerdo a la lógica que necesites. Necesitás Visua Studio y #.&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;3) Flujo de trabajo&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Puede ser una alternativa. Pero los flujos de trabajo no están pensando para ello. La ventaja es que no necesitás desarrollar en C# como en la opción 2.&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;b&gt;Importante&lt;/b&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;No uses el campo ID dentro de un campo calculado:&lt;/div&gt;&lt;div&gt;- Tendrás problemas al insertar un registro. Funcionará bien en la modificación.&lt;/div&gt;&lt;div&gt;- No está oficialmente soportado por Microsoft&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;Si necesitás más ayuda, consultame por favor.&lt;/div&gt;&lt;div&gt;Cordiales saludos!&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;  </description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>¿Cómo actualizar sub sitios existentes cuando modifiqué la plantilla?</title><link>http://surpoint.blogspot.com/2016/03/como-actualizar-sub-sitios-existentes.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Thu, 31 Mar 2016 10:38:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-859353191837407857</guid><description>&lt;div dir="ltr"&gt;
Esta pregunta fue realizada en &lt;b&gt;&lt;a href="http://sharepoint.stackexchange.com/"&gt;sharepoint.stackexchange.com&lt;/a&gt;&lt;/b&gt; y me pareció importante compartir un enfoque que he tomado en una situación similar. Comparto la respuesta que dejé en el foro. Pueden verla en:&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="http://sharepoint.stackexchange.com/questions/175370/updating-sites-when-template-is-updated/175407"&gt;Updating sites when template is updated&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;div&gt;
&lt;b&gt;Transcripción&amp;nbsp;de mi respuesta&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Hola.&lt;/div&gt;
&lt;div&gt;
Estoy trabajando en un proyecto similar:&lt;/div&gt;
&lt;div&gt;
- Sitio raíz&lt;/div&gt;
&lt;div&gt;
- Sitios de proyecto&lt;/div&gt;
&lt;div&gt;
- Plantillas de sitios de proyecto&lt;/div&gt;
&lt;div&gt;
Es un proyecto de más de un año bastante complejo.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Me he encontrado con el mismo problema y he analizado diferentes alternativas.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
No hay forma de resolver eso automáticamente. Para ello deberías usar definiciones de sitios en lugar de plantillas de sitios. Pero es un enfoque excesivamente complejo y muy poco utilizado.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Has hecho muy bien en utilizar &lt;b&gt;tipos de contenido &lt;/b&gt;ya que eso resuelve gran parte del problema.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
En mi caso he optado por utilizar el modelo de objetos del servidor para hacer los cambios en los sitios de proyecto ya existentes. Me refiero a C# con Visual Studio. Este modelo es muy poderoso y te permite modificar cosas que uno nunca hubiese imaginado.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;Resumen del enfoque:&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
1) Creas un programa en C# para hacer los cambios mediante código. No utilizas configuración.&lt;/div&gt;
&lt;div&gt;
2) Ese programa posee un LOOP para recorrer todos los sitios de proyecto y aplicar los cambios&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Luego de usar este enfoque, he tomado la decisión de hacer todos los cambios en forma programática. Esto facilita mucho el pasaje entre ambientes de prueba y producción.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;Entonces el enfoque pasa a ser crear un programa que:&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
1) Modifique programaticamente tipos de contenido y columnas de sitio&lt;/div&gt;
&lt;div&gt;
2) Modifique programáticamente los sitios de proyecto (incluso la plantilla). Me refiero a vistas, elementos web, etc.&lt;/div&gt;
&lt;div&gt;
3) Crea una nueva plantilla basada en el sitio base y elimine la anterior&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Con este enfoque el pasaje entre desarrollo y prueba / producción es limpio y rápido. Es muy robusto. Y actualiza automáticamente los sitios existentes. Garantizando al mismo tiempo que los sitios futuros se creen con los nuevos cambios de la plantilla.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Cualquier consulta avisame.&amp;nbsp;&lt;/div&gt;
&lt;div&gt;
Tengo muchísimos ejemplos de código para compartir.&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
</description><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item><item><title>¿Cómo listar las alertas de usuario en una lista en SharePoint con c#?</title><link>http://surpoint.blogspot.com/2016/03/como-listar-las-alertas-de-usuario-en.html</link><author>noreply@blogger.com (jpussacq)</author><pubDate>Mon, 28 Mar 2016 15:14:00 -0300</pubDate><guid isPermaLink="false">tag:blogger.com,1999:blog-1589782896227255352.post-159632129419372020</guid><description>&lt;div dir="ltr"&gt;
El objetivo es lista para una lista específica las alertas de diferentes usuarios.&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
En este ejemplo, a modo de prueba, he configurado una alerta sobre la lista Hitos:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2fLjLN9eeRUNguIioZqw9tNfsMawrDF5W_XAiV7Hg1f1VQYXsxFRA4IlW6Z_TbOcD7R610pfPch4ieIpacO_-r1k6F4Scg-fxRmjM2U2xRSxtfgsdi8NIXlnk0Te1_aaeBmgshYw0K265/s1600/image-747983.png"&gt;&lt;img alt="" border="0" id="BLOGGER_PHOTO_ID_6267168382899439010" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2fLjLN9eeRUNguIioZqw9tNfsMawrDF5W_XAiV7Hg1f1VQYXsxFRA4IlW6Z_TbOcD7R610pfPch4ieIpacO_-r1k6F4Scg-fxRmjM2U2xRSxtfgsdi8NIXlnk0Te1_aaeBmgshYw0K265/s320/image-747983.png" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
El siguiente código permite listar los usuarios con alertas sobre Hitos:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; public static string listarAlertasLista(SPWeb web, string listaInternalName)&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; {&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; string alerts = "";&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; string listUrl = web.ServerRelativeUrl + "/Lists/" + listaInternalName;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; listUrl = listUrl.Replace("//", "/");&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; SPList list = web.GetList(listUrl);&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; SPAlertCollection alertsColl = web.Alerts;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; alerts += "&amp;lt;span style='color: blue'&amp;gt;Alertas de la lista " + listaInternalName + "&amp;lt;/span&amp;gt;&amp;lt;br&amp;gt;";&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; foreach (SPAlert alert in alertsColl)&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; {&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; if (alert.ListID == list.ID)&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; {&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; alerts += "Usuario: " + alert.User.LoginName + "&amp;lt;br&amp;gt;";&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; alerts += "Tipo: " + alert.AlertType + "&amp;lt;br&amp;gt;";&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; alerts += "Canales: " + alert.DeliveryChannels.ToString() + "&amp;lt;br&amp;gt;";&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; }&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; }&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; return alerts;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: blue; font-family: monospace, monospace;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; }&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
El resultado:&lt;br /&gt;
&lt;br /&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8Zzl2Cmiwv17l6PLmR8W43WZM7MwmGjVW0Vf7IUITy4OTg0zguDHDDbymwvqsiA5noupAiaDBpJEscLohrNtdkRBIxsOCn1-oR0tO8xUZzrygGrQDa5AE9IAWfV2qdKJzfkCEzDAaYkS3/s1600/resultado.JPG" imageanchor="1"&gt;&lt;img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8Zzl2Cmiwv17l6PLmR8W43WZM7MwmGjVW0Vf7IUITy4OTg0zguDHDDbymwvqsiA5noupAiaDBpJEscLohrNtdkRBIxsOCn1-oR0tO8xUZzrygGrQDa5AE9IAWfV2qdKJzfkCEzDAaYkS3/s400/resultado.JPG" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</description><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2fLjLN9eeRUNguIioZqw9tNfsMawrDF5W_XAiV7Hg1f1VQYXsxFRA4IlW6Z_TbOcD7R610pfPch4ieIpacO_-r1k6F4Scg-fxRmjM2U2xRSxtfgsdi8NIXlnk0Te1_aaeBmgshYw0K265/s72-c/image-747983.png" width="72"/><thr:total xmlns:thr="http://purl.org/syndication/thread/1.0">0</thr:total></item></channel></rss>