Hi,

I've recently taken over a project and in all honestly it's terribly structured, especially for what the client wants me to create for them.

I'm rebuilding the old 7.0.3 project and am currently trying to import all the articles, members etc.

both websites are using SQL Server to store Umbraco's data.

What I'm failing with right now is trying to grab all the articles and just putting the bodyText field into my new documentType.

Using the Query:

SELECT *
FROM cmsPropertyData pd
INNER JOIN cmsPropertyType pt
    ON pt.id = pd.propertytypeid
INNER JOIN cmsContent c
    ON c.nodeId = pd.contentNodeId
INNER JOIN cmsContentType ct
    ON ct.nodeId = c.contentType
WHERE ct.alias = 'ArticleDetails' AND pt.Alias = 'bodyText'

in SSMS, it does grab the exact data i need. But when i try to use the same query in CMSImport i get:

"Error during load, check the logfile for details id "

log:

 2017-03-08 15:06:22,680 [P19968/D19/T23] ERROR CMSImport.Controls.CMSImport - CMSImport:Error during load of wizard
System.Data.DuplicateNameException: id
   at CMSImport.Extensions.Providers.DataProviders.DataProvider.GetColumnNames()
   at CMSImport.Extensions.Providers.DataProviders.DataProvider.get_Columns()
   at CMSImportLibrary.Providers.ImportProviders.Content.ContentImportProviderForm.Initialize(ImportState state)
   at CMSImport.Controls.CMSImport.(Int32)
   at CMSImport.Controls.CMSImport.OnPreRender(EventArgs e)

It does take about 2 seconds before coming up with the error. An initial thought being that it could have been timing out since there are 31,906 posts. But my gut tells me its my query that's incorrect for what CMS Import needs.

Is anyone able to point me in the right direction?

Exporting the content as a package from the site is not an option either.