Adding a user-created DB table to the custom tables.

Eoin Maguire asked on July 17, 2014 17:14

I think the best way for me to add a few tables that I've created outside of Kentico to Kentico's custom tables is by using the import tool.

However, when trying this is asks me for the custom table into which I want to import my data. Do I need to create a dummy table and import into that, are the two tables then linked somehow? Or am I going about this the wrong way?

I've got two tables which I created myself in SQL server, I want to get them into the list of custom tables in Kentico, along with all their data.

Thanks

This is Kentico 7.

custom tables

Recent Answers

Jim Spillane answered on July 17, 2014 17:28

You can create a custom table. On Step 2 follow the Use an existing database table instructions.

Creating custom tables

0 votesVote for this answer Mark as a Correct answer

Eoin Maguire answered on July 17, 2014 17:41

Is this using the Import toolkit or just creating a custom table and importing from there? I had through I should use the Import Toolkit, but maybe I was wrong?

0 votesVote for this answer Mark as a Correct answer

Jim Spillane answered on July 17, 2014 18:41

It is not using the Import toolkit. It is creating a custom table from an existing table in the database. So if you already have two tables in the database with data, you can create custom tables inside Kentico using them.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on July 17, 2014 18:43

You can do as Jim suggested an use an existing database table, although it requires the table to be in the Kentico database already. My suggestion would be to create the table you need without any of your custom fields from within the Kentico UI, then use the import toolkit to create the rest of the structure and import the data.

I used the "use existing table" function in v7 several times and found limitations to it. When I tried in v8.0.1 there were issues with it as well. I'm still not confident it's working properly so I stay away from it, plus you lose some functionality if you use Content Staging.

1 votesVote for this answer Mark as a Correct answer

Jim Spillane answered on July 17, 2014 19:00

If you have the choice, create the tables in Kentico first like Brenden says.

0 votesVote for this answer Mark as a Correct answer

Rananjay Singh answered on December 18, 2014 14:42

Now i am using kentico v8.1 and hotfix 15. And trying to create a custom table using "Use an existing database table" but it is not working. There where some issues.

0 votesVote for this answer Mark as a Correct answer

Martin Danko answered on December 23, 2014 16:59

Hi Rananjay,

what kind of issues where there? Are you getting any errors or exceptions?

Best regards, Martin

0 votesVote for this answer Mark as a Correct answer