Recent content by Bertie

Hi I need to verify some data (First and Last Names) in a table that is built up from numerous sources and which can contain duplicates. I am building from historic data that extends to maybe 1000 records for each of the last 12 years. I am trying to assign ID's to them all to avoid this...

The mobile site seems to be just js table data. It would only have a fraction of the info. I have emailed. Although that would be easier if they actually put a contact email on the site! or maybe that was down to my eyesight last evening.

OK. What I do is this: 01 Open the FPL Website 02 Enter username/pw 03 Navigate to Transfers.mc page 04 View page source 05 Select Edit->Find "ed[" 06 Hignlight the 500-ish rows that begin "ed[" 07 Select Edit->Copy 08 Open my Excel workbook (see note below) 09 Select Edit->Paste 10 Select...

So I couldn't understand at all why the data in "ed" was only for the players in my squad. I mean it's all there in the code. So I thought OK let me try and just read the contents of the <script> tag it sits in. I came up with this where before was the HTMLDoc.Script.ed line: Dim objTag As...

I think I see what it is doing but not sure why... It looks like for some reason "ed" might only contains the data relevant to players I have selected for my team rather than for all players. I'll have to have another look at the source code to find out why. Anyway - thank you so much for...

if it helps any the field names are a little further up the page source where you have var _id = 0 to var _transfers_out_event = 44

Thats exactly it. So I'm currently cutting/pasting to excel and then importing the data to a table. I have several table of this data with fields in the same order as the array is structured. Basically what I'm looking for is: Table A - static gathered at 3:00 (or whenever) Table B - starts...

thats the thing. i need all of it. and lots of it doesn't appear in the table whichever option you choose.

the filters (leaders, score(total), price range = comboboxes) are in a form "ism_filters" and when they change the page is recalled and the table is rebuilt according to the choices made. The HTML only references the default table structure by the looks of it.

It isn't complete instead it shows according to the choices selected above. If you can see the array in the source code you will see there are 40 ish columns which have various fields that are never used in the table (eg player code = player identifier which is required) and also things like...

You got me - API? Off to google that one. Basically "yes" the data Hart - MC - 6.1 - 12 but this is only part of the data

The data is in the table where it says score (total) not the list of teams and league places. Sorry for the ambiguity. But here's where I demonstrate my lack of understanding... The table only has one variable "column" of data at a time. Also the table doesn't ever show a lot of the "columns"...

Sorry, you might be on the wrong page. The code you sent me back missed out the last navigation to "http://fantasy.premierleague.com/M/transfers.mc" which is the page I need. It is transfers from the left menu. The data I need is in the table on the right of the screen.

The data i need is about 500 rows just over half way down the source code where you find "ed[32....."

You beat me to it... I just edited the code with dummy setup I just made. You can use TestAccess as the username and Test2010 as the pw.