Copied to clipboard

Flag this post as spam?

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


  • Eric Herlitz 97 posts 129 karma points
    Mar 07, 2011 @ 12:06
    Eric Herlitz
    0

    Export / Import Umbraco Articles

    Hi!

    Is there a smart way to Export Umbraco articles from one installation and Import them to another?

    / Eric

  • Eric Herlitz 97 posts 129 karma points
    Mar 07, 2011 @ 16:29
    Eric Herlitz
    0

    Well, if anyone is interested here is a successful sql-export command, now i just got to figure out how to make a proper import

     

    string query = @"SELECT 
                dbo.umbracoNode.text AS [umbracoNode-text, dbo.umbracoNode.uniqueID AS [umbracoNode-uniqueID], dbo.umbracoNode.createDate AS [umbracoNode-createDate], 
                dbo.umbracoNode.sortOrder AS [umbracoNode-sortOrder], dbo.umbracoNode.path AS [umbracoNode-path], dbo.umbracoNode.level AS [umbracoNode-level], 
                dbo.umbracoNode.parentID AS [umbracoNode-parentID], dbo.umbracoNode.id AS [umbracoNode-id], 
                dbo.umbracoNode.trashed AS [umbracoNode-trashed]], dbo.cmsContentType.description AS [cmsContentType-description], 
                dbo.cmsContentType.alias AS [cmsContentType-alias], dbo.cmsDocument.versionId AS [cmsDocument-versionId], 
                dbo.cmsDocument.published AS [cmsDocument-published], dbo.cmsPropertyData.dataNtext AS [cmsPropertyData-dataNtext], 
                dbo.cmsPropertyData.dataNvarchar AS [cmsPropertyData-dataNvarchar], dbo.cmsPropertyData.dataDate AS [cmsPropertyData-dataDate], 
                dbo.cmsPropertyData.dataInt AS [cmsPropertyData-dataInt], dbo.cmsPropertyType.Alias AS [cmsPropertyType-Alias], 
                dbo.cmsPropertyType.Name AS [cmsPropertyType-Name], dbo.cmsTags.tag AS [cmsTags-tag]
            FROM
                dbo.cmsContent INNER JOIN
                dbo.umbracoNode ON dbo.cmsContent.nodeId = dbo.umbracoNode.id INNER JOIN
                dbo.cmsContentType ON dbo.cmsContent.contentType = dbo.cmsContentType.nodeId INNER JOIN
                dbo.cmsTagRelationship ON dbo.umbracoNode.id = dbo.cmsTagRelationship.nodeId INNER JOIN
                dbo.cmsTags ON dbo.cmsTagRelationship.tagId = dbo.cmsTags.id FULL OUTER JOIN
                dbo.cmsPropertyData INNER JOIN
                dbo.cmsDocument ON dbo.cmsPropertyData.versionId = dbo.cmsDocument.versionId INNER JOIN
                dbo.cmsPropertyType ON dbo.cmsPropertyData.propertytypeid = dbo.cmsPropertyType.id ON dbo.umbracoNode.id = dbo.cmsDocument.nodeId
            WHERE 
                (dbo.cmsDocument.published = 1)
                AND (dbo.cmsPropertyType.Alias = 'bodyText' OR dbo.cmsPropertyType.Alias = 'shorttext')";
  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Mar 07, 2011 @ 16:52
    Richard Soeteman
    1

    Hi Eric,

    For importing data you can use CMSImport 

    Cheers,

    Richard 

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Mar 07, 2011 @ 17:38
    Jan Skovgaard
    0

    Hi Eric

    As Richard is saying you can use CMSimport - I will recommend it since it will save you time and you don't re-invent the wheel. It's such a breeze to use. I'm really looking forward to the release of v2.0 :-)

    /Jan

  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Mar 07, 2011 @ 19:59
    Richard Soeteman
    0

    Thanks Jan,

    Also looking forward to the release of 2.0. You have to wait a little bit longer.... :)

    Cheers,

    Richard

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

    Continue discussion

Please Sign in or register to post replies