G'day from Melbourne, Oz
Moderator: Rathinagiri
G'day from Melbourne, Oz
I started programming in Clipper back around the late 80's as a means to sort and extract data from huge numbers of phone bills we received where I worked at the time (Australian Bureau of Meteorology or Weather Bureau).
At the same time my 'part time job' needed a better solution for timing of motor sport events - first came the Commodore 64, then the 128 and then the migration from C64/128 compiled basic to PC programs and Clipper fell right into this project.
During this time I had a LOT of fun with Clipper - doing things I was told, at the time, couldn't be done. I didn't believe these 'nay-sayers' and so began nearly 20 years of playing with Clipper (under DOS!) doing things such as driving remote TV screens and terminals; sending live timing and result data to outside broadcasters for live transmission to air on TV; driving secondary displays which were then transmitted via local TV transmitters (the first in late 1986 covering a huge area - at that time - of around a square mile); and then, eventually, feeding live information directly to a web site so that there was no more than a gap of 1.5 seconds from when a car crossed the timing line until it was shown/available on the web site.
Also had a lot of fun back then with the CUG(M) (Clipper User Group (Melbourne)), beta testing products (still don't like VO!) and the others who were also active in these groups and areas.
Ahhh those were the days!
Even today, there are still a couple of clubs using my old DOS/Clipper software for their timing. As their timekeepers say - no having to worry about Windows, drivers - a very basic old machine and they are off and running.
Fast forward to the present and a few health scares over the past 5 years and a progression of prostate cancer into the spine late last year made me realise I have a LOT of data and programming tied up that I really should preserve (in the case of the data) and try to bring into the Windows era (the code). Increasing pain and treatment failures meant there were somethings I shouldn't be putting off for much longer....
The data was the hardest - having to resurrect my old Commodore computer and retrieve data off 5 1/4 disks (remember them??) and translate them from PETASCII to standard ASCII and onto a PC (had fun doing this and now have the hardware and software capability of connecting an old Commodore 1571 floppy drive to a PC and being able to read AND write data to Commodore formatted floppies!).
Now the data is being transferred and stored in MySQL databases (largest table so far has just under 9 million records..)
The code transfer was a challenge as I have effectively NEVER programmed any Windows language until the past few months - decided on Harbour and, initially, FWH 64 bit (before I realised it *didn't* include a 32 bit version and can't justify the cost for it as well, so basically wasted money on this one )
Most of my code has already transferred over without too many problems - the only hassles are display/entry screens because of the add on libs I used in Clipper (Funcky a lot, PageScript and Telepathy) but, because I want a 'Windows' look, this part is more a 'start from scratch' rather than a conversion.
General comment I have on Harbour, HMG, FWH - basically all harbour related libraries and add-ons - whilst the documentation is out there - it IS hard to find and, at times, really lacking in how you use it. Other than this, though, I'm enjoying it and having a bit of fun - well, on my good days - those days the pain becomes too much, even the computer doesn't get a look-in!
Stephen Rowe
At the same time my 'part time job' needed a better solution for timing of motor sport events - first came the Commodore 64, then the 128 and then the migration from C64/128 compiled basic to PC programs and Clipper fell right into this project.
During this time I had a LOT of fun with Clipper - doing things I was told, at the time, couldn't be done. I didn't believe these 'nay-sayers' and so began nearly 20 years of playing with Clipper (under DOS!) doing things such as driving remote TV screens and terminals; sending live timing and result data to outside broadcasters for live transmission to air on TV; driving secondary displays which were then transmitted via local TV transmitters (the first in late 1986 covering a huge area - at that time - of around a square mile); and then, eventually, feeding live information directly to a web site so that there was no more than a gap of 1.5 seconds from when a car crossed the timing line until it was shown/available on the web site.
Also had a lot of fun back then with the CUG(M) (Clipper User Group (Melbourne)), beta testing products (still don't like VO!) and the others who were also active in these groups and areas.
Ahhh those were the days!
Even today, there are still a couple of clubs using my old DOS/Clipper software for their timing. As their timekeepers say - no having to worry about Windows, drivers - a very basic old machine and they are off and running.
Fast forward to the present and a few health scares over the past 5 years and a progression of prostate cancer into the spine late last year made me realise I have a LOT of data and programming tied up that I really should preserve (in the case of the data) and try to bring into the Windows era (the code). Increasing pain and treatment failures meant there were somethings I shouldn't be putting off for much longer....
The data was the hardest - having to resurrect my old Commodore computer and retrieve data off 5 1/4 disks (remember them??) and translate them from PETASCII to standard ASCII and onto a PC (had fun doing this and now have the hardware and software capability of connecting an old Commodore 1571 floppy drive to a PC and being able to read AND write data to Commodore formatted floppies!).
Now the data is being transferred and stored in MySQL databases (largest table so far has just under 9 million records..)
The code transfer was a challenge as I have effectively NEVER programmed any Windows language until the past few months - decided on Harbour and, initially, FWH 64 bit (before I realised it *didn't* include a 32 bit version and can't justify the cost for it as well, so basically wasted money on this one )
Most of my code has already transferred over without too many problems - the only hassles are display/entry screens because of the add on libs I used in Clipper (Funcky a lot, PageScript and Telepathy) but, because I want a 'Windows' look, this part is more a 'start from scratch' rather than a conversion.
General comment I have on Harbour, HMG, FWH - basically all harbour related libraries and add-ons - whilst the documentation is out there - it IS hard to find and, at times, really lacking in how you use it. Other than this, though, I'm enjoying it and having a bit of fun - well, on my good days - those days the pain becomes too much, even the computer doesn't get a look-in!
Stephen Rowe
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: G'day from Melbourne, Oz
It is so great to read about your life with Clipper.
Personally I too use MySQL (MariaDB).
Hearty welcome to this forum. I am sure our forum is a good resource.
Personally I too use MySQL (MariaDB).
Hearty welcome to this forum. I am sure our forum is a good resource.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: G'day from Melbourne, Oz
Nice story!
Welcome from Poland!
Marek
Welcome from Poland!
Marek
- serge_girard
- Posts: 3166
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
Re: G'day from Melbourne, Oz
Wellcome from Belgium !
Serge
Serge
There's nothing you can do that can't be done...
- Pablo César
- Posts: 4059
- Joined: Wed Sep 08, 2010 1:18 pm
- Location: Curitiba - Brasil
G'day from Melbourne, Oz
Stephen, welcome to our community !
HMGing a better world
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: G'day from Melbourne, Oz
Stephen Rowe, welcome aboard
Salutes from Turkiye
Happy HMG'ing
Salutes from Turkiye
Happy HMG'ing
Viva INTERNATIONAL HMG
-
- Posts: 1275
- Joined: Tue Sep 03, 2013 4:22 am
- Location: Tecámac, México
Re: G'day from Melbourne, Oz
Wellcome from México !
Javier Tovar
Javier Tovar
Re: G'day from Melbourne, Oz
Welcome from Greece !
Best Regards,
Nikos.
os: Windows Server 2019 - 64
Nikos.
os: Windows Server 2019 - 64
- danielmaximiliano
- Posts: 2612
- Joined: Fri Apr 09, 2010 4:53 pm
- Location: Argentina
- Contact:
Re: G'day from Melbourne, Oz
Bienvenido a la casa de HMG Stephen.
Desde Buenos Aires, Argentina.
Stephen :
Welcome to the home of HMG.
From Buenos Aires, Argentina.
Desde Buenos Aires, Argentina.
Stephen :
Welcome to the home of HMG.
From Buenos Aires, Argentina.
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*
Saludos / Regards
DaNiElMaXiMiLiAnO
Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*
Saludos / Regards
DaNiElMaXiMiLiAnO
Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO