Category Archive: Association Management Solutions (AMS)

IPaaS For Associations

Jack Dempster April 7th, 2023 by

Most companies leverage a variety of software platforms to manage their businesses. For a small commercial business, this may be limited to one or two systems, like a CRM and marketing tool. While some associations manage to work solely within the confines of their AMS, most organizations also utilize multiple purpose-built solutions for specific needs (like an LMS, Event Management, CMS, etc.).

About a decade ago, the primary challenge for orgs using multiple systems was implementing single-sign-on (SSO) to allow members to login once and move between systems to complete tasks. That problem has largely been solved, especially with the advent of affordable identity providers (IdPs).

Now the challenge for most organizations who are using, or would like to use, disparate systems, is how to best integrate those systems and ensure that the connections are robust, reliable, and help the org best leverage the data stored in those systems.

New call-to-action

Integration Options

There are two main methods of integration: point-to-point and iPaaS (Integration Platform as a Service). While point-to-point integration can work well for simple use cases, it is not a scalable solution for larger organizations. With point-to-point integrations, you often end up with a web of integrations among systems as seen in the “Point to Point” Model below. If you want to change out a single system in the future, you will have to rebuilt multiple integrations.

With an iPaaS, all of your integrations run through the integration platform, providing a much more scalable solution as seen in the “Hub and Spoke “ model below.

“Point to Point” Model
“Point to Point” Model
iPaaS “Hub and Spoke” Model
iPaaS “Hub and Spoke” Model

Benefits of iPaaS

Organizations of all sizes are leveraging best of breed solutions and will continue to do so in the future.  An iPaaS is a much better option for associations, and here are a few reasons why:

Flexibility: iPaaS offers flexibility in terms of integration capabilities. It can integrate with a wide range of systems, including cloud-based and on-premises applications. This means you can connect all of your business systems, regardless of their location or type, via a single platform.

Scalability: As your business grows, so does your need for integration. Point-to-point integrations can become cumbersome and expensive to maintain as the number of connections increases. iPaaS, on the other hand, is designed to scale with your business. It can handle a large number of integrations without any additional effort or cost on your part.

Engagement Data: More and more associations are seeing the benefits of measuring member engagement, but one hurdle in real effective metrics and analysis can be the number of systems in place where engagement data is gathered.  An iPaaS can be leveraged to propvide a consolidated data lake/warehouse that can provide a holistic view of your members via your preferred business intelligence tools.

Simplicity: iPaaS simplifies the integration process by providing a single platform for all of your integration needs. This eliminates the need for multiple point-to-point integrations, which can be complex and time-consuming to set up and maintain. With iPaaS, you can manage all of your integrations in one place, making it easy to add or remove connections as needed.

Stability: Many iPaaS solutions include out of the box integration points to connect with commonly used systems.  And for edge cases where there is not an existing connector, it is typically fairly straightforward to implement a new one.  By leveraging an IPaaS provider’s expertise in implementing and monitoring integrations, you can increase uptime and lower the risk of broken connections.

Cost-effectiveness: Point-to-point integrations can be expensive to set up and maintain. Each connection requires specialized expertise and resources, which can quickly add up in terms of time and money. iPaaS can often offer a more cost-effective solution, especially as long term goals are considered. It provides a single platform for all of your integration needs, eliminating the need for multiple point-to-point integrations and the associated maintenance costs.

Security: iPaaS offers a higher level of security compared to point-to-point integrations. It uses secure protocols and encryption to protect data as it is transferred between systems. This ensures that your sensitive business information is kept safe and secure.

In conclusion, as your association explores how to best integrate disparate systems, exploring an iPaaS should be part of the process.  Be sure to consider all costs and benefits associated with both approaches – you might just be surprised how affordable some solutions are and how much more you can do with your data.

New call-to-action

The Advantages Of Online Strategic Planning

carol hamilton fusionSpan Team December 8th, 2021 by

Most people think of strategic planning as a marathon 8- or 10-hour or 2-day retreat. You process lots of information, discuss, debate and brainstorm. You have lunch brought in so you can work without a break. You fill flip chart after flip chart with ideas.

Then, around mid-afternoon, when it’s time to start making important decisions, you’ve hit cognitive load. You’re mentally and physically spent.

There Is A Better Way

​What if you took those grueling 8 or 10 or 12 hours and divided them into manageable 2- or 3-hour sessions, each of which has a contained set of goals and builds on the one before? What if you had time to reflect, think and process between sessions?

By holding shorter sessions via video conference over a period of time, we have found that organizations actually make progress more quickly and end up with better results. Doing one piece of the process at a time and giving participants a break between sessions can make your strategic planning more thoughtful, integrative and aligning. All of this is done virtually combining video conferencing with a collaborative tool to capture notes and ideas along the way.

There are many benefits to pacing strategic planning sessions and working virtually. Some of these include:

  • Working with more clear and defined goals for each session groups go further faster.
  • During the time between large group sessions, participants can fully flesh out their ideas on their own or with a few others, so each person’s perspectives will be part of the finished plan.
  • Pacing also allows the strategic planning committee or other leadership groups to do refinement between the large group planning sessions.
  • Groups reach alignment more easily and quickly because they’ve had the time and space to sift out the chaff and home in on what’s really important.
  • It also is often easier for volunteers to fit into their busy schedules.
  • AND so important to budget challenged nonprofit organizations – it saves all the cost of paying for everyone to travel to be together.

But What About Zoom Fatigue?

It seems like we are spending our lives on Zoom and other video conferencing systems these days. So the prospect of doing your whole strategic planning process online as well might fill you with dread. What differentiates a meeting you dread and one that gets you excited about the work you do? Think of all the bad meetings you have attended – whether in person or online what made those meetings boring and frustrating? Typically they are meetings with:

  • Have no clear purpose, goal and agenda
  • Without a clear purpose, a seemingly random group of people is brought together
  • No one has taken any time to prepare for the meeting, including the person who is leading it
  • The meeting is either way too short for the agenda assembled on the spot or way too long
  • Conversations meander in unconnected directions
  • No one knows what they are supposed to do after the meeting is over

 

A well facilitated online strategic planning process has the opportunity to be the opposite of what is on the list above.

  • Clear goals for each meeting,
  • One session building on the next,
  • Each session is appropriately scoped to have enough time for in depth discussions,
  • Notes are created in real time,
  • You leave with clear next steps and follow through.

But to have this success and translate the process online effectively, you will need to do a few things.

Plan Ahead & Educate Yourself

You will need to plan what tools you are using. You will need to make sure everyone is able to access the documents you will be referring to during the meeting, the files or system you will be using to capture notes and brainstorms, etc. Also be sure to plan for a lower tech plan B. You need to familiarize with the systems you are using to run the meeting. Take some time to play with the system before you pull the group together. Consider testing some features with a colleague and see what you can “break.”

Match Your Tech Tools With Your Participants

You may be excited about trying out the online brainstorming tool you just heard about but make sure that what you choose matches the skills of your participants. You want people focused on their strategic conversation not struggling to make the tool work. So for some groups Zoom and a google doc, and the occasional Jamboard, will be a perfect match. For others, Zoom (or another video conferencing tool) plus an online brainstorming tool like Miro or Mural will work great.

Educate Your Participants

You can try and avoid spending the first 10 minutes of the meeting getting everyone acquainted with the technology systems by creating a video or two that provides a quick overview. Loom is good for this and very easy to use. You might also give the group a small assignment that gets them into the tool you will use for note taking. Something as simple as asking them to open a google doc and write their name at the top of the document. Or, if you are using a more sophisticated tool such as Mural – have them do a check in process. This kick starts your check in at the beginning of the meeting and gives them the chance to play with the tool before the meeting without the same time pressure.

Distraction, Distraction, Distraction

It is hard enough to keep everyone on track when you are together in a room. Then add technology and distance. Your phone and email chirping in the background. Getting on Zoom and wondering whether your co-workers have pants on. Your kids or pets making a ruckus in the next room. Online meetings have to fight for people’s attention even more than in person.

Ask For Their Focus

When you meet online, everything else on the person’s computer or device is there to distract them. A simple step you can take at the beginning of each session is to ask them to close their extra tabs, email, notifications, etc. for the duration of the meeting. Remember to take breaks. Take a moment for everyone to get out of their chair and stretch.

Building Rapport Online

Over the past year and a half, there has been a lot written about the disadvantages of online meetings. Clearly you are missing out on a lot of body language and other non-verbal cues. If folks do not know how to turn off the self-view, it can be wearing and anxiety producing to stare at yourself for hours. Building rapport with people online is one of the things people often mention as a challenge in online meetings. Yet with some intention it is possible.

Connection Before Content

A good practice (whether in person or online) is to be sure to take a little bit of time at the beginning of the meeting to connect on a personal level before you jump into the meeting agenda. This could include a check in question such as an ice-breaker. Some people cringe when you mention icebreaker. Yet the question does not have to be “what Harry Potter character are you?” or “or [fill in the blank with a question you’ve been asked at beginning of a meeting that had nothing to do with the issues at hand]. It can be work-related.

With groups who do not know each other, making the question relatively safe is often a good place to start. What is the latest app you discovered and love? What is your superpower? What are you hoping we achieve today? If the group is large and you are afraid intros and icebreakers will take up a chunk of the meeting time, split people into smaller groups (2-4) and have them introduce themselves in their small group.

Creating Norms

If the group is going to be working together for a while, help them have a conversation about how they want to work together. What helps them work effectively in a group? What might get in the way working together online and remotely? How might they address those challenges? It may take a few rounds of brainstorming and refinement to come to a set of agreements that work for everyone. Yet having this list of agreements will help if the group runs into challenges.

Pause

Online it takes a little bit longer for people to jump into the conversation. They may hesitate wondering whether someone else is going to talk and not wanting to interrupt anyone. Rapport and trust will be lost if a person in the group does not feel like their voice is being heard. They may feel you are rushing through items without sufficient time for discussion.

A good practice as a meeting leader is to pose a question or discussion topic and then take a drink of water. Taking that drink will prevent you from continuing to talk and gives your meeting participants time to gather their thoughts and respond.

Pulse Checks

Do you really know whether everyone is with you and in agreement? During an online meeting it is even more important to check in more frequently with the group to make sure they understand:

  • What part of the agenda you are
  • what issue is being discussed
  • what document you are referring to…
  • whether they agree with the proposed next steps.

Don’t assume silence means agreement.

Once The Process Is Complete

A plan is just a plan – even when the document has strategic plan in the title. It’s not set in stone. It isn’t a tablet from on high. It’s a document that your group created itself and can tweak and adjust as you move forward.

The process of strategic planning itself brings clarity and alignment by creating an opportunity to talk and explore issues together. The less intensive pace of doing the process online brings greater opportunity for buy in, input and integration.

About Grace Social Sector & More Information

Carol Hamilton has more than 25 years of experience in the nonprofit and association sectors working with organizations with a range of missions. Carol trains frequently on leadership, strategy, organizational culture and design as well as innovation topics and is the host of the Mission: Impact podcast. She graduated from Swarthmore College and has her Masters in Organization Development from American University.

A strategic thinker, through her work with Grace Social Sector Consulting, Carol works with teams and organizations to envision and frame their future strategic direction. Practical in her approach, she helps organizations think through who is key to creating their future, how to gather insights from these stakeholders, consider the big picture, imagine new possibilities, come to agreement on their future goals and create an initial action plan to get started. She takes a human centered and appreciative approach in her work. She is also part of a consultant collective focused on diversity, equity and inclusion, All In Consulting.

50 Questions to Ask AMS Vendors During Product Selection

Avatar photo April 29th, 2021 by
Glasswithborderv2This blog was originally published on September 18, 2013.

Are you ready for a new Association Management System (AMS)? If you just answered ‘YES’ or ‘MAYBE’ then read on…

Finding the right AMS for your organization can be like Prince Charming finding Cinderella. Sure, you have a glass slipper – you know what you want. Now, how do you go about finding it?

Listed below are fifty questions to ask AMS vendors. These questions will help you eliminate the product(s) that are not for you, like Prince Charming placing the glass slipper on. Then you can narrow down your best options to find the perfect fit…your very own Cinderella!

(more…)

Your AMS Journey: Selection to Adoption – Step 12: We Are Live, Just Relax Right?

Noel-Shatananda April 1st, 2021 by

You are live, have gone through the go live challenges, and have worked on the other phases whereby the implementation project can be closed. What now?

Here are a few items to consider:

Expand Training

Spend time developing training materials, and put a system in place for keeping the training materials up to date as business processes change. Contemplate what new staff members will use to learn the AMS. Consider not relying on tribal knowledge to take you forward.

Keep Up With Updates

In the technology sphere, things are always changing. Establish a team within the organization that will keep up with the testing and adoption of current versions of the AMS and software patches.

Associations that make the effort to keep up with this tend to get the best return on investment from their AMS.

Adopt New Features

Software continuously evolves. Seriously consider adopting new features that are relevant to your business. While this can be a mini project in itself, it is worth the effort to ensure all data resides in a centralized repository. Ultimately, this will give you the most value.

Engage in the Community

Contemplate engaging in your AMS’ user community to have a voice in the new features that the AMS should include in its product roadmap. Work with other associations like yourself to push for an agenda that considers the advancements of the platform.

Be a Reference

If you are happy with your AMS, consider posting positive reviews and being a reference for your AMS vendor. The same applies to your systems integrator as well. Collaboration always pays off in the long run.

Thanks For Following Along!

While our AMS Journey is over, working with your new AMS will never stop! Check out the previous blogs in this series for a full list of resources and tips regarding your AMS selection and adoption.

For all of your CRM questions and needs, do not hesitate to reach out to our talented team here at fusionSpan!

New call-to-action

Your AMS Journey: Selection to Adoption – Step 11: Going Live, Implementation Fatigue, and Next Phases

Noel-Shatananda March 18th, 2021 by

Your organization has put countless hours of work and research into your new AMS, and now it is time to introduce it to members and stakeholders.

Go live day usually begins calm, but soon gets hectic and turns into a stressful few weeks. We warn our clients that AMS go lives are something that an association goes through once in 8 – 12 years, so approaching it with patience is crucial. The teams that have prepared rigorously obviously fare better. So, prepare, prepare, prepare!

Core Team is Key

Choosing the right core team at the very beginning, with adequate representation from all the various departments, will serve you well during the go-live weeks. These team members will be the champions helping their co-workers get acquainted with the new AMS and help relieve stress.

Establish a System

The weeks surrounding the AMS rollout can be stressful, and ensuring you have a defined system that is well publicized amongst the stakeholders is very beneficial. Here are some tips.

  • Assign core team members to departments as their Tier 1 support. Any question, issue or bug needs to be addressed with that core team member first.
  • The next level of escalation is to the project management team, which will decide the criticality and priority of the issue. The PM team will then decide to escalate further.
  • Once the PM team feels the issue requires escalation, it will be escalated to the team that is working on the issues and bugs. This is usually the team that the system integrators will be a part of.

If an established system is not devised, go live weeks will result in chaos, with people reporting issues to people who cannot bring it to a close. No forward momentum will only to lead to frustration and dissatisfaction with the new AMS platform.

Give It Time

Most go lives do not go exactly as planned. Our experience has led us to believe that a larger association can take up to 3 – 6 months before everything settles down, with the first 4 weeks being the toughest.

Setting the right expectations with the executive team and the entire staff helps tremendously. Sometimes letting the constituent base know in a limited fashion can be an option.

Acknowledge Fatigue

For most associations, the core team that is part of the implementation has a full time job in addition to the implementation. That is difficult to manage. It has worked well when executive management has appreciated the efforts of the core team in tangible ways. This tends to keep morale up.

Phase Slowly

We frequently see situations where certain items are pushed to be completed immediately after go live, since they could not be achieved during the execution phase. This approach needs to be thought through carefully.

If there are minor adjustments that are required for the go live to occur, that is acceptable; however, major changes or additions are discouraged. The staff has just learned a new way of operating on a new AMS, and changing things on them usually results in anxiety or feelings that the implementation process will never end.

Reach Out To fusionSpan Before Our Journey Ends!

The end of Your AMS Journey is almost here! Stay tuned for our final installment of the series in upcoming weeks.

In the meantime, don’t hesitate to reach out to fusionSpan for assistance with all of your AMS/CRM questions and needs!

New call-to-action

Your AMS Journey: Selection to Adoption – Step 10: Prepare To Go Live

Noel-Shatananda March 4th, 2021 by

The end of Your AMS Journey is in sight – you have undergone testing and training, and are now ready to prep for launch. In fact, preparing for go live is something the team has to keep in mind throughout the entire project. Here are some important items to consider:

Constituent Communication

We recommend that the association begin informing their constituents of the new AMS at least 3 – 4 months before the desired go-live date. The first communication should inform them of the fact that in 3 – 4 months time, they will be a new system and state a few advantages they will directly benefit from. One month from go-live, a second communication should go out to give more details around the date, potential down time, specific benefits as well as drum up enthusiasm about the new system. A third communication should be sent out to state the exact dates and any additional information needed ahead of launch.

Data Freeze Date

project planning

As part of preparing for the go live, determine a date on which all transactions in the system will be halted. This means that there will be no new transactions in the legacy system after that time. All transactions that need to occur will be recorded manually to be applied into the new AMS when it comes online.

Final Data Conversion

The final data migration begins on the data freeze date, and is expected to go until all the data is migrated to the new AMS and has been validated. The cycle 1 data migration that occurred earlier would have provided guidance on how long this activity should have taken.

Portal User Accounts

As part of the final data migration, all portal user accounts need to be created. Additionally, passwords need to be set to what they were in the legacy system, or a communication must be sent out to constituents asking them to reset their passwords.

Go/No-Go Decision

Once all the data is migrated, auditing of the data is complete and is deemed ready to move forward, the go, no-go decision is taken. This decision relies heavily on what items have been reported that the association can live with, have work arounds for and can fix post go live and those that are go live blockers.

Contemplate a Soft Launch

Considering the new AMS will be new to staff and your constituents, if your situation allows, you can contemplate taking a longer time to turn on the constituent facing portal and give staff time to get acquainted first. This splits the stress that staff will have to face day one having to answer an irate constituent on the phone, while still not being totally confident of where in the new AMS to get the information.

Contact fusionSpan For More!

For those following the series, we are nearing the conclusion of our Journey! The end is in sight, and we are close to delivering the long-awaited system both to members and internal stakeholders. Stay tuned for more as we outline the rollout phases of your platform, as well as final action items for you to be taking to conclude this project.

If you are seeking more regarding your AMS platform, or for any of your CRM questions in general, do not hesitate to contact our talented team here at fusionSpan today!

New call-to-action

How To Enable MFA For Your Salesforce Org

Avatar photo March 2nd, 2021 by

Beginning February 1, 2022, Salesforce will require customers to enable Multi-Factor Authentication (MFA) in order to access Salesforce products. In our opinion, this is a good move by Salesforce. We always recommend our clients to enable MFA on any and all of their IT systems that will support it.

For those interested in the thought behind Salesforce’s move, “Everything Admins Need to Know About the MFA Requirement” is a good read on the topic.

Therefore, starting next February, you and your staff will need to use some sort of MFA to log in to Salesforce. Luckily, there are several ways to comply with this new requirement. Read on to see a few of the fusionSpan team’s favorite options for meeting this requirement.

What is MFA?

Multi-Factor Authentication (MFA) is an authentication method in which a user is granted access to a website or application only after successfully presenting two or more pieces of evidence to an authentication mechanism.

MFA is used to protect against hackers by ensuring that digital users are who they say they are. Here is a good blog on the topic.

Authenticator App

Authy LogoThere are multiple authenticator Apps – by Salesforce Authenticator, Google and our favorite Authy. All of them are free and available for both iOS and Android. We like Authy, because it allows you to link multiple apps to a single account, which is helpful when switching devices, while Google/Salesforce have on purpose made switching devices a bit cumbersome.

Using an authenticator App is the most straightforward and convenient way to satisfy the MFA requirement. The drawback is that you will often be asking your staff to download an App on their personal mobile device.

Use An External Identity Provider

Okta Logo If you are an Office 365, Google Workspace or Okta customer, then these services already allow using their service as the identity provider (idP), which means that your users can login into Salesforce using their Office365, Google or Okta login credentials.

This is the approach we favor, it allows your users to: O365 Logo

  • One set of credentials
  • Allows them to login to Salesforce without having to login a second time, as most of your users are likely signed in to O365/Google.
  • You can provision/de-provision users automatically when users are added/removed from O365/Google. Here is a quick guide on how this works with Office 365 and Google
  • Best of all, if you use O365/Google then you satisfy MFA requirements already and don’t need an Authenticator App.

Use A Password Manager

1Password logo If you want to keep login credentials in Salesforce, instead of using an Authenticator App, your users can also use password manager like 1Password (amongst others). 1Password is a very easy to use password manager that will remember all your passwords and allows for 1-click login to websites. 1Password can also be used for as an authenticator for sites with two-factor authentication.

Since MFA will be mandatory starting in February, it’s important to start planning that migration now. You have to also consider doing this in a Sandbox environment first, getting your users familiar with a new process, and drafting up new documentation so that there is no disruption to your business.

Get in touch with the fusionSpan team for best-in-class solutions regarding your Salesforce Org today!

New call-to-action

Your AMS Journey: Selection to Adoption – Step 9: UAT & Training

Noel-Shatananda February 18th, 2021 by

Your organization has been hard at work throughout the implementation and data conversion phases of the project. The team has made great progress, but all the activity has been predominantly conducted by the core project team working on perfecting individual modules of the overall project. The testing that has occurred so far is unit/module level testing. It’s time now to take the next step.

User Acceptance Testing (UAT)

Once the build phase of the project is complete, all the bugs are fixed, and configuration settings corrected, it’s time to test the new Association Management System (AMS) with a system-wide lens in mind. This effort tries to ensure that when the various modules are working together, there is harmony and the desired results are obtained.

Standard Operating Procedures (SOPs)

As was suggested in previous steps, creating standard operating procedures all along the build phase is crucial to success in the UAT phase. We recommend that the core team start with the SOPs and run through them in detail as they test the entire AMS carefully.

Take UAT Seriously

Many clients find themselves with their backs against the wall with respect to time and budget when they arrive at UAT. They have spent too much time during the build phase, and have not left themselves enough time to conduct a good UAT. They tend to skip past UAT with the excuse that the unit level testing conducted during the build phase should suffice. Here are just two (amongst many) issues we have encountered:

Bad Data Conversion: While data conversion auditing and reconciliation are a good start, it is no substitute for actually testing the system with the data that has been imported. Many accounting errors have been discovered during UAT in our experience.

Load Testing: Many times, it is only during UAT that the system is tested with the full set of data. This tends to reveal performance issues that were not considered during the build phase. The first few days of the new AMS could be a disaster if the system grinds to a halt post go-live, with irate members on the phone requesting information or accessing the portal.

Fix Issues and Avoid Scope Creep

We recommend setting aside time to fix all the issues that arise during UAT. Since UAT involves a larger number of users, there is frequently the potential for new scope to arise. Beware not to get into the scope creep trap.

Training

Once UAT is complete and the system is stable, it’s time to get the entire staff that will be using the AMS trained and ready to go live. Here again, SOPs will be the key. Members of the core team should participate and be the champions who instill confidence and help with change management.

Stay Tuned for Step 10!

It is important to ensure that you dedicate as much effort and time into the later stages of this project as you did in the beginning. Testing and Training might bring up new topics of consideration for your organization, so it it imperative to stay diligent and dedicated.

Step 10 of Your AMS Journey details everything you need to know regarding prepping for launching your new AMS! In the meantime, don’t hesistate to reach out to fusionSpan with all your CRM questions and needs!

New call-to-action

Your AMS Journey: Selection to Adoption – Step 8: Data Conversion

Noel-Shatananda February 5th, 2021 by

Data conversion, or data migration, is the task of bringing over relevant data from your legacy system to your new CRM. This is one of the most crucial steps for a successful AMS implementation. Bad data will result in a failed project, no matter how good the features are within your new platform.

As you continue your AMS implementation, here are a few considerations regarding the overall data conversion process.

Timing

The data conversion process needs to begin at the start of the implementation phase and run throughout the entire process. This is because there are a lot of items to be thought through and planned. A few of the most important are detailed below:

Data Quality

A new AMS is a good opportunity to both get a handle on your data quality and take concrete steps to clean your data. Consider launching a data governance effort to help you – the collection of processes, roles, policies, and metrics will ensure the effective and efficient use of all information.

Clean in the legacy, not the new

It is strongly recommended that you clean your data in the legacy system and not rely on bringing bad data into the new AMS and cleaning there. We can assure you that once you move to the new system, you will be risking its stability and performance.

Additionally, the first 6 months post-go-live will be spent learning the new AMS. Some customers are sold on the fact that the new AMS will help them with cleansing historic data. Our experience has been that this has not always worked well.

How Much?

One of the most important questions that we have to answer is “how much data needs to be migrated?” Here are a few considerations:

  • How clean is your data? Consider bringing in only clean data. Often, the farther back in time you go, the worse the data tends to be. Trying to bring this data over will only result in time spent cleaning and transforming for a very low return.
  • Are there regulatory requirements? Do you have regulatory requirements around the number of years of data that needs to be maintained in the system? If so, make sure you are aware throughout the process.
  • Do you have a data warehouse? If you have a data warehouse, the data you migrate can consist of only the bare essentials. You can access the rest of the data from the warehouse.
  • Evaluate Value, Not Time! Clients decide how much data to bring over by using an arbitrary number of years that they are comfortable with – let’s say 5 years. This is not the best method. Instead, think of it this way: I will bring in all my years of certification and membership data since it is required by my members and provides value, while I might not bring in more than one year’s worth of merchandise (hats, cups, etc.) data.
  • Do you own the data? If the answer is yes, and you have access, then consider leaving most of the legacy data in the database and tying a reporting/BI tool to it. This will give you easy access to your past data while not burdening the new AMS.
  • What is the Cost? There is typically a data storage cost with newer cloud-based systems. Evaluate the ROI of the data you choose to migrate.

Extract, Transform, Load

Get help if required. Most system integrators (SI) will not want to take on the responsibility of extracting data from your legacy system. This could be because they do not have experience with your legacy system or do not want to take on the responsibility of extraction. If you do not have internal staff who can pull data effectively, hire a vendor that is an expert in data extraction. Extracting data might also include transforming data into a format that the SI requires. This requires certain skills that less experienced teams may not possess.

Most systems integrators will help with the loading of the data if it is provided to them in the format they desire. However, we have also had some clients take on data conversion themselves – and succeed at it! The key to remember here is the competency of the people executing the conversion process as a whole.

How many data cycles?

We recommend a minimum of at least 2 data cycles. The first data cycle is used to get the methodology established and the second is the final data cycle. Taking the time to iron out the problems in the first cycle will be the key to having a quick and clean final data cycle.

Reconciliation

During the running of your first data cycle, confirm you have the requisite auditing capabilities in place to ensure that you are comfortable the new system represents your information accurately. Since the structure of your legacy system could be vastly different from the new AMS, finding good auditing methods during your first data cycle is important.

One simple tactic is to rely on a set of similar reports in both systems. Another is to write automated check routines that compare data. Again, a topic for its own blog.

Stay Tuned For More

Implementation is well underway, and there is finally an end in sight! It is important to continue to be detail-oriented and focused as your team gets into the later stages of the project – don’t let all your hard work go to waste because you run out of steam.

Step 9 of Your AMS Journey will examine the User Acceptance Testing (UAT) and training phases of your implementation process. In the meantime, remember that fusionSpan is here for all of your CRM questions and needs!

New call-to-action

Your AMS Journey: Selection to Adoption – Step 7: Implementation

Noel-Shatananda January 21st, 2021 by

Well, it’s time to begin! In Your AMS Journey, Implementation is the execution phase of the whole endeavor. In Step 6 you defined the scope of your project, and the System Implementer (SI) will now begin to bring your vision to life.

The key is structure, accountability and discipline. While the earlier stages of the project have been planning, this is the building phase. Imagine looking at your brand new house coming to shape one brick at a time.

Structure

Most system integrators use an Agile delivery model. They tend to configure/develop for a sprint (usually 2 – 3 weeks) and demonstrate their work at the end of it. This model of delivery has proven to be the most successful since it allows you to provide feedback along the way, protecting your investment. It is recommended that you take these demo sessions very seriously and provide the SI the feedback they need. Fixing issues discovered early is far easier and cheaper than when they are caught later on in the process.

Unit Level Testing

As you receive these sprint level demonstrations from the SI, devise a plan with them to conduct unit level testing along the way. For example, when your membership module is being set up: the first sprint was dedicated to the basic setup of your memberships purely with out of the box features, and the next sprint is dedicated to develop some customizations around the special pricing you need.

At the end of the first sprint, you should consider having your membership staff look at what has been set up and get some hands-on experience. At the end of the second sprint, your membership staff should begin some unit level testing of the features developed. As stated earlier, this gives you the opportunity to provide feedback and impact the course of the work quicker.

Standard Operating Procedures (SOP)

As you go through the implementation phase of your project, we recommend that you build out your SOPs along the way, rather than at the end. This has been proven key to the success of many projects. The point to keep in mind here is that the SOP will serve as your final User Acceptance Testing (UAT) phase, in addition to the test cases that the SI will provide you.

We have had clients overlook this, come to the UAT phase, and have nothing to use as a basis for their UAT. As go live approaches, the tension in a project increases, and the SOP task is frequently overlooked in lieu of all the other items that need immediate attention. Many times, clients fail to realize that the SOP is what their new staff members will use to learn the system.

Accountability and Discipline is Vital

Please ensure you keep yourself and your core team members accountable to the commitment of time and attention towards this project. It is during implementation that the ball gets dropped. There is high enthusiasm during the discovery and planning phase since time is explicitly allocated for those activities.

During the implementation, tasks like answering SI questions on time, conducting unit testing, attending status meetings are more are frequently overlooked for more pressing daily tasks that need to be completed. We have seen projects slip off the rails during the implementation phase more than once.

Sponsor Meetings

We recommend that monthly sponsor meetings be held between the client sponsor of the project and the SI sponsor. This can be the checkpoint where the project can be course corrected if required. While the project teams are hard at work in the trenches, the client sponsor hears feedback from the rest of the organization in addition to the project team. This insight can sometimes vary from what the project team perceives as the state of the project, giving the client sponsor an early opportunity to take corrective action internally as well as with the SI (if required).

Start The Data Conversion Early

Your efforts to evaluate your existing data for its cleanliness should have begun before the start of the project. If not, this is more or less the last chance. Contemplate a data governance project if one is required. If you need external help with data extraction, it’s time to get those vendors identified and contracted. More about this in the data conversion blog next!

Set Up a Payment Gateway Early

The selection and basic setup of your payment gateway needs to be completed as soon as implementation begins. Many may argue the timing is too early, but our experience has been that the legal paperwork involved with the providers and the pace at which these providers operate is in months.

Go lives have been held up in the past purely because the payment gateway was set up thwarting the possibility to support online transactions. Further complication is added if you are transferring from one gateway provider to another especially if you have periodic scheduled payments. Again, a topic for a blog post of its own!

Stay Tuned For More

While most of your project has been planning, the implementation phase is finally where you get to start executing. Remember to keep enthusiasm and processes as you shift to a new phase of the project.

Implementation is a major step, but it is not the end of Your AMS Journey! Stay tuned for our upcoming blog on data conversion from your legacy AMS to new system. Remember, don’t hesitate to reach out to fusionSpan with any AMS questions you might have!

Contact Us

Leveraging Baseline NetForum Enterprise in Customizations

Hans_Stechl fusionSpan Team January 14th, 2021 by

netforum_by_communitybrands
NetForum Enterprise is a feature-rich association management system (AMS), but most associations will inevitably find themselves needing to customize. That’s fine – NetForum allows customizations. The challenge comes in down the road when you’re looking to upgrade and the customization does not support new functionality available in the new release or worse breaks down completely. Implementing customizations that leverage baseline may reduce your heartburn during future upgrades enhancements. Here are a few customization trade-offs to consider.

New call-to-action

User Control vs Design Form with Form Extension

Capturing data in NetForum is critical, and forms are key to any data entry. To create the most simplified NetForum eWeb customer experience, you may need to customize your form’s format and fields. A coded user control overrides default form builder limitations and allows for maximum control. But, everything is written in code, so adding an additional field to the form is not a drag and drop situation. Someone will have to dig into the code.

Alternatively, consider using a design form with a form extension. This allows for a portion of the form to get customized within the form extension, but still have the flexibility to add fields using the Toolkit form designer. If you later decide to add an additional column to the form, simply drag and drop and you’re done!

Baseline Scheduled Task Framework

If you’re building out any customizations that either update data within NetForum or push data out to a third-party system, building out a scheduled task may be needed. This is completely normal. The problem arises when the scheduled task is not built within NetForum’s baseline scheduled task framework. Within the scheduled task framework, any Admin user can go into the admin module and review existing tasks, see when it last ran, and see how often it will run going forward. While not working within the framework may be fine for now, it is likely to cause future problems. Building the task in the baseline framework would allow you and your staff to better troubleshoot the scheduled task should problems arise. Think of it as process documentation: you don’t need to spend the extra effort upfront for the system to work, but three years from now you’ll thank yourself that you did.

Facade Objects to Enforce Business Rules vs Form Extensions/Data Objects/Direct SQL

NetForum provides a layer of facade objects where business rules can be enforced, allowing for a great deal of control and customization. The challenge is the rules around those objects is more specific to NetForum. It may be tempting to simply build logic directly into the SQL database. However, the SQL may not follow other business logic stored in the facade object. In fact, it may directly contradict baseline’s or other custom business logic. Implementing a business rule in Form Extensions causes a similar issue in that the business rule is only enforced on that particular Form. When a second form is used, or the functionality is exposed through the API (xWeb), the rule is ignored. So While direct SQL and Form Extensions can work for basic items, updating the facade object and, following OOP’s inheritance best practices is generally a better approach in the long run.

Static ASPX page vs. baseline ASPX page

As more associations look to better leverage eWeb, there are increasing requests to customize the site. The current baseline eWeb does come with its limitations – forms only have a single column, baseline menu isn’t truly responsive (although this can be fixed). However, the eWeb baseline feature set has continued to grow over time. While building a static ASPX page feels like an easy improvement to eWeb, you may be sacrificing the ability to leverage future functionality at the expense of current convenience. New features that get added to NetForum won’t be available on the static page. Instead, try to leverage the baseline page, along with other customization tools, knowing it will provide more longevity for the site.

“Leveraging” bugs

This sounds strange, but over the years I have seen a few occasions where customizations or “cool tricks” were implemented that leverage either existing “bugs” in NetForum or perhaps an unknown vulnerability. At the moment, the customization works and delivers the functionality your organization needs. Inevitably, after the issue is fixed in a service pack or a new release, these customizations stop working. It might be alright to leverage “unintended features” as a stopgap, but be prepared to re-implement the customization sooner rather than later.

Unfortunately, it’s not always easy to distinguish an “unintended feature” from an unknown system issue – so perhaps the best advice here is to ask “Does this look right?” or “Would there be a reason for this variable to have a different value in a future release?” – when in doubt avoid it.

Conclusion

If you have NetForum Enterprise, you should look to customize where necessary. Part of the value of the system is the ability to customize. But make sure to consider your best options for long-term success and not just your immediate need, otherwise can end up causing more problems than you solve.

Whether you want to integrate or enhance and customize your current NetForum Enterprise system, fusionSpan is here to help.

New call-to-action

Your AMS Journey: Selection to Adoption – Step 6: Define Scope, Evaluate ROI

Noel-Shatananda December 10th, 2020 by

With the discovery stage complete, you and your staff let out a sigh of relief. The team is happy the implementation is moving along, and members are eagerly anticipating all of the features they expect the new AMS will bring to make their lives easier.

What’s In and What’s Out

As you review the requirements within the discovery documents, you need to decide what is critical to the business. Therefore, the team must evaluate what is in scope and what can be set aside, at least for the moment. Contemplate some of the following as you endeavor to make the decision:

  • Business Criticality: Evaluate the business criticality of the features you would like implemented. Maybe this item was implemented in your existing AMS but provided very little value. Is it worth the time and effort to replicate and implement it in the new AMS?
  • Resource Impact: Keep a close eye on the financial, time, and staff impact of every feature you plan to implement. Just because the AMS offers a feature does not mean it needs to be implemented. Every feature that is implemented requires time spent setting it up, demonstrations, training, standard operating procedures, user acceptance testing, and long term maintenance.
  • Customization: Most newer systems today tout their ability to be customized to fit your exact need. While this is excellent, it can be a double-edged sword. This topic alone can be a series of blog posts, but the primary takeaway would be ‘do not customize unless absolutely necessary.’ Always weigh the cost of the customization and its long term carrying cost against the value it brings your association.
  • Implementations: Ensure you consider your present implementations carefully, charting a path forward with the new AMS. Consider the fact that the new AMS may not perform a particular function as well as a best of breed system. This is usually the best time to integrate the functionality instead of relying on the AMS’ possible sub-par version of the platform.

Phasing

It is very common to break the project down into many phases, so you get the project off the ground and a portion implemented quickly while you build other phases as time passes. Let’s discuss some advantages and challenges to consider:

Advantages

  • The Board: It took time for the Board to approve the new AMS budget, and now they are impatient and eager to see the results.
  • Quick win: The phase 1 budget is obviously lower than the entire project budget, so value can be delivered to the association quicker while the future phases are scheduled. This can sometimes even allow teams to budget across multiple years.
  • Iterative learning: Phases provide the association with an opportunity to learn from mistakes and adapt quickly.
  • Enthusiasm: Having a good phase 1 implementation creates excitement for the staff around the prospect of a new platform and keeps them engaged and enthusiastic.

Challenges to Manage

  • Implementation Fatigue: An AMS implementation takes a lot of effort by the staff to support and keep the daily responsibilities on track. It is common for teams to feel fatigued at the end of phase 1 and need to take a breath. This could impact future phases, resulting in delays.
  • Evaluate business-critical functions: Sometimes, in a rush to phase, the necessary due diligence is not done towards ensuring that all the parts of the business have a viable way to operate day 1 within the platform. This includes ensuring that the new AMS supports any dependent functionality that was supported by the legacy AMS.
  • Budget: While budget management is crucial in all implementations, managing it well is even more important in a phased project since you want to ensure that future phases are adequately funded.
  • Costs more, takes longer: While it may be counterintuitive for some, a phased implementation will cost more than a one time big bang implementation. Every stop and start in an implementation results in repeated tasks, such as user acceptance testing, training, and go-lives.

While the challenges may be daunting, it is still preferable to phase projects, as the advantages overshadow the challenges that could be easily managed with a well-prepared team.

Communication is Still Key

Defining scope and determining each phase’s contents are challenging, but communication to the stakeholders is still vital. Implementations can get off to a dreadful start if this is handled poorly. Stay tuned for our next installment of Your AMS Journey for everything you need to know about preparing for Implementation, and don’t hesitate to reach out to our talented team here at fusionSpan for all of your AMS questions and needs!

Contact Us

Your AMS Journey: Selection to Adoption – Step 5: Discovery

Noel-Shatananda November 25th, 2020 by

By this stage of Your AMS Journey, you have made all the crucial decisions regarding choosing a new product and implementation partner. With your platform and partner selected, now it is time to roll up your sleeves and get to work. To begin, you will engage in a discovery.

Clients are often unable to understand the need for a detailed discovery. Organizations will believe that their conversations with a salesperson, or even the RFP responses, should be adequate for the project to begin. Unfortunately, that is not usually the case.

The discovery is an opportunity for the implementation teams of both the client representatives and the Systems Integrator (SI) to learn about the tactics needed to implement the AMS and see what is needed to bring the vision to reality.

In the previous post, I mentioned concentrating on the ‘what.’ This is the time to get into the ‘how.’ Here are some items to think about as your begin the discovery phase:

Take The Needed Time

Contemplate taking the necessary time to go through a deep and thorough discovery. Rushing a discovery will lead to an implementation that will be incomplete and potentially fail.

Imagine not spending time going through the architectural plans when you want to build a house. Moving rooms around after the build is impossible.

Share The Good With The Bad

During our discoveries, we frequently hear in great detail about all the failures of the existing AMS. We recommend that clients be comprehensive and share what works, as well as what does not. We want to ensure that we implement a product that alleviates the legacy system’s pain points and provides and maintains the functionality that has worked.

Core Team Is Key

The involvement of the core team is key to success. In our previous step of the process, we introduce the core team and highlight its key members.

The core team needs to provide the SI with the processes and pain points they face in each area and department of their association. They will be the ones signing off and accepting the various modules of the product implementation later. Their acceptance has a direct impact on adoption across the organization.

Seeing Is Believing

During the discovery meetings, the client should demonstrate the old system and processes to the systems integrator. In turn, the SI should demonstrate stock product functionality to the client.

The demonstrations can be short but will help the Core Team visualize the solution and buy-in quicker.

Solutions, Please!

As you go through the discovery, please ensure that the requirements are captured in-depth with adequate solutions. They could be stock product features or customizations that might be required to support your organization’s particular needs.

Document Everything & Sign Off

Having strong documentation of the required solutions is key to success, as they serve as the scope that drives the project’s acceptance criteria later on.

Ensure there is a sign-off of the relevant modules of discovery documentation by the appropriate department. This provides the opportunity for each department to own their piece of the implementation process. It also guarantees that each department actively participates in the implementation process and later champions the adoption within their own department.

The point of a discovery session is to highlight what you have, what your organization wants, and what you need to move forward. Remember, the discovery is an opportunity for the implementation team of both the client representatives and the systems integrator to learn about the tactics needed to implement your new AMS platform.

Do not hesitate to reach out to fusionSpan for additional resources, and stay tuned for the upcoming blogs as we jump further into the implementation process!

Your AMS Journey: Selection to Adoption – Step 4: Product Partner Chosen, Now What?

Noel-Shatananda November 12th, 2020 by

You made your product selection, and are excitedly looking forward to implementing your new AMS platform. Now comes the decision to select an implementation partner.

Look carefully at who you plan to use to implement your chosen product. You want a team that understands your business, knows how to integrate all the best of breed systems that you plan to use, and is experienced. The implementation team from the product company could be a great fit, but evaluate if they possess the experience to be your comprehensive systems integration partner.

Far too often, we see associations make the product selection and expect the implementation partner to take them to the finish line. That can be a recipe for failure. Here are some areas that need consideration as you get ready:

Assemble Your Implementation Team

  • The Project Manager (PM): Identify a project manager for the new AMS implementation. Implementing an AMS can be time-consuming, requiring a lot of coordination, organization, and communication, and might require up to 20 – 24 hours a week on average. This time commitment will be higher in the beginning with discovery, will be slightly lower during the build/execution phase of the project, ramp back up at user acceptance testing, and go live. Frequently we see associations assigning people to the role who are unfamiliar with project management, are unaware of what an implementation requires, and, more importantly, already have a full-time job. If you find yourself in such a predicament, we recommend hiring a part-time external project manager to help. The expense will pay for itself ten-fold with a successful implementation.
  • The Project Sponsor (PS): Identify a project sponsor for the implementation. This person is usually someone from the executive team who keeps a finger on the pulse of the project and is responsible for the project’s success. The PS usually meets with the implementation partner’s PS monthly and ensures that the project is on track. The sponsor check-ins are usually held independent of the project manager’s check-in and gives the sponsors a chance to discuss items that either side sees and that the PMs are unable to handle. This is also an escalation point for the PMs and the members of the core team on either side as it relates to the project progression.
  • The Core Team (CT): Behind every successful implementation is a great core team. Your core team should consist of staff members from every department that will be using the AMS or will be impacted by its implementation. Having a mix of a power user (staff person) and a manager (decision maker) per department represented is crucial to success. Having only the staff person will result in the system being designed for today while having only the manager will result in the system being designed for tomorrow disregarding the nuances of today. Lastly, select people who will want to own their piece of the implementation and will be your champions across the organization. This will have a direct impact on adoption.

Develop a Timeline and Mutual Processes

  • Kickoff: Have a formal kickoff meeting with all of the staff that will be using the system and the systems integrator. This meeting should have Association leadership in attendance and the Executive Director laying out how the AMS will tie into the strategic vision. This helps clarify to staff the importance of the project and also ensures their participation and commitment.
  • Communication: While there are many aspects of a project that will be discussed during the kickoff, we would like to highlight the importance of communication. Ensure you use a collaborative tool for all communications between the members of the teams. We have seen teams use emails and it has been disastrous as information is frequently lost, especially if there is a change in resource.

Manage Your Data Wisely

  • Data Governance: The implementation of a new AMS could be the best opportunity to visit your association’s data governance. Contemplate bringing in a consultant to help if you should need to.
  • Clean data: As you contemplate the many aspects of data governance, begin thinking of how you are going to get clean data into the new AMS. We recommend not trying to use the new AMS for cleansing the data, even if it professes to have great capabilities for it. Rest assured that once you are in the midst of the implementation, adding data cleansing to the mix will prove detrimental.

Know What It Will Take

We often see associations overlook what a new AMS implementation truly takes in terms of the association staff’s time. Ensure that you talk through your staff’s time commitment with your chosen implementation partner to consider what it will really take to implement a new AMS.

For more resources surrounding an AMS Selection and Implementation Journey of your own, don’t hesitate to reach out to our talented team at fusionSPAN today!

Your AMS Journey: Selection to Adoption – Step 3: Choosing the Right Product Partner

Noel-Shatananda October 29th, 2020 by

So what should I look for in my next Association Management System?

As implementers, we often get asked this question is some shape or form during the AMS Journey. For those following this series in order, we have asked “why do we need a change from our current system?” and then developed a vendor selection process through the creation of a RFP.

While evaluating the needs of your current platform and beginning to vet platforms is great progress, our AMS Journey is far from over. Your next step is to identify the exact organizational and platform problems you are looking to solve, and choose a product partner based off those requirements.

Untitled-design-3

Choosing the Right Product Partner

Here are some of the key factors you might want to consider as you evaluate platforms during Your AMS Journey:

Your Size and Growth

We often come across associations that have purchased a 16 wheeler, when what they really needed was just a SUV. If you are a small association that has a concise set of features and processes you need to operate well, then going for an extremely flexible and innovative platform might be overkill.

However, are you looking to grow substantially in the future, and do you envision your members doing the same? If so, you need a cloud based, highly flexible product on an innovative platform.

Place of Birth

What we mean here is, was the product “born in the cloud”? It’s obvious we want a product that lives in the cloud, but was it architected for the cloud from its inception. This becomes a crucial factor as you grow.

We tend to come across legacy products that were built before the cloud, but have added a web use interface and claim that they are a cloud platform. Unfortunately, that is not true, as the core architecture was never designed with the needs of the cloud in place.

Platform Compatibility

AMS platforms are great in the sense that your tool is built on top of a stable, innovative, foundational layer. The platform will continue to evolve, and the AMS automatically benefits from the underlying technological innovation. As an example, if the platform began to support artificial intelligence and blockchain, the AMS would be able take advantage of it. Non-platform products would have to integrate or build support for these independently. At some point, your organization will find non-platform products too difficult to keep up with evolving needs.

Features & Technology

We frequently see associations making decisions purely on features, while not fully understanding the ramifications of the technologies the product is built on. Most legacy systems that have been around a long time have solid features, but are poor at integrating, not born in the cloud, and are hard to customize. Furthermore, some of them are not built on a stable platform.

In-house Technical Competence & Budget

Lastly, it is key to make your product decision based on the technical competence you have on staff and the potential budget you are willing to allocate to IT.

We come across organizations that purchase larger complicated systems, when they clearly did not need it. This in turn leads to poor implementation and adoption, and adds problems instead of solving them. A simpler, fully partner managed, easy to use system will be more beneficial in the long term.

Always Use a Scorecard During Platform Evaluation

Typically, the more customization and features you want to implement, the more it will cost. As you go through product demos, define a score card that all the participants can use to help keep the decision making process objective. Make sure you identify which features are a necessity and which features are extraneous.

There are a variety of templates and resources regarding an implementation scorecard, and each organization will have different pain points with their current platform. At the end of the day, make sure you identify what is most important for your organization as a whole in your evaluation, and weigh those needs properly on your scorecard.

Untitled-design-4

Stay Tuned for More!

By this part of Your AMS Journey, the hope is you have not only identified the needs of your organization, but begun to identify the new platform that will fulfill those needs. In our upcoming articles, we will explore where to begin the implementation journey with your new platform and product partner.

In the meantime, don’t hesitate to reach out to fusionSPAN for all of your AMS consulting questions and needs!

Your AMS Journey: Selection to Adoption – Step 2: Always Have a Request for Proposal

Noel-Shatananda October 16th, 2020 by

As an organization that specializes in AMS support and implementation, we typically step in after the selection of an Association Management System has already been made by your organization. Our first step is to ask the AMS partner or association for their Request For Proposal, but a surprising number of clients never issue one.

What is a Request For Proposal?

A Request For Proposal (RFP) is a document used when an association is seeking support or consultation on a tool, product, or service for their organization to leverage. The RFP is designed to outline the requirements for a specific project, and is used to solicit bids from vendors for the association to consider during the process.

While there are a variety of ways to format the proposal, they typically take time and resources to create. Make sure this is a project your association is fully committed to doing before beginning the RFP process.

Here are some things to consider as you create an Request For Proposal for your AMS Journey:

Clearly Defined Needs: This builds directly off Step 1 in Your AMS Journey, “Ask Why.” Be sure to have a high level set of needs with a strategic vision as you begin outlining this document.

The More Detail, The Better: Now, take that strategic vision the organization has and break it down into detail level requirements. Do not go into the tactics (the how) but clearly state the requirement (the what) in an AMS agnostic way. A typical example could be, “the new AMS supports memberships that can be anniversary (day of purchase) or calendar (yearly) based.”

Hire a Vendor Selection Consultant (VSC): Contemplate hiring a vendor selection consultant who can help you get the details finalized. They usually come with deep knowledge on what an association your size should typically look for. Larger organizations with a bigger staff need to consider this more, since the complexity of their processes are usually higher.

Caveat: Some VSCs may come in with a lengthy list of potential requirements that an organization your size may typically need. Ensure you choose the ones that are most relevant to your organization for the present and the near future. However, beware of adding bells and whistles that you do not need into the basket.

Reduce Complexity: Work with the consultant who would be an unbiased third party to evaluate your existing processes and make the hard decisions on which processes stay, and which ones need to be eliminated. Beware of legacy workarounds: we tend to see a lot of processes that organizations want us to implement that were actually workarounds put in place to overcome a deficiency of the legacy AMS.

Evaluate Bylaws: Oftentimes fusionSPAN has been asked to implement a piece of functionality because the bylaws mandated it, when in reality it made very little sense. We recommend that the association take this opportunity to look at its bylaws carefully to evaluate its relevance during the request process.

It’s your blueprint: The RFP will be the blueprint of the tool that will take you into the future you aspire to march towards. At the end of the day, ensure you are confident and happy with your blueprint.

AMS-Journey-img-02

There are a variety of resources and templates online for your association to use when creating a RFP. Make sure to highlight your organization information and required details for this implementation, as well as budget info, deadlines, and any questions you will have for potential vendors. Remember, the idea of this proposal is to specify your needs to help find the best fit for your association.

Stay tuned for Step 3 of Your AMS Journey: Selection to Adoption, where we discuss choosing the right Product Partner for your association. In the meantime, don’t hesitate to reach out to fusionSPAN with any of your AMS implementation needs!

Your AMS Journey: Selection to Adoption – Step 1: Ask Why

Noel-Shatananda October 1st, 2020 by

Welcome to Your AMS Journey: Selection to Adoption, a blog series presented by fusionSpan. Throughout our work providing consulting, implementation, and support services to non-profits and associations, we have seen our share of successes and challenges that the entire selection and implementation process involves when adopting a new Association Management System (AMS).

In this series, we will shed light on the various steps of the AMS journey your association will face through twelve blog articles, with each one offering specific insight as you move throughout your AMS selection and implementation process. Let’s start at the beginning!

What Is An AMS?

First off, an Association Management System, commonly called an AMS for short, has become an essential tool for membership based organizations to leverage when maintaining a database of member information. In fact, almost all non-profits and associations today use membership management software in some capacity for their organization.

Within the AMS, associations are able to process membership dues renewals, event registration, email marketing and more. Although these platforms are not an all-in-one tool, an AMS allows you to deliver more value to your members in an efficient manner, with seemingly increasingly capabilities. There are a variety of systems and features at different price points, so make sure to evaluate more than just one platform when implementing a new AMS.

Step 1 of Your AMS Journey: Ask “Why?”

As we work with associations during implementation of their chosen AMS, we like to ask them the simple question “Why? Why did you as an organization believe you needed a change from your existing system?”

We hear a lot of reasons: technical, infrastructure, database architecture, reporting, lack of features in a particular area, and many more. Sometimes we hear the strategic vision of the organization is focused on digital transformation, and adopting a new AMS is the logical next step in that process.

As you contemplate identifying and implementing an AMS, here are some topics to consider:

Strategic Vision

Clearly define your organizational strategic vision first, then choose a system that will help you accomplish that. As simple as that sounds, many organizations have not articulated their vision at the strategic or executive level, and they expect a system to automatically take them to a better place.

Clearly Defined Needs

Define the explicit high level areas that you expect your new AMS to handle seamlessly, remembering that your AMS cannot do it all. Believe us when we say that the success rate of those who have tried to make their AMS a one-stop-shop is not high. An example could be a single source of truth for all constituent data, membership, and committees, while you might be fine to have your certification needs handled by a best of breed learning management system that integrates tightly with the AMS.

Focus Forward

Armed with your strategic vision and clearly defined needs, lay out some of the features you would like in each of the modules. Stay away from the tactics, but think at a higher strategic level to define what you want, not how it is achieved.

Beware of the Rear View Mirror

This ties directly to defined needs and looking forward. Most of the time we see associations define their future needs based on what their existing AMS lacks, and forget current features they are utilizing. Remember to build a comprehensive list of “Must Haves” and “Nice to Haves” when it comes to features and capabilities.

Upgraded Lately?

We frequently find that associations do not invest in keeping their AMS upgraded to the latest version, often because upgrades are costly. This tends to lead to a lack of knowledge and adoption of newer features. As you evaluate a new AMS, it would benefit you to ensure you are aware of all the newer features the latest version of your existing platform supports. It will provide you ideas on features to look out for in your new AMS.

While this is by no means an exhaustive list, these topics will be a great starting point for your non-profit or association to consider while selecting a new platform. Stay tuned for Step 2 of Your AMS Journey: Selection to Adoption, where we will demonstrate the value of a Request For Proposal (RFP) during your AMS selection!

In the meantime, if you have any questions about this article or your AMS journey in general, we would be more than happy to help you along the way!

Non-Profit Tech Podcast: Cut Through The Clutter with Elizabeth Weaver Engel and Hilary Marsh

justin fusionSpan Team September 24th, 2020 by

Elizabeth Weaver and Hilary MarshIn our latest Non-Profit Tech Podcast, fusionSpan’s Justin Burniske talks content creation with Hilary Marsh, Chief Strategist of the Content Company and returning guest Elizabeth Weaver Engel, Chief Strategist of Spark Consulting, LLC. Associations are content machines, and we are all looking for ways to reduce the load on staff through effective content curation. Tune in as the group discusses the Whitepaper titled “Cut Through the Clutter: Content Curation, Associations’ Secret Weapon Against Information Overload” written by both Elizabeth and Hilary, and also cover strategies and platforms to use while curating content for your association.

If you would like to learn more about content creation, you can contact Hilary and Elizabeth by visiting their respective company websites:

To learn more about Hilary’s content strategy community, visit: content-startegy.com

“Cut Through The Clutter” Whitepaper: https://bit.ly/34P5THr

Tune in as Justin, Hilary and Elizabeth discuss opportunities while working remotely ([skipto time=”4:12″]), analytics surrounding content platforms ([skipto time=”19:15″]), resources for content curation ([skipto time=”43:20″]) and more! Don’t forget to subscribe to the Non-Profit Tech Podcast on your preferred podcast platform, and happy listening!

Listen on YouTube: https://fspan.link/vbsh7

Preparing for the Salesforce Spring ’20 Patch

Avatar photo February 27th, 2020 by

Technical writing

What is Happening

If you use Salesforce or a platform built on the system, then you are probably well aware of the Salesforce Spring ‘20 release, which came out on February 17, 2020. Although the releases are a regular Salesforce event, the latest one contains a security patch, which may require a little extra attention.

Patching normally involves installing the patch and conducting a full round of testing of all your customizations to ensure that nothing was impacted. However, there is always the chance that something is missed or an unexpected complication happens. While the Spring ‘20 release brings expanded innovations across the entire Customer 360 platform, it warrants a look at your current Salesforce/Association Management System (AMS) platform.

Patch Details

In today’s age of unsecure data and wireless breaches, Salesforce’s latest update is improving it’s platform and security. The new release brings a plethora of great features and innovations across the entire Salesforce ecosystem. As certain Association Management Systems such as Fonteva are built on the Salesforce platform, it is imperative to fully prepare for the release in the best possible way. At fusionSpan, we are able to provide the peace of mind that comes with a fully-functional AMS through actions such as:

  • Refreshing your testing environment
  • Implementing the patch
  • Carrying out testing in sandboxes
  • Resolving the resulting issues
  • Deploying the patch
  • Conducting all post-deployment tests, and so on

Since the Spring ‘20 release will affect different users in different ways, be sure to check out Salesforce release notes to see how the update affects your organization

Your Next Steps

Since the patch date is near, there is no better time than now to begin implementing it within your AMS. If your staff does not have the time to handle the impact of the Spring ‘20 release or Fonteva security patch, do not worry! Reach out to us here at fusionSpan for all of your AMS Consulting needs. We will work closely with you to develop a detailed plan and testing schedule to implement either patch.

Why Associations Need Tool Owners, Not Tool Experts

justin fusionSpan Team October 31st, 2019 by

Why Associations Need Tool Owners, Not Tool Experts“So what do I need to do in the CRM?”

The question caught me off guard. I was responsible for training new staff on the CRM, but I didn’t write anyone’s job description. How was I supposed to know what they needed to do in the CRM.

“I guess whatever your manager says you need to do.” I responded.

“Yeah, I asked them and they said you would know.” They answered.

I realized in that moment the challenge – managers know high level what they wanted to accomplish, but none of the managers were experts in technology. Most had a background in education, and little experience with a CRM. I realized that in order to be successful, being the system expert wasn’t enough – I needed to be the system owner who could connect the technology with the work of the association.

While the difference between expert and owner may seem small, for associations having that designation difference is important. Here are five things that make up a system owner.

Owners can make decisions

Having a person who knows the tool is good, but too often an expert can only lead staff to water, she cannot tell staff how much water to drink. Owners get to set the standards around the use of tools at an organization. They need to play both business analysts as well as technical expert. That way staff can come to the owner with a problem and trust the owner to identify a solution.

Owners don’t need a technical background

For many tools today the technical training required to be an owner doesn’t necessarily require a computer science degree or experience as a developer. In most organizations, there likely already exists an informal owner for many of the tools. Designating an owner can be just about formalizing a role someone has already been playing. Often her expertise has been earned through hard work with the tool, and can likely serve your association just as well as bringing in a technical expert who doesn’t know your organization.

Owners create all tool documentation

Most associations lack documentation of how their organization leverages a tool. Many instead rely on generic documentation for the tool, which lacks an explanation of why the association leverages the tool the way it does. With an expert helping a department within the association, responsibility for documentation is unclear between the two parties. By designating an owner, responsibility becomes clear. Maybe that’s why they often call it an “Owner’s Manual”.

Owners ensure best practices are followed

Since the owner has created documentation, they can be expected to monitor system use to ensure staff are following best practices. An expert might point out that, “Hey, that’s not really the best way to create new records,” but an owner can take it a step further and say, “And this is how you should enter records.” That empowerment enables the owner to foster best practices as well as correct bad habits when they are identified.

Owners shouldn’t do everything

While staff should rely on the tool owner to support their needs, a good owner is also a good shepherd of the system. She will empower staff to take initiative and be able to perform basic tasks on their own. Ideally, the owner will also foster a power users group that can grow the use of the tool internally. The power users would ideally comprise of staff from every department within the organization, that way each department will have someone who can do the necessary functions needed within that department. This both ensures the owner does not become a bottleneck within the organization, while still supporting all areas of the organization.

Conclusion

Associations invest so much capital into new technology – now they need to invest equal amounts of capital into ensuring the long term success of that technology. By clearly identifying an individual to own a tool, she will feel a sense of empowerment to step up in challenging situations, or to speak up when an opportunity to better leverage a tool is being overlooked. This also requires leadership to be comfortable with giving up authority – but given the ever evolving nature of technology, giving up a piece of control in exchange for greater performance is probably the only way organizations can remain agile.

Data and Relationships: Too Much, Too Soon?

Becky Breeden October 3rd, 2019 by

It’s inevitable. In every implementation of a new AMS solution, we eventually come to the question of what information needs to be collected for particular transactions – joining, registering, subscribing, etc. Inevitably, we are often handed a set of forms that are either throwbacks to the age of paper or are lengthy tomes printed from online forms.

And there the struggle for data economy begins.

The conversation goes something like this:

Implementer: What pieces of this information are necessary to start your relationship with a new member?

Customer: All of it.

Implementer: Are you sure? Could we eliminate these 12 items about their areas of expertise?

Customer: No, we have to have that to add them to communities or email preferences?

Implementer: Do you have to do that information from the member or prospect when they first reach out to you, or could you gather more information over time?

Customer: Yes, that’s when we’ve always done it. It’s part of our “join process” and part of the automation of benefits flow down we spent $10,000 automating in our current AMS that we hate.

Implementer: Oh, okay. Well, we have seen clients increase engagement by reducing the data barrier to entry. (Insert quote, “Those who fail to learn from history are bound to repeat it.” )

Customer: We HAVE to do that. (becoming animated) You said you could support that in the DEMO!!!. (shuffling papers to find the contract they came armed with.)

Implementer: We can do that, but is it possible we could begin with something less time-consuming for the prospect or member and work our way up to gradually asking for more information?

Customer: This is supposed to save us time. That’s a lot of work!

You probably get the idea. Many organizations are struggling to recruit, engage, and retain members. We live in a society of instant relationships and yet, associations are still wedded to the idea that to develop a relationship means turning over your life’s story.

Is it time we start to think about relationships differently? What if we could start with the most basic of information points and from there begin sharing the things that make a relationship with us valuable. In today’s jargon, what does it take to swipe right or swipe left?

Take a Cue from the Competition
We hear so often that membership is aging and organizations are struggling to recruit and engage younger members. Perhaps we need to take a lesson from the data economy of more popular platforms. Social tools require very, very little information to begin sharing. One of the greatest challenges to membership-based organizations are the connections and resources potential members receive from free tools like LinkedIn, Facebook, or Reddit. Why not consider a minimalist approach to start?

Progressive Profiling
We know profiling can have a very negative meaning. Still, we are all being profiled all day, every day by the tools we use. Even our beloved smartphones learn our habits. In today’s permission-based economy, if you want to gain more from your experience, you share a bit more information gradually so that content is more relevant, contacts are more valuable, and opportunities are more convenient. Progressive profiling is a technique that allows marketers to gradually collect more data on leads at strategically timed intervals throughout the buyer’s journey. Essentially, based on users’ willingness to respond and their engagement after response, we ask for more. If they give us an email to get a newsletter and then open the newsletter and engage with a piece of content (think click), then we ask for a little more.

The Death of Closed Societies
For many organizations, the basis for overwhelming data collection is the need to validate credentials and ensure a level of expertise. However, that may not be necessary for simple, appropriate interactions that show value before a commitment. You are likely going to get push back. “Wait, you’re going to give them an article or let them attend an event?” We can already hear the hue and cry. If you are one of those groups with a “club” mentality, please remind the club that anybody can get anything from anywhere these days…including from for-profit entities who are happy to take your data beleaguered prospects.

A fusionSpan client promoting a recruitment initiative for a particular style of education is using progressive profiling to gradually ask for more and more information to move prospects through an engagement funnel. Once users ask for more information, they are moved through an engagement program that ultimately results in them sharing more and more information on progressive forms and applications.

Here are some soul searching questions for you as you rethink the way you start your relationships with future members.

  • What are the very minimum requirements for you to begin your relationship and begin to show value?
  • For every additional data set (think 2-3 data points), what is the additional value we can show?
    What conversations and changes need to happen internally to allow you to scale back on initial data collection?
  • How can we tell when our relationship is solid enough to ask for a larger data set?
  • How do we need to reconfigure the way we roll out benefits and access to allow for this slower data relationship?

Keep your eyes open for our follow up article on who you can begin to see the journey for your customers unfold and better determine how much you can ask for and when.

Six Musts Around Onboarding Staff to Your Customer Database

justin fusionSpan Team March 13th, 2019 by

Quality onboarding is essential to long-term successQuality onboarding is essential to long-term success.

Association executives are becoming more and more cognizant of how important customer data, and in turn their customer database, is to their organization’s success. Yet most associations struggle to establish a culture of data, where everyone understands the value of customer data. A first step in fixing that culture starts at the beginning with the onboarding of new staff. Here are six items all associations should have as part of their customer database training to help create that culture from day one!

Centralize the training

Many associations leave training to each department, which makes sense since those are the people who oversee the day-to-day activities of a new hire. Unfortunately, when training on a centralized system that everyone uses, training ends up as consistent as a game of telephone – where each department follows slightly different practices, and so the output of data is not at all consistent. Instead, there should be a designated business owner of the customer database who provides training to all staff. This helps ensure all staff get a clear and consistent message about the role of the data within the organization.

Explain the value

Because most staff are not involved in the big picture, associations never explain specifically the role of the customer database in serving the big picture. Sure, all association executives will say things like, “Our organization is our members, so member data is important.” But that’s not actionable in any meaningful way. Instead, explain how the data is being leveraged, how good data has an impact on customer experience, and how leadership leverages the data to make decisions. Then tie those hows back to why their role is so important.

Provide a map

No association uses one system for all their business processes, and the all-in-one association management system is becoming less and less common. New staff are likely bombarded with different tools, from the customer facing systems like the CMS, CRM, LMS, eMarketing to the internal tools for timesheets, documents, messaging, and meetings. Providing a visual diagram – or map – that shows all the different systems, what purpose each system serves, and how the systems are connected (do your customer systems have SSO? Is any data shared/imported? Etc.) can help clue new staff into a bigger picture. Particularly the connections between systems can help them understand how bad data in one place has a ripple effect across the organization.

Define their role

While the specific tasks may be delegated by the department, having a consistent definition of everyone’s role across the organization ensures people don’t think data quality is not their problem. In reality, it is everyone’s responsibility, and everyone will likely need some level of proficiency within the system. A minimum proficiency by role might be defined as the following:

  • Executive Team – Able to pull reports from the system
  • Directors – Able to pull reports and look up records
  • Senior Associates – Able to pull reports, look up and edit records
  • Associates – Able to pull reports, look up, add and edit records

While certain departments may require people to perform more then the minimum, having a minimum in place both helps new staff understand what they need to be able to do, and since the training is centralized the trainer knows at a minimum what they need to get training on to be successful in their role.

Give them documentation

While trainings are great, new hires are generally drinking from a fire hose of information. Having a clear set of organization specific documentation for them to reference after training is often very helpful – especially if they are the kind of people who learn best by reading. And, since the organization now has a delegated business owner for the system, there is a clear owner responsible for documentation. If they are feeling overwhelmed by the task of creating documentation, a great way to go about writing it up is each time staff ask a question, instead of just sending an email response, write up a document that can be sent over, and then save the document in a central repository for others to reference.

Schedule a follow-up

Because of the fire hose of information in the first training, having a follow-up a month or so after the initial training can often be more productive than the initial training. This gives the new staff member a chance to ask follow up with some actual context around what they are doing. Don’t wait to schedule the follow-up – put it on the calendar at the initial meeting, and let them know it will be a chance for them to ask follow-up. That way over the next month, as they come across oddities within the system or processes that don’t make sense, they will have an incentive to capture and report those since they know that follow-up is coming.

Conclusion

Most organizations spend too much time implementing customer databases, and not enough time helping their staff understand how to leverage the system. Having a clear onboarding process in place can help remedy that issue, while also allowing the organization to take a more unified approach to data. Hopefully having these guideposts will help in developing an onboarding approach for new employees.

Falling in Love with Salesforce Reports

Avatar photo February 14th, 2019 by

Roses are red,
Violets are blue,
We love Salesforce reports
And we hope you do too!

Salesforce provides standard report types which can be used to build reports summarizing and analyzing your organization’s data. Salesforce reports are a powerful tool that helps you and your organization’s staff proactively respond to your organization’s trends and activities.

Hint: If your organization is new to Salesforce, check out our blog post “Common Issues for Organizations New to Salesforce (And How to Avoid Them!)“.  If you have any additional questions about report-building, contact our talented Salesforce Customer Success team!

Questions to Ask Before Creating a Salesforce Report

Before creating a report, work with staff requesting the report in gathering report requirements. Consider asking the following questions and use the answers to build your report criteria.

  1. What question is being answered by building this report?
  2. What is the intended business use for the report?
  3. What information is needed?

Once you have your report criteria, you are ready to start building the report!

How to Create a Salesforce Report

In this blog post, we will build a report to pull all active users in your organization who logged in this month.

Note: In this example, we will be using Salesforce Classic. Almost all of these steps can be used to build a report in Salesforce Lightning.

Step 1: Navigate to the Reports Object
Click on the Reports object from the navigation bar

SF Report

Note: If you cannot find Reports on the nav bar, you can also find it under the All Tabs section by clicking on the + icon

Step 2: Create a New Report
Click on New Report.

SF Report

Select your report type and click Create. In this example, we are pulling a report on our organization’s Salesforce logged-in users. Expand the Administrative Reports section and select Users.

SF Report

When you click Create after choosing the report type, you will see your preview report screen.

  1. Fields: Shows the list of fields available for your report. You can drag the fields on the preview (3) section.
  2. Filters: Create filters to meet your report requirements.
  3. Preview: Preview your report’s data.

Based on our Logged-In Active User Report requirements, build the report using the following filters:

  1. View: Active Users
  2. Date Field: Last Login
  3. Range: This Month

Additional filters can be created by clicking the Add button. Additional fields can be added to the report by dragging fields from Fields into the Preview section.

Step 3 – Run Report and Save
Report Previews only display 50 rows of results. To view and export the full report, click Run Report. You can also Save the report for future use.

Congratulations! You now have a report to monitor all active users who logged in this month.

There’s so much more you can do with reports, like grouping the records using bucket fields, create a formula field, add cross filters linking the objects, add a chart to your report, choose from the report formats available etc.

AMS Implementation: Why a Business Process Discovery is Essential BEFORE Making a Move

justin fusionSpan Team November 2nd, 2018 by

One of the biggest challenges with association management system (AMS) implementations is that organizations often confuse processes in their old system with their business requirements. When this happens, organizations request customizations to make the new system function like the old system. [Read one of our related blog posts: Enterprise AMS: When is a customization right for you?] Wasn’t the original goal of selecting and implementing a new AMS to improve—not maintain—your business processes?

Understandably, it’s hard for people to separate what they do (process in the current system) vs. why they do it (business requirements), and that’s generally not something a vendor is going to be able to separate out for clients. It’s the difference between accounting claiming they need a report with 12 specific columns run every month (process in the current system), vs. knowing that the reason they need that report is to follow up on open A/R once a month (business requirements). If the client doesn’t explain the why and instead focuses on the what, the vendor will likely build a report when an automation process may be more efficient.

Business Process Discovery Planning

This all leads into a business process discovery prior to implementing a new system. This makes a lot of sense, since a business process discovery can also help define what you will need in a new system. But how do you prevent the business process discovery from becoming current system processes? Staff will struggle to separate the two.

One more costly option is hire a consultant, who can offer a fresh perspective during your business process discovery. Alternatively, if money is an issue, consider replacing a consultant with other staff.  Staff, if strategically selected from across your organization, may be able to bring a similar fresh perspective, if they are far enough removed from the day-to-day of other departments.

Business Process Discovery Steps

Now you have a discovery team identified, have them go through the following steps:

  1. Have staff identify all the current system processes they complete that require the AMS.
  2. Explain the business process that each system process supports. Business processes should be described in such a manner that anyone can understand them. Note that in some cases, multiple steps may relate to the same business process. Generating renewals and dropping expired members could both be related to 12-month membership terms.
  3. Once finished, trade off their document with at least two people from other departments to review.
  4. The reviewers are responsible for ensuring the business requirements are clear. If the business requirements are not instantly understandable by the reviewer, then the requirements will need to be further clarified. For instance, the reason all memberships are issued as proforma is because the organization uses cash-based accounting.
  5. Go through a couple rounds of edits until everyone is satisfied that the business requirements are no longer reliant on the current system.

Post-discovery

Once the business requirements are solidified, that document should serve as the foundation for all future decisions. When reviewing new potential AMS systems, ensure that all the business processes are supported. Once implementation begins, ensure processes in the new system are identified to support the business process. Staff should ensure they focus on business processes, and because the business process document was a collaborative effort, staff should feel comfortable calling out when they hear someone describing the old system processes instead of business processes. Granted, there are cases where the old process and new process will be very similar, but as long as the business process was the catalyst for the new system process, that’s not a bad thing.

Conclusion

While a business process discovery can be a time consuming exercise, the activity is far less painful than implementing a new AMS that does not accommodate an organization’s business processes. Additionally, by having staff from across the organization collaborating on processes, departments can better understand how their actions in the AMS impact others. Ideally, that collaborative spirit will carry on well beyond the AMS implementation, ensuring the long-term success of the system.

Ready to Transition Your Salesforce Org to Lightning Experience? Here Are 3 Things to Keep in Mind

Karan Mohan September 27th, 2018 by

We’ve all gone through change —sometimes good, sometimes bad—but worst of all is the unknown. The transition of your Salesforce organization from Salesforce Classic to Lightning Experience (LEX) can seem like a daunting change with a lot of unknown, but there’s a lot to be excited about.

You would be relieved to hear that transitioning to Lightning is primarily a change in User Interface (UI) and should have no effect on your data or any business processes.

1. Reports

One of the most used changes has been made to Reports and Dashboards. The Lightning Experience brings more actions within easy reaches, such as being able to edit, run, and export reports all from the Reports home page. Dashboards in LEX are as customizable as ever, allowing you to bring life to your home page with graphs, charts, and metrics that all are dynamically adjusted to match the size and shape you want. While reports are editable in both Lightning and Classic, once Dashboards are transitioned to Lightning, that they are no longer editable in Classic.

2. JavaScript buttons

Do you have any JavaScript buttons in your Salesforce organization’s page layouts? Unfortunately (or fortunately!), you will have to say goodbye to these and embrace Lightning. Lightning actions provide you with most of the use cases of JavaScript buttons such as updating a record, sending an email, or even launching a flow. There’s even a tool that you can use to scan your org’s JavaScript buttons and will convert them to Lightning actions for you.

For more customized actions, you can create a Lightning action that launches a custom VisualForce page or Lightning component with embedded JavaScript.

3. Global Search

Do you have a couple accounts in your org that are the same name but can’t find out which one you need? Maybe knowing the location gives you enough information to know the difference. While you could already modify search result layouts in Classic, Lightning allows you to customize and add additional information to the global search bar’s preview and find what you’re looking for even faster. You can make specific customizations to each object’s Search Results. For example, you can display an Account’s location while Contacts can have their Title appear.

Think you’re ready to make the leap? Contact our team and we will assess your org’s Lightning Readiness and create a Lightning Migration Plan!

Best Practices Around Salesforce Security Groups

Avatar photo August 9th, 2018 by

What Is a Salesforce Group?

If you’re reading this, you are somewhat familiar with Salesforce and maybe even its groups construct. Essentially, a group is a group of users with the same level of access to specific records within the organization. Salesforce offers some great explanations on groups.

Here’s an example: Say there is a marketing department Company Inc., that has just started using Salesforce. Company Inc. can establish a unique set of rules for each department that would later be applied to their respective groups in Salesforce.

Imagine that within Company Inc.’s marketing department, a subgroup has been asked to work on a new marketing strategy, that requires information that normally only the accounting department has access to. It would be inefficient for the marketing department to go through someone in the accounting department every time someone needs information. Adding the marketing team members to the accounting department group, however, would be a serious internal security flaw. Here the need arises to give some, but not all, members of the marketing department access to only some, but not all, accounting information.

This problem can be solved by constructing a new group that has specific permissions to marketing and accounting information. The small subgroup of marketing team members would remain part of the marketing department’s Salesforce group, they just now have more access as long as this newly created group is active and the staff member is a member of said group.

The Who

Groups are defined through roles and group member types. Roles are essentially the specific job title: “CEO,” “Vice President of Internal Affairs,” etc. Roles are a subtype of group member type and will always be positions within the company. Group member types denote the relationship to the company, similar to roles, but do not necessarily come from within the company. For example, customer portal users and partner users are group member types for which permissions can be set, but they are not working members of the organization and do not contribute to the company hierarchy.

Be conservative with assigning permissions when setting up a group: group members should access the data necessary to perform their job functions, but no more than that.

The What

The best way to figure out how to assign permission is in a top-down fashion. Should the President of the organization have access to employee salary information? If yes, then should the Vice President have access to this information and so on and so forth. As soon as we find a level that should not have access, we can safely assume that their subordinates also do not need that level of access and move on to the next object permission, saving us a little time for each object. The most important thing to take away here is that the level of access of each person should be determined before assigning permissions. This will keep the rest of the process simple and straightforward.

The next thing to consider is whether permission for a certain task should be permanent or temporary. If the changes are permanent, it may be better to alter permissions in the role or profile. If the changes are temporary, it may be better to create a new permission set or group. In order to experience the true power of Salesforce, roles, profiles, and permission sets should be used in tandem with groups so that every single employee has exactly the level of information they need.

Roles, Profiles, and Permission Sets

Set of individual fieldLet’s expand on the Company Inc. example further: Sharon, a member of the marketing team, needs even more access to accounting information than the rest of her group? It would still be insecure to simply put Sharon into the accounting group. If a new group was made every time someone in the organization needed unique permissions, the groups would eventually become far too unmanageable. This is where roles, profiles, and permission sets come into play.

The Salesforce Admin can create a unique role for Sharon to access the specific accounting records that she needs. By default, Sharon’s permissions from her role trickle up to her superiors. Sharon’s permissions are based on the role or group that grants a higher level of access

criteria for creating groupsBy editing a profile, the level of access can be determined by each individual field. If Sharon’s profile also needs to be configured to only view certain fields of a record while others remain hidden, Sharon’s profile can be altered.

Permission sets should be used If permissions need to be granted to up to a select few individuals for a limited time on a field by field basis. Permission sets are defined once, and can then be applied to user profiles individually. Permission sets are part of one’s profile but do not alter the base settings of their profile. It is more of an addendum, like a sticky note with extra permissions on it that you attach to a notebook page of permissions. This makes granting temporary access very easy. Permission sets can be activated and deactivated so there is no need to remember someone’s permission settings before granting more permissions either. One can simply remove a permission set from an individual’s profile, like pulling a sticky note off of the notebook, to remove individual access while keeping the permission set active. Alternatively, one can also delete the permission set in general, removing the access from everyone with that permission set in their profile. Let’s talk about some criteria for creating groups.

Now You Know How; Here’s How to Well

And now for the main event! Now that you know a little about groups in Salesforce, we can finally get to some good practices to ensure that your data is as secure as possible.

1. Audit regularly: Change is a natural part of growth, and organizations are no exception. It makes sense that as your organization changes, so will the privileges that should be available. Auditing the privileges of all members of the organization is crucial to maintaining the integrity of the data of your organization. It will prevent privileges from accumulating on old accounts and users, and may even reduce some redundancies of your groups and permissions sets because there will be at least one person with detailed knowledge about the hierarchical structure of your organization.

2. Use the principle of least-permissions: As stated before, groups should only be able to see as little information as necessary in order to still complete their work. This ensures that all unnecessary data, regardless of content, is safely protected from any possible internal threats. Assign divisions that will need permanent access to the same records to groups. Assign roles to individuals that will need permanent access to records their group does not have permissions to access. Assign permission sets to individuals that will need temporary access to information that their group does not have permissions to see.

3. Keep it simple: The organization should be developed using as few groups as possible. By using as few groups as necessary, the data stays restricted, leaving fewer users as potential vulnerabilities. It is also easier to manage.

4. Utilize roles, profiles, and permission sets: Roles, profiles, and permission sets make up for all possible impediments created by using groups. No matter what type of access someone needs and no matter how long they will need it, Salesforce has ensured that you will be able to give them this access as quickly and fluidly as possible.

Salesforce does a great job of providing the tools for us to secure our data. By utilizing good practices, you can create complex but secure hierarchies that allow your business to blossom without worrying about security vulnerabilities from within your organization.

Synchronizing Single Sign-On (SSO) with a Domain Cookie, Part 2: Technical Considerations

Hans_Stechl fusionSpan Team July 25th, 2018 by

In the previous post, we went through an overview of SSO with a domain cookie. In this post, we’ll dig into some of the technical considerations when implementing this SSO solution.

System Overview

As an overview, here are the responsibilities of each website from the previous post:

  • AMS.abc.org (Identity Provider/System of Record):
    • Provides login page
    • Provides logout page
    • Manages Tokens and SSO cookie.
    • Provides SlideCookie page/handler (more on this below)
    • Provides API to validate Tokens
    • Inspects SSO cookie on every page request
      • Validates Token against API on every page request (server side)
      • Automatically logs the user in if the Token is valid.
      • Automatically logs the user out if the Token is not valid.
  • LMS.abc.org and CMS.abc.org (Service Provider sites):
    • Redirects user to AMS.abc.org Login page
    • Redirects user to AMS.abc.org Logout page
    • Inspects SSO cookie on every page request
      • Validates Token against API on every page request (server side)
      • Automatically logs user in if the Token is valid.
      • Automatically logs user out if the Token is not valid.

Note: While this example has the login page on the Identity Provider only, this solution can also be implemented with login pages on the Service Provider assuming the Identity Provider offers an open API, but does require additional development work.

Technical Considerations

As you’re getting into your SSO implementation, there are a range of technical aspects that you need to consider. Here are a few items worth thinking through as part of your implementation.

Session Synchronization

  • Sliding SSO cookie and Token (Tickling) – The “tickle” to slide the SSO cookie and the Token  can be accomplished by referencing the ams.abc.org “cookie-sliding” page or handler with an image tag  such as <img style=”display:none” src=”ams.abc.org/slidecookie”></img>
  • In-Process sessions between all of the websites do not have to be in synch. The SSO cookie along with the API validation will keep all of the websites informed if the user is authenticated. So a session can be restarted seamlessly for the user.

Redirect Loop

  • If you encounter a redirect loop, it is most likely related to the SSO cookie.
    • Check if the cookie is in fact being generated and has the proper Domain attribute. Fiddler is a good tool for this.
    • Check that the cookie is being sent to all of the websites. If it is not, then it might be an issue with Http to Https switching, or an inconsistent “Trusted Sites” configuration in Internet Explorer.
    • Individual users may also have blocked cookies on their browsers. Providing some basic error message text on the login page notifying them they will need to enable cookies to proceed. It may be worth analyzing your users prior to implementation to understand what percentage of your web visitors have disabled their login.

Security considerations

  • HTTPS: This is a general best practice of any website that requests or displays sensitive information. On a login page, make sure it is served over https such that communication is properly secured with a Secure Socket Link (SSL) Certificate issued by a Certified Authority (CA).
  • Secure Cookies: The SSO cookie should be flagged as a “secure cookie” by including the Secure attribute with the cookie. This instructs browsers to not send the cookie along with a request to an HTTP URL even if it is to a resource on the same domain.
  • HttpOnly Cookies: The SSO cookie should be set as “HttpOnly”, which is accomplished by setting the “httponly” cookie attribute. This helps protect the SSO cookie by instructing browsers to deny browser-side alteration to the cookie (i.e. using javascript)
  • CSRF: As with any cookie, your SSO cookie can be vulnerable to Cross-Site Request Forgery. Implementing the proper safeguards against CSRF is highly recommended. You can refer to the OWASPs cheat sheet for more info on CSRF: https://www.owasp.org/index.php/Cross-Site_Request_Forgery_(CSRF)_Prevention_Cheat_Sheet

Conclusion

SSO synchronization is more often than not an afterthought of SSO implementations. There are other methods to accomplish SSO synchronization between multiple websites, including those that are on different domains, however if your websites share the same Top-Level-Domain, then an SSO Domain Cookie approach is a simple and a fairly straightforward method to implement.

Synchronizing Single Sign-On (SSO) with a Domain Cookie, Part 1: An Overview

Hans_Stechl fusionSpan Team July 19th, 2018 by

There are a number of different implementations for Single Sign-On (SSO). SSO is generally approached in one of two ways – The first is a browser-side implementation which usually involves an integration that redirects the user to an Identity Provider’s login page (Identity Provider is the website that is the system of record in which the user accounts reside), while the second is a back-end integration that consumes an Identity Provider’s web services (API) to authenticate users.

New call-to-action

 

The usefulness of most SSO implementations tends to end at the moment of authentication. This is sufficient when all is needed is to allow users to authenticate and validate the user’s authorization. Unfortunately, for organizations that own and manage multiple websites, the challenge beyond authentication lies with “synchronizing” the login sessions of all of the websites, and maintaining a seamless user experience which would ideally look something like this:

  • Single Sign-On: When the user Logs In to any of the websites, then whenever she/he navigates or is redirected to one of the other websites, she/he is automatically logged in.
  • Single Sign-Out: When the user Logs Out of “any” of the websites, she/he is unable to access restricted content on any of the other websites. In essence, the user is Logged out from the other websites as well.
  • Session Expiration: Whenever the Identity Provider’s session “Expires,” the user should not be able to access restricted content on the other Service Provider websites.
  • When a user’s session on a Service Provider website expires, it is automatically restarted if the Identity provider’s authenticated session is still active.

Imagine you work at ABC company, who owns and manages 3 websites:

  1. An Identity Provider website: AMS.abc.org, and
  2. Two satellite “Service Provider” websites: CMS.abc.org and LMS.abc.org.

Your customers can access courses and the community through the LMS and CMS websites respectively, and the AMS website is the system of record in which the user accounts are managed.

If you have the good fortune of having all of your organization’s websites on the same Top-Level-Domain (TLD) as in this case, “abc.org”, then a Domain cookie approach for a seamless SSO user experience might be a good option. Let’s examine how this works.

How it works:

AMS.abc.org is the Identity Provider. In other words, it is the system of record in which user accounts are managed, and it is therefore the website that will either serve the Login page, or will provide an API to be consumed by the other websites in order to authenticate users – note the latter assumes that the service provider websites are under our control and are trusted to pass-through the username/password. For our example, we will use the former.

Once a user successfully authenticates against AMS.abc.org, an authentication Token is issued and stored on the server – in some type of a database. A domain cookie (SSO cookie) is also created which contains aToken. The Token is temporary, unique, and very difficult to guess. A GUID works nicely. After this the user is redirected to the intended page. The intended page can be inferred from the URL referrer or can be specified in a URL parameter which is passed along with the URL when the user is sent to the Login page.

Because the websites share the same TLD and the SSO cookie is flagged as a domain cookie, the browser will send the SSO cookie along with any browser request to any of the websites on the same TLD – in our example, this includes LMS.abc.org and CMS.abc.org (both end in abc.org). When a request is made to a any of these Service Provider websites, the website inspects the SSO cookie, and takes the following actions:

  1. If the SSO cookie exists, the Token is extracted from the SSO cookie, and is validated against the AMS API – The validation can take the form of an authenticated web service call (SOAP or REST).
  2. If the Token is valid, the user is logged into the Service Provider website, and any additional user information authorized by the AMS to the Service Provider can be also requested from the AMS’s API.
  3. If the SSO cookie does not exist, or the Token is not valid or has expired, the user is redirected to the AMS.abc.org Login page.

Below is a diagram that illustrates the flow:

There are two mechanisms in place now that can help keep our sessions in Sync:

  1. When the user logs out from any of the websites, she/he is redirected to a logout page on the AMS.abc.org website. This page invalidates the Token and deletes the SSO cookie. Then the user is redirected to the website from where she/he logged out. Since the SSO cookie is no longer available and/or the Token is no longer valid, the Service Provider will know to “clear” the current user session, and redirect the user to either the login page or another landing page.
  2. Synchronizing Login timeouts is accomplished by setting a timeout on the SSO cookie, and keeping the Login session alive is accomplished by sliding the SSO cookie and Token by “tickling” the AMS website- this can take the form of an HTTP Handler on the AMS website that is referenced by every page on the Service Provider websites.

In-Process sessions can expire at any time on any of the websites – they do not have to necessarily be in sync. The user may still be “logged in” on LMS.abc.org even if the SSO cookie and Token are expired or deleted; for this reason LMS.abc.org MUST inspect the SSO cookie and validate the Token on every request. On the flip side, if the LMS.abc.org “session” expires due to idle time, the SSO cookie and Token can be inspected and validated when the user requests the next page which would automatically log the user back in and start up a new session.

We just released a follow-up to this post!  Continue to Part 2 for technical considerations for an SSO domain cookie implementation.

If you have not already, click here to sign up to receive notifications on all fusionSpan blog posts.

New call-to-action

fusionSpan’s experience at Xperience18!

justin fusionSpan Team May 17th, 2018 by

Last week fusionSpan was at Community Brand‘s User Conference – Xperience18! Five days packed with lots of learning, sharing and connecting. Here are a few highlights!

fusionSpan was networking

We had a booth. Community Brands has compiled quite a cornucopia of products, which in turn meant there was a unique range of organizations at the conference. From small non-profits searching for ways to get the most out of the tools they have, to large associations looking to expand the services they offer their members, we spoke with organizations in the exhibit hall about a range of challenges they were trying to address. With fusionSpan offering services related to Salesforce, netFORUM, and WordPress, we were ready to talk solutions!

As with any good booth, we had giveaways! And not those pens that leak in your bag. We looked to, “grow new partnerships” with clients and vendors by giving out Forget-me-not seed packets – one in ever conference bag that was handed out. For those looking for a little sweetener, we also had our popular chocolate bars. Don’t worry, we hand carried them from DC to Florida to ensure there was no melting in transit!

fusionSpan was sharing

We had five presentations. One session looked at how to integrate your CRM tool with other systems without code. Another session focused on maximizing your ROI with Salesforce. fusionSpan even got to present as part of the ever-popular “10 Toolkit Tips you can do in 10 minutes” session focused on netFORUM Enterprise. With only 10 minutes we pulled out all the stops – there was learning, there were jokes, and there was even some juggling. Surely he can’t be serious? I am serious — and don’t call me Shirley.

fusionSpan was connecting

The user conference was also the first time we get to meet several clients in person. With all the great social events planned during the conference, there are lots of opportunities to get to know people beyond work. Granted, rarely do you get to connect with clients over a front row roller coaster ride at Universal Studios. Let’s just say it was a thrilling Xperience!

Say cheese!

GDPR or: How I Learned to Stop Worrying and Love Data Protection

Christi Liongson April 5th, 2018 by
European Union flag with a padlock in the center

By now, you may have heard about the European Union General Data Protection Regulation (GDPR) that is rattling companies from technology titans like Facebook to small businesses with a website. In short, the GDPR is a legal framework that sets guidelines for the collection and processing of personal data of individuals residing in the EU. The new policies set by GDPR and the ePrivacy Regulation are some of the most significant changes in data privacy regulations in 20 years and will dramatically change how organizations worldwide collect and process data.

If your organization works with data on EU residents, you will be required to comply with GDPR once the regulation goes into effect on May 25, 2018. Non-complying organizations may be faced with fines of up to 20 million Euros or 4 percent of total yearly revenue per incident.

The main purpose of this historic regulation is that GDPR grants consumers and individuals a range of data subject rights. With significant data breaches and other data scandals such as Cambridge Analytica, Equifax, and, most recently, MyFitnessPal, continuing to make headlines, organizations are being pressured to treat data privacy as a right.

GDPR will have strongly affect how your organization processes data, regardless of which side of the Atlantic you are on. By complying with GDPR, your organization shows that you prioritize your members’ and users’ trust.

Ten Steps to Embracing Privacy by Design at Your Organization

1. Educate your staff, and get buy-in from your top stakeholders.

Don’t be mistaken — GDPR is not solely an IT issue . Whether they work in accounting, membership, or government relations, your staff handles a great deal of data.

Educate your staff on personal and sensitive data , and have everyone, from your leadership team to your boots-on-the-ground staff members, make privacy compliance and data governance a priority in your organization. Privacy by design and default is a key part of data protection. Make it a point to regularly discuss data protection at senior management meetings to maintain staff awareness.

2. Appoint someone on your staff to be the Data Protection Officer (DPO).

While your organization might not be legally required by the GDPR to appoint a DPO, we recommend having someone — or even better, a group of staff members — in your organization to be your internal advocates for data protection.

These people should be well-versed enough in your organizational structure and IT infrastructure to help internal staff understand data protection as it relates to a staff member’s tasks and goals. They should also maintain records of data processing activities, and lead regular audits to ensure privacy compliance and proactively address potential issues.

3. Comprehensively assess your data.

One of the best ways to prepare for your transition to privacy by design and solid data governance is to understand your organization’s data inside and out.

The more honest, transparent, and comprehensive your data audit is, the easier it will be to identify ways to change your business process to ensure GDPR compliance.

When reviewing your organization’s data, think of the 5 W’s:

  • Whose data is being collected, processed, and stored?
  • What data is being collected, processed, and stored? Of the data you collect and process, what is personal and what is sensitive?
  • Where is data being collected, processed, and stored? Remember: Excel workbooks also count!
  • When is data collected, processed, and stored?
  • Why is data being collected, processed, and stored?

4. Review how you are getting data and consent from your users.

In addition to answering the “5 W’s” in your data audit, make sure you are also taking note of how you are gathering data and getting consent from your users to gather, store and process their data. Under GDPR, user consent must be explicit, freely given, specific, and unambiguous . This means that users must not be required to hand over their information to use a service, nor should they be automatically opted-in for emails and communications upon signing up for a service.

Be sure to take note of all your organization’s methods of data collection, including member registration, newsletter subscription, and meeting registration forms and well as any cookies and tracking pixels installed on your web properties.

5. Review your third party vendors.

Under the new data protection regulations, any third-party data processors that you use is legally obligated to be compliant with GDPR. This is the time to take stock of any third party vendors that process information on your behalf, and note whether they are GDPR compliant, or if not, what steps they are immediately taking to be GDPR compliant.

Common third-party vendors that associations use include:

  • AMS or CRM
  • Websites
  • Web Analytics Software
  • Email service providers or marketing automation platforms
  • Meeting planning or registrar services
  • E-Learning services

6. Review your data policies and procedures.

Although your third-party vendors are required as data processors to make their software GDPR-compliant, they are not responsible for your internal policies and procedures. Take stock of your organization’s policies and procedures on how you collect, process, and store data.

While reviewing your organization’s processes, make sure that you are answering these four questions that relate to several key principles of GDPR:

  1. Does your organization have data retention policies? Do you have a process for data deletion, if the individual makes the request?
  2. How does your organization evaluate and assess new data sources, technologies, or business processes?
  3. Does your organization have an internal process and communication plan in the unfortunate event of a data breach?
  4. Does your organization have a legal basis or ‘legitimate interest’ in the data that is being gathered and processed?

7. Understand Individuals’ Data Rights under GDPR.

One of the most significant changes that GDPR brings is that the regulation grants ownership to an individual’s data to the individual, not to the organization.

The GDPR introduces these eight data rights for individuals.

  1. The right to be informed
  2. The right of access
  3. The right to rectification
  4. The right to erasure
  5. The right to restrict processing
  6. The right to data portability
  7. The right to object
  8. Rights in relation to automated decision making and profiling.

The Information Commissioner’s Office (ICO), the UK’s independent body to uphold information rights, created a Guide to the General Data Protection Regulation that goes more in-depth on these new individual data rights, and what steps your organization to ensure the individual’s data rights are protected.

8. Perform a Data Protection Impact Assessment (DPIA) to minimize privacy risks.

GDPR recommends risk assessment be an ongoing and continuous process. Your first GDPR risk assessment will go a lot smoother if you have done a comprehensive data audit.

The ICO also created several checklists to evaluate your organization’s data protection compliance and also suggests actionable steps to improve your GDPR compliance.

9. Create an action plan to improve your organization’s data governance.

Once your data audit and risk assessment have been completed, create a roadmap to plan any necessary data migrations, consolidations, and policy and process changes.

10. Review your terms of use and other privacy communications

Finally, once your data audit is complete and you have planned your processes and procedures, meet with your legal team to revise your Privacy Policy, Terms and Conditions, and other privacy communications to be in compliance with GDPR.

Enterprise AMS: When is a customization right for you?

justin fusionSpan Team March 29th, 2018 by

Organizations choosing enterprise-level Association Management Systems (AMS) likely do so for a range of reasons. They know they’re getting a product with a rich feature set and all kinds of configuration options. They know they’ll have a greater deal of flexibility. But, likely most important, is the system can be customized to their need.

Unfortunately, customizations are a double-edged sword. On one hand, they allow the organization to completely mold the AMS to their business needs. On the flip side, customizations require extra maintenance, which is work. With that in mind, here are a few items to consider when considering a customization.

Make sure it’s a business need

When staff says, “We need the system to X because that’s how we’ve always done it.”  SIRENS should start going off. Often old processes are built around an old AMS, and if you really liked your old system, WHY DID YOU GET A DIFFERENT AMS?!? Customization should always be driven by either a business rule or business need. Business rules are usually listed in the by-laws of the organization, and business needs are a feature that will help deliver against the business goals of the organization. Requiring staff to draft up a business case for new customizations is not excessive. If nothing else, staff willing to put in the effort to come up with a business case obviously have a little conviction behind their customization request, while the folks who think it’s too much work will likely figure out how to fit their processes within the baseline.

Clearly define purpose

As part of a business case, there should be an understanding of “WHY?” a customization is needed. Too often customizations focus on how they will work, with no conversation about “why.” Having a “why” clearly defined helps ensure the effort always matches up with the purpose. If you just focus on the how, you can end up 100 hours into a development project before you know it, and if the customization only helps one person save 8 hours once a year, you’ve made a mistake. Even if you do need the customization, there will inevitably be opportunities for scope creep. With a defined purpose any scope creep items you can ask, “Does this help address why we need this customization?” If the answer is no, then keep it out of scope.

Build for flexibility

Most customizations are built to fix an issue now. Which is good — until you’re no longer in the now.  In time, you will find yourself painted into a corner.

As part of the design process, try to identify input values. These could be inputs into formulas, text descriptions, drop down fields, or any other number of values. With each of those inputs, make sure the values are captured in an area that is easy to update without having a developer get involved, either in a control panel, system option, or some other feature that can be edited, instead of having the input value hard-coded into the customization.

Think of a spreadsheet, where you have to multiply a bunch of values by 20%. For each of those fields you could go in and type 20% into each field, but then if your boss comes back and says, “Actually, we need to do 25%,” you’re now stuck finding and replacing each 20% in your spreadsheet. Instead, what you want is to type 20% into one field, then everywhere in your spreadsheet where you multiply by 20%, just reference that field. That way when you need to switch to 25%, you only have to make one change.

Granted, building for flexibility usually requires a little extra work, so balancing the right amount of flexibility against your budget is a per-project judgment, but some are always better than none.

Conclusion

While everyone wants a perfect system out of the box, most enterprise level associations will inevitably need to customize. Being strategic, purposeful and flexible with those customizations will serve you well in the long-term success of your organization’s AMS.

Delayed Gratification and your CRM

justin fusionSpan Team February 22nd, 2018 by

Did I lose my special treat?” A frequent question from my son. We’ve created a system in our home where if he behaves, he gets a “special treat” after dinner – usually in the form of 22 minutes of TV. While there are some issues with the system (what’s the leverage for behaving once he’s lost this special treat?), overall the incentive has succeeded because we’ve taught him about delayed gratification. That may seem like an easy task, but given how abstract the concept of time is to a child, he only figured it out after repeating the same process over and over.

Working with a customer relationship management (CRM) system presents a similar problem – people must do work now to reap the benefits later. A CRM can provide amazing insights into your customers, but only if people take the time to ensure data gets into the system. That requires staff to change their processes and spend time now to get results later. It’s not easy, but here are a few steps to get you going.

What’s your treat?

Promising a child a big piece of chocolate cake and then trying to give them one Oreo cookie and calling it even will not go over well. The same goes for staff. Too often a CRM is promised as the fix-all for everything – then when the CRM inevitably fails to deliver, staff discount the tool as a failure. Instead, try selling what you have. Talk about how an Oreo cookie goes great with milk. How much fun it is to twist an Oreo to separate one of the cookies from the cream. How an Oreo is kind of like getting two cookies!

For your CRM, talk about what specifically will be tracked in the CRM. Identify current processes – likely related to reporting or tracking – that will be significantly easier and/or less time-consuming because of the CRM. Point out that having one set of customer data means that when a customer’s email bounces, only one person needs to fix it and it will automatically update for everyone else. Focus on the true value of the CRM.

What’s a reasonable timeline?

My four-year-old recently asked, “How many minutes until my birthday?” When I informed him it was approximately 383,000 minutes away, a mix of disbelief and terror seemed to wash over him. While birthday presents are a great example of delayed gratification, they’re too far off to provide motivation – I need to provide an incentive that is more tangible.

Same goes for the CRM. Providing those early wins builds momentum towards long-term goals. Show how a list of contacts entered today can be pulled as a report tomorrow. How financial transactions being entered in the CRM can help reconcile the General Ledger. How tasks that used to take five steps now take three steps. While the longer-term results may take six months to a year out, short-term successes help reinforce the necessary processes that allow you to reach your long-term goals.

Who’s the parent?

While it’s never any fun, parents need to remind their kids that they must EARN that gratification. Whether through following directions, helping with chores, or remembering to say please and thank you, there needs to be effort to earn the gratification. If the child still gets their “special treat” even if they don’t use please or thank you once, then they have not learned anything. The parent needs to hold the child to their end of the bargain.

For work, that means ensuring staff are entering customer information into your CRM. They must follow the processes and take the time to ensure the information is complete. Initially, this will likely include regular reminders to staff about the processes. Auditing the data on a regular basis will help identify individuals not in compliance with the processes so that more targeted interventions can occur. Change doesn’t happen overnight, so don’t give up. And if all your intervention does not work, do not then do the work for them. Otherwise they will never learn.

Conclusion

While getting the most out of your CRM takes work, the effort will be worth it. There will come a day when staff just enter all their information into the CRM and children will wash the dishes without being reminded. And you will get an extra 30 minutes to of “me time” – which will be your delayed gratification.

Underutilized Technology: Getting the Most of Your System

justin fusionSpan Team October 12th, 2017 by
Underutilize your systems and they turn into old rusty clunkers - like a tractor at a kids playground!
Underutilize technology and it will rust away…

As part of an office redesign, an organization I used to work at installed all new screens in the conference rooms. They also installed two large touch screen projectors that allowed for an “interactive” presentation. Instead of sitting behind their laptop, the presenter could control their presentation directly from the projection screen, making for a more engaging and collaborative experience. Except it wasn’t. Few staff bothered to learn how to use or even connect the screen to their computer, primarily using the screens to just display presentations. Because they leveraged projectors, the image was inferior to the HDTV screens. So, what seemed like superior technology turned out to be inferior in practice.

Too often new technology is introduced to an organization at great cost without addressing the strategic purpose or plan for the tool. This results in under-utilization of the technology, which in turn leads to wasted resources. Avoiding this waste requires thoughtful preparation, implementation and operation of new technology. Consider leveraging the following four steps to ensure success.

Define success

New technology should be trying to solve a problem. Make sure to articulate the problem and expected improvements once the tool is in place. And it cannot be that, “once we implement X, everything will be great!” That’s the perfect way to set technology up to fail. Instead focus on specific measurable outcomes you’re planning to accomplish with the new tool.

Identify relevant use cases

When working with small organizations, nothing makes me cringe more than the phrase, “Well at Amazon they…” or, “You know Apple uses…” It’s like comparing an orange with an entire apple orchard. There are tools tech giants use that are relevant to other organizations, just make sure you identify how your organization is going to apply a tool. A great example is Slack. Slack can be an incredible collaboration tool. But if staff don’t understand how their processes fit into the tool, then adoption is likely to be low. Connect the tool to the process, and you’ll have a much greater chance of success. Which relates to my next point.

Personalize training

Everyone is busy, which is why processes rarely change. Assuming a new tool will encourage change is a mistake. Because everyone is so busy, no one has time to identify the best ways they can leverage new technology. Instead, people will identify ways the new tool fits in their current process without disturbing anything else, which likely underutilizes the tool. People focus on what they understand and ignore the rest. Personalized training helps remove the burden. Staff don’t have to invest as much energy into the tool. Accomplish this with a pilot group who is willing to invest in the tool and can the role it out to the rest of the organization. Or have trainers conduct follow-up one-on-one sessions with staff to see what they are doing and identify any potentially new processes. Explain the tool in their terms, and they’re much more likely to understand the bigger picture.

Measure progress

Everyone measures how their customers engage with their technology, but what about staff? Many tools allow for some level of reporting on staff usage. How often do staff login? What functionality are they leveraging? If a direct messaging system was introduced, has there been a decrease in emails? If a cloud storage solution was introduced, is the system holding machine back-ups seeing less data usage? This all goes back to the first point on defining success – how will you know you’re there if you never bother to measure your progress? If you never stop to check the map, how can you confirm your headed in the right direction and not about to drive off a cliff.

Being more strategic in the tools you implement will likely mean you leverage fewer tools, but that’s likely a good thing. Fewer tools means less learning by staff, which results in them spending more time focused on their actual work. While at times taking a short cut to a quick implementation of a new tool may seem optimal, you’ll end up waste both staff time and financial resources in the long run. If you are strategic when you start, and you will succeed in the long run.

A similar version of this post was originally published on IT Chronicles.

Refresh expiring Salesforce X509 certificates

Avatar photo September 14th, 2017 by

Tired of receiving the “You have one or more certificates in your Salesforce org XYZ* that will expire soon…” notices? Or worse, when your CEO receives it and sends a panicked email to you at 3 in the morning?

You can solve the countless email bombardment, for you and your users, by creating a new certificate and transitioning all your connected Apps and API’s to use the new certificate. SSL certificates in Salesforce are used by Connected Apps using SAML, SOAP and REST APIs. This post will take you through the steps of creating new certificates with longer expiry dates to replace the expiring ones.

The process of creating and configuring a new certificate is fairly straightforward and can be done in 2 fairly quick steps:

The issue is that Salesforce, by default, will create self-signed certificates that are valid for only a year. This means that every year you have to create new certificates. The process (as described above), is relatively painless, but most of these Connected Apps are third-party integrations, which means there is a whole lot of coordination needed to migrate these applications to use the new certificate. The actual work is relatively easy and just involves importing the certificate by these third-party systems/vendors. The coordination to make it happen and then test all of these integrations is time consuming.

One way to mitigate is to not rely on Salesforce, and just generate these certificates with longer expiry dates.

Note: Most Certificate Authorities (CA) will only issue shorter term certificates because they want to be able to guard against private keys that get compromised. Since we are using a single self-signed certificate, we can change the key and certificate on our schedule.

Openssl is an excellent open source tool to do this. Here is a quick-and-dirty guide to generating a certificate for use with Salesforce:

Step 1: Generate a self signed certificate valid for 10 years

openssl req -x509 -newkey rsa:4096 -keyout key.pem -out cert.pem -nodes -days 3650

Here the -days flag is setting the expiry date of this certificate for 10 years. You can set it to any number of days.

Step 2: Convert the certificate and key into pkcs12 file

openssl pkcs12 -export -in cert.pem -inkey key.pem -out server.p12 -name salesforce_cert

Note: Use a password when prompted, as you will need it later.

Step 3: Import the new certificate into a keystore file (the format Salesforce expects)

keytool -importkeystore   -destkeystore server.keystore -srckeystore server.p12 -srcstoretype PKCS12 -alias  salesforce_cert

Step 4: Import the new certificate into Salesforce

Go to Setup->Certificate and Key Management->Import from Keystore

and then import the keystore file created in Step 3.

You now have a new certificate available that is valid for 10 years. Just modify any of your connect apps to use the new certificate. And send the public key (cert.pem from Step 1), to any of the external system, so that they can continue working with the new certificate.

AMSFest – Up close with an AMS

justin fusionSpan Team September 22nd, 2016 by

img_3461fusionSpan was at AMSFest, put on by Teri Carden, founder of ReviewMyAMS.com. It’s an intimate event where association professionals can get an up-close look at a bunch of different AMS (association management systems) vendors all in one place. They also can talk with industry partners (like fusionSpan) about what the trends are and what they should have on their radar. Very informative for both organizations beginning the process of moving to a new AMS as well as organizations just looking to stay abreast of the latest news related to association technology. Highlights included:

AMS Implementation

Heard from Rene Shonerd who is currently implementing 5 AMS systems at once. A little crazy, but sometimes you just got to do what you got to do. She pointed out that before making a move, associations should always reassess their current system – new feature come out all the time, and those new features may solve your current issues. If you do decide to move, make sure to rank the importance of different feature BEFORE looking at systems – don’t want to make a decision based on some shiny object that isn’t business critical.

SSO and API

Featuring fusionSpan’s very own Gayathri Kher, this panel dived into the nitty-gritty of SSO (single sign-on) and API (application programming interface). While all AMS vendors can check a box that their system does have an API, not all APIs are built the same. As you are getting ready to make a purchase, ask them to demonstrate the capabilities of their API, budget money to maintain your integrations, and understand that, as the name suggests, you will need a programmer to do some programming. There was also an interesting conversation around Middleware that can serve as a cog to connect multiple systems, but can also be costly.

Investors Discover

Lots of AMS vendors are buying and being bought. A vendor being purchased could be a good thing – the panel noted that generally only good companies get acquired. It could also mean trouble – an acquisition likely means a change in culture. Key takeaway for associations? Ask questions – reach out to your favorite employees at that organization and see if they are sticking around. If they are leaving it may be a red flag of things to come.

Was a very informative event with lots of very knowledgeable speakers donating their time to put on a great event. Plus, if you’re about to begin the search for a new AMS, may as well do it at a location with a rooftop networking event. We had a great view of the Capitol, Union Station and the rest of the DC skyline.

img_3473

Summer Cleaning Series: Database

Avatar photo June 16th, 2016 by

150px-Summer_time.svg Where has the time gone?! This year has flown by, and today marks the first day of summer! If you’re like me, you have left a lot of opportunities for spring cleaning untouched so here is our chance to redeem ourselves. Spring cleaning applies to your home but I am introducing Summer Cleaning, that applies to work and goes beyond cleaning out the piles of paper in your drawers.

There are three areas that we can focus on at work (database, website and network systems). In this post we talk all about cleaning your database. We know you are super busy with your everyday tasks but once a year it is good to take a step back and think about the bigger picture.

Here’s what you should ask yourself:

hqdefault

  1. How am I entering data? Is this the most efficient way?
  2. Am I replicating any steps or doing double entry at any point?
  3. How am I using the data I put in? Are there parts that I don’t use?
  4. How long does it take to get the data I want out of my database?

There are two approaches to fixing or improving these four areas of your database. The deep clean and the touch-up method vary quite a bit but I must reiterate that doing something is better than doing nothing!

Summer Cleaning

The Deep Cleantouchup 2

1. Integrations: Does your answer to #1 include manually entering data from another source, like a CMS, event registration system or online form? This can be a huge time drain. Most AMS (Association Management System) have a way to integrate with other systems and pull data out of the AMS and then put information back in. You could leverage SSO (single sign on) between your different systems. Having them talk to each other will allow information to be updated in your AMS seamlessly.

2. Process Review: Are you manually creating accounts but could be using your AMS’s import tool instead? You may not know your AMS has an import tool so I would recommend asking your account rep. Importing and updating records from an Excel could save you lots of time.

3. Data: Are you collecting information that you do not use or have never used? For instance, how important is it to collect a member’s favorite ice cream flavor if you have no use for this data? Maybe it doesn’t require you much effort since this field is already in your system and users fill in the answers themselves, but useless information clogging up your data will not help in the long run. Later down the line, someone will, no doubt, be tasked to clean your data and may spend time trying to figure out if the data is useful or not. Another part of cleaning data is making sure the information you currently have is consistent. Do all your addresses have the same format (Street vs St.)?

4. Reports: Are the reports you use efficient and helpful or are you running reports and manually updating or filtering the data in a spreadsheet before you can use it? If it is the latter, then you need to re-evaluate the reports you use. Can you create a report that gives you the data already filtered, with the search results you want?

touchup 1Touch-ups

1. Could your time be better used elsewhere besides updating user profiles? If you have surges when profile updates are heavy, such as renewal time, then it may be worth it to get a temp to help update addresses from returned mail or update profiles based on member requests.

2. If integrating your various systems seems like too big of a project for right now, find out if you can do mass imports into your database so you can cut down on data entry. Updating a spreadsheet and having that imported will save you some time.

3. Data: If you do not have time to mass clean your data, you can create rules for your data and disperse to your staff. Let them know if they see a wrong address, department name, contact information, etc, to let you know or they can fix it themselves according to the rules you create (Street vs St.). You can’t fix everything, but you can fix what you do find/see.

4. Reports: If you do not have the resources to dedicate to redoing your reports, then brush up on your Excel skills so you can edit the report results more efficiently. You are not limited to copy and paste functions. Excel has so many tricks that you may not know about. Follow our Excel Series to find out more.

mop-1075442_960_720-1 Subscribe to our blog to get notified when the other parts of this series on website and network systems cleaning are released!

AMS Fest Midwest!

Mary Glavin May 5th, 2016 by
images-3May 10th, just 5 days post Cinco de Mayo is another day for celebration in this month of budding optimism; AMS Fest Midwest in Chicago is the place to be and it’s cause for small associations to cheer. Those interested in examining AMS options, communicating their concerns or praises, and networking with like-minded and like-sized organizations will be in awe of such an invaluable event.

(more…)

Documentation: Good for Work and Travel!

Avatar photo April 29th, 2016 by
Koala
Koala on Phillip Island, Australia

Hello Small Staff Big Impact. I’m baack! I’ve spent the better part of the last year traveling around Australia and SE Asia. I’ve met a lot of great people and learned many things. As part of my experience, I held some interesting jobs to supplement my travel income, including crew on a 43 foot yacht and farm hand on a lime farm.

I also got the chance to work with a non-profit in Australia, helping with their AMS. Yes, I found myself staring down another messy AMS situation. I was surprised to find out that they have similar problems to many of our clients in the US and I’d like to share what I learned from this experience.

(more…)

Solving your App-ocalypse: Strategic planning with your technology

justin fusionSpan Team November 5th, 2015 by
app-68002_1280

At this point everyone will agree that software systems have permeated all areas of business. From HR to Marketing to Accounting to Customer Relations, every area requires the staff to utilize some tools or application to complete their job. Yet at many, if not most organizations, there are a mash-up of tools in place that always seem to fall short of meeting the organization’s needs. To make matters worse, attempt to correct issues usually involves adding on another tool, which only further obfuscates the situation. So how do organizations end up with such a dysfunctional set of systems, and how can an organization begin to address your app-ocalypse? (more…)

Women in IT – Interested?

Jessica Sansaet August 14th, 2015 by
“What do you do for a living?” Many people seem surprised when I answer that I work in IT. Almost as if the phrase “woman in IT” is some kind of mythical creature, akin to Big Foot or a unicorn. But should they be surprised?

JSI developed an interest in math and sciences at a very young age. I remember begging my mom to buy me the practice math booklets at the store that were intended for 5th grade and up when I was about 6 years old. I excelled in these areas and was placed in the “gifted” program all throughout middle and high school. For my electives, I took classes such as AutoCAD, Intro to C++, or other computer-related courses. Even then, I noticed something very obvious – there were more boys than girls in all of these classes. (more…)

netFORUM Pro driven WordPress Site

Avatar photo March 24th, 2015 by
blog netFORUM Pro is a widely adopted association management system (AMS). It provides several interfaces that can be used for member interaction.

  • eWeb or “external web” which is a web based interface where members can perform certain actions – like purchase renewals, buy products etc.
  • xWeb is the “XML web service” interface. Mostly a programming API to interact with netFORUM Pro.
  • iWeb is the “internal web” interface, which the administrative users of netFORUM Pro use to manage customer information.

(more…)

Hot Topic – Salesforce Based Platforms

Avatar photo February 27th, 2015 by
DivingboardThere has been lots of buzz lately in ASAE’s Collaborate community regarding Salesforce based AMS/CRMs for associations. Since we’ve got our fingers on the pulse of new trends in the association world, we thought we’d share our thoughts and let you hear from an expert in this arena. (more…)

2014 netFORUM Pro Consulting Giveaway WINNER!

Sheree Santantonio January 9th, 2015 by
Announcement

Congratulations to Caroline from the South Carolina Bankers Association for winning fusionSpan’s 2014 netFORUM Pro Consulting Giveaway. We look forward to working with you in 2015!

(more…)

Grow Your Association Management Career in 2015

adam thocher January 2nd, 2015 by
New Year 2015 formed from sparking digits over black backgroundWith each new year, we reflect on as many of the last 365 days we can remember while simultaneously resolving to [insert unattainable New Year’s resolution here]. For me, 2014 was a big year with more resolutions checked off the list than I had anticipated.  Topping the list are wedding plans coming together, travel adventures from Costa Rica to Iceland and a healthy number of airline miles in between, the Fiancée finishing up her MSW (I can’t take much of the credit for that, but it still makes the top 10 on my list), three days lost in Florida, no longer owning this sail boat, and – perhaps most challenging of all – attaining my CAE credential before I turned 30. (more…)

Integrating Cvent with Avectra netForum Pro

Avatar photo January 6th, 2014 by

One of our clients, a small-staff association, wanted to improve user experience during the annual conference registration . In the past they just used their AMS, netForum Pro to register attendees but increased customer service calls forced them to look for an alternate solution. This time around they wanted to simplify the registration process and reduce the work that their staff will need to do in managing registrations.

Our recommendation was to use a dedicated web based Event Management software. Some advantages of using an online event management software to manage your events and registration are

  1.  Provides online access and a dedicated branded event website.
  2.  Automate the entire event registration. Users could manage their own registrations. Optionally they are allowed to modify their registrations and even initiate refunds.
  3.  Process credit card payments.
  4.  All event and registration data is secure.
  5. Affordable for a small staff organization
  6.  Can integrate with the current membership database.

The first 4 features are pretty much universally supported by most good quality event management software.

Its the last feature that we were most interested in. Reducing staff overhead by letting attendees key in information does reduce your staffs overhead, but this information already exists in your membership database, why enter it again at all? Wouldn’t it be better if most of the registration information is already filled in for your members?

Most of the registration information including attendee name, address and contact information is already in your membership database (substitute with your CRM or AMS). Since the organization we were doing this for already used netForum Pro and Abila provides a comprehensive set of web services that provide secure access to your member data, all we needed was an event management software that would support this integration.

This helped us in selecting Cvent since it provides this exact capability we were looking for. They call it Single Sing On (SSO), but it is a little more than just single sign on. In effect they allow externalizing user authentication and also allow for pre-populating user information.

cvent_sso

When a user goes to our dedicate event website and try to register, Cvent redirects them to the Organizations homepage. Here they see the familiar login page. Once we authenticate the user with their netForum credentials (username and password), we redirect the user back to Cvent and also send details about the user which includes

  •  Full name
  •  Address
  •  Phone number
  •  Email address
  • Membership Information

The interaction is a little more complicated than shown in the previous figure. The following diagram shows some of the HTTP redirection that takes place when performing the SSO –

redirect

Since Cvent recognizes the organization as a trust identity provider, it just accepts all the information regarding the user and creates one in their own system. The user now sees most of their registration information already pre-filled and can make changes if something has changed or enter their payment details.

What is cool is that we can even recognize different category of users (in our case just Active Members and Non-members). This allows us to offer different registration fees to different users.

One minor caveat – Cvent did recommend using their SAML based SSO solution. After several tries and working with their support it simply did not work. It was either not installed on their end or their were some configuration errors. Either way it still seems experimental with minimal documentation. We ended up using HTTP FORM based SSO which also uses SSL (and a slight work around for mutual authentication), so it was just as secure if non-standards based. If you are looking at SSO with Cvent, please use this method first and if time permits try the SAML based approach.

Happy Holidays from fusionSpan

Avatar photo December 20th, 2013 by

It’s 5 days until Christmas and we would like to take the opportunity to say thank you to all of our friends, fans, and future followers.

We launched the Small Staff Big Impact blog in September 2013 in the hopes that we could leverage our expertise and the expertise of others in the industry to help small staff associations do more with less. We are ecstatic with the amount of support and success of this blog and hope to continually grow. We can’t do it without you and can’t wait to see what the new year holds!

Holiday card

 

 

Ease Your AMS Worries with the Use of a Good Consultant

Avatar photo September 26th, 2013 by

Have you considered hiring a consultant to help you identify the ideal system for your association and help with the data conversion?

If your nonprofit has a small staff, little technical expertise or limited time, a consultant may be just what you need. You’ll want to make sure the consultant you choose has relevant association experience to understand your organization’s needs. For instance, just because someone has database experience, does not necessarily mean they will know how to apply your association’s membership and accounting structure within an AMS.

Assess the consultant’s knowledge by speaking with at least three clients/references to find out which system they chose and why. In this amazing new world where social media is everywhere, reviewing LinkedIn profiles can provide great insight to a consultant’s background and capabilities.

Consulting services can be beneficial for organizations that need ongoing assistance from a local expert. Not only can a consultant provide advice during the product search, but they can often assist with implementation of your new system. Having a third party who is familiar with both your association and your product can facilitate communication and save you lots of time. They can also expedite service and support.

It is possible that you’re already working with an expert who can serve in this capacity — just remember to include these fees in your budget. If you can’t afford a consultant for both the selection and implementation phases, consider hiring one for part of the process. Ask yourself: Is it more important for you to have an impartial consultant head up your product search, or would your money be better spent on hiring an expert to assist with the implementation of your new system? Each organization is different and the answer to this question will be based on your staff’s abilities and availabilities.

Check out Sarah Hill’s recent post for the MemberClicks blog:

5 Ways to Work Well with Consultants

  1. Be transparent about your need
  2. Find a good one
  3. Be super clear (even if it seems like overkill)
  4. Have short employment periods with frequent reviews
  5. Ask for feedback

Not sure if a consultant is for you? Ask us a question!