Luis Du Solier G [El valor de la colaboración]

Cómo preparar el ambiente de trabajo de SharePoint

Cómo puedo preparar mi(s) ambiente/servidores trabajo para desarrollar sobre/con SharePoint

Que necesito para hacer pruebas de desarrollo con/en SharePoint

En muchos foros, comunidades y demás, hemos visto que se pide ayuda para ver como preparar nuestro ambiente de trabajo de SharePoint, posiblemente más orientado a pruebas de piloto, o desarrollo más que para producción. En Technet están todos los whitepaper necesarios para apoyarse y hacer una buena planeación Design and build sites for Office SharePoint Server 2007 para un ambiente productivo, pero que pasa cuando queremos setear un adecuado ambiente de desarrollo?

Buscando en TechNet me he encontrado con estas ligas que me gustaría compartirles.

The development and distribution process involves the following environments:

• Development

• Configuration management

• Test

• Authoring

• Pilot

• Production

For more information about these environments, see Review of environments.

Depending upon the scale of your coded elements and content needs and the size and complexity of your development and testing team, you might combine one or more of the environments. For more information about factors that can guide your topology and approach, see Determine your approach and Customization scenarios.

In this section:

• Set up the software configuration management environment

• Set up the development environment

  Note

  This section does not cover the actual development of coded elements for Office SharePoint Server 2007. For more information about developing the coded elements, see the Office SharePoint Server 2007 SDK Documentation (http://go.microsoft.com/fwlink/?LinkId=106289&clcid=0x409).

• Set up the integration environment (Office SharePoint Server)

• Set up the authoring environment

• Set up the pilot environment

Finalmente dos artículos interesantes de Blogs:

Preparing the development environment

How to Build a SharePoint Development Machine

Espero sea de utilidad.

Referencia: http://technet.microsoft.com/en-us/library/cc263006(TechNet.10).aspx

Si alguna vez usando los Workflows default de SharePoint (MOSS 2007) -particularmente el de aprobación-, trabajando con Formularios de InfoPath publicados a bibliotecas de formularios habilitadas para abrir los formularios usando Form Services, verificamos que tenemos problemas para abrir el documento al checar el correo que nos llega por el flujo, puede ser que sea un bug ya corregido en algún Service Pack.

There has been an error while loading the form. Click try again to attempt to load form again. If this error persists, contact the support team for the web site.
Click close to exit this message.
The URL URL_path is an unsupported relative URL. Use an absolute URL of prefix with '~sitecollection, for a site-collection-relative URL.

El problema viene cuando en el primer nivel (aunque podría presentarse en el segundo), le llega al primer aprobador un correo con la liga para verificar el contenido del formulario previo a su aprobación. Dicha liga tiene una estructura un tanto extraña cuando colocan el mouse encima y si tratan de abrirla obtendrán este error (parece ser que no sucede lo mismo si en vez de usar Form Service susamos el cliente de InfoPath):

Como posibles soluciones se tienen:

1. Modificar el archivo elemsnts.xml con el cual se necesita tener acceso a donde esta instalado SharePoint: como se ve en el siguiente estracto de la página: http://msdn.microsoft.com/en-us/library/cc263911.aspx

The following is a code segment from the elements.xml manifest file that is implemented by this particular Feature. The manifest file contains details of the different components or actions that make up a Feature. For example, the manifest for an event handler might say, for lists of the specified type, use the class defined in this specified assembly to respond to this specified list item event type, for example, the ItemUpdated event. Here, the manifest file defines a field that might be used in a list column, for example.

Xml

Copy Code

<Elements xmlns="http://schemas.microsoft.com/sharepoint/">

<Field ID="{0B9E3314-3F9F-2aa8-4BCD-7CB89A6FB32D}"

Name="ProductName"

SourceID=http://schemas.microsoft.com/sharepoint/v3

StaticName="ProductName"

Group="ProductColumns"

DisplayName="Product Name"

Type="Text">

</Field>

</Elements>

In this markup code, a field is identified by a GUID and name. The group and display name identify the Feature and the values that appear in the column setup screen on the SharePoint site. These values could just as easily be retrieved from a resource file. And finally, every field must be associated with a Windows SharePoint Services field type.

Note:

Groups typically specifies a section or area in the user interface (UI).

Install the Feature

After you have created the feature.xml and elements.xml files in a folder, you then need to install and activate the Feature. The process involves three steps.

To install and activate a Feature

1. Copy the folder containing the two files to the Windows SharePoint Services FEATURES directory.
2. Run the STSADM.EXE utility to install the Feature.
3. Run the STSADM.EXE utility to activate the Feature in the context of a Windows SharePoint Services site.

2. La segunda es instalando el SP 1 de Windows SharePoint Services 3.0 http://support.microsoft.com/kb/939592/

Windows SharePoint Services 3.0 KB 939592

In an e-mail message, you click a hyperlink for an assignment in a Microsoft Office SharePoint Server 2007 site. When you do this, you receive the following error message:
There has been an error while loading the form. Click try again to attempt to load form again. If this error persists, contact the support team for the web site.
Click close to exit this message.
The URL URL_path is an unsupported relative URL. Use an absolute URL of prefix with '~sitecollection, for a site-collection-relative URL.

Gracias a mi compañero Alejandro García por compartir esta segunda opción que parece ser la solución real al problema.

Muchas veces los clientes preguntan por casos de implementaciones reales de SharePoint para poder vislumbrar el alcance y funcionalidad de la herramienta.

A continuación compartimos un caso interesante de una implementación real, SharePoint presente en el Sitio Oficial de las Olimpiadas de Beijing 2008.

"...The 2008 Olympics in Beijing, China, will host 10,000 athletes, 302 events, 7 million spectators, and more than 20,000 international media personnel. Beijing will use a Web portal called INFO 2008 to provide Olympics partners and media with continually updated information and event results. To provide accurate information promptly, the BOCOG needed a powerful search solution for INFO 2008 that would perform at high levels and integrate into the portal’s user interface. The BOCOG used Microsoft® Office SharePoint® Server 2007 to create powerful search features for INFO 2008, so users can find the facts they need easily and quickly. Olympics athletes, officials, partners, and the accredited media will be able to search and find the information they need to successfully present, promote, and report the 29th Summer Olympics...."

Para más información se puede revisar el Caso de Estudio Aquí.

Que tal eh!

Ha sido liberado el Infrastructure Update o una actualización importante para los Servidores de Office.

Podemos ver el detalle de estas nuevas actualizaciones, importantes y recomendadas para toda instalación (de WSS 3.0, MOSS 2007, Project Server 2007, Project Professional 2007, Search Server 2008, and Search Server 2008 Express) en el Blog del equipo de producto de SharePoint. http://blogs.msdn.com/sharepoint/archive/2008/07/15/announcing-availability-of-infrastructure-updates.aspx

Del Blog del equipo de producto:

We strongly recommend that you install the updates that apply to you as soon as your patching and maintenance schedules permit.

The updates can be downloaded from the links below:

Infrastructure Update for Microsoft Office Servers (KB951297) - x86

Infrastructure Update for Microsoft Office Servers (KB951297) - x64

Infrastructure Update for Windows SharePoint Services 3.0 (KB951695) - x86

Infrastructure Update for Windows SharePoint Services 3.0 (KB951695) - x64

Infrastructure Update for Microsoft Office Project 2007 (KB951547) - x86

* The updates are applicable to all shipping languages.

Installation Instructions are available from the links below:

Deploy Software Updates for Windows SharePoint Services 3.0

Deploy Software Updates for Office SharePoint Server 2007 - This article also applies to Project Server 2007, SharePoint Server 2007, Search Server 2008 and Search Server 2008 Express.

Install the Infrastructure Update for Microsoft Office Servers (Office SharePoint Server 2007) (This article will go live later today)

Install the Infrastructure Update for Microsoft Office Servers (Search Server 2008) (This article will go live later today)

Related Knowledge Base Articles are available from the links below:

Description of the Infrastructure Update for Windows SharePoint Services 3.0 (KB951695)

Fixes Included in the Infrastructure Update for Windows SharePoint Services 3.0 (KB953749)

Description of the Infrastructure Update for Microsoft Office Servers (KB951297)

Fixes Included in the Infrastructure Update for Microsoft Office Servers (KB953750)

Description of the Infrastructure Update for Microsoft Office Project 2007 (KB951547)

Fixes Included in the Infrastructure Update for Microsoft Office Project 2007 (KB953751)

Estas actualizaciones son importantes y recomendadas, a continuación sus referencias:

Referentes a Project: (http://blogs.msdn.com/project/archive/2008/07/15/announcing-the-infrastructure-update-for-office-servers.aspx)

Project Server

• Timesheets and My Tasks stability and usability improvements
• Queue Management user interface improvements
• Logging Tracing improvements
• Project Server performance improvements
• Project Server 2003 to Project Server 2007 migration fixes
• Database performance improvements to enhance the cube building process and Project Professional Save/Publish scenarios

Project Professional

• Cost Resources calculation fixes
• Improved Custom Fields stability
• Improved local Project Cache stability
• Fixed Excel Import problem

Search Server 2008, Search Server 2008 Express (http://blogs.msdn.com/enterprisesearch/archive/2008/07/15/announcing-availability-of-infrastructure-updates.aspx)

• Federated Search Capability (Click here for a Video)
• Unified Administration Dashboard

Windows SharePoint Services 3.0, Microsoft Office SharePoint Seerver 2007 (http://blogs.msdn.com/sharepoint/archive/2008/07/15/announcing-availability-of-infrastructure-updates.aspx#comments)

• Federation Search Capabilities.
• Content Deployment improvements. (http://blogs.msdn.com/ecm/archive/2008/07/15/content-deployment-and-the-infrastructure-update.aspx)

Frequently Asked Questions

Q: Is Office Servers Service Pack 1 (SP1) a prerequisite or installed as part of this fix?
A: No. Our supportability commitments to customers include providing the ability to install hotfixes on the two most recent versions of a product, in this case RTM and SP1. So installing these updates directly onto an RTM server is not blocked and will install some of the fixes shipped in Office Servers Service Pack 1, but only those that are contained in files that are changed by the Infrastructure updates.

Q: Can I uninstall the server updates?
A: No. The Infrastructure Update for Microsoft Office Servers (KB951297) and the Infrastructure Update for Windows SharePoint Services 3.0 (KB951695) cannot be uninstalled. Both updates make database schema changes.

Q: Can I install the "Infrastructure Update for Microsoft Office Project 2007 (KB951547)" Project 2007 client update without installing the "Infrastructure Update for Microsoft Office Servers (KB951297)" on the server?
A: Yes, the "Infrastructure Update for Microsoft Office Project 2007 (KB951547)" includes fixes for both client/server communication and local client features, so if you don't have Office Project Server 2007 but use Office Project 2007 client this update can be safely installed and you will be able to take advantage of all the client updates.

Q: Where can I find information on Service Pack 1 for Project Server and Project Professional 2007?

A: Please check the following: http://blogs.msdn.com/chrisfie/archive/2007/12/12/announcing-the-release-of-epm-2007-service-pack-1.aspx

Q: What if I have an issue that isn't addressed by this update?
A: If your customer has a specific issue that these updates do not address you should follow the Microsoft Support process to log the issue and request a hotfix.

En cuanto a migraciones de SharePoint 2003 a 2007 se refiere, hay distintos caminos a seguir dependiendo de varias cosas, pero las tres opciones más conocidas son:

• In-Place Upgrade,
• Gradual Upgrade y
• Content Dababase Upgrade (cada una con sus ventajas y desventajas en cierto sentido).

Para saber más información de como elegir el camino a seguir, pueden consultar la siguiente dirección: Migration and Upgrade Information for SharePoint Server 2007.

Ahora, en caso de que requieran o vayan a usar nuevo hardware para contar con especificaciones técnicas mas recomendables para SharePoint 2007, e incluso si piensas migrar a SQL Server 2005, si tienen SQL 2000 en su instalación de SPS 2003, podrían evaluar al tercer approach.

Si utilizan el modo de migración de mover la(s) base(s) de contenido de SPS 2003 a 2007, podrían en algún momento requerir sacar un respaldo o backup de la base de datos recién migrada (restaurada) en SQL 2005, y cuando lo intenten posiblemente les aparezca el siguiente mensaje:

Msg 3007, Level 16, State 1, Line 1

The backup of the file or filegroup "sysft_ix_portal1_SITE" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

Msg 3013, Level 16, State 1, Line 1

BACKUP DATABASE is terminating abnormally.

Esto se debe a que en SQL 2000 está habilitado por default el Full Text Search, que no necesariamente esta habilitado para todas las bases de datos que se tengan en SQL Server 2005. Lo que se puede hacer es antes de intentar sacar un respaldo de la base de datos recién restaurada de la instalación de SPS 2003 (si tienen SQL 2000) a MOSS 2007 (ahora con 2005), es habilitar o hacer clic en el checkbox dentro de las propiedades de la base de datos que queremos respaldar considerando la capacidad de Full Text Search (como venía ya habilitado previamente en SQL 2000).

Si nuevamente intentamos hacer el respaldo ahora ya lo lograremos.