2. PHPRunner General questions
  3. Add table update to export
This topic is locked

Add table update to export

 		10/20/2005 14:03:31
PHPRunner General questions
jimhnet author

How hard would it be to add an export option to write the selected fields to another table ie kind of a batch process synchronization. If you set the other table value(mysql) for unique on say email what whould you have to add to increment the records if the record exists.
I can see all sorts of possibilities for this capability from list sync to batch accounting type updates. I know I can do it real time to a certain extent but after 35 years doing these sort of things batch, I guess I just think that way.
Thanks
Jim Freeman
Sergey Kornilov admin 10/21/2005

Jim,
PHPrunner pages can not copy records from one table to another.
So adding this feature to export page is as hard as making it from a scratch.
scuba 10/27/2005

Jim, I'm not shure if I get you right on this, but you can do data-copying by transfroming your MySQL tables from MyISAM to InnoDB since this format provides transaction handling. Then set up the field-links between two tables - PHPRunner will work as usual and display any transaction-data correctly.