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

Forums / Developing with Sitefinity / import data from external database

import data from external database

13 posts, 0 answered
  1. Owain
    Owain avatar
    110 posts
    Registered:
    17 Jan 2012
    19 Jun 2014
    Link to this post

    Hi,

    I am looking to migrate my blog posts from another CMS in to Sitefinity. The CMS I currently use on is Orchard but I am migrating the site to Sitefinity. It's not a massive site but I would like to copy the blog entries over to SF rather than retype or copy/paste them. 

    I've been looking at the inbound pipes and thought this might be the solution but I'm looking for some guidance on a) whether this is the best way to do it and b) if it isnt, what would be the best option?

    The database is sitting on the same server as what my SF site will be on. 

    Thanks

  2. Owain
    Owain avatar
    110 posts
    Registered:
    17 Jan 2012
    23 Jun 2014
    Link to this post

    Would really appreciate some guidance on this, 

    Thanks,

  3. Nikola Zagorchev
    Nikola Zagorchev avatar
    424 posts
    Registered:
    29 Sep 2016
    24 Jun 2014
    Link to this post
    Hi Owain,

    Implementing an inbound pipe is a good approach if you want to constantly import data between the two sources. However, it is a lot of work having in mind that you pointed out you do not have much data and as far as I understand you want to only migrate the data from the legacy site, not keep them both synced. It is important how you suppose to get the data from the not Sitefinity database, what points for getting the data will be used, services implemented etc. If you can use the API and just create and publish the items you want, I suppose this would be the easiest way.

    Regards,
    Nikola Zagorchev
    Telerik
     
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
     
  4. Owain
    Owain avatar
    110 posts
    Registered:
    17 Jan 2012
    24 Jun 2014 in reply to Nikola Zagorchev
    Link to this post

    Thanks for the reply,

    It would be just the once I want to do this, I simply want to connect to the legacy database, find the specific information and then map it to the Sitefinity DB as a new blog post.

    I'll have a look through the API to see if I can find anything that may help, if anyone has any pointers to get me started it would be appreciated.

     

  5. Nikola Zagorchev
    Nikola Zagorchev avatar
    424 posts
    Registered:
    29 Sep 2016
    25 Jun 2014
    Link to this post
    Hello Owain,

    You can find information and samples for creating and publishing blogs and blog posts in our documentation. Please, take a look at the following link. There are samples for creating and editing both blogs and posts, please review them and let us know if you need further information.

    Regards,
    Nikola Zagorchev
    Telerik
     
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
     
  6. Kuldeep
    Kuldeep avatar
    1 posts
    Registered:
    26 Jun 2014
    26 Jun 2014
    Link to this post

    Hello Owain,

    if You are going to migrating the complete website, I'd recommend you to work with an expert or read the following guide provides by @Nikola Zagorchev.

    Also before editing your post and pages you must take backup of your data and website. There are lots of people outside there you can find them through freelance desk or can contact with a sitefinity development agency with your requirement. I am sure they can help you understand the sitefinity better. 

    Thanks,
    Kuldeep,
    Sitefinity Developer - IDS Logic

  7. Owain
    Owain avatar
    110 posts
    Registered:
    17 Jan 2012
    26 Jun 2014 in reply to Kuldeep
    Link to this post

    Hi Kuldeep, 

    Thanks for your reply. I am a developer but very new to developing with Sitefinity so looking for the best way to achieve what I am looking to do. I've been working with Sitefinity for about 2 years now but had to do very little development as I've had other team members to do that coding. 

    This is more a personal project of mine and I want to develop my Sitefinity skills. Full backups will be taken, just in case :) 

     

  8. Natasha
    Natasha avatar
    11 posts
    Registered:
    19 Mar 2015
    01 Apr 2015 in reply to Owain
    Link to this post

    Owain start with the small modules. You have to be work on Sitefinity platform regularly so that you are able to face future problem of application development.

    You can post your error and problems regarding application development using Sitefinity.


    Thanks

    Natasha

     

  9. Nikola Zagorchev
    Nikola Zagorchev avatar
    424 posts
    Registered:
    29 Sep 2016
    02 Apr 2015
    Link to this post
    Hello all,

    Owain, feel free to post questions or issues regarding the forum thread topic here, so we and the community could help you achieve the desired result.

    Regards,
    Nikola Zagorchev
    Telerik
     
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
     
  10. Nikhil
    Nikhil avatar
    2 posts
    Registered:
    06 Jan 2015
    13 Jul 2015
    Link to this post

    Hi,

     

    I have same kind of requirement in which I need to get data from external site and store it in sitefinity database. I have to take data from NASDAQ which is not RSS or ATOM. It provides feeds in IRXML. I have made custom inbound pipe and registered in module also by following  these setps:

    In the main menu, click Administration » Settings » Advanced.
    In the navigation tree on the left, click System » ApplicationModules.
    To register the module, click Create New.
    In the Name input field and in the Title input field, enter ​CustomFeeds.
    In the Type field, enter SitefinityWebApp.Modules.​UserControls.CustomFeedsd.
    To save your changes, click Save.​

     Now I am expecting to see custom inbound pipe in sitefinity dashboard either in module or alternate publishing. Where I can give URL of NASDAQ feeds and assign inbound pipe. I am not finding that place where I need to do these kind of settings. Can you help me in that to achieve?

  11. Nikola Zagorchev
    Nikola Zagorchev avatar
    424 posts
    Registered:
    29 Sep 2016
    16 Jul 2015
    Link to this post
    Hello Nikhil,

    Please, check the resources bellow:
    Import multilingual News from external RSS feed in Sitefinity
    Import POP3 content: Create the feed
    Create a custom inbound pipe

    Hope you find them helpful.

    Regards,
    Nikola Zagorchev
    Telerik
     
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
     
  12. Nikhil
    Nikhil avatar
    2 posts
    Registered:
    06 Jan 2015
    22 Jul 2015 in reply to Nikola Zagorchev
    Link to this post

    Thanks Nikola for your reply.

     It has not worked for me. I have already made Inbound Pipe. The problem I am facing is about registration and to see somewhere so that I can assign inbound pipe and so some sort of mapping. I expect it to be in Alternate Publishing but does not see it.

     

    Suggest me to see it in effect.

     

    Thanks

    Nikhil

  13. Nikola Zagorchev
    Nikola Zagorchev avatar
    424 posts
    Registered:
    29 Sep 2016
    27 Jul 2015
    Link to this post
    Hello Nikhil,

    Please, provide more information on the current implementation you have. Basically, you need only to unregister the default pipe and register your custom one over it. This is described in the first post I linked:
    protected void Application_Start(object sender, EventArgs e)
    {
        Bootstrapper.Initialized += OnBootstrapperInitialized;
    }
      
    protected static void OnBootstrapperInitialized(object sender, ExecutedEventArgs e)
    {
        if (e.CommandName == "Bootstrapped")
        {
            PublishingSystemFactory.UnregisterPipe(RSSInboundPipe.PipeName);
            PublishingSystemFactory.RegisterPipe(RSSInboundPipe.PipeName, typeof(RssInboundPipeCustom));
      
            PublishingSystemFactory.UnregisterPipe(ContentOutboundPipe.PipeName);
            PublishingSystemFactory.RegisterPipe(ContentOutboundPipe.PipeName, typeof(ContentOutboundPipeCustom));
        }
    }

    You do not need to explicitly set it when creating the feed to import from.

    Regards,
    Nikola Zagorchev
    Telerik
     
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
     
13 posts, 0 answered