List Manager Forum

Translation in Multivaluelists - Multivalues from a sperate table

User galbur 2017-03-02 09:52:13

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 2017-03-02 18:53:46

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 2017-03-09 16:15:34

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 2017-03-09 17:10:51

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 2017-03-10 16:02:58

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 2017-03-11 17:20:08

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 2017-03-12 17:45:43

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 2017-03-13 16:07:15

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 2017-03-14 17:04:27

Ok

Thank you. I will try this.

Chris

...
CalcBuilder

Create dynamic calculators

Buy now!
...
Support/development 40 hours

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

Buy now!