dbEdit - DB Table editor module | MODX Community Forums

1,624 Posts

cipa Reply #71, 16 years, 8 months ago

Try to fill all the fields with simple text.

Responsive CSS Grid: cipalabs.com/projects/metal/
Blog: MODX Tutorials & Articles

30 Posts

ganesh_1707 Reply #72, 16 years, 8 months ago

Quote from: cipa at Jan 28, 2010, 08:10 AM

Try to fill all the fields with simple text.

I am gettin same error Unable to save configuration

30 Posts

ganesh_1707 Reply #73, 16 years, 7 months ago

Hey pls help me . I am still gettin same error "Unable to save configuration"

1,624 Posts

cipa Reply #74, 16 years, 7 months ago

Please try with the original version. On this page there another 2 versions. You might try them as well.

Are you sure you have everything set up correctly.

Responsive CSS Grid: cipalabs.com/projects/metal/
Blog: MODX Tutorials & Articles

30 Posts

ganesh_1707 Reply #75, 16 years, 7 months ago

Quote from: cipa at Feb 01, 2010, 08:12 AM

Please try with the original version. On this page there another 2 versions. You might try them as well.

Are you sure you have everything set up correctly.

Thanks cipa

my problem is solved

372 Posts

bwente Reply #76, 16 years, 7 months ago

This module will really help with eliminating a lot of the workarounds I have with making hidden containers of documents. But...

I try to normalize the tables as best that I can. It took me a while to figure it out, but I have the foreign ID’s working. But I can’t hide the lookup id’s on the list page. (see image)

I great as the module is, it might be too much for a data entry person to understand. It would be nice to add some content to the detail edit page and new record page.

Is there a way I can associate records with a Resource? (see image) I have records mapped to a document ID, I would like the user to go to one place to modify that resource. (pagetitle, content, dbedit table)

DropboxUploader -- Upload files to a Dropbox account.
DIG -- Dynamic Image Generator
gus -- Google URL Shortener
makeQR -- Uses google chart api to make QR codes.
MODxTweeter -- Update your twitter status on publish.

1,010 Posts

TobyL Reply #77, 16 years, 7 months ago

Answer to your first question:

You can use the "select_sql" advanced setting in the configuration to make your own listing. Create a new setting in the table configuration (at the bottom of the dbEdit configuration page) and use a (join) SQL statement to populate the list... For example;

select_sql >> SELECT t1.page_title, t2.color_name as color, [...more fields] FROM clothing AS t1 INNER JOIN product_colors AS t2 ON t1.color_id = t2.id;

As to answer your second question... No, in the current version that’s not possible.

eForm | eForm support | eForm @ wiki

372 Posts

bwente Reply #78, 16 years, 7 months ago

Thanks TobyL! I added joins to my query.

SELECT m1.pagetitle, c1.color_name, s1.size_name, p1.inventory, p1.price FROM products AS p1 
INNER JOIN modx_site_content AS m1 ON p1.doc_id = m1.id 
INNER JOIN colors AS c1 ON p1.color_id = c1.id 
INNER JOIN sizes AS s1 ON p1.size_id = s1.id

But now when I go to edit a record the values do not appear for inventory and price. The others appear since I have queries for the select menus. When I add a new record those values do get recorded.

DropboxUploader -- Upload files to a Dropbox account.
DIG -- Dynamic Image Generator
gus -- Google URL Shortener
makeQR -- Uses google chart api to make QR codes.
MODxTweeter -- Update your twitter status on publish.

1,624 Posts

cipa Reply #79, 16 years, 7 months ago

Just so it doesn’t get lost:

It was reported that dbEdit did not cleared the cache when values were updated so I added this functionality

1. add the following function to the end of index.php

function clearCache() {
	    include_once "processors/cache_sync.class.processor.php";
	    $sync = new synccache();
	    $sync->setCachepath("../assets/cache/");
	    $sync->setReport(false);
	    $sync->emptyCache();
	}

2. modify record.save.inc.php around line 103

if($ok){
		
		//clear cache
		clearCache();
		
		$_SESSION['dbedit_message'] = array('succes',$msg);
		header("location: {$uri}");
		exit;
		
	}

3. edit record.delete.inc.php at line 39

if($ok){
	
	//clear cache
	clearCache();
	
	$_SESSION['dbedit_message'] = array('succes',$msg);
	header("location: index.php?a=".$_REQUEST['a']."&id=".$module_id.'&db='.$db_id);
	exit;
}

Responsive CSS Grid: cipalabs.com/projects/metal/
Blog: MODX Tutorials & Articles

372 Posts

bwente Reply #80, 16 years, 7 months ago

Quote from: bwente at Feb 28, 2010, 09:07 AM

Thanks TobyL! I added joins to my query.
SELECT m1.pagetitle, c1.color_name, s1.size_name, p1.inventory, p1.price FROM products AS p1 
INNER JOIN modx_site_content AS m1 ON p1.doc_id = m1.id 
INNER JOIN colors AS c1 ON p1.color_id = c1.id 
INNER JOIN sizes AS s1 ON p1.size_id = s1.id
But now when I go to edit a record the values do not appear for inventory and price. The others appear since I have queries for the select menus. When I add a new record those values do get recorded.

I just notice when I mouse over the links on the list page this is the url that I get.

http://localhost:8888/modx_dev/manager/index.php?a=112&id=3&db=3&rn=[+item_id+] so I added "p1.item_id" to my select statement. Now it works I get the correct URL and the data is the proper fields. How can I hide the "keyfield" when using a sql query?

Has anyone devised a way to the fields readonly on edit but a select on a new?

DropboxUploader -- Upload files to a Dropbox account.
DIG -- Dynamic Image Generator
gus -- Google URL Shortener
makeQR -- Uses google chart api to make QR codes.
MODxTweeter -- Update your twitter status on publish.