Notices


Reply
 
LinkBack Thread Tools Display Modes

Old 09-28-2007, 03:20 PM   #1 (permalink)
Junior Member

Join Date: Sep 2007
Location: Fairfax, VA
Posts: 17
Rep Power: 0 ttavenner is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

VBA/API and PHP

I've been working on some web apps which "integrate" with RE for the past few months. Primarily they extend the relationship abilities of RE so that we can do a more highly refined relationship mapping. The apps are written in PHP and run on our intranet, completely independent of RE. Since I had no experience with VBA to begin with I just wrote the apps to interact directly with the SQL server instance (read only) but now that the apps are getting more complex I would like a tighter integration with RE. So I have been looking into the API and the VBA interface.

Long-story short, is there anyone out there with experience doing PHP integration with RE. I would love to hear some advice on accessing the libraries through RE. Is this impossible without delving into VB/VBA? I don't mind learning a new language if thats what I need but would love to retain as much of the work I've done as possible.

Thanks for any advice.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 09-28-2007, 03:57 PM   #2 (permalink)
RDC:RE Guy

mwittman's Avatar

Join Date: Sep 2007
Posts: 152
Rep Power: 2 mwittman is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- NetCommunity (BBNC)

Hi, ttavenner.

I haven't dived into how RE uses VBA for scripting duties (but will when I have time), but I have lots of experience with both PHP web app development AND VBA (MS Access). Maybe it's worth some further dialog to share ideas.

Micah Wittman
Database Coordinator
Red Deer College
blackbus.m.wittman@xoxy.net
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 09-28-2007, 05:15 PM   #3 (permalink)
BUS Driver

Peter Gulka's Avatar

Join Date: May 2006
Location: Winnipeg, MB, Canada
Posts: 1,638
Rep Power: 4 Peter Gulka is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)
- API/VBA

RE: VBA/API and PHP

Would either of you be interested in looking at this along with the concept of starting an opensource RE plugin project as part of Blackbus?

Quote:
On 9/28/07, mwittman wrote: Hi, ttavenner.

I haven't dived into how RE uses VBA for scripting duties (but will when I have time), but I have lots of experience with both PHP web app development AND VBA (MS Access). Maybe it's worth some further dialog to share ideas.

Micah Wittman
Database Coordinator
Red Deer College
blackbus.m.wittman@xoxy.net




__________________
Peter Gulka
Chief Bus Driver
Blackbaud User Society
www.blackbus.org

Follow me on Twitter

View Peter Gulka's profile on LinkedIn
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 09-28-2007, 05:22 PM   #4 (permalink)
Junior Member

Join Date: Sep 2007
Location: Fairfax, VA
Posts: 17
Rep Power: 0 ttavenner is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

I'm a big fan of Open Source development and I'd be glad to contribute what I can. I'd certainly be a great way to get my hands dirty on the API/Plugin side of things.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 09-28-2007, 05:50 PM   #5 (permalink)
RDC:RE Guy

mwittman's Avatar

Join Date: Sep 2007
Posts: 152
Rep Power: 2 mwittman is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- NetCommunity (BBNC)

Sounds interesting, let's dialog further.
__________________
Micah Wittman

WORK

Database Coordinator
Red Deer College
blackbus4.m.wittman@xoxy.net

PERSONAL

http://bebepool.com
http://hmatters.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-05-2007, 09:04 AM   #6 (permalink)
Grumpy Guy

Join Date: Jul 2007
Location: The U-S of A
Posts: 29
Rep Power: 0 AntiFanBoy is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- NetCommunity (BBNC)
- API/VBA

I want to be in on this one.

Please let me know if you're looking for some collaboration. We're in the early stages, researching this move ourselves.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-05-2007, 09:25 AM   #7 (permalink)
BUS Driver

Peter Gulka's Avatar

Join Date: May 2006
Location: Winnipeg, MB, Canada
Posts: 1,638
Rep Power: 4 Peter Gulka is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)
- API/VBA

RE: VBA/API and PHP

We need to find some kind of tool like SourceForge that we can host here to allow us to collaborate on projects. My preference would lean towards tools built for Joomla (eg. Project Fork) or vBulletin (eg. vBulletin Project Tools) because of the site integration.

Any thoughts are appreciated
__________________
Peter Gulka
Chief Bus Driver
Blackbaud User Society
www.blackbus.org

Follow me on Twitter

View Peter Gulka's profile on LinkedIn
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-05-2007, 09:43 AM   #8 (permalink)
Junior Member

Join Date: Sep 2007
Location: Fairfax, VA
Posts: 17
Rep Power: 0 ttavenner is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

Quote:
Originally Posted by Peter Gulka View Post
We need to find some kind of tool like SourceForge that we can host here to allow us to collaborate on projects. My preference would lean towards tools built for Joomla (eg. Project Fork) or vBulletin (eg. vBulletin Project Tools) because of the site integration.

Any thoughts are appreciated
Ironically, there is a dearth of Joomla extensions built for programming. We may be out of luck for Joomla integration considering that Joomla's own Forge runs on a commercial collaboration software. I'm not as familiar with vBulletin but a quick Google search doesn't turn up anything immediate neither does a quick search of the vBulletin forums.

Perhaps this is the first project, though it falls far outside of the RE spectrum.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-05-2007, 10:45 AM   #9 (permalink)
BUS Driver

Peter Gulka's Avatar

Join Date: May 2006
Location: Winnipeg, MB, Canada
Posts: 1,638
Rep Power: 4 Peter Gulka is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)
- API/VBA

RE: VBA/API and PHP

Have a peek at FlySpray... I installed it at www.blackbus.org/flyspray. You can login with your Blackbus account and browse around. It integrates with Joomla, and appears to fit our basic needs.

Thoughts
__________________
Peter Gulka
Chief Bus Driver
Blackbaud User Society
www.blackbus.org

Follow me on Twitter

View Peter Gulka's profile on LinkedIn
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-05-2007, 11:00 AM   #10 (permalink)
Junior Member

Join Date: Sep 2007
Location: Fairfax, VA
Posts: 17
Rep Power: 0 ttavenner is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

Quote:
Originally Posted by Peter Gulka View Post
Have a peek at FlySpray... I installed it at www.blackbus.org/flyspray. You can login with your Blackbus account and browse around. It integrates with Joomla, and appears to fit our basic needs.

Thoughts
It looks like it has potential. I was also playing around with the demo at the FlySpray website. The one thing I couldn't tell from either installation was if this program manages files as well or if it is primarily a task manager. Either way it looks good, we can always use one of Joomla's systems (like Docman) to manage changes. There also appear to be several extensions that just do version control.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-05-2007, 11:48 AM   #11 (permalink)
BUS Driver

Peter Gulka's Avatar

Join Date: May 2006
Location: Winnipeg, MB, Canada
Posts: 1,638
Rep Power: 4 Peter Gulka is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)
- API/VBA

RE: VBA/API and PHP

Another option is to go outside the site with an implementation of GForge, the open source version of what joomlacode.org uses. I can host that, but the installation is way over my head.
__________________
Peter Gulka
Chief Bus Driver
Blackbaud User Society
www.blackbus.org

Follow me on Twitter

View Peter Gulka's profile on LinkedIn
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-05-2007, 12:09 PM   #12 (permalink)
Junior Member

Join Date: Sep 2007
Location: Fairfax, VA
Posts: 17
Rep Power: 0 ttavenner is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

Quote:
Originally Posted by Peter Gulka View Post
Another option is to go outside the site with an implementation of GForge, the open source version of what joomlacode.org uses. I can host that, but the installation is way over my head.
I would be happy to help with the installation if I can. I am downloading the express version now to see what is involved. Being that it is GPL'd and PHP based it may be possible to create a plugin for or integrate it with either Joomla! or vB.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-05-2007, 12:26 PM   #13 (permalink)
Junior Member

Join Date: Sep 2007
Location: Fairfax, VA
Posts: 17
Rep Power: 0 ttavenner is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

A quick look at GForge shows that it is not really PHP based. It uses PHP on top of (I guess) pre-compiled binary. The instalaltion does look difficult and not really "platform independent" as the website says.

Sifting through the Joomla Extensions I did find a Version Control component

Perhaps that would do the trick along with Flyspray or similar.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-05-2007, 12:36 PM   #14 (permalink)
BUS Driver

Peter Gulka's Avatar

Join Date: May 2006
Location: Winnipeg, MB, Canada
Posts: 1,638
Rep Power: 4 Peter Gulka is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)
- API/VBA

RE: VBA/API and PHP

That looks nifty...
__________________
Peter Gulka
Chief Bus Driver
Blackbaud User Society
www.blackbus.org

Follow me on Twitter

View Peter Gulka's profile on LinkedIn
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-11-2007, 11:36 PM   #15 (permalink)
o o o o o o o o o o o o o o o o o o

JeffMon's Avatar

Join Date: Aug 2006
Location: Charleston, SC
Posts: 54
Rep Power: 3 JeffMon is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Financial Edge (FE)
- API/VBA

How's about DotNetNuke?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-12-2007, 09:36 AM   #16 (permalink)
BUS Driver

Peter Gulka's Avatar

Join Date: May 2006
Location: Winnipeg, MB, Canada
Posts: 1,638
Rep Power: 4 Peter Gulka is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)
- API/VBA

RE: VBA/API and PHP

It requires a Windows hosting environment, and I use LAMP. I think there is an equivalent called PHPNuke, but I don.t know anything about it.

Quote:
On 10/11/07, JeffMon wrote: How's about DotNetNuke?



__________________
Peter Gulka
Chief Bus Driver
Blackbaud User Society
www.blackbus.org

Follow me on Twitter

View Peter Gulka's profile on LinkedIn
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-12-2007, 02:09 PM   #17 (permalink)
o o o o o o o o o o o o o o o o o o

JeffMon's Avatar

Join Date: Aug 2006
Location: Charleston, SC
Posts: 54
Rep Power: 3 JeffMon is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Financial Edge (FE)
- API/VBA

If we're talking about integrating with the RE API, there is probably going to be a windows environment involved, eh?
__________________
Jeffrey Montgomery
Managing Partner, PalmettoTech LLC
www.PalmettoTech.c