Questions about the xxxxx_associations table. Uses, and where it happens?

[reynaldo celaya III]

Just curious, from digging around the Joomla 3 database I see an xxxxx_associations table.

I'm guessing from looking at com_content/helpers/content.php getAssociations() that its used to associate items with other items of the same component. It seems you can associate objects from other components by changing the sql a bit.

Two Quick Questions.....
Is the xxxxx_associations table only intended to designate relations of "tagged" articles(com_content) / items(from any component)?
Where are the associations created, I dont see tags in articles, or any association manager component... my table is empty?

[Victor Drover]

Thanks for your interest! 

However this list is for discussing joomla development. I suspect you will get a complete answer on the Joomla forums.

That said, associations relate the same content in different languages .

Sent from my iPhone

--
You received this message because you are subscribed to the Google Groups "Joomla! CMS Development" group.
To view this discussion on the web, visit https://groups.google.com/d/msg/joomla-dev-cms/-/SYsgDjrw12sJ.
To post to this group, send an email to joomla-...@googlegroups.com.
To unsubscribe from this group, send email to joomla-dev-cm...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/joomla-dev-cms?hl=en-GB.

[reynaldo celaya III]

Ill just go through the code myself, shouldnt have wasted my time posting here... i dont see how cms group gets contributors if unwilling to discuss something simple like a new table. I wont hold it against the community as Vic is just one voice.

[over]

The question is very well related to joomla development! This group or altternativaly in the joomla developer google group.

e.g. Is someone worrking on item assossiations for other cms components than content?

@reynaldo celaya III
Your interest is important for making Joomla as a whole multilingual. I doubt there will be any general extensions available to handle translations in the future. I added it myself to a component and am testing.it. Joomla 3.0.2 needed.

As you mentioned, have a look in com_content and com_categories. There are a lot of small pieces of new code. e.g.in the edit models.

If you ask in the developer group I'll be able to point to some more specific code.

https://groups.google.com/forum/#!forum/joomla-dev-general

Regards
Ove

[reynaldo celaya III]

Thanks for your reply!

e.g. Is someone worrking on item assossiations for other cms components than content?

Right, that would be  a better question for this group, but an understanding of the intentions of the core joomla comes first. Then comes innovation. Sometimes an experienced developer doesnt always need to dive into every nook of the frameworks that they use. Up until now havent touched on associations just thinking it was related items, but the language aspect sparks alot of my interest.
 

@reynaldo celaya III
Your interest is important for making Joomla as a whole multilingual. I doubt there will be any general extensions available to handle translations in the future. I added it myself to a component and am testing.it. Joomla 3.0.2 needed.

Right as is.... it really needs a little work to simplify the process, the ammount of duplicate work neccessary can somewhat be automated... and it would be great to add some josetta functionality into the core! Id be happy to get my team on some of this because in my current project it would be mutually beneficial to have continued community development on such a core functionality. Id love to see what you got so far.

As you mentioned, have a look in com_content and com_categories. There are a lot of small pieces of new code. e.g.in the edit models.

Thanks, have set up some breakpoints and am going over the content model code / modules / helpers.... it looks very simple...Good day to you Ove!

[Ove]

> Right as is.... it really needs a little work to simplify the process,
> the ammount of duplicate work neccessary can somewhat be automated...
> and it would be great to add some josetta functionality into the core!
> Id be happy to get my team on some of this because in my current
> project it would be mutually beneficial to have continued community
> development on such a core functionality. Id love to see what you got
> so far.
>

Are you involved with Josetta? A great next step for native multilingual
support would be to have core functionality for front end translations.
I didn't test Josetta yet and don't know how the items are assossiated.
I first wanted to see something like this core associations table used.
As a test I allready had a "double" view with original/new item in the
backend (with my own assossiations). If we want users to find a common
Joomla interface it has to driven by the community. My hope and guess
is that e.g the Josetta project could contribute to it.

Regards
Ove

[Andrew Eddie]

On Friday, 7 December 2012 22:13:21 UTC+10, over wrote:

The question is very well related to joomla development! This group or altternativaly in the joomla developer google group.

Yeah, definitely a development question ...

The table has to do with the multi-language functions (I'm not sure on the details).

https://github.com/joomla/joomla-cms/commits/master/components/com_content/helpers/association.php 

I don't think it's intended to be used for generic associations - and I wouldn't use an anti-pattern table to do that if that's what you want to do.

Regards,

Andrew Eddie

[reynaldo celaya III]

@ ove

Are you involved with Josetta?

 No association w josetta.

A great next step for native multilingual
support would be to have core functionality for front end translations. 

I didn't test Josetta yet and don't know how the items are assossiated.

 

Ive only read the features but the idea of a manager component to simplify the creation of the category, content translations and associations would be a great addition to the core. Also the bing api for translation suggestions.
 

I first wanted to see something like this core associations table used.  

As a test I allready had a "double" view with original/new item in the
backend (with my own assossiations). If we want users to find a common
Joomla interface it has to driven by the community.

 Is it a public project on github? Id like to help out.

My hope and  guess
is that e.g the Josetta project could contribute to it.

Me too. Ask Vic :)

@andrew
 Im developing components and came across a table i havent used yet... I originally thought general associations but Ove really cleared it up and sparked some interest into improving joomla multi-language.

Im can commit some time to this....especially a multi component translation manager...but any starting point that anyone has would be good to look at.