Print Address Labels for subscribers

[Spiker]

It would be awesome if there was a mod that allowed you to print address labels for current subscribers.

For example, if you have a printed newsletter and manage the annual subscriptions through vbulletin, you can print mailing labels directly from vbulletin and possibly have an expiration date next to their name.

If this would be way too hard does anyone know of a subscription manager that would so something like this (not associated with vbulletin)? Currently we have all memberships ending on Dec. 31st (if they sign up in june they pay for half a year) but would like to have memberships run 1 year from date of sign-up. However, it seems like a logistical nightmare to do this by hand as we have lots of members. Thanks

[misterhyde]

This would be a great tool for me. Can anyone point me in the right direction?

[ccaldwell]

I as well would love to see some report printing capability.

[Marco van Herwaarden]

The easiest would be to just select the data and use a PC application to print the labels.

[emailapphost]

I want this to.
Thanks.

[emailapphost]

Marco,
When you say "select the data" in vBulletin.

Do you mean to have a PC application access the data directly in the vBulletin database?
Or,
Do you mean to export it as a comma separated file?

Or something else?

[Marco van Herwaarden]

Whichever suits you.

Address information is not stored in vBulletin by default, so it will always be a custum task to retrieve the information and to print it.

[emailapphost]

Marco, thanks for helping in this,

I have added address fields in the "User Profile Fields", but it does not show up in the users signup page.
Is this how you add address fields?
How do you get it to appear on the singup page?

Is this data then stored in the database?

[Ted S]

The data is stored in a seperate table for user profile fields and can be pulled up through a query or in the user view page.

To get the fields to show in the signup page change them to either required or optional, but show during registration. This option can be found in the settings of each profile field (look for the drop down about 2/3rds down the page).

As far as getting this data into address labels, all you need to do is run a query for the custom fields to store address and perhaps the username if you plan to use that. You can copy the output into a text file, save it as .csv and use word or any other desktop publishing program to create labels from it.

An example query to fetch 5 userfields, the userid and username:

SELECT u.username,uf.userid,uf.field2 as address,uf.field3 as city,uf.field4 as state,uf.field5 as zipcode,uf.field6 as country
FROM userfield AS uf
LEFT JOIN user AS u ON(u.userid = uf.userid)
WHERE uf.field2 <> ''
LIMIT 5

This can be run through your AdminCP if you have SQL rights for your admin user. Be sure to add any table prefects before both userfield and user if necessary (user vb_userfield). Change the field numbers to whatever your actual settings are.

[emailapphost]

Ted (thanks a lot btw),

If I want to use the vBulletin database to keep internal administrative track of my newsletter subscribers payments, expirations etc, can I add fields in the db using using profile fields and manipulate this data using phpMyAdmin?

Is there a big risk of corrupt data and vBulletin corruption if I manipulate data (like address uppdates, passwords, etc) using phpMyAdmin?