Hide Forgot
Create a table Author_Information with the following fields: AuthorID WriterID First_Name Surname OrgName OrgDiv Email PRIMARY AUTOINC Now, we will populate the WriterID field with the tagID of Authors. So if we have an Assigned Writer jwulf whose TagID is 43, then we'll create a record in here for jwulf and make the WriterID 43. When assembling a build, we need to do the following: Run a query that returns all the Author_Information records where the WriterID matches the TagID of any topic-to-tag mapping for any of the topics in the build. This will return to us a list of the authors who were assigned writers for the topics included in the build. Now write these guys into the Author_Group.xml file of the output in the following way: <authorgroup> [FOR EACH AUTHOR_INFORMATION] <author> <firstname>[AUTHOR_INFORMATION.First_Name]</firstname> <surname>[AUTHOR_INFORMATION.Surname]</surname> [IF EXISTS AUTHOR_INFORMATION.OrgName or AUTHOR_INFORMATION.OrgDiv] <affiliation> <orgname>[AUTHOR_INFORMATION.OrgName]</orgname> <orgdiv>[AUTHOR_INFORMATION.OrgDiv]</orgdiv> </affiliation> [END: IF] [IF EXISTS AUTHOR_INFORMATION.Email] <email>jwulf</email> [END:IF] </author> [END: FOR] </authorgroup> Boom, automated author attribution.
We would need a way to pull/insert the rest of the data for each Author as Skynet doesn't keep any of this information. All it keeps is the username of the writer.
Yes, we will manually populate the table. All we need from Skynet is the user ID. Hopefully once we demonstrate it as a Proof-of-Concept Skynet will pull the functionality in.
This has now been implemented. However to ensure better database design there are three tables; AuthorInformation, Organization & OrganizationDivision. In the AuthorInformation table the AuthorID is the TagID in the tag table. This was done since not all users are assigned writers. If no assigned writers are found then it will go back to the default: <authorgroup> <author> <firstname>Staff</firstname> <surname>Writer</surname> <affiliation> <orgname>Red Hat</orgname> <orgdiv>Engineering Content Services</orgdiv> </affiliation> <!-- <email></email> --> </author> </authorgroup>
Created attachment 531713 [details] SQL for the new tables
Did we lose this functionality when we merged into the borg? (Documenting it, but it doesn't seem to be working) At the moment my book [1] has only my name, but topics from different authors (jwulf and sgordon). Is it inheriting the book author from the Content Spec author? [1] Spec ID: 7272
No see: Bug #791075 The author information is now populated using the property tags on an author. and it gets all the authors for for every topic in the book.
Got it, thanks. The cause of this for me was that one of the assigned writer tags did not have its Person (First Name, Last Name, Email) metadata set up.