Getting translation to French?

[gob33]

Exact. I want each country manage its zones in an interval of 1000 positions, in order to keep zones grouped in one ordered sequence and not having addendums/corrections at end in full disorder.

Zones are subject to change for each country, reserved intervals of 1000 in zone_id permit not shifting the rest of the table. This can be done easily with an update SQL script and a trigger on table insertion.

You must understand your actual french zones are absolutely incorrect and make the product unusable for us. I dont know if the same for other countries but i fear. Thats why i propose to reserve 1000 sequential zone_ids per country in table "zone" to the disposition of each translator.

[eCommerce Core]

Thank you for the tip gob33.

Like you said zones can be corrected and inserted into tables with SQL.
I assume you refer to ac_zones and zone_id.

It will be big work to refactor this data and retest. Any help is appreciated.

[gob33]

I have posted my soluce in Git. Its all SQL and had been tested ok for me on 1.1.9.

[abantecart]

Great. I wonder how it can be integrated into french language.

[gob33]

It is for all language. At language install, clear all zones relative to the country, then insert good ones in the reserved intervall. Other zones dont move/shift.

[gob33]

Currently, I have a problem with banner_manager and form_manager extensions, all texts on page stay in English, despite i have uploaded their translated xml language file. These english texts come from the DB and are recorded with the language_id corresponding to "french" !
I dont understand at all.
So, I have some questions:

1) Does language xml files need to be translated for the standart extensions inside AbanteCart (banner_manager, ...)

2) If i add a new language (by uploading xml files) on an AbanteCart running with some of these extensions enabled, does the translation appear automaticaly inside these extensions ?

3) Is there a simple way to know if abante_demo has been installed, in order to also insert demo translations into tables ?

[gob33]

I reply to myself:
XML translations for extensions should be inside your own language extension like:

french_language_extension\code\extensions\french_language\admin\language\french\banner_manager\banner_manager.xml

to be found and loaded in DB by isExtensionLanguageFile().
This makes the directories tree of your language extension rather bizarre.

In fact, I suspect there is something wrong in that case (loading translation of abantecart extensions) between _load_from_xml(), _detect_language_xml_file() and isExtensionLanguageFile().