Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 1st 04, 02:37 AM
Ken Scharf
 
Posts: n/a
Default ARRL CD ROMS under linux.

For those hams running linux, I've found I can read
the ARRL QEX and QST View cd roms under linux using either
the Gimp or Open Office writer. These cdroms are scanned
images in tiff or jpg formats which import into either program.
By importing into an OO text document I can convert the articles
into PDF files and print double sided to my printer for
hard copy.

I started looking at writing a program to search the QST view
database found on the disks. The database on the disks up to
1990 (not sure about the 1995 disk) is an ascii representation
of a 3 table SQL database so I can create a MySQL, Posgres, or
similar SQL database to search. The QEX disk has a binary database
of which some sections are readable under vi as text that also appear
to be a set of SQL tables, so extraction of useful data may be
possible here as well. If I could find documention on performing
'macro' commands on a running OO session from another program I could
use OO to build pdf files from a search application (you can do this
under windows using VB script to control a word session).

The QST view database is somewhat incomplete as the final pages
of an article are not referenced in the database and you have to
manually hunt for them, even if you use the windows software.
QEX mostly kept the articles contiguous.
  #2   Report Post  
Old May 1st 04, 04:21 AM
Michael Black
 
Posts: n/a
Default

Ken Scharf ) writes:
For those hams running linux, I've found I can read
the ARRL QEX and QST View cd roms under linux using either
the Gimp or Open Office writer. These cdroms are scanned
images in tiff or jpg formats which import into either program.
By importing into an OO text document I can convert the articles
into PDF files and print double sided to my printer for
hard copy.

I started looking at writing a program to search the QST view
database found on the disks. The database on the disks up to
1990 (not sure about the 1995 disk) is an ascii representation
of a 3 table SQL database so I can create a MySQL, Posgres, or
similar SQL database to search. The QEX disk has a binary database
of which some sections are readable under vi as text that also appear
to be a set of SQL tables, so extraction of useful data may be
possible here as well. If I could find documention on performing
'macro' commands on a running OO session from another program I could
use OO to build pdf files from a search application (you can do this
under windows using VB script to control a word session).

The QST view database is somewhat incomplete as the final pages
of an article are not referenced in the database and you have to
manually hunt for them, even if you use the windows software.
QEX mostly kept the articles contiguous.


Have you just started playing with this?

Because someone did write about their experiences years back, at
least I think they had had success with those CDROMs under Linux.
I've been meaning to go digging to try to find the post or posts,
because now that I have a computer with a CDROM drive, obviously
those QSTs on CDROM become tempting. And I've never had Windows
running here.

Michael VE2BVW

  #3   Report Post  
Old May 1st 04, 04:21 AM
Michael Black
 
Posts: n/a
Default

Ken Scharf ) writes:
For those hams running linux, I've found I can read
the ARRL QEX and QST View cd roms under linux using either
the Gimp or Open Office writer. These cdroms are scanned
images in tiff or jpg formats which import into either program.
By importing into an OO text document I can convert the articles
into PDF files and print double sided to my printer for
hard copy.

I started looking at writing a program to search the QST view
database found on the disks. The database on the disks up to
1990 (not sure about the 1995 disk) is an ascii representation
of a 3 table SQL database so I can create a MySQL, Posgres, or
similar SQL database to search. The QEX disk has a binary database
of which some sections are readable under vi as text that also appear
to be a set of SQL tables, so extraction of useful data may be
possible here as well. If I could find documention on performing
'macro' commands on a running OO session from another program I could
use OO to build pdf files from a search application (you can do this
under windows using VB script to control a word session).

The QST view database is somewhat incomplete as the final pages
of an article are not referenced in the database and you have to
manually hunt for them, even if you use the windows software.
QEX mostly kept the articles contiguous.


Have you just started playing with this?

Because someone did write about their experiences years back, at
least I think they had had success with those CDROMs under Linux.
I've been meaning to go digging to try to find the post or posts,
because now that I have a computer with a CDROM drive, obviously
those QSTs on CDROM become tempting. And I've never had Windows
running here.

Michael VE2BVW

  #4   Report Post  
Old May 1st 04, 02:58 PM
Ken Scharf
 
Posts: n/a
Default

Michael Black wrote:
Ken Scharf ) writes:

For those hams running linux, I've found I can read
the ARRL QEX and QST View cd roms under linux using either
the Gimp or Open Office writer. These cdroms are scanned
images in tiff or jpg formats which import into either program.
By importing into an OO text document I can convert the articles
into PDF files and print double sided to my printer for
hard copy.

I started looking at writing a program to search the QST view
database found on the disks. The database on the disks up to
1990 (not sure about the 1995 disk) is an ascii representation
of a 3 table SQL database so I can create a MySQL, Posgres, or
similar SQL database to search. The QEX disk has a binary database
of which some sections are readable under vi as text that also appear
to be a set of SQL tables, so extraction of useful data may be
possible here as well. If I could find documention on performing
'macro' commands on a running OO session from another program I could
use OO to build pdf files from a search application (you can do this
under windows using VB script to control a word session).

The QST view database is somewhat incomplete as the final pages
of an article are not referenced in the database and you have to
manually hunt for them, even if you use the windows software.
QEX mostly kept the articles contiguous.



Have you just started playing with this?

Because someone did write about their experiences years back, at
least I think they had had success with those CDROMs under Linux.
I've been meaning to go digging to try to find the post or posts,
because now that I have a computer with a CDROM drive, obviously
those QSTs on CDROM become tempting. And I've never had Windows
running here.

Michael VE2BVW

I've been looking at this for awhile, but havn't yet written
any code. Havn't yet figured out which SQL database to use,
but there is an embedded open source implementation (name escapes
me at the moment) that is easier to use then MySql or Postgres
which doesn't require the server to be installed. Converting
the QST view database would require a simple C program to read
and parse the ascii file into three tables, then just write
some simple SQL searches to retrieve the data.
The hard part is to access OO write via backdoor scripts to
create a document to read or print from the images on the cdrom.
Of course that part can be done by hand once you have the list
of file names.
I hope to find time to sit down and write the code to do the
first part, maybe someone familar with the backends of OO can
help me with the second part.
  #5   Report Post  
Old May 1st 04, 02:58 PM
Ken Scharf
 
Posts: n/a
Default

Michael Black wrote:
Ken Scharf ) writes:

For those hams running linux, I've found I can read
the ARRL QEX and QST View cd roms under linux using either
the Gimp or Open Office writer. These cdroms are scanned
images in tiff or jpg formats which import into either program.
By importing into an OO text document I can convert the articles
into PDF files and print double sided to my printer for
hard copy.

I started looking at writing a program to search the QST view
database found on the disks. The database on the disks up to
1990 (not sure about the 1995 disk) is an ascii representation
of a 3 table SQL database so I can create a MySQL, Posgres, or
similar SQL database to search. The QEX disk has a binary database
of which some sections are readable under vi as text that also appear
to be a set of SQL tables, so extraction of useful data may be
possible here as well. If I could find documention on performing
'macro' commands on a running OO session from another program I could
use OO to build pdf files from a search application (you can do this
under windows using VB script to control a word session).

The QST view database is somewhat incomplete as the final pages
of an article are not referenced in the database and you have to
manually hunt for them, even if you use the windows software.
QEX mostly kept the articles contiguous.



Have you just started playing with this?

Because someone did write about their experiences years back, at
least I think they had had success with those CDROMs under Linux.
I've been meaning to go digging to try to find the post or posts,
because now that I have a computer with a CDROM drive, obviously
those QSTs on CDROM become tempting. And I've never had Windows
running here.

Michael VE2BVW

I've been looking at this for awhile, but havn't yet written
any code. Havn't yet figured out which SQL database to use,
but there is an embedded open source implementation (name escapes
me at the moment) that is easier to use then MySql or Postgres
which doesn't require the server to be installed. Converting
the QST view database would require a simple C program to read
and parse the ascii file into three tables, then just write
some simple SQL searches to retrieve the data.
The hard part is to access OO write via backdoor scripts to
create a document to read or print from the images on the cdrom.
Of course that part can be done by hand once you have the list
of file names.
I hope to find time to sit down and write the code to do the
first part, maybe someone familar with the backends of OO can
help me with the second part.


  #6   Report Post  
Old May 1st 04, 07:45 PM
xpyttl
 
Posts: n/a
Default

"Michael Black" wrote in message
Because someone did write about their experiences years back, at
least I think they had had success with those CDROMs under Linux.
I've been meaning to go digging to try to find the post or posts,
because now that I have a computer with a CDROM drive, obviously
those QSTs on CDROM become tempting. And I've never had Windows
running here.


The newer ARRL Periodicals CDs are all PDF files. There is one PDF per
issue so it's pretty handy compared to a tiff file per page. I stuffed it
into my Fedora box an read it with no problem.

...


  #7   Report Post  
Old May 1st 04, 07:45 PM
xpyttl
 
Posts: n/a
Default

"Michael Black" wrote in message
Because someone did write about their experiences years back, at
least I think they had had success with those CDROMs under Linux.
I've been meaning to go digging to try to find the post or posts,
because now that I have a computer with a CDROM drive, obviously
those QSTs on CDROM become tempting. And I've never had Windows
running here.


The newer ARRL Periodicals CDs are all PDF files. There is one PDF per
issue so it's pretty handy compared to a tiff file per page. I stuffed it
into my Fedora box an read it with no problem.

...


  #8   Report Post  
Old May 1st 04, 10:11 PM
Ken Scharf
 
Posts: n/a
Default

xpyttl wrote:
"Michael Black" wrote in message

Because someone did write about their experiences years back, at
least I think they had had success with those CDROMs under Linux.
I've been meaning to go digging to try to find the post or posts,
because now that I have a computer with a CDROM drive, obviously
those QSTs on CDROM become tempting. And I've never had Windows
running here.



The newer ARRL Periodicals CDs are all PDF files. There is one PDF per
issue so it's pretty handy compared to a tiff file per page. I stuffed it
into my Fedora box an read it with no problem.

..


Those CD's are the ones for a single year. AFAIK they have always been
pdf format. The multi year cd's are of the tiff/jpg image kind, with
a windows search engine.
  #9   Report Post  
Old May 1st 04, 10:11 PM
Ken Scharf
 
Posts: n/a
Default

xpyttl wrote:
"Michael Black" wrote in message

Because someone did write about their experiences years back, at
least I think they had had success with those CDROMs under Linux.
I've been meaning to go digging to try to find the post or posts,
because now that I have a computer with a CDROM drive, obviously
those QSTs on CDROM become tempting. And I've never had Windows
running here.



The newer ARRL Periodicals CDs are all PDF files. There is one PDF per
issue so it's pretty handy compared to a tiff file per page. I stuffed it
into my Fedora box an read it with no problem.

..


Those CD's are the ones for a single year. AFAIK they have always been
pdf format. The multi year cd's are of the tiff/jpg image kind, with
a windows search engine.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ARRL Propose New License Class & Code-Free HF Access Lloyd Mitchell Antenna 43 October 26th 04 01:37 AM
ARRL Walks Away From Bandwidth Restrictions Louis C. LeVine Dx 36 September 9th 04 09:30 AM
ARRL Walks Away From Bandwidth Restrictions Louis C. LeVine Dx 0 September 5th 04 08:30 AM
To ALL DX! Me Dx 16 April 1st 04 06:52 AM


All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 RadioBanter.
The comments are property of their posters.
 

About Us

"It's about Radio"

 

Copyright © 2017