Archive for April, 2008

Download di portable Virtual PC

April 29, 2008

Riprendo un post dal blog di Emanuele Mattei. Molto interessanti sono gli applicativi che non bisogna installare, quelli che copiati su una chiavetta o in un Hard Disk esterno, possono funzionare senza problemi. Oggi vi segnalo un interessante sito, dove si può scaricare gratuitamente una macchina virtuale.

In particolare la possibilità di utilizzare Virtual Pc, senza installarlo, per esempio, se utilizzate più pc e non volete installare virtual pc, oppure non potete installare Virtual pc o ancora, avete un collega che deve provare un determinato programma e non può installare Virtual Pc, gli passate il vostro hard disk esterno con virtual pc portable ed una macchina virtuale, potrà testare il suo programma..  

Davvero un ottimo strumento, da portare con se nella propria chiavetta (8GB o 16GB) o nel proprio hard disk esterno (consigliato).

Di seguito riporti i siti per scaricare tale software.
http://portable.lococobra.com/ (Download Virtual Pc Portable)

http://portable.lococobra.com/VPCReadme.html (istruzione per configurarlo e crearlo)

http://www.portablefreeware.com/forums/viewtopic.php?t=2297&postdays=0&postorder=asc&start=0 (Forum con vari suggerimenti)

http://softwareportables.blogspot.com/2007/08/portable-microsoft-virtual-pc-2007.html (Virtual Pc Portable e vari download di applicativi Portable)

Advertisements

MS Office SharePoint Server 2007 e WSS 3.0 con SP1

April 28, 2008

Sono finalmente disponibili i nuovi pacchetti per l’installazione di SharePoint con bit comprensivi del Service Pack 1.

Non sarà quindi più necessario prepararsi un’installazione “slipstream”.

MOSS 2007 with SP1 a 32 bits
http://www.microsoft.com/downloads/details.aspx?FamilyId=2E6E5A9C-EBF6-4F7F-8467-F4DE6BD6B831&displaylang=en

MOSS 2007 with SP1 a 64 bits
http://www.microsoft.com/downloads/details.aspx?FamilyId=3015FDE4-85F6-4CBC-812D-55701FBFB563&displaylang=en
WSS 3.0

WSS 3.0 with SP1 a 32 bits
http://www.microsoft.com/downloads/info.aspx?na=47&p=2&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=3015fde4-85f6-4cbc-812d-55701fbfb563&u=details.aspx%3ffamilyid%3dEF93E453-75F1-45DF-8C6F-4565E8549C2A%26displaylang%3den

WSS 3.0 with SP1 a 64 bits
http://www.microsoft.com/downloads/info.aspx?na=47&p=1&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=3015fde4-85f6-4cbc-812d-55701fbfb563&u=details.aspx%3ffamilyid%3d9FB41E51-CB03-4B47-B89A-396786492CBA%26displaylang%3den

Note per il deployment in ambiente Windows Server 2008:
http://technet.microsoft.com/en-us/office/sharepointserver/bb735844.aspx

Dalla SharePoint Conference, i materiali delle sessioni sui BDC

April 27, 2008

Dalle sessioni sui BDC (Business Data Catalogs) tenute da Todd Baginski, uno dei pionieri dei tool per configurare i BDC su MOSS 2007. Ecco qui i materiali utilizzati nel corso delle sue sessioni.

Make Selected Links in a Links List Open in a New Window

April 26, 2008

“How can I make some of my links in a Links List open in a new window?” I usually explain how I would accomplish this using JavaScript. I’ve answered this question so often now that I guess it’s time to post the solution here on the blog.

When you add a link to your SharePoint navigation, or in a Summary Link Web Part, it gives you the option to, “Open link in new window.” However, the standard Links list, doesn’t give you this option. Many users seem to want it though.

The first part of my solution involves training your end-users to add something extra onto links that they want to open in a new window. I like to have them add. “#openinnewwindow”. There is a two-fold reason for this. One, it’s fairly easy for most users to remember once they’ve used it a couple times. Two, if the JavaScript code isn’t in place, it doesn’t cause any errors when a user clicks on the link–it will just open in the same window as normal (unless there is a named anchor on the target page named “openinnewwindow”, which is highly unlikely.

The second part of my solution is the JavaScript code that makes this work. Here is the code. It can be placed into the source of a Content Editor web part, or even added to your master page.

Note: In the code example below, replace the square brackets around the SCRIPT tags with angle brackets. If I included the angle brackets, the browser tried to execute the code.

[script language=”JavaScript”]
//add an entry to the _spBodyOnLoadFunctionNames array
//so that our function will run on the pageLoad event
_spBodyOnLoadFunctionNames.push(“rewriteLinks”);
function rewriteLinks() {
     //create an array to store all the anchor elements in
the page
     var anchors = document.getElementsByTagName(“a”);
     //loop through the array
     for (var x=0; x<anchors.length; x++) {
     //does this anchor element contain #openinnewwindow?
          if (anchors[x].outerHTML.indexOf(‘#openinnewwindow’)>0)
{
//store the HTML for this anchor element
oldText = anchors[x].outerHTML;
//rewrite the URL to remove our test text and add a target instead
newText = oldText.replace(/#openinnewwindow/,'” target=”_blank’);
//write the HTML back to the browser
anchors[x].outerHTML = newText;
          }
     }
}
[/script]

That’s all you need to do make this work!

Migrazione di un server MOSS 2007 a seguito del cambio di dominio

April 25, 2008

Un cliente (grande azienda multinazionale) al quale avevo fatto consulenza per un progetto su MS Office SharePoint 2007 Server nel giro di pochi mesi ha deciso di scorporare alcuni suoi branch office e pertanto saranno rifatti vari domini e di conseguenza i domain controller.

Come è possibile (se possibile) spostare una server farm (solo front end) di MS Office SharePoint 2007 Server Enterprise Edition  mentre il back end è su un altro server con MS SQL Server 2005 Standard Edition, cambiando contemporaneamente anche il Dominio (AD Domain/Forest).

Una prima procedura che si potrebbe seguire è questa:

1) Se i domini che vengono creati fanno parte della stessa foresta, i problemi sono molto ridotti.
2) Se invece i domini fanno parte di foreste diverse, allora prima bisogna portare il functional level di entrambe le foreste a 2003 nativo e quindi stabilire una root forest trust tra le due foreste
3) Va installato ADMT (Active Directory Migration Tool) sul dominio da cui vengono migrati server, pc e utenti
4) Migrare prima gli utenti, quindi gli account di servizio e poi i servers.
5) A questo punto ti troverai con i server (Sharepoint e SQL) sul dominio nuovo ma con gli utenti ancora sul vecchio. La cosa non creera’ problemi di alcun tipo, tutti continueranno a lavorare tranquillamente grazie all’attributo SidHistory presente nel loro utente migrato.
6) Puoi quindi procedere alla migrazione graduale di PC e utenti.

Di seguito il link da dove scaricare Active Directory Migration Tool v3.0.

Ricerca nelle viste anche degli Accounts inattivi

April 24, 2008

Utilizzando MS Dynamics CRM 3.0 nelle viste degli accounts inattivi non è possibile fare nessuna ricerca, se avete bisogno di ricercare anche clienti cessati, potrebbe esservi utile questo link:

http://blogs.infinite-x.net/2006/09/07/using-filtered-views-with-crm-30/

qui si trova la soluzione per modificare la query di ricerca e visualizzare anche gli inattivi:

http://blogs.delta-n.nl/crm/Lists/Posts/Post.aspx?ID=6

Il metodo è “non supportato” ma funziona.

Ways to Backup/Restore MS Office SharePoint 2007

April 23, 2008

I did want to share some of the ways to perform backups for the different versions of SharePoint.

Collaborative SharePoint Versions

  • Windows SharePoint Services v2 (WSS v2)
    • Stsadm –o backup –filename [file path & name] –url [http://WSSv2Server] [-overwrite]
      • backups the SharePoint site collection to a known location
    • Stsadm –o restore –filename [file path & name] –url [http://WSSv2Server]
      • restores the SharePoint site collection to a known IIS web application
    • SQL Server 2000 backup/restore of SharePoint content and configuration databases
    • Vendor: Veritas Backup Exec Agent for SQL Server
  • Windows SharePoint Services v3 (WSS v3)
    • Recycle-bin site restore
    • Recycle-bin List/Library restore
    • Recycle-bin List/Document Library item restore
    • stsadm –o backup –filename [file path & name] –url [http://WSSv3Server] [-overwrite]
      • The above backups the SharePoint site collection to a known location
    • stsadm -o backup -directory “[UNC Path]” -backupmethod full -item “farm”
      • The above backups the SharePoint farm to a known UNC path
    • stsadm -o backup -directory “[UNC Path]” -backupmethod full -item “Windows SharePoint Services Web Application”
      • The above backups all SharePoint web applications to a known UNC path
    • stsadm –o restore –filename [file path & name] –url [http://WSSv3Server]
      • The above restores the SharePoint site collection to a known IIS web application
    • stsadm -o restore -directory “[UNC Path]” -restoremethod overwrite -item “farm”
      • The above restores the SharePoint farm
    • stsadm -o restore -directory “[UNC Path]” -restoremethod overwrite -item “farm\Windows SharePoint Services Web Application”
      • The above restores all the SharePoint web applications that is in the farm only
    • SQL Server 2000 backup/restore of SharePoint content and configuration databases
    • Vendor: Veritas Backup Exec Agent for SQL Server

Enterprise SharePoint Versions

  • SharePoint Portal Server 2003 (SPS 2003)
    • stsadm –o backup –filename [file path & name] –url [http://SPS2K3Server] [-overwrite]
      • backups the SharePoint site collection to a known location
    • stsadm –o restore –filename [file path & name] –url [http://SPS2K3Server]
      • restores the SharePoint site collection to a known IIS web application
    • SharePoint Portal Server Data Backup and Restore windows application
    • SQL Server 2000 backup/restore of SharePoint content and configuration databases
    • Vendor: Veritas Backup Exec Agent for SQL Server
    • Vendor: Veritas Backup Exec Agent for SharePoint Portal Server 2003
    • Vendor: AvePoint DocAve 3.0 Backup/Restore application
      • Provides item level backup and restore to a global SharePoint deployment
  • Microsoft Office SharePoint Server 2007 (MOSS 2007)
    • Recycle-bin site restore
    • Recycle-bin List/Library restore
    • Recycle-bin List/Document Library item restore
    • stsadm –o backup –filename [file path & name] –url [http://MOSS2K7Server] [-overwrite]
      • backups the SharePoint site collection to a known location
    • stsadm -o backup -directory “[UNC Path]” -backupmethod full -item “Windows SharePoint Services Web Application”
      • The above backups all SharePoint web applications to a known UNC path
    • stsadm -o backup -directory “[UNC Path]” -backupmethod full -item “SharedServicesProvider”
      • The above backups the Shared Service Provider to a known UNC path
    • stsadm –o restore –filename [file path & name] –url [http://MOSS2K7Server]
      • restores the SharePoint site collection to a known IIS web application
    • stsadm -o restore -directory “[UNC Path]” -restoremethod overwrite -item “farm”
      • The above restores the SharePoint farm
    • stsadm -o restore -directory “[UNC Path]” -restoremethod overwrite -item “farm\Windows SharePoint Services Web Application”
      • The above restores all the SharePoint web applications that is in the farm only
    • stsadm -o restore -directory “[UNC Path]” -restoremethod overwrite -item “SharedServicesProvider”
      • The above restores the SharePoint Service Provider database and index files
    • SQL Server 2000 backup/restore of SharePoint content and configuration databases
    • Vendor: Veritas Backup Exec Agent for SQL Server
    • Vendor: Veritas Backup Exec Agent for SharePoint Portal Server 2003
    • Vendor: AvePoint DocAve 4.0 Backup/Restore application
      • Provides item level backup and restore to a global SharePoint deployment

FYI, to find the stsadm utility in your instance of SharePoint, you must access the SharePoint web server and navigate to “[Hard_Drive]:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Bin”. The executable contains a number of useful operations other than backup/restore for SharePoint. I recommend that the IT administrator get to know some of the other possible operations that can make administrating SharePoint easier. For simply backups, I like to create batch file scripts that contain something like the following: “stsadm –o backup –url [http://MySharePointSite] –filename [\\MyBackupServer\BackupShare\[Mon|Tue|Wed|Thu|Fri]]”. This allows me to ensure that every day of the week there is a backup to disk that I can restore. In addition, best practice tells me to ensure that you have a backup system that always backs up the files to tape. This would allow for restores that is past one week.

There are advantages and disadvantages to each backup method above.

Disaster Recovery SharePoint Server 2007 and Catastrophic Backup and Restore Options with stsadm.exe

April 22, 2008

Backup/Restore a Site Collection using stsadm.exe:

In the 12 Hive ( C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN )

stsadm -o backup -url http://portal.contoso.msft/sites/site2backup -filename c:\site2.bak

To restore, simply replace backup with restore

This will create a full fidelity backup of the site that can be restored to the same farm or different farm, if required.  Remember that if you restore to a different AD Domain, all list items will lose permissions and the site collection users list will be empty. Best practice is to always backup/restore in the same AD Domain/Forest.

Using stsadm.exe for Catastrophic ( Farm Level Backup / Restore )

From the 12 Hive: stsadm -o backup -directory file://backupservernetbiosname/backupsharename -backupmethod full

optionally, you can append the following for an item level restore (no, not List Item level, only Web Application item level):

 stsadm -o backup -directory file://backupservernetbiosname/backupsharename -backupmethod full -item “Farm\Windows SharePoint Services Web Application\WebAppName“

Remember (1) the UNC share must have the following permissions enabled:

• The account authenticated to Central Administration when using the UI
• The logged on account when manually running stsadm.exe
• The Run As account when scheduling scripted backups in Control Panel
• The Central Administration pool account in Internet Information Services
• SQL Server account, if Local System is the SQL service account
• The SPTimer service account, if using the Central Administration UI (This is, by default, the same account used by the Central Administration App Pool)

 (2) You can’t use the differential option until you have run at least one Full backup after a new installation or after creating a new web application.

You can replace the backup option with restore .  You will need to specify the type of restore, either New or Overwrite. The New option will allow you to create a parallel database with a different name and can even be on another DB server.  The Overwrite option will completely overwrite your data, so be careful with this option. When restoring, you can also choose a different DB server and use the -restoreconfigurationdatabase  option.  This is very dangerous on a production farm and should only be considered when restoring the entire farm or restoring to a failover farm.

I also promised an IIS Backup script

 This will backup the IIS Metabase in the target host’s %systemroot%\system32\inetsrv\MetaBack directory. You can create as many lines as needed in a .bat file and schedule it in control panel. Remember to  give the RunAs account appropriate permissions.

cscript.exe %systemroot%\system32\iisback.vbs /s servername /u accountname  /p password /backup /b WeeklyBackup /v NEXT_VERSION /e backuppassword

Why backup with a password? It will allow you to restore the metabase to any server, not just the one you backed up!

MS Office SharePoint Server 2007 Disaster Recovery

April 21, 2008

Qualche suggerimento su il disaster recovery per MS Office SharePoint 2007.

Eseguire il Backup della Site collection
stsadm -o backup -url http://serversharepoint/sites/sitodasalvare -filename c:\sitodasalvare.bak

[Il comando stsadm lo eseguite la command prompt e lo trovate solitamente in C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN].

Questo backup puà essere ripristinato (basta sostituire il comando “backup” con “restore”) nella medesima Fram o in una differente Farm. Se si cambia Dominio (AD Domain/Forest) si perderanno le impostazioni di autorizzazione.

Eseguire il Backup per il Disaster Recovery
Eseguire il comando per effettuare il backup globale:
stsadm -o backup -directory \\nomeservernetbios\nomeshare -backupmethod full

ed in aggiunta eseguire anche un backup “Web application level” con il comando:
stsadm -o backup -directory \\nomeservernetbios\nomeshare -backupmethod full -item “Farm\Windows SharePoint Services Web Application\WebAppName”

[Le permissions del percorso UNC devono essere tali da garantire l’accesso agli accounts che accedono alla Central Administration, che eseguono il comando STSADM, che impersonano gli Application Pools utilizzati dal sito SharePoint su IIS, che operano su SQL Server e che eseguono il servizio SPTimer.]

Per eseguire il ripristino, anche in questo caso, sostituire al comando “backup” il comando “restore”.

Preformatted document libraries for Windows SharePoint Services 3.0 and SharePoint Server 2007

April 20, 2008

Add preformatted document libraries to your Microsoft Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007 site. Each library is configured with a Microsoft Office Word 2007 template that generates a new document and binds data in the library with data in the body of each document.

When you install this download, you can add preformatted document libraries to your Microsoft Windows SharePoint Services or Microsoft Office SharePoint Server site.

This download contains templates for the following document libraries:

  • Invoices
  • Specifications
  • Press releases
  • Customer site visit reports
  • Meeting notes

Each library is configured with a Microsoft Office Word 2007 template that generates a new document in the library when the user clicks New on the library page. Each Word template includes a mechanism for binding data in the library with data in the body of each document.

For example, in the Invoice library, the “amount due” property in the library is populated with the “amount due” data in each of the invoices. You can set up views of the library to see reports of the data that is stored in the documents — in this example, the total amount due for all payable invoices.

Each document library is an .stp file, which you install on a computer that is running Microsoft Windows SharePoint Services or Microsoft Office SharePoint Server.

Each document library includes instructions for installing its .stp file and for customizing the library and its accompanying Word template. The instructions are in Word 2007 documents.