You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "Jockxtar (via GitHub)" <gi...@apache.org> on 2025/02/25 07:55:07 UTC
[I] Error 505 when exporting pivoted .csv with custom CSV_EXPORT configuration [superset]
Jockxtar opened a new issue, #32371:
URL: https://github.com/apache/superset/issues/32371
### Bug description
I'm trying to make the "Export to pivoted .CSV" option work for a (relatively) convoluted pivot table and I found some issues. I will create a bug report for each of them.
### Description
Throws "Error 505" if configuration file has CSV_EXPORT = {"encoding": "utf-8", "sep": ";", "decimal": ","}.
Since this configuration doesn't work anyways for the normal csv export, I'm okey with just removing it for now, but a fix would be neat.
### Steps to reproduce:
1. Modify 'CSV_EXPORT' in 'config.py' to "CSV_EXPORT = {"encoding": "utf-8", "sep": ";", "decimal": ","}".
2. Save changes.
3. Restart Superset.
4. Create a "pivot table" graph.
5. Select a numeric metric
6. Click on 'Download' -> 'Export to pivoted .CSV'
### Screenshots/recordings
_No response_
### Superset version
4.1.1
### Python version
3.10
### Node version
I don't know
### Browser
Firefox
### Additional context
### Source code:
I'm using version 4.1.1, but I tried updating 'post_processing.py' to match what's in the master branch's 'client_processing.py' since I needed PR #29898 (which doesn't seem to affect this issue).
### Feature flags:
"DASHBOARD_RBAC": True,
"ENABLE_TEMPLATE_PROCESSING": True,
"CACHE_QUERY_BY_USER": True,
"CACHE_IMPERSONATION": True
### Checklist
- [ ] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [ ] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Error 505 when exporting pivoted .csv with custom CSV_EXPORT configuration [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #32371:
URL: https://github.com/apache/superset/issues/32371#issuecomment-2913434284
> Most of the replies of current issues are from this (not very helpful) bot
Feedback appreciated. You can also give the bot feedback by clicking the links below its comments. It's helped close a lot of issues, so others have found it helpfu, but we're always trying to get better about this stuff when human contributors are vastly outnumbered :)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Error 505 when exporting pivoted .csv with custom CSV_EXPORT configuration [superset]
Posted by "Jockxtar (via GitHub)" <gi...@apache.org>.
Jockxtar commented on issue #32371:
URL: https://github.com/apache/superset/issues/32371#issuecomment-2903586386
@MichaelF25 The same happens to me (in regular CSV exports)—while the cell separator works, the decimal separator does not. That’s what I meant by that sentence.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Error 505 when exporting pivoted .csv with custom CSV_EXPORT configuration [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #32371: Error 505 when exporting pivoted .csv with custom CSV_EXPORT configuration
URL: https://github.com/apache/superset/issues/32371
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Error 505 when exporting pivoted .csv with custom CSV_EXPORT configuration [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #32371:
URL: https://github.com/apache/superset/issues/32371#issuecomment-3948159756
Thanks for the additional confirmation @MichaelF25\! There's an open PR that fixes both the Error 505 on pivoted CSV export and the decimal separator not being respected: #38170 - should be merged soon.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Error 505 when exporting pivoted .csv with custom CSV_EXPORT configuration [superset]
Posted by "MichaelF25 (via GitHub)" <gi...@apache.org>.
MichaelF25 commented on issue #32371:
URL: https://github.com/apache/superset/issues/32371#issuecomment-2903519834
@Jockxtar What do you mean with
> Since this configuration doesn't work anyways for the normal csv export
I am asking since using the exactly same configuration for `CSV_EXPORT` and the setting for the cell separator `;` seems to work, but `decimal` columns are exported with `.` instead of `,`.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Error 505 when exporting pivoted .csv with custom CSV_EXPORT configuration [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #32371:
URL: https://github.com/apache/superset/issues/32371#issuecomment-2681015157
<!-- Answer -->
The "Error 505" you're encountering when exporting a pivoted CSV with the custom `CSV_EXPORT` configuration might be related to how Superset handles different encodings, separators, and decimal formats during CSV export. Unfortunately, specific details on how Superset manages these configurations or any error handling mechanisms for them are not available in the current knowledge base.
However, the issue might be due to the custom separator (`sep: ";"`) and decimal (`decimal: ","`) settings conflicting with the expected format during the export process. Since you mentioned that this configuration doesn't work for normal CSV export either, it might be worth testing with default settings or different combinations to identify the root cause.
Additionally, since you have already tried updating `post_processing.py` to match the master branch's `client_processing.py`, it seems that PR #29898 does not address this specific issue. You might want to check if there are any recent updates or patches related to CSV export in the Superset repository that could resolve this problem.
For now, reverting to default CSV export settings or experimenting with different configurations might help as a temporary workaround.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
---
<sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/665b8293-b84a-46f3-9ad0-4be1e9c410d0?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/665b8293-b84a-46f3-9ad0-4be1e9c410d0?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/665b8293-b84a-46f3-9ad0-4be1e9c410d0?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/665b8293-b84a-46f3-9ad0-4be1e9c410d0?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/665b8293-b84a-46f3-9ad0-4be1e9c410d0?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/665b8293-b84a-46f3-9ad0-4be1e9c410d0?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/665b8293-b84a-46f3-9ad0-4be1e9c410d0?feedback_type=other)</sup>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Error 505 when exporting pivoted .csv with custom CSV_EXPORT configuration [superset]
Posted by "MichaelF25 (via GitHub)" <gi...@apache.org>.
MichaelF25 commented on issue #32371:
URL: https://github.com/apache/superset/issues/32371#issuecomment-2903617069
> [@MichaelF25](https://github.com/MichaelF25) The same happens to me (in regular CSV exports)—while the cell separator works, the decimal separator does not. That’s what I meant by that sentence.
Thanks for your confirmation, so I don't have to dig deeper if I did something wrong with the configuration.
I am wondering if any human is reading the issues here. Most of the replies of current issues are from this (not very helpful) bot.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org