I'm having trouble importing simple data in CMSImport PRO 2.1.1 on Umbraco v 4.7.1
I've used CMSImport many times with different datasources but i can't seem to get it to import with this latest version. All records are retrieved and skipped, 00:00:00 duration. No extra information is given and the umbraco log doesn't show anything either. I've tried csv, xml and excel in the same way it used to work for me.
Does anyone know how to fix this or how to get some info on whats going wrong?
I think the upgrade from 1.2 to 2.1.1 is causing the issues. I think the database couldn't be updgraded by the package. You don't get any reports on that by the installer. What I would do is backup (in case you have data) and delete the cmsimport tables. And recreate them using the scripts mentioned in the user manual.
Running the script after deleting the cmsimport tables recreates the tables but also gives me these errors (and it's not working yet):
Msg 2627, Level 14, State 1, Line 71 Violation of PRIMARY KEY constraint 'PK_umbracoAppTree'. Cannot insert duplicate key in object 'dbo.umbracoAppTree'. The statement has been terminated. Msg 2627, Level 14, State 1, Line 71 Violation of PRIMARY KEY constraint 'PK_umbracoAppTree'. Cannot insert duplicate key in object 'dbo.umbracoAppTree'. The statement has been terminated. Msg 2627, Level 14, State 1, Line 72 Violation of PRIMARY KEY constraint 'PK_umbracoAppTree'. Cannot insert duplicate key in object 'dbo.umbracoAppTree'. The statement has been terminated. Msg 2627, Level 14, State 1, Line 72 Violation of PRIMARY KEY constraint 'PK_umbracoAppTree'. Cannot insert duplicate key in object 'dbo.umbracoAppTree'. The statement has been terminated.
Not the way i previously did, but keeping "Enable content updates" checked did! Apparently that was the problem, i kept unchecking it thinking it was not necessary.
Glad it's working now. Thanks for your fast response!
Sadly no. Maybe it's a weird problem with this particular website. I'll be using the package again soon on another website so if that turns out to have the same problem i'll let you know immediately!
All records retrieved and skipped
I'm having trouble importing simple data in CMSImport PRO 2.1.1 on Umbraco v 4.7.1
I've used CMSImport many times with different datasources but i can't seem to get it to import with this latest version. All records are retrieved and skipped, 00:00:00 duration. No extra information is given and the umbraco log doesn't show anything either. I've tried csv, xml and excel in the same way it used to work for me.
Does anyone know how to fix this or how to get some info on whats going wrong?
Otherwise awesome package btw.
Hi Harm-Jan,
I'm very interested in this issue since it should work out of the box. Anything in the UmbracoLog table?
Thanks,
Richard
Hi Richard,
Just this:
id userId NodeId Datestamp logHeader logComment
36947 0 0 2012-06-05 08:43:13.307 Custom Import DatasourceAlias:Excel file ended
36948 0 0 2012-06-05 08:43:13.307 Custom Import DatasourceAlias:Excel file started
id userId NodeId Datestamp logHeader logComment
36531 0 0 2012-06-04 15:33:40.907 Custom Import DatasourceAlias:Xml started
36532 0 0 2012-06-04 15:33:40.907 Custom Import DatasourceAlias:Xml ended
id userId NodeId Datestamp logHeader logComment
36523 0 0 2012-06-04 15:27:03.877 Custom Import DatasourceAlias:Csv started
36524 0 0 2012-06-04 15:27:03.877 Custom Import DatasourceAlias:Csv ended
Weird,
Is it possible to share your datasource with me? Did you upgrade the package or was this a fresh install?
Thanks,
Richard
This is the datasource in xlsx but i've tried xls, csv and xml as well.
https://dl.dropbox.com/u/83423543/DenHaagWijken.xlsx
I uninstalled CMSImport version 1.2 and bought and installed version 2.1.1
Thanks Harm-Jan,
I think the upgrade from 1.2 to 2.1.1 is causing the issues. I think the database couldn't be updgraded by the package. You don't get any reports on that by the installer. What I would do is backup (in case you have data) and delete the cmsimport tables. And recreate them using the scripts mentioned in the user manual.
Also check if all the files are copied correctly.
Hope this helps and if not please let me know.
Thanks,
Richard
Running the script after deleting the cmsimport tables recreates the tables but also gives me these errors (and it's not working yet):
Msg 2627, Level 14, State 1, Line 71
Violation of PRIMARY KEY constraint 'PK_umbracoAppTree'. Cannot insert duplicate key in object 'dbo.umbracoAppTree'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 71
Violation of PRIMARY KEY constraint 'PK_umbracoAppTree'. Cannot insert duplicate key in object 'dbo.umbracoAppTree'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 72
Violation of PRIMARY KEY constraint 'PK_umbracoAppTree'. Cannot insert duplicate key in object 'dbo.umbracoAppTree'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 72
Violation of PRIMARY KEY constraint 'PK_umbracoAppTree'. Cannot insert duplicate key in object 'dbo.umbracoAppTree'.
The statement has been terminated.
Those are the Umbraco menu items, all other tables got created?
These tables got created:
CMSImportCustomRelation
CMSImportMediaRelation
CMSImportRelation
CMSImportScheduledItems
CMSImportScheduledTask
CMSImportState
Cool and working now?
Not the way i previously did, but keeping "Enable content updates" checked did!
Apparently that was the problem, i kept unchecking it thinking it was not necessary.
Glad it's working now. Thanks for your fast response!
Harm
Weird,
Just reproduced your steps and all works as expected. Are you in Copenhagen next week? Maybe you can show me then,
Thanks,
Richard
Sadly no. Maybe it's a weird problem with this particular website. I'll be using the package again soon on another website so if that turns out to have the same problem i'll let you know immediately!
Thanks,
Harm
is working on a reply...