best way to build a mailing list for newsletter with accessing data in another Database

Taun Brown asked on March 18, 2014 08:16

So what I am trying to evaluate is the Kentico newsletters over Informz and the challenge of getting our subscriber lists out of a iMIS database into Kentico for a Newsletter mailing list. What I was hoping is possible is that there is a way I can have the Kentico system run a SQL statement against the iMIS DB to pull the subscriber list. I thought this would be good for a scheduled task but I am not skilled in visual studio :( The reason I we want to pull the data out of iMIS if that we don't want to have to manage two membership database.

Any suggestion anyone can provide are greatly appreciated.

Recent Answers

Richard Sustek answered on March 18, 2014 08:41

Hi,

Thank you for your message.

Well, the easiest way to import subscribers si to use the built-in subscriber import tool -> link text

There is a section Import subscribers right in the Newsletter tool. You can see that there is a textarea where you can type in the subscribers - this is what you can use. According to valid expressions:

david.scott@localhost.local;David;Scott
mary.jones@example.com;;Jones
frank.maguire@localhost.local;Frank
monica@localhost.local

You can make an SQL query for your other database to get results in this format and then simply copy and paste it there.

Let me know if you have further questions.

Kind regards,

Richard Sustek

0 votesVote for this answer Mark as a Correct answer

Taun Brown answered on March 18, 2014 08:44

Thank you but what I like to do is remove the manual task from the process and have the system get the data automatically

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on March 19, 2014 10:20

Taun,

I've worked with iMIS before (actually converted it to Protech after working with iMIS for a year) and have written several scheduled tasks to import that type of data on a regular basis using the API.

If you'd like some additional help, let me know, bkehren at gmail dot com

0 votesVote for this answer Mark as a Correct answer