|
YowieFreak
|
 |
« Reply To This #50 on: September 26, 2010, 03:42:14 PM » |
|
Found the problem. Caused by the routine I included in the macros to handle converting text to numbers so that things would work for people with non-US/English/Australian number formats. (It's processing "-$7.50" by treating it as "-7" and adding "50/100", whereas it should be subtracting the "50/100" in this case.)
Will try to fix soon. And other fixes. But work is keeping me busy.
|
|
|
|
|
Logged
|
|
|
|
|
Henry
|
|
« Reply To This #51 on: September 26, 2010, 04:32:56 PM » |
|
Thanks YowieFreak - at least I know it's in the program formula and not in the way I inserted the data.  not that this will be a common error I'm sure but I also received this one while transactions were processing: Row 3 Unknown Bus ID Row 3 on my transactions is: Repayment correction for LUZ MAGALI GORDILLO SARANGO (#131255). Repayment originally occured Nov 15, 2009. But the loan is included in my info calculated |
|
|
|
« Last Edit: September 26, 2010, 04:58:33 PM by Henry »
|
Logged
|
ornitzi bilatzi monteisizi
|
|
|
|
Henry
|
|
« Reply To This #52 on: October 14, 2010, 02:13:51 PM » |
|
Really Really WEIRD thing happening today......
OK - here is what I did
opened KSC1 downloaded Loans..... cut and pasted into Spreadsheet (new page)...... logged out of KSC1..... Logged into KSC2...... downloaded loans..... cut and pasted into new page on spreadsheet......
noticed they are the same data.
hmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm
i've done this 3 times so far.... looking for my error
researching
|
|
|
|
« Last Edit: October 14, 2010, 02:14:31 PM by Henry »
|
Logged
|
ornitzi bilatzi monteisizi
|
|
|
|
Henry
|
|
« Reply To This #53 on: October 14, 2010, 02:19:36 PM » |
|
ok, my parents would have told me by now I was "Special" and they didn't .... so what's going on???
Each sheet from each of the 3 kiva accounts is titled: "User 80007 loans"
Download history below - all files are same, but i was logged into different accounts.
PETER!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
ok..... so i switched from using the "Google Chrome" over to IE and tried it - I got different files for each account......
so odd
|
|
|
« Last Edit: October 14, 2010, 02:25:15 PM by Henry »
|
Logged
|
ornitzi bilatzi monteisizi
|
|
|
|
Henry
|
|
« Reply To This #54 on: October 14, 2010, 02:52:26 PM » |
|
odd error......
photo below
line 288 of "My Transactions" is:
Luz Magali Gordillo Sarango $0.02 Jun 28, 2010 5:52pm Loan Repayment Repayment correction for LUZ MAGALI GORDILLO SARANGO (#131255). Repayment originally occured Nov 15, 2009. $344.91
my guess is it's got the "#" sign in the description instead of "id=131255"
|
ornitzi bilatzi monteisizi
|
|
|
|
YowieFreak
|
|
« Reply To This #55 on: October 14, 2010, 03:02:28 PM » |
|
a) Downloading same data - yeah, that happens to me too. I only have one account but if I download twice within a couple of days I just get the same file again. A server/computer somewhere (possibly even our own) is caching the data and trying to save time by saying it already has the info about that web-page and therefore doesn't need to chew up bandwidth by getting it again.
I usually just change the url slightly (e.g. add a "&cache_confuser=xxx" to the end of the url, where "xxx" is some random number) to force the computers to think that it is a different url.
b) (#131255) - stupid manual transactions that aren't in the standard format - grrrrr!
|
|
|
|
|
Logged
|
|
|
|
|
YowieFreak
|
|
« Reply To This #56 on: June 03, 2011, 04:56:26 AM » |
|
Changes made to the format of Kiva's transaction export file in the last couple of days have made the Summary Spreadsheet completely unusable. Don't even try.
|
|
|
|
|
Logged
|
|
|
|
|
Phoenix42
|
|
« Reply To This #57 on: June 15, 2011, 10:15:40 AM » |
|
Yowie, any plans on updating it?
|
|
|
|
|
Logged
|
|
|
|
|
YowieFreak
|
|
« Reply To This #58 on: June 16, 2011, 03:22:22 AM » |
|
Yowie, any plans on updating it?
Plans, yes. Timeframe, no. Probably a while before I will get a chance. |
|
|
|
|
Logged
|
|
|
|
|
Phoenix42
|
|
« Reply To This #59 on: June 16, 2011, 10:46:32 AM » |
|
Understandable Yowie, and thanks for providing it and maintaining it.
|
|
|
|
|
Logged
|
|
|
|
|
