Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Lesley 107 posts 349 karma points
    Sep 15, 2016 @ 03:17
    Lesley
    0

    Does SniperTags work in Umbraco v7. The package says it installed successfully but I don't see Sniper Tags in the Data Types Property Editor dropdown?

  • Alex Skrypnyk 6132 posts 23951 karma points MVP 7x admin c-trib
    Sep 15, 2016 @ 17:20
    Alex Skrypnyk
    0

    Hi Lesley,

    I think it's not working with umbraco 7

    Thanks,

    Alex

  • Alex Skrypnyk 6132 posts 23951 karma points MVP 7x admin c-trib
    Sep 23, 2016 @ 13:43
    Alex Skrypnyk
    0

    Hi Lesley,

    Do you have something to share on this topic?

    It would be great.

    Thanks

  • Lesley 107 posts 349 karma points
    Sep 25, 2016 @ 19:53
    Lesley
    1

    Sniper Tags do not work in v7 so we have replaced with the standard Umbraco tags.

    During the upgrade process from Umbraco v6.0.5 to v7, the Sniper Tags details in the cmsTagRelationship table was deleted which meant the auto-complete functionality of the tags wasn't working.

    We ended up taking a backup of the Umbraco database and then doing the upgrade.

    Once the upgrade was finished, we restored the backup as a separate instance so that we had the new v7 database and original v6.0.5 database on the same server.

    We changed the Sniper Tag properties to standard Umbraco tags and then ran a script against the v7 database to pull the Sniper Tags cmsTagRelationship data across from the v6.0.5 database and link it to the relevant property type e.g.:

    insert into cmsTagRelationship
    (nodeId, tagId,propertyTypeId)
    select oldtags.nodeId, oldtags.tagId,
    case 
    when cmstags.[group] = 'Group1' then 71
    when cmstags.[group] = 'Group2' then 72
    else null
    end as propertytypeid
     from [OldDB].dbo.cmsTagRelationship as oldtags
    inner join [OldDB].dbo.cmsTags on oldtags.tagId = cmsTags.id
    left outer join [NewDB].dbo.cmsTagRelationship as newtags
    on oldtags.nodeid = newtags.nodeId
    and oldtags.tagId = newtags.tagId
    where newtags.nodeId is null
    and exists (select 1 from cmsContent where nodeId = oldtags.nodeId)
    

    We then detached the v6.0.5 database as this was no longer needed.

Please Sign in or register to post replies

Write your reply to:

Draft