How to add script to exploit excel report - DPA

Hi Sariaka,

Yes DPA does provide the option for you to apply a post-processing script to the generated scheduled report. The steps would be:

- write your post-processing script to format the data as you require

- in the DPA UI select Tools, Scheduled Report Editor, open the scheduled report in question and then enter the location and name of the post-processing script into the post-processing script field in the Advanced tab

Alternatively DPA provides other output options other than csv which may be better suited to your users (i.e. html)

Thanks

David

David Russell

EMC

Hi David,

Thank you very much.

I would like to convert the ";" to table

I'm not very strong to write scripts. Have you an example of script for me please?

In effect, users want backup of the report, they need csv format :-(

Thank you

Sariaka

Hi Sariaka,

Unfortunately we don't have any examples of scripts.

Thanks

David

David Russell

EMC

Hi David,

I found a script to delimite csv file to table.

In order to insert the script into the report :

I have to write the path at the "Pre-Processing Script" or "Post-Processing Script" ?

Thank you.

Regards,
Sariaka

Hi Sariaka,

You would need to insert it into the post-processing script field.

Thanks

David

David Russell

EMC

For the test, I specify this path in advanced :

C:\Program Files\EMC\DPA\webapps\root\reports\convert_tableau.vbs

with default template

in basic Publication method :

     Report Format : Comma Separated Values (csv)

     Publish via : File

     File name : Sauvegarde Avamar Agents

Thanks

regards,
Sariaka

Hi Sariaka,

What you have configured appears to be correct. At this stage I would recommend raising a support case via EMC Powerlink. The DPA support team can then investigate to make sure the product is correctly trying to run the script. When you raise the case please attach a copy of the publisher.log from the DPA server as this should contain any error messages when trying to run the script.

Thanks

David

David Russell
EMC

I think DPA don't considere my script. It's a vbs script like that :

    Const xlDelimited = 1

    Const xlNormal = -4143

    Dim CurrentPath        : CurrentPath = LCase (Replace (WScript.ScriptFullName, WScript.ScriptName, "")) 'Current path

    Dim Excel

    Dim myDateString

    myDateString = Replace (Date(), "/", ".")

    Set Excel = CreateObject("Excel.Application")

    With Excel

        .Workbooks.Open CurrentPath & "\Sauvegarde Avamar Agents.csv"

        .Sheets(1).Columns("A").TextToColumns .Range("A1"), xlDelimited, , , , True  'semicolon-delimited

       .ActiveWorkbook.SaveAs .ActiveWorkbook.Path & "\Sauv_Avamar_DD_sites-" & myDateString & ".csv", xlNormal

        .Quit

    End With

I specify the path as you tell me, but nothing change  :

Thanks a lot

Sariaka

OK thank you very much David.

Regards,
Sariaka

Hi,

I suppose the script needs to be *.bat

Perhaps You need to move all things around to a different directory, like:

C:\Scripts\

Then in DPA post-processing provide:
C:\Scripts\MyScript.bat

That will contain a call to the VBS one.

Additional tip:

For the reports that are written as files (so not send via e-mail), the first parameter that is passed to the called post-processing script is path of the report.

Good luck!