Import data to custom module using Import Toolkit

Khoa Nguyen asked on August 8, 2018 13:16

I would like to import data to custom module, but it did not show in toolkit.

Did i miss some setting ?

import toolkit module

Correct Answer

Peter Mogilnitski answered on August 10, 2018 20:33

Yeah. I get what you saying. I just did some tests. Yep, you are right it doesn't seems to list your module tables as a target, but it lists them as a source. Well here what you can try (do db back up first though):

Get your class: select classid, * from cms_class where classname like '%class_name_in_you_module%'
Temporary set it as a custom table: update cms_class set ClassIsCustomTable =1 where classid = ...
Try the Kentico import toolkit (it does work for custom tables.)
When done set ClassIsCustomTable to 0.

On the other hand there is SQL Server Import and Export Wizard which you can download and works fine with excel files.

P.S. Or your can do it directly from sql.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Peter Mogilnitski answered on August 8, 2018 16:04 (last edited on August 8, 2018 16:32)

You just need to get to the "tables" screen:

select all data objects instead of typical objects
select 'module' (or anything it doesn't matter you need to get to the "tables" screen)
select db
select the table that represent your class in your module for which you want import data.

0 votesVote for this answer Mark as a Correct answer

Khoa Nguyen answered on August 8, 2018 17:56

Hi Peter Mogilnitski,

I had selected all data objects instead of typical objects
Select moudle

Step 1 & 2 screenshoot

After click next, i did not see where to select db http://prntscr.com/kg9eob

0 votesVote for this answer Mark as a Correct answer

Arun Kumar answered on August 8, 2018 18:14 (last edited on August 8, 2018 18:15)

Select db is the 3rd step http://prntscr.com/kg9op3 and then select data in 4th step https://prnt.sc/kg9p7o

0 votesVote for this answer Mark as a Correct answer

Khoa Nguyen answered on August 9, 2018 03:10

Hi Arun Grazitti,

Your step 3 is select source of data not the target

I want to import from excel file to my custom module

0 votesVote for this answer Mark as a Correct answer

Khoa Nguyen answered on August 10, 2018 04:44

any one ?

0 votesVote for this answer Mark as a Correct answer

Peter Mogilnitski answered on August 10, 2018 16:54

I think 'select the target project' on the first step - that should automatically select your db.

0 votesVote for this answer Mark as a Correct answer

Khoa Nguyen answered on August 10, 2018 18:06

Hi Peter Mogilnitski,

It seem to be you are understood wrong my ideas.

I have created my custom module. And now i want to import data to that module.

Problem is when i stay in step 2, it not show in list module, so i couldn't select

http://prntscr.com/kh48r5

0 votesVote for this answer Mark as a Correct answer