Thank you! Very nice database! I've got someone looking into the customization...thanks again for the quick response!

Joy, here's the link: http://www.rmothg.org/wildapricot_api%20Distro.zip

It uses the V1 API. I quit development with it when I found that the API would not allow any connection or grouping of contacts into their respective bundles. WA does still support the V1 calls, I think.

There are several hundred lines of custom VB code included. It may or may not be easy to convert the app to V2, if V2 has the power you need.

I have never investigated V2 because I am no longer the volunteer responsible for the club membership development.

Good Luck,

Dave, davegri@comcast.net

I would love to see a copy of the Access Database you're referring to. I am using Access to standardize some of the fields prior to sending out reports, and this would be extremely beneficial to see! Thanks in advance for your help!

Could you also use this to bring up a Wufoo form in an event registration form and pre-file form fields such as name and email address? How about member ID if the user is logged into WA?

I'd be interested in taking a look at your Access 2010 file, if possible. TIA!

If you are still willing to share a link to the Access database you put together utilizing the API, that would serve as a great starting point for me. My programming skills are a bit rusty but with some working code to start with, I may have a chance :-).

Thanks in advance.

Just started working with the example Excel file and I am having some issues. I notice that so fields are always blank yet I know there is data in them. It seems that everything after the email address is blank.

If I just paste the Result URL in the browser I get ALL fields with their data.

Is anyone else seeing this problem?

Thanks

-gary

I've ported the example Excel VBA code to Access 2010 so that I can download tblContacts, tblFields, and tblLevels to an Access application.

This allows me to create custom reports from Access. The WA API does not allow us financial data yet, but with the contacts data allowed, I can create reports such as a Roster, New Members, Membership Cards, and customized labels. There's also built in functionality to create some of the reports via mail merge in Word.

If anyone wants a copy of the .accdb, email me and I can give you the URL to the zip file via return mail.
I have stripped out most of the code specific to my organization. However, the application still contains a large amount of VBA code. If you are unable to work with VBA programming, you will probably have problems that you cannot overcome. You must accept the download as is, without my support. I can, at my discretion, and if time permits, answer specific questions via email if you become stuck trying to understand/modify the program code. The program does contain fairly comprehensive help on functionality.

Davegri

The best thing ever to hear for us :) Thanks a lot for the good words!

Even better ;-)

I got most of it working last night using XML and LINQ. I need to refine it but it did work fine.

Thanks a lot for making it happen.

Alan

ok, thanks, clear. we also added to the page a link to download the file, so you don't have to copy/paste the code.

On the website, it has a sample for C# using JSON. If you copy it, it is not delimited correctly and comes across as a single string. You then have to go in and correctly format the code.

Go to one of my posts that show code:

http://savian.blogspot.com/2012/04/hash-sas-value.html

You can copy that and place it into Notepad (or whatever) and it pastes formatted properly.

Your C# sample needs the following tags around it before it is placed into the HTML:

<pre style="WORD-WRAP: break-word;">

...paste code in here formatted...

</pre>

HTH,

Alan

Thanks! Though not sure about your C# comments...

Cool stuff. I have successfully cleaned up the c# code and executed the program successfully against our data.

Good job guys.

The new C# sample code is not put into the HTML correctly. It comes out as one big string and is impossible to format easily. I will have to go in and clean it up by hand.

I love this new stuff and wanted to start coding immediately but we need pre tags or something in there so we can copy the code formatted.

What am I missing?

You can use server-side web service calls to WA and expose those services out to your website.

For example, a WCF interface which the client consumes and the back-end web service makes the calls to WA. Just a thought.

I may also do some BI so I can monitor membership rates and attrition issues. Lots of possibilities.

Interesting question. I may also just roll our own website and take it from there.

We have articles due from officers once a quarter. I figure I can have a form for them to fill out their article then mash it with photobucket and create our newsletter using a template. May use Aspose.PDF to create a pdf version. Then generate the file and mail it out either using the WA service or on our own.

WA would be preferred but the initial APIs are membership APIs. I think the full power will be realized when additional APIs come online so we can automate the creation of the emails, events, etc. For now, I will be playing around and getting infrastructure into place. We will automate list creation such as BOD members so we don't have to maintain those lists outside of the db.

I am not a fan of the Excel export on WA since it dumps everything. I already have programs that cleans it all up and creates simple lists that we can hand out to our officers (many prefer hard lists). I will probably automate the data pull and avoid the export button as step #1 and wait for more APIs to be put into place.

I have the Wufoo APIs in place already and will just extend off of that.

All of my work is in C#/.NET, btw. Just an FYI on what people are using.

Very interesting. Could you elaborate on how you plan on using it with Wufoo for automated newsletter creation?

I will be using it with Wufoo for automated newsletter creation. I have been waiting a long time for this so still wrapping my head around what I can do with it.

I will also be automating the creation of our membership lists that we print out and hand to officers. That and event management.