Return to Jive Software

Up to Discussions in Developers

This Question is Answered

1 "correct" answer available (4 pts) 2 forum.thrd.helpful_answer.plural.text available (2 pts)
679 Views 3 Replies Last post: Nov 7, 2008 6:52 AM by ramseyn RSS
ramseyn Novice
ramseyn
46 posts since
Sep 8, 2008
Currently Being Moderated

Nov 3, 2008 3:47 AM

Questions about DB schema for Clearspace version 2.5

Hi,

 

I'm using Clearspace version 2.5.2 and am trying to work out how tags are related to individual documents / other content in the DB schema. I've worked out how a tag maps to a community / space:

 

jiveTag (tagID) --> jiveTagSetMap (tagSetID) --> jiveTagSet (containerID) --> jiveCommunity

 

The above tells me that tags at their lowest level can be mapped to a communinty / space, and therefore by implication to every document within a space, but not to one specific document only. Can anyone explain how you map a record from the table jiveTag to an individual document in table jiveDocument?

Todd West Jive Employee
Todd West
11,540 posts since
Jul 14, 2008
Currently Being Moderated
Nov 3, 2008 5:59 AM in response to: ramseyn
Re: Questions about DB schema for Clearspace version 2.5

Hi,

 

The key here is the jiveObjectTag table, this is the table that maps any object in the system to a given tag.

 

objectType and objectID will map to a specific document, blog, community, etc. in the system. Then the tagID maps to a tag in the jiveTags table. Thanks.

 

-Todd

rickpalmer Jive Employee
rickpalmer
63 posts since
Nov 14, 2007
Currently Being Moderated
Nov 5, 2008 4:07 PM in response to: ramseyn
Re: Questions about DB schema for Clearspace version 2.5

Hi Ramsey (same Ramsey that I met over in London by any chance?)

 

Not sure if you've seen this, but there's a Database Schema guide that lists all of the tables, and down at the bottom of the doc there are ERD diagrams that I've found helpful in visualizing the relationships.

ramseyn Novice
ramseyn
46 posts since
Sep 8, 2008
Currently Being Moderated
Nov 7, 2008 6:52 AM in response to: rickpalmer
Re: Questions about DB schema for Clearspace version 2.5

Hi Rick,

 

Indeed it is, nice to hear from you. Also nice to see that you take the time to help out in the forums .

 

What I'd like to achieve is add new tags to some documents. By some I mean a ton of documents, so doing it manually is out of the question. I'm hoping to be able to run some SQL to do this for me. I've done some research and I believe all I need to do is:

 

1. Stop Clearspace

 

2. For each document (with ID internalDocID):

 

(a). Pick a unique ID for each tag, let's call it X. This tagID must not currently exist in jiveTag. Insert a record into jiveTag for the new tag.

(b). Insert a record into jiveObjectTag. Record will have the following format:

 

102 (which is the code for a doc), internalDocID, X, creationDate.

 

3. Start Clearspace

 

 

I don't think I need to touch tables jiveTagSet and JiveTagSetMap because I understand them to be a grouping mechanism for tags which I don't need?

 

Do I need to do some kind of re-indexing because I have manually inserted records into the tables? Maybe I don't need to worry about re-indexing and I'll be good to go as soon as I restart Clearspace. Does my above plan seem sensible?

 

Thanks,

Ramsey

More Like This

  • Retrieving data ...

Bookmarked By (0)