I'm a new user of a complex website maintained by volunteers.
They recognize its complexity and have a series of HELP pages.
Unfortunately there are critical gaps.
[Suspect they originate with assumptions that "Everyone knows ..." ;]

Although I've been a computer user for ~60 years and spent decades in
various forms of customer service, I've not used some items known by
"everybody".

I'm looking for a tool which reports the time of *BOTH* the *first* and
the *most recent* visit to each URL. SeaMonkey's History nicely reports
visit count and time of most _recent_ visit. I wish to demonstrate to
those maintaining the new user help pages how some critical information
can be missed.

A web search turned up a apparently appropriate tool for *WINDOWS*.
[q.v. https://www.nirsoft.net/utils/mozilla_history_view.html ]

I need a similar tool for SeaMonkey 2.49.4 running on Debian 9.13 .
[have later versions on another machine, but this is available/working]

Suggestions?
TIA

Richard Owlett wrote:

> I'm a new user of a complex website maintained  by volunteers.

> I'm looking for a tool which reports the time of *BOTH* the *first* and
> the *most recent* visit to each URL.

Firstly, it might be better to review the website design and identify
why it's too complicated.

Secondly, it might be better to do this server side instead of relying
on per client browser history. e.g. you can use something like webalizer
to show breakdown of which pages are visited and when.

On 06/03/2023 04:09 AM, gerry 666uk wrote:
> Richard Owlett wrote:
>
>> I'm a new user of a complex website maintained  by volunteers.
>
>> I'm looking for a tool which reports the time of *BOTH* the *first*
>> and the *most recent* visit to each URL.
>
> Firstly, it might be better to review the website design and identify
> why it's too complicated.

In the first place, the website is anything but _complicated_.
It straight forwardly deals with a _complex_ topic.
I think they did an excellent job.

>
> Secondly, it might be better to do this server side instead of relying
> on per client browser history. e.g. you can use something like webalizer
> to show breakdown of which pages are visited and when.

In the second place, you snipped the description which demonstrates why
the procedure must be done client side - NOT server side.

Perhaps my post should have simply said:

> I'm looking for a tool which reports the time of *BOTH* the *first*
> and the *most recent* visit to each URL. SeaMonkey's History nicely
> reports visit count and time of most _recent_ visit.
>
> A web search turned up an apparently appropriate tool for *WINDOWS*.
> [q.v. https://www.nirsoft.net/utils/mozilla_history_view.html ]
>
> I need a similar tool for SeaMonkey 2.49.4 running on Debian 9.13 .
> [have later versions on another machine, but this is available/working]

Does such a tool exist?
TIA

Richard Owlett wrote:

> the procedure must be done client side - NOT server side.

For client side, you can access database file places.sqlite in the
profile. You can use a table join to map site url, title to the date the
site was visited, moz_places inner join moz_historyvisits. The date is
stored as an integer, not a date.

On 06/03/2023 01:33 PM, gerry 666uk wrote:
> Richard Owlett wrote:
>
>> the procedure must be done client side - NOT server side.
>
> For client side, you can access database file places.sqlite in the
> profile. You can use a table join to map site url, title to the date the
> site was visited, moz_places inner join moz_historyvisits. The date is
> stored as an integer, not a date.

Thank you.
I'm not an active programmer and not very familiar with SQLite.
I'll have to see how close I can come with its default tool set.