Subpage under development, new version coming soon!
Subject: New NTDB Database
so you want to be able to click in an excel spreadsheet to your player in sokker?
Yes. In Ireland we've already been doing it with the youths but it takes a long time and when you import updates from Excel, obviously you've either got to Hyperlink them all over again or copy and paste them all again.
Nah that leaves just as much work to do as before. I still have to add the hyperlink, the player name and all the brackets and ". Thanks for trying anyway
does that mean to him to copy and paste..? orftgnmyhjukilo0p-]
or that you are going to try and script it..?
or that you are going to try and script it..?
He's scripted the export so that the pid is incorporated into the url but it's done in a strange way where the HYPERLINK isn't shown and you can't edit in the player name to tidy it up.
Instead of
=HYPERLINK("http://online.sokker.org/player.php?PID=8859560","Danny Dealhunty")
Which just shows up as Danny Dealhunty
it's
http://online.sokker.org/player.php?PID=10041693
Which shows up as
http://online.sokker.org/player.php?PID=10041693
And you need to double click it to activate the link, then click again to use it.
(edited)
Instead of
=HYPERLINK("http://online.sokker.org/player.php?PID=8859560","Danny Dealhunty")
Which just shows up as Danny Dealhunty
it's
http://online.sokker.org/player.php?PID=10041693
Which shows up as
http://online.sokker.org/player.php?PID=10041693
And you need to double click it to activate the link, then click again to use it.
(edited)
though it was better to hyperlink the ID rather than the name tbh. Its weird how it isnt instanty activated in excel tho
Why not both?
I'd imagine it's a security thing for Excel, although I think when I copied and pasted the national teams I think it was auto linked, so I'm not sure what the problem is.
Yep I had no problem with autolinking.
(edited)
I'd imagine it's a security thing for Excel, although I think when I copied and pasted the national teams I think it was auto linked, so I'm not sure what the problem is.
Yep I had no problem with autolinking.
(edited)
rtg naar guy fink
right i have changed the script now. Can someone try it who hasnt updated already today so that it will actually run. If not i will try it again tomorrow.
is that the part of form updates, or should it all be updated?
(because ages aren't adapted yet.)
(and please, don't get mad, I'm just asking)
right i have changed the script now. Can someone try it who hasnt updated already today so that it will actually run. If not i will try it again tomorrow.
is that the part of form updates, or should it all be updated?
(because ages aren't adapted yet.)
(and please, don't get mad, I'm just asking)
Are you still having problems with age updates from the Form Updater? Our didn't work on Friday but was fine on Saturday
Strange, it's under Requirements.
Anyway, rtg, if you can't do the hyperlinking thing it's best to put it back how it was. It's a massive pain in the arse at the moment.
Anyway, rtg, if you can't do the hyperlinking thing it's best to put it back how it was. It's a massive pain in the arse at the moment.
lol
@jefke go to requirements tab then click on update player form
@jefke go to requirements tab then click on update player form
I sduppose only the U21/NT coach can click on that, so I can't update ages.
I'll ask langhe to do so.
thanks for the help.
I'll ask langhe to do so.
thanks for the help.
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@domiciano.eng.br and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
when updating the age in Belgium
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@domiciano.eng.br and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
when updating the age in Belgium
Nevermind, server error came because of using Safari (Apple's browser) in stead of FireFox
age update = ok now :)
age update = ok now :)