search

chaddro / EasyPopulate-4.0

Data import and export module for Zencart 1.3.x and 1.5.x
GNU General Public License v2.0
24 stars 31 forks source link

multi-lingual category import #5

Closed chaddro closed 12 years ago

chaddro commented 12 years ago

When importing to a store with multiple languages installed, EP4 is not creating the additional entries to TABLE_CATEGORIES_DESCRIPTION.

chaddro commented 12 years ago

As of 4.0.16 import code will create and copy placeholders for each installed language from the default language. Still need to work on getting this done correctly at import.

CategoriesMeta can be used to update all languages, but the should not be altered between export and import of updates since this section of the script works off the categories id, not name or tree structure.

chaddro commented 12 years ago

As of 4.0.17, milt-lingual category import is working with 1 caveat: The script is using your lowest defined language at a pivot/check for the other language columns. This means that if you have 3 category entries (or depth) in v_categories_names_1, that the subsequent v_categories_names_2, etc. must have the same number of entries or depth.

Also, you need not define all entries for your additional languages because the script will use the lowest defined language to create entries effectively duplicating them.

The script has some additional error checking to on categories_name's length so you don't attempt to import a string longer than is supported by the database.

It occurs to me now that perhaps it would be better to use the "default" language as the main pivot category, but that will have to be a future patch and need more testing, and could also affect other code.