Description:

When exporting datasets in the GDPR tool we try to format all columns that are exported.
This is done by checking for matching dimensions. In some cases this causes problems, as the dimensions actually don't have a format method that can format the raw column value (as they define a sql segment that should be applied).

This currently happens e.g. when exporting a dataset that contains some media actions, as the Hour dimension is used for server_time column.

This PR drops using dimensions for formatting if they define a special sql segment.
In addition it catches possible exceptions thrown while formatting and using the unformatted raw value instead. Possible exceptions will be logged so we still might notice possible problems.

Review

• Functional review done
• Potential edge cases thought about (behavior of the code with strange input, with strange internal state or possible interactions with other Matomo subsystems)
• Usability review done (is anything maybe unclear or think about anything that would cause people to reach out to support)
• Security review done
• Wording review done
• Code review done
• Tests were added if useful/possible
• Reviewed for breaking changes
• Developer changelog updated if needed
• Documentation added if needed
• Existing documentation updated if needed