Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
3 Vastaukset
11550 Näkymät
Avatar
Josean Soroa

We actually activate unaccent for each database.

For that we use postgresql-contrib and CREATE EXTENSION \"unaccent\" for each database.

It works fine, but we want to avoid remembering and checking this task.


My question.

I can't find any information about how to get unaccent activated by default when we create new databases.

Anyone knows how to do it?

Thanks.

Avatar
Hylkää
Avatar
Israr
Paras vastaus

I finally found the solution.

I had to execute this sql request: DELETE FROM pg_proc WHERE proname='unaccent';
Because it seems like Odoo still detects the database as in unaccent mode.

Avatar
Hylkää
Avatar
Josean Soroa
Tekijä Paras vastaus

Thanks Fred.

We use option unaccent = True in config file.

But also for each database you have to run this command

psql <database> -c "CREATE EXTENSION \"unaccent\"";

What I asked for was a way to avoid running this command for each created database. And it looks there is no way without editing odoo code.

I could be great if we could include this code in postgresql and get it running for each database creation.

Any ideas?

Avatar
Hylkää
Avatar
Fred Cruypenninck
Paras vastaus

Start the server with the option --unaccent

/path/to/openerp-server.py --unaccent

Or add the option

unaccent = True

in the OpenERP configuration file... 

answer found here \https://www.odoo.com/fr_FR/forum/aide-1/question/how-to-search-without-accented-characters-1229

Avatar
Hylkää