We have a membership database of 1000 members, with typical personal data and payments, history and the like.
We publish a hard copy magazine every couple of months, and this needs to to be posted.
Currently we have to do a complete database download, and then sort manually the address data in a spread sheet, to get the address list, and then print envelopes.
This is very basic club management, and I can find no way of doing this directly from within CB. There are lots of ways to send e mails, but that is not what i want.
Can this be done?
I have been dscussion this with Nick and he asked we to put in this ticket. His last comment was
You can most likely just copy paste a user list to any excel sheet if you put some css code in your template.
Create a eserlist with all your information for a user (in the order you want it in for your envelope label) in column 1. Now disable searching for that userlist. Once done navigate to the userlist URL except append &tmpl=component&print=1. That will give you a print friendly version of the URL. You'll then want to use some CSS to format it better for printing, cutting, and pasting to the envelope (or however you prefer to go about it). Please see the below for examples.
Example URL: index.php?option=com_comprofiler&task=usersList&listid=4&tmpl=component&print=1
Example CSS:
CB really isn't designed to be an address book though. It's absolutely going to be best to just design a Joomla extension or a new CB plugin with a component page to display exactly what you need.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Same way you use any CSS, place it in your Joomla template CSS file or CB template CSS file. Keep in mind it's just an example and it isn't userlist specific so it will affect all userlists. The alternative is a code action on the userlist display trigger to append the CSS to the header dynamically with a conditional to check the listid.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.