« previous next »
Pages: [1]

Author Topic: open office and downloadable timetable  (Read 11903 times)

Offline EHM-1838 Andrew

  • Martian transfer
  • *******
  • Posts: 516
  • Karma: 1
open office and downloadable timetable
« on: December 10, 2009, 02:44:50 pm »
Hello ALL
I have been trying to open the downloadable timetable which is an MS Excel file.I don't have MS office,but i do have open office(free office suite),but i am having know joy.When i try to open the document i am getting what appears to be  a spreadsheet page but with no sign of any flights.
Open Office is supposed to be able to handle MS office documents.
Any ideas chaps.
thanks
Andy
Logged

Offline EHM-1465 Dominic

  • Administrator
  • Intergalactic!!
  • ***
  • Posts: 3,529
  • Karma: 10
  • VA Management
Re: open office and downloadable timetable
« Reply #1 on: December 11, 2009, 02:15:43 am »
Hi Andy,

I also use Open Office and I've not had a problem with this before but when I downloaded the timetable and tried to open it just now, the same thing happened to me. I then went to File/Open and selected the location of the timetable.xls file again and then it did open but only after about 20 seconds. For some reason it seems to be sluggish at the moment but I don't know why...

Murray - any ideas if there's a problem with this program at the moment?
Logged
Dom Mahon // EHM-1465
VA Management

Offline EHM-0654 Murray

  • Administrator
  • Intergalactic!!
  • ***
  • Posts: 4,531
  • Karma: 5
  • VA Management
    • The Ponderings of PMUK
Re: open office and downloadable timetable
« Reply #2 on: December 11, 2009, 04:29:43 pm »
It won't even run on my VM here at work, so I'll see if it works on my NetBook, otherwise it'll be me installing it on our print "server" (which runs XP) to test it...

Well, the downloader works on my netbook, so that's hurdle #1 crossed. Only problem seems to be that the XLS file is only 2 bytes big. Trying run as Admin, 'cause you never know...

Update: Well, even under XP I get a 2 byte file from the downloader, so appears that it no longer works (for some reason).
« Last Edit: December 11, 2009, 04:48:21 pm by EHM-0654 Murray »
Logged
Murray Crane // EHM-0654 // Twitter
VA Management

KEEP CALM AND CARRY ON

Offline EHM-1838 Andrew

  • Martian transfer
  • *******
  • Posts: 516
  • Karma: 1
Re: open office and downloadable timetable
« Reply #3 on: December 11, 2009, 04:33:37 pm »
Quote from: EHM-1465 Dominic on December 11, 2009, 02:15:43 am
Hi Andy,

I also use Open Office and I've not had a problem with this before but when I downloaded the timetable and tried to open it just now, the same thing happened to me. I then went to File/Open and selected the location of the timetable.xls file again and then it did open but only after about 20 seconds. For some reason it seems to be sluggish at the moment but I don't know why...

Murray - any ideas if there's a problem with this program at the moment?

Hello Dominic
Well at least you can get yours to work.I tried waiting 20-30 seconds but no joy,just that spreadsheet page again and no flights.
PS
I thought i would try the timetable instead of using the Flogger to choose flights in view of the problems with the Flog closing with that error message i posted about the other day.
cheers Andy
 
Logged

Offline EHM-1465 Dominic

  • Administrator
  • Intergalactic!!
  • ***
  • Posts: 3,529
  • Karma: 10
  • VA Management
Re: open office and downloadable timetable
« Reply #4 on: December 12, 2009, 12:18:08 pm »
I must have had an old version on my PC - tryint afresh just brings up the 2 byte file that Murray found...

However, I'm posting the old version below as an attachment in case it's any use to you Andy (unfortunately it hasn't got any of the new flights or Missions) ;)

EDIT:- I tried attaching it and that didn't work so here's a link to download it:- LINK HERE
« Last Edit: December 12, 2009, 12:28:31 pm by EHM-1465 Dominic »
Logged
Dom Mahon // EHM-1465
VA Management

Offline EHM-0654 Murray

  • Administrator
  • Intergalactic!!
  • ***
  • Posts: 4,531
  • Karma: 5
  • VA Management
    • The Ponderings of PMUK
Re: open office and downloadable timetable
« Reply #5 on: December 12, 2009, 06:04:18 pm »
What's column M? GCD? I have a feeling that I'll be able to offer the timetable download functionality directly from the backend database with a little bit of scripting in PHP... Can't look into it right now, but if needs be I'll work on it over my upcoming Xmas break en France...

Update: I've gotten most of the info directly from the database, but because of some backend problems, I can't get it all yet. I'll have a play around in some of my development tools and see if I can't sort things.
« Last Edit: December 12, 2009, 11:01:19 pm by EHM-0654 Murray »
Logged
Murray Crane // EHM-0654 // Twitter
VA Management

KEEP CALM AND CARRY ON

Offline EHM-1838 Andrew

  • Martian transfer
  • *******
  • Posts: 516
  • Karma: 1
Re: open office and downloadable timetable
« Reply #6 on: December 13, 2009, 11:12:09 am »
Quote from: EHM-1465 Dominic on December 12, 2009, 12:18:08 pm
I must have had an old version on my PC - tryint afresh just brings up the 2 byte file that Murray found...

However, I'm posting the old version below as an attachment in case it's any use to you Andy (unfortunately it hasn't got any of the new flights or Missions) ;)

EDIT:- I tried attaching it and that didn't work so here's a link to download it:- LINK HERE


Hello Dominic
I tried your link but still no joy i am afraid. If i try to open your older version of the timetable Open Office simply locks up and its CTRL ALT DEL to the rescue.
cheers Andy
Logged

Offline EHM-0654 Murray

  • Administrator
  • Intergalactic!!
  • ***
  • Posts: 4,531
  • Karma: 5
  • VA Management
    • The Ponderings of PMUK
Re: open office and downloadable timetable
« Reply #7 on: December 14, 2009, 03:41:26 pm »
K. Not to leave you in the lurch Andrew, I've made a script that exports the timetable as CSV (commas as separator, ISO-8859-1 character set)

[ http://www.fly-euroharmony.com/site/timetableDownload.php?div=1 ]

Until I expand it with a front-end page that asks what division you want later tonight, "div" is the division; use the table below if you want something specific (defaults to 1, resets to 1):
divName
1Main Division
2EuroBusiness
3EuroCargo
4EuroHolidays
5Tours
6Missions
7ProPilot Events
« Last Edit: December 14, 2009, 03:52:49 pm by EHM-0654 Murray »
Logged
Murray Crane // EHM-0654 // Twitter
VA Management

KEEP CALM AND CARRY ON

Offline EHM-1465 Dominic

  • Administrator
  • Intergalactic!!
  • ***
  • Posts: 3,529
  • Karma: 10
  • VA Management
Re: open office and downloadable timetable
« Reply #8 on: December 14, 2009, 06:57:20 pm »
Quote from: EHM-0654 Murray on December 12, 2009, 06:04:18 pm
What's column M? GCD?

GCD=Great Circle Distance - the direct GPS distance between two points on the globe's surface...
Logged
Dom Mahon // EHM-1465
VA Management

Offline EHM-0654 Murray

  • Administrator
  • Intergalactic!!
  • ***
  • Posts: 4,531
  • Karma: 5
  • VA Management
    • The Ponderings of PMUK
Re: open office and downloadable timetable
« Reply #9 on: December 14, 2009, 07:02:07 pm »
Quote from: EHM-1465 Dominic on December 14, 2009, 06:57:20 pm
GCD=Great Circle Distance - the direct GPS distance between two points on the globe's surface...

;) I know what GCD means... it was more is column M GCD (as it's got no header), but I guessed it was GCD in the PHP downloader I fabricated.
Logged
Murray Crane // EHM-0654 // Twitter
VA Management

KEEP CALM AND CARRY ON

Offline EHM-1465 Dominic

  • Administrator
  • Intergalactic!!
  • ***
  • Posts: 3,529
  • Karma: 10
  • VA Management
Re: open office and downloadable timetable
« Reply #10 on: December 14, 2009, 09:04:57 pm »
Oops - sorry mate  :-[
Logged
Dom Mahon // EHM-1465
VA Management

Offline EHM-1838 Andrew

  • Martian transfer
  • *******
  • Posts: 516
  • Karma: 1
Re: open office and downloadable timetable
« Reply #11 on: December 15, 2009, 05:43:25 pm »
AH ha!
That worked Murray. Thanks for taking the time to help.
PS I am being immensely thick here but i cant quite work out the Divs/Cats/Flights yet.(even with your diagram ::))
but i am sure it will become clear.

cheers Andy
« Last Edit: December 15, 2009, 06:00:55 pm by EHM-1838 Andrew »
Logged
Pages: [1]
« previous next »