When trying to mask Excel file with FDM we do not see the file as expected.

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are not able to perform Excel file masking in CA FDM (Fast Data Masker) tool. There is a separate folder for dm.txt file, however, it is showing that the file does not exist.
The FDM connection profile is using EXCEL FILE in DBMS option. The file name we are trying to mask is <filename>.csv

 

 

Environment

FDM 4.9.1+

Cause

Excel file format names must end with .xlsx

Resolution

A CSV file is not an Excel formatted file. This is why it is not showing up when you choose this option.

Though Excel can open a CSV and make changes to it, a CSV file is not a native Excel format.

To use FDM to mask this file you would need to open the CSV file in Excel and then do a save AS to save as an Excel workbook to then be able to use the Excel masking function in FDM.

To use FDM to mask a CSV file directly, change the DBMS type to "File" and map the fields in the GUI Interface, as shown below: