It is time to combine/merge the following site pages admin functions into a single admin window within the Website admin tab. Currently each website & system page has to be edited individually when moving the page into or out of the website menu system and when changing assigned page template. This can be time consuming when trying to move large volumes of pages in or out of the menu system or when changing templates. The Reorder pages function only allows the movement of page that are already in the menu system and doesn't account for any page not in the menu list.

Moving & combining these three functions into a single admin window would allow website developers & website admins to quickly move pages in or out of their respective website menus, assign new or updated templates and reorder pages within the existing menu.

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")

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.

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.

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.