davwms' Origin Generator - anyone ever get it to work?

[blueturf]

Originally Posted by stevebydac

3) I look in that particular league's file (World Cup) and the Originator is sitting in there along with a folder for OriginData. The players_general Excel sheet is there too. I don't touch it.

Originally Posted by stevebydac

EDIT: On that last point, I now have gone into the OriginData folder and opened up every DAT file in it. I found three that had spaces after the last entry. I removed the extra space and saved. However, this STILL doesn't work! Do I need to do anything to files outside of the OriginData folder??

Can anybody help me? Thanks!

The players_general is most likely the file that has the extra space at the end. Open that file with NOTEPAD instead of Excel. Remove any extra space at the end. Close and Save.

Try to re-run the generator and it should work. If not, I would be happy to look at your players_general file and attempt to get it to work for you.

[stevebydac]

Thanks for the help blueturf There aren't too many people who can help with stuff like this, so I am REALLY appreciative. If I could buy you a beer I would!

I did as you suggested and indeed found an empty line at the end of the players_general document. I went to the last character that was present and deleted anything after it (which was an empty line/ space), closed it, and then ran the Originator, but am still getting the same error message.

Could it be something else? Do I have to do anything to the DAT files that are in that league's folder, such as Coaches, league, messages, draft, etc.?

Does the time that you use the Originator matter? I created a league, set up the divisions, named the teams, etc. but have not yet had the initial draft. Do the players need to be on teams for this to work, or is it ok that they are just in draft/ free agent limbo for now?

EDIT: Thank you for the offer to look at my file. I'm trying to attach the file, but I am getting a message saying it is an invalid file. It is only an 89K Excel sheet. What do I need to change to get this attached?

[stevebydac]

For anyone's else reference, blueturf was kind enough to take a peek at my file. His reply:

"It appears the the export in OOTP5 is different than with OOTP6. V6 has other ratings such as Infield Arm so the fields are in a different order. V5 will not work with the Originator."

So, back to the drawing board. blueturf, thanks so much for giving it a shot!

[enuttage]

I'm getting Error 62 messages on this bad boy, but I'm a little confused about what to do to remedy the problem. How do I tell if a city name is too long?

I know I'm bumping an ancient thread, but I'm trying to properly populate an online league, and want to get it right, instead of the same old boring USA stuff.

Cheers,

-E

[SandMan]

Originally Posted by enuttage

I'm getting Error 62 messages on this bad boy, but I'm a little confused about what to do to remedy the problem. How do I tell if a city name is too long?

I know I'm bumping an ancient thread, but I'm trying to properly populate an online league, and want to get it right, instead of the same old boring USA stuff.

Cheers,

-E

City Names with the state or country behind it can not be no more than 20 characters. I limit mine to 19 because I have had troubles at times with those exactly 20.

[enuttage]

Originally Posted by SandMan

City Names with the state or country behind it can not be no more than 20 characters. I limit mine to 19 because I have had troubles at times with those exactly 20.

So do I need to go through each name individually, or is there some other way to make sure I don't end up with city names that long.

Thanks for the help, SandMan.

-E

[SandMan]

To get rid of the long names I do the following.

1. Cut the list of cities from the origin file and paste them into an Excel worksheet. Do not use the copy. Before you do this make sure you backup you origins file incase of an error.....

2. Use the text to columns and use the comma as the separator.

3. I then do the LEN(A1) and get the length of each location (city /state or city /country abbr). I then sort by the length. If any of the locations are over 19 I then edit them down to a useable size or delete them if they are not major locations.....

4. Now the tricky part. You need to put the structure of the text back into a useable format for the text file. I use the concatenate functions and if you have your city and state in A, and the rest in B it is simple. =Concatenate(a1,", ",b1).

Now using this column, cut it and paste it back into your origins file.


This sounds complicated but it is actually not so bad. I have done this to clean up the origin files and to create my own origin files many times and found it to be a good way of cleaning up the bad locations in the files......

[enuttage]

Well, about half of what you just wrote actually makes sense to me, which tells me that I'm in over my head for the time period alotted.

Thanks again, bro. I really appreciate you taking the time.

-E