View Single Post
  #44   Report Post  
Old October 1st 03, 04:11 PM
Hank Oredson
 
Posts: n/a
Default


"Peter Lemken" wrote in message
...
Hank Oredson wrote:

I am aware of the architecture, understand how the certificates
are used, have my own database and software for dealing with
logs, station identification, DX entities, have ADIF
reading and writing functions for that database, etc.

What I have not yet found is the API into the LotW database, so that I
can create my own client to view, modify, delete and insert QSO data.


Something like that?

|Detailed Description
|The Data API is used to form data into TrustedQSL
|records. A TrustedQSL record consists of a station record and a QSO
|record. Together, the two records fully describe one station's end of the
|QSO -- just as a paper QSL card does.

I believe this describes the local part of want you want to do with your
QSO-data: Forming records, converting and modifying these records and then
upload them via the tqsllib.

Have I understood you correctly this time?



Getting closer :-)

Here is a description of one application.

1. Connect to the server.
This would probably be via HTTP with a cookie to create a session.

2. Authenticate myself to the server.
Using my user name and password, and possibly a certificate.

3. Query the server for one or more QSO records.
Something that looks like SQL would be most convenient.
It should be possible to say "read only" or "for modification".

4. Acquire the records returned by the query.
The server must also return status information for each record.

5. View and modify the records locally. Possibly create new records.

6. Return any modified or new records to the server.

7. Acquire status information from the server.

8. Disconnect from the server.

I want operations on records, not fields.
Things like "tqsl_getLocationDXCCEntity" are simply too low level.

What I do not see in tqsllib are the "open database", "get record",
"put record", "close database" functions that are needed to build an
application. We will see how things work out over time. Perhaps
everything I want is actually there, hidden under that huge pile of
low level internal function calls.

--

... Hank

Hank: http://horedson.home.att.net
W0RLI: http://w0rli.home.att.net