Ian, do you have a suggestion about what those of us with larger portfolios might be able to do to overcome the time-out problems so we, too, can participate in using the tools you've created, which sound super?
Well, firstly, the timeout problem you have with getting an export file out of Kiva won't be an issue with the spreadsheet to find common lenders. This one gets all the information it needs about your portfolio directly from data that is publicly accessible via Kiva's API, so no export files are required.
The Summary spreadsheet needs the Loan export file because it is the only place to obtain information re the lending team applicable to each of your loans, and obviously the Transaction export file as it is the only way to obtain information about your actual transactions.
There is talk that, at some stage, the API will be modified so that it can access private information (after proper user authentication obviously) and, once it is modified in that way, I will be able to modify the Summary spreadsheet to no longer need the export files too.
As far as the export file problems go, if the error message you get is the "oops" message that most of the rest of us get then I would suggest just to continue to persevere and hope that it works finally. I think
it is related to the number of other people who are trying to get an export file created at the same time, so perhaps try late at night or very early in the morning.
If you are instead getting an actual "timeout" message of some sort, that is going to be different to the rest of us, and it won't matter what time of day you try - it will be related simply to the time that it takes Kiva's servers to extract the information for your portfolio from the databases and then format it into an Excel file. The only thing I can suggest you could do in that situation is ask Kiva to include a facility to supply a simple CSV file, rather than the actual XLS file that they normally provide. (I'm not sure why they even go to the trouble of actually providing an XLS file.) A CSV file should
be faster to produce than an XLS file, so should mean less chance of it taking longer than the "timeout" period.