Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount! Get 20% off now with code SPOOKY-2024!

Snail mail address

11 years 9 months ago #218871 by MasterNABO
Snail mail address was created by MasterNABO
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.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48454
  • Thanks: 8280
  • Karma: 1443
11 years 9 months ago #218911 by krileon
Replied by krileon on topic Re: Snail mail address
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:
Code:
#cbUsersListInner > .cb_form, .cbUserListTable > thead, .cbUserListHrTop, .cbUserListHrBottom { display: none; } .cbUserListTable tbody tr, .cbUserListTable tbody tr td { border: 0; } .cbUserListTable tbody tr { border-bottom: 1px gray dashed; } .cbUserListTable .cbUserListCol1 { width: 100%; } .cbUserListTable .cbUserListCol2, .cbUserListTable .cbUserListCol3, .cbUserListTable .cbUserListCol4 { display: none; }
Example Output:


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.
Attachments:

Please Log in or Create an account to join the conversation.

11 years 9 months ago #219120 by MasterNABO
Replied by MasterNABO on topic Re: Snail mail address
Thank you for the response. Could you please clarify how to use the CSS.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48454
  • Thanks: 8280
  • Karma: 1443
11 years 9 months ago #219158 by krileon
Replied by krileon on topic Re: Snail mail address
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.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum