Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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.
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.
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... ?
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted