Archive for August, 2007

Major Update to the MOSS and WSS Downloadable SDKs

August 29, 2007

I am very proud to announce a major update to the MOSS and WSS Software Development Kit (SDK) downloads.  You can install them from the following locations:

MOSS 2007 SDK 1.2.  Includes Conceptual and Class Library Reference documentation, Web Services documentation, and Developer Tools and Samples for MOSS and WSS.  See below for a detailed breakdown what’s new in this release.

http://www.microsoft.com/downloads/details.aspx?FamilyId=6D94E307-67D9-41AC-B2D6-0074D6286FA9&displaylang=en

WSS 3.0 SDK 1.2.  Includes Conceptual and Class Library Reference documentation, Web Services documentation, and Developer Tools and Samples for WSS technology only.  See below for a detailed breakdown what’s new in this release.

http://www.microsoft.com/downloads/details.aspx?familyid=05E0DD12-8394-402B-8936-A07FE8AFAFFD&displaylang=en

NSE Tools MOSS 2007 Third-Party Backup Tools

August 23, 2007

Another company that focuses on SharePoint backups is NSE (http://www.nse.com) with their product SPManager. It is also a complete backup solution for SharePoint 2003 environments. During 2007, NSE will release an upgraded version of SPManager that works with SharePoint 2007, both WSS and MOSS. It has been around for several years now and is easy to use for both backup and restore tasks. The main features of SPManager are these:

  • Restores single documents.
  • Restores single list items.
  • Restores Web Parts.
  • Restores single sites.
  • Restores complete SharePoint environments.

All these restore operations can be performed against the original SharePoint server or on another SharePoint server. This tool can also be used as a migration tool or when you need to create a test environment of your production server.

AvePoint Tools MOSS 2007 Third-Party Backup Tools

August 23, 2007

One of the first vendors that developed backup solutions specifically for SharePoint was AvePoint (http://www.avepoint.com). They were also first with a backup solution for SharePoint 2007 and with migration tools for moving content from SharePoint 2003 servers to SharePoint 2007. Their main product, DocAve, is today one of the most popular tools due to its very advanced restore options, and it is often recommended by Microsoft as the solution for organizations that require a way to recover single documents, including the complete version history. Note that DocAve by itself is not a substitute for a complete SharePoint backup. Its objective is to offer the administrator the capability to restore the following objects to their original location or to another SharePoint farm:

  • Restore a single document, including all its previous versions and web discussions.
  • Restore a specific version of a document instead of all versions.
  • Restore a single list item.
  • Restore a single list or library.
  • Restore a single site.
  • Restore a single personal site.
  • Restore a single portal area.

The current version of DocAve is not backing up the complete SharePoint structure, so you will still need to use a tool like SharePoint Central Administration backups, a SQL backup tool, or DocAve’s own SharePoint Disaster Recovery tool. However, since DocAve will protect all data, it will most likely be enough to run tools like MOSSBACKUP once per week or even once per month, depending on how often you change the structure of your SharePoint environment. The SharePoint Disaster Recovery tool will replicate the complete SharePoint environment to another server. If a total disaster happens, you simply rebuild the basic structure on the old server, and press the Recover button and all data will be replicated back to that server again.

There is also a very handy complement to DocAve called TrashBin, which allows a user to undelete any document, list item, or list directly from within the site, without any assistance from the administrator. TrashBin will use the backups made by DocAve, which gives the user the same type of restore options as the administrator (i.e., all the options listed above). Compare that to other “undelete” tools, which cannot restore documents deleted from the file system or by using the Explorer View. This is no problem for TrashBin.

Save as Template Size Limitation (Workaround)

August 21, 2007

So today I was working with a client and they mentioned that they were trying to save a site template and move it to another server while retaining the content but the size of the site prohibited this. By default there is a 10MB size limitation built in. Something clicked in my head because I recently found a fix that will increase the size limitation to whatever value you want to make it.

Type the following using the STSADM utility

stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 50000000

I think its pretty self explanatory with what you can do here… if you have a site that is in excess of 50MB you will use 75000000 or whatever number you come up with.

Where do you want to connect today?

August 19, 2007

Se avete bisogno di connetterVi a fonti di dati eterogenee come:

Database servers (SQL Server, Sybase, Firebird, SQL Server 2005, Informix, AS/400 iSeries, SQL Server 2005 Compact Edition, Ingres, Pervasive, Oracle, Mimer SQL, SQLBase, MySQL, Lightbase, Progress, Interbase, Postgre SQL, Caché, IBM DB2, Paradox) 

Data files (Excel 2007, Access 2007, DBF/FoxPro, Excel, Access, SQLite, Textfile, Visual FoxPro, Filemaker)

Others (MS Project, Lotus Notes, Index Server, Active Directory, DSN, Exchange, UDL)

e non Vi ricordate la stringa di connessione con i suoi relativi parametri Vi può essere di aiuto sapere che attraverso questo link potete trovare tutto quanto Vi necessita.

Progetti Open Source su CodePlex

August 18, 2007

Su CodePlex è presente una intera sezione dedicata ai progetti Open Source per le SharePoint Technologies. Di quelli che ritengo più interessanti vi riporto quì sotto il collegamento alla pagina del relativo progetto su CodePlex.

Collezione di links utili per MOSS 2007

August 18, 2007

Architecture, Installation, and Migration

Development

Content Management and Customization

Search

Records Management

Excel Services

Work Flow

Knowledge Network

Add-On’s

MS Office SharePoint 2007: retrieve a specific document version programmatically

August 17, 2007

Se avete la necessità di recuperare una determinata versione di un file via OM l’oggetto SPFileVersion di MOSS 2007  ci viene notevolmente in aiuto. Prima dell’esempio però è utile ricordare come la gestione delle versioni dei files in SharePoint sia prettamente logica e non fisica.

Se abbiamo un file dal nome “GetDocumentVersionByID.txt” e l’uplodiamo in MOSS 2007 questo sarà raggiungibile dal seguente URL http://server/Docs/Documents/GetDocumentVersionByID.txt mentre se volessimo visualizzare le versioni successive dello stesso file, qualora ce ne fossero, il path relativo sarebbe il seguente: _vti_history/n/Documents/GetDocumentVersionByID.txt dove (n) sta per il numero di versione, quindi se volessimo visualizzare la versione n=2 del documento “GetDocumentVersionByID.txt” il path assoluto sarebbe del tipo:

http://server/Docs/_vti_history/2/Documents/GetDocumentVersionByID.txt

In realtà le versioni sono gestite attraverso l’utilizzo di tabelle referenziate all’interno del DB di MOSS 2007 e quindi ciò che visualizziamo all’interno del browser in realtà è il risultato di una query al DB e non l’URL fisico di un documento. Questo “problema” ce lo portaimo dietro anche quando cerchiamo di accedere via OM all’oggetto SPFile di MOSS 2007, in particolare alle sue versioni. Ad un primo approccio può venire di istinto recuperare il secondo URL e passarlo al’oggetto SPFile per poi recuperarne le proprietà o lo stesso stream di byte ma è una idea errata, ci ritornerebbe il classico messaggio di errore:

The system cannot find the file specified. (Exception from HRESULT: 0x80070002)”

Di seguito vi giro due esempi chiarificatori, il primo è errato e genera il precedente errore, il secondo mostra il modo corretto per recuperare la versione del file che ci interessa e tutte le sue proprietà:

Esempio 1: Esempio errato

Function GetDocumentByVersionID (ByVal fileURL As String, ByVal versionID As Long, _
                                  ByRef content() As Byte) As Integer

Dim objWeb As SPWeb = Nothing
Dim objSite As SPSite = Nothing
Dim objFile As SPFile

Try
objSite = New SPSite(fileURL)
objWeb = objSite.OpenWeb
If Not (objWeb Is Nothing) Then
objFile = objWeb.GetFile(fileURL)
If objFile.Exists Then
  Dim fileVersion As SPFileVersion
  fileVersion = objFile.Versions.GetVersionFromID(versionID)
  objFile = objWeb.GetFile(objWeb.Url & “/” & fileVersion.Url)
  content = objFile.OpenBinary
  Return 1
Else
  Return 0
End If
End If

Catch ex As Exception
‘Gestione eccezioni.

Finally
If Not objWeb Is Nothing Then objWeb.Dispose() : objWeb = Nothing
If Not objSite Is Nothing Then objSite.Dispose() : objSite = Nothing

End Function

Esempio 2: Esempio corretto

Function GetDocumentByVersionID (ByVal fileURL As String, ByVal versionID As Long, _
                                  ByRef content() As Byte) As Integer

Dim objWeb As SPWeb = Nothing
Dim objSite As SPSite = Nothing
Dim objFile As SPFile

Try
objSite = New SPSite(fileURL)
objWeb = objSite.OpenWeb
If Not (objWeb Is Nothing) Then
objFile = objWeb.GetFile(fileURL)
If objFile.Exists Then
For Each version As SPFileVersion In objFile.Versions
    If versionID = version.ID Then
        content = version.OpenBinary()
        Return 1
    Else
        content = Nothing
    End If
Next 
Else
  Return 0
End If
End If

Catch ex As Exception
‘Gestione eccezioni.

Finally
If Not objWeb Is Nothing Then objWeb.Dispose() : objWeb = Nothing
If Not objSite Is Nothing Then objSite.Dispose() : objSite = Nothing

End Function

Il comando STSADM applicato a Project Server 2007

August 16, 2007

Il tool di amministrazione da riga di comando di SharePoint, l’ormai mitico STSADM.EXE, in un ambiente con presente Project Server 2007 si estende di alcune ulteriori funzionalità.

Questa è la sintassi:
stsadm -o projenumprojects –url <URL name>

Projcatgroupbackup
Projenumsecuritytemplates
Projmodifyusergroupcategorypermissionsbytemplate

Projcatgrouprestore
Projenumusers
Projmodifyusergroupglobalpermissions

Projcreatecategory
Projerpbackup
Projmodifyusergroupincategory

Projcreateentity
Projerprestore
Projmodifyuseringroup

Projcreategroup
Projguidfromcategoryname
Projmodifyviewsincategory

Projcreatepwainstance
Projguidfromentitydisplayname
Projonlinebackup

Projcustfieldsbackup
Projguidfromentityemail
Projonlinerestore

Projcustfieldsrestore
Projguidfromentitylogonname
Projreadbackupschedule

Projdeactivateentity
Projguidfromgroupname
Projsyssettingsbackup

Projdeletecategory
Projguidfrompermissionname
Projsyssettingsrestore

Projdeletegroup
Projguidfromprojectname
Projupdatebackupschedule

Projdeletepwainstance
Projguidfromsecuritytemplatename
Projupdateentity

Projeglobalbackup
Projguidfromviewname
Projupdatepwainstance

Projeglobalrestore
Projmodifyentitysettings
Projviewcategorydetails

Projenumcategories
Projmodifyprojectsettingsincategory
Projviewentitydetails

Projenumgroups
Projmodifyprojectsincategory
Projviewgroupdetails

Projenumpermissions
Projmodifyresourcesettingsincategory
Projviewpwainstance

Projenumprojects
Projmodifyresourcesincategory
Projviewsbackup

Projenumpwainstances
Projmodifyusergroupcategorypermissions
Projviewsrestore

Per maggiori dettagli.

Implementare un workflow con MS Office SharePoint Server 2007

August 16, 2007

Come implementare un workflow con MS Office SharePoint Server 2007, è un argomento molto interessante di seguito riporto i links a 7 lezioni: