[FX.php List] Create portal/related records with fx.php

[VanBuskirk, Patricia]

Hey Tim and Anders,

 

It is a phone and cable signup form.  All the standard stuff (name,
address, student id, phone, email, etc - mostly required)  go into the
main TO - and then they have many non-required options:  basic cable or
digital cable (radio), phone line (checkbox).  On the digital cable is
where it gets tricky.  They can choose from several premium channels
(checkboxes), HD, DVR or HD&DVR (radio )... for up to 3 rooms each item.
I've got all kinds of issets in there, and yes, each item creates at
least one record in the transactions TO.  Most times, there are more
than one child record ...i.e. if they request a phone, 5 child records
are created (installation, etc.).   

 

The original database was created by someone else and was basically a
flat file, a field for every form field.  I created the transactions
table, and 4 new fields in the original database that kind of gather up
1) Premiums 2) Dig Options 3) AddtlBoxes 4) Room into lists.  The reason
we are having to do this, is that we want to eliminate manual entry of
orders into the PeopleSoft system, where all this eventually ends up.
They couldn't be exported as they were.

 

Thanks guys!

 

~ Trish

 

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Monsen,
Anders
Sent: Tuesday, August 24, 2010 3:49 PM
To: FX.php Discussion List
Subject: RE: [FX.php List] Create portal/related records with fx.php

 

Trish,

 

If you go this route, see if you can replicate the process as a script
in FMP, then fire this from PHP and as the last step return the result
to the screen via PHP.

 

Are the many options selected from checkboxes? Do they span multiple
TOs? Not sure about imports, but if the child records are each related
to the parent table but reside in separate TOs, are you then creating
multiple db connections when creating the child records? Even so, 20
child records should not take more than 30 seconds.

 

Anders

 

________________________________

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of VanBuskirk,
Patricia
Sent: Tuesday, August 24, 2010 2:27 PM
To: FX.php Discussion List
Subject: RE: [FX.php List] Create portal/related records with fx.php

 

I've considered it, Anders, but not quite sure where to begin on that
one.  Would you do several finds/imports or is there an easier way?  

 

Forgive me if I'm overlooking the obvious, but this php has whooped my
butt the last couple of weeks ... I was doing php code in my dream (or
was it a nightmare) last night!

 

~ Trish

 

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Monsen,
Anders
Sent: Tuesday, August 24, 2010 3:19 PM
To: FX.php Discussion List
Subject: RE: [FX.php List] Create portal/related records with fx.php

 

There was a similar issue somewhat more recently, which was solved by
letting a script inside FileMaker create the individual child records.
Have you tried this?

 

--

Anders Monsen

 

________________________________

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of VanBuskirk,
Patricia
Sent: Tuesday, August 24, 2010 11:48 AM
To: FX.php Discussion List
Subject: [FX.php List] Create portal/related records with fx.php

 

(Using Fx.php with FM9A on Win2003 Server and IIS)

 

I searched the list archive and only found answers to my question from
2005, and even then I didn't see a real solution.

 

I have a form that feeds many fields into the parent table,  creates a
session with the resulting order number, then creates individual child
records for each selection (many, if/thens).  If every choice was
selected, there would be about 20 child records to create.  This times
out php, even after changing the default 30 seconds to 90.  There MUST
be an easier way?

 

As usual, any advice is greatly appreciated!

 

Trish V.

 

This message and any attachments are intended only for the use
of the intended recipient and may contain information that is
privileged and confidential. If the reader of the message is not the
intended recipient or an authorized representative of the intended
recipient, you are hereby notified that distribution, disclosure,
printing, copying, storage, modification or the taking of any action
in reliance upon this transmission is strictly prohibited. Delivery of
this message to any person other than the intended recipient shall
not compromise or waive such confidentiality.  If you have received
this communication in error, notify the sender immediately by
return email and delete the message and any attachments from
your system. Messages sent to or from this contact will be
recorded and are subject to archival, monitoring, and/or disclosure
to someone other than the recipient.
 
This message and any attachments are intended only for the use
of the intended recipient and may contain information that is
privileged and confidential. If the reader of the message is not the
intended recipient or an authorized representative of the intended
recipient, you are hereby notified that distribution, disclosure,
printing, copying, storage, modification or the taking of any action
in reliance upon this transmission is strictly prohibited. Delivery of
this message to any person other than the intended recipient shall
not compromise or waive such confidentiality.  If you have received
this communication in error, notify the sender immediately by
return email and delete the message and any attachments from
your system. Messages sent to or from this contact will be
recorded and are subject to archival, monitoring, and/or disclosure
to someone other than the recipient.
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100824/374a292a/attachment.html