Export Report

Command

Export-Report

Syntax

Export-Report

-CopyResult <CopyResult> [-Path <String>]

[-DefaultColumns <SwitchParameter>] [-NoItems <SwitchParameter>]

[-NoItemVersions <SwitchParameter>] [-Overwrite <SwitchParameter>]

Export-Report

-SessionId <String[]> [-Path <String>]

[-DefaultColumns <SwitchParameter>] [-NoItems <SwitchParameter>]

[-NoItemVersions <SwitchParameter>] [-Overwrite <SwitchParameter>]

Description

The command to export one or many migration reports.

Examples

Export Copy Result with All Columns

$srcSite = Connect-Site -Url http://myfarm1/sites/mysourcesite
$dstSite = Connect-Site -Url http://myfarm1/sites/mydestinationsite
$srcList = Get-List -Name mysrclist -Site $srcSite
$dstList = Get-List -Name mydstlist -Site $dstSite
$result = Copy-Content -SourceList $srcList -DestinationList $dstList
Export-Report $result -Path C:\MyReports\CopyContentReports.xlsx

Export Copy Result with Default Columns

$srcSite = Connect-Site -Url http://myfarm1/sites/mysourcesite
$dstSite = Connect-Site -Url http://myfarm1/sites/mydestinationsite
$result = Copy-List -All -SourceSite $srcSite -DestinationSite $dstSite
Export-Report $result -Path C:\MyReports\CopyContentReports.xlsx -DefaultColumns

Export Copy Result with session ID as file name

$srcSite = Connect-Site -Url http://myfarm1/sites/mysourcesite
$dstSite = Connect-Site -Url http://myfarm1/sites/mydestinationsite
$srcList = Get-List -Name mysrclist -Site $srcSite
$dstList = Get-List -Name mydstlist -Site $dstSite
$result = Copy-Content -SourceList $srcList -DestinationList $dstList
Export-Report $result -Path C:\MyReports\

Export Session Id in Excel format (.xlsx)

Export-Report -SessionId 140221-1 -Path C:\MyReports\CopyContentReports.xlsx

Export Session Id CSV (.csv)

Export-Report -SessionId 140221-1 -Path C:\MyReports\CopyContentReports.csv

 

Parameters

-CopyResult <CopyResult>

Specifies the copy result.

Required?	True
Position?	0
Default value
Accept pipeline input?	true (ByValue, ByPropertyName)
Accept wildcard characters?	False
Parameter set name	Default
Aliases	None

-DefaultColumns <SwitchParameter>

Specifies that only default columns will be exported.

Required?	False
Position?	2
Default value
Accept pipeline input?	false
Accept wildcard characters?	False
Parameter set name	(All)
Aliases	None

-NoItems <SwitchParameter>

Specifies that items will not be exported.

Required?	False
Position?	3
Default value
Accept pipeline input?	false
Accept wildcard characters?	False
Parameter set name	(All)
Aliases	None

-NoItemVersions <SwitchParameter>

Specifies that item versions will not be exported.

Required?	False
Position?	4
Default value
Accept pipeline input?	false
Accept wildcard characters?	False
Parameter set name	(All)
Aliases	None

-Overwrite <SwitchParameter>

Specifies that file will be overwritten if already exist.

Required?	False
Position?	5
Default value
Accept pipeline input?	false
Accept wildcard characters?	False
Parameter set name	(All)
Aliases	None

-Path <String>

Specifies the path where you want to save the file. Supported formats are Excel and CSV.

Required?	False
Position?	1
Default value
Accept pipeline input?	false
Accept wildcard characters?	False
Parameter set name	(All)
Aliases	PSPath

-SessionId <String[]>

Specifies the session identifiers. (The format of the session id is yymmdd-#. Where "yy" represents the year, "mm" the month, "dd" the day and "#" the migration number for this day, starting at 1 each day. You can split multiple sessions with commas. They will be combined inside the same report.)

Required?	True
Position?	0
Default value
Accept pipeline input?	false
Accept wildcard characters?	False
Parameter set name	SessionId
Aliases	None

Inputs

CopyResult

Outputs

String

The export result.