Reformat Data

[YFT_CBSD]

Hello Everyone,

In the reformat data tool, can we set a default output dictionary and prompt only for the input data file? Also, is there a way to save the dictionary differences to an Excel file or retrieve the contents of the dictionary differences? Thank you.

My main goal is to retrieve or save the dictionary differences using CSPro. Thanks

[Gregory Martin]

Reformat Data can be run using a PFF: https://www.csprousers.org/help/CSReFmt ... rmats.html

While the tool itself cannot by modified to only prompt for the input data file, you can write a batch application to do this and then run the PFF from that application. For example, you would run Reformat Data to create a template PFF, and then in logic you would do something like this:

Pff refmt_pff;
refmt_pff.load("Reformat-Template.pff");

string input = CS.Path.selectFile(title := "Select a Data File", filter := "*.csdb");

if input = "" then
    stop(0);
endif;

refmt_pff.setProperty("InputData", input);

refmt_pff.exec();

As of CSPro 8.0, the differences are only available via the text listing report.