PowerShell Question: Export-ERReportDefinition...is there an Import cmdlet?

I can export a report definition successfully with the following PS command...

$rpt = Get-ERReport "My Reports\Account Operators"
Export-ERReportDefinition $rpt -Destination c:\

...and can import (the exported definition) via the Enterprise Reporter Report Manager | Report | My Reports -> Import

But is there are companion cmdlet or way to import the definition in PowerShell that maybe I have overlooked?

Use case is the customer has a lab and have made the report they want and export it to the production instance. Exporting is fine in PowerShell but it seems only the GUI allows for importing.

  • I have a customer I'm working with right now that would like to do the same. Does anyone have any suggestions?

    I only see the following available:

    Connect-ERReportingServer
    Export-ERReportDefinition
    Get-ERReport
    Get-ERReportSQL
    Initialize-Services
    Invoke-ERReport

  • Hi there,

    I looked into the PowerShell cmdlets for the report manager and specifically related to the import/export of report definitions and unfortunately we don't have any cmdlet to perform the import of report definitions. 

    I would suggest you to please contact the customer support and they would be able to log this enhancement request on your behalf and will provide you the case number for the future reference. Hope this will help.

    Please let me know if you have any further questions.

    Thanks,
    Aarti

  • Right. I know the PS cmdlets haven't been updated in quite a while unfortunately. I think they need a rehaul. :) It's one of the SR's I created a few days ago.

    On another note, if the report is published out to QKP, which in turn then used SSRS for its backend, it's possible to export the RDL (Report Definition Language) file [from SSRS]... Then, you can import then back into SSRS. While this still doesn't conquer the need to do with Enterprise Reporter, it might be helpful for any published reports.

    Here's a PS script to extract the RDL's of a branch to the local drive:

    ##############################################################################

    # Prerequisites

    # Install-Module -Name ReportingServicesTools

    ##############################################################################

    # Lets get security on all folders in a single instance

    ##############################################################################

    # Declare SSRS URI

    $sourceRsUri = 'http://sql1/ReportServer'

    # Declare Proxy so we dont need to connect with every command

    $proxy = New-RsWebServiceProxy -ReportServerUri $sourceRsUri

    # Output ALL Catalog items to file system

    Out-RsFolderContent -Proxy $proxy -RsFolder / -Destination ‘C:\TEMP\SSRS_Out’ -Recurse