181 results found

1. Provide a working example using XML and Access 2016

   I am converting an existing (working) application based on the excel example provided by Wild Apricot to work with Access instead of Excel. All I need from the API is to download a list of members. I've found that the Excel code does not work with Access. I've found many workarounds on various VBA boards, but I'm stymied at the final step of actually downloading the XML for the membership roster.

   These three lines of code from the LoadContacts sub are the problem. The dim statement does not compile in Access. The error is that the 'user defined type is not defined'. If I change that to be DOMDoccument60 it compiles, but the following statement fails silently. The call to LoadXML does return an object, but the following call to SelectSingleNode fails silently. Nohting is returned to ContactsResultUrl. It remains an empty string.

   Dim contactsRequestDoc As DOMDocument
   Set contactsRequestDoc = LoadXml(url)
   ContactsResultUrl = contactsRequestDoc.SelectSingleNode("/ApiResponse/ResultUrl")
   

   I am converting an existing (working) application based on the excel example provided by Wild Apricot to work with Access instead of Excel. All I need from the API is to download a list of members. I've found that the Excel code does not work with Access. I've found many workarounds on various VBA boards, but I'm stymied at the final step of actually downloading the XML for the membership roster.

   These three lines of code from the LoadContacts sub are the problem. The dim statement does not compile in Access. The error is that the 'user defined type is… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  API  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. change system page colors

   How can I change the color of menu items on system pages? For example, the current color is blue; I want to change it to red.

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  How to  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. Single Sign On Very simple Ruby on Rails snippet

   Hello,
   I have been able to implement bare bones Wild Apricot single sign on steps in a blank Ruby on Rails project, thanks to Wild Apricot support! Please find attached a redacted and commented version of the code here for anyone who is trying to do similar with their own custom web app. This snippet prints out the ID of the user who is signed in.
   Cheers!

   • 

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   Team Mobile responded

   Great, thank you for contribution.

   We put copy of attached file to API samples on github:
   https://github.com/WildApricot/ApiSamples/blob/master/RubyOnRails/SSO/application_controller.rb

4. Database format of guest that attend event based on sign in list so it can be entered in PC file

   Hand write data retrieved after community event is over for guest that attended and signed in and contact info so it can be electronically processed in organizations data entry

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  How to  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. Hi, I am trying to add Google Spreadsheet to WildApricot Site...Can anyone help in this issue?

   Hi, I am trying to add Google Spreadsheet to WildApricot Site...Can anyone help in this issue?

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. How can I do a multiple language mobile friendly wildapricot website? (3 different menu bar needed)

   How can I do a multiple language mobile friendly wildapricot website? (3 different menu bar needed)

   -menu widget(all pages are shown, not workable)
   -3 content widget for 3 different lang (not mobile friendly)

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. Event registration types created via API cannot be edited in the web interface

   It is no longer possible to edit an event registration type in the web UI if it was created via an API call. Attempting to load these registration types causes Uncaught Error: Invalid cancellationBehavior to be thrown in the console and the page spins forever without loading.

   Unfortunately due to the asinine piecemeal implementation of the API it is only possible to set this field through the web interface. See the issue? Yet another reason why you should use your own dang API; you could catch these issues before they break your customers' workflow and piss them off.

   Console log attached.

   PS: You may also to check out the article linked on the second line of the log file, in case you weren't already aware of the issue with your site certificate.

   It is no longer possible to edit an event registration type in the web UI if it was created via an API call. Attempting to load these registration types causes Uncaught Error: Invalid cancellationBehavior to be thrown in the console and the page spins forever without loading.

   Unfortunately due to the asinine piecemeal implementation of the API it is only possible to set this field through the web interface. See the issue? Yet another reason why you should use your own dang API; you could catch these issues before they break your customers' workflow and piss them off.

   Console log… more

   • 

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   Work in progress  ·  Team Mobile responded

   An ability to setup cancellation options will be added to the API in the next release – approximately at the end of the month. It’ll fix this issue also.

   Currently, we fixed all broken registration types (the cancellation option was set to “not allow”) but unfortunately new ones will be created with the same problem for now.

8. Monthly list of new users

   I am attempting to create a google doc for our Printing/Mail vendor to easy grab info on the members that renwed or signed up in the last 30 days. The idea is the vendor would just open this share google doc once a month, run the report, export the data.

   I am using your example from: https://github.com/WildApricot/ApiSamples/tree/master/GoogleScript

   function getCardData(){
   Logger.clear();

   var ui = SpreadsheetApp.getUi();
   
   var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
   var urls = urlBuilder();

   var token = getToken(ui, urls.getAuthServiceUrl());
   var accountId = getDataFromApi(urls.getAccountsListUrl(), token)[0].Id;
   var filter = '\'Renewal date last changed\' ge 2017-10-01 AND \'Mebership Status\' eq Active'
   var query = getDataFromApi(urls.getCardDataUrl(accountId, filter), token)[0];
   Logger.log(query);
   var resultID = query.Resultid
   Logger.log(resultID);

   sheet.getRange('A2').setValue(contacts.FirstName);
   sheet.getRange('B2').setValue(contacts.LastName);
   sheet.getRange('C2').setValue(contacts.Address);
   sheet.getRange('D2').setValue(contacts.City);
   sheet.getRange('E2').setValue(contacts.State);
   sheet.getRange('F2').setValue(contacts.Zip);
   sheet.getRange('G2').setValue(contacts.RenewalDate);
   sheet.getRange('H2').setValue(contacts.ExpireDate);

   }

   Having a hard time getting it to work. Any help would be apprciated.

   I am attempting to create a google doc for our Printing/Mail vendor to easy grab info on the members that renwed or signed up in the last 30 days. The idea is the vendor would just open this share google doc once a month, run the report, export the data.

   I am using your example from: https://github.com/WildApricot/ApiSamples/tree/master/GoogleScript

   function getCardData(){
   Logger.clear();

   var ui = SpreadsheetApp.getUi();
   
   var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
   var urls = urlBuilder();

   var token = getToken(ui, urls.getAuthServiceUrl());
   var accountId = getDataFromApi(urls.getAccountsListUrl(), token)[0].Id;
   var filter = '\'Renewal date last changed\' ge 2017-10-01 AND \'Mebership Status\' eq Active'
   var query = getDataFromApi(urls.getCardDataUrl(accountId,… more

   4 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. Wild Apricot on Google Trends

   We recently noticed an increase in search for Wild Apricot related keywords from Google trends. Read more here:
   https://nicasiodesign.com/wild-apricot/wild-apricot-pricing-login/

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. How can I sync WA API and Azure Active Directory?

    We are looking at using WA with Office 365 to collaborate with our members. Office 365 uses the Azure AD environment which accepts most setups. My question is how we could export WA member data to Azure AD as 'B2B external partners' or, better yet, native AD accounts.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  API  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. Exit options for the email wizard

    It seems the only way to exit the email wizard after sending an email successfully is to click on the one link available to the email log. Alternatively, I wanted to get back to what I was doing, communicating with a member and updating his record.

    I suggest you look into exit options for the email wizard.

    •  

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. Event creation via API cannot set all fields

    I am creating Events using the API and cannot see how the following fields can be set (I can set these as an Administrator in the website) .....
    
    Show registrants who want to be listed
    to everyone
    to members only
    Include pending registrations

    Also I cannot see how the schedule for email announcements and reminders for an Event can be set via the API?

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    3 comments  ·  API  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    Team Mobile responded

    Status update in case someone new will see this topic:
    The section “Show registrants who want to be listed” have been added to API already.

    Schedule for email announcements and reminders can’t be set via API at the moment.

    As a workaround, you could create a template event on the web, set the start date in the distant future and all settings you need. Then you can clone it via POST request:
    api.wildapricot.org/v2/rpc{AccountId}/CloneEvent
    The request body should be like this:
    {“EventId”: 123456}

13. Google search

    Funny thing happens when you Google "Best Wild Apricot" See below...

    But for the rest of us in need of options for WA themes, and development - there is always the Partner Directory!
    http://www.wildapricot.com/partners

    •  

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. New APP Is Live

    We are glad to share that the Nicasio APP, which allows members to access/edit/pay/register/etc... has been approved by GooglePlay for our first APP Client:

    https://play.google.com/store/apps/details?id=com.nicasiodesign.cdk

    Let us know if you also want an APP for your organization.

    •  

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. Launch Checklist

    1- First thing you need to secure is access to is your domain’s DNS settings or Zone Files. If you run a query at say DNS STUFF.Com – you can find out where your DNS is hosted: dnsstuff.com

    Notice that in the Parent section our public Name Servers listed as follows:
    emily.ns.cloudflare.com. | 173.245.58.155
    buck.ns.cloudflare.com. | 173.245.59.78

    So for our website CloudFlare.Com is where we host our DNS.

    2- Next, go to the Wild Apricot custom domain setup article < Click Here >
    Once in your DNS Zone Files, you will need to edit the following files:
    A) CNAME
    Name: www
    Value: sites.wildapricot.org

    B) A record
    Name: YourDomain.com
    Value: 96.43.192.222

    C) TXT record
    Name:YourDomain.com
    Value: v=spf1 mx include:wildapricot.org ~all

    3- Finally, you will need to set custom domains in the Wild Apricot settings for both www and non-www YourDomain.Com. You’d need to decide which of the two would be your primary or default primary.

    One thing to keep in mind is your MX or Email DNS Zone Files. As you may or may not know, Wild Apricot does not host or provide mail boxes/emails for your domain. So, please keep this in mind – so that you can either keep your existing Email provider or find a new one.

    1- First thing you need to secure is access to is your domain’s DNS settings or Zone Files. If you run a query at say DNS STUFF.Com – you can find out where your DNS is hosted: dnsstuff.com

    Notice that in the Parent section our public Name Servers listed as follows:
    emily.ns.cloudflare.com. | 173.245.58.155
    buck.ns.cloudflare.com. | 173.245.59.78

    So for our website CloudFlare.Com is where we host our DNS.

    2- Next, go to the Wild Apricot custom domain setup article < Click Here >
    Once in your DNS Zone Files, you will need to edit the following files:
    A) CNAME
    Name:… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. Auction from within WA

    My club conducts an annual auction which supports both silent and live components. Has anyone created an auction plugin or software that would integrate the Wild Apricot contact database and allow an auction to be administered from within the website?

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    Frank responded

    As far as we know, no one has created this kind of plugin or integration.

17. Facebook at Work will be released soon and provides API access to manage login credentials. Is there any way to automate this process?

    Facebook at Work will be released soon and provides API access to manage login credentials. Is there any way to automate this process?

    https://developers.facebook.com/docs/facebook-at-work/provisioning/overview

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  API  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    Dmitry Smirnov responded

    Could you please elaborate what kind of automation you would like to see?

18. Sample Excel File for API Connect to WA Make Available for Excel for MAC [14851]

    It seems that the Sample Excel file for importing data from Wild Apricot was developed in Excel for WIndows. The Import Data macro does not compile because of a Missing:Microsoft XML,v3.0 reference. This XML object is only available in Excel for Windows.

    Wild Apricot states that it will not be supporting this Excel file at all. That leaves out all MAC users.

    I have not been able to find any suggestions on line on how to run this Macro or replace the XML object.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  API  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    Team Mobile responded

    The Excel file is just an example of API usage and anyone is free to take it and change in a way you want it to be.

19. Extend functionality of sample Excel file

    I will start this post off by saying that I am not a designer or coder, and that will probably be evident by my questions!

    I love the new contact record API and using the supplied Excel file I was able to pull our membership database.

    My question is this: Is it possible to set up the file to pull just members from a specific region or state and not the entire pool of members? The file for the full membership was around 6mb and took several minutes to run. I'd like to be able to narrow the query so that our officers can quickly download members in their regions. I see on the Fields tab where I can turn on and off particular fields, but I don't see how I can narrow down the search of a field. (Example: Field Name = Region, search and pull only results for Pacific Northwest).

    I now that once I run the full database I can sort by anything that I want, but I was hoping there would be a way that I could run a report for specific criteria making it quicker and a smaller file.

    Like I said, I am sure that my questions verified that I do not know what I am doing! But any help would be greatly appreciated.

    Thank you.

    I will start this post off by saying that I am not a designer or coder, and that will probably be evident by my questions!

    I love the new contact record API and using the supplied Excel file I was able to pull our membership database.

    My question is this: Is it possible to set up the file to pull just members from a specific region or state and not the entire pool of members? The file for the full membership was around 6mb and took several minutes to run. I'd like to be able to narrow the query so… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  API  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    Team Mobile responded

    The Excel file is just an example of API usage and anyone is free to take it and change in a way you want it to be.

20. VBA example of doing updates via API v2

    Does anyone have an example of doing updates via the new API version 2 in VBA? I was successfully able to make the PHP code work, but now want to do updates from an Access database.

    0 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  API  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close