Report - Source - External ReadCSVFile - issues with date field

Hi All:

I'm having some issues with the report's external source ReadCSVFile, that I wonder if somebody can help me with.

The issue is related to the creation of the data source from the csv file, when one of the csv fields is a date field.

That is not working fro me at all.

I have to manually change the fomat on the csv field to text and use a text cast, to make it work.

I'm thinking that since we have a date cast type, we should be able to read data from date fields.then

Please find below the details on the configuration I'm using.

The csv file (HostFile.csv) has 5 fields, 4 text fields and one date field.

Example:

Powerserver

10.130.128.118

0

v1.02

8/20/2012

My Readcsv external source is configure as follow:

Cast String: Text,text,text,text,date

Field String: Client,IP,Wave,Ver,MDate

File name: C:\Program Files\EMC\DPA\webapps\root\reports\HostFile.csv

Key string: true,false,false,false,false

Separator: ,

I'm doing a joint with the "Backup Client Config" data source using "Client" as key field.

I'm expecting an output with data from the clients on the csv file that match with the ones on the "Backup Client config" data source.

As long as I have that field as date, it does not work.

Again, If I manually change the format on the csv to text and use a text cast, then it works.

Additional Info:

DPA 5.8.0 (5934)

Thanks,