Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

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


  • Ben Williams 5 posts 95 karma points
    Feb 23, 2018 @ 01:19
    Ben Williams
    0

    Remove all blog posts

    Is there a way to remove/delete all blog posts listed in the archive instead of having to click the select all checkbox and click Delete on each page. I'm testing BlogML data import and when there's 150+ blog posted entered, it gets time-consuming deleting all the entries back out.

    Kind regards,

    Ben Williams

    Copy Link
  • Dennis Aaen 4500 posts 18255 karma points admin hq c-trib
    Feb 23, 2018 @ 20:02
    Dennis Aaen
    0

    Hi Ben and welcome to Our, :)

    The archive node in the Articulate package are using the standard content list view. The great thing about this list view is that you can define how many items should be visible per page.

    So if you go the developer section --> Data Types --> Listview - Content then you will see something like this.

    enter image description here

    As you can see you can configure how many items that should be shown per page by changing the value in Page Size

    Hope this helps,

    /Dennis

    Copy Link
  • Ben Williams 5 posts 95 karma points
    Mar 13, 2018 @ 04:31
    Ben Williams
    0

    Hello Dennis. Thank you for the tip.

    Copy Link
  • Shannon Deminick 1526 posts 5272 karma points MVP 3x
    Feb 26, 2018 @ 07:03
    Shannon Deminick
    3

    Why not just delete the Archive node and then re-create it?

    Copy Link
  • Ben Williams 5 posts 95 karma points
    Mar 11, 2018 @ 04:28
    Ben Williams
    100

    Thank you Shannon. I did not realize I could do that.

    The workaround I previously came up with shortly after posting my question was to run this SQL Server script:

    declare @blogParentId int
set @blogParentId = 4777

update [myumbracodb].[dbo].[umbracoNode] set trashed = 1, 
    parentID = -20, 
    level = 1, 
    path = ('-1,-20,' + CONVERT(varchar, id)) 
    where parentid = @blogParentId
    Copy Link
  • Shannon Deminick 1526 posts 5272 karma points MVP 3x
    Mar 12, 2018 @ 03:49
    Shannon Deminick
    0

    You should definitely steer clear of running manual SQL scripts against Umbraco, without knowing all implications, this can cause you problems - least of which your caches and indexes will be out of sync.

    Copy Link
  • Ben Williams 5 posts 95 karma points
    Mar 13, 2018 @ 04:30
    Ben Williams
    0

    Thank you. I did not realize that caches and indexes would be out of sync. Looks like I have more learning to do.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft