Subject: »[news] XML Data Improvements

Some additions I'd like to see in the XMLs, please:

transfers: add player name and surname, so you don't have to query each single player in the list just to get the name.

team-xxx data: would be great to have the league-ID, junior-league-ID and Cup-ID in there.

juniors: now with juniors playing matches, it would be great to have no. of matches played.

reports: would be nice to have a list with the reports texts. ;)

for statistics it would be nice to have the number of fans in each arena block separately in the match-xxx XML.

this example will open a connection in VB with excel and copy the vars.xml to a sheet named XML_Import. You will need to create that sheet first and it's contents will be erased when you call this function.

btw. if someone can tell me how to make the password invisible on typing (like ****), please tell me. ;)

sub() test_connection
dim test1 as boolean

test1=log_In
end sub

Function Log_In() As Boolean

Sheets("XML_Import").Select
Cells.Select
Selection.ClearContents

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://online.sokker.org/start.php?session=xml", _
Destination:=Range("a1"))
.PostText = _
"ilogin=[""ilogin"",""Enter login""]&ipassword=[""ipassword"", ""Enter password""]"
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
'Variablen für Datum importieren
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://online.sokker.org/xml/vars.xml", _
Destination:=Range("A2"))
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = False
End With

Range("A1").Select
If Left$(ActiveCell.text, 2) = "OK" Then
Log_In = True
Else
Log_In = False
End If

End Function

How do you read the password? (console or dialog)

Thanks a lot :)

... and now we have xml files updated!

^L^

sum of changes? someone? :-)

yes that would be good eh.

player:
- height
- superdivine skill

junior:
- formation
- age
- superdivine skill

are the junior stats of any use without a proper pid number?

i you multiple current id by -1 then you will get proper ID.

you cannot get junior names from opponent team (yet)

ah so this is using juniors.xml then - i have been trying player-X.xml which is not showing the correct player

you cannot get junior names from opponent team (yet)

Are you going to include skill level of these other teams juniors?

it is not my decision, but if will be I would not agree for that.

and where is the talent? :-)))

skill level would be great to see which would allow a junior scout team to be setup to ensure the best juniors are caught in the junior school and then followed through when promoted.

and where is the talent? :-)))
omg. I completely forgot :P

btw. this changes were made by greg :) there is one thing which doesn't allow me to make any changes there :)