ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 227274

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Hi Team,

We are not able to perform Excel file masking in CA FDM (Fast Data Masker) tool.
We have created a separate folder for dm.txt file, however, it is showing that the file does not exist.
We are using EXCEL FILE in DBMS option.

The file name we are trying to mask is Unmasked Circle K Census.csv

Could you please help us here to resolve the issue?

 

Cause

Excel file format names must end with .xlsx

Environment

FDM 4.9.1

Component : Fast Data Masker

Resolution

A CSV file is not an excel formated file and 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.

You can use FDM to mask a CSV file directly.
You would need to use the DBMS type of file and map the fields in the GUI Interface:

https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=HyAaraTUwv9WAu2cwjPDwg==