Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Entity List template CSV gets opened and saved by Excel as not UTF-8 #721

Open
lognaturel opened this issue Sep 25, 2024 · 0 comments
Open
Assignees
Labels
frontend Requires a change to the UI needs testing Needs manual testing

Comments

@lognaturel
Copy link
Member

Steps to reproduce the problem

  1. Download an Entity List template CSV
  2. Double click to open in Excel
  3. Populate a cell with non-ASCII characters (e.g. Hélène)
  4. Save from Excel
  5. Upload the Entity List CSV

Screenshot

Screenshot 2024-09-25 at 12 15 04 PM

Expected behavior

Excel opens and saves the file as UTF-8

Central version shown in version.txt

versions:
67bd0ad3def294a89fc17a8be8e1001a37303f80 (v2024.1.0-15-g67bd0ad)
+3372015d4fe4ba34598ab5e4552c1ec1e11ee205 client (v2024.1.0-41-g3372015d)
 3ae8a69011f3839b60ecc9fdda770faa408d16d4 server (v2024.1.0-35-g3ae8a690)

Other notes (if any)

This is related to #752. I think that in this case we can add the BOM because this template exists just to make it easier to input data. We generally don't expect the template to be ingested into data pipelines or edited by scripts.

@github-project-automation github-project-automation bot moved this to 🕒 backlog in ODK Central Oct 1, 2024
@matthew-white matthew-white added needs testing Needs manual testing and removed needs testing Needs manual testing labels Oct 1, 2024
@matthew-white matthew-white self-assigned this Oct 7, 2024
@matthew-white matthew-white added frontend Requires a change to the UI needs testing Needs manual testing labels Nov 9, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
frontend Requires a change to the UI needs testing Needs manual testing
Projects
Status: 🕒 backlog
Development

No branches or pull requests

2 participants