We have a very unstable Umbraco 7.1.8 version intranet which we are looking to move away from however I would like the following:
* All site pages
* A csv / XML document that contains metadata relating to the site and pages.
The problem is if we attempt to install any packages on our existing Umbraco set up it falls over.
Does anyone know if there is a way to obtain this data through PowerShell or safer way through Umbraco or any other way.
If it was me, that stood with this problem, I´ll maybe do it this way:
I would create a new project. Create a new SQL User with only read access.
So for the new project I´ll go direct to the SQL and read up the data.
SELECT * from [dbo].[cmsDocument]
inner join [dbo].[cmsContentVersion]
on [dbo].[cmsContentVersion].[versionId] = [dbo].[cmsDocument].[versionId]
inner join [dbo].[cmsContent]
on [dbo].[cmsContentVersion].[nodeId] = [dbo].[cmsContent].[nodeId]
inner join [dbo].[umbracoNode]
on [dbo].[cmsContentVersion].[nodeId] = [dbo].[umbracoNode].[id]
where [dbo].[umbracoNode].[nodeObjectType] = 'C66BA18E-EAF3-4CFF-8A22-41B16D66A972' AND [dbo].[cmsDocument] .[newest] = '1' // only select Content
then now you can get the meta data
SELECT * from [dbo].[cmsPropertyData]
inner join [dbo].[cmsPropertyType]
on [dbo].[cmsPropertyData].[propertyTypeId] = [dbo].[cmsPropertyType].[id]
where [dbo].[cmsPropertyData].[versionId] = @0
Not it just to cast it to model and save it into a CSV file.
Are you able to create a new Template? If so, you could probably get away with handling it as an alternate template (i.e., going to /?alttemplate=templatename) and perform some code in that, which goes through all of the Content and writes XML or CSV instead of HTML... ?
Export Umbraco 7.1.8 pages and Metadata
Hi,
We have a very unstable Umbraco 7.1.8 version intranet which we are looking to move away from however I would like the following: * All site pages * A csv / XML document that contains metadata relating to the site and pages.
The problem is if we attempt to install any packages on our existing Umbraco set up it falls over.
Does anyone know if there is a way to obtain this data through PowerShell or safer way through Umbraco or any other way.
Kind Regards
Hello Evagelos,
Doesn´t sound good at all!
If it was me, that stood with this problem, I´ll maybe do it this way: I would create a new project. Create a new SQL User with only read access.
So for the new project I´ll go direct to the SQL and read up the data.
then now you can get the meta data
Not it just to cast it to model and save it into a CSV file.
Hi evangelos,
Are you able to create a new Template? If so, you could probably get away with handling it as an alternate template (i.e., going to
/?alttemplate=templatename) and perform some code in that, which goes through all of the Content and writes XML or CSV instead of HTML... ?/Chriztian
is working on a reply...