Report Builder & CSV Export Glitch

Scoutbook Scoutbook Bugs
,
1

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 :frowning_face:

image
image974Ă—700 60.3 KB

Expected Format :smiley:

image
image879Ă—700 48.6 KB

2

Do you have the award images turned on?

3

How do I determine this?

4

Screen Shot 2023-07-23 at 3.52.24 PM

5

Award images are off.

image

6

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

7

:+1:

Appreciate it.

8

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

9

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

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

Unexpected Value

image
image1125Ă—700 62.7 KB

10

post the url of the report cvs

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

it should show awarded cause the item has been awarded - not why it is doing awardedawarded

13

@DonovanMcNeil Can you arrange for a developer to investigate?

14

What are all the setting in the report - I cannot get it to do this

15

image
image1007Ă—1932 72.1 KB

16

@AdrianWright nope - what is the Ref at the bottom of the report - like this - ref: PD-20230725194507-746110-361758

17

@DonovanMcNeil Good news. I regenerated the report (to get the ref #) and now the report has the expected content :grinning:

Thanks for your help with this.

1 Like
18

might have been cached before

19

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.