Comments (12)
Hey @TommyLeung-gj! I'm here to help you with the issue you're experiencing with Superset 4.0.1. I'm a bot that can assist you with bug fixes, answer your questions, and guide you on becoming a contributor. Let's dive into resolving the problem together!
To resolve the issue of Chinese characters and numbers being garbled when exporting query results to a CSV file in Superset 4.0.1, you need to ensure that the CSV file is encoded in UTF-8. The df_to_escaped_csv
function in the superset/utils/csv.py
file should be called with the appropriate encoding settings.
Here is the relevant part of the code with the necessary modification:
csv_data = df_to_escaped_csv(df, index=False, encoding='utf-8', **config["CSV_EXPORT"])
Ensure that the encoding='utf-8'
parameter is included in the call to df_to_escaped_csv
. This will help in correctly encoding Chinese characters and numbers in the exported CSV file [1][2].
To continue talking to Dosu, mention @dosu.
from superset.
The issue has been resolved by downgrading the package with the following command: pip install Werkzeug==2.3.8
.
from superset.
The issue has been resolved by downgrading the package with the following command:
pip install Werkzeug==2.3.8
.I down grade the Werkzeug as 2.3.8 but no luck. What's your encoding option?
My is followingCSV_EXPORT = {"encoding": "utf-8-sig"}
Yes, this encoding. But did you face the same problem with
VERSION 2.1.3
or3.1.3
? Also I got a Chinese characters not with the English.
It's worked after i reload the cerely service. Thanks a lot bro.
from superset.
Related issue linked above ^^^
Might even be considered a duplicate, really, but they seem kind of unique.
from superset.
No ,It still doesn't work after I changed encoding = "utf-8"
from superset.
maybe there is something wrong in the process of async query , the celery or redis resultbackend cache
from superset.
+1
from superset.
+2
Having the same issue with VERSION 4.0.1
even VERSION 2.1.3
WORKING FINE WITH THESE PARAMETER CONFIG.
from superset.
The issue has been resolved by downgrading the package with the following command:
pip install Werkzeug==2.3.8
.
I down grade the Werkzeug as 2.3.8 but no luck.
What's your encoding option?
My is following
CSV_EXPORT = {"encoding": "utf-8-sig"}
from superset.
The issue has been resolved by downgrading the package with the following command:
pip install Werkzeug==2.3.8
.I down grade the Werkzeug as 2.3.8 but no luck. What's your encoding option?
My is following
CSV_EXPORT = {"encoding": "utf-8-sig"}
Yes, this encoding. But did you face the same problem with VERSION 2.1.3
or 3.1.3
? Also I got a Chinese characters not with the English.
from superset.
++ @TommyLeung-gj, could you confirm if this downgrade solves your issue or not? Also, what language are you using?
++ @bionexit, we appreciate your feedback on the language characters you encountered, to report to the Werkzeug team.
from superset.
The issue has been resolved by downgrading the package with the following command:
pip install Werkzeug==2.3.8
.I down grade the Werkzeug as 2.3.8 but no luck. What's your encoding option?
My is followingCSV_EXPORT = {"encoding": "utf-8-sig"}
Yes, this encoding. But did you face the same problem with
VERSION 2.1.3
or3.1.3
? Also I got a Chinese characters not with the English.It's worked after i reload the cerely service. Thanks a lot bro.
I use docker. How to reload the cerely service. thanks.
from superset.
Related Issues (20)
- Creating thread in superset_config.py freezes app HOT 2
- No module named 's3cache' HOT 8
- "user_favorite_tag" table not created after "superset db upgrade" when upgrade superset 3.0.1 to 4.0.2 on docker HOT 11
- [SIP-143] Global Async Task Framework HOT 15
- Hash mismatch error during build part of docker installation HOT 3
- [4.0.2] SQL LAB int argument error since version 4 HOT 3
- Bug crossing lines in line/area chart HOT 2
- Slack HOT 4
- Duplicated entries in Alerts & Reports execution log HOT 1
- /api/v1/dashboard/{id_or_slug}/copy with "duplicate_slices" = true not working because The "json_metadata" take from /api/v1/dashboard/{id_or_slug} doesn't have "positions" HOT 4
- Bar Chart: Bar Chart Echart X Axis and Y Axis labels not showing HOT 3
- The default URL generated by Dashboard has security risks! HOT 22
- Advanced Period filter bug HOT 2
- Switching languages doesn't take effect on some menu elements if BABEL_DEFAULT_LOCALE is not "en" HOT 11
- ENABLE_JAVASCRIPT_CONTROLS use HOT 2
- [SIP-144] Proposal to Integrate VisActor Visualization Plugin into Superset HOT 2
- Dashboard Color Scheme keeps changing every refresh HOT 4
- Bug: fetchGuestToken function is not called after internet is disconnected and error is encountered during embedded report access HOT 3
- The in-memory storage for tracking rate limits HOT 14
- Filtered values not appearing/not working after selected from dropdown Post Migration to Latest SS Version HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from superset.