Logging users searches

[graemeaustin]

I am in the process of creating a web-based database running on FM server 5.5 on a Mac (if that makes a difference).

Guest users will be allowed to search through the database (having registered a username/password programmatically).

My question is this: does anyone know a good way to log what searches they perform in a separate database so that i can see which queries are most popular - so that for instance I could hardcode those searches for a 'quick search' page.

Thanks in advance.

Graeme

[Anatoli]

No problem, you can log all reply pages with single line of Inline tags. It was already discussed here...

[graemeaustin]

Thanks, but I can't find it in the archives. Could you give me an idea when the discussion took place etc. so I can gain from the previous chats.

Thanks a bunch.

Graeme

[Anatoli]

The search engine found 70 inline threads.

Oh well, my code is:

code:

---

[FMP-InlineAction: -db=prtzlog.fp5, klic={CurrentToken: 3}, TZnSz=AKS, -New] [/FMP-InlineAction]

---

That will create new record in prtzlog.fp5 and populate fields klic and TZnSz vith variable {CurrentToken: 3} and with static value AKS. The record have autoenter creation date/time.

[graemeaustin]

Thanks, but I was not clear in my original query. Yes Anatoli, that is how you use inline to create a record in a separate database, but how do I capture the search criteria being deployed as it may be embedded inside the URL or have been passed to FM via a form?

I'm sure it's got something to do with the way that html is sent to the servier (or something) but I'm no web expert.

Graeme

[Anatoli]

code:

---

Repeats the HTML between [FMP-CurrentFind] and [/FMP-CurrentFind] for each find criteria that was part of the request that created this page.

---

Will this be OK (it is from CDML database)?

[graemeaustin]

Brilliant Anatoli!

I saw it in the reference database a while ago but it did not stay in my head

Thanks a bunch!

Graeme

[Anatoli]

BTW, I was living in London for 11 years so I owe something to you all Londoners! Beautiful City!

[graemeaustin]

Hey, straight back to you: I was taken to Prague for my 30th birthday and it's a fabulous, beautiful city.

Graeme

[graemeaustin]

BTW I've just thought of another way which I'll share:

[FMP-Link: drlsmkta]

This creates a string starting with 'FMPro?' and followed by the find criteria in URL format. So it is a simple job to shove that in a logging database with minimal back-end processing.

Graeme

[Anatoli]

quote:

---

Originally posted by graemeaustin:

Hey, straight back to you: I was taken to Prague for my 30th birthday and it's a fabulous, beautiful city.

Graeme

---

But you wouldn’t like to live here 11 years on Czech terms and salaries