Need help on Web database

[gowrann]

I have a local shared db which lists various clients and items, I need to create a separate web db so one client can see their items (search only)- what is the best way to create it so it has the real time changes from the local db.

[Anatoli]

Publish database on Web with CDML and Custom Web Publishing.

When web client will log into your system, include his/hers ID in all searches, as hidden field so they will see only their records.

[gowrann]

Many thanks - I here it is better to keep the web db separate - what is the best way to do this?

[Leb i Sol]

right HERE

[Anatoli]

nice joke

[Garry Claridge]

You could use a Script which updates the "Web DB" each time a record is edited in the "Main DB".

Good Luck.

Garry

[gowrann]

thanks Gary - what's the best way to do this.

[Steve T.]

Hi, gowrann! Yeah, that bugs... The FMP docs on web publishing have a great little diagram that shows the recommendation of publishing a web DB pseudo-clone instead of your main DB but they don't tell you how to do it. I asked this same Q a ways back and folks basically said what Garry just said... use a Script.

I didn't know scripts well and didn't know how to auto-execute a script based on a user action, so I ended up just publishing the main DB. You can use Web Security Database to limit which fileds are accessible, but not a per user basis; it's all or nothing. Then you can control record searches (somewhat, not secure) by labeling each record with 2 fields: the "owner/client" and their "password". Using EXACT SEARCH to require both fields be entered at your made-up login screen, only their records should show up in the results. A wrong login or wrong password will have no records found.

Hope this helps!

--ST

[gowrann]

yes that great little diagram showing a perfectly sync'ed db is what I saw but can't work out how to replicate. (excuse the pun)

I would rather share a different one for the web as it will only be used for searching older records - I could do a crude cron copy very xxx hrs but would rather script it - anyone have any ideas on a script...

[Garry Claridge]

You may want to have a button on the Layouts of the main file which can run the script manually whenever a record is updated.

Alternatively, you can use an Applescript as a timer for regular-interval updates.

All the best.

Garry

[gowrann]

Gary can you give an example of the script

[Garry Claridge]

Which script?

The update script?

or

The Applescript for the timer?

I don't use this method so I do not have scripts for it. However, I have scripts that can be adapted to do what you require. I may have some spare time later next week I can do some work on this!

All the best.

Garry

[gowrann]

Hi Gary - I would like to see it with the update script.

Thanks

[Garry Claridge]

For a similar solution I use a file (the web access one) which has only one data field. This field is the Item_ID. All other fields in the database are Calculated; they are simply pointers to the related fields.

I am travelling this week (in Sydney) however I should get a chance to write a demo script for moving data from from one file to the other.

All the best.

Garry