Updating the history in Manimal v4.1 - VOLUNTEERS NEEDED!

[AaronRStanley]

I'm having trouble with Jerry D'amgio. The Atlantic junior hockey league, where he played in 2006 with the Binghampton jr Sens, the league isn't in the db, as well as the US national team development league, it's only showing the one, as opposed to separate U17 and U18 leagues, and there's no USDP league.

Also, what league is Sweden-1 listed as in the DB?

[bobmcgoo]

I've got the same error Stastny had no matter whether I click the datasheet or the manual option, so I can't do any editing at all...

[Manimal]

I'm having trouble with Jerry D'amgio. The Atlantic junior hockey league, where he played in 2006 with the Binghampton jr Sens, the league isn't in the db, as well as the US national team development league, it's only showing the one, as opposed to separate U17 and U18 leagues, and there's no USDP league.

Also, what league is Sweden-1 listed as in the DB?

There is no such thing as a USDP league. The USNTDP play in either the USHL or the NAHL
Sweden-1 is probaly Sweden First Division. Where did you see it?

[stone169]

When emailing csv files to me, please mention your username and which teams or leagues are included in the file - otherwise it takes a lot of work trying to figure it out.

Hi Stone - It looks as though you emailed me half of the Springfield Falcons (in addition to Chicago Wolves and Albany) - is that correct?

I was hoping to send you all the AHL teams at once, but life took over with my 2 year old, so I sent it to you in two seperate CSV files.

[Manimal]

To whoever is doing the WHL teams. You should use the real-life rosters, not the in-game. Just leave out anyone signed by a NHL-team.
DO NOT ADD THE INFO TO THE EDITOR
We will add your histories later when all players have been created

[Wheat_king]

Alright will do

[AaronRStanley]

I'm having trouble with Jerry D'amgio. The Atlantic junior hockey league, where he played in 2006 with the Binghampton jr Sens, the league isn't in the db, as well as the US national team development league, it's only showing the one, as opposed to separate U17 and U18 leagues, and there's no USDP league.

Also, what league is Sweden-1 listed as in the DB?

There is no such thing as a USDP league. The USNTDP play in either the USHL or the NAHL
Sweden-1 is probaly Sweden First Division. Where did you see it?

The Swe-1 came from http://www.hockeydb.com/ihdb/stats/pdis ... ?pid=80861

Also, I still haven't revolved the situation with the binghampton jr. sens and the AJHL

[AaronRStanley]

Percy Stuart isn't appearing in the database, be it for the Maple Leafs, Marlies, Reading Royals, or Mississauga St. michael's Majors.

[Manimal]

Percy Stuart isn't appearing in the database, be it for the Maple Leafs, Marlies, Reading Royals, or Mississauga St. michael's Majors.

Try finding Stuart Percy instead

The Swe-1 came from http://www.hockeydb.com/ihdb/stats/pdis ... ?pid=80861

Also, I still haven't revolved the situation with the binghampton jr. sens and the AJHL

In that case, Swe-1 is Swedish Allsvenskan.
Put D'Amigo with the Binghamton Jr. Sens but leave the league blank (i.e. _BLANK in the Editor - Archi)

[archibalduk]

To whoever is doing the WHL teams. You should use the real-life rosters, not the in-game. Just leave out anyone signed by a NHL-team.
DO NOT ADD THE INFO TO THE EDITOR
We will add your histories later when all players have been created

I will hold on to any WHL histories and will not import any into the database.

Note to anybody researching the WHL - DO NOT ADD TO THE EDITOR BECAUSE WE WILL NOT BE WORKING ON THE WHL YET. JUST PUT YOUR RESEARCH IN A SPREADSHEET.

[archibalduk]

As one or two users are having difficulty running the Editor, I thought I would share an alternative way of editing the data without using the Editor. I must point out that this method makes it easier to make mistakes - it is essential that you check the ID numbers carefully as you enter the data.

If you have already put your research into a spreadsheet then you might find the following method quicker than using the Editor. But please note my warning about being careful when entering the data. I personally use this method rather than the Editor because I find it quicker and easier.

Although it looks like there is a lot of text below, it is very simple to use the spreadsheet. As usual, I just wanted to make sure everything was explained as clearly as I could.

You will need to download History Spreadsheets - Manimal v4.1.zip from here. Extract the files somewhere on your computer.

Here is how to use the spreadsheets included with the zip file:


1) Open Player_list.xls. The column headings have small arrows next to them which allow you to filter the list. Click on the drop-down arrow next to Team Name and select the team you are researching. If you are using Excel 2007/2010 then click on the 'Select all' option from the menu to deselect all the teams and then select the team you want by putting a tick next to it. If you struggle to use the filter then you can simply scroll down the window until you find your team they're in alphabetical order.

You should research career histories for all of the players listed for the team you select.


2) Open Career_history.xls. This is the spreadsheet you should enter your stats into. Ignore the TeamID and CompetitionID columns for the time being (we will deal with these later below).

Enter each new row of career history as a new row in the spreadsheet.

It doesn't matter what you enter for the Player Name and Team Name columns. These are just for your reference and are not used in the game. You could just enter the players' surnames, for example. For the team names, you could write anything you want (as well as the league name if your really want). The purpose of these two columns is just so that we can easily see what each career history refers to.

For the Playoffs and On Loan columns you should enter a 0 or a 1. You will see that I have explained above each column title what a 0 and 1 means.

You must enter a stat for each column in the spreadsheet - even if it is just a zero. For example, for all skaters you should enter a zero for each goalie stat column. There cannot be any blanks in the spreadsheet.

For the StaffID column you should enter the player's StaffID number. You can find this number from Player_list.xls. You should enter the StaffID number that corresponds to that player. If you enter the wrong StaffID then the career stats will appear for the wrong player in game.


3) Once you have entered all of the career stats, you should just have the TeamID and CompID columns to complete. To make it as quick and easy to complete as possible, you can sort the data by Team Name (so you can group the rows together by team). To do this, click on the drop-down arrow in the Team Name column and click on 'Sort A-Z' or 'Sort Ascending' depending on what version of Excel you have.

Open Competition_list.xls and Team_list.xls. For each team listed in your career history, you need to lookup the corresponding TeamID and CompID numbers. Then enter these numbers into your spreadsheet.

For example, for the Atlanta Thrashers, you will see that their TeamID is 411 and the TeamID of the NHL is 0. So these would be the ID numbers you would need to add if you were adding a row of history for a season at the Thrashers.

Note that the Memorial Cup has its own seperate CompID (33) to the OHL (7), QMJHL (8) and WHL (6). For other playoff competitions, you simply enter the ID for the league (e.g. NHL = 0) and then enter '1' in the Playoffs column.

As with the StaffID, if you accidentally enter the wrong TeamID or CompID then the career history will display the wrong team or competition in game. Hence why it is so important to double-check that you are entering the correct number. It won't cause the game to crash however - it's just that the data will be wrong in game.

4) Once you are done, email the Career_history.xls file to me (archibalduk AT gmail DOT com). Put in your email a list of which rosters you have researched and what your TBL username is.


Finally, here is an example of how the completed spreadsheet should look like:

[Loosie]

I have got the international and league competitions updated. There are a couple of gaps in some of the lesser-known playable leagues but I think I've got the bulk of it done. I will take a good look through the game once I've got some more teams done in order to check for any gaps in the competition history.

For the NHL All-Stars, I have used NHL Western All-Stars for Team Lidstrom (Det) and East for Team Staal (Car).

Does this include World Juniors...and if so are we adding those into the player histories?

[archibalduk]

Does this include World Juniors...and if so are we adding those into the player histories?

Yes - WJC Under 20s and Under 18s have both been updated.

However, we are not adding international team player histories at the moment. This is partly because I haven't added this feature to the Editor (but will eventually) and partly because we have a big enough task with the league player histories.

[archibalduk]

when i click on the button entitled Export Career History program generates an error, something about the impossibility to use fractions in text files.
I think the problem in this

Russian computer does not recognize the specific Czech, Swedish, Finnish letters, well, or just my computer does not recognize)))
So I do not even know how to make export ...

The player/team/competition names are purely cosmetic. The name data is not exported when you click on the Export button and anyway those letters don't cause a problem.

Could you take a screenshot of the error message so I can try and figure it out? If we can't get it to work then just email the accde file to me and I can export the data instead.

We found that the cause of Statsny's error was that he missed a slash '/' at the end of the CSV Data Location box. It should have said C:/Downloads/ instead of C:/Downloads

[Smetana]

My apologies, but I'm just not able to find the free time to fulfill my obligation with this. If someone wants to take care of Pittsburgh and Wilkes-Barre, I'd appreciate it greatly. darn RL

[Stastny26]

when i click on the button entitled Export Career History program generates an error, something about the impossibility to use fractions in text files.
I think the problem in this

Russian computer does not recognize the specific Czech, Swedish, Finnish letters, well, or just my computer does not recognize)))
So I do not even know how to make export ...

The player/team/competition names are purely cosmetic. The name data is not exported when you click on the Export button and anyway those letters don't cause a problem.

Could you take a screenshot of the error message so I can try and figure it out? If we can't get it to work then just email the accde file to me and I can export the data instead.

We found that the cause of Statsny's error was that he missed a slash '/' at the end of the CSV Data Location box. It should have said C:/Downloads/ instead of C:/Downloads

Maybe, but now i can't change CSV Data Location, i don't know why...

[Reave]

I had finished four teams in the history editor and pressed export but I got same error as Stastny26. The Export folder was empty; and all stats in the history editor was removed as it was suppose to.

Start all over again

edit* Phew it wasnt gone when I restarted the editor. Should I mail you the .accde file when I have finished all twelve teams instead, archi? (I have the final "\" in the end)

Maybe, but now i can't change CSV Data Location, i don't know why...

Have you tried the tab key?

[Stastny26]

I had finished four teams in the history editor and pressed export but I got same error as Stastny26. The Export folder was empty and all stats in the history editor was removed as it was suppose to.

Start all over again

edit* Phew it wasnt gone when I restarted the editor. Should I mail you the .accde file when I have finished all twelve teams instead, archi? (I have the final "\" in the end)

Maybe, but now i can't change CSV Data Location, i don't know why...

Have you tried the tab key?

Thanks, tab key help, but error still...

Archi, please don't export my four teams, who i sent to you yesterday, i make all KHL teams (except Dinamo Riga) and sent you full ready accde file

[AaronRStanley]

Percy Stuart isn't appearing in the database, be it for the Maple Leafs, Marlies, Reading Royals, or Mississauga St. michael's Majors.

Try finding Stuart Percy instead

Good call.

The Swe-1 came from http://www.hockeydb.com/ihdb/stats/pdis ... ?pid=80861

Also, I still haven't revolved the situation with the binghampton jr. sens and the AJHL

In that case, Swe-1 is Swedish Allsvenskan.
Put D'Amigo with the Binghamton Jr. Sens but leave the league blank (i.e. _BLANK in the Editor - Archi)[/quote]

Will do.

[AaronRStanley]

My apologies, but I'm just not able to find the free time to fulfill my obligation with this. If someone wants to take care of Pittsburgh and Wilkes-Barre, I'd appreciate it greatly. darn RL

I'll take care of the Pens and....Pens. If you could send me what you have, I would appreciate it: aaron robert stanley @ gmail. com

[archibalduk]

My apologies, but I'm just not able to find the free time to fulfill my obligation with this. If someone wants to take care of Pittsburgh and Wilkes-Barre, I'd appreciate it greatly. darn RL

No worries. I will update the list. I think we all know where you're coming from.

edit* Phew it wasnt gone when I restarted the editor. Should I mail you the .accde file when I have finished all twelve teams instead, archi? (I have the final "\" in the end)

Yes, please do send the accde file to me. Would you be able to post a screenshot of the error message? It might help me figure out the error.

The Editor isn't working quite as well as I hoped for everybody - but at least we will get the data in there one way or another. A NOTE FOR EVERYBODY: MAKE A BACKUP OF YOUR .ACCDE FILE BEFORE YOU USE THE EXPORT BUTTON.

Archi, please don't export my four teams, who i sent to you yesterday, i make all KHL teams (except Dinamo Riga) and sent you full ready accde file

Ok - I will wait for you.

[AaronRStanley]

I'm back to having trouble with jussi rynnas, mostly his years in the various Finnish leagues. If someone with a good understanding of it could tell me what of the following to list, I'd appreciate it.
Jussi Rynnas 2006-2007 Assat SM-liiga
Jussi Rynnas 2006-2007 Assat U20 Jr. A SM-liiga
Jussi Rynnas 2007-2008 Assat U20 Jr. A SM-liig
Jussi Rynnas 2008-2009 Sport Finland2
Jussi Rynnas 2008-2009 FPS (Loan) Finland3
Jussi Rynnas 2008-2009 Kiekko-Vantaa Finland2
Jussi Rynnas 2009-2010 Assat SM-liiga
Jussi Rynnas 2010-2011 Toronto Marlies AHL

Also, the leagues that are GER (Marcel Muller), DEL and Ger2 (Korbinian Holzer), Aus (Kelsey Wilson) are all leagues that I can't find. Other than that, every player contracted to the Toronto Maple Leafs at any level (according to CapGeek), are completed.

HK Dukla Tren ín Jr. is a team playing in the Slovak Extraliga. It's supposed to be HK Dukla Trencín Jr. And would the extraliga be listed under Slovakian First or Second division, or Junior league?

In 2006/2007, Matt Frattin played for the Fort Saskatchewan traders of the AJHL. The team was relocated at the end of the season to St. albert and renamed the St. Albert Steel. Going with Archi's suggestion, I tried to find the Ft. Sask Traders, but they're not in the db. should I go ahead and put them under St. Albert?

[Reave]

Yes, please do send the accde file to me. Would you be able to post a screenshot of the error message? It might help me figure out the error.

It's in swedish so I had to use google translate, which we know can be a bit wierd, so I dont know if this will help you anything.

"The expression on click you entered as the event property values ​​are caused following errors:
Field delimiter in the text file specification is the same character as the decimal- or text delimiters.

* The expression does not result in a macro name, the name of a own-defined function or [Event Procedure].
* An error occurred while executing a function, event or macro.

This error can occur when an event can not be run due to the location of the event's logic can not be calculated. For example, if property OnOpen of a form is set to = [Field] occurs this error because the name of a macro or an event is expected to run when the event occurs."

[archibalduk]

Ha thanks Reave! I think with the help of Google Translator, I have a better idea of what the error means.

[Manimal]

I'm back to having trouble with jussi rynnas, mostly his years in the various Finnish leagues. If someone with a good understanding of it could tell me what of the following to list, I'd appreciate it.
Jussi Rynnas 2006-2007 Assat SM-liiga Finnish SM-League
Jussi Rynnas 2006-2007 Assat U20 Jr. A SM-liiga Finnish Junior League
Jussi Rynnas 2007-2008 Assat U20 Jr. A SM-liig Finnish Junior League
Jussi Rynnas 2008-2009 Sport Finland2 Finnish Mestis
Jussi Rynnas 2008-2009 FPS (Loan) Finland3 Finnish Suomi Division
Jussi Rynnas 2008-2009 Kiekko-Vantaa Finland2 Finnish Mestis
Jussi Rynnas 2009-2010 Assat SM-liiga Finnish SM League
Jussi Rynnas 2010-2011 Toronto Marlies AHL

Also, the leagues that are GER (Marcel Muller), DEL and Ger2 (Korbinian Holzer), Aus (Kelsey Wilson) are all leagues that I can't find. Other than that, every player contracted to the Toronto Maple Leafs at any level (according to CapGeek), are completed.

HK Dukla Tren ín Jr. is a team playing in the Slovak Extraliga. It's supposed to be HK Dukla Trencín Jr. And would the extraliga be listed under Slovakian First or Second division, or Junior league?

In 2006/2007, Matt Frattin played for the Fort Saskatchewan traders of the AJHL. The team was relocated at the end of the season to St. albert and renamed the St. Albert Steel. Going with Archi's suggestion, I tried to find the Ft. Sask Traders, but they're not in the db. should I go ahead and put them under St. Albert?

Add all on Rynnäs (I named the leagues for you)
Marcel Müller played in the Deutsche Eishockey Liga and the Deutsche Oberliga with Eisbären Berlin and Eisbären Berlin Juniors, respectively.
Korbinian Holzer played in the Deutsche 2. Bundesliga and Deutsche Eishockey Liga
HK Dukla Trenčín Jr. is spelled with that strange C, Don't know what it's called. Earlier in the thread Archi responded to a question on spelling. Look it up
Put all HK Dukla Trenčín Jr. games in the Slovakian Junior League
Yes, do use the St. Albert Steel