starfished
Member of DD Central
Posts: 296 
Likes: 216
|
Post by starfished on Apr 23, 2020 17:39:54 GMT
It looks like RS has made a change recently (last fortnight?), so I can no longer seem to get a copy of my loan book for each market as a simple copy and paste process. Does anyone have any workarounds that they have discovered? Thanks
|
|
aju
Member of DD Central
Posts: 3,486 
Likes: 919
|
Post by aju on Apr 23, 2020 22:26:21 GMT
It looks like RS has made a change recently (last fortnight?), so I can no longer seem to get a copy of my loan book for each market as a simple copy and paste process. Does anyone have any workarounds that they have discovered? Thanks Not as yet - what I find interesting is that they may have been trying to make it simpler but in fact they have made it much more cumbersome. For me its another case of designs being changed without fully understanding what the information is supposed to convey. At present the only bit that still works for me is that whilst the transaction history looks odd - i never really used it as a screen - at least there are no changes in the returned CSV data as yet!. (Not sure if that will be long before changing though) At least I can still get an overall picture from the csv data.
|
|
starfished
Member of DD Central
Posts: 296
Likes: 216
|
Post by starfished on Apr 24, 2020 0:44:50 GMT
It is very annoying. Transaction data I don't think tells you the individual loan rate? Other firms going for a similar format usually have an option to
"see all" or download as a CSV file.
|
|
aju
Member of DD Central
Posts: 3,486
Likes: 919
|
Post by aju on Apr 24, 2020 1:06:18 GMT
It is very annoying. Transaction data I don't think tells you the individual loan rate? Other firms going for a similar format usually have an option to "see all" or download as a CSV file. yes i agree, it is a right pain now but perhaps RS does not want it to be that easy anymore. I'll leave it for a while and come back and see if the dust has settled and find a way to join it all back together as before. Not sure what planet they are on if you ask me.
|
|
|
|
Post by cinereus on Apr 24, 2020 18:22:39 GMT
It looks like RS has made a change recently (last fortnight?), so I can no longer seem to get a copy of my loan book for each market as a simple copy and paste process. Does anyone have any workarounds that they have discovered? Thanks I don't use this so what exactly is the change? I seem to be able to copy/paste members.ratesetter.com/your_lending/money_on_loan/by_product_on_loan.aspx?pid=1 with no issue.
|
|
aju
Member of DD Central
Posts: 3,486
Likes: 919
|
Post by aju on Apr 24, 2020 18:37:37 GMT
Ok so whilst I realise this won't really help many people I realised the following items about the recently changes "Money on loan" screens as follows. 1. The sort fields are not working correctly especially for the "Contract Date" field. 2. Apart from the Loan ID the rest of the columns are the same. So for me all I had to do was to change my excel loan record translator/reformer slightly by offsetting previous fields and picking up the separate LoanId for each loan as two tasks now. Apart from the initial loans I'm not overly bothered about changes to contract ID's for rolling/access etc so that was it. The column sorting is a bit of a pain and it probably does not work correctly due to the new split page/screen coding but as long as I can see the new loans and identify the closed ones by LoanID and Contract ID then it works still for me. I do have to make sure I keep on top of it monthly though. I didn't really use the loan screens for much else if I'm honest so for me it wasn't that bad a deal but if they change the CSV data fields it may make life a bit more difficult - my fingers are crossed and to be honest with the Zopa changes to columns etc I used a loader screen translator for the original layouts so I guess I could use the same for RS if they get. Overall I'm not really sure why they removed the LoanID other than they were probably having an issue with the pagination code and have the loanID was just one more thing to cope with. Of course anyone wanting to use the live screens will find it a bit of a pain though and looking at the rework coding that they probably had to do and still have to do to get the sort code to work will keep them busy for quite a while I think.  I find it interesting that RS and other make these changes and then end up with code that never works after the changes and when they sit down to rework it to make the fixes they suddenly realise they should probably have had a longer design drains up and analysis session to cover all aspects. They should be comfortable in the knowledge that they can all get jobs on the govt's new snappy apps they are trying to work into our lives though, about the same amount of design time is spent on those bits of kit too. |
|
aju
Member of DD Central
Posts: 3,486
Likes: 919
|
Post by aju on Apr 24, 2020 18:47:20 GMT
It looks like RS has made a change recently (last fortnight?), so I can no longer seem to get a copy of my loan book for each market as a simple copy and paste process. Does anyone have any workarounds that they have discovered? Thanks I don't use this so what exactly is the change? I seem to be able to copy/paste members.ratesetter.com/your_lending/money_on_loan/by_product_on_loan.aspx?pid=1 with no issue. Where are you copying them, in Excel 2007 that I use I had to reform a lot of the numbers as they are split left and right of the decimal points. I tried a number of ways and then threw them all away and copy the lines into a little piece of excel translator code as text to reform the numbers into more workable forms. Bit of a pain but it works. The only other way i could see was to use a screen scraper app but I found all the ones I tried had more issues than they were worth the time on. The other copying and paste issue that I think starfished is struggling over is that one cannot copy the loanid's in with a simple scrape of the screen as they have been moved down to the individual loan level info. The date sorting is not working correctly so that's an issue too, especially on contract date when i'm trying to see new loans.
|
|
|
|
Post by cinereus on Apr 24, 2020 23:56:07 GMT
Where are you copying them, in Excel 2007 that I use I had to reform a lot of the numbers as they are split left and right of the decimal points. I tried a number of ways and then threw them all away and copy the lines into a little piece of excel translator code as text to reform the numbers into more workable forms. Bit of a pain but it works. Just tried and you're right. But simple in a very basic Excel formula to correct. 1 min work to do once and never need to worry about again. Scraping either with python/bash or an extension should be possible looking at the DOM layout. And you could probably fix it with Greasemonkey too. All this irrelevant though as it seems it works perfectly just with Google Sheets. And it seems aju is saying there's a CSV anyway? (I admit loan ID is annoying and the incorrect sorting is dumb even if trivial to fix in Sheets.)
|
|
starfished
Member of DD Central
Posts: 296
Likes: 216
|
Post by starfished on Apr 25, 2020 13:30:23 GMT
It looks like RS has made a change recently (last fortnight?), so I can no longer seem to get a copy of my loan book for each market as a simple copy and paste process. Does anyone have any workarounds that they have discovered? Thanks I don't use this so what exactly is the change? I seem to be able to copy/paste members.ratesetter.com/your_lending/money_on_loan/by_product_on_loan.aspx?pid=1 with no issue. On that link all my loans in a market used to show but now it is spread over 10 pages... For the 1 year / 5 year market
|
|
aju
Member of DD Central
Posts: 3,486
Likes: 919
|
Post by aju on Apr 25, 2020 13:40:43 GMT
On that link all my loans in a market used to show but now it is spread over 10 pages... For the 1 year / 5 year market I have two pages on some screens but as I said above its only real use to me is to be able to transfer top level loans info to my spreadsheets. I can see having 10 sheets of this would be a real pain. In my case it would be less of an issue if the sort was good in that usually I am only interested in the initial data for new loans and the closed ones on a month basis. I feel for you starfished especially as RS is unlikely to A. fix the errors B. change it back to a more logical screen I'm guessing this is perhaps a toy domination issue (Sorry tablets/phones) but that's just the luddite in me.
|
|
aju
Member of DD Central
Posts: 3,486
Likes: 919
|
Post by aju on Apr 26, 2020 14:30:38 GMT
Ok for ISA access, i was trying to figure out any changes in my Access loans and noticed that there are now tabs for both - Existing contracts
- New contract where RS helpfully says Well not as such ... In Mrs Aju's ISA Access I checked at the moment and there are 2 supposed new contracts that are not new but have both already paid 2 months of payments. All a bit odd and just goes to show in my view that these changes have not been tested to a useful standard. Adding that issue to the sort issues both in one page and also in multiple pages too makes these new screens very confusing I feel. Also it took me quite a while just flipping back and forth to the lower level to get the LoanID and guess what on the way back it defaults from new contract screen back to existing screen. I can't believe this was well thought through in terms of a users perspective. This is probably why it has not been tested either. I wonder if RateSetter is that interested though, i'm guessing not. I wished I had kept the translation screen I created now but hey what the heck I'm self distancing so I guess I have time to waste doing it all again next time there are new loans ... |
|
starfished
Member of DD Central
Posts: 296
Likes: 216
|
Post by starfished on Apr 27, 2020 11:08:11 GMT
Well I emailed RS over the weekend and received a response back. As aju predicted, they acknowledged the email/issue but were noncommittal on whether it will revert back to the previous functionality.
|
|
