How to Open XML Files in Open Office

Having difficulty installing or running EHM? Having trouble purchasing the game through Steam? Unable to get an addon or patch to work correctly? This is the place to ask for help! Please note that this is purely unofficial support offered by the TBL community.
Forum rules
Data Editing Forum: Editing the game, databases or saved games. Home of the EHM Editor and the EHM Assistant.

Game Add-ons Forum: Database projects, graphics and sounds. Any discussion which does not relate to editing databases or saved games.

Game Knowledge Discussion: Attributes, coaching, drafting, scouting, tactics and training/practice.

Rosters Forum: Discussion relating to all database and roster projects for Eastside Hockey Manager.

Technical Support: Difficulties, crashes and errors when installing or running the game (and nothing else). Any issues relating to the TBL Rosters must be posted in the TBL Rosters forum. Questions about how to install add-ons must be posted in the Game Add-ons Forum.

General EHM Chat: Anything relating to Eastside Hockey Manager 2004 / 2005 / 2007 / 1 which does not fall within any of the other forums.

Please carry out a forum search before you start a new thread.
Post Reply
User avatar
y2jericho
Prospect
Posts: 77
Joined: Mon Mar 07, 2011 7:47 pm
Custom Rank: yzerwing

How to Open XML Files in Open Office

Post by y2jericho »

I used the EHM 2007 Updater and exported the files to a separate folder. When I right click and open the file(s), in Open Office, the spreadsheets are blank. What am I not doing right? Any help appreciated.
Top
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:
Contact archibalduk

Re: How to Open XML Files in Open Office

Post by archibalduk »

Can you upload an example XML file? I will check whether the file itself is blank or if it is just an issue with opening the file in Open Office.
Top
User avatar
CJ
TBL Rosters Researcher
Posts: 3411
Joined: Tue Nov 08, 2011 6:34 pm
Custom Rank: Formerly jhcjobpb
Favourite Team: Florida Panthers
Location: Finland

Re: How to Open XML Files in Open Office

Post by CJ »

archibalduk wrote:Can you upload an example XML file? I will check whether the file itself is blank or if it is just an issue with opening the file in Open Office.
If I remember correctly it only shows empty but the file continues everything it should. I know my friend wasn't able to open the XML file in Open Office, well it opened but it's empty.
Top
User avatar
y2jericho
Prospect
Posts: 77
Joined: Mon Mar 07, 2011 7:47 pm
Custom Rank: yzerwing

Re: How to Open XML Files in Open Office

Post by y2jericho »

Not entirely sure how to upload that type of file on a forum.
Top
User avatar
y2jericho
Prospect
Posts: 77
Joined: Mon Mar 07, 2011 7:47 pm
Custom Rank: yzerwing

Re: How to Open XML Files in Open Office

Post by y2jericho »

Can you get the file like this?

http://www.filedropper.com/showdownload ... rtedstaff1
Top
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:
Contact archibalduk

Re: How to Open XML Files in Open Office

Post by archibalduk »

Got it, thanks. The file opens fine in Excel and so, as CJ says, it is clearly an OpenOffice issue. I had a quick look on Google and it appears that OpenOffice struggles with XML (LibreOffice has better support). The solution may be to save the file as CSV instead (I'm assuming you generated the XML file using the EHM Updater - which has an option for CSV).
Top
User avatar
CJ
TBL Rosters Researcher
Posts: 3411
Joined: Tue Nov 08, 2011 6:34 pm
Custom Rank: Formerly jhcjobpb
Favourite Team: Florida Panthers
Location: Finland

Re: How to Open XML Files in Open Office

Post by CJ »

archibalduk wrote:Got it, thanks. The file opens fine in Excel and so, as CJ says, it is clearly an OpenOffice issue. I had a quick look on Google and it appears that OpenOffice struggles with XML (LibreOffice has better support). The solution may be to save the file as CSV instead (I'm assuming you generated the XML file using the EHM Updater - which has an option for CSV).
If CSV doesn't work...
The other option is to have a friend with Excel and opening it and saving it to a file that Open Office recognizes (but I don't know which they are). :-)
Top
User avatar
y2jericho
Prospect
Posts: 77
Joined: Mon Mar 07, 2011 7:47 pm
Custom Rank: yzerwing

Re: How to Open XML Files in Open Office

Post by y2jericho »

archibalduk wrote:Got it, thanks. The file opens fine in Excel and so, as CJ says, it is clearly an OpenOffice issue. I had a quick look on Google and it appears that OpenOffice struggles with XML (LibreOffice has better support). The solution may be to save the file as CSV instead (I'm assuming you generated the XML file using the EHM Updater - which has an option for CSV).
Ah, ok, thank you very much for the assistance! Keep up the awesome work! :thup:
Top
User avatar
y2jericho
Prospect
Posts: 77
Joined: Mon Mar 07, 2011 7:47 pm
Custom Rank: yzerwing

Re: How to Open XML Files in Open Office

Post by y2jericho »

jhcjobpb wrote:
archibalduk wrote:Got it, thanks. The file opens fine in Excel and so, as CJ says, it is clearly an OpenOffice issue. I had a quick look on Google and it appears that OpenOffice struggles with XML (LibreOffice has better support). The solution may be to save the file as CSV instead (I'm assuming you generated the XML file using the EHM Updater - which has an option for CSV).
If CSV doesn't work...
The other option is to have a friend with Excel and opening it and saving it to a file that Open Office recognizes (but I don't know which they are). :-)
Thank you for your help, much appreciated! :thup:
Top
Post Reply

Return to “Technical Support”