Report Builder & CSV Export Glitch

AdrianWright · July 23, 2023, 6:03pm

The CSV export feature in Report Builder is including HTML in the generated CSV files. This unexpected behavior was first observed in early April 2023 (approximately). Expected behavior is no HTML in the generated CSV file.

The screen capture below shows an example of a problematic CSV files with some of the unexpected HTML outlined in red.

The CSV export functionality is located at -

https://reportspd.scouting.org/advancements/webscript/output/sbreports.aspx?Method=ExecuteScriptSet&ScriptSetCode=SBReportBuilderOutput&ScriptCode=PrintCSV&ReportID=

Problem occurs with existing and new reports in Report Builder.

Best Regards
Adrian

Unexpected Format

Expected Format

DonovanMcNeil · July 23, 2023, 7:47pm

Do you have the award images turned on?

AdrianWright · July 23, 2023, 8:51pm

How do I determine this?

DonovanMcNeil · July 23, 2023, 8:53pm

Screen Shot 2023-07-23 at 3.52.24 PM

AdrianWright · July 23, 2023, 8:57pm

Award images are off.

DonovanMcNeil · July 23, 2023, 8:57pm

I did get it to fail this way finally - let me see

AdrianWright · July 23, 2023, 8:59pm

Appreciate it.

DonovanMcNeil · July 24, 2023, 3:05pm

@AdrianWright this should be fixed now - might need a Shift plus refresh

AdrianWright · July 24, 2023, 5:51pm

@DonovanMcNeil I see an improvement: the HTML is no longer in the reports

Below the highlighted values of “AwardedAwarded” are unexpected. Expected value is “Awarded”.

Unexpected Value

DonovanMcNeil · July 24, 2023, 5:54pm

post the url of the report cvs

AdrianWright · July 24, 2023, 5:58pm

https://reportspd.scouting.org/advancements/webscript/output/sbreports.aspx?Method=ExecuteScriptSet&ScriptSetCode=SBReportBuilderOutput&ScriptCode=PrintCSV&ReportID=745061&IsPivotTableEnabled=0