Esempio n. 1
0
        public List <MigratorPost> GetPosts()
        {
            int postId = 100;             // this is only used if the id format is not an int (dasblog)

            CleanupEncodedFile();

            var posts    = new List <MigratorPost>();
            var comments = new List <MigratorComment>();
            var tags     = new List <BlogMLTag>();

            XmlDocument doc = new XmlDocument();

            try
            {
                doc.LoadXml(_encodedFile);
            }
            catch (Exception exc)
            {
                // might be unicode, and since DOM detection doesn't work correctly, we will try to load it unicode
                try
                {
                    _encodedFile = Encoding.Unicode.GetString(_fileBytes);
                    CleanupEncodedFile();

                    doc.LoadXml(_encodedFile);
                }
                catch (Exception)
                {
                    // didn't work here either, bubble it up
                    throw exc;
                }
            }

            XmlNamespaceManager mgr = new XmlNamespaceManager(doc.NameTable);

            XmlNode node = doc.SelectSingleNode("blog", mgr);

            foreach (XmlNode catNode in node.SelectNodes("categories/category"))
            {
                BlogMLTag t = new BlogMLTag();
                t.Id = catNode.Attributes["id"].Value;

                if (catNode.SelectSingleNode("title") == null)
                {
                    t.Description = catNode.Attributes["id"].Value;
                }
                else
                {
                    t.Description = catNode.SelectSingleNode("title").InnerText;
                }

                tags.Add(t);
            }

            foreach (XmlNode itemNode in node.SelectNodes("posts/post"))
            {
                if (itemNode.Attributes["approved"].Value == "true")
                {
                    MigratorPost post = new MigratorPost();

                    int temp = 0;
                    if (itemNode.Attributes["id"] != null && int.TryParse(itemNode.Attributes["id"].Value, out temp))
                    {
                        postId      = Convert.ToInt32(itemNode.Attributes["id"].Value);
                        post.PostID = postId;
                    }
                    else
                    {
                        post.PostID = postId;
                        postId++;
                    }

                    //post.Author = itemNode.SelectSingleNode("dc:creator").InnerText;
                    post.Body      = itemNode.SelectSingleNode("content").InnerText;
                    post.CreatedOn = Convert.ToDateTime(itemNode.Attributes["date-created"].Value);
                    post.Name      = itemNode.SelectSingleNode("title").InnerText;
                    post.Subject   = itemNode.SelectSingleNode("title").InnerText;

                    post.IsPublished = true;

                    // tags
                    post.TagsAndCategories = new List <String>();

                    foreach (XmlNode catNode in itemNode.SelectNodes("categories/category"))
                    {
                        string catId = catNode.Attributes["ref"].Value;

                        BlogMLTag cat = tags.Find(delegate(BlogMLTag t) { return(t.Id == catId); });

                        if (cat != null)
                        {
                            post.TagsAndCategories.Add(cat.Description);
                        }
                    }

                    // comments : these are going to be stored in cache for wordpress types
                    foreach (XmlNode commentNode in itemNode.SelectNodes("comments/comment"))
                    {
                        if (commentNode.Attributes["approved"].Value == "true")
                        {
                            MigratorComment comment = new MigratorComment();

                            comment.PostID      = post.PostID;
                            comment.Body        = commentNode.SelectSingleNode("content").InnerText;
                            comment.PublishedOn = Convert.ToDateTime(commentNode.Attributes["date-created"].Value);

                            comment.WebSite     = commentNode.Attributes["user-url"] == null ? "" : commentNode.Attributes["user-url"].Value;
                            comment.UserName    = commentNode.Attributes["user-name"].Value;
                            comment.IsPublished = true;

                            comments.Add(comment);
                        }
                    }

                    posts.Add(post);
                }
            }

            // add the comments to cache
            ZCache.MaxCache("MigratorComments", comments);

            return(posts);
        }
Esempio n. 2
0
        public List <MigratorPost> GetPosts()
        {
            var posts = new List <MigratorPost>();

            int userid    = 0;
            int sectionid = 0;

            using (SqlConnection conn = new SqlConnection(_databaseConnString))
            {
                conn.Open();

                using (SqlCommand cmd = new SqlCommand("select UserID from cs_Users where UserName = @username", conn))
                {
                    cmd.Parameters.Add(new SqlParameter("@username", _userName));
                    userid = Convert.ToInt32(cmd.ExecuteScalar());
                }

                using (
                    SqlCommand cmd =
                        new SqlCommand("select SectionID from cs_Sections where ApplicationKey = @appkey and ApplicationType=1", conn))
                {
                    cmd.Parameters.Add(new SqlParameter("@appkey", _applicationKey));
                    sectionid = Convert.ToInt32(cmd.ExecuteScalar());
                }

                using (
                    SqlCommand cmd =
                        new SqlCommand(
                            "select PostID, PostAuthor, FormattedBody, UserTime, PostName, Subject, IsApproved from cs_Posts where PostLevel = 1 and SectionID = @sectionid and UserID=@userid",
                            conn))
                {
                    cmd.Parameters.Add(new SqlParameter("@sectionid", sectionid));
                    cmd.Parameters.Add(new SqlParameter("@userid", userid));

                    using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
                    {
                        while (rdr.Read())
                        {
                            MigratorPost post = new MigratorPost();

                            post.PostID            = Convert.ToInt32(rdr["PostID"]);
                            post.Author            = rdr["PostAuthor"] as string;
                            post.Body              = rdr["FormattedBody"] as string;
                            post.CreatedOn         = Convert.ToDateTime(rdr["UserTime"]);
                            post.Name              = rdr["PostName"] as string;
                            post.Subject           = rdr["Subject"] as string;
                            post.TagsAndCategories = GetTags(Convert.ToInt32(rdr["PostID"]));
                            post.IsPublished       = Convert.ToBoolean(rdr["IsApproved"].ToString());

                            posts.Add(post);
                        }

                        rdr.Close();
                    }
                }

                conn.Close();
            }

            // add the connection string to cache
            ZCache.MaxCache("MigratorConnectionString", _databaseConnString);

            return(posts);
        }
Esempio n. 3
0
        public List <MigratorPost> GetPosts()
        {
            // do some manual cleanup of the wordpress export
            _encodedFile = _encodedFile.Replace("<wp:comment_content>", "<wp:comment_content><![CDATA[");
            _encodedFile = _encodedFile.Replace("</wp:comment_content>", "]]></wp:comment_content>");

            _encodedFile = _encodedFile.Replace("<wp:comment_content><![CDATA[<![CDATA", "<wp:comment_content><![CDATA[");
            _encodedFile = _encodedFile.Replace("]]>]]></wp:comment_content>", "]]></wp:comment_content>");

            _encodedFile = _encodedFile.Replace("<wp:comment_author>", "<wp:comment_author><![CDATA[");
            _encodedFile = _encodedFile.Replace("</wp:comment_author>", "]]></wp:comment_author>");

            _encodedFile = _encodedFile.Replace("<wp:comment_author><![CDATA[<![CDATA[", "<wp:comment_author><![CDATA[");
            _encodedFile = _encodedFile.Replace("]]>]]></wp:comment_author>", "]]></wp:comment_author>");

            _encodedFile = _encodedFile.Replace("<wp:comment_author_url>", "<wp:comment_author_url><![CDATA[");
            _encodedFile = _encodedFile.Replace("</wp:comment_author_url>", "]]></wp:comment_author_url>");

            _encodedFile = _encodedFile.Replace("<wp:comment_author_url><![CDATA[<![CDATA", "<wp:comment_author_url><![CDATA[");
            _encodedFile = _encodedFile.Replace("]]>]]></wp:comment_author_url>", "]]></wp:comment_author_url>");

            _encodedFile = _encodedFile.Replace("<wp:comment_author_email>", "<wp:comment_author_email><![CDATA[");
            _encodedFile = _encodedFile.Replace("</wp:comment_author_email>", "]]></wp:comment_author_email>");

            _encodedFile = _encodedFile.Replace("<wp:comment_author_email><![CDATA[<![CDATA",
                                                "<wp:comment_author_email><![CDATA[");
            _encodedFile = _encodedFile.Replace("]]>]]></wp:comment_author_email>", "]]></wp:comment_author_email>");

            var posts    = new List <MigratorPost>();
            var comments = new List <MigratorComment>();

            XmlDocument doc = new XmlDocument();

            doc.LoadXml(_encodedFile);

            XmlNamespaceManager mgr = new XmlNamespaceManager(doc.NameTable);

            mgr.AddNamespace("content", "http://purl.org/rss/1.0/modules/content/");
            mgr.AddNamespace("wp", "http://wordpress.org/export/1.0/");
            mgr.AddNamespace("dc", "http://purl.org/dc/elements/1.1/");

            XmlNode node = doc.SelectSingleNode("/rss/channel");

            foreach (XmlNode itemNode in node.SelectNodes("item"))
            {
                if (itemNode.SelectSingleNode("wp:post_type", mgr).InnerText == "post" &&
                    itemNode.SelectSingleNode("wp:status", mgr).InnerText == "publish")
                {
                    MigratorPost post = new MigratorPost();

                    post.PostID    = Convert.ToInt32(itemNode.SelectSingleNode("wp:post_id", mgr).InnerText);
                    post.Author    = itemNode.SelectSingleNode("dc:creator", mgr).InnerText;
                    post.Body      = itemNode.SelectSingleNode("content:encoded", mgr).InnerText;
                    post.CreatedOn = Convert.ToDateTime(itemNode.SelectSingleNode("pubDate").InnerText);
                    post.Name      = itemNode.SelectSingleNode("wp:post_name", mgr).InnerText;
                    post.Subject   = itemNode.SelectSingleNode("title").InnerText;

                    // tags
                    foreach (XmlNode catNode in itemNode.SelectNodes("category"))
                    {
                        if (catNode.Attributes["domain"] != null &&
                            catNode.Attributes["domain"].Value == "tag")
                        {
                            post.TagsAndCategories = new List <String>();

                            var tags = catNode.InnerText.Split(' ');
                            foreach (string tag in tags)
                            {
                                post.TagsAndCategories.Add(tag);
                            }
                        }
                        else
                        {
                            post.TagsAndCategories = new List <string>();
                            post.TagsAndCategories.Add(catNode.InnerText);
                        }
                    }

                    post.IsPublished = true;

                    // comments : these are going to be stored in cache for wordpress types
                    foreach (XmlNode commentNode in itemNode.SelectNodes("wp:comment", mgr))
                    {
                        if (commentNode.SelectSingleNode("wp:comment_approved", mgr).InnerText == "1")
                        {
                            MigratorComment comment = new MigratorComment();

                            comment.PostID      = post.PostID;
                            comment.Body        = commentNode.SelectSingleNode("wp:comment_content", mgr).InnerText;
                            comment.PublishedOn = Convert.ToDateTime(commentNode.SelectSingleNode("wp:comment_date", mgr).InnerText);
                            comment.IPAddress   = commentNode.SelectSingleNode("wp:comment_author_IP", mgr).InnerText;

                            comment.WebSite     = commentNode.SelectSingleNode("wp:comment_author_url", mgr).InnerText;
                            comment.UserName    = commentNode.SelectSingleNode("wp:comment_author", mgr).InnerText;
                            comment.Email       = commentNode.SelectSingleNode("wp:comment_author_email", mgr).InnerText;
                            comment.IsPublished = true;

                            comments.Add(comment);
                        }
                    }

                    posts.Add(post);
                }
            }

            // add the comments to cache
            ZCache.MaxCache("MigratorComments", comments);

            return(posts);
        }
Esempio n. 4
0
        public List <MigratorPost> GetPosts()
        {
            string allXmlPosts    = MergePostFiles();
            string allXmlFeedback = MergeFeedbackFiles();

            var posts    = new List <MigratorPost>();
            var comments = new List <MigratorComment>();

            XmlDocument doc = new XmlDocument();

            doc.Load(new StreamReader(allXmlPosts));

            XmlDocument doc2 = new XmlDocument();

            doc2.Load(new StreamReader(allXmlFeedback));

            XmlNamespaceManager mgr = new XmlNamespaceManager(doc.NameTable);

            XmlNode node = doc.SelectSingleNode("Posts", mgr);

            XmlNamespaceManager mgr2 = new XmlNamespaceManager(doc2.NameTable);

            XmlNode node2 = doc2.SelectSingleNode("Feedback", mgr2);

            //foreach (XmlNode catNode in node.SelectNodes("categories/category"))
            //{
            //    BlogMLTag t = new BlogMLTag();
            //    t.Id = catNode.Attributes["id"].Value;

            //    if (catNode.SelectSingleNode("title") == null)
            //        t.Description = catNode.Attributes["id"].Value;
            //    else
            //        t.Description = catNode.SelectSingleNode("title").InnerText;

            //    tags.Add(t);
            //}

            int postId = 100;

            // grab the dasBlog mapping table from the cache if it already exists
            // so we can add to it, otherwise create a new object
            var permalinkMapping = ObjectManager.Get <List <PermalinkMap> >("dasBlogPermalinks");

            if (permalinkMapping == null)
            {
                permalinkMapping = new List <PermalinkMap>();
            }

            foreach (XmlNode itemNode in node.SelectNodes("Entries/Entry"))
            {
                if (itemNode.SelectSingleNode("IsPublic") == null || itemNode.SelectSingleNode("IsPublic").InnerText == "true")
                {
                    MigratorPost post = new MigratorPost();

                    post.PostID = postId;
                    postId++;

                    post.LegacyID  = itemNode.SelectSingleNode("EntryId").InnerText;
                    post.Body      = itemNode.SelectSingleNode("Content").InnerText;
                    post.CreatedOn = Convert.ToDateTime(itemNode.SelectSingleNode("Created").InnerText);
                    if (itemNode.SelectSingleNode("Categories") != null)
                    {
                        string categoryText = itemNode.SelectSingleNode("Categories").InnerText;
                        categoryText = categoryText.Replace('|', ';');
                        var categories = categoryText.Split(';');

                        post.TagsAndCategories = new List <string>();
                        foreach (string c in categories)
                        {
                            if (post.TagsAndCategories.Contains(c) == false)
                            {
                                post.TagsAndCategories.Add(c);
                            }
                        }
                    }

                    if (itemNode.SelectSingleNode("Title") == null)
                    {
                        post.Name = "";
                    }
                    else
                    {
                        post.Name = itemNode.SelectSingleNode("Title").InnerText;
                    }

                    if (itemNode.SelectSingleNode("Subject") == null)
                    {
                        post.Subject = post.Name;
                    }
                    else
                    {
                        post.Subject = itemNode.SelectSingleNode("Subject").InnerText;
                    }

                    post.IsPublished = true;

                    //        // tags
                    //        post.TagsAndCategories = new List<String>();

                    //        foreach (XmlNode catNode in itemNode.SelectNodes("categories/category"))
                    //        {
                    //            string catId = catNode.Attributes["ref"].Value;

                    //            BlogMLTag cat = tags.Find(delegate(BlogMLTag t)
                    //                                        {
                    //                                            return t.Id == catId;
                    //                                        });

                    //            if (cat != null)
                    //                post.TagsAndCategories.Add(cat.Description);
                    //        }

                    // store the post id and name in a url map so we can look this up
                    // in the dasBlog301 plugin
                    PermalinkMap permalinkMap = new PermalinkMap(post.LegacyID, post.Name);
                    if (permalinkMapping.Contains(permalinkMap) == false)
                    {
                        permalinkMapping.Add(permalinkMap);
                    }

                    posts.Add(post);
                }
            }

            ObjectManager.Save(permalinkMapping, "dasBlogPermalinks");

            foreach (XmlNode commentNode in node2.SelectNodes("*", mgr2))
            {
                if (commentNode.Name == "Trackings")
                {
                    foreach (XmlNode trackingNode in commentNode.SelectNodes("*"))
                    {
                        MigratorComment comment = new MigratorComment();

                        MigratorPost p = posts.Find(
                            delegate(MigratorPost c)
                        {
                            return(c.LegacyID.ToUpperInvariant() ==
                                   trackingNode.SelectSingleNode("TargetEntryId").InnerText.ToUpperInvariant());
                        });

                        if (p != null)
                        {
                            comment.PostID = p.PostID;
                        }

                        comment.Body = trackingNode.SelectSingleNode("TargetTitle") != null
                                                                       ? trackingNode.SelectSingleNode("TargetTitle").InnerText
                                                                       : "";

                        comment.PublishedOn = Convert.ToDateTime("01/01/1900");

                        comment.WebSite  = trackingNode.SelectSingleNode("PermaLink").InnerText;
                        comment.UserName = trackingNode.SelectSingleNode("TargetTitle") != null
                                                                           ? trackingNode.SelectSingleNode("TargetTitle").InnerText
                                                                           : "";

                        comment.IsPublished = true;
                        comment.IsTrackback = true;

                        comments.Add(comment);
                    }
                }
                if (commentNode.Name == "Comments")
                {
                    foreach (XmlNode cmtNode in commentNode.SelectNodes("*", mgr2))
                    {
                        MigratorComment comment = new MigratorComment();

                        MigratorPost p = posts.Find(
                            delegate(MigratorPost c)
                        {
                            return(c.LegacyID.ToUpperInvariant() == cmtNode.SelectSingleNode("TargetEntryId").InnerText.ToUpperInvariant());
                        });

                        if (p != null)
                        {
                            comment.PostID = p.PostID;
                        }

                        if (cmtNode.SelectSingleNode("Content", mgr2) != null)
                        {
                            comment.Body = cmtNode.SelectSingleNode("Content", mgr2).InnerText;
                        }

                        comment.PublishedOn = Convert.ToDateTime(cmtNode.SelectSingleNode("Created", mgr2).InnerText);

                        comment.WebSite = cmtNode.SelectSingleNode("AuthorHomepage", mgr2) != null
                                                                          ? cmtNode.SelectSingleNode("AuthorHomepage", mgr2).InnerText
                                                                          : "";

                        comment.UserName    = cmtNode.SelectSingleNode("Author", mgr2).InnerText;
                        comment.Email       = cmtNode.SelectSingleNode("AuthorEmail", mgr2).InnerText;
                        comment.IsPublished = true;

                        comments.Add(comment);
                    }
                }
            }

            // add the comments to cache
            ZCache.MaxCache("MigratorComments", comments);

            return(posts);
        }