Multilevelselect import

Looks like after first load it did not created indexes back. It delete indexes before load because it might take too long.

Tyr run this query. change #__ to your DB prefix.

ALTER TABLE `#__js_res_field_multilevelselect`

    ADD KEY  `idx_field` (`field_id`),

    ADD KEY  `idx_lr` (`lft`,`rgt`),

    ADD KEY  `idx_parent` (`parent_id`);

Thanks, problem fixed.

BTW loading txt files appends to existing values?

Sergey the multilevel is again with the problem of the UTF-8

When i try to import the value:

Maranhão

Espírito

It only appears "Maranh" and "Esp"

Check if you text is saved as UTF 8.

Thanks... although it was used notepad i had to change the file in notepadd++

Please attach your file.

yes... i can see that, but can you import again to that table? using for example a multilevelselect from another type? that's the question

Yes why not. That was not first multilevelselect field I imported. There was already come data of other types.

strange... well.. at least there's a fix and multilevel will be imported and remain as it is so don't bother if you can't replicate the problem. thanks anyway