Removing the default enabled HyperLink when using Site Columns

January 29th, 2009 by Doug Ortiz

There have been some great ideas posted in the comments section of this blog, particularly to the

following posting:

Leveraging the use of Site Columns – Part II

 

One of the blog readers: Katy, was kind enough to share a common “featurette” when using Site Columns, by default the

hyperlink is enabled pointing back to the location of the Lookup List Item. While for some in

some instances this is not a huge problem, it can be annoying for the end user.

Site Column Featurette 

 

With this suggestion in mind, looked around through the User Interface and was not able to

satisfactorily find a simple way to find a solution to this issue. After spending quite some time

decided to just go ahead and find a solution through custom development. Decided to create a

Custom Field Type, for those who are not familiar with this concept I recommend the following links:

 

By developing a Custom Field Type, I was able to get the UserControl to inherit from the BaseFieldControl. This allowed

for the display to be not done as a Link. More importantly, this could be modified to inherit from the many choices available

for SPFieldxxx. Another possibility, could be the use of a different type of control like a Multi-Choice ListBox.

 

After all was said and done this is what the code in the CreateChildControls looked like:

CreateChildControls

 

The magic happens in those12 lines of code that instantiate the Site Column, track back to the

Lookup Web, List and Field. Ending with the population of the DropDown with the ListItems of

the SharePoint List.

 

Creating a Column based on the new Custom Field Type

Newly Added CFT

 

The Custom Field Type in Action

Using the CFT

What did the end result look like?

Display View of the CFT

Notice that there is no HyperLink and that a color has been set just to add a little twist.

 

While this is not a full fledged production implementation it will give you a good starting point to

complete and customize the solution to your needs. Keep in mind, that it can be improved

by:

  • Adding code to ensure the security is working properly
  • Adding a DropDown to select the Site Column

Quite a few other modifications could be made to improve it.

Stay tuned next time we will look at how to use it with a Multi-Choice CheckBox.

 

Happy coding!

VSeWSS 1.3 CTP disponible para descarga!

January 21st, 2009 by Doug Ortiz

Contiene varios extras y es bastante estable, tuve la oportunidad de crear un Web Part Project r pidamente en Visual Studio 2008. VSeWSS 1.3 CTP no solamente crea la plantilla pero agrega al menu varias opciones cuando se ejecuta un right-click en el proyecto.

Entre las varias acciones que provee, estas estan entre las mas importantes:

    Package
    Deploy
    Retract
    Quick Deploy

o    Recycle Application Pool
o    Attach to IIS Worker Processes

VSeWSS 1.3 CTP 

 

Adicionalmente te crea el manifest.xml, ddf and feature file autom ticamente.

 

Definitivamente lo he agregado a mi lista de utilerias para desarrollo.

 

Est  disponible para descarga, aseg£rate de checar los foros para mas detalles.

The VSeWSS 1.3 CTP is available for download!

January 21st, 2009 by Doug Ortiz

It contains a lot of goodies and is very stable, have had the chance to create a Web Part project in Visual Studio 2008. VSeWSS 1.3 CTP not only creates the template but adds a menu when you right click on the project.

Among the many tasks provided the most useful ones are:

    Package
    Deploy
    Retract
    Quick Deploy

o    Recycle Application Pool
o    Attach to IIS Worker Processes

VSeWSS 1.3 CTP 

 

On top of that it creates the manifest.xml, ddf and feature file automatically.

 

It certainly has made it to the top list of my dev tool box.

 

It is available for download, make sure you check the forums for more details.

Felices Fiestas!

December 23rd, 2008 by Doug Ortiz

Queridos lectores, gracias por leer el blog y los articulos.

 

Les deseo una Feliz Navidad y Prospero Feliz A¤o!

 

Happy Holidays!

December 23rd, 2008 by Doug Ortiz

Thank you readers for following and reading the blog and all its postings.

 

Have a Merry Christmas and a Happy New Year!

SQL Server 2005 Service Pack 3 y Modalidad Integrada en SharePoint

December 19th, 2008 by Doug Ortiz

Probablemente han
escuchado que el SQL Server 2005 Service Pack 3 ha estado disponible desde
Diciembre 15, 2008.

 

Que importancia tiene
esto para la Comunidad de SharePoint?

 

La respuesta, es que
las llamadas que SSRS ejecuta contra el SharePoint Object Model han sido
optimizadas
.

 

 

Esto resulta en menos
tiempo de respuesta cuando se compara la Modalidad Integrada contra la Nativa
en SharePoint.

 

Sabiendo esto, decidi
descargar el mencionado Service Pack y determinar como se refeljaria en mi Instalacion
de SharePoint.

 

La prueba que ejecute
fue realizada en dos Maquinas Virtuales y limitada a un solo reporte con unos
pocos registros.

 

Sin embargo, el
tiempo de respuesta mejoro entre 30 a 50% de reduccion.

 

 

Aparte de la optimizacion
a la Modalidad Integrada de SharePoint, note una mejora en tiempo de respuesta
mientras accesando Central Administration y los sitios de SharePoint en
general.

.

 

Conclusion:

Asegurate de crear un
buen backup a la Instalacion existente, descarga el Service Paack y aplicalo.

 

Nota:

Han habido menciones
que ciertas opciones han sido apagadas en SQL Server, manten esto en cuenta por
si algun problema surge.

SQL Server 2005 Service Pack 3 and SharePoint Integrated Mode

December 19th, 2008 by Doug Ortiz

 As you probably have heard, SQL Server 2005 Service Pack 3 was released on December 15, 2008.

Why is this significant to the SharePoint Community?

Because, the calls that SSRS makes to the SharePoint Object Model are optimized.

This in turn reduces the latency when you compare Integrated Mode against Native Mode.

With that in mind, I set to download the Service Pack and find out how this would reflect on my SharePoint Installation.

While the benchmarking between both Virtual Machines was limited to a Report with just a few records;

the time response did show improvements. Between 30 to 50% of latency reduction.

Besides the SharePoint Integrated Mode being optimized, I did notice an improved time response
when accessing Central Administration and the other SharePoint Sites a bit snappier.

Conclusion:

Make a good backup of your environment, download and apply the SQL Server 2005 SP3.

Note:

It has been mentioned that a few options have been turned off in SQL Server, keep that in mind in case you run into some problems.

List RollUp Web Part en Acción

October 23rd, 2008 by Doug Ortiz

En este posting vamos a observar al List RollUp Web Part en Acci¢n.

Para ‚se prop¢sito, he creado una lista de pasos para demostrar las propiedades y su prop¢sito.

El Web Part puede ser descargado con su documentaci¢n en la siguiente direcci¢n: http://www.codeplex.com/illustris/Release/ProjectReleases.aspx?ReleaseId=16317

Desplegando y Utilizando el Free List RollUp Web Part

  1. Navega al Sitio de SharePoint en el cu l deseas mostrar el List RollUp Web Part
  2. Aseg£rate que tengas suficientes permisos para agregar el Web Part al Sitio de SharePoint
  3. Haz cliq en el v¡nculo Site Actions localizado en la parte derecha de la pantalla
  4. Haz cliq en el v¡nculo Edit Page
  5. Haz cliq en el v¡nculo Add a Web Part localizado en la zona d¢nde el Web Part sera agergado
  6. Busca y localiza la secci¢n llamada Illustris – Web Parts
  7. Checa el control correspondiente al Web Part llamado Illustris – Web Parts – FreeListRollUp
  8. Haz cliq en el bot¢n Add localizado al final de la pantalla
  9. Esta es como la Pantalla sera desplegada la primera vez que el Free List RollUp Web Part ha sido agregada Despliegue del Free List RollUp Web Part


 

Configurando el Free List RollUp Web Part

  1. Haz cliq en el v¡nculo Edit del Web Part
  2. Haz cliq en el v¡nculo Modify Shared Web Part
  3. El panel de configuraci¢n del Web Part sera desplegada

Panel de Propiedades del Free List RollUp Web Part

  1. Configurando el Web Part

Expande el Grupo Illustris hacienda cliq en el Icono +     

Web Part Property

Description
CAML Query Property El default est  asignado con:<Where><Contains><FieldRef Name='Title'/><Value Type='Text'>Started</Value></Contains></Where>Despliega el contenido de cualquier Lista que contiene la palabra: “Started” en la Columna: “Title”; prueba el Query de CAML exhaustivamente antes de ingresarlo en ‚sta propiedad.Nota:Mant‚n el texto todo junto y utiliza (`)
ViewFields Property El default est  asignado con:<FieldRef Name='Title' Nullable='True' />Puedes agregar cuantas columnas quieras, ellas aparecer n a la derecha del Grid.Nota:La palabra Nullable significa que si la columna no existe no ocurrir  un error y continuar  sin problema alguno.Mant‚n el texto todo junto y utiliza (`)
Query Scope Por default har  una b£squeda en todo el Site Collection, selecciona Recursive si deseas que la b£squeda se efect£e en el Sitio d¢nde el Web Part est  localizado y abajo.
Display Title As Link Desplegar  la Columna ListItem c¢mo un v¡nculo.
Open Links in Separate Window Abrir  el v¡nculo desplegado en la Columna ListItem en otra instancia de Internet Explorer.

 

List RollUp Web Part in Action

October 23rd, 2008 by Doug Ortiz

As mentioned in the previous blog posting, we were going to look at the List RollUp Web Part in Action.

For that purpose, I have made  quick list of steps to use the Web Part and demonstrate its features and capabilities.

The Web Part can be downloaded along with documentation at: http://www.codeplex.com/illustris/Release/ProjectReleases.aspx?ReleaseId=16317

Displaying the Free List RollUp Web Part

  1. Navigate to the SharePoint Site where you wish to display the List RollUp Web Part
  2. Ensure you have enough permissions to add the Web Part to the SharePoint Site
  3. Click the Site Actions Link located at the top right of the screen
  4. Click the Edit Page Link
  5. Click the Add a Web Part Link located in the Web Part Zone where the Web Part will be displayed
  6. Locate the Section named Illustris – Web Parts
  7. Check the CheckBox corresponding to the Web Part named Illustris – Web Parts – FreeListRollUp
  8. Click the Add Button located at the Bottom of the Screen
  9. First Time Display of the Free List RollUp Web Part

First Time Display of the Free List RollUp Web Part


Customizing the Free List RollUp Web Part

  1. Click the Edit Link for the Web Part
  2. Click Modify Shared Web Part
  3. The Web Part Property Pane will be displayed

Free List RollUp Web Part Property Pane

4. Customizing the Web Part

5. Expand the Illustris Group by clicking on the + Icon         

  1. Web Part Property
Description
CAML Query Property By default it is set to:<Where><Contains><FieldRef Name='Title'/><Value Type='Text'>Started</Value></Contains></Where>Which displays the content of any List that contains Started in the Title List Column; test your CAML Query thoroughly before entering it here.Note:Keep the text all together and only use single quotes (`)
ViewFields Property By default it is set to:<FieldRef Name='Title' Nullable='True' />You can add as many columns as you like, they will appear to the right of the Grid. Note:The Nullable keyword means if it does not exist in the List ignore the error and continue.Keep the text all together and only use single quotes (`)
Query Scope By default it will search throughout the entire Site Collection, choose Recursive if you wish to search within the current Site and below.
Display Title As Link Will display the ListItem Column as a HyperLink.
Open Links in Separate Window Will open the link displayed in the ListItem Column in a separate Web Browser window.

 

 

<a href="http://technorati.com/claim/nac78hyvak" rel="me">Technorati Profile</a>

September 26th, 2008 by Doug Ortiz

 <a href="http://technorati.com/claim/nac78hyvak" rel="me">Technorati Profile</a>