I'm using CMS Import 3.7.7 to migrate some content from an Umbraco 6.2.6 site to an Umbraco 7.13.1 site.
Some of the nodes are failing on the bodyText field (an RTE field). I've stripped back the content to just content that errors, here are some examples:
<h3>When?</h3>
<p>Every Tuesday (except 16, 23 Dec and 17 Feb).</p>
<h2>Where?</h2>
<p>Meet by the potting shed, London Road estate, N10 8LK</p>
I can't see anything that would obviously cause a problem. When I leave the RTE empty these pages import without issue.
The error I'm getting is
Error :Conversion failed when converting from a character string to uniqueidentifier.
This is caused by an SQL exception I guess when trying to save the property data.
I've run the SQL profiler to capture some of the errors that I'm seeing during an import. I'm seeing errors around the following queries
Select id, text,Path FROm umbracoNode where uniqueID = 'filename.jpg'
Conversion failed when converting from a character string to uniqueidentifier.
Select propertyEditorAlias from cmsDataType where propertyEditorAlias is null
Invalid column name 'propertyEditorAlias'.
Select alias from cmsContentType where masterContentType is null
Invalid column name 'masterContentType'.
That last query is invalid as the cmsContentType table doesn't have a masterContentType column.
The last error doesn;r ring a bell, Sure you are still using the hotfix, no dll's on deploy? There is a tryparse now that checks first if the referenced item is a guid before starting to convert it.
You're absolutely right. I had originally installed the package via NuGet so when I restarted the site this afternoon it's used the old DLLs from NuGet.
Problems importing RTE content
Hi,
I'm using CMS Import 3.7.7 to migrate some content from an Umbraco 6.2.6 site to an Umbraco 7.13.1 site.
Some of the nodes are failing on the bodyText field (an RTE field). I've stripped back the content to just content that errors, here are some examples:
I can't see anything that would obviously cause a problem. When I leave the RTE empty these pages import without issue.
The error I'm getting is
This is caused by an SQL exception I guess when trying to save the property data.
Any ideas on this or is there anything I can try?
Thanks Richard
I've run the SQL profiler to capture some of the errors that I'm seeing during an import. I'm seeing errors around the following queries
That last query is invalid as the cmsContentType table doesn't have a masterContentType column.
Hi Richard,
This was a bug indeed and fixed in a hotfix to be included in 3.7.8 already.
If you install both packages below the error should be gone.
Cmismport package : https://www.dropbox.com/s/a2ooybno5qnspw1/cmsimport37_8.zip?dl=0 Umbraco data provider : https://www.dropbox.com/s/p0t0dkhfj2svey8/CMSImport.UmbracoDataProvider.zip?dl=0
Best,
Richard
Hi Richard,
Thanks for the prompt response.
I've given the new version a try and I've been able to import content that was previously erroring.
Thanks
Richard
I'm running the import of another document type at the moment and having checked the log file I'm seeing instances again of:
There is also the following information which hopefully may help:
The last error doesn;r ring a bell, Sure you are still using the hotfix, no dll's on deploy? There is a tryparse now that checks first if the referenced item is a guid before starting to convert it.
You're absolutely right. I had originally installed the package via NuGet so when I restarted the site this afternoon it's used the old DLLs from NuGet.
Thanks again.
is working on a reply...