The list cannot be displayed in Datasheet view

Basically, the access ActiveX or stslist.dll is in incorrect version or incorrectly registered in the registry
(main culprit is usually a mix of office versions, so office repair can do the trick)
BUT
Simple solution if the target is 2007 : You can download the component in a separate install

2007 Office System Driver: Data Connectivity Components

Obtenir le GUID d'une liste avec son navigateur

simple, à partir de l'url : copier la partie list = et decoder l'url.

exemple : _layouts/ListGeneralSettings.aspx?

 List=%7BDE7B37FE%2DF43D%2D4DEB%2D9977%2DF5E8C6912F6E%7D

7B="{"
2D="-"
7D="}"

GUID = {DE7B37FE-F43D-4DEB-9977-F5E8C6912F6E}

Pleins de sites le font si vous avez la flemme : ex http://www.albionresearch.com/misc/urlencode.php, avec les deux fonctions JS ;)

copier coller des impression d'écran dans un navigateur / paste pictures in webmail

J'avais l'habitude d'utiliser chrome pour ca... je ne sais pourquoi, c'est cassé.
Seul firefox 4.0 à ce jour supporte encore ca, les devs de chrome ont du retirer la fonction.

Pasting screenshots into a webmail or blogger post used to work on chrome but last month it stopped working (they pulled the plug?) - Well, it still works in firefox 4.0

feature aka "inline bitmaps"

Liste des profils utilisateurs

existe toujours en 2010 :

http://xxx/_catalogs/users/simple.aspx

Erreur 26 en FBA - MOSS

Symptome : On crée un accès FBA, qui fonctionne, puis l'on décide d'implémenter des propriétés custom (profileprovider). Tout d'un coup, des error: 26 - Erreur lors de la localisation du serveur/de l'instance spécifiés apparaissent en recette.(ca marche toujours en dev)

Explication : si l'on crée la base SQL FBA avec
aspnet_regsql.exe -E -S ... -A mr -d ....

La table profils n'est pas initialisée... on aura beau mettre un connection string dans le profileprovider, .NET va remonter au machine.config et chercher une instance LOCALE sqlexpress (par défaut)

Résolution : Recréer la base FBA avec les bon paramètres,

aspnet_regsql.exe -E -S ... -A mrp -d ....


Un peu dodgy à trouver ce truc... :)
Evidamment sur le serveur de développement, il y avait un sqlexpress, pour brouiller les pistes...

User profile synchronization woes

l'autre demi dieu (pas joel) a un très bon post dessus : http://www.harbar.net/articles/sp2010ups.aspx

update : en RTM, cela ne marche pas, ou très mal. Personnellement, j'ai patché la ferme avec la CU de cette année et re provisionné le service. Faire preuve de patience également, c'est du style kerberos (attendre deux minutes entre chaque manip ;)

lancer le client FIM dans \Program Files\Microsoft Office Servers\14.0\Synchronization Service\UIShell pour voir si cela fonctionne ou pas.

Script PowerShell pour Monitoring et pré - chargement Sharepoint

Contexte :


On veut profiter d’un script de ‘warmup’ au démarrage du serveur pour
1) lister les sites crées sur le serveur et
2) tester leur accessibilité.

On va stocker le résultat dans une liste SharePoint dans la console d’admin.



Le script teste des sites SharePoint, mais pourrait tester d’autres choses, évidemment.

Sharepoint Diagnostic Studio

From sharepoint team blog :



Post :

http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=971

Download :

http://www.microsoft.com/downloads/en/confirmation.aspx?FamilyID=718447d8-0814-427a-81c3-c9c3d84c456e&displaylang=en

How to use calculated columns to assign a calendar Datetime span from a choice field

Say you have a production planning with guys working with 4 different schedules :
A. 7:30 to 16
B  9:30 to 17h30
... etc

With standard sharepoint, you have to create two dates (begining and end), select they day twice, and type the hours each time.

You want to only write a date and select the time span :

Resolution :
Create a choice (C_schedule), prefix each choice with "1", "2", "3", etc....
Create a date field (D_work_date, without time),
and two calculated columns of datetime result: DT_work_start, DT_work_end

You'll make sharepoint fill those columns with basically, the start date + the hour(s) of your working day.

The formulas will be

#START TIME
DT_work_start=D_work_date+IF(LEFT(C_Schedule)="1";"07:30:00";IF(LEFT(C_Schedule)="2";"07:30:00"; ..... )))

#END TIME
DT_work_end=D_work_date+IF(LEFT(C_Schedule)="1";"16:00:00";IF(LEFT(C_Schedule)="2";"17:30:00"; ..... )))


Et voila! :)

SP2010 user profile synchronization problems / Forefront Identity Manager (FIM)

Btw, official link : http://technet.microsoft.com/en-us/library/ee721049.aspx (this isn't trivial stuff)

What happens : behind the scenes, SP2010 uses FIM, which is deployed to the hive (\14). There is an integrated UI to debug issues there : \Program Files\Microsoft Office Servers\14.0\Synchronization Service\UIShell\Miisclient.exe

Invaluable to solve issues (the most common being your account not having AD replication rights)

[mmorpg] Rift tank theorycrafting

To my great surprise, stumbled across a post from ciderhelm, which i remembered as making great wow tanking videos. Seems he switched to rift, or at least took an interest in it :)

Felt like a wave of fresh air amidst a sea of garbage, as the current state of rift relating to theorycrafting is... hmmm. Experimental :)

Anyway, here's the link : http://ciderhelm.com/?p=426 , awesome, enjoy! :)

Warmup and monitoring PowerShell script for Sharepoint

Version francaise la


While i was working for a customer, i wanted to generate automatically a list of AAM to monitor. There's also the problem of warming up after a pool recycle (or issreset). So, why not use the warmup script and sharepoint itself  to generate automatic inventory and status of each website?



This was also a good PowerShell exercise to iterate a SharePoint collection, access a list and update it. It is surprisingly easy, since PowerShell is quite capable of importing the sharepoint assembly and use its object model. I guess it works exactly the same in .NET (i'm an admin, not a coder ;).

Simply create a list in central admin. We'll use title as the URL, nice unique key. You can integrate it to the UI by editing the homepage and simply add a webpart to the list (remember it's got its own view)

Ce que j'aime vraiment dans Sharepoint 2010 (french)

-       Multilingue en standard :

-       Il y a des prédécesseurs dans les taches (mini-project)

Solving 10016 events under 2008 R2

From as long as i can remember, if you use a specific farm account, sharepoint doesnt grant it local activation for the IISWAMREG component, thus making 10016 and 10017 warnings appear in the system log.

Under windows 200x, the resolution is quite simple (grant local activation rights to wss_wpg for the component, as per http://support.microsoft.com/kb/920783)

Under 2008 R2, the "edit" button is greyed.

That's because the ownership of the corresponding registry key is to "trusted_installer", not you (even as admin). Go to the key and take possession of it, and the edit button will be enabled.

The key used by the IIS WAMREG admin is:

HKEY_CLASSES_ROOT\AppID\{61738644-F196-11D0-9953-00C04FD919C1}

(Do not remove trusted installer rights)