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.

Sign up for GitHub

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

Jump to bottom

Make it possible to import Excel and CSV files with multiple languages in the producers platform #5989

Closed
stephanegigandet opened this issue Oct 15, 2021 · 0 comments · Fixed by #5990
Closed

Make it possible to import Excel and CSV files with multiple languages in the producers platform #5989

stephanegigandet opened this issue Oct 15, 2021 · 0 comments · Fixed by #5990
Assignees
@stephanegigandet
Labels
✨ Feature Features or enhancements to Open Food Facts server 🏭 Producers Platform https://wiki.openfoodfacts.org/Platform_for_producers

Comments

@stephanegigandet
Copy link
Contributor

Is your feature request related to a problem? Please describe.

Some producers send us Excel files with multiple languages for some fields. e.g. ingredients in English, Italian, French etc.

Currently the tool to import Excel files works only for a single language.

Describe the solution you'd like

Add a language dropdown for language specific fields, so that fields in different languages can be imported through the same file.

Try to recognize languages of the fields from the column names if possibles. (e.g. "ingredients list (fr)" should be doable).

Describe alternatives you've considered

No response

Additional context

No response

Number of products impacted

No response

Time per product

No response
@stephanegigandet stephanegigandet added ✨ Feature Features or enhancements to Open Food Facts server 🏭 Producers Platform https://wiki.openfoodfacts.org/Platform_for_producers labels Oct 15, 2021
@stephanegigandet stephanegigandet self-assigned this Oct 15, 2021
stephanegigandet added a commit that referenced this issue Oct 15, 2021
@stephanegigandet
support multiple languages in import files on producers platform #5989
eebb941
@stephanegigandet stephanegigandet mentioned this issue Oct 15, 2021
Merged
stephanegigandet added a commit that referenced this issue Oct 21, 2021
@stephanegigandet @alexgarel
support multiple languages in import files on producers platform (#5990)
40eb397 
* support multiple languages in import files on producers platform #5989

* Update cgi/import_file_select_format.pl

Co-authored-by: Alex Garel <[email protected]>

* refactor generation of the list of languages select options

* remove unused code, generate the regexp for language specific fields

* small fix + comments from Alex

* suggestions from Alex

* use the right template data ref

Co-authored-by: Alex Garel <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@stephanegigandet stephanegigandet

Labels
✨ Feature Features or enhancements to Open Food Facts server 🏭 Producers Platform https://wiki.openfoodfacts.org/Platform_for_producers
Projects
🏭 Producers Platform
Status: Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

support multiple languages in import files on producers platform openfoodfacts/openfoodfacts-server
1 participant
@stephanegigandet