|
|
Post by newlender on Feb 4, 2018 6:00:01 GMT
I have been fiddling with my ISA Loan Book CSV file and I wonder if anyone has noticed this.....the column showing %Repaid is not formatted correctly as % format. So, as an example, a loan for £20 which has repaid £10 of the capital shows that .50 has been repaid. The column heading definitely says %Repaid and so the data are mathematically incorrect. A simple formula and changing the format type to % gives a much clearer 50%. This can be adjusted to the nearest whole % too. A very minor point I know, but I wonder why Zopa's tech experts haven't made this simple change - it's so much easier to read. (I'm off to watch The Big Bang Theory now.)
|
|
aju
Member of DD Central
Posts: 3,500 
Likes: 924
|
Post by aju on Feb 4, 2018 8:58:32 GMT
I'm sure you know also that loading a csv into an excel spreadsheet as a csv will mean that a proportion of your loans borrowerID will not format correctly either. Assuming you are using excel then its a simple thing to just change the rate columns format to a %age. I seem to remember asking Zopa to fix this and other CSV issues when they changed the format of the csv's a couple of years back when we lost the old loanbook screen that had the statements data on as well. Not sure they know how to do this though. AS you say ist a simple thing in their system. The old csv's used to have everything pretty much right.
I always load into excel my csv data using text loader, having set up the data types previously I usually just set columns how I want them and use "refresh" (right click anywhere in any data area after the first load is setup) to load the relevant file.
It's a bit of a frig but it means I have more control than Zopa seems to want to provide.
As I say i'm sure you know this.
|
|
|
|
Post by newlender on Feb 4, 2018 14:39:18 GMT
The user IDs are in hexadecimal format - not sure if Excel has a function to import those. Which reminds me of something I heard ages ago when some friends were trying to make up jokes that Sheldon Cooper (The BBT geek) might make. Two professors of mathematics were talking about their children. One said 'my son is an A1 student in his faculty'. The other, fed up of his colleague's boasting, replied 'so there are 160 better than him then!'.
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Feb 4, 2018 16:31:21 GMT
Sheldon who? .... (good joke though).
As long as you treat the BorrowerID as "Text" in the import all items load correctly for me including hex. It only works though if you import rather than just open the CSV. Most of the fields can be "General" and they convert ok. The ones that you know are Text though are better marked as text. That's what I have found in Excel 2007 not sure if its better in later versions.
|
|
|
|
Post by newlender on Feb 4, 2018 19:15:18 GMT
He's the brilliant physicist in The Big Bang Theory. He is totally dysfunctional and annoying, but has a wonderful line in most episodes. He Skypes Stephen Hawking and they exchange merry quips! You really must watch it! He told a joke in a recent episode about Schrodinger's cat and quantum mechanics - Einstein was invited by Schrodinger into the box to have a look around. He says 'OK, but if I see a window I'm out of here'. Now....what was this thread about?
|
|
|
|
Post by flx123 on Mar 5, 2018 10:06:38 GMT
Getting your 50 posts to apply for DD membership?  |
|
|
|
Post by Ton ⓉⓞⓃ on Mar 5, 2018 11:12:20 GMT
Getting your 50 posts to apply for DD membership? You've just hit 50 posts, but as many of yours are on the spam level these will be subtracted from you total. Please make useful posts, spammers get banned.
|
|
aju
Member of DD Central
Posts: 3,500
Likes: 924
|
Post by aju on Mar 6, 2018 12:20:07 GMT
Getting your 50 posts to apply for DD membership? You've just hit 50 posts, but as many of yours are on the spam level these will be subtracted from you total. Please make useful posts, spammers get banned. Nice one Ton ⓉⓞⓃ ;-)
|
|
