I am looking at converting an application that I have in Intraweb with the use of TMS components to Web Builder. This application processes delivery orders. Each of the clients have their own shipping or address lists that are unique to them. I am wondering if I can currently somehow write and read client data that would be used to fill in Web Builder forms on the server side using Web Builder only, and somehow read the client side data or tables that have addresses unique to them, and without keeping several independent client lists on the server side.

I do have a DBISAM client-server application that does this very well, which connects to the server to process the orders once filled in in two ways. 1. It processes orders and posts each individual order. 2. Multiple orders can be entered then batch appended to the server. However for some clients they insist on only browser based applications where we cannot install software on the client side for security and other reasons.

Is there a way I can read addresses and data from EDB tables that belong to each client from the client side. I am developing a pricing matrix that calculates freight prices based on a zip code to a destination. Any help or input is appreciated.

On another note, it wold be nice if Elevate Software could come up with a bundled price for support, since it looks like I may be supporting all core products (DBISAM, EDB and EWB). Having to buy each one along with all the other components I have is a bit to manage at times.

John,

Not sure if i understand this correctly but it can definitely be done -
however you'd need to customize the server end a bit.

In our case I wrote an EWB app that requires user to login and that sets
up filtering rules on web services side so any future request is
automatically filtered to only include records they should have access to.

If you can't/don't want to do login then you could hard-code the per
customer limits into EWB app or host it from a custom URL so that on
startup EWB app can read it's URL and derive any SQL filters etc from
there. Either scenario would involve setting up multiple instances of
the EWB app though on different URLs if multiple customers access the
same web server.

Raul


On 11/16/2012 7:17 PM, John Postnikoff wrote:
> Each of the clients have their own shipping or address lists that are unique to them. I am wondering if I can currently somehow write and read client data that would be used to fill in Web Builder forms on the server side using Web Builder only, and somehow read the client side data or tables that have addresses unique to them, and without keeping several independent client lists on the server side.
> Is there a way I can read addresses and data from EDB tables that belong to each client from the client side. I am developing a pricing matrix that calculates freight prices based on a zip code to a destination. Any help or input is appreciated.

John,

<< Is there a way I can read addresses and data from EDB tables that belong
to each client from the client side. I am developing a pricing matrix that
calculates freight prices based on a zip code to a destination. Any help or
input is appreciated. >>

When you say "client", are you meaning each client PC on the network at a
given customer location ?

<< On another note, it wold be nice if Elevate Software could come up with a
bundled price for support, since it looks like I may be supporting all core
products (DBISAM, EDB and EWB). Having to buy each one along with all the
other components I have is a bit to manage at times. >>

I will let Sam know about this, and we'll see what we can do to make things
easier for you.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Yes this is what I mean.  I am hoping to read a physical or memory table installed at each customer location. The problem is I can install a data file or table on the customer end.  I am not able to install any application due to security reasons, and there seems no way around it unless I create some sort of filtered or un-filtered look-up unique to each customer as suggested on the server side, which I am afraid would slow performance and be difficult to manage if that was unique to each customer. I want to look at all options to see if it even can be done, and of course the best method.

Thanks,

John

>>When you say "client", are you meaning each client PC on the network at a
>>given customer location ?



"Tim Young [Elevate Software]" wrote:

John,

<< Is there a way I can read addresses and data from EDB tables that belong
to each client from the client side. I am developing a pricing matrix that
calculates freight prices based on a zip code to a destination. Any help or
input is appreciated. >>

When you say "client", are you meaning each client PC on the network at a
given customer location ?

<< On another note, it wold be nice if Elevate Software could come up with a
bundled price for support, since it looks like I may be supporting all core
products (DBISAM, EDB and EWB). Having to buy each one along with all the
other components I have is a bit to manage at times. >>

I will let Sam know about this, and we'll see what we can do to make things
easier for you.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

John,

<< Yes this is what I mean.  I am hoping to read a physical or memory table
installed at each customer location. The problem is I can install a data
file or table on the customer end.  I am not able to install any application
due to security reasons, and there seems no way around it unless I create
some sort of filtered or un-filtered look-up unique to each customer as
suggested on the server side, which I am afraid would slow performance and
be difficult to manage if that was unique to each customer. I want to look
at all options to see if it even can be done, and of course the best method.
>>

The only way to allow such a thing would be to have each client running a
web server that has the server-side code to serve up such data (such as the
EWB web server).  However, you'd also have to turn off the same-source
security restrictions in the browser that would prevent an EWB application
loaded from X from accessing a dataset from Y.  IOW, it's pretty much a
non-starter in terms of browser security.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com