I seem to get an compilation error when using this:

Member 'Umbraco.Core.ApplicationContext.Current.get' cannot be accessed with an instance reference; qualify it with a type name instead

So I did this:

public List<BlogPostsList> getPostList()
    {
        string name = "umbNewsItem";
        var contentType = ApplicationContext.Current.Services.ContentTypeService.GetContentOfContentType(string name );
        var nodes = ApplicationContext.Current.Services.ContentService.GetContentOfContentType(contentType.Id).Select(content => new Node(content.Id));

        return nodes.Select(node => new BlogPostNew()
        {
            Id = node.Id,
            Title = node.GetProperty("Title").ToNullSafeString(),
            Content = node.GetProperty("Content").ToNullSafeString(),
            Author = node.GetProperty("Author").ToNullSafeString(),
            PubDate = node.GetProperty("Publish date").ToNullSafeString()
        }).ToList();
    }

Because GetContentType isn't a valid method for ContentService.

I am still however getting an error but it's changed:

CS1513: } expected

Because GetContentType isn't a valid method for ContentService.

No, its a part of ContentTypeService, not ContentService.

ContentTypeService.GetContentType() method is a part of the ContentTypeService and you can pass in either a id (int) or an alias (string) https://our.umbraco.org/documentation/reference/Management/Services/ContentTypeService.

Looking at your code i see you are using the method ContentService.GetContentOfContentType() with a string parameter which is not supported according to https://our.umbraco.org/documentation/reference/Management/Services/ContentService, it should be an integer parameter for the id.

Did you copy the exact code I posted without any adjustments? Becaus that code works for me on Umbraco 7.4.2 and i get a list of all my blogposts. Maybe it might be a version issue? What version are you using?

Also, note that you are not supposed to create an instance of ApplicationContext, you access directly. The compilation errror you got initially indicates that you have created a instance of ApplicationContext.

Best of luck!!

I realized I made a bit of a stuff up with it, not to worry, I sorted that out:

public List<BlogPostsList> getPostList()
    {
        var contentType = ApplicationContext.Current.Services.ContentTypeService.GetContentType((string)"umbNewsItem");
        var nodes = ApplicationContext.Current.Services.ContentService.GetContentOfContentType(contentType.Id).Select(content => new Node(content.Id));

        return nodes.Select(node => new BlogPostNew()
        {
            Id = node.Id,
            Title = node.GetProperty("Title").ToNullSafeString(),
            Content = node.GetProperty("Content").ToNullSafeString(),
            Author = node.GetProperty("Author").ToNullSafeString(),
            PubDate = node.GetProperty("Publish date").ToNullSafeString()
        }).ToList();
    }

The only issue now is that it's not finding the Node namespace and I've used the using references on the Service pages.

Update

Never mind, I fixed that too, I wasn't using umbraco.NodeFactory;

It's throwing an issue saying that the object reference is not set to an instance of an object.

So everything is working except that it cant find the Node reference? Sounds close! :) Try add this:

using umbraco.NodeFactory;

Please let me know if this works out for you!

You're a star! That was an obvious miss there for me, but now I don't understand why this part is telling me that:

Object reference not set to an instance of an object.

return nodes.Select(node => new BlogPostsList()
        {
            Id = node.Id,
            Title = node.GetProperty("Title").ToString(),
            Content = node.GetProperty("Content").ToString(),
            Author = node.GetProperty("Author").ToString(),
            PublishDate = node.GetProperty("Publish date").ToString()
        })

New error:

CS1061: 'umbraco.interfaces.IProperty' does not contain a definition for 'ToNullSafeString' and no extension method 'ToNullSafeString' accepting a first argument of type 'umbraco.interfaces.IProperty' could be found (are you missing a using directive or an assembly reference?)

Thanks :)

Now I have ensured ToNullSafeString is working, for whatever reason it's not fetching the properties...

any ideas?

return nodes.Select(node => new BlogPostsList()
        {
            Id = node.Id,
            Title = node.GetProperty("umbTitle").ToNullSafeString(),
            Author = node.GetProperty("author").ToNullSafeString(),
            Content = node.GetProperty("content").ToNullSafeString(),
            PublishDate = node.GetProperty("publish date").ToNullSafeString()
        }).ToList();
    }

That's strange. Could you double check that you've given the correct alias for the contentType? I see in your code you wrote "umbNewsItem" and in the post header you wrote "umbNewsItems". Also check that the propertyAliases are correct. Can you debug the code in VS or something to make sure you get the correct nodes?

I'm pretty sure it's umbNewsItem.

When I change it to umbNewsItems it throws me an "object reference not set to an instance of an object" exception on line.

I think it's maybe the property strings which might be wrong?

Could be, have you double checked that the property string aliases are correct?

Checked it all, still pulling through null:

here is my entire class:

using ExportUmbracoBlogsPackage.Models;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Net;
using System.Web;
using System.Web.Mvc;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Umbraco.Core.Persistence;
using Umbraco.Web;
using Umbraco.Web.WebApi;
using Umbraco.Core;
using Umbraco.Core.Models;
using Umbraco.Core.Services;
using umbraco.NodeFactory;
using AutoMapper.Internal;

namespace ExportUmbracoBlogsPackage.App_Code
{
    public class ExportAllBlogsController : UmbracoAuthorizedApiController
    {
        StringBuilder sb = new StringBuilder();
        [System.Web.Http.AcceptVerbs("GET", "POST")]
        public void ExportAll()
        {
            List<BlogPostsList> BlogPostList = new List<BlogPostsList>();
            BlogPostList = getPostList();

            string attachment = "attachment; filename= BlogPosts.csv;";
            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.ClearHeaders();
            HttpContext.Current.Response.ClearContent();
            HttpContext.Current.Response.AddHeader("Content-Disposition", attachment);
            HttpContext.Current.Response.ContentType = "text/csv";
            HttpContext.Current.Response.AddHeader("Pragma", "public");
            HttpContext.Current.Response.CacheControl= "private";

            WriteColumnName();
            foreach (BlogPostsList post in BlogPostList)
            {
                WritePostInfo(post);
            }

            HttpContext.Current.Response.Flush();
            HttpContext.Current.Response.End();
        }

        private void WritePostInfo(BlogPostsList post)
        {
            AddComma(post.Title, sb);
            AddComma(post.Author, sb);
            AddComma(post.Content, sb);
            AddComma(post.PublishDate.ToString(), sb);
            HttpContext.Current.Response.Write(sb.ToString());
            HttpContext.Current.Response.Write(Environment.NewLine);
        }

        private void AddComma( string value, StringBuilder sb )
        {
            sb.Append(value.Replace(',', ' '));
            sb.Append(", ");
        }

        private void WriteColumnName()
        {
            string columnNames = "Title, Author, Content, Publish Date";
            HttpContext.Current.Response.Write(columnNames);
            HttpContext.Current.Response.Write(Environment.NewLine);
        }

        //public List<BlogPosts> getPostList()
        //{
        //    UmbracoDatabase db = ApplicationContext.DatabaseContext.Database;
        //    var select = new Sql("SELECT dataNtext FROM cmsPropertyData WHERE propertytypeid = 57;");
        //    List<BlogPosts> BlogPostList = new List<BlogPosts>();
        //    BlogPostList = db.Fetch<BlogPosts>(select);
        //    return BlogPostList;
        //}

        public List<BlogPostsList> getPostList()
        {
            var contentType = ApplicationContext.Current.Services.ContentTypeService.GetContentType("umbNewsItem");
            var nodes = ApplicationContext.Current.Services.ContentService.GetContentOfContentType(contentType.Id).Select(content => new Node(content.Id));

            return nodes.Select(node => new BlogPostsList()
            {
                Id = node.Id,
                Title = node.GetProperty((string)"title").ToNullSafeString(),
                Author = node.GetProperty((string)"author").ToNullSafeString(),
                Content = node.GetProperty((string)"bodyText").ToNullSafeString(),
                PublishDate = node.GetProperty((string)"publishDate").ToNullSafeString()
            }).ToList();
        }
    }
}

I'm not sure what's going on here, now I'm getting an object reference not set to an instance of an object on this line:

            sb.Append(value.Replace(',', ' '));

It's saying sb is not an instance of an object.

unfortunately not :( It just runs the script and nothing happens and the tab that open to run the script which downloads the csv file, returns a DNS error.

Yeah it is working if I remove Publish Date. hmm not entirely sure, also the sheet ends up looking like this:

http://pasteboard.co/N046g0E.png

Not sure why it's doing this, it's not finding the title or author data.

Hi Dennis,

I now have the publish date working, however it's still not pulling the data for the title or author. I have the alias correct for title, but I'm not sure what the alias for Author is, because it doesn't specifically say.

Figured out: I can use a userSelector datatype and I was missing text in the title section because the page title was being pulled through to the front end as the blog title. So I managed to sort that out, new problem is that my CSV has multiple rows of the same data.

Thanks, Jonathan

Awsome Jonathan, im happy to hear that it worked out for you!!! :)

Best of luck to you with the rest of this package!!

Have a great day!!