2. PHPRunner General questions
  3. bulk edit and update
This topic is locked

bulk edit and update

 		2/3/2010 7:40:42 PM
PHPRunner General questions
G
 greener author

Hi all,

I am new to PHP Runner and about to purchase. It is a fantastic program and I have been through most of the commercial and online databases. A few questions on capabilities - mostly what I am "missing" from some of the other solutions. perhaps their are "plugins" or some feature that I have overlooked.

  1. Bulk Edit. I miss being able select 20 records and replace the value in a single field all at one time. this value would replace all 20 records at once.
  2. Updating records From a CSV file. I often need to import a csv file and replace the value in a particular field. So if the file contains 50 records with two fields ID, ProdName - I want to replace the 50 records with the first match to ID. Granted this can be done using a SQL Update command, but it would be nice to have this feature in the import. BTW this feature is missing from most of the other mysql/php gui's (but is in dabbledb.com)
    and last I don't quite understand how to configure the "quick search" utility on the page list. currently the fields that are relational and based on other tables do not return results. I have them linked through the "tables" page/scheme.
    Thank you in advance. rg
Sergey Kornilov admin 2/4/2010

In regards to updating multiple records on the list page here is the article that can help:

http://xlinesoft.com/phprunner/docs/update_multiple_records.htm
You need to allow user enter value to be inserted into the database. You can use Javascript function prompt() for this purpose:

newvalue=prompt("Enter new value","new");
In regards to update from CSV - it already works this way. Its trying to insert the record first and if such ID exist already it updates it with new values.
In regards to quick search - I guess you need to setup those fields as 'Lookup wizard'. This can be done in Visual Editor. Double-click on field to set 'Edit as' type to 'Lookup wizard'.
G
 		greener author 2/4/2010



In regards to updating multiple records on the list page here is the article that can help:

http://xlinesoft.com/phprunner/docs/update_multiple_records.htm
You need to allow user enter value to be inserted into the database. You can use Javascript function prompt() for this purpose:

newvalue=prompt("Enter new value","new");
In regards to update from CSV - it already works this way. Its trying to insert the record first and if such ID exist already it updates it with new values.
In regards to quick search - I guess you need to setup those fields as 'Lookup wizard'. This can be done in Visual Editor. Double-click on field to set 'Edit as' type to 'Lookup wizard'.



Thank you. I'm good on the first two questions, but the search is still a problem for me. I've set up the lookup wizard on the 'Search page' and it works fine on the advanced search page - I just don't see a way to configure the 'lookup wizard' for the quick search on the 'List Page' as I don't see the 'properties' like I do when clicking the search field in the visual editor in the 'Search page' which the configuration I presume effects just the advanced search page.

thank you... rg
Sergey Kornilov admin 2/4/2010

Check PHPRunner 5.2 that comes with handy search panel on the list page. I guess this exactly what you looking for.

http://www.asprunner.com/forums/topic/13378-asprunnerpro62phprunner52-beta-is-available-for-download/