How to copy citation webtag to source webtag?

#1 · 2023-02-22, 5:25 pm

Hi Folks:

Recently I decided instead of lumping my citations I would split them. (I did so in a different program).

Currently my sources are how I want them except for one point.

I have a citation webtag still on each source. I would like to copy that to the Source webtag field. Any idea on how I could do that?

Thanks,

Matthew

(On a side note, I notice when I copy a source from Familysearch to Rootsmagic, if it has a link that link is clickable and stays clickable in Rootsmagic (this is in the source transfer screen). Is there a way to make the source webtag clickable like that (clickable if you click on the information icon in the transfer screen)

Uploaded files:

#2 · 2023-02-23, 9:54 am

Could there be multiple distinct WebTags among the many Citations of the same Source?

Yes. Add all distinct WebTags to the Source. Keep all Citation WebTags.
No. Add the one distinct WebTag to the Source. Delete Citation WebTags?

#3 · 2023-02-23, 10:08 am

Quote from Matthew Friend on 2023-02-22, 5:25 pm
... Is there a way to make the source webtag clickable

They are, if you have entered a proper URL. Or, have I misunderstood the question?

#4 · 2023-02-23, 1:59 pm

Hi Tom:

Thanks for helping. Each source should only have x1 web tag in the citation section. I think what I want to do is what you list for #1: Add all distinct webtags to the source and keep the citation webtag.

The link thing is weird. When I am in the sync part of rootsmagic and say I click on the "i" to see the source, it shows the url but its not clickable. If I actually go to the source that is attached to the fact/person, it shows as clickable. Here is an example from one that is not clickable attached.

Uploaded files:

#5 · 2023-02-23, 8:26 pm

A decade ago I developed a script which is probably more complex than what is needed to do what you want:

WebTags - Consolidate

On the same page is a script to delete duplicate WebTags which might still work and come in handy.

#6 · 2023-02-23, 9:55 pm

Hi Tom:

When I run the webtags -consolidate sql I get the following error:

no such column: Cit.OwnerType

SQL Statement:

-- WebTags-Consolidate.sql

Maybe some table structures have changed? (I'm using RM 8).

Uploaded files:

#7 · 2023-02-23, 10:29 pm

Yes, tables have changed and those scripts don't run on an RM8 database. I'm just in the throes of of the Consolidate script which is proving quite tricky because UTCModDate now comes into play. The Delete Duplicates was easy. After I get it sorted, I'll have a look at your Copy WebTag from Citation to Source, which I think should be easy.

#8 · 2023-02-23, 11:23 pm

@mfriend there are now scripts for RM8 on WebTags - Consolidate if they are of interest.

#9 · 2023-02-24, 9:57 pm

Here's my script for copying WebTags for Citations to their Sources for RM8. Note in the description comments that repeated execution duplicates the WebTags so you'll need to run the script WebTags-DeleteDuplicates-RM8.sql afterwards (found at WebTags - Consolidate. It could be appended to the Copy script to be all done in one operation.

I'm not sure that this will prove very useful to you and the RM8 user interface may undermine its usefulness. There is no width adjustment in the Edit WebTags list window and the Name field is much too narrow. Why the URL is displayed beats me - why is it not the same as the FamilySearch Central style where the Name has been made into a hyperlink!

Uploaded files:

WebTags-CopyCitations_to_Source-RM8.sql

#10 · 2023-02-25, 11:53 am

Thank you so much for your help, those all worked perfect 🙂

I have another question but I'll start a new forum post so it doesn't get lost incase someone searches for it in the future.

Matthew