Skip to main content
List Manager logo
List Manager Forum

Translation in Multivaluelists - Multivalues from a sperate table

User galbur

Hi

Where exactly (and how) can i change the translation of multivalues?

And: Is there a way to use Name/Value form a seperate table?

thank you
Chris

Edited by galbur - 02.03.2017 09:53

Moonsoft support

Hi,

You can use traslation adding values to joomla translation file you want. I.e. if you have a multivalue like 1=>NAMETOVIEW, you can add NAMETOVIEW to translation files.

About the use of Name/Value from a separate table, you can do it using SQL query inside multivalue.

Hope this helps. Regards,

User galbur

Hi

Thank you very much!
SQL Query: How to do that?
Let's say i have a table "xyz_nationality", with two fields "title" and "value"?

Thank you...
Chris

Moonsoft support

Hi,

In this case you could try with this sql:

SELECT value, title FROM #__nationality

where we suppose xzy is joomla prefix.

Hope this helps. Regards,

User galbur

Ok

Thats seems to work. I have connection to this specific Tabel now.
But: When i try to edit the entry, i don't see any list to choose values.

What can i do?

Thank you
Chris

Moonsoft support

Hi,

Please ensure this field is enabled to edit at 'Configure Access Control' and is added in 'Form Layout'. If you continue couldn't see the select to choose values, you can place a private ticker in helpdesk with url and credentials to access and we'll take a look.

Regards,

User galbur

Ok

Thank you for helping. So now i can see the values in the DB Edit Mode. But now there is a new Problem:
After editing something in the DB and changing something in the new multivalue option (wtih the SQL Action) i got this error:

Unknown column 'AMTSHILFE' in 'where clause' SQL=select value from #__listmanager_field_multivalue where idobj=6 and id=AMTSHILFE

When i use the same list with a csv-action it works fine.

Thank you
Chris

Moonsoft support

Hi,

The main problem is that you've change the type from text, for example, to multivalue option and didn`t delete the previous data. If you change the type to multivalue, old data doesn't match the new multivalue internal code, so this is the error you could see. Delete or change the old data using backend data administrator and you'll get no error.

Regards,

User galbur

Ok

Thank you. I will try this.

Chris

...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!
...
Support/development

Perfect for small code changes or to correct any bug at your site

Buy now!