Azərbaycan dili Bahasa Indonesia Bosanski Català Čeština Dansk Deutsch Eesti English Español Français Galego Hrvatski Italiano Latviešu Lietuvių Magyar Malti Mакедонски Nederlands Norsk Polski Português Português BR Românã Slovenčina Srpski Suomi Svenska Tiếng Việt Türkçe Ελληνικά Български Русский Українська Հայերեն ქართული ენა 中文
Subpage under development, new version coming soon!

Subject: New NTDB Database

2009-08-26 10:34:11
so you want to be able to click in an excel spreadsheet to your player in sokker?
2009-08-26 10:36:13
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.
2009-08-26 10:52:46
try that
2009-08-26 11:06:09
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
2009-08-26 11:06:41
does that mean to him to copy and paste..? orftgnmyhjukilo0p-]
or that you are going to try and script it..?
2009-08-26 11:10:21
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)
2009-08-26 11:24:44
though it was better to hyperlink the ID rather than the name tbh. Its weird how it isnt instanty activated in excel tho
2009-08-26 11:31:47
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)
2009-08-26 11:44:43
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)
2009-08-26 11:46:22
Are you still having problems with age updates from the Form Updater? Our didn't work on Friday but was fine on Saturday
2009-08-26 11:51:41
I think I dont have that form updater tool.
2009-08-26 11:53:10
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.
2009-08-26 12:25:14
lol

@jefke go to requirements tab then click on update player form
2009-08-26 12:52:00
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.
2009-08-26 16:02:34
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
2009-08-26 16:05:18
Nevermind, server error came because of using Safari (Apple's browser) in stead of FireFox


age update = ok now :)