Setup for multiple companies/ data sets

[LSlowick]

We have several 'divisions' internally. Each division has its own set of data files located in separate directories.

With my NetTalk app how can I allow the user to select which division they would like to access and then open the appropriate set of data files.

Note the data files for each division are exactly the same names, layouts, etc.

Can this be done with one nettalk app.exe running or do I need a version for each division?

I thought I saw somewhere a post or tip on how to do this...

Thanks for any suggestions.
Lee

[Bruce]

Hi Lee,

This is a very common setup and works for TPS files, or SQL databases or however you split your data. The basic idea goes something like this;

a) create and set a session value to determine the name of the data set to use. Maybe this is on the login screen, maybe they select it on a Memory form, maybe it's "tied" to the user himself as he logs in (ie perhaps stored in your User table) or whatever.

b) In the dict all the tables need a variable for their Full Pathname. (Usually I declare the globals in the dict at the same time.) VERY IMPORTANT that these variables are THREADed, as indeed are the files.

b) Create a small, normal, Clarion source procedure which sets all the "full pathnames" based on the Session variable. For example
CustomerName = p_web.GetSessionValue('DataFolder') & '\Customers.Tps'

c) Call this source procedure from the WebHandler procedure, ProcessLink method, before the parent call.

cheers
Bruce

[LSlowick]

Bruce

Thanks for the advice. I'll give this a try.

Lee

[LSlowick]

I want to alter the header so that it displays the 'location' they are logged into.

I've gotten the login working and its is now selecting the proper set of files.

How do place a field in the header after they've selected the proper location?

If you look at the attached image I have a box in the upper right indicating where/what I'd like to see. II can set a field and alter its value when I set the datapaths, hoping to trigger this field to display 'when logged in'. I'm not really to concerned that it has to be located there, but somewhere on the header.

thanks for any help.
Lee



[attachment deleted by admin]

[peterH]

Lee,

Use a session value instead of a field and set the value once you know the location they're selecting, e.g. SetSessionValue('current_loc','Name of location').

Then, somewhere in your header xHtml, display the session value using the special tag
<!-- Net:s:current_loc --> and you're all set.

Peter

[LSlowick]

Peter

That worked! Thanks for the help.

Lee