Nintex Connect

Today I was finding some resources related with Nintex Workflow 2010. Remember that it's a powerfull and low cost platform wich enables SharePoint to create complex workflows.

Searching thought Google Bing, I've met Nintex Connect. It's a complete bank of information wich has a lot of documents, guides, whitepapers, etc. about Nintex technologies, not only Workflow.

I strongly recommend to visit it: http://connect.nintex.com/files/folders/tutorials_and_how_tos_nw2010/default.aspx

Enjoy It!!!

what's new on Framework 4.5?

Hi everyone, previous month Microsoft landed their 4.5 version of .NET Framework.

Its has some differences, for example:

• Support for new HTML5 form types.
  


• Support for model binders in Web Forms. These let you bind data controls directly to data-access methods, and automatically convert user input to and from .NET Framework data types.
  


• Support for unobtrusive JavaScript in client-side validation scripts.
  Improved handling of client script through bundling and minification for improved page performance.
  


• Integrated encoding routines from the AntiXSS library (previously an external library) to protect from cross-site scripting attacks.
  


• Support for WebSockets protocol.
  


• Support for reading and writing HTTP requests and responses asynchronously.
  


• Support for asynchronous modules and handlers.
  


• Support for content distribution network (CDN) fallback in the ScriptManager control.

What do you think? change to 4.5 version?

Excel Services and RBS Security on Project Server 2010

Hi Guys,

I've bad news about the security of visualize Excel Services Reports on Project Server 2010. Project Server offer out-of-the-box Report solucions based on Excel Services.
It sounds good and it's spectacular when you see it on demonstrations, but when you try to discover a little bit, you get a strange experience.

So, Excel Services throw querys to Report database retieving all projects/resources/fields... that you want to show a spectacular report with grafics and dynamic tables.
Even so, as you could think, the query and Excel Services don't apply the RBS Security... it's worse because it enables that a Project Manager can see all project of the whole company. :-S

We have noticed Microsoft about this point... i hope it will be solved quickly.

http://social.technet.microsoft.com/Forums/es-ES/exceles/thread/ed26d374-3223-482b-96da-70242bdceaad/

Integration Services - SSIS

I'm going to learn a little of SSIS to migrate an older SQL Server 200 Database to new SQL Express 2008. After research some webs and blogs, I think, in my first overview that it's an intuitive tool to manage the tasks on the our databases.

After install SQL Server 2005/2008 with the Analisys Services, Reporting Services and Integration Services packages, you can create some BI related projects on your Visual Studio. We create a SSIS project and we have a tour inside of the toolbox, features, and the best tool, the designer.

If you are in this step, I strongly recommend to follow a some basic guide, because SSIS seems a really good tools that it can help us.

Recommend site: http://msdn.microsoft.com/en-us/library/ms141026.aspx

Entity Framework

Hi everyone,

A few days ago, I saw for the first time the Entity Framework. It's a framework that allow to preserve the independece between business layer and the data base technology. In the other words, you can relate across the VS designer an entity of your business model with an operation (store procedure), table, field, of function on the database model.

"Every business application has, explicitly or implicitly, a conceptual data model that describes the various elements of the problem domain, as well as each element's structure, the relationships between each element, their constraints, and so on.
Since currently most applications are written on top of relational databases, sooner or later they'll have to deal with the data represented in a relational form. Even if there was a higher-level conceptual model used during the design, that model is typically not directly "executable", so it needs to be translated into a relational form and applied to a logical database schema and to the application code.
While the relational model has been extremely effective in the last few decades, it's a model that targets a level of abstraction that is often not appropriate for modeling most business applications created using modern development environments." of http://msdn.microsoft.com/en-us/library/aa697427(VS.80).aspx

I recommend to take an around of msdn to look some features that it provides.

MOSS 2010 - Sharepoint 2010

Ok, that's the moment to talk about new Sharepoint 2010. This platform provides a environment to share, publish and group a huge number of features.

The most improvements that the platform's offer are In the internet have a lot of rumours, but.. seems that the follow are true):

1. On the fly editing lists. No need to change to datasheet view.


2. With Sharepoint 2010 you can Insert and Retrive Information throw Business Data Catalog (BDC)


3. Doesn't support IE 6.0, because SharePoint 2010 will be “targeting standards based browsers (XHTML 1.0 compliant) including Internet Explorer 7, Internet Explorer 8 and Firefox 3.x. running on Windows Operating Systems".


4. Improves the UI features, ajax controls, etc.


5. Enables the communication to other CMS.



Thanks!

Hi all,

I've decided to write the blog in english and it's my first entry in english :)

Crear eventHandler en una DocLib y cambiar permisos al SPListItem

Creo que es muy interesante conocer cómo assignar permisos a un item cuando se añade a una lista, por ejemplo. Puede ser una práctica muy usual. Por ello, os pongo el código de como se realizaría:

public override void ItemUpdated(SPItemEventProperties properties)
{
string sGroupName = "Group Name";
spWeb = properties.OpenWeb();
spWeb.AllowUnsafeUpdates = true;
SPGroupCollection spGroupCollection = spWeb.SiteGroups;
SPRoleDefinition spRoleDefinition = spWeb.RoleDefinitions.GetByType(SPRoleType.Reader);
properties.ListItem.BreakRoleInheritance(true);


foreach (SPRoleAssignment spRoleAssignment in properties.ListItem.RoleAssignments)
{
//Add your conditions to remove/not remove the existing permissions
spRoleAssignment.RoleDefinitionBindings.RemoveAll();
spRoleAssignment.Update();
}

if (spGroupCollection != null)
{
SPRoleAssignment spRoleAssignment = new SPRoleAssignment((SPPrincipal)spGroupCollection[sGroupName]);
spRoleAssignment.RoleDefinitionBindings.Add(spRoleDefinition);
properties.ListItem.RoleAssignments.Add(spRoleAssignment);
}

this.DisableEventFiring();
UpdateUserGroups(spWeb, properties);
this.EnableEventFiring();
spWeb.AllowUnsafeUpdates = false;
spWeb.Dispose();
}

Actualizado el VHD descargable desde MSDN - MOSS

Recientemente Microsoft ha actualizado el VHD pre-configurado con una instalación completa de MOSS de cara a evaluarlo. Éste VHD ya estaba disponible aunque con una versión de evaluación válida sólo hasta finales de éste mes. Afortunadamente, desde Microsoft se han dado prisa y ya tenemos un nuevo VHD que estará operativo hasta enero de 2010. Tendremos que activar la licencia de W2003 y listo. Como en la versión previa, este VHD viene con una instalación de W2003 Server, VS2005, AD, MOSS y todo el paquete Office 2007.

Os lo podéis descargar desde aquí

Personalización de la CQWP - Sharepoint

Cuantas veces hemos querido que nuestra CQWP nos mostrara más campos que los que te muestra por defecto (Título y Descripción). Pues bien, con la guia que os facilito, os aseguro que es tarea fácil:

http://geeks.ms/blogs/ciin/archive/2007/05/22/personalizaci-243-n-de-la-content-query-web-part.aspx