Welcome, Guest

VBA/API to compare CSV file and constiuent record.
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: VBA/API to compare CSV file and constiuent record.

VBA/API to compare CSV file and constiuent record. 17 Jun 2010 20:01 #6322

  • marku5788
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Hi all,
I am currently attempting to code an API that would:
1. Allow the user to browse a CSV file used for this process. For this step I have Google search endlessly and have some idea – using Browse Folder.
2. Once the user selected the CSV file, the file is used to compare certain information of constituent. Information is compared between the CSV file and Raiser’s Edge constituent records.
If someone could suggest a start for this VBA/API, it would be awesome.
Regards,
Markus.

VBA/API to compare CSV file and constiuent record. 17 Jun 2010 20:01 #35821

  • marku5788
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Hi all,
I am currently attempting to code an API that would:
1. Allow the user to browse a CSV file used for this process. For this step I have Google search endlessly and have some idea – using Browse Folder.
2. Once the user selected the CSV file, the file is used to compare certain information of constituent. Information is compared between the CSV file and Raiser’s Edge constituent records.
If someone could suggest a start for this VBA/API, it would be awesome.
Regards,
Markus.

VBA/API to compare CSV file and constiuent record. 22 Jun 2010 12:03 #35847

  • Doug Creek
  • OFFLINE
  • Platinum Boarder
  • Posts: 756
  • Karma: 0
I use SSIS (Sql Server Integration Services) and t-sql code to do this. Unfortunately (fortunately, depending on the day), I don't have the VBA /API modules, but i take either a dump from our banner database or a file that is given to me from somewhere, dump the information into temp table(s), then run a bunch of SQL comparisons against RE, churning out an import and an "update" file that we then use appropriately.

If you send me an email to This e-mail address is being protected from spambots. You need JavaScript enabled to view it , I can send you a zip file of what I have (please be aware it won't be plug and play, but this one should be pretty close as it looks at the basic information on a given record).

Doug
~~~~~~~~~~~~~~~~~~~
Doug Creek
Systems and Reports Administrator
University of Alaska Foundation
This e-mail address is being protected from spambots. You need JavaScript enabled to view it ( This e-mail address is being protected from spambots. You need JavaScript enabled to view it )

Re: VBA/API to compare CSV file and constiuent record. 26 Apr 2012 15:52 #40190

Markus
Did you build someting? Looking for banner-re solutions.

thanks,
Tara

Re: VBA/API to compare CSV file and constiuent record. 20 Jul 2012 18:43 #40721

  • JeffMon
  • OFFLINE
  • Administrator
  • Posts: 144
  • Karma: 0
This e-mail address is being protected from spambots. You need JavaScript enabled to view it wrote:

Did you build someting? Looking for banner-re solutions.


Hi Tara,

A number of universities use Import-O-Matic to process Banner data into Raiser's Edge 7 automatically. As a large portion of our clients are higher-ed, we've invested a lot of time implementing the features they need (like matching to existing Education relationships based on user-defined criteria, importing multiple family relationships [with duplicate-matching] simultaneously, etc). Just let us know if you'd like a demo or to talk to one of our clients using it for Banner data.

Jeff

PS - I'm on Kaua'i right now, your state is so incredible!

Re: VBA/API to compare CSV file and constiuent record. 24 Oct 2012 17:41 #41181

  • Eduardo X
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
SSIS can also perform a Fuzzy Lookup to do a comparison of similar information to see if the constituents are matched in similar ways. So, a James Doe vs Jim Doe could still be a match, and 1455 S. Elm St. could be a match with 1455 South Elm Street. It takes a lot of tweaking and isn't perfect, but it has helped me a lot in the past.

I've mostly used this to compare outside mailing lists to our RE database as a way to make sure we don't send solicitations to people who do not want them or who will already be receiving them.
  • Page:
  • 1
Time to create page: 0.53 seconds