Download the Kiva toolbar! - (what's this?)

September 03, 2010, 03:20:08 AM *
Welcome, Guest. Please login or register (it's quick and free!) for full access to all community features and functions, including instant messaging and message viewing preferences.

Login with username, password and session length

Cool Forum Options
: Not available. Login or register :)
: Popular Topics on Kiva Friends

Kivapedia
: View recent changes on Kivapedia
: Online shopping that helps support Kiva
: List of Kiva microfinance institutions
: List of Kiva group lenders
: Kiva Timeline : More...


.
Welcome to Kiva Friends, an active community for Kiva users, staff and supporters. Don't know what Kiva is? Read this!
   
   Home   Search Calendar Help Tags Login Register  

Pages: 1 ... 3 4 [5]   Go Down
  Bookmark This  |  E-Mail This  |  Print It  
Author Topic: Summary spreadsheet  (Read 8244 times)
0 Members and 2 Guests were last seen viewing this topic.
cjp1973
Kiva Supporter
*****
Gender: Female
Posts: 866


View Profile
« Reply To This #40 on: April 20, 2010, 10:43:59 AM »

Is anyone else having problems running the spreadsheet that has a currency loss in their transactions?  If so, is there a way to get it to process that you could share.

Thanks
Charmaine
Logged
YowieFreak
Kiva Supporter
*****
Posts: 1275



View Profile
« Reply To This #41 on: April 20, 2010, 11:06:52 PM »

I've had a look at the problem that Charmaine is having with loans which have had Currency Losses.  The problems occur because the transaction export file contains details regarding the currency losses in rows that have no indication of which loan id those losses belong to.

The rows do contain the entrepreneur's name, so I will have to modify things so that it matches transactions to loans based on name if no id is available.

(Not sure what I'm going to do when there are multiple loans in a portfolio with the same name - e.g. returning entrepreneurs or loans with just a common first name supplied.)
Logged

Click this link to (hopefully) earn me 1 Dshini which I can then donate to Mona's fundraising efforts.

And click this link to earn Mona 1 Dshini directly.

See this KivaFriends topic for more info.
cjp1973
Kiva Supporter
*****
Gender: Female
Posts: 866


View Profile
« Reply To This #42 on: June 11, 2010, 07:06:57 AM »

Ian, is there anything new that I should know about that will now allow the summary spreadsheet to work with lines of currency loss?

thanks
Charmaine
Logged
YowieFreak
Kiva Supporter
*****
Posts: 1275



View Profile
« Reply To This #43 on: June 11, 2010, 07:43:31 AM »

Ian, is there anything new that I should know about that will now allow the summary spreadsheet to work with lines of currency loss?

thanks
Charmaine

 Embarrassed  After seeing all those effusive comments in other threads about how much Paul and I considered the lenders needs, and how responsive we were to requests for changes, fixes, etc, I was definitely feeling guilty about not yet having made the changes that were requested about a month ago.  (Or was it two months ago?  Embarrassed Embarrassed)

I will try to have a look at it over this weekend.  (It's a long weekend Smiley - Queen's Birthday holiday on Monday.  Despite a large percentage of Australians saying that they want to change to become a republic, they still want a day off to celebrate the monarch's birthday! Laugh)
Logged

Click this link to (hopefully) earn me 1 Dshini which I can then donate to Mona's fundraising efforts.

And click this link to earn Mona 1 Dshini directly.

See this KivaFriends topic for more info.
Dagfinn
Kiva Supporter
*****
Posts: 511


View Profile
« Reply To This #44 on: August 28, 2010, 04:16:29 AM »

Hi Ian - has something happened to the Kiva site as I do not get export files any longer?

Dagfinn A
Logged
Pages: 1 ... 3 4 [5]   Go Up
  Bookmark This  |  E-Mail This  |  Print It  
 
Jump to:  

 
Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC
Thanks to PixelSlot
Valid XHTML 1.0! Valid CSS!
Page created in 0.139 seconds with 24 queries.