Ancestry.com built-in source template

Quote from Jaime Teas on 2022-12-01, 12:18 amThis has got to be a problem that has already been covered in this forum, but I can't find it posted anywhere.
The problem is that when I print a bibliography, Ancestry.com sources print with a leading comma. If I save my report in a text file and do a search/replace I can easily fix this, however it puts my bibliography out of alphabetical order.
Since we can't edit built-in source templates, has anyone come up with a workaround/solution for this?
This has got to be a problem that has already been covered in this forum, but I can't find it posted anywhere.
The problem is that when I print a bibliography, Ancestry.com sources print with a leading comma. If I save my report in a text file and do a search/replace I can easily fix this, however it puts my bibliography out of alphabetical order.
Since we can't edit built-in source templates, has anyone come up with a workaround/solution for this?
Uploaded files:
Quote from Tom Holden on 2022-12-01, 9:55 amIt is disconcerting that RM Inc continued to create source templates that result in extraneous punctuation when a field is empty, viz. Source Templates: Revision Utilities. Built-in templates can be modified through SQLite but the modification cannot be carried across a GEDCOM transfer. The sentence templates themselves have no effect on TreeShare. So the Ancestry Record Source Templates can have their sentence templates freely modified with effect only on the report products of the database.
It is disconcerting that RM Inc continued to create source templates that result in extraneous punctuation when a field is empty, viz. Source Templates: Revision Utilities. Built-in templates can be modified through SQLite but the modification cannot be carried across a GEDCOM transfer. The sentence templates themselves have no effect on TreeShare. So the Ancestry Record Source Templates can have their sentence templates freely modified with effect only on the report products of the database.

Quote from Jaime Teas on 2022-12-01, 11:51 amThanks for this. I'm also unsure why some of my freeform sources have been converted to Ancestry sources. They were hand-entered by me from sources outside of Ancestry.
Thanks for this. I'm also unsure why some of my freeform sources have been converted to Ancestry sources. They were hand-entered by me from sources outside of Ancestry.

Quote from Tom Holden on 2022-12-01, 4:54 pmIn the SourceTemplateTable, record #439 is the template for Ancestry.com record sources and the Bibliography sentence is currently:
<?[Author:Surname]|[Author:Reverse]. |[Author]. ><i>[Title]</i>. <[PubPlace]|N.p.>: <[Publisher]|n.p.>, <[PubDate]|n.d.>.
I'm uncertain that there is anything wrong with it and why you get the result you do. I just ran an experiment with the same collection and the result I get is punctuated correctly.
In the SourceTemplateTable, record #439 is the template for Ancestry.com record sources and the Bibliography sentence is currently:
<?[Author:Surname]|[Author:Reverse]. |[Author]. ><i>[Title]</i>. <[PubPlace]|N.p.>: <[Publisher]|n.p.>, <[PubDate]|n.d.>.
I'm uncertain that there is anything wrong with it and why you get the result you do. I just ran an experiment with the same collection and the result I get is punctuated correctly.
Uploaded files:

Quote from Tom Holden on 2022-12-01, 4:59 pmAnd what version of RM are you using? I'm on 8.2.5 and our citation preview panes are different.
And what version of RM are you using? I'm on 8.2.5 and our citation preview panes are different.

Quote from Tom Holden on 2022-12-01, 5:59 pmAha! You are on RM7 and the Bibliography sentence template was revised|improved for RM8. Here's the RM7 version:
[Author:Reverse]. <i>[Title]</i>. <[PubPlace]|N.p.>: <[Publisher]|n.p.>, <[PubDate]|n.d.>.
If you replace it with this from RM8, the extraneous comma will be gone:
<?[Author:Surname]|[Author:Reverse]. |[Author]. ><i>[Title]</i>. <[PubPlace]|N.p.>: <[Publisher]|n.p.>, <[PubDate]|n.d.>.
Likewise for the Short Footnote, use the RM8 version in RM7.
Aha! You are on RM7 and the Bibliography sentence template was revised|improved for RM8. Here's the RM7 version:
[Author:Reverse]. <i>[Title]</i>. <[PubPlace]|N.p.>: <[Publisher]|n.p.>, <[PubDate]|n.d.>.
If you replace it with this from RM8, the extraneous comma will be gone:
<?[Author:Surname]|[Author:Reverse]. |[Author]. ><i>[Title]</i>. <[PubPlace]|N.p.>: <[Publisher]|n.p.>, <[PubDate]|n.d.>.
Likewise for the Short Footnote, use the RM8 version in RM7.

Quote from Tom Holden on 2022-12-01, 9:15 pmQuote from jlodge on 2022-12-01, 12:18 amThis has got to be a problem that has already been covered in this forum, but I can't find it posted anywhere.
It was addressed on the page Ancestry TreeShare - Impact that has a link back to the formative discussion in July 2017. It only took four years for the fix to be in a public release. I note that my earlier solution on that page is different from what is in RM8 which looks identical or close to what user Gina had proposed back then.
I suspect the current RM8 Bibliography sentence template still has the same problem when the Author is something like "Ancestry.com and The Church Of Latter Day Saints". It will come out as "Saints, Ancestry... Latter Day".
Quote from jlodge on 2022-12-01, 12:18 amThis has got to be a problem that has already been covered in this forum, but I can't find it posted anywhere.
It was addressed on the page Ancestry TreeShare - Impact that has a link back to the formative discussion in July 2017. It only took four years for the fix to be in a public release. I note that my earlier solution on that page is different from what is in RM8 which looks identical or close to what user Gina had proposed back then.
I suspect the current RM8 Bibliography sentence template still has the same problem when the Author is something like "Ancestry.com and The Church Of Latter Day Saints". It will come out as "Saints, Ancestry... Latter Day".

Quote from Tom Holden on 2022-12-01, 9:43 pmQuote from jlodge on 2022-12-01, 11:51 amThanks for this. I'm also unsure why some of my freeform sources have been converted to Ancestry sources. They were hand-entered by me from sources outside of Ancestry.
I suspect that what you mean is that sources using the Free Form template or any RM source template, when uploaded to Ancestry.com and then downloaded to a new RM database end up as using the Ancestry Record Source template. That is because RM has to comply with the Ancestry API spec for transport of citations and it is constrained by the A.com database design and structure to support only one source structure for import. The Ancestry Record Source fields definition is identical or nearly so to the GEDCOM standard with fields such as Title, Author, Publisher, etc. for the Master Source and then Page for the specific citation from that source. Very much modelled on book sources. So RM puts the Footnote sentence with only the Master Source variables into the Title field and all the values from the Source Detail|Citation fields concatenated with semi-colon separators into the Page field.
There's more discussion about this from way back at Source Templates, especially in the PDF linked from the section "A Trio of Templates". While it pre-dates TreeShare, the issue of translating from RM templates to book-style templates is the same. That's why TreeShare brought about the addition of the Ancestry Record Source template.
Quote from jlodge on 2022-12-01, 11:51 amThanks for this. I'm also unsure why some of my freeform sources have been converted to Ancestry sources. They were hand-entered by me from sources outside of Ancestry.
I suspect that what you mean is that sources using the Free Form template or any RM source template, when uploaded to Ancestry.com and then downloaded to a new RM database end up as using the Ancestry Record Source template. That is because RM has to comply with the Ancestry API spec for transport of citations and it is constrained by the A.com database design and structure to support only one source structure for import. The Ancestry Record Source fields definition is identical or nearly so to the GEDCOM standard with fields such as Title, Author, Publisher, etc. for the Master Source and then Page for the specific citation from that source. Very much modelled on book sources. So RM puts the Footnote sentence with only the Master Source variables into the Title field and all the values from the Source Detail|Citation fields concatenated with semi-colon separators into the Page field.
There's more discussion about this from way back at Source Templates, especially in the PDF linked from the section "A Trio of Templates". While it pre-dates TreeShare, the issue of translating from RM templates to book-style templates is the same. That's why TreeShare brought about the addition of the Ancestry Record Source template.

Quote from Jaime Teas on 2022-12-01, 11:00 pmThanks so much! I will try it asap!
Thanks so much! I will try it asap!