[FX.php List] [OFFish] opening a new file on server

[Steve Winter]

lol love the TLA fest ;-)

I'm not sure how I could have designed this any other way. Currently each
school needs to have a separate database of their own, I guess I could have
built one huge database, and then given each school an id within that db,
and then added that ID to every search that I did on every table within the
db, but given that this is already a pretty complex system anyway (and based
on an existing FMP solution) and we're talking about thousands of records
per school, I didn't want to go down that line...

Maybe I should have, but I think there would have been serious performance
issues, but as you say, too late now...

I guess what I'm trying to do is a little different from the norm, in that I
want to web-connect to the FM server service, rather than a database running
on it... ho hum...

Any other ideas out there...??

Thanks
Steve
-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of DC
Sent: 04 December 2007 20:33
To: FX.php Discussion List
Subject: Re: [FX.php List] [OFFish] opening a new file on server

right, i'm still in FMP6 land and i missed FMS v. FMP - in your post you 
use both TLAs and i skimmed it and assumed you were talking about the 
FMP client database which can run scripts.

not sure if you can run scripts in FMS without going through a client.

if it were up to me i would have designed the dbs so that they didn't 
require a service restart or FMS manipulation. you probably can't go 
back in time though... ;-)

FWIW. it's my 2 cents. AFAIK. YMMV.

dan
Steve Winter had written:
> Hi Dan,
> 
> Thanks for the thought, and the link to your PHP script...
> 
> I must however be missing here something here... how will an FMP script
open
> a database on an FMServer...?? or is this a function of the fact that the
> CWP server is now also the FMS...?? What script step would I use...??
> 
> I can see how a script in a database, running in an FMP client could be
used
> to open another database which is hosted on the FMS, within the client,
but
> what I want to do is open the database on FMS... maybe I didn't explain
> myself properly last time, or have missed the point of your post... ??
does
> the Open File script step perform the open function on the server, if
called
> through the XML interface...??
> 
> Thanks
> Steve
> 
> 
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of DC
> Sent: 04 December 2007 19:56
> To: FX.php Discussion List
> Subject: Re: [FX.php List] [OFFish] opening a new file on server
> 
> run an FMP script that opens the db named via PHP and a GET or POST 
> parameter?
> 
> http://snurl.com/1umx4
> 
> dan
> 
> Steve Winter had written:
>> Hi all,
>>
>>  
>>
>> I've been working on a solution over the last few weeks which will be 
>> used by schools for monitoring behaviour management within the school. 
>> It's based on an FMP database, and uses FX to deliver the content. It is 
>> anticipated that there will multiple schools using the system, with each 
>> school having their own copy of the 'base' database and the associated 
>> PHP files so that it's possible to do customisations on a school by 
>> school basis. all good so far.
>>
>>  
>>
>> We would however like to have a completely web-based 'management' aspect 
>> of this, which would mean that a school would register, and at 
>> completion of registration (into a separate master database) PHP would 
>> set up the school folder with a default install of the system, copy the 
>> 'master' database, giving it an appropriate name, into the FMS databases 
>> folder. and it's there that I run into a substantial snag.! Everything 
>> is in place, *except* that the database isn't open on the server.
>>
>>  
>>
>> Does anyone have any clever ideas about how I can tell FMS to open the 
>> new database.? I guess I could take the brute-force approach and use 
>> exec() commands to stop, then restart the FMS service, but that will 
>> clearly disrupt everyone else.!! I notice some of the FMP hosting 
>> providers offer a web-based interface which they say can be used to open 
>> and close dbs, anyone got any idea how they work.?
>>
>>  
>>
>> Any thoughts.??
>>
>>  
>>
>> Thanks
>>
>> Steve
>>
>>  
>>
>>  
>>
>>  
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list