The CmsImportRelation is a database table. Could you check if the cmsimportrelation table is available in the database and can be accessed by the database user?
I checked in the main database (the one I create while installing Umbraco) and there is no table with that name. For your second question, I believe all read/write permissions are granted, if that's what you are asking.
Ok so the installer failed to install the database tables. You can solve this by installing the sql manually. Run the script as shown in section 10.2 of the documentation then it should work. Please let me know if you need more info.
Invalid object name 'CMSImportRelation'. error when importing
On my first .csv import for the Pro version I got the following error on all records:
Invalid object name 'CMSImportRelation'.
I looked at formatting of my csv fields and they look OK.
For the record, very similar files went successfully into the trial version of CMS Import.
Thanks in advance for your help!
The CmsImportRelation is a database table. Could you check if the cmsimportrelation table is available in the database and can be accessed by the database user?
Thanks,
Richard
I checked in the main database (the one I create while installing Umbraco) and there is no table with that name. For your second question, I believe all read/write permissions are granted, if that's what you are asking.
Thanks!
Hi Jonathan,
Ok so the installer failed to install the database tables. You can solve this by installing the sql manually. Run the script as shown in section 10.2 of the documentation then it should work. Please let me know if you need more info.
Thanks,
Richard
Thanks. Can you e-mail that script code to me? Copying it out of the PDF is tough. Thanks!
Sure, Just send you the sql.
Cheers,
Richard
is working on a reply...