Kryptronic Software Support Forum

makesachange · 09-07-2009 06:05:12

Hi,

I am trying to extract the email addresses of everyone who has chosen to be on our mailing list so I can then export this to an external mail management program.

I know this is simple but I can't remember how to do it. Could anyone please give me blow by blow instructions on how to do this please?

Thanks very much indeed,
Emma

dh783 · 09-07-2009 14:10:42

A down and dirty way is to export the khxc_user database table and only have the id and subscriptions fields exported. The subscriptions list is a coma separated list so you could limit it further by a where clause to exclude null entries, either way you would have a list to edit in a spreadsheet.

John

Last edited by dh783 (09-09-2009 12:11:07)

makesachange · 09-09-2009 09:53:18

Hi John,

I can understand what I need to do to open a CSL in Excel and then remove null entries, but I don't know how to export the CCP0_user database. Would you be good enough to give me a step by step explanation?

Thanks ever so much,
Emma

makesachange · 09-09-2009 10:10:43

Actually, I've got it (xbak22h5_khxc_users).

Thanks again,
Emma

Dave · 09-09-2009 10:36:31

That is a backup table. The correct table that is current is named khxc_users.

Kryptronic Software Support Forum

#1 09-07-2009 06:05:12

Extracting email addresses

#2 09-07-2009 14:10:42

Re: Extracting email addresses

#3 09-09-2009 09:53:18

Re: Extracting email addresses

#4 09-09-2009 10:10:43

Re: Extracting email addresses

#5 09-09-2009 10:36:31

Re: Extracting email addresses

Board footer