Page 1 of 1

Html Rosters ???

Posted: Sat Mar 26, 2011 4:42 pm
by nick
Hi,
I'm not sure if is possible but I want to convert or Export my rosters in Html File .

Anyone have an answers ?

Thank you

Re: Html Rosters ???

Posted: Sat Mar 26, 2011 4:45 pm
by nick

Re: Html Rosters ???

Posted: Sat Mar 26, 2011 8:22 pm
by cv81
I'd like to know that too if possible lol

Re: Html Rosters ???

Posted: Sun Mar 27, 2011 12:16 am
by nick
I know how for the stats or the standings but i really want for rosters :P

Re: Html Rosters ???

Posted: Sun Mar 27, 2011 6:21 am
by Richie Daggers Crime
From your rosters page, you can Print>Roster to a txt file. Then, you can use a text editor to export to html. I'd imagine you'd have to add the tables and padding yourself.

Re: Html Rosters ???

Posted: Sun Mar 27, 2011 3:31 pm
by archibalduk
Once exported to a text file, you're probably best then pasting it into Excel. IIRC I think if you use Paste As Unicode or something similar then it'll paste into individual cells rather than pasting the whole table into one cell. From this, it will be easy to add the <tr>, <th> and <td> tags you'll need in order to get it into html.

Are you going to be exporting a lot of rosters? If so, if you want to format each table so that they look a particular way then you're best using CSS. To do this, create a blank file called 'ehm.css'. Then in your HTML rosters file, add this line to the top:

Code: Select all

<link href="ehm.css" rel="stylesheet" type="text/css" />
In your HTML rosters file, change the <table> tag to:

Code: Select all

<table id="rosters">
Then from your 'ehm.css' file you can create a 'rosters' ID which will control the formatting for each roster table. So you could put the following in your css file:

Code: Select all

#rosters
{
font-family:"Trebuchet MS", Arial, Helvetica, sans-serif;
width:100%;
border-collapse:collapse;
}
#rosters td, #rosters th 
{
font-size:1em;
border:1px solid #98bf21;
padding:3px 7px 2px 7px;
}
#rosters th 
{
font-size:1.1em;
text-align:left;
padding-top:5px;
padding-bottom:4px;
background-color:#A7C942;
color:#ffffff;
}
I am doing this from memory but it should work. If you do need to format things and you're struggling then let me know and I can take a closer look.

If you want to export a lot of data from EHM into spreadsheets or HTML tables then I'd highly recommend ABBYY Screenshot Reader. It allows you to export any text or tables from EHM and is only about £9 ($14 US). It works by taking a screenshot and then converting it to text using OCR. I find it very useful indeed.

Re: Html Rosters ???

Posted: Sun Mar 27, 2011 4:34 pm
by nick
Are you going to be exporting a lot of rosters? If so, if you want to format each table so that they look a particular way then you're best using CSS. To do this, create a blank file called 'ehm.css'. Then in your HTML rosters file, add this line to the top:
First Thank you for your answers...


Where I can found Html rosters files ? I have Html directory who contains stats and standing .

And Yes I need to export also 30 rosters every day .

When I export rosters from EHM , this rosters go in TXT files named EHM_EXPORT_2 il EHM directory .Well where I create EHM.CSS ?

Thank you

Re: Html Rosters ???

Posted: Sun Mar 27, 2011 5:59 pm
by francis246
those rosters are from the freeware version. BTW do you run that league ?

Re: Html Rosters ???

Posted: Sun Mar 27, 2011 6:13 pm
by archibalduk
In light of Francis246's comment, the following applies for EHM 2007. If you're looking for support for the freeware version then please make that clear because otherwise we assume you're referring to EHM 2007. Although the below applies to EHM 2007, I can probably set this up for the freeware version for you.

Setting up the correct export options
1) When you have loaded your game, click on the Options menu in the top right of the screen (this is visible on any screen in EHM).
2) Click on Preferences from the Options menu.
3) Under the Game section you will see an option that says "Print To". Change this option to "HTML File". I find that this is the best option to use because it will export it as a pre-formatted table whereas using a Text File doesn't include any such formatting/layout.
4) Click on OK to save the settings.

Exporting the rosters
1) Go to the team whose rosters you wish to export.
2) In the bottom left corner you'll see a button in the bottom left hand corner that says "Print". Click on this and then click on "Roster".
3) This will bring up an option that allows you to set a filename and to choose where to save it. When you enter a filename, you don't need to add the file extension as this is done automatically.

Formatting the table
You might be happy with the way in which the html file is formatted. If you're not then this is where you can use a CSS file to easily change the format of every html file that you have exported.

1) In the folder where you have saved your html files, create a new text document and name it ehm.css. Note that this should change the file extension from .txt to .css.
2) Open ehm.css in Notepad and paste in the following (this is just an example that you can easily tweak):

Code: Select all

#rosters
{
font-family:"Trebuchet MS", Arial, Helvetica, sans-serif;
width:100%;
border-collapse:collapse;
}

#rosters td
{
background-color:#ecf3f7;
}

#rosters td, #rosters th 
{
font-size:1em;
border:1px solid #b7b7b7;
padding:3px 7px 2px 7px;
}

#rosters th 
{
font-size:1.1em;
text-align:left;
padding-top:5px;
padding-bottom:4px;
background-color:#0a8ed0;
color:#ffffff;
}
3a) Open your html file (the file with your rosters table) in Notepad.

3b) You'll see on the third, fourth and fifth lines that it says:

Code: Select all

<style type ="text/css"> 
<!-- body,td,th { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; } td { padding: 2px; border-style: solid; border-width: 1px } --> 
</style>
Replace this text with the following:

Code: Select all

<link href="ehm.css" rel="stylesheet" type="text/css" />
So the top of the file should look like this:

Code: Select all

<HTML>
<head>
<title> Washington Capitals - Wednesday August 30th 2006</title>
<link href="ehm.css" rel="stylesheet" type="text/css" />
</head>
<body>
3c) Near the top of the file (roughly line seven) you will see the following:

Code: Select all

<TABLE BORDERCOLOR="#000000" WIDTH="90" ALIGN="CENTER">
Change this to:

Code: Select all

<TABLE id="rosters">
3d) Using the "Find and Replace" function in Notepad (just press Ctrl+H), find the following:

Code: Select all

<TR bgcolor="#EEEEEE">
and replace with:

Code: Select all

<TR>
3e) If you want to add a nicer table header then delete the following (it starts on roughly line nine):

Code: Select all

<TD>No</TD>
<TD>Name</TD>
<TD>Position(s)</TD>
<TD>Nation</TD>
<TD>Born</TD>
<TD>Age</TD>
<TD>Height</TD>
<TD>Weight</TD>
<TD>Wages</TD>
<TD>Expires</TD>
<TD>Reputation</TD>
and replace it with this:

Code: Select all

<TH>No</TH>
<TH>Name</TH>
<TH>Position(s)</TH>
<TH>Nation</TH>
<TH>Born</TH>
<TH>Age</TH>
<TH>Height</TH>
<TH>Weight</TH>
<TH>Wages</TH>
<TH>Expires</TH>
<TH>Reputation</TH>

I know this looks like a lot of text, but it's actually very easy to achieve and takes less than a minute to setup for each html file. You can then modify the css code I provided above to your taste - e.g. change the colours, add padding, spacing, margins, etc.

I have attached a sample file to demonstrate. Just extract the files into a folder and then open the html file in your web browser.

Re: Html Rosters ???

Posted: Sun Mar 27, 2011 9:26 pm
by nick
I'm not sure if I have the right version but I didn't find the preference

Image

Re: Html Rosters ???

Posted: Sun Mar 27, 2011 9:33 pm
by archibalduk
](*,)

You're referring to the freeware version of EHM and not EHM 2007...

Re: [Freeware] Html Rosters ???

Posted: Sun Mar 27, 2011 9:35 pm
by nick
FML!!! ](*,) ](*,) OHHH Sorry guys

Re: [Freeware] Html Rosters ???

Posted: Sun Mar 27, 2011 9:48 pm
by archibalduk
Try the HTML Team List Creator for the Freeware version: http://ehm.fhockey.com/resources/Team%20Lists%202a.zip

Re: [Freeware] Html Rosters ???

Posted: Sun Mar 27, 2011 9:52 pm
by nick
do you Know how to use it ??

Re: [Freeware] Html Rosters ???

Posted: Mon Mar 28, 2011 7:25 pm
by archibalduk
nick wrote:do you Know how to use it ??
No, sorry. You'll have to either figure it out yourself or try asking in the forums at fhockey.com - they're far more knowledgeable about the freeware version than we are here.

If you are interested in formatting your freeware html tables using css then let me know - I'm sure I can give similar instructions based on the freeware one no problems.

Re: [Freeware] Html Rosters ???

Posted: Mon Mar 28, 2011 10:35 pm
by nick
Thank for all archibalduck :P

Re: [Freeware] Html Rosters ???

Posted: Thu Jun 23, 2011 10:28 pm
by illidan432
Sorry to bump this but when I press CTRL + P, it says its exported, but I can't find the file.

Re: [Freeware] Html Rosters ???

Posted: Fri Jun 24, 2011 8:04 pm
by illidan432
anyone know why this is happening?

Re: [Freeware] Html Rosters ???

Posted: Mon Sep 05, 2011 1:13 pm
by Yan009
Its cool but once i have exported them in HTML, how can i put these rosters on the internet to have something like this : http://macmiller92.olympe-network.com/

Re: [Freeware] Html Rosters ???

Posted: Mon Sep 05, 2011 6:01 pm
by archibalduk
Yan009 wrote:Its cool but once i have exported them in HTML, how can i put these rosters on the internet to have something like this : http://macmiller92.olympe-network.com/
Do you have some web space? You simply upload the html files to your web server.