[FX.php List] Approach to update FM data from web input

[Jonathan Schwartz]

Thanks for the responses.

Here's a summary of what you said:

1) Update directly into the primary database using:
	- robust error checking
	- logging for recovery/backout/history

2) Update into second copy of the database, apart from the primary database
	- Staff reviews new data and approves before replacing original data

3) Update into primary database but into duplicate records. (This was 
mine for a limited project)

I'm leaning towards Option 1.

Jonathan

At 7:42 PM -0500 8/26/08, John Funk wrote:
>Jonathan,
>I had a solution a few years ago were I duplicated the table, then put all
>new / changed data into and kept the old data intact. Then navigating them
>to a duplicate screen that shows the new data. This way I had an "undo"
>function.
>John Funk
>
>-----Original Message-----
>From: fx.php_list-bounces at mail.iviking.org
>[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Jonathan Schwartz
>Sent: Tuesday, August 26, 2008 6:04 PM
>To: fx.php_list at mail.iviking.org
>Subject: [FX.php List] Approach to update FM data from web input
>
>Hi Folks,
>
>I'm working on a solution where the user (customer) will be able to
>log in and update their customer information online.
>
>While this isn't an issue technically, there's the business issue of
>how to process the new data without the risk of losing the original
>data....especially if the new data is invalid.
>
>In my last experience in this arena, I was astonished at how
>determined one user was to erase every bit of data presented on the
>web form.  The customer could just clicked one box to become
>inactive.  Instead, they felt compelled to eradicate their data.  In
>this case, there was a second records for each customer that
>contained the original data...the effort was futile.
>
>So...what do you folks do?
>
>Jonathan
>
>
>--
>Jonathan Schwartz
>Exit 445 Group
>jonathan at exit445.com
>http://www.exit445.com
>415-370-5011
>_______________________________________________
>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


-- 
Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-370-5011