FORUM HOME > TNM > Wish List
Ratings Export on WCW Request

triad4evrPosted on 01/01/06 at 10:18:17

I would _really_ love to see some change to how the Weight Class Wizard exports ratings. The current form is not very useful for my purposes- what I need is a way for those ratings to be exported in such a way that I can turn them into a Table in Word and then sort them by name or number of wins or whatever. Right now, the only way I can do that is by exporting the rating, then going in with a word processor program from 1985 that can mark specific rectangles of text, then I cut out the ratings number (cuz that's no help for a sort) so that the name is the first thing on the left. Then I save it, reload it in Word, then turn it into a table which, sadly, has only one column (it would be nice if it could somehow interperet TNM's output as being multiple columns), then I sort it by name, print it out, and update my wrestler records in an offline database. Then I reset the ratings in my circuit and proceed for the next year. And I do this every year. As you can see, there's a lotta steps I wish TNM could simply cut out for me. If it could either export only the information I _want_ exported (Name, win, loss, draw) and leave out the information I don't want (rating, streak) _or_ it could output the ratings sorted by any item selected, that would be extremely cool! Thanks for your time!

-Jeff
Rick GarrardPosted on 01/02/06 at 02:27:18

So basically you are looking for it to export in a "comma seperated value format" I believe it is called, where as it will export to a text file of data such as:

1.,Ric Flair,13,3,0,7
2.,Sting,3,13,0,0


etc. whereas when said list is imported into any spreadsheet and the spread is told that the file is in .csv format, it will automatically put each item following a comma into a new column.  This shouldn't be too hard to do providing Oliver has a working knowledge of how to get it do it.

And I do agree, this is a really good way to use the WCW.
triad4evrPosted on 01/02/06 at 02:33:17

No, no, I want some control as to how it would export the data. For example, if I don't _want_ the Rankings number, I want to be able to leave it off. If I want the export in alphabetical order instead of rank order, I want to be able to do that. I don't want to put it into a database neccessarily, I just want to be able to sort it in a table format in Word. I guess if the comma thing would do that, that would be fine, but I honestly don't know how to do that exactly....
Rick GarrardPosted on 01/02/06 at 03:02:35

what I was suggesting is merely just a way to save data from a table such that the WCW outputs.  And it was once frequently used for mailing list databases to conserve  precious disk space back in the days of the 5 1/4 inch floppy disk.  And it really shouldn't be too hard to get the WCW to save into this format which is easily imported into tables in word and excel from which you should then be able to sort however you want it.  At least that's been my experience with it a few years ago.
triad4evrPosted on 01/02/06 at 21:42:05

Cool! Sounds lik a plan!
IronwolfePosted on 01/15/06 at 02:15:44

It's not the complete solution you're looking for - and your suggestion would, indeed, be a nice addition - but since you have Word, you can speed up your process a bit with a macro.  I generally do three steps when I'm sorting the rankings - exporting to notepad, opening that with Word, running a macro to create the table and taking that into Excel for my sorting (this last step wouldn't be absolutely necessary, by the way; you could easily sort the table in Word once you've created it.)

What the macro does is perform several search and replace loops - basically
1) it replaces all instances of double-spacing with tabs, then
2) runs through and replaces all instances of double-tabs with single tabs; then
3) looks for instances of a parenthesis followed by a paragraph return and replaces it with a parenthesis, then
4) it selects the whole thing and converts it to a table using tab-delimiters and
5) it selects the table and auto-fits the columns.

From there you could easily select that first column and delete it, then sort on any column you want to.  The single caveat is that if you have, say, a trip-tag team that has a long name (ex: Creighton Whateley, Wilbur Whateley and Arek Britomartis in my fed) you've got to go to that team before you run the macro and delete the paragraph return following the last name of the last wrestler.  If the wrestler names are in parentheses you don't need to bother, the macro takes care of that step.  To elaborate even more on this particular thing, if those three were in a stable - ie The Minions (Creighton Whateley/Wilbur Whateley/Arek Britomartis) the macro would replace the )
p - parens followed by a paragraph - with a parens; if the Whateleys are a tag team - Dunwich (Creighton Whateley and Wilbur Whateley) and Arek Britomartis - you'd need to delete the paragraph return yourself.  That particular step just can't be automated.)

Anyway - longwinded here.  Here's the macro if you want to give it a try.  If you're unfamiliar with creating them, just go to the Tools menu and select Macros; in the popup window, type the name you want to use and click Create, it'll open the macro editor.  If you called the macro Stats, you'll see the following:

Sub stats()
'
' stats Macro
' Macro created 1/14/2006 by Customer
'

End Sub

Just paste the following before the End Sub line

   Selection.Find.ClearFormatting
   Selection.Find.Replacement.ClearFormatting
   With Selection.Find
       .Text = "
p   "
       .Replacement.Text = "
p"
       .Forward = True
       .Wrap = wdFindContinue
       .Format = False
       .MatchCase = False
       .MatchWholeWord = False
       .MatchWildcards = False
       .MatchSoundsLike = False
       .MatchAllWordForms = False
   End With
   Selection.Find.Execute Replace:=wdReplaceAll
   With Selection.Find
       .Text = "
p  "
       .Replacement.Text = "
p"
       .Forward = True
       .Wrap = wdFindContinue
       .Format = False
       .MatchCase = False
       .MatchWholeWord = False
       .MatchWildcards = False
       .MatchSoundsLike = False
       .MatchAllWordForms = False
   End With
   Selection.Find.Execute Replace:=wdReplaceAll
   With Selection.Find
       .Text = "  "
       .Replacement.Text = "
t"
       .Forward = True
       .Wrap = wdFindContinue
       .Format = False
       .MatchCase = False
       .MatchWholeWord = False
       .MatchWildcards = False
       .MatchSoundsLike = False
       .MatchAllWordForms = False
   End With
   Selection.Find.Execute Replace:=wdReplaceAll
   With Selection.Find
       .Text = "
t
t"
       .Replacement.Text = "
t"
       .Forward = True
       .Wrap = wdFindContinue
       .Format = False
       .MatchCase = False
       .MatchWholeWord = False
       .MatchWildcards = False
       .MatchSoundsLike = False
       .MatchAllWordForms = False
   End With
   Selection.Find.Execute Replace:=wdReplaceAll
   Selection.Find.Execute Replace:=wdReplaceAll
   Selection.Find.Execute Replace:=wdReplaceAll
   Selection.Find.Execute Replace:=wdReplaceAll
   Selection.Find.Execute Replace:=wdReplaceAll
   Selection.Find.Execute Replace:=wdReplaceAll
   Selection.Find.Execute Replace:=wdReplaceAll
   Selection.EndKey Unit:=wdStory, Extend:=wdExtend
   With Selection.Find
       .Text = ")
p"
       .Replacement.Text = ")"
       .Forward = True
       .Wrap = wdFindContinue
       .Format = False
       .MatchCase = False
       .MatchWholeWord = False
       .MatchWildcards = False
       .MatchSoundsLike = False
       .MatchAllWordForms = False
   End With
   Selection.Find.Execute Replace:=wdReplaceAll
   Selection.ConvertToTable Separator:=wdSeparateByTabs, NumColumns:=6, _
       NumRows:=94, AutoFitBehavior:=wdAutoFitFixed
   With Selection.Tables(1)
       .Style = "Table Grid"
       .ApplyStyleHeadingRows = True
       .ApplyStyleLastRow = True
       .ApplyStyleFirstColumn = True
       .ApplyStyleLastColumn = True
   End With
   Selection.Tables(1).AutoFitBehavior (wdAutoFitContent)
   Selection.Tables(1).AutoFitBehavior (wdAutoFitContent)
   Selection.EndKey Unit:=wdStory
   Selection.MoveLeft Unit:=wdCharacter, Count:=1
   Selection.MoveRight Unit:=wdCell
   Selection.EndKey Unit:=wdStory

As I say, not the end solution you want, but it may speed up your process a bit in the interim.  The macro takes about ten seconds to run.
triad4evrPosted on 01/24/06 at 05:28:23

Wow... that works! Only glitch I encountered (with singles ratings) was that the guys tied for a rating didn't format quite right- they were over one column but that was really easy to fix. Thanks a whole bunch- that was pretty much what I was looking for! I haven't tried it much with tag-teams, but I will heed your advice as best as I can. Thanks a lot! Macros are _way_ beyond my humble abilities.
CarlzillaPosted on 01/25/06 at 04:44:11

the Lovecraft references are awesome Ironwolfe.
IronwolfePosted on 01/30/06 at 15:15:37

You're welcome, and glad to help, triad



IronwolfePosted on 01/30/06 at 15:20:15

On 01/25/06 at 04:44:11, Carlzilla wrote:the Lovecraft references are awesome Ironwolfe.
Thanks, Carlzilla

I enjoy working with 'roll your own' characters rather than the real thing.  Though I do raid literature and film for singles and tag team names here and there.