TntConnect
Helping you build powerful connections for a lifetime of ministry...

CSV donation report to TntMPD Datasync conversion tool


It is our pleasure to provide this software free of charge to help you in your ministry.  We're so thankful for our partners who make this possible!

About TntWare


posted by objecttothis
12 Oct 2012

Downloads: 507
Views: 26,732
CSV donation report to TntMPD Datasync conversion tool

http://tnt.clcusa.org

This online tool is designed to help the hundreds of missionaries who receive reports of their donations from their organizations using QuickBooks or other tool which generates csv reports.  All your organization needs to do is send you the report in .csv format which can be done by checking one box when the report is created.  Workers from at least 14 different organizations are now using the tool!

If you would like your company added to the tool so that you can use this tool to automatically import your gifts to TntMPD then go to http://tnt.clcusa.org/instructions.html for more information.

Compatibility: This tool is natively compatible with CSV reports from the following programs. If you would like to have native compatibility added for other software, please contact me.

  • Quickbooks
  • Araize Fastfund
  • Blackbaud Raiser's Edge
  • Blackbaud eTapestry
  • AGWM ISSQL
  • Generic (see documentation)

I highly recommend first importing your TntMPD datasync file into a blank database to make sure it works properly before importing it with your live database.

Recent Changes:

  • Fixed long file bug. Large files (up to 512kb) are able to be imported.
  • Tested with TntMPD 3.x successfully.
  • Now works with Blackbaud Raiser's Edge CSV gift reports.
  • Now works with Araize Fastfund CSV gift reports.
  • Now works with Blackbaud eTapestry CSV gift reports.
  • Can now import all fields (address, email, phone, gifts, etc.) that TntMPD will receive.  (See documentation)
  • Now works with AGWM ISSQL file types.
  • The tool has been moved from www.clcusa.org/tnt to http://tnt.clcusa.org so please note this change.

Coming Soon:

  • Working on bug where csv files created or manipulated in Apple systems don't properly recognize line endings.

Comments

Russ.IFI wrote re: Quickbooks donation report to TnTMPD Datasync converter
on 26 Oct 2012 5:11 PM

It’s nice to see you have made something to quickly import into tntMPD.  Thanks!

It should be able to be used with ANY .csv file, if we knew all the Quickbooks report fields required & their meanings.  I tried to load a dummy .csv file with the info you gave on your website, but it came back empty.  Can you please give us the the Fields names & their descriptions of the Quickbooks donation report .csv so we can look at it & set up our reports to create them?  Or a sample to download, if it’s just striped of data & has the headers & one row of dummy data, that would work just fine.

objecttothis wrote re: Quickbooks donation report to TnTMPD Datasync converter
on 26 Oct 2012 5:29 PM

Definitely.  I'm working on a writeup that explains the formatting of the csv file, but yes, it will work with more than quickbooks.  As long as you can produce a CSV file with the same format it will work.

objecttothis wrote re: Quickbooks, Blackbaud or CSV donation report to TntMPD Datasync converter
on 29 May 2013 9:21 AM

Works great with TntMPD 3.0 beta.  Please report bugs to tnt@clcusa.org or message me.

LucyHayes wrote re: Quickbooks, Blackbaud or CSV donation report to TntMPD Datasync converter
on 12 Nov 2013 4:54 AM

Is this able to be used on the latest TnTMPD 3.0 r.21 version?

objecttothis wrote re: Quickbooks, Blackbaud or CSV donation report to TntMPD Datasync converter
on 12 Nov 2013 11:02 AM

Yes, it works with all new versions of TntMPD.  We just need to get your company information in the tool so that it fills in the correct company information

Richard Carpenter wrote re: CSV donation report to TntMPD Datasync conversion tool
on 29 Jan 2014 2:38 AM

The download link for this conversion tool isn't working.  It sends me to a "404 Error file not found" page.  Is this download still available?

objecttothis wrote re: CSV donation report to TntMPD Datasync conversion tool
on 29 Jan 2014 5:44 AM

OK, fixed it.

rafulton1944 wrote re: CSV donation report to TntMPD Datasync conversion tool
on 11 Aug 2014 5:35 PM

Does Rock of Ages Prison Ministry participate?

Rich

objecttothis wrote re: CSV donation report to TntMPD Datasync conversion tool
on 12 Aug 2014 1:53 PM

Not currently, but if they can send you a CSV report then you will be able to use the tool.  We will need to do an initial setup, so click the download link and then "Instructions" and send me an email with the information needed in "One-time Setup" and we'll get you setup.

John Sugars wrote re: CSV donation report to TntMPD Datasync conversion tool
on 28 Jan 2015 10:58 PM

Would you be able to add Xero accounting package to your native compatibility please?

objecttothis wrote re: CSV donation report to TntMPD Datasync conversion tool
on 30 Jan 2015 7:33 PM

@jwsugars I may be able to do this, but I will need the details of the csv file that it outputs.  The ideal situation is if it can generate csv reports that already carry the correct header information and data found at www.clcusa.org/.../instructions.html but if we need to come up with something custom I can work with you on that.

John Sugars wrote re: CSV donation report to TntMPD Datasync conversion tool
on 30 Jan 2015 8:54 PM

On the Converter page (after pressing download), what is the Employee ID number? Does it matter what number I put in there?

objecttothis wrote re: CSV donation report to TntMPD Datasync conversion tool
on 30 Jan 2015 9:38 PM

@jwsugars if you are submitting a csv report that contains more than one employee's donations then you need to enter the employee identifier that is used to differentiate between what donations to include in the resulting tntmpd file.

If you are just submitting a csv report that contains one employee's donations then you can put anything in that field but I recommend using the same value each time.  I usually use last name but it doesn't have to be that.

objecttothis wrote re: CSV donation report to TntMPD Datasync conversion tool
on 22 Mar 2016 8:11 AM

CSV to Tnt converter is now compatible with TntConnect and older versions of TntMPD.

crossroadsfarmcalendar wrote re: CSV donation report to TntMPD Datasync conversion tool
on 9 Feb 2017 2:05 AM

Hello.  I have tried to access the www.clcusa.org/tnt/ website and get only this error message: [an error occurred while processing this directive]

Is was working not long ago.  Is it working for anyone else?

Troy Wolbrink wrote re: CSV donation report to TntMPD Datasync conversion tool
on 27 Jul 2018 3:04 PM

It looks like this tool is no longer available.  Please contact me (troy@tntware.com) for information about how DonorHub can help you flow donation data into TntConnect.

objecttothis wrote re: CSV donation report to TntMPD Datasync conversion tool
on 27 Jul 2018 11:31 PM

Sorry, I am not sure what happened. I will look into why it's down in the morning.

objecttothis wrote re: CSV donation report to TntMPD Datasync conversion tool
on 1 Aug 2018 7:06 AM

Sorry for the down time of the tool.  I was not aware that the website was being migrated and the tool was not copied over.  The tool will now be located at http://tnt.clcusa.org and should be up shortly.

© 2018 TntWare | Privacy | Terms of Use