Pioneers Importing

Post your ideas here on new features you would like to see included in future versions of the Donor Manager.
Post Reply
Guest

Pioneers Importing

Post by Guest »

:D at the moment Pioneers is using Tnt another great program and has some great benifits, but I can not decide which one I want to use, but It would be great if I could import their gift giving into the program with the address update as well.
the format is located at
http://www.tntware.com/tntmpd/HowToCrea ... ncFile.htm


[ORGANIZATION]
Name=Sample Organization
Abbreviation=SampleOrg
WebLogo-JPEG-476x100=http://download.tntware.com/ccc/SampleWebLogo.jpg
BannerAdUrl-468x60=http://download.tntware.com/ccc/SampleAdBanner.htm
Code=Sample-Organization-USA
[DONORS]
"PEOPLE_ID","ACCT_NAME","ADDR1","ADDR2","ADDR3","ADDR4","CITY","STATE","ZIP",...
"921875429","Smith, Dave J & Julie J","630 Pine St",,,,"Hickleman","SD","18372-2637",...
"332812300","Pine Hills Christian Church","1212 Elm Cir",,,,"Orlando","FL","32828-1868",...
"220389751","Fryerson, Sue","900 S Sarmon Dr",,,,"Mitchell","SD","57302-9244", ...
[GIFTS]
"PEOPLE_ID","ACCT_NAME","DISPLAY_DATE","AMOUNT","DONATION_ID","DESIGNATION","MOTIVATION"
"921875429","Smith, Dave J & Julie J","08/23/2002","60","J5INQ","0455770","Z01000"
"332812300","Pine Hills Christian Church","08/22/2002","50","J5E2S","0455770","Z01000"
"220389751","Fryerson, Sue","08/22/2002","40","J5EGE","0455770","Z01000"

[ORGANIZATION]
jmuehleisen
Site Admin
Posts: 737
Joined: Sat May 29, 2004 1:28 pm
Type the middle number, please (202): 202
Location: Kampala, Uganda
Contact:

re: Pioneers Importing

Post by jmuehleisen »

TNT is indeed a very nice program. There are a lot of places where TNTMPD and the Donor Manager overlap, and some other places where they take different approaches.

Which one is right for you (or even one of the other similar programs (see http://www.donormanager.com/links.htm#other) depends on how you do things and your particular approach.

It would be a snap for me to write an importer for TNT type contribution files, and I'll put that on my "do list" for the next update. If you could send me an email to john@donormanager.com, I'll let you know when there is something for you to test for me.

Now, if I recall, TNTMPD pulls these directly from an organizations web site if they have set up their server to serve these requests. Is that what Pioneers does, or do they e-mail you these contribution files, or what?
John Muehleisen
Mentoring Emerging Christian Leadership in Africa for Excellence / Integrity / Innovation
4HisGlory
Posts: 1
Joined: Fri Oct 22, 2004 6:16 am
Type the middle number, please (202): 302

Somewhat on the same subject

Post by 4HisGlory »

:D I just wondered how difficult it would be to write a routine that would import and export to and from TNT as they are both M$ software based. Still think it would be great to port it to filemaker.
jmuehleisen
Site Admin
Posts: 737
Joined: Sat May 29, 2004 1:28 pm
Type the middle number, please (202): 202
Location: Kampala, Uganda
Contact:

TNT Importer

Post by jmuehleisen »

Actually, I've started working on a TNT format importer but just haven't gotten around to finishing it.

TNT format is actually a simple text file with three sections. Since a number of organizations supply their contributions in that format, it would make sense to add that to the DM as a common import format, and it wouldn't require any additional work for folks.
John Muehleisen
Mentoring Emerging Christian Leadership in Africa for Excellence / Integrity / Innovation
Post Reply