Exporting bulk invitation codes

kraiya

I would like to personally email our invitation codes instead of using the forum feature.

Is it possible to export a batch of codes so I can do this?

x00

you should be able just to populate the GDN_Invitation table, then send them off with a valid link. You would need to generate some unique ids. it depends how you are importing as to how you are doing it.

I would test a few first.

You can run

CREATE TRIGGER before_insert BEFORE INSERT ON GDN_Invitation FOR EACH ROW SET new.Code = uuid(), new.DateInserted = now();

to ensure you get new codes, and dates on insert.

then you can import a csv like so

\N,name1@email-server.com,\N,\N,\N,\N
\N,name2@email-server.com,\N,\N,\N,\N
\N,name3@email-server.com,\N,\N,\N,\N

then you want to send links of this format.

http://your-site.com/forum/entry/register/{Code}