Custom Table Import

John Burch asked on May 13, 2014 10:33

Is there a way to allow the cmsdesk user to import data into a custom table from and excel spreadsheet?

Recent Answers


Brenden Kehren answered on May 13, 2014 11:08

You have a few options, but in short, you'd have to write a custom module for that. I've done this before for CSV and works great.

Another option is to use the Kentico Import Toolkit if you have the Ultimate license. This gives you a user interface to perform the import but requires the user to know some advanced things (connection string, table names, etc.). This would be something an administrator would do though.

Another option would be to create a scheduled task to pick up the csv or simply query a database and perform the insert/update to the custom table. I've done this as well and seems to work the best because it doesn't require any user intervention.

0 votesVote for this answer Mark as a Correct answer

Yehuda Lando answered on May 13, 2014 15:44

You can also use this

0 votesVote for this answer Mark as a Correct answer

Sunil Sharma answered on September 17, 2014 16:53

BRENDEN KEHREN : Another option would be to create a scheduled task to pick up the csv or simply query a database and perform the insert/update to the custom table.

Can you share any example of this ?

0 votesVote for this answer Mark as a Correct answer

Ivana Liptakova answered on September 19, 2014 13:43 (last edited on September 19, 2014 13:43)

Hi,

you can create a custom scheduled task and use custom table API to insert data. The API examples you can find in you Kentico inatallation in API Examples -> Modules -> Development -> Custom tables

Best regards,

Ivana Tomanickova

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.