Ggthjy

Reverse string, can I make it faster?

In the late 1940’s to early 1950’s what technology was available that could melt a LOT of ice?

Leftbar without indentation

Single word request: Harming the benefactor

Are babies of evil humanoid species inherently evil?

My story is written in English, but is set in my home country. What language should I use for the dialogue?

How much attack damage does the AC boost from a shield prevent on average?

Good allowance savings plan?

How did the power source of Mar-Vell's aircraft end up with her?

Is "history" a male-biased word ("his+story")?

They call me Inspector Morse

Is there an elementary proof that there are infinitely many primes that are *not* completely split in an abelian extension?

Do Bugbears' arms literally get longer when it's their turn?

Replacing Windows 7 security updates with anti-virus?

If the Captain's screens are out, does he switch seats with the co-pilot?

Fourth person (in Slavey language)

Why does Captain Marvel assume the people on this planet know this?

How do I express some one as a black person?

Can you reject a postdoc offer after the PI has paid a large sum for flights/accommodation for your visit?

How strictly should I take "Candidates must be local"?

Why is Beresheet doing a only a one-way trip?

How to clip a background including nodes according to an arbitrary shape?

Meaning of ちはース

Built-In Shelves/Bookcases - IKEA vs Built

Exporting list of URLs

3

In SDL Web 8.5 is it possible to export a list of all URLs in a specific tree?

We're hoping to use this to cross-check an XML sitemap to ensure nothing that's live isn't missed out (as crawlers won't index anything with a direct link to it).

Thank you,

importexportservice

share

asked 5 hours ago

KJHKJH

161

New contributor

KJH is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

3

In SDL Web 8.5 is it possible to export a list of all URLs in a specific tree?

We're hoping to use this to cross-check an XML sitemap to ensure nothing that's live isn't missed out (as crawlers won't index anything with a direct link to it).

Thank you,

importexportservice

share

asked 5 hours ago

KJHKJH

161

New contributor

KJH is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

In SDL Web 8.5 is it possible to export a list of all URLs in a specific tree?

We're hoping to use this to cross-check an XML sitemap to ensure nothing that's live isn't missed out (as crawlers won't index anything with a direct link to it).

Thank you,

importexportservice

share

asked 5 hours ago

KJHKJH

161

New contributor

KJH is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 hours ago

KJHKJH

161

New contributor

KJH is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 hours ago

KJHKJH

161

New contributor

KJH is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 hours ago

KJHKJH

161

New contributor

KJH is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 hours ago

KJHKJH

161

2 Answers
2

active

oldest

votes

5

There is no 'out of the box' way via the GUI, but you can do this using the Core Service.

Something like the following code (which outputs a CSV) should give you a good start:

void Main()

{

    List<PageData> allPages = Client.GetList("tcm:25-1234-4", new OrganizationalItemItemsFilterData { Recursive = true, ItemTypes = new[] { ItemType.Page } }).Cast<PageData>().ToList();    

    foreach (PageData page in allPages)

    {

        OutputPageDetails(page.Id);

    }

}



void OutputPageDetails(string pageId)

{

    PageData page = (PageData)Client.Read(pageId, null);

    string livePagePublishUrl = Client.GetPublishUrl(pageId, "Live");

    Console.WriteLine($"{pageId}, "{page.Title}", "{livePagePublishUrl}"");

}

(P.S. You'll probably want to consider using Client.GetListXML(), rather than Cleint.GetList() for efficiency)

share|improve this answer

edited 25 mins ago

answered 4 hours ago

Jonathan WilliamsJonathan Williams

13k1753

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Generally speaking, GetListXML is not more efficient than GetList (as a matter of fact, the first one internally calls the second and then builds the list XML).
  
  – Rick Pannekoek
  58 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I assume the example TCM URI (tcm:25-1234-64) should actually be the ID (TCM URI or WebDAV URL) of a Publication rather than a Page ?
  
  – Rick Pannekoek
  56 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Good point, Rick. It should’ve been the TcmId of a Structure Group where we’re starting from (rather than a page). I’ve updated it now
  
  – Jonathan Williams
  24 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That’s interesting about ‘GetListXML()’ calling ‘GetList()’ internally. My concern was more about the amount of data coming ‘over the wire’ when working with a large list of objects (when using ‘GetList()’). I’ve never actually compared the two sizes though.
  
  – Jonathan Williams
  8 mins ago
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The amount of data for both types of lists can be optimized using the ListBaseColumns and AdditionalColumns properties of the list filter. In general, GetList results in so-called R6 XML going over the wire, whereas Get!istXML results in R5 XML. The latter is older, but a bit more compact (it heavily uses XML attributes rather than nested XML elements). So, indeed, GetListXML will result in a bit more data sent over the wire, but in many situations this is neglectable.
  
  – Rick Pannekoek
  13 secs ago
  

  
  
  
  

add a comment | 

1

Actually Jonathan's answer is just part of the solution. You should create 2 lists:

1. first list is the list created using Core Service API and this list
   is the list of URLs for pages that CM side thinks that are
   published.


2. Second list is list of page URLs created using Content Delivery API, and this list is the list of actually published pages.

In ideal world, these 2 lists should be identical, but in most cases they are not. Second list is the list of actually published pages on CD Environment, so you should in any case do the following:

• Create both lists


• compare them and make sure that they are in sync (if there are some URLs in first but not in second list, republish the page so that it indeed comes to CD side. If there is URL in second, but not in first list, it means that item is orphan, so you should create undeploy package and remove it from CD environment).

share|improve this answer

answered 1 hour ago

Marko MilicMarko Milic

4,67621145

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "485"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

KJH is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2ftridion.stackexchange.com%2fquestions%2f19871%2fexporting-list-of-urls%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

5

There is no 'out of the box' way via the GUI, but you can do this using the Core Service.

Something like the following code (which outputs a CSV) should give you a good start:

void Main()

{

    List<PageData> allPages = Client.GetList("tcm:25-1234-4", new OrganizationalItemItemsFilterData { Recursive = true, ItemTypes = new[] { ItemType.Page } }).Cast<PageData>().ToList();    

    foreach (PageData page in allPages)

    {

        OutputPageDetails(page.Id);

    }

}



void OutputPageDetails(string pageId)

{

    PageData page = (PageData)Client.Read(pageId, null);

    string livePagePublishUrl = Client.GetPublishUrl(pageId, "Live");

    Console.WriteLine($"{pageId}, "{page.Title}", "{livePagePublishUrl}"");

}

(P.S. You'll probably want to consider using Client.GetListXML(), rather than Cleint.GetList() for efficiency)

share|improve this answer

edited 25 mins ago

answered 4 hours ago

Jonathan WilliamsJonathan Williams

13k1753

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Generally speaking, GetListXML is not more efficient than GetList (as a matter of fact, the first one internally calls the second and then builds the list XML).
  
  – Rick Pannekoek
  58 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I assume the example TCM URI (tcm:25-1234-64) should actually be the ID (TCM URI or WebDAV URL) of a Publication rather than a Page ?
  
  – Rick Pannekoek
  56 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Good point, Rick. It should’ve been the TcmId of a Structure Group where we’re starting from (rather than a page). I’ve updated it now
  
  – Jonathan Williams
  24 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That’s interesting about ‘GetListXML()’ calling ‘GetList()’ internally. My concern was more about the amount of data coming ‘over the wire’ when working with a large list of objects (when using ‘GetList()’). I’ve never actually compared the two sizes though.
  
  – Jonathan Williams
  8 mins ago
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The amount of data for both types of lists can be optimized using the ListBaseColumns and AdditionalColumns properties of the list filter. In general, GetList results in so-called R6 XML going over the wire, whereas Get!istXML results in R5 XML. The latter is older, but a bit more compact (it heavily uses XML attributes rather than nested XML elements). So, indeed, GetListXML will result in a bit more data sent over the wire, but in many situations this is neglectable.
  
  – Rick Pannekoek
  13 secs ago
  

  
  
  
  

add a comment | 

5

There is no 'out of the box' way via the GUI, but you can do this using the Core Service.

Something like the following code (which outputs a CSV) should give you a good start:

void Main()

{

    List<PageData> allPages = Client.GetList("tcm:25-1234-4", new OrganizationalItemItemsFilterData { Recursive = true, ItemTypes = new[] { ItemType.Page } }).Cast<PageData>().ToList();    

    foreach (PageData page in allPages)

    {

        OutputPageDetails(page.Id);

    }

}



void OutputPageDetails(string pageId)

{

    PageData page = (PageData)Client.Read(pageId, null);

    string livePagePublishUrl = Client.GetPublishUrl(pageId, "Live");

    Console.WriteLine($"{pageId}, "{page.Title}", "{livePagePublishUrl}"");

}

(P.S. You'll probably want to consider using Client.GetListXML(), rather than Cleint.GetList() for efficiency)

share|improve this answer

edited 25 mins ago

answered 4 hours ago

Jonathan WilliamsJonathan Williams

13k1753

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Generally speaking, GetListXML is not more efficient than GetList (as a matter of fact, the first one internally calls the second and then builds the list XML).
  
  – Rick Pannekoek
  58 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I assume the example TCM URI (tcm:25-1234-64) should actually be the ID (TCM URI or WebDAV URL) of a Publication rather than a Page ?
  
  – Rick Pannekoek
  56 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Good point, Rick. It should’ve been the TcmId of a Structure Group where we’re starting from (rather than a page). I’ve updated it now
  
  – Jonathan Williams
  24 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That’s interesting about ‘GetListXML()’ calling ‘GetList()’ internally. My concern was more about the amount of data coming ‘over the wire’ when working with a large list of objects (when using ‘GetList()’). I’ve never actually compared the two sizes though.
  
  – Jonathan Williams
  8 mins ago
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The amount of data for both types of lists can be optimized using the ListBaseColumns and AdditionalColumns properties of the list filter. In general, GetList results in so-called R6 XML going over the wire, whereas Get!istXML results in R5 XML. The latter is older, but a bit more compact (it heavily uses XML attributes rather than nested XML elements). So, indeed, GetListXML will result in a bit more data sent over the wire, but in many situations this is neglectable.
  
  – Rick Pannekoek
  13 secs ago
  

  
  
  
  

add a comment | 

There is no 'out of the box' way via the GUI, but you can do this using the Core Service.

Something like the following code (which outputs a CSV) should give you a good start:

void Main()

{

    List<PageData> allPages = Client.GetList("tcm:25-1234-4", new OrganizationalItemItemsFilterData { Recursive = true, ItemTypes = new[] { ItemType.Page } }).Cast<PageData>().ToList();    

    foreach (PageData page in allPages)

    {

        OutputPageDetails(page.Id);

    }

}



void OutputPageDetails(string pageId)

{

    PageData page = (PageData)Client.Read(pageId, null);

    string livePagePublishUrl = Client.GetPublishUrl(pageId, "Live");

    Console.WriteLine($"{pageId}, "{page.Title}", "{livePagePublishUrl}"");

}

(P.S. You'll probably want to consider using Client.GetListXML(), rather than Cleint.GetList() for efficiency)

share|improve this answer

edited 25 mins ago

answered 4 hours ago

Jonathan WilliamsJonathan Williams

13k1753

void Main()

{

    List<PageData> allPages = Client.GetList("tcm:25-1234-4", new OrganizationalItemItemsFilterData { Recursive = true, ItemTypes = new[] { ItemType.Page } }).Cast<PageData>().ToList();    

    foreach (PageData page in allPages)

    {

        OutputPageDetails(page.Id);

    }

}



void OutputPageDetails(string pageId)

{

    PageData page = (PageData)Client.Read(pageId, null);

    string livePagePublishUrl = Client.GetPublishUrl(pageId, "Live");

    Console.WriteLine($"{pageId}, "{page.Title}", "{livePagePublishUrl}"");

}

share|improve this answer

edited 25 mins ago

answered 4 hours ago

Jonathan WilliamsJonathan Williams

13k1753

answered 4 hours ago

Jonathan WilliamsJonathan Williams

13k1753

answered 4 hours ago

Jonathan WilliamsJonathan Williams

13k1753

1

Actually Jonathan's answer is just part of the solution. You should create 2 lists:

1. first list is the list created using Core Service API and this list
   is the list of URLs for pages that CM side thinks that are
   published.


2. Second list is list of page URLs created using Content Delivery API, and this list is the list of actually published pages.

In ideal world, these 2 lists should be identical, but in most cases they are not. Second list is the list of actually published pages on CD Environment, so you should in any case do the following:

• Create both lists


• compare them and make sure that they are in sync (if there are some URLs in first but not in second list, republish the page so that it indeed comes to CD side. If there is URL in second, but not in first list, it means that item is orphan, so you should create undeploy package and remove it from CD environment).

share|improve this answer

answered 1 hour ago

Marko MilicMarko Milic

4,67621145

add a comment | 

1

Actually Jonathan's answer is just part of the solution. You should create 2 lists:

1. first list is the list created using Core Service API and this list
   is the list of URLs for pages that CM side thinks that are
   published.


2. Second list is list of page URLs created using Content Delivery API, and this list is the list of actually published pages.

In ideal world, these 2 lists should be identical, but in most cases they are not. Second list is the list of actually published pages on CD Environment, so you should in any case do the following:

• Create both lists


• compare them and make sure that they are in sync (if there are some URLs in first but not in second list, republish the page so that it indeed comes to CD side. If there is URL in second, but not in first list, it means that item is orphan, so you should create undeploy package and remove it from CD environment).

share|improve this answer

answered 1 hour ago

Marko MilicMarko Milic

4,67621145

add a comment | 

Actually Jonathan's answer is just part of the solution. You should create 2 lists:

1. first list is the list created using Core Service API and this list
   is the list of URLs for pages that CM side thinks that are
   published.


2. Second list is list of page URLs created using Content Delivery API, and this list is the list of actually published pages.

In ideal world, these 2 lists should be identical, but in most cases they are not. Second list is the list of actually published pages on CD Environment, so you should in any case do the following:

• Create both lists


• compare them and make sure that they are in sync (if there are some URLs in first but not in second list, republish the page so that it indeed comes to CD side. If there is URL in second, but not in first list, it means that item is orphan, so you should create undeploy package and remove it from CD environment).

share|improve this answer

answered 1 hour ago

Marko MilicMarko Milic

4,67621145

share|improve this answer

answered 1 hour ago

Marko MilicMarko Milic

4,67621145

answered 1 hour ago

Marko MilicMarko Milic

4,67621145

answered 1 hour ago

Marko MilicMarko Milic

4,67621145