+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / Share News content across multiple Sitefinity sites

Share News content across multiple Sitefinity sites

6 posts, 0 answered
  1. Chip Gallent
    Chip Gallent avatar
    41 posts
    Registered:
    06 Nov 2009
    17 May 2010
    Link to this post
    I have a client who has four Sitefinity 2.9 sites and wants to only share news across all of the sites. Each site has a separate database - they're not working off of one shared dB. But, we'd like to post the news once and then have it show up on all four sites. Any ideas?

    Thanks,
    Chip
  2. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    18 May 2010
    Link to this post
    Hi Chip Gallent,

    Could you, please clarify which version version of Sitefinity are you using? We do not have a Sitefinity 2.9 version. The latest version of the 2.x line is 2.6.

    Versions prior to Sitefinity 3.x do not support the provider model so this will not be possible in such versions. In versions 3.x you need to do the following:

    1) Add connection string to the common database:
    <connectionStrings>
        ...
        <add name="NewsCommonConnecton" connectionString="..." providerName="System.Data.SqlClient" />
    </connectionStrings>

    2) In data access configuration section add another generic content connection for the common news provider, which will use the connection string to the common news db:
    <dataAccess defaultConnection="DefaultConnection">
        <connections>
            <add name="DefaultConnection" driver="Telerik.DataAccess.Providers.ExtendedSqlServer2005Provider, Telerik.DataAccess" connectionStringName="Sitefinity" />
            <add name="GenericContentConnection" driver="Telerik.Cms.Engine.Data.Providers.GCSql2005Provider, Telerik.Cms.Engine.Data" connectionStringName="Sitefinity" />
            <add name="NewsConnection" driver="Telerik.Cms.Engine.Data.Providers.GCSql2005Provider, Telerik.Cms.Engine.Data" connectionStringName="NewsCommonConnecton" />
        </connections>
    </dataAccess>

    3) Set the news generic content provider to use this connection:
    <cmsEngine defaultProvider="Generic_Content">
        <providers>
            <clear />
            ...
            <add name="News" allowLocalization="True" urlRewriteFormat="[Publication_Date]/[Title].aspx" urlDateTimeFormat="yy-MM-dd" urlWhitespaceChar="_" visible="False" defaultMetaField="Title" securityProviderName="" allowVersioning="True" applicationName="/News" versioningProviderName="" commentsModeration="true" connectionStringName="NewsConnection" type="Telerik.News.Data.DefaultNewsProvider, Telerik.News.Data" />

    This should do the trick.

    Sincerely yours,
    Radoslav Georgiev
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. Kyle Gleason
    Kyle Gleason avatar
    1 posts
    Registered:
    19 Jun 2009
    04 Aug 2010
    Link to this post

    Radoslav,

    We're using Sitefinity 3.7, and am sharing content using this approach. We have multiple sites sharing a secondary database for Generic Content, News, Polls, etc... It works fantastic, all the content is shared amongst the sites, and can be edited from the Admin side of any site. However, the "Tags" feature doesn't seem to work correctly in the Admin area.

    When clicking on the Tags menu item, it will correctly display the Tags within our Shared content database, and the number of Content Items associated with each tag. But, when clicking on a Tag, the listing comes up empty. Below are the config settings for our implementation.

    Connection String:

    1.<add name="SF-Share" connectionString="data source=Server;UID=dbuser;PWD=dbpass;initial catalog=SF-Share" providerName="System.Data.SqlClient" />
    Data Access:
    1.<add name="SharedGenericContentConnection" driver="Telerik.Cms.Engine.Data.Providers.GCSql2005Provider, Telerik.Cms.Engine.Data" connectionStringName="SF-Share"/>

    CMSEngine tag:
    1.<add name="Shared_Content" urlRewriteFormat="[Publication_Date]/[Name].aspx" urlDateTimeFormat="yy-MM-dd" urlWhitespaceChar="_" visible="True" defaultMetaField="Name" allowLocalization="True" allowVersioning="True" allowWorkflow="False" allowComments="false" commentsModeration="true"  connectionStringName="SharedGenericContentConnection" tagProviderName="test" type="Telerik.Cms.Engine.Data.Providers.DefaultProvider, Telerik.Cms.Engine.Data"></add>

    The Meta fields we're using are a copy of the "Generic_Content" fields, but renamed to "Shared_Content". I can provide more information if needed.

    Thanks,
    Kyle
  4. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    05 Aug 2010
    Link to this post
    Hi Kyle Gleason,

    Thank you for getting back to us.

    We have tested this configuration and can confirm that this is a bug with the tagging functionality. We have logged this bug and will try to fix this for our upcoming service pack. The problem is with the tags only. We have tested this for categories and other meta fields and it is working as expected there. Thank you very much for reporting this. I have updated your Telerik points.

    Best wishes,
    Radoslav Georgiev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Madhavan
    Madhavan avatar
    19 posts
    Registered:
    31 Jan 2011
    16 Feb 2011
    Link to this post
    Hi,

      First we are using the 4.0 version of Sitefinity. We have multiple sites and the news are present in the master web site with some categories which will differentiate whether it needs to go to the child site or not. There are multiple child sites which will take data from this master site filtering on the category. 

      For example There are 5 news items with categories below

    1. Corporate
    2. Corporate, Child 1
    3. Corporate, Child 2
    4. Corporate, Child 2
    5. Corporate, Child 3

      In this when the news for the corporate is displayed it displays all the 5 news items. The Child 1 site will display only News Item 1 and 2, The child 2 site will display 1, 3,4 while the child 3 should display 1 and 5.

    Please note: The Child sites should not have any control on the News being displayed. The child admin can not edit or take control of this News. The News flow from the Corporate to the Child Sites only.

    Please let me know if this is possible using the News section or should I be using the blogs to accomplish this. 

    Thanks
    Madhavan
  6. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    18 Feb 2011
    Link to this post
    Hi Madhavan,

    Thank you for contacting Telerik Support.

    Sharing of content between providers is not intended to work in this way. If you use the modules and make them share content they have to share the entire news content.

    For your requirement you should the Feed & Notifications features and create an RSS pipe to import content from your parent news to your child news. Unfortunately right now the feeds system cannot syndicate news by category. This feature will be ready for Q2 2011. Then on your parent website you should go to Administration -> Feeds & Notifications. Then for each child website you should create an RSS feed which includes news from the categories which you want to appear on the child site.

    Kind regards,
    Radoslav Georgiev
    the Telerik team
Register for webinar
6 posts, 0 answered