Thanks for your reply but the timeout setting didn't solve my problem.
I set the timeout for 120,000 milliseconds.  My query takes 64 seconds to run.

When the TreeGrid starts loading, the loadMsg text is displayed for 45 seconds and then it disappears.
How do I tell the TreeGrid control to wait longer?

I have a tree grid that I am trying to populate using the URL property.
The URL points to a PHP page which passes a directory name to a powershell script.
The powershell script:
- connects to a remote computer
- builds an object containing a recursive list of all files from the specified root directory
- processes the list by removing unwanted file names
- sorts, group and generates a JSON formatted list
- returns the list to the calling PHP which returns the list to the treegrid element

The majority of the directory names I pass to the above process take about 5-7 seconds to process, however there are 2 (out of a possible 24) directories which are very large and take 55-70 seconds to process.  I can see that the powershell script finishes successfully - but the treegrid does not get populated...so either PHP or the treegrid must be timing out and unwilling to wait for the full 60 seconds...

Is there any way to adjust the timeout so that the treegrid waits for the query to complete?

(Other suggestions for populating the treegrid more efficiently would also be welcome - but I'm very new to this and detailed examples or instructions would be extremely helpful.)

Thanks Stworthy,

Thanks for your reply with additional tips!

I found out that one of my main problems initially was that some of the values I was returning contained illegal characters that needed to be escaped.  Once I fixed that up, it started working as I expected it to.

The way I've been handling passing the data (so far) is to have the powershell script generate the output in json-like format (using an echo) and then having PHP simply pass it back to the HTML as-is:

Powershell:

Code:

  $infile = get-content c:\inis\myinputfile.ini
  $outfile = "["
  $count = 0
  $comma = ","
  $infile|foreach {
    $count = $count + 1
    $inline = ($_).split("=")
    $name=$inline[0];$value=($inline[1]).replace("\","\\")
    if ($infile.length -eq $count) {$comma = ""}
    $outfile = "$($outfile)`r`n{`"name`":`"$name`",`"value`":`"$value`",`"group`":`"$groupname`"}$comma"
  }
  $outfile = "$($outfile)]"
  $outfile|foreach {echo "$_`r`n"}

PHP:

Code:

<?php
  $username = $_SERVER["PHP_AUTH_USER"];
  $custname=$_GET["custname"];
  $propfile=$_GET["propfile"]; 
  $tmp = system("powershell -executionpolicy bypass d:/scripts/ps/supportkit.ps1 getproperties $username $custname $propfile",$err);
?>

Is there anything inherently wrong with this approach (besides the ugly-looking echo statement)?  Or some compelling reason to use the mechanism you provided instead of sticking with my current model?  (I'm much more comfortable working in Powershell than I am in PHP or JavaScript).

Thanks in advance for any advice you care to share!

I hope this is an easy question.

Is there a syntax that I can use to expand/collapse groups in a property grid by group name instead of group index?

Thanks in advance!

Please refer to this example http://www.jeasyui.com/demo/main/index.php?plugin=PropertyGrid&theme=default&dir=ltr&pitem=Basic.

Thanks for the reply stworthy.  Of course, I'd seen the demo and tried every possible variation of it I could think of - with and without the square brackets, trying to set the returned data into a javascript variable and then use the 'data' parameter to populate the property grid, etc and none of them worked.  The behavior I was consistently seeing was that if I saved the results to a file called returndata.json and then served up that file to the URL parameter, it would work - but if i set the url to returndata.php, it would fail - and when I opened the .php file in a browser directly and did a view source - the data displayed *exactly* matched the data in the .json file (right down to crlf characters and encoding).  I

However - since you took the time to reply to my question, I decided to humor you and rebuild my test using your example from the documentation so I could tell you exactly where it was failing...except this time it didn't fail....  ARGH!!!  I've spent a month on this problem and it turns out the documentation was right all along?  I'm guessing that in my earlier testing, there must have been a PHP error or info message that was invisibly getting in the way?

In any case - thanks very much for your reply and for setting me straight.  None of the examples actually showed how to generate the json data via code so I wasn't completely sure I was generating it in the correct format. I thought I might need one extra set (or one fewer set) of quotes, curly brackets or square brackets - or some special html tag to surround the data - but now that I've finally seen it work, I'll be able to move forward.  I was having a similar issue with several datagrid controls and I'm sure I will also be able to move forward with them now too!

Thanks again for taking the time to respond to such a simple question!

Hi All,

I'm new to jquery, php, easyui and html and I've been stumped on something I think should be pretty basic for a month now.

I'll try to make my problem as simple as possible.

I have an html document which contains a textbox, 2 buttons (load and refresh) and an empty div element.
A user is meant to enter a server name into the textbox and then click the button.

The load button should:
- run a function (ajax) which retrieves a list of services and the current status of each service.
- create a property grid populated with the service name/service status.

The refresh button should:
- re-run the query and update the data in the property grid

I have a powershell script on the web-server which can collect the required data.
I can have the powershell script return the data formatted in whatever way is required - but I need someone to tell me what format to use!

So far most of my testing has involved trying to generate the output from powershell in json format and using PHP to invoke the powershell script and return it to the html.
But no matter what I do, I can't get the PropertyGrid control to use it as a datasource.  I've tried using both the "url" and the "data" parameters with no luck.

So - can someone please help me?  How can I use PowerShell to generate the data I want to display in a PropertyGrid???

Thanks in advance to any that reply...

[want]

I am extremely new to EasyUI and to Web Development in general so forgive me if this question is obvious to most people.  I've been stuck on this issue for 2-3 weeks and am finally ready to admit I need help.

I am having problems populating datagrid and propertygrid's using the 'url:""' parameter.  My workaround until now was to use the 'data: propgrid' method instead of the url method. 
This of course requires me to create and populate the variable using PHP at page load time and that to refresh the data, I have to refresh the entire page. (very undesirable!)

I use a Powershell script on the back end which interfaces with a number of systems to collect the information I want to display.  The powershell script produces JSON-formatted output.

I want to be able to click a button on my page which creates the property grid and uses the URL property to invoke a .php script to invoke the powershell script to collect the data.

Code:

    function addpg() {
      $('#pg').propertygrid({
        url: 'propgrid.php?arg1=value1&arg2=value2',
        showGroup: true,
        scrollbarSize: 0
      });
    };

I've tried a million variations of this and for the life of me I can't get it to work when trying to generate the data 'live'.  It just fails silently.  If I mis-type the propgrid.php, i can see in the console.log that a 404 error is generated (so I know it is being called), but if everything is spelled correctly, I get no error - and also no data displayed.
This mechanism works fine if I change it to:

Code:

url: 'propgrid_data.json'

and I have the data stored in the above named file on my web-server - but NOT if I try to generate the data on-the-fly.

For sake of an example; One of the property grids is meant to display a list of Windows Services running on a remote server and the status of each (ie: Stopped, Running, StartPending, etc).
Powershell collects the information in an object, and I generate the output from that object with something like:

Code:

$comma=",`r`n"
$outfile="[`r`n"
$infile|foreach {
  $name = $infile.name;$value=$infile.value;$group=$infile.group
  $outfile = "$outfile`r`n{`"name`":`"$name`",`"value`":`"$value`",`"group`":`"$group`"}$comma"
}
$outfile = "$outfile`r`n]"

(There is also logic in the loop to determine it is the last record and set the value of $comma to blank)

After many failures, I added a line after the loop to save a copy of my output to disk:

Code:

$outfile|set-content "C:\Apache24\htdocs\testing\propgrid_data.json"

The content of the .json file is identical to the results returned by the PHP page however;
- the grid is populated correctly if I set url to look directly to the .json file, but
- the grid does NOT get populated if I set it to use the .php file

I've verified that the lines end with crlf in both the web-page and the file.
I've tried adding the <html> and <body> tags to the html output and I've tried just generating the raw output with no html elements.
I've confirmed that the encoding of the file and the web-page output are both UTF-8.

Here is a sample of how my .json file looks and also how the output from invoking the .php file looks.  If I retrieve both via the web-browser and choose 'View Source', the results are identical.

Code:

[
{"status":"Running","servicename":"Service1"},
{"status":"Running","servicename":"Service2"},
{"status":"Stopped","servicename":"Service3"},
{"status":"Running","servicename":"Service4"}
]

I just don't get it.  What do I need to do to make the property grid control accept and display the output from a .PHP page???

Please help!