pipina commented on issue #36682: URL: https://github.com/apache/superset/issues/36682#issuecomment-3665680196
Its strange but i can confirm that superset and celry workers have loaded the CSV_EXPORT variable properly superset: 2025-12-17T15:38:07.044598450+01:00 Patched: /app/superset/charts/client_processing.py 2025-12-17T15:38:07.163046120+01:00 [2025-12-17 15:38:07 +0100] [3231] [INFO] Starting gunicorn 23.0.0 2025-12-17T15:38:07.163191366+01:00 [2025-12-17 15:38:07 +0100] [3231] [INFO] Listening at: http://0.0.0.0:8088 (3231) 2025-12-17T15:38:07.163220773+01:00 [2025-12-17 15:38:07 +0100] [3231] [INFO] Using worker: gthread 2025-12-17T15:38:07.165432024+01:00 [2025-12-17 15:38:07 +0100] [3232] [INFO] Booting worker with pid: 3232 2025-12-17T15:38:11.626840295+01:00 CSV_EXPORT: {'encoding': 'cp1250', 'sep': ';', 'decimal': ','} Worker: CSV_EXPORT: {'encoding': 'cp1250', 'sep': ';', 'decimal': ','} When the csv is downloaded or emailed its in utf-8. I verified on linux: file 20251217_153829.csv 20251217_153829.csv: Unicode text, UTF-8 text, with very long lines (386) ab On Wed, 2025-12-17 at 06:12 -0800, dosubot[bot] wrote: > dosubot[bot] > left a comment (apache/superset#36682) [1] > The CSV_EXPORT encoding setting should control the encoding for both > GUI downloads and email attachments, but if your CSVs are still UTF- > 8, it's likely a config loading issue. Superset loads its config once > per process at startup, so you need to make sure your custom > superset_config.py (or the config file with CSV_EXPORT = {"encoding": > "cp1250", ...}) is available to every process—including all web and > Celery worker containers—and that you restart all of them after > making changes. If any process (especially a worker) starts with the > default config, it will use UTF-8 regardless of your > override reference [2]. > To debug, add a print or log statement in your superset_config.py > (e.g., print("CSV_EXPORT:", CSV_EXPORT)) and check that it appears in > both web and worker logs after a full restart. Also, verify the > actual encoding of the exported CSVs using a tool like file (Linux), > Notepad++ (Windows), or Python's chardet. If the encoding is correct > in the file but Excel still shows garbled characters, it's an Excel > import issue—use Excel's "Data > From Text/CSV" wizard and manually > select cp1250 reference [3]. > If you confirm the config is loaded everywhere and the encoding is > still wrong, let me know and we can dig deeper into the export code > path. > To reply, just mention @dosu [4]. > > How did I do? Good [5] | Irrelevant [6] | Incorrect [7] | Verbose [8] > | Hallucination [9] | Report 🐛 [10] | Other [11] > > — > Reply to this email directly, view it on GitHub [1], or unsubscribe > [12]. > You are receiving this because you were mentioned.Message ID: > ***@***.***> [1] (apache/superset#36682) https://github.com/apache/superset/issues/36682#issuecomment-3665544761 [2] reference https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/app.py#L41-L71 [3] reference https://github.com/apache/superset/issues/36374#issuecomment-3601122640 [4] @dosu https://go.dosu.dev/dosubot [5] Good https://app.dosu.dev/response-feedback/f47f4160-2c8d-478e-9638-cb86133ac703?feedback_type=great_response [6] Irrelevant https://app.dosu.dev/response-feedback/f47f4160-2c8d-478e-9638-cb86133ac703?feedback_type=irrelevant_answer [7] Incorrect https://app.dosu.dev/response-feedback/f47f4160-2c8d-478e-9638-cb86133ac703?feedback_type=incorrect_sources [8] Verbose https://app.dosu.dev/response-feedback/f47f4160-2c8d-478e-9638-cb86133ac703?feedback_type=too_verbose [9] Hallucination https://app.dosu.dev/response-feedback/f47f4160-2c8d-478e-9638-cb86133ac703?feedback_type=hallucination [10] Report 🐛 https://app.dosu.dev/response-feedback/f47f4160-2c8d-478e-9638-cb86133ac703?feedback_type=bug_report [11] Other https://app.dosu.dev/response-feedback/f47f4160-2c8d-478e-9638-cb86133ac703?feedback_type=other [12] unsubscribe https://github.com/notifications/unsubscribe-auth/ABQWXGRRV4HTVP2NEQYIRFT4CFQD3AVCNFSM6AAAAACPHTCBIKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTMNRVGU2DINZWGE -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
