SharePoint Posts Ratings Migration

Hi All,
Recently our team had a requirement to migrate ratings.Below is a sample code to add ratings to ratings for an item.


public void AddPostItem(LRBlog blog, SiteMigrationConfiguration siteMigrationConfiguration)
        {
            try
            {
                Console.WriteLine(DateTime.Now.ToShortTimeString() + "Adding blog post, post id :");
                List list = clientContext.Web.Lists.GetByTitle(siteMigrationConfiguration.BlogPostListName);
                ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation();
                ListItem listItem = list.AddItem(itemCreateInfo);
                listItem["Title"] = blog.title;
                listItem["Body"] = HtmlAgilityReader.ProcessContent(System.Web.HttpUtility.HtmlDecode(blog.content), siteMigrationConfiguration.BlogImageListName, clientContext);
                listItem["PublishedDate"] = blog.SpDisplayDate;
                listItem["Created"] = blog.SpCreateDate;
                listItem["Modified"] = blog.SpModifiedDate;
                //Set Rating values
                listItem["AverageRating"] = blog.avgRating;
                if (blog.ratings != null)
                {
                    listItem["RatingCount"] = blog.ratings.Count();
                    FieldUserValue[] user = new FieldUserValue[blog.ratings.Count()];
                    string ratings = string.Empty;
                    for (int i = 0; i < blog.ratings.Count(); i++)
                    {
                        var rating = blog.ratings[i];
                        ratings = ratings + rating.score + ",";
                        user[i] = SPUserPermissionHelper.GetUsers(rating.userId.ToString(), siteMigrationConfiguration.BlogSiteURL);
                    }

                    if (user.Length > 0)
                    {
                        listItem["RatedBy"] = user;
                        listItem["Ratings"] = ratings;
                    }

                }
                listItem.Update();
                clientContext.Load(list);
                clientContext.ExecuteQuery();
                /// Microsoft.Office.Server.ReputationModel.Reputation.SetRating(clientContext, list.Id.ToString(), listItem.Id, 5);
                FieldUserValue author = SPUserPermissionHelper.GetUsers(blog.createdBy.ToString(), clientContext.Url);
                FieldUserValue editor = SPUserPermissionHelper.GetUsers(blog.modifiedBy.ToString(), clientContext.Url);
                Console.WriteLine(DateTime.Now.ToShortTimeString() + "setting permission on  Blog idid :" + blog.entryId);

                SPUserPermissionHelper.SetItemLevelPermisionfromRole(author, listItem, clientContext, blog.permissions);
                foreach (var comment in blog.comments)
                {
                    List commentList = clientContext.Web.Lists.GetByTitle(siteMigrationConfiguration.BlogCommentListName);
                    ListItemCreationInformation itemCreateInfocomment = new ListItemCreationInformation();
                    ListItem commentItem = commentList.AddItem(itemCreateInfocomment);
                    commentItem["Title"] = comment.comment;//comment.;
                    commentItem["PostTitle"] = listItem.Id;
                    commentItem["Created"] = comment.SpCreateDate;
                    commentItem["Modified"] = comment.SpCreateDate;
                    FieldUserValue CommentBy = SPUserPermissionHelper.GetUsers(comment.userId.ToString(), clientContext.Url);
                    commentItem["Author"] = CommentBy;
                    commentItem["Editor"] = CommentBy;
                    commentItem.Update();
                }
                listItem["Author"] = author;
                listItem["Editor"] = editor;
                ////set item level permission
                listItem.Update();
                clientContext.ExecuteQuery();

                ReportGenerator.Instance.AddMigratedCount(EntityTypes.Blogs, 1);
            }
            catch (Exception ex)
            {
                ReportGenerator.Instance.AddFailedCount(EntityTypes.Blogs, 1, blog.entryId.ToString());
                Console.WriteLine(DateTime.Now.ToShortTimeString() + " " + "Exception occured. PLease check the log File");
                Logger.Log("Exception occured", Logger.LogType.Exception, "AddCalendarEvent", ex.StackTrace.ToString());
            }

        }

Comments

Post a Comment

Popular posts from this blog

Install Node.js without admin rights

Hi Folks, This is a copy paste version of one of the blogs which helped me.Giving due to credit to him.Just wanted a copy of the same with some minor updates.Below is the link for reference http://abdelraoof.com/blog/2014/11/11/install-nodejs-without-admin-rights/ Step 1: Get Node.exe First you will need to download the Windows Binary. You can get it from  Node.js download page  or  http://nodejs.org/dist/latest/ . For x64, you will have to download from the appropriate folder. Move the executable to a local folder. Step 2: Get NPM NPM (Node Package Manager) is the package manager for Node.js and you will need this for your development. You can download NPM from  https://github.com/npm/npm/releases  and extract the zip file to a local folder. Step 3: Copy the extracted files in a folder Copy npm.cmd from extracted folder  \npm\bin to the folder where node.exe resides Now move the extracted npm files in a folder named "node_modules\npm" in the same folder
Read more

Create a lean React Solution using Typescript

 Make sure you have node and npm installed Directory Setup 1. npm run init 2. create public and src folder 3. Add index.html in public folder 4. Add index.tsx in src folder Add Dependencies npm install react react-dom Add Dev Dependencies npm install typescript webpack webpack-cli webpack-dev-server ts-loader html-webpack-plugin  --save-dev  npm i --save-dev @types/react-dom typed-scss-modules  Add Configuration and Code Add code to src\index.tsx https://github.com/sagarpandey88/templates/blob/main/typescript-react/src/index.tsx Add webpack.config.js https://github.com/sagarpandey88/templates/blob/main/typescript-react/webpack.config.js Add tsconfig.json https://github.com/sagarpandey88/templates/blob/main/typescript-react/tsconfig.json Run the code npm run build npm run start
Read more

Replace all occurence of String in JavaScript

Hi All, I came across an issue in JavaScript where i was not able to replace all the occurrences of a string in another string. A simple string.replace would only replace the first occurence. str.replace("hello", 'hi'); We can make a small tweak in the existing code and make it work.Below is an example. str.replace(new RegExp('hello', 'g'), 'hi');
Read more