Anderson Utilities - AUHistory - Page 2

Comedian2004 · 08-29-2006, 07:51 PM

Rasnell,

Try going into OOTP setup, they have a new option there to set what the seperator is, a comma or semi-colon. Change it to a semi-colon and do a new dump.

I lost the source code for this program, so I will have to re-write it.

rasnell · 08-29-2006, 08:29 PM

Can you be a little more specific on where to find the csv semicolon option? Going to database/tools, I do not see that option for the CSV export.

I can't find anything in setup. Little more info, please.

EDIT: I found it; it's OOTP Preferences in main menu. I'll test.

rasnell · 08-29-2006, 08:36 PM

Yep. Works with the semi-colons.

sporr · 08-30-2006, 10:55 PM

Quote:

Originally Posted by Comedian2004

I am up for the challenge.

I do not have any 6.x leagues, so I need someone to supply me with the data.

I will need someone to zip up their 6.x league and send it to me. I will then import it and see what I can do.

I would rather have a smaller league in years (maybe 5-10 years in length,

Let me know if you have the test data.

Some additional info just in case: Player Histories

Solonor · 09-01-2006, 01:26 PM

Quote:

Originally Posted by sporr

Great utility. Now a question that I'm reposting from another forum:

First off, I'm not a programmer so it's very possible I'm overlooking something here.

Wouldn't it be possible to write a utility that converts the old player history over to the new format so that it could be brought over to the new game?

Line from old player text file:

Injured on 8/21/2014 with a Stiff Knee, out for one week...

Line from new player text file (same news):

20140821 Injured (Stiff Knee), out one week.

It would seem simple enough for a program to rearrange the order of the text lines from the old player history text file to get them into the new format. Then it would be a process of matching a player ID from the old engine with a player ID from the new (maybe using the player's name in the csv dump?).

Is it really that much more complicated than that?

I work in software, and a programmer and I looked at this today, and it seems wicked simple. Just dump the 6.5 players to CSV (players_general.csv) and do a 2006 CSV dump. Scan through both to find the old player number to tie to the new player number. Then, reformat the text from the old p1234.txt file and save it into the new player_1234_history.txt file.

The problem is that no matter how many times we have tried to do this manually, it never works!! What are we doing wrong?

At first, I thought it was the "tab" thing mentioned, but I tried that, and it didn't help.

sporr · 09-01-2006, 05:15 PM

Quote:

Originally Posted by Solonor

I work in software, and a programmer and I looked at this today, and it seems wicked simple. Just dump the 6.5 players to CSV (players_general.csv) and do a 2006 CSV dump. Scan through both to find the old player number to tie to the new player number. Then, reformat the text from the old p1234.txt file and save it into the new player_1234_history.txt file.

The problem is that no matter how many times we have tried to do this manually, it never works!! What are we doing wrong?

At first, I thought it was the "tab" thing mentioned, but I tried that, and it didn't help.

I gave some info to Larry to look at, so maybe he can solve this. I'm not sure what could be causing this not to work manually. I really think that there will be some solution so that leagues can bring in player history...at least for active players.

Comedian2004 · 09-01-2006, 06:14 PM

You were going to send me an updated 6.5 league, one that is a the start of a season so I can import it in. You have not sent it yet.

Solonor · 09-01-2006, 08:18 PM

Eureka!!!

I figured out what I was doing wrong! I can edit the history txt files. Stay tuned for a conversion program. I know what I'm doing with my long weekend, now...

sporr · 09-02-2006, 09:59 AM

Quote:

Originally Posted by Comedian2004

You were going to send me an updated 6.5 league, one that is a the start of a season so I can import it in. You have not sent it yet.

I had replied with the new link, but it must not have gone through. I'll resend it

Solonor · 09-02-2006, 09:47 PM

Here's my stupid little utility...it ain't pretty, but it works!!

1. BACKUP THE DATA FILES!!!!!
2. Export 6.5 player data to CSV
3. Export 2006 player data to CSV
4. Unzip HISTCONV.zip to some folder on your PC
5. Run HISTCONV.EXE either through Windows or from the command line, answering the prompts for where 6.5 and 2006 are installed and what the league names are.

That's it.

It's not fancy, and it doesn't do retired players, but considering we've been told it wasn't possible, I think it was worth a day.

Solonor · 09-03-2006, 12:50 AM

Bah. I just found where it's got memory problems. It will run out of virtual memory before it finishes, most likely. I'll work on fixing it tomorrow.

08-29-2006, 07:51 PM	#21 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,396	Rasnell, Try going into OOTP setup, they have a new option there to set what the seperator is, a comma or semi-colon. Change it to a semi-colon and do a new dump. I lost the source code for this program, so I will have to re-write it. __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

08-29-2006, 08:29 PM	#22 (permalink)
rasnell Hall Of Famer Join Date: Jan 2003 Posts: 2,664	Can you be a little more specific on where to find the csv semicolon option? Going to database/tools, I do not see that option for the CSV export. I can't find anything in setup. Little more info, please. EDIT: I found it; it's OOTP Preferences in main menu. I'll test. Last edited by rasnell : 08-29-2006 at 08:30 PM.

09-01-2006, 06:14 PM	#27 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,396	You were going to send me an updated 6.5 league, one that is a the start of a season so I can import it in. You have not sent it yet. __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

09-01-2006, 08:18 PM	#28 (permalink)
Solonor Hall Of Famer Join Date: Mar 2003 Location: Orlando Posts: 2,990	Eureka!!! I figured out what I was doing wrong! I can edit the history txt files. Stay tuned for a conversion program. I know what I'm doing with my long weekend, now... __________________ SGCBL Commissioner "Beings will come, Frodo. The one constant through all the years has been baseball. Middle Earth has rolled by like an army of Mumakil. It has been erased like a slate, rebuilt and erased again. But baseball has marked the time. This field, this game: it's a part of our past, Frodo. It reminds of us of all that once was good and it could be again. Oh... beings will come Frodo. Beings will most definitely come." - Gladden Field of Dreams

09-03-2006, 12:50 AM	#31 (permalink)
Solonor Hall Of Famer Join Date: Mar 2003 Location: Orlando Posts: 2,990	Bah. I just found where it's got memory problems. It will run out of virtual memory before it finishes, most likely. I'll work on fixing it tomorrow. __________________ SGCBL Commissioner "Beings will come, Frodo. The one constant through all the years has been baseball. Middle Earth has rolled by like an army of Mumakil. It has been erased like a slate, rebuilt and erased again. But baseball has marked the time. This field, this game: it's a part of our past, Frodo. It reminds of us of all that once was good and it could be again. Oh... beings will come Frodo. Beings will most definitely come." - Gladden Field of Dreams

08-29-2006, 08:36 PM	#23 (permalink)
rasnell Hall Of Famer Join Date: Jan 2003 Posts: 2,664	Yep. Works with the semi-colons.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode