Enr2010

updated

15 years ago

E

Enr2010

25 Posts

0

2225

September 2nd, 2011 09:00

Create Report using external data source (ReadCSVfile)

Hi,

I'm trying to create a Backup Client Config report using a .CSV file as external data source.

Basically I'm trying to read from the CSV file the list of clients that the user needs the report for.

I've done the following:

1) Save the ClientName.csv file with the name of the clients on drive C:\ under the Temp folder .

2) This file has only one column with the name of 3 clients (just for the test).

3) Created the report using the default Backup Client Config Report as source.

4) Added the External/ReadCSVFile source to the report

5) Set the READCSVFile source as follow:

Cast String: Text

Field String: ClientName

Filename: C:\Temp\ClientName.csv

Key String: true

Separator: ,

6) Adding a Merge operator to merge both sources

7) Added a condition where Client field (from Backup server mapping Source) must be equal to ClientName (from ReadCSVFile source)

When I run the report I keep getting error message:

C:\Temp\ClientName.txt (The system cannot find the path specified)

I wonder if I'm missing something here.

Any help would be much appreciated

Thanks,

  • 874

    0

    Posted September 5th, 2011 01:00

    Hi,

    The way you would want to do this would be:

    1) Save the ClientName.csv file with the name of the clients in a location which can be accessed from any PC. Often customers will use the reports sub-directory on the DPA server (e.g. \webapps\root\reports) as this is accessible via the built in DPA web-server.

    2) This file has only one column with the name of 3 clients (just for the test).

    3) Created the report using the default Backup Client Config Report as source.

    4) Added the External/ReadCSVFile source to the report

    5) Set the READCSVFile source as follow:

    Cast String: Text

    Field String: Client

    Filename: C:\Program Files\EMC\DPA\webapps\root\reports\ClientName.csv

    Key String: True

    Separator: ,

    Please note I have changed the Field String name so that it matches the name of the client field in the Backup Client Config data source.

    6) Add a Join operator to join both sources and only return those clients which are in the csv file.

    Thanks

    David

    David Russell

    EMC Technical Support

  • Enr2010

    25 Posts

    874

    0

    Posted September 6th, 2011 08:00

    Hi David:

    I just got back to work this morning and tried creating the report following your instructions and it did work perfectly.

    Thank you very much.