Question

Photo of James Gray

0

Excel export displays number instead of value shown in report.

1

I have a report that I am exporting from Excel. For several fields I am getting a number instead of the actual value shown in the report. For instance one of the fields is a person that is set by selecting the person. Instead of the person's name I get something like 3bed4716-f7de-4217-b334-4c1d7da11697. I also get a "|" character appeneded onto values set from a list of values. For instance instead of "red" I get "red|". What is the fix for these problems?

  • Photo of David Stevens

    0

    There might be an open bug report filed for that already, you might want to check here: https://github.com/SparkDevNetwork/Rock/issues

    That 32 character value is known as a GUID and it's used for common (defined) values throughout Rock.  Sometimes the field translation isn't set just right for the Excel output.