Has anyone had a chance to report the bug with the new way WBT has been formatting their monthly reports?
Starting October 6, 2007, WBT is including a note (simply a CC) in their members monthly reports to indicate if a donation was made by a credit card. Unfortunately, this addition of just a couple letters has messed up the formatting for the entire entry in question and DM can not read it the right way.
Last month I had to manually input about 20 gifts because of this, and I was wondering if a solution has been met?
WBT HTML Reports
-
- Posts: 13
- Joined: Wed Jan 10, 2007 4:24 am
- Type the middle number, please (202): 302
- Location: Addis Ababa, Ethiopia
-
- Posts: 24
- Joined: Sat Mar 17, 2007 3:53 am
- Type the middle number, please (202): 302
- Location: Tanzania
that and Wycliffe Australia....
I've had this problem too. I thought it was a bug in my October file, but it's the same thing for my November file. On the plus side, it's nice to see this month's donations as $34,951,342.00.
Also, the Wycliffe Australia import doesn't work. I get a 5 page .pdf from WBTA but it has never imported correctly.
Also, the Wycliffe Australia import doesn't work. I get a 5 page .pdf from WBTA but it has never imported correctly.
-
- Posts: 24
- Joined: Sat Mar 17, 2007 3:53 am
- Type the middle number, please (202): 302
- Location: Tanzania
Quick Fix
I figured out a temporary fix for WBT US.
1. Open the file in WordPad.
2. Find all the entries of 'CC' and simply delete them (you can search for CC and do it that way, just don't delete the 'cc' in the word 'account'.)
3. Go 'Save as' and save the file under a new name (in case something happens), keeping the html extension.
4. Import into DM.
Everything worked fine for me, except one entry the name was 'One-Time Gift' instead of the donor's name, but that was easy to adjust. All the numbers and names added up and lined up correctly.
I also had to relink some of my donors, but that didn't take long (compared to entering 20 items manually).
1. Open the file in WordPad.
2. Find all the entries of 'CC' and simply delete them (you can search for CC and do it that way, just don't delete the 'cc' in the word 'account'.)
3. Go 'Save as' and save the file under a new name (in case something happens), keeping the html extension.
4. Import into DM.
Everything worked fine for me, except one entry the name was 'One-Time Gift' instead of the donor's name, but that was easy to adjust. All the numbers and names added up and lined up correctly.
I also had to relink some of my donors, but that didn't take long (compared to entering 20 items manually).
- djklord
- Posts: 26
- Joined: Mon Jul 17, 2006 10:15 pm
- Type the middle number, please (202): 302
- Location: West Chicago Illinois
same problem - thanks for the fix
I've seen the same problem, but only yesterday figured out it was the "CC" that was causing the misread by DM.
Thanks for the work-around (editing out the CC).
I wonder if Wycliffe has any other notations which might be used in that field. I see the column has a title of "Pay Method."
Thanks for the work-around (editing out the CC).
I wonder if Wycliffe has any other notations which might be used in that field. I see the column has a title of "Pay Method."
Dan Lord
Wycliffe Bible Translators
Wycliffe Bible Translators
-
- Posts: 46
- Joined: Tue Apr 17, 2007 2:05 pm
- Type the middle number, please (202): 302
- Location: North Carolina
- Contact:
This is a wonderful example case for the use of XML. If Wycliffe published an XML Schema, JM could know exactly how to handle the files. In fact, Foxpro might be able to import XML already. Of course, the XML would have to be well-formed, but there are tools out there to ensure good XML.
In the meantime, Notepad might be your best friend. Alternatively, try this:
In the meantime, Notepad might be your best friend. Alternatively, try this:
- Print the HTML file for reference.
- Import what you can into DM.
- Go to Giving Review and delete the multi-million dollar gifts. (Only if they're not real, of course! )*
- Manually re-enter the correct gift amounts.
-
- Site Admin
- Posts: 737
- Joined: Sat May 29, 2004 1:28 pm
- Type the middle number, please (202): 202
- Location: Kampala, Uganda
- Contact:
Greetings all.
The "CC" problem that confuses the gift importer has been fixed in the latest update to the program which I hope to release in the next few days.
I'm adding support for a bunch of additional organizations plus trying to nail a few bugs that have been lurking for too long.
Look for version 5.40 or later. I hope to get it out in the next few days.
The "CC" problem that confuses the gift importer has been fixed in the latest update to the program which I hope to release in the next few days.
I'm adding support for a bunch of additional organizations plus trying to nail a few bugs that have been lurking for too long.
Look for version 5.40 or later. I hope to get it out in the next few days.
John Muehleisen
Mentoring Emerging Christian Leadership in Africa for Excellence / Integrity / Innovation
Mentoring Emerging Christian Leadership in Africa for Excellence / Integrity / Innovation