Import Table

Theodoulos Iacovou asked on March 12, 2021 07:44

Hello guys ,

I am trying to import a table and I am getting the following error:

Could not update table 'Application' required for data class 'Application'. Table named 'Application' already exists but is not associated with this data class.

I checked in the database but this table does not exist.

Thank you

import table

Recent Answers

Jeroen Fürst answered on March 12, 2021 08:45

Hi Theodoulos,

How are you importing the table? Have you considered using the Kentico Import Toolkit?

Cheers, Jeroen

0 votesVote for this answer Mark as a Correct answer

Theodoulos Iacovou answered on March 12, 2021 09:04

Hello Jeroen,

I am importing the table through Sites >> Import sites or objects

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on March 12, 2021 14:38

It's most likely 1 of following items:

There's already a table in the database called "Applications" that was manually added. If so, remove it. If you can't remove it, then rename the table you're importing.
Your previous import failed and left the table in the database without creating a reference in the cms_class table.
The table name Application could be a reserved name within Xperience. I'd suggest trying to rename the table and try your import again.
Depending on the type of "table" you're trying to import, if it's a custom table, it would not be named "Application", they follow the naming convention of using a namespace and class name. So if your namespace was "custom" and your classname was "application", your table name would be "custom_application".

To get further information about your process, can you tell me what object you're trying to import? Technically speaking, you cannot import a table directly without it being directly attached to an Xperience object like a Page Type or a Custom Table.

0 votesVote for this answer Mark as a Correct answer