|
Home > Archive > Microsoft Content Management Server > August 2005 > tracing nodes(pages) inside MCMS content repository
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
tracing nodes(pages) inside MCMS content repository
|
|
| Nilofar 2005-08-23, 7:53 am |
| Good day,
I'm trying to trace some pages inside MCMS database (I have several daily
backups)in order to see what has happned to them during a period of time, my
question is how do I distinguish between an unpublished and a published page?
I tought I had found a role that gives me a list on unpublished pages, but
it is not true all the times:
in table NODE when isCheckedOut = 1 and approvalstatus = 0 and approvedwhen
is null och displayname is null , then the page is unpublished.
any advices how to trace this, cause NodeGuids seem to change inside NODE
table and a page has serveral posts(rows) inside the same table, but no posts
in table CHANGETABLE
//thank you
| |
| Stefan [MSFT] 2005-08-23, 7:53 am |
| Hi Nilofar,
touching the MCMS database directly will break the MCMS support boundaries.
You should never do this.
The only allowed method to access the MCMS repository content is through the
MCMS publishing API.
In addition the schema is not documented and changes between hotfixes and
service packs without notice. So code written against a current schema can
break with the next hotfix you install.
Here are some articles you might want to read on this topic:
http://blogs.technet.com/stefan_gos.../16/396647.aspx
http://blogs.technet.com/stefan_gos..._API_Part1.aspx
http://blogs.technet.com/stefan_gos.../27/408245.aspx
http://blogs.technet.com/stefan_gos.../27/408247.aspx
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------
"Nilofar" <Nilofar@discussions.microsoft.com> wrote in message
news:450B9B78-185C-424C-A568-E2544E4C884D@microsoft.com...
> Good day,
> I'm trying to trace some pages inside MCMS database (I have several daily
> backups)in order to see what has happned to them during a period of time,
> my
> question is how do I distinguish between an unpublished and a published
> page?
> I tought I had found a role that gives me a list on unpublished pages, but
> it is not true all the times:
> in table NODE when isCheckedOut = 1 and approvalstatus = 0 and
> approvedwhen
> is null och displayname is null , then the page is unpublished.
> any advices how to trace this, cause NodeGuids seem to change inside NODE
> table and a page has serveral posts(rows) inside the same table, but no
> posts
> in table CHANGETABLE
> //thank you
| |
| Nilofar 2005-08-23, 5:53 pm |
| Thank you Stefan for your answer,
ofcource I'm just testing and this is not in production, I'm just looking
into restored backups
localy on my machine. The thing is that some pages have been unpublished
without any known reason, I'm just checking if there is some thing somebody
has done that make this possible, expiryDate is set to 3000-01-01 so it
shouldn't be a problem... no other scripts/paches has been run at that time
either on the server...
thanks again
"Stefan [MSFT]" wrote:
> Hi Nilofar,
>
> touching the MCMS database directly will break the MCMS support boundaries.
> You should never do this.
>
> The only allowed method to access the MCMS repository content is through the
> MCMS publishing API.
>
> In addition the schema is not documented and changes between hotfixes and
> service packs without notice. So code written against a current schema can
> break with the next hotfix you install.
>
> Here are some articles you might want to read on this topic:
>
> http://blogs.technet.com/stefan_gos.../16/396647.aspx
>
> http://blogs.technet.com/stefan_gos..._API_Part1.aspx
> http://blogs.technet.com/stefan_gos.../27/408245.aspx
> http://blogs.technet.com/stefan_gos.../27/408247.aspx
>
> Cheers,
> Stefan
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> New to MCMS?
> Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
> ----------------------
>
>
> "Nilofar" <Nilofar@discussions.microsoft.com> wrote in message
> news:450B9B78-185C-424C-A568-E2544E4C884D@microsoft.com...
>
>
>
| |
| Stefan [MSFT] 2005-08-23, 5:53 pm |
| Hi Nilofar,
if the item is unpublished, please open it in webauthor and check the
current state.
That should give you a good indication why it is unpublished.
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------
"Nilofar" <Nilofar@discussions.microsoft.com> wrote in message
news:46FAA078-9E7E-40FD-8631-0F8E558A1119@microsoft.com...[vbcol=seagreen]
> Thank you Stefan for your answer,
> ofcource I'm just testing and this is not in production, I'm just looking
> into restored backups
> localy on my machine. The thing is that some pages have been unpublished
> without any known reason, I'm just checking if there is some thing
> somebody
> has done that make this possible, expiryDate is set to 3000-01-01 so it
> shouldn't be a problem... no other scripts/paches has been run at that
> time
> either on the server...
> thanks again
>
> "Stefan [MSFT]" wrote:
>
|
|
|
|
|