158 - Sauvegarder une vue de Project
web Access
Utilisation de l'utilitaire ViewBackupTool à télécharger sur le site Microsoft :
http://office.microsoft.com/en-ca/assistance/HA011642761033.aspx
La ligne de commande est :
ViewBackup.exe /B /N
ProjectServerViewsGD.xml /S pragmasvr /D ProjectSvr /U sa /P sa /T 4 /V
"Plan de Charge par Ressource par Projet"
/B : Backup
/N : le nom du fichier XML de sauvegarde : ProjectServerViewsGD.xml
/S : le nom du serveur qui exécute SQL Server
/D : le nom de la base de données SQL Server
/U : le nom de l'utilisateur
/P : le mot de passe
/T : le type d'affichage. 4 pour Analyseur de porte-documents (Portfolio Analyzer)
/V : le nom de l'affichage entre guillemets
View Backup and Restore Tool Command-Line
Parameters
The
following table lists the command-line parameters that you can use with
ViewBackup.exe.
Parameter |
Description |
/B |
Backup. |
/D |
The name of the Project Server database. |
/F |
Overwrite existing file. Using the /F parameter causes an existing
backup file to be overwritten. |
/I |
The ID of the view you want to back up. |
/N |
The name of the backup file. |
/O |
Overwrite (restore only). Optional. If the /O parameter is not
specified, views that already exist are skipped during the restore process. |
/P |
SQL Server password. Optional. Use with the /U parameter. If /U and /P
are not specified, NT Authentication is used. |
/R |
Restore. |
/S |
The name of the instance of SQL Server where the Project Server
database is located. |
/T |
View Type (backup only). Optional. Specifies the type of view to back
up: Project = 0 Project Center = 1 Assignment = 2 Resource Center = 3 Portfolio Analyzer = 4 Time Sheet = 5 When
using the /T parameter, you must also specify the /V parameter. |
/U |
SQL Server user name. Optional. Use with the /P parameter. If /U and
/P are not specified, NT Authentication is used. |
/V |
The name of the View you want to back up. Optional. When using the /V
parameter, you must also specify the /T parameter. The value must be placed
in quotes. For example, /V "Resource Summary" |
Un extrait du fichier
XML généré :
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<MSP_WEB_VIEW_REPORTS WVIEW_ID="112" WVIEW_NAME="Plan
de Charge par Ressource par Projet" WVIEW_DESCRIPTION="En
Prévisionnel et en Réel" WVIEW_TYPE="4"
WVIEW_DISPLAY_TYPE="5" WVIEW_WORK_TYPE="0"
WGANTT_SCHEME_ID="0" WTABLE_ID="0"
WVIEW_FILTER_PARAM1="" WVIEW_FILTER_PARAM2=""
WVIEW_FILTER_PARAM3="" WVIEW_REPORT_KIND="0"
WVIEW_OWC_PIVOT_XML="<xml
xmlns:x="urn:schemas-microsoft-com:office:excel">