SQL Action / Variation of CB Fields Integration

djackso1
OFFLINE
Junior Member
Posts: 30
Thanks: 0
Karma: 0

14 years 7 months ago #110879 by djackso1

SQL Action / Variation of CB Fields Integration was created by djackso1

I'm looking for suggestions on how to accomplish the following:

We purchase membership numbers from our parent organization. We receive the 10-digit numbers in a spreadsheet. The numbers are in sequential order. We have created a read-only text field in CB to hold this number. After a member registers, we manually edit their profile and add their membership number to the read-only text field. I'm looking for a way to automate this process.

The CB Fields Integration Plugin will almost work, except that we have 8 different membership types, and all of them need to assign membership numbers from the same base list.

I was thinking an SQL action may work. I can get the membership numbers into a database table, I'm just not sure how to sequentially assign them upon member registration.

Any suggestions are greatly appreciated. Thank you. -Dave

Please Log in to join the conversation.

krileon
Team Member
OFFLINE
Posts: 68482
Thanks: 9076
Karma: 1434

14 years 7 months ago #110890 by krileon

Replied by krileon on topic Re:SQL Action / Variation of CB Fields Integration

The plugins work on subscription, not simply on registration, etc..

You could just develop a new plugin to do this. My tutorials (see signature) cover Trigger usage and can help with creating a plugin to trigger on registration and do the query for you.

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 to join the conversation.

djackso1
OFFLINE
Junior Member
Posts: 30
Thanks: 0
Karma: 0

14 years 7 months ago #110916 by djackso1

Replied by djackso1 on topic Re:SQL Action / Variation of CB Fields Integration

Thanks a lot for the follow up. I have started to read your tutorials. In the event that this is too complicated for me, would you be interested in contracting for this?

Please Log in to join the conversation.

krileon
Team Member
OFFLINE
Posts: 68482
Thanks: 9076
Karma: 1434

14 years 7 months ago #110923 by krileon

Replied by krileon on topic Re:SQL Action / Variation of CB Fields Integration

djackso1 wrote:

Thanks a lot for the follow up. I have started to read your tutorials. In the event that this is too complicated for me, would you be interested in contracting for this?

Tutorial is designed to assist you in developing the plugin easily. An example is also provided. In the event this is not enough to develop to your needs you may contact me for custom development on my site. Please review contract information on my site.

Please Log in to join the conversation.

Moderators: beat, nant, krileon

Time to create page: 0.271 seconds

SQL Action / Variation of CB Fields Integration

Search

Login / Logout

Menu

User Menu